Workflow Templates

This workflow automatically enriches company domain lists with comprehensive business information using Perplexity AI's research capabilities and organizes the data in Google Sheets for easy analysis and use. Who's it for Sales teams** building prospect databases with accurate contact information Marketing professionals** researching target companies for campaigns Business development teams** gathering competitive intelligence Data analysts** enriching existing company datasets Researchers** collecting business information for market analysis How it works The workflow reads unprocessed company domains from a Google Sheets document, processes them in batches of 10 using Perplexity AI to research detailed business information, then saves the enriched data back to the spreadsheet. It focuses on German addresses but can be customized for any region. What it does Fetches unprocessed domains - Reads company domains from Google Sheets that haven't been processed yet Batches for efficiency - Groups domains into batches of 10 to optimize API costs and performance AI-powered research - Uses Perplexity AI to find comprehensive business data for each company Parses structured data - Converts AI responses into clean, structured JSON format Updates spreadsheet - Saves enriched data and marks domains as processed to prevent duplicates Requirements Perplexity AI API key** (Get one here) Google Sheets API access** (OAuth2 credentials) Google Sheets template** - Make a copy of this template How to set up Make a copy of the template Google Sheet and update the document ID in both Google Sheets nodes Configure Perplexity AI credentials in the HTTP Request node Set up Google Sheets OAuth2 authentication Add your company domains to the "domain" column in the Data tab Leave the "processed" column empty for new domains Run the workflow using the manual trigger How to customize the workflow Change target region**: Modify the AI prompt to research addresses in different countries Adjust batch size**: Change the batch size in the "Batch Process Domains" node (smaller batches = lower costs) Add custom fields**: Extend the AI prompt and Google Sheets mapping to include additional data points Automate execution**: Replace Manual Trigger with Schedule Trigger for regular processing Filter criteria**: Modify the Google Sheets filter to process specific subsets of domains Output data includes Complete company address (street, city, state, postal code, country) International phone number format Latest employee count and annual revenue (USD) Industry classification LinkedIn company URL Reliable source URL for verification Processing status tracking

This workflow automates the extraction of SEO metadata (URL, page title, and meta description) from every page listed in your website's sitemap and exports it to Google Sheets. Ideal for SEO audits, content inventories, and tracking on-page elements. Prerequisites Before using this workflow: A publicly accessible sitemap.xml URL Google Sheets spreadsheet with columns: URL, Title, and meta description Google Sheets API access via OAuth2 Setup Instructions 1. Configure Sitemap Source In the "Get Sitemap XML" node, replace the default URL with your actual sitemap URL 2. Connect Google Sheets Open the "Append or update row in sheet" node Configure Google Sheets credentials Set Document ID and Sheet Name Verify column mappings match your spreadsheet 3. Adjust Rate Limiting (Optional) Modify Wait nodes if encountering 429 errors Increase delay between requests if needed How It Works Trigger: Manual workflow execution Sitemap Fetch: Retrieve sitemap.xml file URL Parsing: Extract all URLs from sitemap Batch Processing: Process URLs in manageable batches Data Extraction: Scrape title and meta description from each page Data Merge: Combine URL with extracted metadata Sheet Update: Append or update rows in Google Sheets using URL as a unique key Features Duplicate Prevention**: Uses appendOrUpdate with URL matching Rate Limiting**: Built-in delays between requests Flexible Processing**: Handles sitemaps of various sizes Easy Customization**: Modify code nodes for additional data extraction Use Cases SEO audits of title and description tags Content migration planning Website content inventory management Ongoing SEO monitoring and reporting

Who it’s for This workflow is for content creators and marketers who write short scripts in Google Sheets and want to automatically turn each line into an AI-generated avatar video stored in Google Drive, with links written back to the sheet. How it works A Manual Trigger starts the workflow. It first uses Get Avatar Description (Google Sheets) to read avatar details from a dedicated “Gaia” sheet. The Global Variables node sets the working script page (for example, “Draft 5”) and exposes the avatar description. Next, Get Script reads all rows from the selected sheet. Loop Over Items iterates through each row, while Set Loop Inputs prepares the variables: avatar description, speech, and framing. For every row, Generate a video with Veo (Google Gemini video model) creates an 8-second 16:9 clip. Upload video file saves it to a chosen Google Drive folder, and Update row in sheet with link to video writes the Drive link back into the same row, then loops to the next snippet. Yellow sticky notes explain each phase, with the large one summarizing the end-to-end snippet generation loop. How to set up Connect your Google Sheets and Google Drive credentials. Update the spreadsheet IDs, sheet names, and Drive folder to match your own. Configure the Gemini/Veo model credentials. Adjust the default script page name in Global Variables. Requirements n8n instance Google Sheets and Google Drive accounts Google Gemini / Veo API access No API keys or personal identifiers are hardcoded; always store credentials securely in n8n and avoid real PII in test data. How to customize Change the page value in Global Variables to target different script tabs. Edit the Veo prompt to alter background, camera framing, or speaking style. Modify video duration, aspect ratio, or output folder in the Gemini and Drive nodes. Extend the loop to add more post-processing steps (e.g., thumbnail generation, analytics tracking).

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Workflow Description: Startup Idea Finder (n8n) What This Workflow Does: This n8n workflow helps entrepreneurs discover startup ideas by automatically scraping top posts from multiple subreddits that often discuss unmet needs or problems (e.g., posts containing phrases like “Why is there no tool that”, “I wish there was an app for”, “someone should make”, etc.). The workflow extracts key information from these posts and sends it to Google’s Gemini 1.5 Flash-8b AI model, which analyzes the problem and suggests possible solutions or startup ideas. All relevant data and AI-generated insights are then saved to a Google Sheet for easy review and tracking. How It Works (Step-by-Step) 1. Manual Trigger: The workflow starts with a manual trigger. 2. Reddit Scraping: It queries multiple subreddits for top posts matching specific keywords that indicate a problem or unmet need. 3. Merge & Edit Fields: The results are merged and filtered to keep only the necessary fields: title, selftext, ups, created, and url. 4. AI Analysis: The filtered post data is sent to the Gemini 1.5 Flash-8b model with a prompt asking for: An explanation of the core problem, Whether existing solutions exist, A new startup idea if not, The target user, An implementation overview. 5. Google Sheets Logging: Both the original post data and the AI’s output are appended as a new row in a Google Sheet for future reference. APIs & Credentials Needed To use this workflow, you must set up the following credentials in your n8n instance: Reddit API: For scraping subreddit posts. Google Gemini (PaLM) API: For AI-powered analysis and idea generation. Google Sheets API: For saving results to your spreadsheet. Google Sheets Setup Before running the workflow, create a Google Sheet with the following columns (in this order): title, selftext, ups, created, url, output* The workflow will automatically append new rows with the scraped post data and the AI-generated output. Summary This workflow is a powerful tool for anyone looking to systematically discover and analyze real-world problems discussed online, and to generate actionable startup ideas using AI. Just set up your credentials, prepare your Google Sheet, and you’re ready to start finding your next big idea!

How it works Please send a corporate website URL via chat. The AI will investigate the company website on your behalf and return the extracted company information. Since this is set up as a conversational workflow, retrying or trying another URL is simple. How to use To get started, please set up the Credential in the Gemini node attached to the AI Agent node. You can obtain an API key from Google AI Studio. Once configured, the workflow will run when you send a corporate website URL (e.g., https://example.com/) via chat. Customizing this workflow You can change the settings in the Config node. You can modify targetCompanyFields to customize which company data fields are extracted. You can modify language to receive the results in a language other than English.

How it works This workflow automates the job curation process by retrieving pending job search inputs from a spreadsheet, querying the JSearch API for relevant job listings, and writing the curated results back to another sheet. It is designed to streamline job discovery and reduce manual data entry. Step-by-step 1. Trigger & Input The workflow starts on a defined schedule (e.g., once per day). It reads a row from the Job Scraper sheet where the status is marked as "Pending". The selected row includes fields like Position and Location, which are used to build the search query. 2. Job Search & Processing Sends a search request to the JSearch API using the Position and Location from the spreadsheet. Parses the API response and extracts individual job listings. Filters out empty, irrelevant, or invalid entries to ensure clean and relevant job data. 3. Output & Status Update Writes valid job listings to the Job Listing output sheet with fields such as job title, company name, location, and more. Updates the original row in the source sheet to mark it as Scraped, ensuring it will not be processed again in future runs. Benefits Reduces manual effort in job research and listing. Ensures only valid, structured data is stored and used. Prevents duplicate processing with automatic status updates. Simple to expand by adding more job sources or filters.

AI-Powered Product Video Generator (Foreplay + Gemini + Sora 2) Sign Up For Foreplay HERE Automatically generate personalized, cinematic-quality product videos using Foreplay’s ad data, Google Gemini AI for creative prompts, and Sora 2 for text-to-video generation. Who’s it for? Perfect for marketers, brand managers, or creators who want to produce quick, high-quality video ads without manual scripting or editing. How it works Fetch product data and related competitor videos from Foreplay. Use Gemini AI to generate creative text-to-video prompts. Send the prompt and image to Kie.ai to generate a short, cinematic product video. Save the finished video automatically to Google Drive. How to set up Connect your Foreplay, Google Drive, Gemini, and Kie.ai credentials. Set your product image folder's permission (Google Drive) as public. Add your API keys inside the Set Workflow Credentials node. Then run the workflow manually to generate your first video ad!

Automate SEO Blog Creation with Apify + Google Docs + KIE AI’s Nano Banana API Who’s it for For content creators, SEO specialists, and digital marketers who want to automatically generate SEO-optimized blog posts from trending topics — no manual writing or formatting required. How it works / What it does This workflow turns trending searches into fully structured blog posts using AI: Fetch trending topics from India (or any country) using Apify’s Google Trends scraper. Generate a SEO-optimized blog post with title, meta description, headings, and long-form content using Gemini AI. Refine the System Message (optional) with Gemini AI for better readability and engagement. Create a custom blog image using KIE AI’s Nano Banana API based on the blog title. Automatically insert all content and images into a Google Doc, ready for publishing. How to set up Add your Apify API token in the Google Trends node. Configure Google Docs OAuth2 credentials for the document update node. Add your KIE AI Nano Banana API token for image generation. Schedule the Daily Trigger to your preferred time (default is 8 AM). Requirements Apify API token (for trending search scraping) Google account with Docs access KIE AI Nano Banana API token How to customize the workflow Change country or timeframe for trending searches. Update the AI prompt for tone, length, or style of the blog. Change the Google Doc ID to insert content into a different document. Adjust image generation settings (size, style) in the KIE AI node.

This workflow returns the current weather at a predefined or given city and returns it so that it can be displayed with bash-dash. By default does it return the weather in Berlin if no city got defined. That default can be changed in the "Set City" node. Example usage: \- weather london Example bash-dash config: commands[weather]="http://localhost:5678/webhook/weather"

This workflow demonstrates how to automate the extraction of business emails from Google Maps results using a specific keyword. It streamlines the process of finding, filtering, and saving contact emails into a Google Sheet, eliminating the need for tedious manual research. This tool is perfect for those who need to collect business email addresses for outreach, research, or marketing purposes, especially those whose success depends on building and managing business relationships at scale. Sales and Lead Generation Teams**: Quickly build targeted business email lists for efficient cold outreach and follow-up. Marketing Agencies and Freelancers**: Effortlessly gather contact details for potential clients in specific niches or locations to power outreach campaigns. Recruiters and Talent Acquisition Specialists**: Easily collect company contacts to connect with HR or hiring managers in targeted industries or regions. Event Organizers and B2B Promoters**: Rapidly compile relevant business emails for event invitations, sponsorship proposals, or promotional efforts. Market Researchers and Data Analysts**: Automate large-scale collection of business emails to support industry analysis and data-driven research. How It Works A target keyword (e.g., “n8n workflow”) should be entered in Node Fields - Set Keyword / Phrase. Then, the process is triggered by clicking Test Workflow or Execute Workflow. The workflow queries Google Maps, collects keyword-related website URLs from its HTML, and filters for only valid website URLs. Next, it removes duplicate website URLs to ensure each is processed only once later. For every unique valid website URL, the workflow sends an HTTP request to extract all potential email addresses from the website’s content in a loop. After that, the emails are passed through another loop and a code node (Code – Match Email) to ensure each one is a valid, properly formatted email address (not just random text). Any invalid emails are filtered out during this step. All valid emails are then collected and prepared for further processing. The workflow then splits out the results and removes any duplicate emails to ensure each address appears only once. Finally, the list of unique, verified emails (directly related to your chosen keyword) is saved to your connected Google Sheet for easy access and follow-up. How To Set Up Download the working package. Import the package into your n8n interface. Duplicate the Google Maps - Crawl Emails By Keyword Google Sheets template into your Google Sheets account. Set up necessary credentials in Google Cloud Console for Google Sheets access and usability in Node Google Sheets - Update Data. Set up a GET method to access Google Maps in Node HTTP Request - Get Sites. Enter your desired keyword or phrase in Node Fields - Set Keyword / Phrase. Start the workflow in n8n. Wait a few minutes for the process to finish. Check the list of all valid emails related to your keyword/phrase in the connected Google Sheet. Requirements Basic setup in Google Cloud Console (OAuth or API Key method enabled) with enabled access to Google Sheets. Access to Google Maps. How To Customize Adjust the Keyword Input: You can easily change the keyword or phrase you want to search for by editing the second node, **Fields – Set Keyword / Phrase, in your n8n workflow. Add Follow-up Steps**: Modify the workflow to even trigger follow-up actions like sending emails automatically. Need Help? If you need a step-by-step guide to set up this workflow or want it customized for your specific business needs, 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 assistance, 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

This workflow shows how to download an image file from S3 and pass it on to Textract for text extraction. The workflow uses two nodes: AWS S3**: This node will download a receipt file from S3 AWS Textract**: This node connects to Aamazon's Textract service to extract text from the receipt file

Who is this for This workflow is designed for Innovation Managers, Tech Transfer Offices, and Business Development Representatives looking to find commercial partners for new technologies. What it does This template automates the process of scouting startups that might be a good fit for NASA patents. Search: It fetches patents from the NASA Tech Transfer API based on a keyword you define. Find: It searches Google to identify startups operating in related fields. Enrich: It crawls the identified startup's website to extract context about their business. Analyze: Using OpenAI, it scores the "fit" between the patent and the startup and drafts a personalized outreach email. Save: High-scoring leads are enriched with LinkedIn company pages and saved directly to a Notion database. How to set up Configuration: In the Configuration node, set the keyword variable to the technology topic you want to search for (e.g., "robotics"). NASA API: Get a free API key from api.nasa.gov and enter it in the NASA Patents API node parameters. Apify: Connect your Apify account credential. You will need credits to run the google-search-scraper and website-content-crawler actors. OpenAI: Connect your OpenAI credential. Notion: Create a database with the following properties and connect it in the Create Notion Lead node: Company (Text) Website (URL) LinkedIn (URL) Email (Email) Score (Number) Draft Email (Text) NASA Tech (Text) Requirements NASA API Key**: Free to obtain. Apify Account**: Requires google-search-scraper and website-content-crawler actors. OpenAI API Key**: For analysis and text generation. Notion Account**: To store the leads.