Workflow Templates

This workflow provides a comprehensive weather reporting system with two main functionalities: a scheduled daily summary and an interactive AI agent for dynamic queries. Who's it for? This template is ideal for anyone who wants to stay updated on the weather, from individuals planning their day to teams needing automated daily briefings. It's also a great example for developers and n8n users who want to explore the capabilities of AI Agents and integrating external APIs in their workflows. What it does / How it works This workflow operates in two distinct modes: Scheduled Daily Summary: The workflow triggers automatically every day at 9:00 AM (customizable) or can be run manually. It fetches the latest weather data for a specified location (default is near Chiba, Japan) from the Open-Meteo API. It then formats a message with the day's maximum and minimum temperatures. Finally, it sends this summary to a designated Gmail address and a Slack channel. AI-Powered Forecasts via Chat: When you send a message to the Chat Trigger webhook, it activates the AI Agent. The AI Agent, powered by an OpenAI model, understands natural language questions like "What's the humidity right now?" or "Will it be warmer tomorrow?". The agent uses an HTTP Request tool to fetch real-time, specific data from the weather API to answer your question. The generated answer is then sent back to you via both Gmail and Slack. How to set up Configure Credentials: Add your credentials for OpenAI, Gmail, and Slack in the credentials menu. Set Your Location: In the Fetch Weather Data and HTTP Request Tool for AI nodes, update the latitude and longitude in the URL to your desired location. Update Email and Slack: In the Send Email Summary and Send AI Response via Email nodes, change the recipient email address to your own. In the Send Slack Summary and Send AI Response via Slack nodes, select your desired Slack channel. Adjust the Schedule: Modify the Schedule Trigger node to change the time or frequency of the daily summary. Activate the Workflow: Click the "Active" toggle in the top-right corner to enable the workflow. How to customize the workflow Change the Message:** You can easily customize the notification message in the Format Daily Summary node (for the summary) and in the Send... nodes for both flows. Add More Data:** The Open-Meteo API provides a wealth of data. You can fetch additional information like precipitation, wind speed, or UV index by modifying the URL in the HTTP Request nodes. Integrate Other Services:** Add other notification nodes like Discord, Telegram, or Microsoft Teams to send the weather reports to more platforms.

Overview This workflow auto-generates a personalized research report on any prospect who books a call with you—using their LinkedIn profile and advanced web research. When a call is booked in your calendar, the system looks up the lead’s LinkedIn URL from a Google Sheets database. That profile is then scraped using Relevance AI to extract posts, experiences, and education. It also runs a deep-dive query on the person using Perplexity to uncover relevant news, insights, and context. This structured data is passed to an AI model that produces a clean profile summary, suggested pain points, and solution ideas. Finally, the system builds and sends you a fully formatted HTML report via email—ready to review before your meeting. Who’s it for Founders taking high-stakes sales calls SDRs/BDRs booking back-to-back meetings Agencies and consultants who want to personalize discovery calls Teams doing high-touch enterprise sales or B2B outreach How it works Triggered when a new call is booked via Cal.com Finds matching LinkedIn URL from a local database (Google Sheets) Scrapes public LinkedIn data via Relevance AI Runs a Perplexity query on the prospect for deeper context Formats the scraped data using Code nodes Sends structured info to AI to generate: A company + person profile Suggested pain points and solutions Formats everything into a clean HTML report Emails you the final summary to prep for the call Example use case > Someone books a call. You receive a report 2 minutes later in your inbox with: > - Their role, company, and latest posts > - What their business does > - Recent news and context from Perplexity > - Predicted pain points and how you might help > > You show up to the call prepped and ready How to set up Connect your Cal.com trigger (or replace with any booking tool) Set up your Google Sheet(s) with contact info + LinkedIn profiles Add Relevance AI API key and configure LinkedIn scraping (they have free credits) Link Perplexity API for web research Customize the AI prompts and report formatting Connect Gmail or preferred email provider to send reports Requirements Cal.com or other booking platform Google Sheets for lead storage Relevance AI account and API access Perplexity API key OpenAI or similar LLM for summarization Email integration (e.g. Gmail) How to customize Replace Cal.com with Calendly, SavvyCal, etc. Change AI prompt tone and structure of the report Add CRM push (e.g. log into HubSpot, Notion, or Airtable) Add Slack or Telegram notifications for call alerts Format reports as PDF instead of HTML for download

🚀 How it works Runs daily at 06:00 UTC, pulls every Shopify product variant's stock level, calculates real sales velocity from the last 7 days of orders, then uses GPT-4o to predict stockout dates and decide whether to reorder — automatically. 🛍️ Fetches all Shopify product variants and current inventory quantities 📦 Pulls the last 7 days of orders and computes units sold per variant ⚡ Calculates sales velocity (units/day) and estimated days until stockout 🤖 AI Agent classifies risk: critical / high / medium / low and recommends reorder quantity (30-day demand + 20% safety buffer) 📧 Sends a formatted reorder request email to your supplier for high-risk variants 📊 Logs every decision (reordered or skipped) to Google Sheets for inventory tracking 🛠️ Set up steps Estimated setup time: ~15 minutes Shopify — create a Custom App in your Shopify Admin → Apps → Develop Apps; enable read_products and read_orders scopes; copy the Admin API Access Token OpenAI — connect your OpenAI API credential (GPT-4o) Gmail — connect Gmail OAuth2; replace supplier@example.com with your real supplier address Google Sheets — connect Google Sheets OAuth2; replace YOUR_REORDER_LOG_SHEET_ID with your sheet ID; create a sheet tab named Reorder Log Follow the sticky notes inside the workflow for per-node guidance 📋 Prerequisites Shopify store (any plan with Admin API access) OpenAI API key Gmail account for supplier notifications Google Sheets for reorder log Custom Workflow Request with Personal Dashboard kumar@smartflowcraft.com https://www.smartflowcraft.com/contact More free templates https://www.smartflowcraft.com/n8n-templates

Good to know: The workflow runs every hour with a randomized delay of 5–20 minutes to help distribute load. It records the exact date and time a lead is emailed so you can track outreach. Follow-ups are automatically scheduled two days after the initial email. How it works: After apify completes, the JSON data is retrieved and inserted into the proper JSON node (only the JSON is removed — nothing else). The agent then runs on its own, parsing the data and pushing it to Google Sheets. When a lead is emailed, the system tags it with the date and time for tracking. Two days later the workflow automatically triggers a follow-up, again on an hourly schedule with the same time delay. How to use: Start by connecting your apify account to retrieve data. Place the returned JSON into the designated JSON node. Configure your Google Sheet where the data will be stored. Adjust the time delay window or follow-up period if needed. Insert your email credentials and the message. Requirements: Apify account with active leads/data. Google Sheet for storing and managing parsed lead information. n8n credentials configured for your accounts. email credentials Customising this workflow: You can easily extend this template to include other CRMs, different time delays, or additional notification steps. For example, push new leads to Slack, send SMS notifications, or trigger downstream analytics dashboards automatically.

Description Automatically convert any video URL into a fully structured, publish-ready SEO blog post using WayinVideo AI transcription, GPT-4o-mini, and Google Sheets — zero manual writing required. What This Workflow Does This workflow takes a single video URL and does everything for you. It transcribes the video using WayinVideo — a powerful multilingual video transcription API that accurately converts spoken content into clean, structured text — then passes that transcript to an AI Agent that writes a complete SEO blog post with title, meta description, slug, sections, FAQs, key takeaways, and tags. The final output is saved directly as a draft row in Google Sheets, ready for review and publishing. Perfect for content marketers, YouTubers, agencies, and SEO teams who want to repurpose video content at scale without touching a keyboard. Key Features AI-powered transcription via Wayin: Uses the WayinVideo API to transcribe any video URL into clean, timestamped text segments with word count and duration metadata — supporting multilingual content. Smart polling loop: Automatically polls Wayin every 5 seconds until transcription is complete — no manual waiting or webhook setup needed. Structured SEO output: GPT-4o-mini generates a complete blog post with H2 sections (300+ words each), meta description (155 chars), URL slug, focus keyword, secondary keywords, FAQs, and a CTA conclusion. Strict JSON schema enforcement: A Structured Output Parser validates every AI response — no broken outputs, no missing fields. Google Sheets auto-logging: Every blog post is instantly saved as a draft row with date, video URL, word count, read time, tags, and status. Webhook-triggered: Works as part of any larger pipeline — trigger it from Make, Zapier, or your own frontend. How It Works Receive Video URL — Webhook accepts a POST request with {"url": "your-video-link"} Submit Transcription — Wayin — Sends the video URL to WayinVideo API to start English transcription job Poll Transcription Status — Fetches job status using the transcription ID every 5 seconds Wait 5 Seconds — Pauses execution between each poll attempt to avoid rate limits Is Transcription Complete? — IF status = SUCCEEDED → move forward, ELSE → re-poll Process Transcript Data — Joins all text segments, calculates word count and video duration Generate SEO Blog Post — AI Agent (GPT-4o-mini) writes the full structured blog post Parse Blog JSON Output — Enforces strict JSON schema and auto-fixes any format issues Save to Google Sheets — Appends all blog fields as a new draft row Return Success Response — Sends confirmation back to the webhook caller Setup Requirements Tools you'll need: Active n8n instance (self-hosted or n8n Cloud) WayinVideo account + API key (for video transcription) OpenAI API key (GPT-4o-mini for blog generation) Google Sheets with OAuth access (for draft storage) Estimated setup time: 10–15 minutes Configuration Steps 1. Add credentials in n8n: OpenAI API key Google Sheets OAuth API 2. Add your WayinVideo API Key: Open Submit Transcription — Wayin node → replace YOUR_WAYIN_API_KEY in the Authorization header Open Poll Transcription Status node → replace YOUR_WAYIN_API_KEY in the Authorization header 3. Set up your Google Sheet: Create a sheet with these exact column headers: Date | Video URL | SEO Title | Slug | Focus Keyword | Meta Description | Secondary Keywords | Read Time | Tags | Word Count | Duration (min) | Status 4. Update Sheet Document ID: Open Save to Google Sheets node Replace YOUR_GOOGLE_SHEET_DOCUMENT_ID with your actual Sheet ID (found in the Google Sheet URL) 5. Test the workflow: Activate the workflow Send a POST request to your webhook URL: POST https://your-n8n-domain/webhook/43129e0a-... Body: {"url": "https://youtube.com/watch?v=example"} Check your Google Sheet for the new draft row Use Cases Content marketers: Repurpose every YouTube video, webinar, or podcast episode into an SEO blog post automatically — 10x your content output without extra writing. SEO agencies: Generate first-draft blog posts for clients from recorded calls, demos, or training videos in minutes. Course creators: Turn every lesson or tutorial video into a standalone blog post to drive organic search traffic. YouTubers & podcasters: Build a content library of written posts from existing video content with zero extra effort. Customization Options Change the AI model: Replace gpt-4o-mini with gpt-4o or gpt-4-turbo in both OpenAI nodes for higher quality output on complex topics. Add WordPress publishing: Connect a WordPress REST API node after Save to Google Sheets to auto-publish instead of saving as draft. Change output language: Modify the WayinVideo API target_lang parameter and GPT system prompt to generate blog posts in any language. Adjust blog structure: Edit the system prompt in Generate SEO Blog Post to change section count, word targets, tone, or add custom fields like author bio or schema markup. Add Slack/email notifications: Insert a Slack or Gmail node after Return Success Response to notify your team when a new draft is ready. Troubleshooting Transcription stuck in polling loop: Check your WayinVideo API key is valid and the video URL is publicly accessible. Private or age-restricted videos may fail. AI output missing fields: The Structured Output Parser auto-fixes most issues. If errors persist, add explicit field instructions to the GPT system prompt. Google Sheets not updating: Verify OAuth credentials are connected and the Sheet Document ID is correct (not the full URL, just the ID string between /d/ and /edit). Webhook not triggering: Make sure the workflow is activated (toggle ON) before sending test requests. Test mode webhooks use a different URL than production. Resources WayinVideo — Transcription API n8n Documentation OpenAI API Reference Google Sheets API Support Need help setting up or want a custom version built for your use case? 📧 Email: info@isawow.com 🌐 Website: https://isawow.com/

This n8n template demonstrates how to use AI to fully automate the generation and scheduling of X (formerly Twitter) content based on a specific, predefined persona. Use cases are many: It's perfect for social media marketers looking to streamline content creation, individual experts building a consistent brand voice, or businesses aiming to drive traffic to specific services with a steady stream of relevant content. Good to know The AI model used in this workflow (via OpenRouter) requires an API key and will incur costs based on usage (typically a few cents per generation). The Blotato node used for posting is a third-party community node and requires a separate Blotato account. How it works This workflow is divided into two main processes: Content Generation and Content Posting. Content Generation Process: A Schedule Trigger kicks off the workflow every 4 hours. An AI Agent (LangChain) generates a post based on a detailed prompt defining a persona, purpose, and rules. A Code node refines the AI's output, ensuring the text ends naturally. The generated post is then saved to a Google Sheet with a "Not Posted" status, creating a content queue. Content Posting Process: The workflow retrieves one "Not Posted" item from the Google Sheet. An IF node checks the post's category to determine if an image is required. If an image is needed, it searches for and retrieves a matching image file from a specified Google Drive folder. The Blotato node posts the text (and image, if applicable) to the designated X (Twitter) account. A confirmation email is sent via Gmail to notify stakeholders of the successful post. Finally, the Google Sheet status is updated to "Completed" to prevent duplicate posts. How to use You can test the workflow anytime using the manual trigger. For production, adjust the posting frequency in the "Trigger: Every 4 Hours" node. The quality of the generated content is determined by the prompt. Edit the system message within the "AI: Generate X Post Content" node to customize the persona, purpose, tone of voice, etc. To generate posts with images, you must upload image files to the specified Google Drive folder. The filename must exactly match the post's category name (e.g., Evidence-based_Graph.png). Requirements An OpenRouter account (or another AI service account) for the LLM. A Blotato account for social media posting. A Google account for content management, image storage, and notifications (Sheets, Drive, Gmail). Customising this workflow Expand the workflow to post to other social media platforms supported by Blotato, such as Facebook or LinkedIn. Instead of posting immediately, add a human-in-the-loop approval step by sending the AI-generated draft to Slack or email for review before publishing. Replace the Schedule Trigger with a Webhook Trigger to generate and post relevant content based on external events, such as "when a new blog post is published."

SmartSupport Flow: Auto-Handle IT Requests from Email to JIRA with Slack notification Watch the demo video below: Who’s it for > This workflow is built for lean IT teams, office managers, and business operators who receive support requests via email and want to automate ticket creation, smart AI resolution advice, and seamless communication with both users and internal teams, all without lifting a finger. If your team is tired of manually triaging inbox requests, this AI-powered flow will transform your support handling process. How it works / What it does Trigger on New Email: Uses Gmail Trigger to detect new support request emails. Fetch Email Content: Retrieves the full message body and metadata. Check for Duplication: Skips processing if the email has already been handled (based on READ/UNREAD label). Mark as Read: Updates Gmail to mark the email as processed. Extract Structured Request: Uses the Support Request Reader Agent powered by OpenAI to extract: Request title Request description Requested by Department Category and priority Create Jira Ticket: A main issue is created in Jira using the structured request. Generate AI-Based Solution: Invokes the IT Support Advisor Agent to propose resolution(s). Post Comment to Jira: Adds the suggested solution(s) to the issue as a comment. Notify IT Team: Sends the ticket and context to a Slack channel for visibility and action. (Optional) Send Email to Requester: Currently deactivated. Can be enabled to acknowledge receipt. How to set up Gmail Integration Connect Gmail in the “Gmail Trigger” and “Get Email Content” nodes. OpenAI Configuration Use OpenAI API credentials in both the Reader and Advisor agent models. Jira Integration Authenticate your Jira account. Set project key and issue fields in the “Create Main Issue” node. Slack Notification Configure Slack connection and select a target channel. Set up Jira, Slack, Email Set your company Jira based URL, IT Support slack channel and IT Support email in the Edit Fields (Set) node (Optional) Email Acknowledgment Provide SendGrid credentials and email template in the “Send email to requester” node if re-enabled. Requirements Gmail API access with appropriate permissions OpenAI account with API access (for GPT-4 or GPT-3.5) Jira instance with project and permission to create/comment on issues Slack workspace and Webhook or OAuth setup n8n instance running with all above integrations configured How to customize the workflow Enhance Email Deduplication**: Adjust the deduplication logic to use message-id, threadId, or custom headers. Expand Reader Agent**: Configure the LLM to extract more details such as asset tags, urgency levels, or locations. Tailor Advisor Agent**: Adjust prompt to generate multiple solutions, troubleshooting guides, or internal references. Routing by Department**: Add logic to forward requests to different teams based on the request category or department. Enable Email Acknowledgment**: Activate and customize the email notification step to inform requesters that their issue is being handled.

Automated SEO Health Monitoring & Reporting This workflow automatically monitors the SEO health of websites stored in a Google Sheet. It fetches each website’s HTML, analyzes key SEO metrics (title, meta description, H1 count, canonical, robots, performance score, etc.) and updates results back into Google Sheets. If performance is poor (<50), it sends an alert email. For healthy sites, it generates a detailed PDF report and stores it in Google Drive. Who’s it for Digital marketing teams SEO agencies Website administrators who want automated SEO health checks Businesses with multiple websites or landing pages to monitor How it works Daily Trigger – Runs every day at 9 AM. Fetch Website List – Reads website URLs from Google Sheets. Crawl Websites – Uses HTTP requests to fetch each website’s HTML. SEO Analysis – Extracts SEO-related metadata (title, meta description, H1, etc.). Health Check – Scores SEO performance based on predefined rules. Decision Node – If score < 50 → Send alert email; else → Generate full SEO report. Update Logs – Logs results back into Google Sheets. Generate PDF Reports – Converts HTML reports into PDFs via PDF.co API. Save to Drive – Stores the PDF reports in Google Drive for long-term access. How to set up Open n8n and import the workflow. Configure your Google Sheets credentials and specify the sheet containing your website URLs. Add your Gmail account to allow automated alert emails. Set up your Google Drive credentials for storing PDF reports. Obtain an API key from PDF.co and configure the HTTP Request node. Adjust the Schedule Trigger to the time that works best (default: 9 AM daily). Test the workflow with a sample domain list. Requirements n8n instance (self-hosted or cloud) Google Sheets account (to store website URLs and logs) Gmail account (for sending alerts) Google Drive account (to save SEO reports) PDF.co API Key (for HTML → PDF conversion) How to customize Change performance threshold**: Modify the IF node condition (default <50). Custom SEO rules**: Edit the “SEO Health Check” Function node to add/remove checks (e.g., missing schema tags, page load times). Different output storage**: Replace Google Drive with Dropbox, S3 or OneDrive. Alternate notification channels**: Swap Gmail with Slack, Microsoft Teams or Telegram. Add-ons Send Slack/Teams notifications for low scores. Add PageSpeed Insights API for performance scoring. Generate weekly summary reports per domain. Integrate with Notion/Confluence to log SEO health history. Use Case Examples An SEO agency monitors 100+ client websites daily and sends alerts when a site has poor SEO signals. A company’s marketing manager gets a daily SEO health PDF report stored in Drive. A SaaS product team automatically logs performance changes for each release. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------------------ | ------------------------------------------------ | --------------------------------------------------------------------------- | | Workflow fails at HTTP Crawl | Website blocks requests / timeout | Increase timeout in Set Config node or add retry logic. | | Always returns https://example.com | Missing canonical / OG tags in HTML | Enhanced code now infers from JSON-LD or domain detection. Update analyzer. | | PDF not generated | Invalid API key or wrong endpoint in PDF.co node | Verify PDF.co API key and endpoint URL. | | Email not sending | Gmail credentials not set or blocked | Reconnect Gmail in n8n credentials manager. | | Google Sheet not updating | Wrong column mapping in Update Sheet node | Check node mapping: domain column vs performance/date columns. | | Google Drive upload fails | Missing folder permissions | Ensure correct Drive folder ID and credentials. | Need Help? If you’d like assistance setting up, customizing or scaling this workflow for your use case, our n8n automation team at WeblineIndia can help you: Tailor SEO rules for your industry. Connect to additional APIs (Ahrefs, Semrush, PageSpeed). Automate weekly/monthly reporting with summary dashboards.

What it does Customer support calls contain a wealth of valuable feedback and urgent issues, but manually reviewing audio files is inefficient. This workflow acts as an AI assistant for your call log, transforming unstructured audio recordings into structured, actionable data. It provides a clean summary, sentiment analysis, and a list of required actions for every call, eliminating the need for manual listening and ensuring key insights are never missed. How it works The workflow runs on a schedule to fully automate the call analysis process from start to finish. Fetch New Recordings: The workflow triggers on a schedule (e.g., every 5 minutes), searches a designated Google Drive folder for new call recordings, and downloads any new files it finds. Transcribe Audio: Each audio file is sent to the ElevenLabs API to be converted from speech to a text transcript. The result is then formatted into a conversational, multi-speaker format. AI-Powered Analysis: The transcript is passed to a Google Gemini node, which is prompted to return a structured JSON object. This JSON contains a complete analysis of the call, including speaker identification (agent_name, client_name), a summary, the client_sentiment, a call_topic, a department_tag, and a list of action_items. Log the Results: The complete, structured analysis output from Gemini is appended as a new row in a Google Sheet, creating a centralized log with all the extracted call details and the full transcript. Take Action: The workflow uses conditional logic based on the detected sentiment: Negative Sentiment: If a call was negative, an immediate alert containing the call summary and action items is sent to a manager's group on Telegram. Positive Sentiment: If a call was positive, a kudos message is sent to the support team's Telegram channel to celebrate good work. File Management: After processing, the original audio file is automatically moved to a separate "Processed" folder in Google Drive to ensure it isn’t analyzed again. Setup Instructions To configure this workflow, you will need to set up your file storage in Google Drive, create a Google Sheet for logging, and configure credentials for all connected services. Required Credentials Google: You will need Google OAuth2 credentials that have permission for Google Drive, Google Sheets, and the Google AI (Gemini) APIs. ElevenLabs: Sign up for an account at ElevenLabs and get your API Key. You will add this directly into the HTTP Request node for transcription. Telegram: Create a bot using the BotFather in Telegram to get your Bot Token. You will also need the specific Chat ID for the managers' channel and the team's channel. Step-by-Step Configuration Google Drive: Create two folders in your Google Drive: one named "Company - Support Call Recordings" and another named "Processed Recordings". Copy the unique Folder ID from the URL for each and paste it into the respective Google Drive nodes. Google Sheets: Create a new Google Sheet to log the results. In the first row, create the following headers exactly as written: Recording File, Sentiment, Department, Topic, Agent, Client, Summary, Actions, and Fulltext. Copy the Sheet ID from the URL and paste it into the "Log Recording Analysis" (Google Sheets) node. ElevenLabs Node: In the "Convert Speech To Text" (HTTP Request) node, make sure the URL is set to the correct ElevenLabs API endpoint for speech-to-text. Add your ElevenLabs API Key to the authentication header. Telegram Nodes: In the "Send Alert To Managers" node, enter the Chat ID for your managers' group. In the "Send Kudos to Team" node, enter the Chat ID for the main team channel. How to Adapt the Template This workflow is a powerful starting point. Based on your specific needs, you can customize the inputs, the AI analysis, the logging method, and the final actions. Input Method Change File Source:* Instead of Google Drive, you can adapt the workflow to fetch recordings from other services like *Dropbox, **OneDrive, or a custom FTP server. Use a Webhook:* Replace the *Schedule Trigger* with a *Webhook Trigger** to process calls in real-time as they are added from your call software (if it supports webhooks). Final Actions Create Service Tickets:* This is a key area for customization. Replace the *Telegram* nodes with nodes for ticketing systems. For a negative call, you can automatically create a high-priority ticket in *Jira, **Zendesk, or ServiceNow. Create Tasks:* For calls with specific action items, use a node like *Asana, **Trello, or Todoist to automatically create a task and assign it to the correct team member. Send Email Notifications:* Use the *Send Email** node to dispatch summaries and alerts to stakeholders who are not on Telegram. Logging and Analysis Log to a Database:* Instead of Google Sheets, you can use a *Postgres, **MySQL, or Data Warehouse node to log the structured data for more advanced business intelligence and dashboarding. Customize the AI Prompt:** The prompt in the Google Gemini node is the "brain" of the operation. It specifically instructs the AI to return a JSON object with a predefined structure. To change what data is extracted, you can modify this structure in the prompt. For example, you could add a new key-value pair like "competitor_mentioned": "Name of competitor if mentioned, otherwise null" to the JSON structure. The current workflow asks the AI to populate a JSON object like this: { "speaker_identification": { "agent": "speaker_id", "agent_name": "The agent's name", "client": "client_id", "client_name": "The client's name" }, "summary": "A concise summary.", "client_sentiment": "Positive, Negative, or Neutral", "call_topic": "A brief phrase for the topic.", "department_tag": "The most relevant department.", "action_items": [ "A list of actionable tasks." ] } Change AI or STT Service:* You can swap out the *Google Gemini* node for an *OpenAI* node, or change the *HTTP Request* node to use a different transcription service like *AssemblyAI* or *Deepgram**.

This workflow scrapes Google Maps via Decodo API, analyzes each business using Google Gemini 2.5 Flash, scores lead quality, and generates ready to send outreach emails. Why Use This Workflow? Time Savings:** Reduces manual lead research from 20 minutes per lead to 30 seconds processing 100 leads in under an hour Cost Reduction:** Eliminates $300-500/month spent on lead databases and enrichment tools like Apollo or ZoomInfo Scalability:** Process 500+ leads daily without additional staff or subscription costs Ideal For Sales Teams & BDRs:** Building targeted prospect lists for local businesses (restaurants, retail, service providers) with verified contact data and personalized outreach hooks Digital Marketing Agencies:** Identifying high-value clients in specific niches (e.g., "restaurants without websites in Chicago") and automating first-touch campaigns B2B SaaS Companies:** Finding businesses matching ideal customer profiles based on ratings, reviews, and digital maturity indicators Local Service Providers:** Generating qualified leads for web design, SEO, POS systems, or booking software tailored to underserved markets How It Works Trigger: Manually start the workflow or schedule it to run on specific intervals (e.g., daily/weekly) Data Collection: Scrapes Google Maps search results using Decodo API based on your query (e.g., "coffee shops in Austin"), country, and language settings Processing: Parses raw HTML responses into structured lead objects with business name, address, phone, website, ratings, reviews, and coordinates Intelligence Layer: Google Gemini 2.5 Flash analyzes each lead to generate value propositions, identify pain points, create outreach hooks, and assign a 1-10 quality score Output & Delivery: Filters leads scoring ≥7, generates personalized email templates, and saves all data to Google Sheets with enrichment timestamps Storage & Logging: Maintains complete lead database with outreach status tracking; error handler sends Telegram notifications for failed executions Setup Guide Prerequisites | Requirement | Type | Purpose | |-------------|------|---------| | n8n instance | Essential | Workflow execution platform | | Decodo Scraper API | Essential | Google Maps data extraction (get key at dashboard.decodo.com) | | Google Gemini API | Essential | AI-powered lead analysis and scoring | | Google Sheets | Essential | Lead database and outreach tracking | | Telegram Bot (optional) | Optional | Real-time error notifications | Installation Steps Import the JSON file to your n8n instance Configure credentials: Decodo API: Create HTTP Header Auth credential with header name Authorization and value Basic [YOUR_API_KEY] get from Decodo dashboard Google Gemini API: Add your Google AI API key in the "2.5 Flash" node credentials Google Sheets OAuth2: Authenticate with your Google account (both "Save to Google Sheets" and "Save Outreach To Sheets" nodes) Telegram (optional): Add bot token and replace YOUR-CHAT-ID in "Send Error Notification" node Update environment-specific values: In "Set Search Parameters" node: Update searchQuery (e.g., "Italian restaurants in Miami"), country, targetLanguage, and resultsLimit In both Google Sheets nodes: Select your destination spreadsheet and sheet name Customize settings: Adjust lead score threshold in "Filter Hot Leads" (default: ≥7) Modify AI prompt in "Lead Enrichment" node to match your value proposition Customize outreach email template in "Prepare Outreach Message" node Test execution: Start with resultsLimit: 5 to verify all connections work Check Google Sheets for properly formatted data Verify AI enrichment produces actionable insights Technical Details Core Nodes | Node | Purpose | Key Configuration | |------|---------|-------------------| | Decodo Maps Scraper | Fetches Google Maps listings via API | Set target: google_maps, adjust page_to based on resultsLimit | | Parse & Normalize Data | Extracts business data from HTML | Custom JavaScript handles multiple response formats | | Lead Enrichment (AI Chain) | Analyzes leads with Gemini 2.5 Flash | Structured output parser ensures JSON compliance | | Filter Hot Leads | Isolates high-quality prospects | Combines lead score ≥7 + contact info validation | | Save to Google Sheets | Stores all enriched leads | Uses appendOrUpdate with id as matching column | | Save Outreach To Sheets | Updates hot leads with messages | Marks leads as "HOT" category for prioritization | Customization Options Basic Adjustments Search Parameters:** Modify searchQuery, country, targetLanguage in "Set Search Parameters" to target different markets (supports all Google Maps locales) Lead Scoring Threshold:** Change filter condition from ≥7 to ≥6 for broader lead pool or ≥8 for ultra-qualified prospects Batch Size:** Adjust "Split Into Batches" to process 10-50 items per cycle (lower = more reliable, higher = faster execution) Advanced Enhancements Email Automation:** Connect "Prepare Outreach Message" to Gmail/SendGrid nodes for automatic campaign sends (medium complexity) CRM Integration:** Add HubSpot/Salesforce nodes after enrichment to sync leads directly (requires CRM API credentials) Multi-Channel Outreach:** Branch hot leads to LinkedIn automation tools or SMS providers (high complexity, needs additional services) Custom Scoring Models:** Modify AI prompt to prioritize industry-specific signals (e.g., verified badges for healthcare, delivery options for restaurants) Troubleshooting Common Issues | Problem | Cause | Solution | |---------|-------|----------| | "No valid leads extracted" error | Decodo response format changed or empty results | Check Decodo API response in "Parse & Normalize Data" execution logs; verify search query returns results in Google Maps manually | | AI enrichment produces invalid JSON | Gemini output doesn't match schema | Review "Result Parser" schema; add retry logic or simplify AI prompt to reduce complexity | | Google Sheets "matching column not found" | Spreadsheet missing "id" column header | Ensure Sheet1 has headers: id, businessName, category, address, phone, website, rating, reviewCount, valueProposition, painPoints, outreachHook, leadScore, engagementStrategy, googleMapsUrl, scrapedAt, enrichedAt, outreachMessage, status | | Timeout on large batches | Processing 100+ leads exceeds execution limits | Reduce resultsLimit to 25-50; run workflow multiple times with different queries | Use Case Examples Scenario 1: Digital Marketing Agency Prospecting Challenge: Agency needs 200 qualified restaurant leads monthly for web design services, spending 40 hours on manual research Solution: Configure workflow with query "restaurants in [city]" filtered by ratings ≥4.0 and missing professional websites (AI scoring detects this) Result: Generated 312 leads in 8 hours across 3 cities; 89 scored ≥8 (hot prospects); closed 14 clients in first month at $2,500 average contract value Scenario 2: SaaS Company Market Entry Challenge: Booking software startup targeting salons/spas in new geographic market with zero existing contacts Solution: Ran workflow with "beauty salons in Denver" + "day spas in Denver"; AI identified pain points like "manual appointment booking" and "no online presence" Result: 156 leads enriched in 2 days; personalized outreach hooks increased demo booking rate from 2% (cold template) to 11%; secured 8 pilot customers in 3 weeks Scenario 3: Local Service Provider Lead Generation Challenge: POS system reseller needs to identify retail stores still using cash registers, wasting days driving to scout locations Solution: Configured workflow for "retail stores in [neighborhood]" with AI analyzing reviews for mentions of "cash only" or payment friction Result: Identified 47 high-probability prospects in 90 minutes; field sales team prioritized top 15 leads (score ≥9), closed 6 deals worth $32K total revenue Credits & Links Created by: Khaisa Studio Category: Sales & CRM | Tags: lead-generation, google-maps, ai-enrichment, sales-automation, prospecting Need custom workflows? Contact us Connect with the creator: Portfolio • Workflows • LinkedIn • Medium • Threads

Jotform Lead Qualification & Distribution System Transform lead chaos into systematic qualification and instant routing - achieving 5-minute response times, 300% conversion increase, and eliminating sales team conflicts through AI-powered BANT scoring and intelligent territory assignment. What This Workflow Does Revolutionizes lead management with AI-driven qualification and automated distribution to the right sales rep: 📝 Intelligent Lead Capture - Jotform collects complete lead profile including budget, timeline, and pain points 🤖 AI BANT Scoring - GPT-4 evaluates leads across Budget, Authority, Need, Timeline (0-100 score) 🎯 Smart Routing - Automatically assigns leads based on score, territory, industry expertise, and workload 💼 Instant CRM Creation - Creates detailed contact records in HubSpot/Salesforce with full context 📧 Dual Notifications - Sales rep gets detailed brief, lead receives professional confirmation 📊 Complete Tracking - Google Sheets logging enables performance analysis and conversion metrics 🔥 Priority Tiering - Hot leads (75+) go to senior reps, warm to mid-level, cold to SDRs 💡 Pre-Written Talking Points - AI provides conversation starters based on lead pain points 🚀 Zero Manual Work - End-to-end automation from form submission to first contact Key Features AI Lead Qualification Engine: GPT-4 analyzes every lead using BANT framework with 25-point scoring per category (Budget, Authority, Need, Timeline) Intelligent Territory Routing: Matches leads to sales reps based on geography, industry expertise, deal size capacity, and current workload Real-Time CRM Integration: Creates fully populated contact records in HubSpot, Salesforce, or Pipedrive with AI insights Instant Rep Notifications: Beautiful HTML emails with complete lead profile, BANT breakdown, talking points, and recommended next steps Lead Confirmation Emails: Professional auto-responses set expectations and introduce assigned account executive Conversion Probability Scoring: AI estimates likelihood of close based on BANT signals and pain severity Deal Value Estimation: Automatically calculates potential deal size based on company size and budget range Red Flag Detection: AI identifies concerns (budget constraints, wrong decision-maker, competitor lock-in) Competitor Vulnerability Assessment: Evaluates how easily lead can switch from current solution Opportunity Size Classification: Tags leads as Small/Medium/Large/Enterprise for proper resource allocation 24-Hour SLA Monitoring: Hourly checks identify uncontacted leads and escalate to sales management Complete Audit Trail: Every lead logged to Google Sheets with timestamps, scores, and assignments for analytics Perfect For B2B SaaS Companies: Fast-growing software companies with high lead volume (100+ leads/month) Technology Services: IT consulting, MSPs, and technology solution providers Enterprise Sales Teams: Organizations with complex products requiring senior rep expertise Professional Services: Law firms, accounting firms, consulting practices with territory-based teams Manufacturing: Industrial equipment sales with industry-specific expertise requirements Healthcare Tech: Medical software and equipment sales with compliance considerations Financial Services: Wealth management, insurance, and fintech with regulatory requirements Marketing Agencies: Digital marketing and advertising agencies qualifying client prospects What You'll Need Required Integrations Jotform - Lead capture form (free tier works) Create your form for free on Jotform using this link OpenAI API - GPT-4 for AI BANT scoring (~$0.20-0.40 per lead) Gmail - Automated notifications to sales reps and leads Google Sheets - Lead tracking database and analytics CRM System - HubSpot, Salesforce, or Pipedrive (via API) Optional Integrations Slack - Real-time lead notifications to sales channel Calendar Integration - Auto-schedule follow-up calls Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 required for best BANT analysis) Create Jotform Lead Capture Form: Company Name (q3_companyName) Contact Name (q4_contactName) Email (q5_email) Phone (q6_phone) Company Size (q7_companySize) - dropdown: 1-10, 11-50, 51-200, 201-500, 500+ Budget Range (q8_budgetRange) - dropdown: <$10K, $10K-$25K, $25K-$50K, $50K-$100K, $100K+ Timeline (q9_timeline) - dropdown: Immediate, 1-3 months, 3-6 months, 6+ months Industry (q10_industry) - dropdown or text Current Solution (q11_currentSolution) - text area Pain Points (q12_painPoints) - text area Configure Gmail - Add Gmail OAuth2 credentials (same for all Gmail nodes) Setup Sales Team Routing: Edit "Intelligent Routing Logic" node Update salesTeam object with your actual sales reps Configure territories, industries, and deal size thresholds Configure CRM Integration: Choose your CRM (HubSpot shown, easily adapted for Salesforce/Pipedrive) Add CRM API credentials Map custom fields as needed Setup Google Sheets: Create spreadsheet with "Lead_Tracking" sheet Replace YOUR_GOOGLE_SHEET_ID in workflow (3 places) Columns auto-populate on first submission Customize Email Templates: Update company name, phone, website URLs Adjust branding colors if desired Set Up Escalation: Update sales manager email in escalation node Adjust 24-hour SLA threshold if needed Test Workflow - Submit test lead through Jotform Go Live - Embed form on website, share link, add to email signatures Customization Options Lead Scoring Thresholds: Adjust what constitutes Hot (75+), Warm (50-74), Cold (25-49) Territory Configuration: Add/modify territories, states, countries for rep assignment Industry Expertise: Define which reps specialize in which industries Multi-Level Routing: Add VP or director assignment for enterprise deals Custom BANT Weights: Adjust importance of Budget vs Authority vs Need vs Timeline Qualification Disqualification: Auto-reject leads below minimum score Round-Robin vs Workload: Choose between even distribution or capacity-based assignment Integration Flexibility: Swap HubSpot for Salesforce, Pipedrive, Zoho, or custom CRM Follow-Up Sequences: Add automated email nurture campaigns for different tiers Calendar Booking: Include Calendly/Chili Piper links for instant meeting scheduling Lead Source Tracking: Add UTM parameters and campaign tracking Industry-Specific Qualifying: Custom questions and scoring for different verticals Multi-Touch Attribution: Track which marketing channels produce best leads Competitor Intelligence: Add fields to track which competitor they're considering Expected Results 5-minute response time - From form submission to rep contact (vs 48+ hours manual) 300% conversion increase - Faster response + better qualification = 3x more deals Zero lead conflicts - Automated assignment eliminates sales team arguments 95% SLA compliance - 24-hour escalation ensures no leads fall through cracks 40% time savings - Reps spend time selling, not qualifying or cherry-picking leads 85% accurate routing - AI + territory logic assigns to optimal rep first time 60% reduction in unqualified meetings - BANT scoring filters out poor-fit prospects 100% lead visibility - Complete tracking from inquiry to close in Google Sheets 50% manager time savings - Automated monitoring vs manual lead assignment 2x rep productivity - Only work high-quality, properly matched leads Use Cases SaaS Company (Series B, 50 Sales Reps) Scenario: Lead submits form requesting project management software for 200-person engineering team. Budget: $50K-$100K annually. Timeline: 1-3 months. Current solution: Jira. Pain: Poor cross-team visibility. AI BANT Analysis: Budget: 23/25 (has budget, validated by company size) Authority: 22/25 (VP Engineering, decision-maker) Need: 24/25 (critical pain, expanding team needs better tools) Timeline: 20/25 (moderate urgency, current fiscal quarter) Total Score: 89/100 - HOT LEAD** Automated Response: 9:14 AM: Form submitted 9:14 AM: CRM contact created with full profile 9:15 AM: Sarah Johnson (Senior AE, specializes in Tech/Engineering tools) receives detailed notification 9:15 AM: Lead receives confirmation email introducing Sarah 9:17 AM: Sarah calls lead (3-minute response time) 9:45 AM: Discovery meeting scheduled for tomorrow 10:30 AM: Sarah updates CRM status to "Qualified Opportunity" Result: Lead converts to $85K annual contract. 3-minute response time impressed prospect (competitor took 2 days). Total sales cycle: 18 days vs 45-day average. Professional Services Firm (8 Consultants) Scenario: Small business owner (25 employees) inquires about IT consulting. Budget: <$10K. Timeline: 6+ months. Current solution: "We handle it ourselves." Pain: "Sometimes things break." AI BANT Analysis: Budget: 8/25 (insufficient budget for typical engagement) Authority: 18/25 (owner, but budget-constrained) Need: 12/25 (low pain severity, reactive not proactive) Timeline: 5/25 (no urgency, exploratory inquiry) Total Score: 43/100 - COLD LEAD** Red Flags**: Below minimum deal size, no immediate pain, DIY mentality Automated Response: Assigned to Emily Brown (SDR) for nurture track Lead receives confirmation with educational resources Emily sends follow-up email with free IT assessment offer Lead added to quarterly newsletter nurture campaign No immediate sales rep time wasted on low-probability lead Result: 6 months later, business experiences server crash. Remembers firm from newsletter. Submits new request with "Immediate" timeline and $25K budget. This time routes to senior consultant, converts to $40K managed services contract. Enterprise Software (Global Sales Team) Scenario: Fortune 500 procurement manager submits RFP for enterprise data platform. Budget: $500K+. Timeline: Immediate (Q1 deadline). 5,000 employees. Industry: Healthcare. Current: Legacy Oracle system. AI BANT Analysis: Budget: 25/25 (enterprise budget, board-approved) Authority: 20/25 (procurement, but mentions C-suite sponsorship) Need: 25/25 (critical: compliance requirements, legacy system EOL) Timeline: 25/25 (urgent: Q1 deadline 8 weeks away) Total Score: 95/100 - ENTERPRISE HOT LEAD** Key Insight**: Competitor vulnerability HIGH (legacy system, compliance pressure) Automated Response: Assigned to Michael Chen (Senior AE, Healthcare + Enterprise specialist) Sales VP automatically CC'd on notification (deal size >$250K) CRM tags: "Enterprise", "Healthcare", "RFP", "Q1 Deadline" Michael's calendar checked, existing demo moved to prioritize this lead Michael calls within 8 minutes (prospect answered, impressed) Enterprise demo scheduled for next day with solutions engineer Legal and compliance teams looped in proactively Result: Won $650K 3-year contract. 8-minute response time + pre-qualified insights helped beat 4 competitors. Sales cycle: 6 weeks (vs 6-month average for enterprise deals). Manufacturing Sales (Regional Reps) Scenario: Plant manager in Texas requests quote for industrial equipment. Company size: 200 employees. Budget: $25K-$50K. Timeline: 3-6 months. Industry: Automotive. Current: 10-year-old machinery, frequent breakdowns. AI BANT Analysis: Budget: 20/25 (has capital budget, needs approval) Authority: 19/25 (plant manager, recommends to CFO) Need: 22/25 (high: downtime costs, efficiency losses) Timeline: 18/25 (planned capital purchase, budget cycle timing) Total Score: 79/100 - HOT LEAD** Talking Points**: Focus on ROI from reduced downtime, payback period Automated Response: Territory-based routing assigns to Jessica Martinez (Southwest US, Manufacturing) Email highlights equipment efficiency ROI calculator Lead receives PDF product catalog automatically Jessica calls within 12 minutes, schedules site visit for next week Technical specialist added to meeting invite automatically Result: $42K equipment sale + $8K annual maintenance contract. Jessica's quick response and ROI-focused approach (from AI talking points) won deal over competitor who took 3 days to respond. Marketing Agency (Qualifying Client Fit) Scenario: E-commerce startup (2 employees) requests full-service digital marketing. Budget: <$10K monthly. Timeline: Immediate. Current: Doing it themselves. Pain: "Need more customers." AI BANT Analysis: Budget: 12/25 (below agency minimum of $15K monthly) Authority: 22/25 (founder, decision-maker) Need: 18/25 (need is real, but unrealistic expectations) Timeline: 20/25 (urgent, but may not understand scope) Total Score: 72/100 - WARM LEAD** Red Flags**: Budget too low, unrealistic expectations, startup risk Automated Response: Assigned to David Williams (Mid-Level AE) AI recommends: "Qualify budget realism, educate on agency pricing" David calls, explains pricing, suggests DIY consulting option ($5K) Lead appreciates transparency, opts for consulting package now Agreed to revisit full-service when reaches $100K MRR Result: $5K consulting engagement (profitable given rep level). Client reaches $100K MRR 8 months later, upgrades to $20K monthly retainer. Honesty during qualification built trust and long-term relationship. Pro Tips Response Time is King: Every minute delayed reduces conversion by 10%. Use mobile notifications for reps. BANT Customization: Adjust scoring weights based on your sales cycle. Enterprise may weight Authority higher, transactional sales may weight Timeline higher. Territory Conflicts: Use round-robin within territories to prevent cherry-picking. Track conversion rates by rep. Lead Source Attribution: Add hidden fields to Jotform to track UTM parameters and campaign sources. Continuous Improvement: Monthly review of Google Sheets data to refine AI scoring thresholds. Rep Accountability: Use 24-hour escalation data to identify training needs or workload issues. Disqualification Criteria: Add automatic rejection for competitors, students, or leads outside serviceable areas. Integration Expansion: Connect to calendar systems (Calendly, Chili Piper) for instant meeting booking. Lead Nurture Tracks: Route cold leads to marketing automation (HubSpot sequences, Mailchimp campaigns). A/B Testing: Try different form fields and AI prompts to optimize qualification accuracy. Mobile Optimization: Ensure Jotform is mobile-friendly for leads submitting from phones. Follow-Up Sequences: Add automated day 2, day 7, day 30 follow-ups for non-responsive leads. Competitive Intelligence: Track which competitors are mentioned most, adjust positioning accordingly. Budget Realism Check: AI can identify when stated budget doesn't match company size/needs. Multi-Product Routing: For companies with multiple product lines, route based on interest. Learning Resources This workflow demonstrates advanced automation: AI Agents for Complex Qualification: Multi-dimensional BANT scoring with natural language understanding Dynamic Routing Algorithms: JavaScript-based logic for territory, expertise, and workload balancing CRM API Integration: Creating fully populated contact records with custom fields Conditional Email Formatting: HTML templates with dynamic content based on lead tier Scheduled Monitoring: Cron-based checking for SLA compliance and escalation Data Aggregation: Complete lead pipeline tracking for business intelligence Code Node Efficiency: Custom JavaScript for complex routing logic beyond visual nodes Multi-Output Branching: Parallel execution for CRM, notifications, and tracking Error Handling: Graceful failure modes for API timeouts or missing data Performance Optimization: Minimizing API calls while maximizing data capture Business Impact Metrics Lead Response Time: Track average time from submission to first contact (target: <5 minutes) Conversion Rate by Tier: Compare close rates for Hot vs Warm vs Cold leads to validate scoring Rep Performance: Measure conversion rates by sales rep to identify training needs or star performers Lead Source ROI: Calculate which marketing channels produce highest-scoring leads SLA Compliance: Track % of leads contacted within 24 hours (target: >95%) Revenue Per Lead: Compare deal sizes for AI-qualified leads vs manual qualification Time to Close: Measure if faster response and better qualification shortens sales cycles Assignment Accuracy: Track how often leads need re-assignment (target: <10%) Manager Escalations: Monitor frequency of 24-hour SLA breaches by rep Cost Per Lead Processed: Calculate ROI of automation vs manual lead distribution Ready to Transform Your Lead Management? Import this template and turn lead chaos into systematic qualification and instant routing with AI-powered BANT scoring! 🎯✨ Questions or customization? The workflow includes detailed sticky notes explaining each component's logic and decision criteria. Template Compatibility ✅ n8n version 1.0+ ✅ Works with n8n Cloud and Self-Hosted ✅ Fully customizable routing logic ✅ Integrates with any CRM via API

Shorts Creation v10 (Telegram Filming) — n8n Template Description How it works This workflow is a fully automated YouTube Shorts production pipeline. It takes the structured output from a video digestion workflow (transcript, key moments, metadata) and produces finished, rendered vertical shorts complete with AI-generated avatar narration, AI-generated B-roll video clips, dynamic multi-layout compositions, social media copy, and a lead magnet document — all uploaded to Google Drive and tracked in Google Sheets. It's designed to be called as a sub-workflow — triggered by a parent workflow that provides video analysis data (transcript, key moments, visual analysis, metadata). The full pipeline: Stage 1 — Extract & Prepare The workflow receives pre-analysed video data (transcript, sections, B-roll clips, metadata) from the parent workflow via the Execute Workflow Trigger. A Code node extracts and structures the key snippets, B-roll timestamps, and video context ready for AI processing. Stage 2 — Short-Form Concept Ideation (Gemini AI Agent) A Gemini-powered AI agent analyses the transcript, key moments, and video overview to generate 3 unique short-form concepts per video. Each concept includes a hook, body structure, CTA, full avatar script, and a lead magnet deliverable prompt. The agent uses structured output parsing to guarantee clean JSON. Concepts are fed with real examples from top-performing creators for style reference. Stage 3 — Loop Through Concepts The workflow loops through each concept and for each one runs the full production pipeline in parallel: Stage 4 — HeyGen Avatar Generation Each concept's full script is sent to HeyGen's API to generate a vertical (1080×1920) AI avatar video. The workflow polls HeyGen's status endpoint until rendering is complete, then captures the avatar video URL. Stage 5 — AI B-Roll Generation (Replicate — Seedance 1 Lite) While the avatar renders, the workflow generates AI video B-roll clips using ByteDance's Seedance 1 Lite model on Replicate. The AI Video Director determines what B-roll is needed, and prompts are sent to Replicate to generate 2-second vertical clips at 24fps and 720p. Multiple clips are generated and aggregated. Stage 6 — AI Video Director (Gemini AI Agent) A Gemini-powered AI Video Director creates a beat-by-beat storyboard with dynamic layout transitions. It generates a RenderScript specifying layout types (avatar full-frame for hooks/CTAs, split-screen for demos, picture-in-picture overlays for focus moments), transition effects, and timing. The effects library provides scroll-stopping transitions like RGB glitch, accent flash, zoom shake, and whip pan. Stage 7 — Creatomate Rendering The Creatomate Template Builder Code node converts the AI Director's storyboard into a Creatomate-compatible render payload — assembling avatar video, B-roll clips, transitions, text overlays, and effects into a single 1080×1920 composition. The render is sent to Creatomate's API, polled until complete, then downloaded. Stage 8 — Upload & Social Copy The finished video is uploaded to Google Drive and shared. An OpenAI-powered Social Media Copywriter generates platform-optimised titles, descriptions, hashtags, and captions for YouTube Shorts, Instagram Reels, and TikTok. Everything is logged to a Google Sheets tracker. Stage 9 — Lead Magnet Document Generation In parallel, a Gemini-powered Document Generator creates a downloadable lead magnet (actionable guide, template, checklist, etc.) based on the CTA promise from each concept. The document is converted to HTML and uploaded as a Google Doc, shared publicly, and linked in the tracker sheet — ready to use as a content magnet in video descriptions. Setup guide Required accounts & API keys | Service | What it does | Sign up | |---------|-------------|---------| | HeyGen | AI avatar video generation (talking head narration) | https://heygen.com | | Replicate | AI video B-roll generation (Seedance 1 Lite by ByteDance) | https://replicate.com | | Creatomate | Video composition rendering (assembles final short) | https://creatomate.com | | Google AI Studio (Gemini) | Powers 4 AI agents (concept ideation, video direction, output parsing, document generation) | https://aistudio.google.com | | OpenAI | Social media copywriting (titles, descriptions, hashtags) | https://platform.openai.com | | Google Cloud | Google Drive (video storage) + Google Sheets (tracking) + Google Docs (lead magnets) | https://console.cloud.google.com | Replicate model This workflow uses Seedance 1 Lite by ByteDance for AI-generated B-roll video clips: https://replicate.com/bytedance/seedance-1-lite n8n credentials to configure | Credential type | Used by | |----------------|---------| | HeyGen API Key (HTTP Header Auth) | Avatar generation + status polling | | Replicate API Token (HTTP Header Auth) | AI B-roll video generation | | Creatomate API Key (HTTP Header Auth) | Video render + status polling | | Google Gemini API Key | Concept ideation, video direction, structured parsing, document generation | | OpenAI API Key | Social media copywriting | | Google Drive OAuth2 | Video upload, Google Doc creation, file sharing | | Google Sheets OAuth2 | Shorts tracker logging | Google Workspace setup Google Sheets — Create a spreadsheet called shorts_tracker with a sheet named Shorts Tracker. Columns should include: Created Date, YouTube Title, Short Title, Concept Type, YouTube Short Title, YouTube Description, Instagram Caption, TikTok Caption, Hashtags, Google Drive URL, Magnet URL. Google Drive — Create a folder for rendered shorts. Update the Upload to Google Drive node with your folder ID. Google Docs — Lead magnet documents are auto-created and shared via the Google Drive API. Steps Import the workflow into n8n Configure all credential sets (HeyGen, Replicate, Creatomate, Gemini, OpenAI, Google OAuth2) Set up your Google Sheets tracker and Drive folder Update the HeyGen avatar IDs in the "HeyGen - Generate Full Avatar" node to match your HeyGen avatars Connect this as a sub-workflow — it expects to be called by a parent workflow (like the Video Digestion Workflow) via the Execute Workflow Trigger The parent workflow passes in: source video data, transcript, sections, key moments, visual analysis, and video overview What this workflow produces (per video) For each source video, the workflow generates 3 unique shorts, and for each short: ✅ Finished rendered vertical video (1080×1920 MP4) uploaded to Google Drive ✅ AI avatar narration with hook, body, and CTA ✅ AI-generated B-roll video clips ✅ Dynamic layouts with scroll-stopping transitions ✅ Platform-optimised copy (YouTube, Instagram, TikTok) ✅ Lead magnet Google Doc with shareable link ✅ Full tracking row in Google Sheets Nodes used (44 total) Execute Workflow Trigger Code nodes (x4 — snippet extraction, effects library, Creatomate template builder, HTML converter) AI Agents (x4 — Gemini-powered concept ideator, video director, document generator + structured output parsers) OpenAI node (social media copywriter) Google Gemini Chat Models (x5) HeyGen API (x2 — generate + poll status) Replicate API (AI B-roll generation) Creatomate API (x2 — render + poll status) Google Drive (x2 — upload + share) Google Sheets (x2 — tracker logging) HTTP Request (Google Docs creation) Set/Edit Fields, Split In Batches, Split Out, Merge, Aggregate, Wait, If nodes Example Reels: Example 1 Example 2 Built by @adamgoodyer — The Anti-Guru Technical Educator. Real workflows, real implementation, no fluff.