by Agent Circle
This n8n template automates real-time SEO keyword research, delivering comprehensive keyword insights, autocomplete suggestions, subtopics, SERP analysis, and more, straight into your Google Sheet. Use cases are many: This workflow is perfect for bloggers, SEO professionals, affiliate marketers, e-commerce teams, and content creators who need fresh, actionable keyword data for planning, optimization, and content expansion - without endless manual research. How It Works Phase 1: Set Google Sheet ID & Input Target Keywords In n8n, enter the Google Sheet ID in the Set Sheet ID node. In the connected Google Sheet, for the first tab Main Keyword, you manually add the main keywords that you want the tool to research and generate relevant keyword suggestions for. Trigger the process by clicking Test Workflow or Execute Workflow. The workflow automatically reads your main keywords from the Main Keyword tab in your linked Google Sheet, only those marked with the status Ready will be processed. Phase 2: Automated Research & Data Collection For your input main keyword (considering here you only set Ready for one main keyword in the connected Google Sheet), the workflow runs multiple automated queries in parallel: 1. Get Related Keywords: The workflow sends a POST request to the DataForSEO API endpoint to directly retrieve an array of related keywords. Then, the array of related keywords is parsed out, preparing each keyword as a separate record for further processing. It appends each extracted related keyword as a new row in the Related KW tab of your connected Google Sheet. The Main Keyword value from your input is included in Column A of the tab to maintain keyword context. Additionally, the workflow appends the related keywords - along with the associated main keyword - to the All Results tab in your Google Sheet for consolidated tracking and future reference. This ensures you have both a dedicated list of related keywords and a master log of all research results in one place. 2. Get Keyword Suggestions: The workflow sends a POST request to the DataForSEO API endpoint to directly retrieve an array of keyword suggestions related to your main keyword. This array of keyword suggestions is then parsed, splitting out each suggestion as an individual record for further processing. Each extracted keyword suggestion is appended as a new row in the KW Suggestion tab of your connected Google Sheet. The original Main Keyword value from your input is included in Column A of the tab to maintain clear context. Additionally, the workflow appends all keyword suggestions - along with the associated main keyword - to the All Results tab in your Google Sheet for consolidated tracking and future reference. This ensures you have both a dedicated list of keyword suggestions and a master log of all research results in one place. 3. Get Autocomplete Suggestions: The workflow sends a POST request to the DataForSEO API endpoint to retrieve Google autocomplete keyword suggestions for your main keyword. The array of autocomplete keyword suggestions is parsed out as an individual record for processing. Each extracted autocomplete keyword is appended as a new row in the Autocomplete Suggestion tab of your connected Google Sheet. The Main Keyword is included alongside each entry for proper tracking. Additionally, the workflow appends all autocomplete keywords - along with the associated main keyword - to the All Results tab in your Google Sheet for consolidated tracking and future reference. This ensures you have both a dedicated list of autocomplete keywords and a master log of all research results in one place. 4. Get Content Ideas: The workflow sends a POST request to the DataForSEO API endpoint to retrieve content ideas and fresh topic suggestions based on your main keyword. The array of content ideas is then parsed; each idea is extracted as a separate record for further use. Every content idea is then appended as a new row in the Content Idea tab of your connected Google Sheet, with the Main Keyword included to provide context. Additionally, the workflow appends all content ideas, along with their related main keyword, to the All Results tab in your sheet for consolidated tracking and easy access. This ensures you have both a dedicated list of content ideas for brainstorming and a central log of all keyword research outputs in one place. 5. Get SERPs: The workflow sends a POST request to the DataForSEO API endpoint, retrieving both the current Google SERP (Search Engine Results Page) data and People Also Ask (PAA) questions related to your main keyword. Then, the data is split into two streams: one for standard SERP results and one for PAA questions. For Standard SERPs: The workflow filters the SERP data to keep only the most relevant results. Each SERP entry is appended as a new row in the SERP tab of your connected Google Sheet, providing insights into top-ranking pages and their attributes. For PAA (People Also Ask): The PAA data is also filtered. Each PAA question is split out and added as a new row in the PAA tab in your connected Google Sheet for focused tracking. Additionally, all PAA questions are consolidated and appended, along with their related main keyword, to the All Results tab in your sheet for consolidated tracking and easy access. This ensures you have both a dedicated list of PAA questions for brainstorming and a central log of all research outputs in one place. Result Types Main Keyword: Your original list of main keywords with status tracking. All Results: A master log of all relevant keyword and idea research outputs for easy review. Related KW: Lists of related keywords for each main keyword. KW Suggestion: Suggested keyword ideas for broader targeting. Autocomplete Suggestion: Google autocomplete keyword suggestions to capture real user queries. Content Idea: Keyword-related content ideas to build out your content clusters. SERP: top-ranking pages, including their URLs, page titles, and descriptions - perfect for quick competitor and content analysis. PAA: People Also Ask questions for intent research and content expansion. How To Set Up Download the workflow package and import it into your n8n interface. Duplicate the Keyword Research Google Sheet template to your Google Sheets account. Set up necessary credentials for tools access and usability: For Google Sheets access, ensure each node is properly connected to the correct tab in your connected Google Sheet template: Node Get Main Keywords → connected to the Main Keyword tab Node Add Related KWs → connected to the Related KW tab Node Save Related KWs to All Results → connected to the All Results tab Node Add KW Suggestions → connected to the KW Suggestion tab Node Save KW Suggestions to All Results → connected to the All Results tab Node Add Autocomplete Suggestions → connected to the Autocomplete Suggestion tab Node Save Autocomplete Suggestions to All Results → connected to the All Results tab Node Add Content Ideas → connected to the Content Idea tab Node Save Content Ideas to All Results → connected to the All Results tab Node Add SERPs → connected to the SERP tab Node Add PAAs → connected to the PAA tab Node Save PAAs to All Results → connected to the All Results tab For DataForSEO access, set up API credentials (Basic Auth) along with correct POST URL for each query in the following node: Node Get Related KWs Node Get KW Suggestions Node Get Autocomplete Suggestions Node Get Content Ideas Node Get SERPs Enter your Google Sheet ID in the Set Sheet ID node to link the workflow to your connected Google Sheet. Add your target keywords to Column B in the Main Keyword tab in the connected Google Sheet and set their status to Ready Run the workflow by clicking Test Workflow or Execute Workflow in n8n. Review the results across all output tabs in your connected Google Sheet. Requirements n8n** instance (self-hosted or cloud). Basic setup in Google Cloud Console (OAuth or API Key method enabled) with enabled access to Google Sheets. DataForSEO** API credentials. How To Customize Add Extra Research Steps**: Expand the workflow by integrating additional research queries related to the main keywords - such as backlink analysis, competitor monitoring, or search trend tracking - to gather even more valuable insights alongside your keyword data. Automate Scheduling & Notifications**: Set up an automatic schedule in n8n so the workflow runs at your preferred intervals. Connect notification tools like Telegram, Slack, or a chatbox to receive alerts whenever the process finishes, keeping you instantly updated without manual checks. Personalize Data Mapping**: Tailor how the research results are saved to your Google Sheet by customizing column mapping and naming conventions. This lets you organize your data exactly how you want for easier analysis and reporting. Need Help? If you’d like this workflow customized to fit your tools and platforms availability, or if you’re looking to build a tailored AI Agent for your own business - please feel free to reach out to Agent Circle. We’re always here to support and help you to bring automation ideas to life. Join our community on different platforms for support, inspiration and tips from others. Website: https://www.agentcircle.ai/ Etsy: https://www.etsy.com/shop/AgentCircle Gumroad: http://agentcircle.gumroad.com/ Discord Global: https://discord.gg/d8SkCzKwnP FB Page Global: https://www.facebook.com/agentcircle/ FB Group Global: https://www.facebook.com/groups/aiagentcircle/ X: https://x.com/agent_circle YouTube: https://www.youtube.com/@agentcircle LinkedIn: https://www.linkedin.com/company/agentcircle
by Vasyl Pavlyuchok
Automatically track your favorite YouTube creators and get a daily summary of new videos delivered to Discord. Unlike complex YouTube API integrations, this workflow uses efficient RSS feeds, meaning you don't need a Google Cloud API Key or worry about quota limits. How it works The workflow is scheduled to run daily (default 8:30 AM) to: Define Channels: It takes a list of "Channel IDs" you want to monitor. Fetch RSS: It retrieves the latest video feed for each channel. Filter: It applies a strict date filter to pass only videos published in the last 24 hours. Notify: Sends a notification to your Discord server with the Video Title, Date, and Link. Setup steps 1. Add your Channels Open the node named "Define Channel IDs". Replace the example IDs with the Channel IDs you want to track. Note: The template comes pre-loaded with some Spanish AI channels as a demo. Feel free to remove them! Tip: If you don't know a Creator's Channel ID (e.g. UC...), use a free online "YouTube Channel ID Finder". 2. Connect Discord Create a Webhook in your Discord Server (Server Settings > Integrations > Webhooks). Open the "Discord Notification" node. Create a new credential and paste your Webhook URL. Note: This template is a lightweight alternative to database-backed trackers. It relies on the daily trigger frequency to avoid duplicates.
by Adrian
How it works This is an example of using sub-workflow nodes and a proof of concept showing that it’s possible to solve and explain recursive problems with n8n. Towers of Hanoi - Task Move a stack of n disks from rod A to rod C, using rod B as auxiliary. Only one disk can be moved at a time, and no disk may be placed on a smaller disk. Example n=4 | | | = | | === | | ===== | | ======= | | --------- --------- --------- A B C Algorithm procedure Hanoi(n, X, Y, Z): if n == 1: move disk from X to Z else: Hanoi(n-1, X, Z, Y) move disk from X to Z Hanoi(n-1, Y, X, Z) Notes This is a learning example. In a real scenario, you would probably use an iterative approach with only a single code node. When experimenting with recursion, make sure to define a termination condition first. Also, be aware of the "Restart workspace" link in the n8n Dashboard. Learn more about Recursion on Wikipedia&oldid=1301600240#Towers_of_Hanoi). Set up steps Optional: Set "numberOfDiscs" in node "Set number of discs" Execute workflow
by Daniel
Apollo Lead Scraper to Airtable CRM Automate your lead generation by scraping targeted prospects from Apollo.io, enriching with contact details, and seamlessly syncing to Airtable for organized outreach—all without manual data entry. What It Does This workflow pulls search URLs from Airtable, uses Apify to scrape Apollo leads (up to 50k), enriches with emails and LinkedIn profiles, removes duplicates, filters valid entries, and categorizes contacts into Airtable tables based on email availability for efficient CRM management. Key Features Apify Apollo Scraper** - Extracts up to 50k leads with personal/work emails Smart Deduplication** - Removes duplicates based on key fields like email and name Email Categorization** - Separates contacts with/without emails into dedicated tables Field Mapping** - Customizable data transformation for Airtable compatibility Configurable Limits** - Adjust total records and memory for optimal performance Error Handling** - Built-in troubleshooting for common issues like invalid URLs Perfect For Sales Teams**: Build targeted B2B pipelines for email campaigns Recruiters**: Source candidates by job title, location, and skills Marketers**: Create datasets for market research and analysis Agencies**: Automate client prospecting from custom filters Researchers**: Collect professional data for industry studies CRM Managers**: Maintain clean, enriched contact databases Technical Highlights Leveraging n8n's Airtable and Apify integrations, this workflow showcases: Dynamic data fetching from Airtable tables Actor-based web scraping with custom parameters Conditional branching for data routing Efficient data processing with set, filter, and if nodes Scalable design for large datasets with memory optimization Ideal for automating lead workflows and scaling prospecting efforts. No advanced coding needed—just set up credentials and run!
by Ahmad Sarian
Effortlessly Turn Prompts into Captivating ASMR Rainforest Videos! Transform your creative ideas into stunning ASMR-style videos with this automated workflow. By seamlessly chaining image and video generation, you can go from text prompts to finished animations in just a few clicks. Who is it for? Content creators, digital artists, ASMR enthusiasts, and anyone looking to produce unique animated videos from simple text prompts. How it works Start with your chosen prompt, and the workflow generates a mesmerizing image using seedream v4. Once ready, it automatically transforms the image into an engaging video using seedance v1 pro. Built-in wait checks ensure smooth processing even during heavy loads. How to set up Create a FAL credential by entering your API authorization header. Set your creative prompt in the “Prompt” node. Models used by default: Text-to-image: seedream v4 Image-to-video: seedance v1 pro Hit Run and watch the magic happen! Requirements fal.ai API key Customizing Your Workflow Instantly auto-post your results to social media (YouTube, Twitter, etc.). Log all image and video URLs to Google Sheets or a data table for easy tracking. Get notified by email or Telegram when your content is ready.
by Fahmi Fahreza
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Analyze Any Video and Get a Text Summary with Google Gemini This workflow uses the NEW native Google Gemini node in n8n to analyze videos and generate detailed text summaries. Just upload a video, and Gemini will describe the scenes, objects, and actions frame by frame. Who Is This For? Content Creators & Marketers** Quickly generate summaries, shot lists, or descriptions for video content. Video Editors** Get a fast overview of footage without manual review. Developers & n8n Beginners** Learn how to use multimodal AI in n8n with a simple setup. AI Enthusiasts** Explore the new capabilities of the Gemini Pro model. How It Works Upload** Triggered via a form where you upload a video file. Analyze** The video is sent to the Gemini 2.5 Pro model for analysis. Describe** Gemini returns a detailed text summary of what it sees in the video. Setup Instructions 1. Add Credentials Connect your Google AI (Gemini) credentials in n8n. 2. Activate Workflow Save and activate the workflow. 3. Upload Video Open the Form Trigger URL, upload a video, and submit the form. Requirements An n8n instance (Cloud or Self-Hosted) A Google AI (Gemini) account Customization Ideas Translate the Summary** Add another LLM node to translate the analysis. Create Social Media Posts** Use the output to generate Twitter or LinkedIn content. Store the Output** Save the summary to Google Sheets or Airtable. Automate with Cloud Storage** Replace the Form Trigger with a Google Drive or Dropbox trigger to process videos automatically.
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,
by Juan Cristóbal Andrews
Who's it for This template is designed for filmmakers, content creators, social media managers, and AI developers who want to harness OpenAI's Sora 2 for creating physically accurate, cinematic videos with synchronized audio. Whether you're generating realistic scenes from text prompts or reference images with proper physics simulation, creating multi-shot sequences with persistent world state, or producing content with integrated dialogue and sound effects, this workflow streamlines the entire video generation process from prompt to preview and Google Drive upload. What it does This workflow: Accepts a text prompt, optional reference image, OpenAI API key, and generation settings via form submission Validates reference image format (jpg, png, or webp only) Sends the prompt and optional reference to the Sora 2 API endpoint to request video generation Continuously polls the video rendering status (queued → in progress → completed) Waits 30 seconds between status checks to avoid rate limiting Handles common generation errors with descriptive error messages Automatically fetches the generated video once rendering is complete Downloads the final .mp4 file Uploads the resulting video to your Google Drive Displays the download link and video preview/screenshot upon completion How to set up 1. Get Your OpenAI API Key You'll need an OpenAI API key to use this workflow. Here's the general process: Create an OpenAI account at https://platform.openai.com Set up billing - Add payment information to enable API access Generate your API key through the API keys section in your OpenAI dashboard Copy and save your key immediately - you won't be able to view it again! ⚠️ Important: Your API key will start with sk- and should be kept secure. If you lose it, you'll need to generate a new one. 2. Connect Google Drive Add your Google Drive OAuth2 credential to n8n Grant necessary permissions for file uploads 3. Import and Run Import this workflow into n8n Execute the workflow via the form trigger Enter your API key, prompt, and desired settings in the form Optionally upload a reference image** to guide the video generation All generation settings are configured through the form, including: Model**: Choose between sora-2 or sora-2-pro Duration**: 4, 8, or 12 seconds Resolution**: Portrait or Landscape options Reference Image** (optional): Upload jpg, png, or webp matching your target resolution ⚠️ Sora 2 Pricing The workflow supports two Sora models which have the following API pricing: Sora 2 - $0.10/sec Portrait: 720x1280 Landscape: 1280x720 Sora 2 Pro - $0.30/sec (720p) or $0.50/sec (1080p) 720p - Portrait: 720x1280, Landscape: 1280x720 1080p - Portrait: 1024x1792, Landscape: 1792x1024 Duration options: 4, 8, 12 seconds (default: 4) Example costs: 4-second video with Sora 2: $0.40 12-second video with Sora 2 Pro (1080p): $6.00 Requirements Valid OpenAI API key (starting with sk-) Google Drive OAuth2 credential connected to n8n Reference image** (optional): jpg, png, or webp format - should match your selected video resolution for best results How to customize the workflow Modify generation parameters Edit the form fields to include additional options: Style presets (cinematic, anime, realistic) Camera movement preferences Audio generation options Image reference strength/influence settings It's recommended to visit the official documentation on prompting for a detailed Sora 2 guide. Adjust polling behavior Change the Wait node duration (default: 30 seconds) Modify the Check Status polling frequency based on typical generation times Add timeout logic for very long renders Customize error handling Extend error messages for additional failure scenarios Add retry logic for transient errors Configure notification webhooks for error alerts Alternative upload destinations Replace the Google Drive node with: Dropbox AWS S3 Azure Blob Storage YouTube direct upload Slack/Discord notification with video attachment Enhance result display Customize the completion form to show additional metadata Add video thumbnail generation Include generation parameters in the results page Enable direct playback in the completion form Workflow Architecture Step-by-step flow: Form Submission → User inputs text prompt, optional reference image, API key, and generation settings Create Video → Sends request to Sora 2 API endpoint with all parameters and reference image (if provided) Check Status → Polls the API for video generation status Status Decision → Routes based on status: Queued → Wait 30 seconds → Check Status again In Progress → Wait 30 seconds → Check Status again Completed → Proceed to download Failed → Display descriptive error message Wait → 30-second delay between status checks Download → Fetches the generated video file Google Drive → Uploads .mp4 to your Drive Completion Form → Displays download link and video preview/screenshot If you have any questions, just contact me on Linkedin Ready to create cinematic AI videos with physics-accurate motion, synchronized audio, and optional image references? Import this workflow and start generating! 🎬✨
by System Admin
Tagged with: , , , ,
by Noriwal AlMa Jr
WhatsApp Audio Transcriber Bot Overview Automatically transcribe WhatsApp audio messages to text using AI-powered speech recognition. This workflow receives audio messages via webhook, processes them through Groq's Whisper API, and replies with the transcribed text in the same conversation. Use Cases Accessibility**: Help users with hearing impairments access audio content Workplace Communication**: Quickly scan audio messages in professional settings Language Learning**: Get text versions of audio for better comprehension Meeting Notes**: Convert voice messages to searchable text format Multilingual Support**: Transcribe audio in Portuguese (configurable for other languages) How it Works Message Reception: Webhook receives WhatsApp messages in real-time Audio Detection: Filters only audio messages using Switch node Format Conversion: Converts base64 audio to MP3 file format AI Transcription: Processes audio through Groq API with Whisper Large V3 model Response Delivery: Sends transcribed text back to the original conversation Key Features ✅ Real-time Processing: Instant transcription of incoming audio messages ✅ High Accuracy: Uses Whisper Large V3 model for reliable transcription ✅ Auto-Reply: Automatically responds in the same WhatsApp conversation ✅ Message Quoting: References the original audio message in the reply ✅ Portuguese Optimized: Configured for Brazilian Portuguese transcription ✅ Self-Message Filtering: Ignores messages sent by the bot itself Prerequisites Required Services Evolution API**: WhatsApp integration service Groq API**: AI transcription service (Whisper model) n8n Instance**: Workflow automation platform API Keys & Configuration Groq API key (set as environment variable: GROQ_API_KEY) Evolution API instance properly configured Webhook URL configured in Evolution API Setup Instructions Import Workflow: Import the JSON workflow into your n8n instance Configure Environment: Set GROQ_API_KEY environment variable Setup Webhook: Configure Evolution API to send messages to the webhook endpoint Test Connection: Send a test audio message to verify the workflow Workflow Nodes Webhook**: Receives WhatsApp messages from Evolution API Edit Fields**: Extracts relevant data (number, name, message, audio) Switch**: Filters only audio messages (audioMessage type) Convert to File**: Transforms base64 audio to MP3 format HTTP Request**: Sends audio to Groq API for transcription Evolution API**: Sends transcribed text back to WhatsApp Configuration Options Groq API Settings Model**: whisper-large-v3 Language**: pt (Portuguese) Temperature**: 0 (maximum accuracy) Response Format**: json Customization Options Change language by modifying the language parameter Adjust temperature for different accuracy/creativity balance Modify response format for different output styles Response Format Mensagem transcrita automaticamente. [Transcribed text content] Technical Specifications Input**: Base64 encoded audio from WhatsApp Output**: Plain text transcription Processing Time**: Typically 2-5 seconds per audio message Supported Audio**: MP3 format (converted from WhatsApp audio) Language**: Portuguese (configurable) Troubleshooting No Response**: Check Groq API key and webhook configuration Poor Transcription**: Ensure audio quality and check language settings Error Messages**: Monitor n8n execution logs for detailed error information Version History v0.0.1**: Initial release with basic transcription functionality