by DevCode Journey
Who is this for? This workflow is designed for anyone who wants to automate AI-driven chat responses integrated with Google Docs and Google Sheets, using the Google Gemini (PaLM) language model via n8n. It’s perfect for teams looking to: Automatically generate AI replies to chat messages, Pull content dynamically from Google Docs, What this Workflow Does Receives chat messages via a webhook trigger. Sends the chat input to the Google Gemini AI Chat Model for generating replies. Optionally retrieves a document from Google Docs if a URL or ID is provided. Uses an AI agent node to coordinate between the AI model and tools like Google Docs. Key Features Integration with Google Gemini (PaLM) AI for natural language understanding and response generation. Ability to fetch and use data from Google Docs dynamically. Modular structure using n8n nodes for flexibility and easy customization. Credential management for Google APIs (Docs, Gemini) via n8n’s built-in credential system. Get Your Google AI API Key Visit Google AI Studio. Click "Create API key in new project". Copy the API key that appears. Add Your Credential in n8n On the workflow canvas, go to the Connect your model (Google Gemini) node. Click the Credential dropdown and select + Create New Credential. Paste your API key into the API Key field. Click Save. Start Chatting! Go to the Example Chat node. Click the "Open Chat" button in its parameter panel. Try asking it one of the example questions: "What's your name?" "What time now in bangladesh?" "What's the weather in bangladesh?" You're now ready to chat with your personal AI agent powered by Google Gemini! 🎉 Requirements n8n instance with internet access. Google Cloud account with: Access to PaLM API (Google Gemini). Proper OAuth2 credentials configured in n8n for Google APIs. 🙋 For Help & Community 👾 Discord: n8n channel 🌐 Website: devcodejourney.com 🔗 LinkedIn: Connect with Shakil 📱 WhatsApp Channel: Join Now 💬 Direct Chat: Message Now
by Harshil Agrawal
No description available
by amudhan
Uses a DigitalOcean Personal Access Token to create a new Droplet. Add your personal access token and change the parameters to create droplets of different sizes. You can also specify more options; refer the API docs
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 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 CompanyEnrich
This workflow allows you to automatically expand your B2B target lists by discovering companies similar to your existing leads. Instead of manually searching for competitors or lookalikes, you can input a list of domains into Google Sheets and let the CompanyEnrich API generate high-quality lookalike suggestions along with similarity scores. Who is this for? This template is ideal for GTM Engineers, Sales Teams, and Growth Hackers who want to enrich their lead databases and find new prospecting opportunities based on their current ideal customer profile (ICP). What it does Reads Source: It pulls a list of company domains from a specified Google Sheet. Enriches: It sends each domain to the CompanyEnrich API to find similar companies (competitors/lookalikes). Processes: It merges the new data with your original list and formats the JSON response. Saves: It appends the results (Similar Company Name, Domain, and Similarity Score) back into a new tab in your Google Sheet. Requirements Google Sheets:** A spreadsheet with a column named Domain containing the websites you want to analyze. CompanyEnrich API Key:** You need an API key from CompanyEnrich. n8n Credentials:** Connected Google Sheets account. How to set up Prepare Sheet: Create a Google Sheet with two tabs. In the first tab, create a column header named Domain and add your target websites. Leave the second tab empty for results. Configure Nodes: Open the "Read Source List" and "Write Results" nodes to select your spreadsheet file and the respective tabs. Add API Key: Open the "Fetch Similar Companies" node. In the Header Parameters section, replace YOUR_API_TOKEN with your actual API key (keep the Bearer prefix). How to customize Filter by Score:** You can add an "If" node after the API call to filter out results with a low similarity score. Change Destination:** Instead of Google Sheets, you can easily swap the final node to write results to Airtable, Notion, or your CRM (HubSpot/Pipedrive).
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 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 Davide
This workflow automates the management of Zoom OAuth tokens and the creation of new Zoom users through the Zoom API. This workflow automates the process of creating a new Zoom user by first ensuring a valid OAuth access token is available. It is designed to handle the fact that Zoom access tokens are short-lived (1 hour) by using a longer-lived refresh token (90 days) stored in an n8n Data Table. It includes two main phases: Token Generation & Management The workflow initially requests a Zoom access token using the OAuth 2.0 “authorization code” method. The resulting access token (valid for 1 hour) and refresh token (valid for 90 days) are stored in an n8n Data Table. When executed again, the workflow checks for the most recent token, refreshes it using the refresh token, and updates the Data Table automatically. User Creation in Zoom Once a valid token is retrieved, the workflow collects the user’s first name, last name, and email (set in the “Data” node). It then generates a secure random password for the new user. Using the Zoom API, it sends a POST request to create the new user, automatically triggering an invitation email from Zoom. Key Features ✅ Full Automation of Zoom Authentication Eliminates manual token handling by automatically refreshing and updating OAuth credentials. ✅ Centralized Token Storage Securely stores access and refresh tokens in an n8n Data Table, simplifying reuse across workflows. ✅ Error Prevention Ensures that expired tokens are replaced before API requests, avoiding failed Zoom operations. 4.✅ Automatic User Provisioning Creates Zoom users automatically with prefilled credentials and triggers Zoom’s built-in invitation process. ✅ Scalability Can be easily extended to handle bulk user creation, role assignments, or integration with other systems (e.g., HR, CRM). ✅ Transparency & Modularity Each node is clearly labeled with “Sticky Notes” explaining every step, making maintenance and handover simple. How it works Trigger and Data Retrieval: The workflow starts manually. It first retrieves user data (first name, last name, email) from the "Data" node. In parallel, it fetches all stored token records from a Data Table. Token Management: The retrieved tokens are sorted and limited to get only the most recent one. This latest token (which contains the refresh_token) is then used in an HTTP Request to Zoom's OAuth endpoint to generate a fresh, valid access_token. User Creation: The new access_token and refresh_token are saved back to the Data Table for future use. The workflow then generates a random password for the new user, merges this password with the initial user data, and finally sends a POST request to the Zoom API to create the new user. If the creation is successful, Zoom automatically sends an invitation email to the new user. Set up steps Prepare the Data Table: Create a new Data Table in your n8n project. Add two columns to it: accessToken and refreshToken. Configure Zoom OAuth App: Create a standard OAuth app in the Zoom Marketplace (not a Server-to-Server app). Note your Zoom account_id. Encode your Zoom app's client_id and client_secret in Base64 format (as client_id:client_secret). In both the "Get new token" and "Zoom First Access Token" nodes, replace the "XXX" in the Authorization header with this Base64-encoded string. Generate Initial Tokens (First Run Only): Manually execute the "Zoom First Access Token" node once. This node uses an authorization code to fetch the first-ever access and refresh tokens and saves them to your Data Table. The main workflow will use these stored tokens from this point forward. Configure User Data: In the "Data" node, set the default values for the new Zoom user by replacing the "XXX" placeholders for first_name, last_name, and email. After these setup steps, the main workflow (triggered via "When clicking 'Execute workflow'") can be run whenever you need to create a new Zoom user. It will automatically refresh the token and use the provided user data to create the account. Need help customizing? Contact me for consulting and support or add me on Linkedin.
by System Admin
Tagged with: , , , ,
by System Admin
Tagged with: , , , ,