Google Gemini Chat Model and Google Sheets integration

This n8n template demonstrates how to obtain token usage from AI Agents and places the data into a spreadsheet that calculates the estimated cost of the execution. Obtaining the token usage from AI Agents is tricky, because it doesn't provide all the data from tool calls. This workflow taps into the workflow execution metadata to extract token usage information. Works well with OpenAI, Google and Anthropic. Other LLM providers might need small tweaks. How it works The AI Agent executes and then calls a subworkflow to calculate the token usage. The data is stored in Google Sheets The spreadsheet has formulas to calculate the estimated cost of the execution. How to use The AI Agent is used as an example. Feel free to replace this with other agents you have. Call the subworkflow AFTER all the other branches have finished executing. Requirements LLM account (OpenAI, Gemini...) for API usage. Google Drive and Sheets credentials n8n API key of your instance

🛒 Lead Workflow: Yelp & Trustpilot Scraping + OpenAI Analysis via BrightData > Description: Automated lead generation workflow that scrapes business data from Yelp and Trustpilot based on location and category, analyzes credibility, and sends personalized outreach emails using AI. > ⚠️ Important: This template requires a self-hosted n8n instance to run. 📋 Overview This workflow provides an automated lead generation solution that identifies high-quality prospects from Yelp and Trustpilot, analyzes their credibility through reviews, and sends personalized outreach emails. Perfect for digital marketing agencies, sales teams, and business development professionals. ✨ Key Features 🎯 Smart Location Analysis** AI breaks down cities into sub-locations for comprehensive coverage 🛍 Yelp Integration** Scrapes business details using BrightData's Yelp dataset ⭐ Trustpilot Verification** Validates business credibility through review analysis 📊 Data Storage** Automatically saves results to Google Sheets 🤖 AI-Powered Outreach** Generates personalized emails using Claude AI 📧 Automated Sending** Sends emails directly through Gmail integration 🔄 How It Works User Input: Submit location, country, and business category through a form AI Location Analysis: Gemini AI identifies sub-locations within the specified area Yelp Scraping: BrightData extracts business information from multiple locations Data Processing: Cleans and stores business details in Google Sheets Trustpilot Verification: Scrapes reviews and company details for credibility check Email Generation: Claude AI creates personalized outreach messages Automated Outreach: Sends emails to qualified prospects via Gmail 📊 Data Output | Field | Description | Example | |---------------|----------------------------------|----------------------------------| | Company Name | Business name from Yelp/Trustpilot | Best Local Restaurant | | Website | Company website URL | https://example-restaurant.com | | Phone Number | Business contact number | (555) 123-4567 | | Email | Business email address | [email protected] | | Address | Physical business location | 123 Main St, City, State | | Rating | Overall business rating | 4.5/5 | | Categories | Business categories/tags | Restaurant, Italian, Fine Dining | 🚀 Setup Instructions ⏱️ Estimated Setup Time: 10–15 minutes Prerequisites n8n instance (self-hosted or cloud) Google account with Sheets access BrightData account with Yelp and Trustpilot datasets Google Gemini API access Anthropic API key for Claude Gmail account for sending emails Step 1: Import the Workflow Copy the JSON workflow code In n8n: Workflows → + Add workflow → Import from JSON Paste JSON and click Import Step 2: Configure Google Sheets Integration Create two Google Sheets: Yelp data: Name, Categories, Website, Address, Phone, URL, Rating Trustpilot data: Company Name, Email, Phone Number, Address, Rating, Company About Copy Sheet IDs from URLs In n8n: Credentials → + Add credential → Google Sheets OAuth2 API Complete OAuth setup and test connection Update all Google Sheets nodes with your Sheet IDs Step 3: Configure BrightData Set up BrightData credentials in n8n Replace API token with: BRIGHT_DATA_API_KEY Verify dataset access: Yelp dataset: gd_lgugwl0519h1p14rwk Trustpilot dataset: gd_lm5zmhwd2sni130p Test connections Step 4: Configure AI Models Google Gemini (Location Analysis)** Add Google Gemini API credentials Configure model: models/gemini-1.5-flash Claude AI (Email Generation)** Add Anthropic API credentials Configure model: claude-sonnet-4-20250514 Step 5: Configure Gmail Integration Set up Gmail OAuth2 credentials in n8n Update "Send Outreach Email" node Test email sending Step 6: Test & Activate Activate the workflow Test with sample data: Country: United States Location: Dallas Category: Restaurants Verify data appears in Google Sheets Check that emails are generated and sent 📖 Usage Guide Starting a Lead Generation Campaign Access the form trigger URL Enter your target criteria: Country: Target country Location: City or region Category: Business type (e.g., restaurants) Submit the form to start the process Monitoring Results Yelp Data Sheet:** View scraped business information Trustpilot Sheet:** Review credibility data Gmail Sent Items:** Track outreach emails sent 🔧 Customization Options Modifying Email Templates Edit the "AI Generate Email Content" node to customize: Email tone and style Services mentioned Call-to-action messages Branding elements Adjusting Data Filters Modify rating thresholds Set minimum review counts Add geographic restrictions Filter by business size Scaling the Workflow Increase batch sizes Add delays between requests Use parallel processing Add error handling 🚨 Troubleshooting Common Issues & Solutions BrightData Connection Failed Cause: Invalid API credentials or dataset access Solution: Verify credentials and dataset permissions No Data Extracted Cause: Invalid location or changed page structure Solution: Verify location names and test other categories Gmail Authentication Issues Cause: Expired OAuth tokens Solution: Re-authenticate and check permissions AI Model Errors Cause: API quota exceeded or invalid keys Solution: Check usage limits and API key Performance Optimization Rate Limiting:** Add delays Error Handling:** Retry failed requests Data Validation:** Check for malformed data Memory Management:** Process in smaller batches 📈 Use Cases & Examples Digital Marketing Agency Lead Generation Goal:** Find businesses needing marketing Target:** Restaurants, retail stores Approach:** Focus on good-rated but low-online-presence businesses B2B Sales Prospecting Goal:** Find software solution clients Target:** Growing businesses Approach:** Focus on recent positive reviews Partnership Development Goal:** Find complementary businesses Target:** Established businesses Approach:** Focus on reputation and satisfaction scores ⚡ Performance & Limits Expected Performance Processing Time:** 5–10 minutes/location Data Accuracy:** 90%+ Success Rate:** 85%+ Daily Capacity:** 100–500 leads Resource Usage API Calls:** ~10–20 per business Storage:** Minimal (Google Sheets) Execution Time:** 3–8 minutes/10 businesses Network Usage:** ~5–10MB/business 🤝 Support & Community Getting Help n8n Community Forum:** community.n8n.io Docs:** docs.n8n.io BrightData Support:** Via dashboard Contributing Share improvements Report issues and suggestions Create industry-specific variations Document best practices > 🔒 Privacy & Compliance: Ensure GDPR/CCPA compliance. Always respect robots.txt and terms of service of scraped sites. 🎯 Ready to Generate Leads! This workflow provides a complete solution for automated lead generation and outreach. Customize it to fit your needs and start building your pipeline today! For any questions or support, please contact: 📧 [email protected] or fill out this form: Contact Us

Overview Manual financial reconciliation is tedious and prone to error. This workflow functions as an AI Financial Controller, automatically monitoring your inbox for invoices, receipts, and bills, extracting the data using OCR, and syncing it to Google Sheets for approval. Unlike simple scrapers, this workflow uses a "Guardrail" AI agent to filter out non-financial emails (like newsletters) before they are processed, ensuring only actual transactions are recorded. Who is it for? Finance Teams:** To automate the collection of vendor invoices. Freelancers:** To track expenses and receipts for tax season. Operations Managers:** To monitor budget spend and categorize costs automatically. How it works Ingest: The workflow watches a specific Gmail label (e.g., "INBOX") for new emails. Guardrail: A Gemini-powered AI agent analyzes the email text to determine if it is a valid financial transaction. If not, the workflow stops. Extraction (OCR): If an attachment exists: An AI Agent (GPT-4o) extracts data from the PDF. If no attachment: An AI Agent extracts data directly from the email body. Validation: Code nodes check for missing fields or invalid amounts. Business Logic: The system automatically assigns General Ledger (GL) categories (e.g., "Uber" -> "Travel") and sets approval statuses based on amount thresholds. Sync: Validated data is logged to Google Sheets, and a confirmation email is sent. Errors are logged to a separate error sheet. How to set up Google Sheets: Copy this Google Sheet template to your drive. It contains the necessary tabs (Invoices, Error Logs, Success Metrics). Configure Workflow: Open the node named "Configuration: User Settings". Paste your Google Sheet ID (found in the URL of your new sheet). Enter the Admin Email address where you want to receive error notifications. Credentials: Connect your Gmail account. Connect your Google Sheets account. Connect your OpenAI (for OCR) and Google Gemini/PaLM (for Guardrails) accounts. Requirements n8n version 1.0 or higher. Gmail account. OpenAI API Key. Google Gemini (PaLM) API Key.

AI powered content creation and WordPress publishing workflow Summary This workflow automates the entire process of blog content creation, from idea generation and article writing using Google Gemini, to sourcing images from Pexels and publishing directly to your WordPress site. It uses Google Sheets as a central hub for managing content ideas and tracking their status, all orchestrated through interactive n8n forms. Key features AI driven content:** Leverages Google Gemini for generating: Full blog articles based on prompts. Relevant keywords for image searching. New blog topic ideas. Automated image sourcing:** Searches Pexels for suitable images based on AI generated keywords and downloads them. WordPress integration:** Creates new posts with AI generated title and content. Uploads sourced images to the WordPress media library. Sets the uploaded image as the featured image for the post. Google Sheets management:** Fetches content ideas (prompts) marked as "not generated". Updates the sheet after a post is generated with the post ID, title, and generation date. Adds newly AI generated blog topic ideas to the sheet. Interactive forms:** Main trigger form to choose between generating content or adding new ideas. Forms to input topics for idea generation. Confirmation forms at the end of processes. Structured output parsing:** Ensures AI responses for topic generation are correctly formatted as JSON. How it works The workflow is initiated via an n8n Form Trigger: Select Action, allowing the user to choose one of two main paths: Generate content path: Fetch idea: The Fetch unprocessed ideas (Google Sheets) node retrieves a row from your sheet where the "Generated" column is "no". Set prompt: The Set prompt node prepares the topic from the sheet for the AI. Generate article: The Generate article AI (Langchain Agent with Google Gemini) node takes the prompt and writes a full article. Generate image keyword: The Generate image keyword AI (Langchain Agent with Google Gemini) node creates a concise search term based on the article topic. Search image: The Search Pexels image (HTTP Request) node uses the generated keyword to find a relevant image via the Pexels API. Create WordPress post: The Create WordPress post node publishes the AI generated article and initial image metadata to your WordPress site. Download and upload image: The Download Pexels image (HTTP Request) node fetches the actual image file, and the Upload image (HTTP Request) node uploads it to your WordPress media library. Set featured image: The Set featured image (HTTP Request) node links the uploaded image as the featured image for the newly created post. Update sheet: The Update Google Sheet node marks the idea as "yes" in your Google Sheet and adds the WordPress post ID and title. Confirmation: A Form: End post generation node displays a completion message. Add ideas path: Input topic: The Form: Enter topic for ideas node prompts the user to enter a general subject. Generate topics: The Generate blog topics AI (Langchain Agent with Google Gemini and Structured Output Parser) node generates five SEO friendly blog topic ideas based on the user's input, formatted as JSON. Process topics: The Split topics node separates the generated list of topics into individual items. Add to sheet: For each topic, the Add ideas to sheet (Google Sheets) node appends it as a new row, marked with "Generated: no". Loop or end: The Form: Add more topics? node asks the user if they want to generate more ideas or end the process. If "NEXT", it loops back to the Form: Enter topic for ideas. If "END", a Form: End idea generation node displays a completion message with the list of added topics. Nodes used Form Trigger If Google Sheets Set Langchain Agent (with Google Gemini Chat Model) Structured Output Parser (Langchain) HTTP Request (for Pexels API and WordPress Media/Post updates) WordPress Split Out Form (for user interaction and completion messages) Sticky Note (for instructions within the workflow) Setup instructions Credentials: Google Sheets: Configure your Google Sheets OAuth2 credentials in the Fetch unprocessed ideas, Update Google Sheet, and Add ideas to sheet nodes. WordPress: Configure your WordPress API credentials in the Create WordPress post, Upload image, and Set featured image nodes. Google Gemini: Configure your Google Gemini (PaLM) API key in the Gemini model for article, Gemini model for image keyword, and Gemini model for topics nodes. API keys and URLs: Pexels: In the Search Pexels image node, replace <YOUR_PEXELS_API_KEY> in the Authorization header with your actual Pexels API key. WordPress URL: In the Upload image and Set featured image nodes, replace <YOUR_WORDPRESS_URL> in the URL field with your WordPress site's domain (e.g., yourblog.com). Google Sheet configuration: Ensure your Google Sheet (specified by Document ID in Google Sheets nodes) has a sheet named Sheet1 (or update the Sheet Name parameter). The sheet should have at least the following columns: Prompt (for the blog idea/topic), Generated (to track status, e.g., "no" or "yes"), row_number (automatically populated by n8n when reading), Date, Title (for the final WordPress post title), Post ID. Activate the workflow. The Form Trigger: Select Action will provide a webhook URL to initiate the process. Customization ideas Modify the AI prompts in the Langchain Agent nodes for different tones, styles, or content structures. Change the Google Gemini models used for different cost/performance balances. Integrate other image sources instead of or in addition to Pexels. Add steps for social media sharing after a post is published. Extend the Google Sheet to track more metrics like word count or target keywords. Implement more sophisticated error handling. Use cases Automating blog content generation for personal or company blogs. Streamlining content marketing efforts. Quickly populating new websites with initial content. Assisting SEO agencies in creating draft content for clients. Helping solo bloggers maintain a consistent publishing schedule.

AI-Powered Product Research & SEO Content Automation Skip the guesswork and manual effort — this n8n flow automates the entire process of researching your product's online competition and generating high-quality SEO content. Whether you're launching a new product or optimizing existing listings, this workflow leverages real-time web data and AI-driven copywriting to deliver: 📈 Search-optimized metadata (Title, Description, Keywords) 🛍️ Engaging product descriptions tailored for marketing 📊 Auto-organized output ready for use in your content or e-commerce platform All of this happens with just one product title input! 🧠 How It Works • User submits a product title via a form. • The workflow uses Google Custom Search to gather real-time competitor content based on that title. • Titles, snippets, and keywords are extracted from the search results. • This information is sent to a language model (Google Gemini via LangChain) to generate: SEO-optimized metadata (Title, Description, Keywords) A compelling product description tailored for marketing • The AI-generated content is then parsed and organized into two categories: SEO data and product content. • The structured output is saved automatically into a connected Google Sheet for easy access or further automation. 🛠️ What Problems Does This Solve? Manual competitor research and writing SEO content from scratch can be: Time-consuming** Inconsistent in quality** Not optimized for search engines** Hard to scale for multiple products** This workflow automates the entire research + writing + structuring process. ✅ Key Benefits Instant Content Creation**: Generate polished SEO content in seconds. Competitor-Aware**: Pulls in real-time data from the web for relevant, market-aligned content. Scalable**: Easily repeat the process for multiple product titles with minimal effort. Data Centralization**: Stores everything in Google Sheets—great for collaboration or syncing with other tools. Customizable**: Easily extend or modify the workflow to include translations, publishing, or social media automation. ⚙️ Set-Up Steps • Connect Google Custom Search API with a valid API key and search engine ID (CX). • Connect and configure Google Gemini or LangChain with access credentials. • Provide access to a Google Sheet with columns for storing SEO and product data. • Estimated setup time: ~15–25 minutes depending on API access and sheet setup. 🚀 Let’s Get You Started with Automating Your LinkedIn Posts! Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

Automated AI Content Creation & Instagram Publishing from Google Sheets This n8n workflow automates the creation and publishing of social media content directly to Instagram, using ideas stored in a Google Sheet. It leverages AI (Google Gemini and Replicate Flux) to generate concepts, image prompts, captions, and the final image, turning your content plan into reality with minimal manual intervention. Think of this as the execution engine for your content strategy. It assumes you have a separate process (whether manual entry, another workflow, or a different tool) for populating the Google Sheet with initial post ideas (including Topic, Audience, Voice, and Platform). This workflow takes those ideas and handles the rest, from AI generation to final publication. What does this workflow do? This workflow streamlines the content execution process by: Automatically fetching** unprocessed content ideas from a designated Google Sheet based on a schedule. Using Google Gemini to generate a platform-specific content concept (specifically for a 'Single Image' format). Generating two distinct AI image prompt options based on the concept using Gemini. Writing an engaging, platform-tailored caption (including hashtags) using Gemini, based on the first prompt option. Generating a visual image using the first prompt option via the Replicate API (using the Flux model). Publishing* the generated image and caption directly to a connected Instagram Business account*. Updating the status** in the Google Sheet to mark the idea as completed, preventing reprocessing. Who is this for? Social Media Managers & Agencies:** Automate the execution of your content calendar stored in Google Sheets. Marketing Teams:** Streamline content production from planned ideas and ensure consistent posting schedules. Content Creators & Solopreneurs:** Save significant time by automating the generation and publishing process based on your pre-defined ideas. Anyone** using Google Sheets to plan social media content and wanting to automate the creative generation and posting steps with AI. Benefits Full Automation:** From fetching planned ideas to Instagram publishing, automate the entire content execution pipeline. AI-Powered Generation:** Leverage Google Gemini for creative concepts, prompts, and captions, and Replicate for image generation based on your initial topic. Content Calendar Execution:** Directly turn your Google Sheet plan into published posts. Time Savings:** Drastically reduce the manual effort involved in creating visuals and text for each planned post. Consistency:** Maintain a regular posting schedule by automatically processing your queue of ideas. Platform-Specific Content:** AI prompts are designed to tailor concepts, prompts, and captions for the platform specified in your sheet (e.g., Instagram or LinkedIn). How it Works Scheduled Trigger: The workflow starts automatically based on the schedule you set (e.g., every hour, daily). Fetch Idea: Reads the next row from your Google Sheet where the 'Status' column indicates it's pending (e.g., '0'). It only fetches one idea per run. Prepare Inputs: Extracts Topic, Audience, Voice, and Platform from the sheet data. AI Concept Generation (Gemini): Creates a single content concept suitable for a 'Single Image' post on the target platform. AI Prompt Generation (Gemini): Develops two detailed, distinct image prompt options based on the concept. AI Caption Generation (Gemini): Writes a caption tailored to the platform, using the first image prompt and other context. Image Generation (Replicate): Sends the first prompt to the Replicate API (Flux model) to generate the image. Prepare for Instagram: Formats the generated image URL and caption. Publish to Instagram: Uses the Facebook Graph API in three steps: Creates a media container by uploading the image URL and caption. Waits for Instagram to process the container. Publishes the processed container to your feed. Update Sheet: Changes the 'Status' in the Google Sheet for the processed row (e.g., to '1') to mark it as complete. n8n Nodes Used Schedule Trigger Google Sheets (Read & Update operations) Set (Multiple instances for data preparation) Langchain Chain - LLM (Multiple instances for Gemini calls) Langchain Chat Model - Google Gemini (Multiple instances) Langchain Output Parser - Structured (Multiple instances) HTTP Request (for Replicate API call) Wait Facebook Graph API (Multiple instances for Instagram publishing steps) Prerequisites Active n8n instance (Cloud or Self-Hosted). Google Account** with access to Google Sheets. Google Sheets API Credentials (OAuth2):** Configured in n8n. A Google Sheet** structured with columns like Topic, Audience, Voice, Platform, Status (or similar). Ensure your 'pending' and 'completed' statuses are defined (e.g., '0' and '1'). Google Cloud Project** with the Vertex AI API enabled. Google Gemini API Credentials:** Configured in n8n (usually via Google Vertex AI credentials). Replicate Account** and API Token. Replicate API Credentials (Header Auth):** Configured in n8n. Facebook Developer Account**. Instagram Business Account** connected to a Facebook Page. Facebook App** with necessary permissions: instagram_basic, instagram_content_publish, pages_read_engagement, pages_show_list. Facebook Graph API Credentials (OAuth2):** Configured in n8n with the required permissions. Setup Import the workflow JSON into your n8n instance. Configure Schedule Trigger: Set the desired frequency (e.g., every 30 minutes, every 4 hours) for checking new ideas in the sheet. Configure Google Sheets Nodes: Select your Google Sheets OAuth2 credentials for both Google Sheets nodes. In 1. Get Next Post Idea..., enter your Spreadsheet ID and Sheet Name. Verify the Status filter matches your 'pending' value (e.g., 0). In 7. Update Post Status..., enter the same Spreadsheet ID and Sheet Name. Ensure the Matching Columns (e.g., Topic) and the Status value to update match your 'completed' value (e.g., 1). Configure Google Gemini Nodes: Select your configured Google Vertex AI / Gemini credentials in all Google Gemini Chat Model nodes. Configure Replicate Node (4. Generate Image...): Select your Replicate Header Auth credentials. The workflow uses black-forest-labs/flux-1.1-pro-ultra by default; you can change this if needed. Configure Facebook Graph API Nodes (6a, 6c): Select your Facebook Graph API OAuth2 credentials. Crucially, update the Instagram Account ID in the Node parameter of both Facebook Graph API nodes (6a and 6c). The template uses a placeholder (17841473009917118); replace this with your actual Instagram Business Account ID. Adjust Wait Node (6b): The default wait time might be sufficient, but if you encounter errors during publishing (especially with larger images/videos in the future), you might need to increase the wait duration. Activate the workflow. Populate your Google Sheet: Ensure you have rows with your content ideas and the correct 'pending' status (e.g., '0'). The workflow will pick them up on its next scheduled run. This workflow transforms your Google Sheet content plan into a fully automated AI-powered Instagram publishing engine. Start automating your social media presence today!

How it works This workflow automates your initial hiring pipeline by creating an AI-powered CV scanner. It collects job applications through a web form, uses AI to analyze the candidate's CV against your job description, and neatly organizes the results in a Google Sheet. Here’s the step-by-step process: The Application Form:** A Form Trigger provides a public web form for candidates to submit their name, email, and CV (as a PDF). Initial Logging:** As soon as an application is submitted, the candidate's name and email are added to a Google Sheet. This ensures every applicant is logged, even if a later step fails. CV Text Extraction:* The workflow uses Mistral's OCR* model to accurately extract all the text from the uploaded CV PDF. AI Analysis:* The extracted text is sent to Google Gemini*. A detailed prompt instructs the AI to act as a hiring assistant, scoring the CV against the specific requirements of your job role and providing a detailed explanation for its score. Structured Output:** A JSON Output Parser ensures the AI's analysis is returned in a clean, structured format, making the data reliable. Final Record:** The AI-generated qualification score and explanation are added to the candidate's row in the Google Sheet, giving you a complete, analyzed list of applicants. Set up steps Setup time: ~15 minutes You'll need API keys for Mistral and Google AI, and to connect your Google account. Get Your Mistral API Key: Visit the Mistral Platform at console.mistral.ai/api-keys. Create and copy your API key. In the workflow, go to the Extract CV Text node, click the Credential dropdown, and select + Create New Credential. Paste your key into the API Key field and Save. Get Your Google AI API Key: Visit Google AI Studio at aistudio.google.com/app/apikey. Click "Create API key in new project" and copy the key. In the workflow, go to the Gemini 2.5 Flash Lite node, click the Credential dropdown, and select + Create New Credential. Paste your key into the API Key field and Save. Connect Your Google Account: Select the Create 'CVs' Spreadsheet node. Click the Credential dropdown and select + Create New Credential to connect your Google account. Repeat this for the Log Candidate Submission and Add CV Analysis nodes, selecting the credential you just created. Create Your Spreadsheet: Click the "play" icon on the Start Here node to run it. This will create a new Google Sheet in your Google Drive named "CVs" with the correct columns. Customize the Job Role: Go to the AI Qualification node. In the Text parameter, find the job_requirements section and replace the example job description with your own. Be as detailed as possible for the best results. Start Screening! Activate the workflow using the toggle at the top right. Go to the Application Form node and click the "Open Form URL" button. Fill out the form with a test application and upload a sample CV. Check your Google Sheet to see the AI's analysis appear within moments

🚀 AI Resume Screener (n8n Workflow Template) An AI-powered resume screening system that automatically evaluates applicants from a simple web form and gives you clear, job-specific scoring — no manual filtering needed. ⚡ What the workflow does 📄 Accepts CV uploads via a web form (PDF) 🧠 Extracts key info using AI (education, skills, job history, city, birthdate, phone) 🎯 Dynamically matches the candidate to job role criteria stored in Google Sheets 📝 Generates an HR-style evaluation and a numeric score (1–10) 📥 Saves the result in a Google Sheet and uploads the original CV to Google Drive 💡 Why you’ll love it FeatureBenefitAI scoringInstantly ranks candidate fit without reading every CVGoogle Sheet-drivenEasily update job profiles — no code changesFast setupConnect your accounts and you're live in ~15 minsScalableWorks for any department, team, or organizationDeveloper-friendlyExtend with Slack alerts, translations, or automations 🧰 Requirements 🔑 OpenAI or Google Gemini API Key 📄 Google Sheet with 2 columns: Role, Profile Wanted ☁️ Google Drive account 🌐 n8n account (self-hosted or cloud) 🛠 Setup in 5 Steps Import the workflow into n8n Connect Google Sheets, Drive, and OpenAI or Gemini Add your job roles and descriptions in Google Sheets Publish the form and test with a sample CV Watch candidate profiles and scores populate automatically 🤝 Want help setting it up? Includes free setup guidance by the creator — available by email or WhatsApp after purchase. I’m happy to assist you in customizing or deploying this workflow for your team. 📧 Email: [email protected] 💬 WhatsApp: +20106 180 3236

Your inbox is overflowing with daily newsletters: Public Affairs, ESG, Legal, Finance, you name it. You want to stay informed, but reading 10 emails every morning? Impossible. What if you could get one single digest summarizing everything that matters, automatically? ❌ No more copy-pasting text into ChatGPT ❌ No more scrolling through endless email threads ✅ Just one smart, structured daily briefing in your inbox Who Is This For Public Affairs Teams: Stay ahead of political and regulatory updates—without drowning in emails. Executives & Analysts: Get daily summaries of key insights from multiple newsletters. Marketing, Legal, or ESG Departments: Repurpose this workflow for your own content sources. How It Works Gmail collects all newsletters from the day (based on sender or label). HTML noise and formatting are stripped automatically. Long texts are split into chunks and logged in Google Sheets. An AI Agent (Gemini or OpenAI) summarizes all content into one clean daily digest. The workflow structures the summary into an HTML email and sends it to your chosen recipients. Setup Guide • You’ll need Gmail and Google Sheets credentials. • Add your own AI Model (e.g., Gemini or OpenAI) with an API key. • Adjust the prompt inside the “Public Affairs Consultant” node to fit your topic (e.g., Legal, Finance, ESG, Marketing). • Customize the email subject and design inside the “Structure HTML-Mail” node. • Optional: Use Memory3 to let the AI learn your preferred tone and style over time. Cost & Runtime Runs once per day. Typical cost: ~$0.10–0.30 per run (depending on model and input length). Average runtime: <2 minutes.

Extract data from any PDF or image invoice dropped in Google Drive directly into Google Sheets – powered by AI OCR. Free, fully modifiable n8n workflow. Optional add-ons for pro features. 🚀 What this template does Stop typing invoice data by hand. Drop a PDF or phone-snapshot into your Invoices Inbox folder in Google Drive and this n8n workflow will: Auto-OCR the document with the Mistral OCR API Match any fields you list in Row 1 of your Google Sheet (totally schema-agnostic) Append a clean, structured row – every time Works with both PDFs and images, in any language supported by Mistral. Template JSON included, ready to import into self-hosted or n8n Cloud 👀 Who’s this for? Freelancers & agencies processing client invoices Small finance teams on Google Workspace Anyone self-hosting n8n who wants an AI OCR flow without glue-code No coding skills required – but flow tweaking is possible for power users. 🛠 Upcoming PRO Add-Ons I am also working on PRO add-ons for this template: Add-On #1 – Error Handling & Alerts (ships Jul 2025)• Flags missing fields, branches to Email/Slack notification; prevents silent failures Add-On #2 – Auto-Currency Converter (ships Jul 2025)• Detects invoice currency symbol/code → converts Total into your base currency via a free FX API Add-On #3 – VAT / GST Breakdown (ships Jul 2025)• Extracts VAT number, net, tax rate, tax amount, gross – ready for EU/UK/AU filings To pre-order these please see: https://ysqander.gumroad.com/l/N8N-AI-Workflow-Invoice-Data-Extraction-LITE

Notice Community nodes can only be installed on self-hosted instances of n8n. Description This workflow automates the process of scraping local business data from Google Maps and enriching it using AI to generate lead profiles. It's designed to help sales, marketing, and outreach teams collect high-quality B2B leads from Google Maps and enrich them with contextual insights without manual data entry. Overview This workflow scrapes business listings from Google Maps, extracts critical information like name, category, phone, address, and website using Bright Data, and passes the results to Google Gemini to generate enriched summaries and lead insights such as company description, potential services offered, and engagement score. The data is then structured and stored in spreadsheets for outreach. Tools Used n8n: The core automation engine to manage flow and trigger actions. Bright Data: Scrapes business information from Google Maps at scale with proxy rotation and CAPTCHA-solving. Google Gemini: Enriches the raw scraped data with smart business summaries, categorization, and lead scoring. Google Sheets : For storing and acting upon the enriched leads. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Set Up Bright Data: Insert your Bright Data credentials and configure the Google Maps scraping proxy endpoint. Configure Gemini API: Add your Google Gemini API key (or use via Make.com plugin). Customize the Inputs: Choose your target location, business category, and number of results per query. Choose Storage: Connect to your preferred storage like Google Sheets. Test and Deploy: Run a test scrape and enrichment before deploying for bulk runs. Use Cases Sales Teams: Auto-generate warm B2B lead lists with company summaries and relevance scores. Marketing Agencies: Identify local business prospects for SEO, web development, or ads services. Freelancers: Find high-potential clients in specific niches or cities. Business Consultants: Collect and categorize local businesses for competitive analysis or partnerships. Recruitment Firms: Identify and score potential company clients for talent acquisition. Connect with Me Email: [email protected] LinkedIn: https://www.linkedin.com/in/ranjan-dailata/ Get Bright Data: Bright Data (Supports free workflows with a small commission) #n8n #automation #leadscraping #googlemaps #brightdata #leadgen #b2bleads #salesautomation #nocode #leadprospecting #marketingautomation #googlemapsdata #geminiapi #googlegemini #aiworkflow #scrapingworkflow #businessleads #datadrivenoutreach #crm #workflowautomation #salesintelligence #b2bmarketing

This workflow makes it easier to keep track of the stocks market and get an email with a summary of the daily highlights on what happened, key insights and trends Setup Guide Define the schedule (days, times, intervals). Replace sample stock data with your desired stock list (ticker, name, etc.) in JSON format. Split Out the fields to have a clean list of the stocks to monitor set keyword node Extracts the stock ticker from each item and sets it to the keyword property. Financial times scraper Triggers the Bright Data Datasets API to scrape financial data. Set the node as below Method: POST URL: https://api.brightdata.com/datasets/v3/trigger Query Parameters: dataset_id: Replace with your Bright Data dataset ID. include_errors: true type: discover_new discover_by: keyword Headers: Authorization: Bearer YOUR_BRIGHTDATA_API_KEY Replace with your Bright Data API key. Body: JSON, ={{ $('set keyword').all().map(item => item.json)}} Execute Once: Checked. Get progress node Checks the status of the Bright Data scraping job if complete, or running Setup: URL: https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }} Headers: Authorization: Bearer YOUR_BRIGHTDATA_API_KEY Replace with your Bright Data API key. Get snapshot + data retrieves the scraped data from the Bright Data API. Pass the request as URL: https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }} Query Parameters: format: json Headers: Authorization: Bearer YOUR_BRIGHTDATA_API_KEY Replace with your Bright Data API key. Aggregate. Combines the data from each stock item into a single object Update to sheet and add all items to This sheet. Make a copy before you can map the data create summary node generates a summary of the scraped stock data using the Google Gemini AI model and notifies you via Gmail. Setup: Prompt Type: define Text: Customize the prompt to define the AI's role, input format, tasks, output format (HTML email), and constraints. Google Sheets. Appends the scraped data to a Google Sheet. This should be set to automap so as to adjust to the results found in the request Important Notes: Remember to replace placeholder values (API keys, dataset IDs, email addresses, Google Sheet IDs) with your actual values. Review and customize the AI prompt for the "create summary" node to achieve the desired email summary output. Consider adding error handling for a more robust workflow. Monitor API usage to avoid rate limits.

🤖 Interactive Academic Chatbot (Telegram + MongoDB) Overview 📋 This project is a template for building a complete academic virtual assistant using n8n. It connects to Telegram, answers frequently asked questions by querying MongoDB, keeps the community informed about key dates (via web scraping), and collects user feedback for continuous improvement. How It Works Architecture and Workflow ⚙️ n8n: Orchestration of 3 workflows (chatbot, scraping worker, announcer). Telegram: Frontend for user interaction and sending announcements. MongoDB: Centralized database for FAQs, academic calendar, and feedback logs. Web Scraping: HTTP Request and HTML Extract nodes to read the university's web calendar. Cron: For automatic periodic executions (daily and weekly). Core Processes 🧠 Real-time reception of user queries via Telegram. Querying MongoDB collections for FAQ answers and calendar dates. Daily scraping of the university website to keep the calendar updated. Instant logging of user feedback (👍/👎) in MongoDB. Proactive sending of weekly announcements to the Telegram channel. Key Benefits ✅ Complete automation of student communication 24/7. An always-accurate academic calendar database without manual intervention. A built-in continuous improvement system through user feedback. Proactive communication of important events to the entire community. Use Cases 💼 Automation of student support in universities, colleges, and institutions. A virtual assistant for any organization needing to manage FAQs and a dynamic calendar. An automated announcements channel to keep a community informed. Requirements 👨‍💻 n8n instance (self-hosted or cloud). Credentials for a Telegram Bot (obtained from @BotFather). Credentials for a MongoDB database (Connection URI). URL of the academic calendar to be scraped. Authors 👥 Doménica Amores Nicole Guevara Adrián Villamar Mentor: Jaren Pazmiño Applicants to the CIAP Polytechnic Artificial Intelligence Club

How it works Your WhatsApp AI Assistant automatically handles customer inquiries by linking your Google Docs knowledge base to incoming WhatsApp messages. The system instantly processes customer questions, references your business documentation, and delivers AI-powered responses through OpenAI or Gemini - all without you lifting a finger. Works seamlessly in individual chats and WhatsApp groups where the assistant can respond on your behalf. Set up steps Time to complete: 15-30 minutes Step 1: Create your WhapAround account and connect your WhatsApp number (5 minutes) Step 2: Prepare your Google Doc with business information and add the document ID to the system (5 minutes) Step 3: Configure the WhatsApp webhook and map message fields (10 minutes) Step 4: Connect your OpenAI or Gemini API key (3 minutes) Step 5: Send a test message to verify everything works (2 minutes) Optional: Set up PostgreSQL database for conversation memory and configure custom branding/escalation rules (additional 15-20 minutes) Detailed technical configurations, webhook URLs, and API parameter settings are provided within each workflow step to guide you through the exact setup process.

Automated Invoice-Processing AI Agent for n8n Overview The Automated Invoice-Processing AI Agent in n8n is designed to streamline and optimize invoice management for finance teams and accounts payable (AP) professionals. This solution addresses the common challenge of verifying invoice data manually, cross-checking it against purchase orders (POs), and ensuring compliance before releasing payments. By intelligently fetching invoices from Google Drive, extracting key details, validating them against PO records from Google Sheets, and automating the next actions, this system reduces human intervention, minimizes errors, and accelerates the payment process. Target Audience This automation primarily serves finance and AP teams responsible for managing large volumes of vendor invoices. It also supports finance managers, procurement departments, and auditors who require accuracy in payment reconciliation, ensuring that invoices align with approved POs before processing. Business Problem Addressed Organizations frequently struggle with time-consuming manual invoice verification and data entry. Discrepancies between invoices and purchase orders can lead to payment delays, compliance risks, or duplicate payments. This n8n-based AI agent automates that process—ensuring that every invoice is validated, exceptions are flagged to the finance team promptly, and payments of smaller value (under defined thresholds) are processed automatically. Prerequisites Active n8n account or self-hosted instance Google Drive and Google Sheets connected via n8n credentials LLM (AI node) configured for document extraction (optional but recommended) A Google Sheet set up with existing PO data (including PO Number, Amount, and Date fields) Setup Instructions Connect Google Drive and Google Sheets integrations within n8n. Configure the workflow trigger to monitor a designated "Invoices" folder. Add a document-parsing node to extract invoice details such as PO Number, Invoice Date, and Amount. Implement conditional logic: If the invoice amount > 5000, the agent cross-references PO details from the Google Sheet. If it matches, it updates the PO sheet status to “Process Payment.” If not, an automated email notifies the finance team. If the amount ≤ 5000, the workflow marks it for direct payment. Test the workflow with sample invoices before full deployment. Customization Options Adjust the payment threshold value (e.g., 10,000 instead of 5,000). Customize the email notification template and recipient list. Integrate with accounting systems such as QuickBooks or SAP for end-to-end automation. Add audit logging nodes to create traceability for every action taken. This AI-driven automation brings speed, accuracy, and scalability to invoice verification—empowering finance professionals to focus on analytical and strategic tasks rather than repetitive manual work.

CV → Match → Screen → Decide, all automated This workflow automatically processes candidate CVs from email, intelligently matches them to job descriptions, performs AI-powered screening analysis, and sends actionable summaries to your team in Slack. Good to know Handles both PDF and Word document CVs automatically Two-stage JD matching: prioritizes role mentioned in candidate's email, falls back to CV analysis if needed Uses Google Gemini API for AI screening (generous free tier and rate limits, typically enough to avoid paying for API requests, but check latest pricing at Google AI Pricing) All CVs stored in Google Drive with standardized naming (candidate name + date/time) Complete audit trail logged in Google Sheets Who's it for Hiring teams and recruiters who want to automate first-round CV screening while maintaining quality. Perfect for companies receiving high volumes of applications across multiple roles, especially in tech, sales, or automation-focused positions. How it works Gmail monitors inbox for CVs with specific label and downloads attachments Detects file type (PDF or Word) and converts/standardizes format for text extraction AI agent matches candidate to best-fit job description by analyzing email context first (if candidate mentioned a role), or CV content as fallback (selects up to 3 potential JD matches) If multiple JDs matched, second AI agent selects the single best fit AI recruiter agent analyzes CV against selected JD and generates structured screening report (strengths, weaknesses, risk/reward factors, overall fit score 0-10 with justification) Extracts candidate details (name, email) from CV text Logs complete analysis to Google Sheets tracker Sends formatted summary to Slack with Proceed/Reject action buttons for instant team decisions Requirements Gmail account with API access Google Drive account (OAuth2) Google Sheets account (OAuth2) Slack workspace with bot permissions Google Gemini API key (Get free key here) Google Drive folders: one for CVs, one for Job Descriptions (as PDFs or Google Docs) How to set up Add credentials: Gmail OAuth2, Google Drive OAuth2, Google Sheets OAuth2, Slack OAuth2, Google Gemini API Create Gmail label (e.g., "CV-Screening") for incoming candidate emails In "Receive CV via Email" node: select your Gmail label for filtering Create two Google Drive folders: "Candidate CVs" and "Job Descriptions" In "Upload CV - PDF" and "Stream Doc/Docx File" nodes: update folder ID to your "Candidate CVs" folder In "Access JD Files" node: update folder ID to your "Job Descriptions" folder Create Google Sheet named "AI Candidate Screening" with columns matching the sample AI Candidate Screening sheet In "Append row in sheet" node: select your Google Sheet In "Send Candidate Screening Confirmation" node: select your Slack channel Activate workflow Customizing this workflow Change JD matching logic: Edit "JD Matching Agent" node prompt to adjust how CVs are matched to roles (e.g., weight technical skills vs. experience). Change "Company Description" in AI prompts: Insert your "Company Description" in System Message sections in "JD Matching Agent" and "Detailed JD Matching Agent" nodes Modify screening criteria: Edit "Recruiter Scoring Agent" node system message to focus on specific qualities (culture fit, leadership, technical depth, etc.) Add more storage locations: Add nodes to save CVs to other systems (Notion, Airtable, ATS platforms) Customize Slack message: Edit "Send Candidate Screening Confirmation" node to change formatting, add more context, or include additional candidate data Auto-proceed logic: Add IF node after screening to auto-proceed candidates with fit score above threshold (e.g., 8+/10) Add email responses: Connect nodes to automatically email candidates (confirmation, rejection, interview invite) Add human-in-the-loop: Sub-workflow triggered by Slack response or email response, to update Sheet with approve/reject status Add candidate email responses + interview scheduling**: For approved candidates, trigger email to candidate with Cal.com or Calendly link so they can book their interview Quick Troubleshooting No CVs being processed: Check Gmail label is correctly set in "Receive CV via Email" node and emails are being labeled Word documents failing: Verify "Stream Doc/Docx File" node has correct parent folder ID and Google Drive credentials authorized JD matching returns no results: Check "Access JD Files" node folder ID points to your Job Descriptions folder, and JD files are named clearly (e.g., "Marketing Director JD.pdf") JD matching is not relevant for my company: Update the "Company Description" in the System Messages in the "JD Matching Agent" and "Detailed JD Matching Agent" nodes "Can't find matching JD": Ensure candidate's email mentions role name OR their CV clearly indicates relevant experience for available JDs Google Sheets errors: Verify sheet name is "AI Candidate Screening" and column headers exactly match workflow expectations (Submission ID, Date, CV, First Name, etc.) Slack message not appearing: Re-authorize Slack credentials and confirm channel ID in "Send Candidate Screening Confirmation" node Missing candidate name/email: CV text must be readable - check PDF extraction quality or try converting complex CVs to simpler format 401/403 API errors: Re-authorize all OAuth2 credentials (Gmail, Google Drive, Google Sheets, Slack) AI analysis quality issues: Edit system prompts in "JD Matching Agent" and "Recruiter Scoring Agent" nodes to refine screening criteria Sample Outputs Google Sheets - AI Candidate Screening - sample Slack confirmation message Acknowledgments This workflow was inspired by Nate Herk's YouTube demonstration on building a resume analysis system. This implementation builds upon that foundation by adding dynamic job description matching (initial + detailed JD matching agents), Slack Block Kit integration with interactive buttons, updated Google Drive API methods for document handling, and enhanced candidate data capture in Google Sheets.

Translating your YouTube video titles and descriptions into multiple languages is one of the simplest ways to expand your channel's global reach. But doing it manually is super tedious and time-consuming. This n8n workflow automates the entire process: from detecting your latest video, translating its metadata into multiple languages using AI, to publishing the translated versions directly to YouTube - all managed and tracked through a connected Google Sheet only. What Problem Is This Workflow Solving? Manually translating YouTube metadata—titles, descriptions, and tags—is both time-consuming and costly, especially as your video library grows. For example, let's say you want to translate the metadata of 50 videos into 5 languages, and if you spend 10 minutes on each video, it could take over 40 hours of manual work. This workflow automates the localization of your YouTube metadata, making it fast and efficient to translate large volumes of content. Instead of spending days on translations, you can handle bulk updates in minutes: Save Time and Resources**: Instantly translate metadata for dozens or hundreds of videos, freeing you from repetitive, manual tasks. Expand Your Global Reach**: Enable your videos to appear in search results across multiple languages, reaching new audiences worldwide. Boost Engagement and SEO**: Localized metadata helps your videos get discovered and increases viewer engagement, leading to higher watch times and better performance. Make Content More Accessible**: Welcome viewers from different linguistic backgrounds, making your channel inclusive and inviting. Who Is This For? Use cases are many: This workflow is perfect for YouTubers who want to automate multilingual metadata updates and eliminate repetitive manual tasks. It’s especially useful for creators whose content is visually driven and easy to follow, such as: DIY and How-to Channels Travel and Nature Channels Fitness and Workout Channels Cooking Channels Art and Craft Channels How It Works Phase 1: Prepare Values & Auto Crawl Mode Set up a Schedule Trigger: In the **Schedule Trigger node in n8n, define your preferred interval to automatically run the workflow on a recurring schedule; no manual execution needed. Set Required Parameters: In the **Prepare Values node in n8n, you must enter the following: spreadsheet_id: to link the workflow to your connected Google Sheet channel_name: to specify which tab of the Google Sheet contains the video URLs to process channel_id: to define the YouTube channel the workflow will act upon Set Target Languages: In the **Languages tab of your connected Google Sheet, list all languages you'd like to generate translated titles and descriptions for. These will be used later during the translation phase. Choose Crawling Mode: In the **Auto tab of your Google Sheet, configure the Auto Crawl setting in Column B based on your preferred method: Select No (Turn off Auto Crawl): You must manually input the video URL(s) in the channel_name tab and set the status to Ready for 1 video only. Select Yes (Turn on Auto Crawl): The workflow will automatically fetch one of the latest videos from your connected YouTube channel (based on channel_id) into the channel_name tab in your Google Sheet. Phase 2: Trigger The Process Once everything is properly set up, the workflow in n8n can be activated - either manually or automatically via the Schedule Trigger, which runs based on the interval you’ve configured earlier. The tool then checks the Auto Crawl status in Column B in the Auto tab of your connected Google Sheet to determine the route: If Auto Crawl = No: The workflow skips auto-fetching and proceeds directly to the next phase, expecting that the video URL is already entered manually and marked as Ready in its status. If Auto Crawl = Yes: The tool connects to your YouTube channel using the predefined channel_id. It fetches one of the latest videos and checks whether that video’s ID already exists in the list of processed videos. If the video has not been processed yet, its URL will be inserted into the channel_name tab, and its status in Column A will automatically be set to Ready, ensuring it proceeds to the next step. If it already exists, the video is skipped to avoid reprocessing. ⚠️ Important: When Auto Crawl = Yes, do not manually add another URL and set its status to Ready in the channel_name tab in the Google Sheet. Doing so may trigger the same video twice, causing data conflicts and redundant processing. Phase 3: Collect Video Information Once a new video URL appears in your connected Google Sheet and its status is set Ready in Column A (under the specified channel_name tab), the workflow picks it up automatically. Then, it extracts the Video ID from the URL and sends a GET request to the YouTube API to retrieve that video’s title and description in your channel’s default language for the next steps. Phase 4: Generate Translated Metadata In Preset Languages The tool reads your target languages from the Languages tab in your connected Google Sheet. A loop runs through each language code one at a time. For each language, the tool sends your original title and description to Google Gemini’s Chat Model. Then, the AI returns the content translated into the target language. The output is returned in JSON data, then restructured to ensure each language’s data is clearly separated and ready for the next step. Phase 5: Update Translated Metadata On YouTube & Log Status All translated titles and descriptions from previous steps are combined into one structured format. The tool sends a PUT request to the YouTube API to update the video’s metadata directly with the new multilingual-translated content. If the update is successful, the video's status in Column A in the channel_name tab in the connected Google Sheet is marked as Success. If the update fails, the video’s status is marked as Error for later review or retry. How To Set Up Download the working package. Import the package into your n8n interface. Duplicate the Youtube - Update Video Metadata in Multi-Languages Google Sheet template into your Google Sheets account. For the channel_name tab in the template, you can rename it with your actual YouTube channel's name for easier tracking. Set up necessary credentials in Google Cloud Console for tools access and usability: For Google Sheets access, please ensure connection in the following nodes: Node Get Auto Crawl Status → connected to the Auto tab Node Check Latest Video ID → connected to the channel_name tab Node Insert Video Info → connected to the channel_name tab Node Get Video URL → connected to the channel_name tab Node Get Language List → connected to the Languages tab Node Update Status - Success → connected to the channel_name tab Node Update Status - Error → connected to the channel_name tab For YouTube access, ensure connection to YouTube API in the following nodes: Node YouTube - Get Latest Video Node Get Video Info Node Update Video Metadata with Selected Languages For Google Gemini access, ensure connection to Google Gemini API in the following node: Node Google Gemini’s Chat Model Set a Schedule Trigger in n8n to run the workflow automatically at your preferred interval. Define necessary parameters in Node Prepare Values in your n8n workflow: spreadsheet_id: your connected Google Sheet ID channel_name: the tab in your connected Google Sheet contains the video URLs and receives process updates (should be renamed with your actual YouTube channel’s name for easy tracking) channel_id: your YouTube channel ID Check the status of the Auto Crawl function in the Auto tab in your connected Google Sheet: By default, its status is No: You’ll manually insert a video URL and mark its row as Ready. In case you want to turn it on, please change it to Yes: The tool will automatically fetch the latest video(s) from your channel. Activate the workflow in n8n. To manually update a video: Set Auto Crawl to No Insert the video URL into the channel_name tab Set the status to Ready To automate with Auto Crawl: Set Auto Crawl to Yes The tool will auto-fetch one of the new videos and set its status to Ready Track results of the original row in the channel_name tab of your Google Sheet and YouTube: If the row’s status is Success, the metadata is updated on YouTube with all the set languages and you can check things out on the platform directly. If the row’s status is Error, you can do manual review or retry. Requirements Basic setup in Google Cloud Console with OAuth2 credentials in the following configurations: Google Sheets API enabled, with edit permissions on the connected spreadsheet YouTube API enabled, with an account that has Owner or Editor role on the target channel API access to Google Gemini for generating multilingual translated content via AI. How To Customize Adjust the trigger interval: Change the schedule in the **Schedule Trigger node to fit your needs (e.g. every 10 minutes, hourly, etc.). Add or remove target languages: Simply update the **Languages tab in your connected Google Sheet. No changes in n8n are required. Customize the translation style: You can edit the prompt inside the **AI node to change the tone, format, or style of the translations. However, do not modify the output structure format - doing so will break the workflow. Add alerts or notifications when finished**: Feel free to integrate additional nodes (like Telegram or Email) to notify you and your team when updates succeed or fail. FAQs: Can I use this workflow for more than one YouTube channel? Not directly. This workflow is currently designed to connect to a single YouTube channel ID at a time. However, if you’d like to manage multiple YouTube channels within one Google Sheet and a unified n8n interface, we can customize the setup for you. Feel free to reach out to Agent Circle for a tailored setup and guidance. What happens if I manually enter a video URL while Auto Crawl is ON? Avoid this. Manually adding a URL with status Ready in the channel_name tab while Auto Crawl = Yes may cause duplicate processing, API conflicts, or data overwrites. How many languages can I translate into at once? There's no strict limit. You can list as many languages as needed in the Languages tab in your connected Google Sheet. Refer to the All Languages tab in the Google Sheet template for valid languages and language codes (e.g., en, fr, es, de). Do I need to change anything in n8n when I add more languages? No - simply update the Languages tab in your connected Google Sheet. No work in n8n is needed for this. Can I change the AI model from Google Gemini to something else? Yes. You can replace the Google Gemini Chat Model node with another chat model, such as OpenAI GPT-4, or any compatible LLM provider. What happens if the metadata update to YouTube fails? The video's status in Column A of the channel_name tab in your connected Google Sheet will be marked Error. You can then review, fix, and re-run the process. Can I edit the translation prompt in the AI node for my own brand tone? Absolutely. You can customize the translation prompt in the AI node to adjust tone, format, or even brand voice. Just make sure the structure of the returned JSON remains intact. Is the workflow GDPR or YouTube policy-compliant? Yes - as long as you're the owner or have editor access to the YouTube channel and use the official YouTube API with proper OAuth2 authentication. Can I schedule this workflow to run every day? Yes. In the Schedule Trigger node in n8n, set your preferred interval - e.g., daily, every 12 hours, etc. Does this work with unlisted or private videos? No - YouTube API typically returns data only for public videos. For private/unlisted videos, additional permissions and scopes are required. If you need support for this case, feel free to contact Agent Circle for personalized consultation and setup assistance. 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

Social Media Spark (SMS) — Automated Viral Content Engine Automate your entire content workflow: discover viral ideas, generate posts in your tone, repurpose for X, and auto-publish — reducing 90% of manual effort. 🚀 What it Does Scrapes competitors or niche profiles on LinkedIn to find high-performing posts. Classifies and saves evergreen content ideas for later use. Generates fresh posts in your own voice with matching images. Repurposes content for X (Twitter) in a platform-optimized style. Automatically publishes content to LinkedIn and X on your schedule. Allows on-demand commands via Telegram for research or instant content generation. 🧩 Why Use It Save time:** no more manual scraping, idea collection, or formatting. Stay consistent:** maintain a daily content pipeline. Multi-platform leverage:** create once, adapt for LinkedIn and X. Creative control:** mix automation with optional human review. Scalable:** extend to more platforms, analytics, and workflows as you grow. 🔧 Prerequisites & Setup Before importing or activating the workflow, prepare these: AI Provider (OpenAI / Gemini / OpenRouter)** For classifying posts, generating new content, repurposing for X. Google Sheets** Central database for competitors, ideas, generated posts, and posting status. Google Drive** Stores generated images. Apify & Browseract** Scrapes LinkedIn profiles, posts, and performs research tasks. LinkedIn API** Needed for automated LinkedIn publishing. X (Twitter) API** Requires OAuth 1.0a for image uploads and OAuth 2.0 for text posting. Telegram Bot** Enables on-demand commands and notifications. Set your Telegram User ID in the trigger node. > 🔎 In each sub-workflow, look for nodes marked “Configure Me!” to replace example prompts, search keywords, sheet IDs, etc. ⚙️ How It Works (Simplified Flow) Scrape & Classify: Collect high-engagement posts → keep evergreen ones. Generate Content: Rewrite ideas into new posts in your voice → create images. Repurpose for X: Adapt LinkedIn posts for short-form, high-impact tweets. Auto-Publish: Post daily on LinkedIn and X. Control via Telegram: Manually trigger scraping, research, or post generation. 💡 Best Practices & Tips Keep all API keys private — never share them in public repos or screenshots. Adjust cron schedules (e.g., scraping on weekends, posting on weekdays) to fit your content rhythm. Add Human-in-the-Loop review steps for brand-sensitive content. Extend to other platforms (Instagram, TikTok, YouTube Shorts) as needed. Experiment with prompt variations for different tones or creative styles. Add analytics logging (likes, comments, clicks) to measure content performance. 🙋‍♂️ Who is This For Solo creators & founders** who want to post consistently but don’t have time for daily ideation. Small marketing teams** that need to keep up with trends without spending hours on research. Consultants & thought leaders** who want to amplify their personal brand on LinkedIn and X. Startups & bootstrapped businesses** that need a lean but reliable content engine. Content strategists** who want a data-driven, repeatable pipeline for finding and using what works. Or anyone who wants to boost social presence by 300% 💡 Why SMS Stands Out Authentic voice:** Uses your own tone and style (defined in prompts and examples), so posts feel personal — not generic AI fluff. Data-driven:** Pulls from real, viral posts in your niche to inspire fresh content. Quality over quantity:** Focuses only on proven viral ideas instead of churning random posts. Consistent growth:** Keeps your posting regular, so you stay visible and relevant. Efficient workflow:** Minimizes manual work while letting you step in when needed (e.g., for approvals or special campaigns). > ⚡ SMS combines real market data with your unique voice — so you post smarter, not just more often.

How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger:* The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2*). It checks whether the link is already processed. Link Type Detection:** The system identifies if the URL is from YouTube or a standard article. Data Retrieval:** If it’s YouTube: Uses Apify to fetch the transcript. If it’s an article: Uses an HTTP Request node to fetch the webpage content. AI Summarization:* The transcript or article content is passed to Google Gemini* for refined summarization. Google Sheets Storage:* The summary and title are appended to another sheet (Sheet1*) for long-term storage, along with a “Stored” status update in Sheet2. Telegram Assistant:** A Telegram Trigger listens for messages from the user. The assistant searches stored summaries in Google Sheets. If a match is found, it returns the result to the user on Telegram; otherwise, it politely apologizes.

AI-Powered Automated Outreach Scheduling with Gemini, Gmail & Google Sheets Automate your lead generation and outreach process seamlessly using AI, Gmail, and Google Sheets—all within n8n. No complicated setup—just import, activate, and start reaching prospects with personalized messages generated by Google Gemini’s AI model. Quick Setup Import the Workflow Download and import the provided workflow into your n8n instance. Connect Your Accounts Authenticate your Google Sheets account. Connect your Gmail account for sending emails. Prepare the Spreadsheet Use this template to set up your leads and tracking sheet. Configure the Gemini API Obtain your Gemini API key. Here Add it to the Gemini API credentials within n8n. Set Scheduling Preferences Customize the Schedule Trigger node to control when the workflow runs. Edit Email Prompts Update the initial and follow-up email prompts to match your outreach tone and goals. Set Rate Limits Configure the rate limiting settings to comply with Gmail sending limits and avoid spam filters. Activate the Workflow Enable the workflow to begin automated outreach to your leads. Track and Manage Leads Monitor responses and update lead statuses directly in your Google Sheet. How It Works Schedule Trigger:** Automatically starts outreach based on your defined schedule Google Sheets Integration:** Fetches leads and updates their status after outreach Email Validation:** Checks if lead emails are valid before sending Website Scraper:** Gathers info from lead websites to personalize messages Google Gemini AI:** Generates tailored cold outreach messages optimized for high response Gmail Node:** Sends personalized emails directly from your Gmail account Core Features Pull leads automatically from Google Sheets Validate emails to avoid bounces Scrape lead websites for custom messaging context Generate AI-crafted outreach emails with dynamic personalization Send emails on schedule without manual intervention Update lead status to track outreach progress AI Integration Uses Google Gemini AI to create professional, friendly, and engaging outreach emails Dynamic prompt templates tailored to each lead’s company and website content Structured JSON output to easily map subject, greeting, and body content 💡 Usage Examples B2B cold outreach campaigns with personalized emails Automated follow-ups based on lead engagement Lead nurturing with context-aware messaging Sales prospecting workflows integrated into your CRM ✨ Benefits Save hours by automating personalized outreach Increase response rates with AI-optimized messaging Keep lead data organized and updated in Google Sheets Fully scalable and customizable n8n workflow Minimal setup, ready to run out-of-the-box

Description This workflow provides a powerful AI assistant for content creators, book editors, and marketers. It automates the collection and analysis of trending discussions from Reddit, YouTube, and X (Twitter), generating insightful topic reports. This frees you from hours of tedious data compilation, allowing you to make faster, more accurate topic decisions based on deep AI analysis. How it works This workflow simulates the complete research process of a strategic editor: Initiate & Collect: A user submits a keyword via a public Form Trigger. The workflow then automatically fetches relevant, trending content in parallel from the official APIs of Reddit, YouTube, and X (Twitter). Multi-stage AI Processing & Analysis: The workflow utilizes a layered AI pipeline to process the data. First, a lightweight Gemini model in the AI Pre-filter Content node rapidly screens the vast amount of content to filter out noise. Next, a more powerful Gemini Pro model in the AI Deep Analysis node performs a detailed, structured analysis on each high-value item, extracting summaries, sentiment, and key arguments. Finally, a "strategist" AI model in the AI Synthesize Final Report node aggregates all analyses to generate the comprehensive final topic report in HTML. Multi-Channel Report Distribution: The workflow distributes the final report to multiple channels based on pre-defined templates. The Send Gmail Report node sends the complete HTML report. The Send Feishu Notification node sends a concise summary card to a group chat. Meanwhile, the Archive to Google Sheets node archives key data. Setup Steps This workflow takes approximately 20-30 minutes to set up, with most of the time spent connecting your accounts. Connect Your API Accounts: In the n8n Credentials section, you will need to prepare and connect credentials for the following services: Google: For the Gemini AI model, Gmail sending, and Google Sheets archiving. This requires a Google Cloud API Key and OAuth2 credentials. Reddit: For fetching Reddit posts. This requires a Reddit account with OAuth2 configured in n8n to allow searches. YouTube: For collecting YouTube videos. You'll need to enable the YouTube Data API v3 in your Google Cloud Console and get an API Key. Twitter: For the official Twitter node, requiring a free developer account and an App with v2 API access. Configure Output Channels: In the final nodes (Send Gmail Report, Send Feishu Notification, Archive to Google Sheets), update the recipient email address, the Feishu bot's Webhook URL, and the target spreadsheet ID to match your own. Activate and Share the Trigger: Activate the workflow. The first Form Trigger node will automatically generate a public URL. Share this link with your team members to let them start using the tool.

Generate visual resumes from Telegram inputs using Google Gemini This workflow transforms text-based resume data into visually stunning images by leveraging Google Gemini's reasoning and vision capabilities. It autonomously analyzes the candidate's profile, selects an appropriate design template based on their industry, and renders a high-quality resume image directly in Telegram. Target Audience Job seekers, career coaches, resume writers, and recruitment agencies looking to automate design generation. How it works Classify Input: The workflow starts with a Telegram trigger. A Google Gemini agent analyzes the incoming message to determine if it is a casual chat or a resume generation request. Fetch Context: If it is a resume request, a BrowserAct node triggers a workflow (using the "AI Resume Replicant" template) to fetch necessary external context or data. Ingest Designs (Optional): If a reference image is provided, CloudConvert standardizes the file, and Google Gemini Vision reverse-engineers the layout and style, saving the "Visual DNA" to Google Sheets. Draft Blueprint: The "Resume Writer" AI agent selects a stored design template that matches the candidate's industry (e.g., "Corporate" for Finance, "Creative" for Design) and maps the text content to the layout. Generate Prompt: A "Visualizer" AI agent converts the structured blueprint into a highly detailed natural language prompt for image generation. Render & Deliver: Google Gemini generates the final resume image, which is then sent back to the user via Telegram. How to set up Configure Credentials: Connect your Telegram, Google Gemini, Google Sheets, CloudConvert, and BrowserAct accounts in n8n. Prepare BrowserAct: Ensure the AI Resume Replicant template is saved in your BrowserAct account. Setup Google Sheet: Create a new Google Sheet with the required header (listed below). Connect Sheet: Open the Google Sheets nodes (Clear, Get, Append) and select your new spreadsheet. Configure Telegram: Ensure your Telegram Bot is connected to the Trigger and Message nodes. Google Sheet Headers To use this workflow, create a Google Sheet with the following header: Resume Details Requirements BrowserAct* account (Template: AI Resume Replicant*). Google Gemini** account. Telegram** account (Bot Token). CloudConvert** account. Google Sheets** account. How to customize the workflow Refine Design Logic: Modify the system prompt in the "Resume Writer" agent to change how the AI matches industries to design styles (e.g., force specific colors for specific roles). Change Output Format: Replace the Telegram response node with a Google Drive node to save the generated images as PDF or PNG files instead of sending them. Switch Image Model: Update the "Generate an image" node to use a different image generation model if preferred (e.g., OpenAI DALL-E). Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video I Built a Resume Bot that CLONES Any Template! 🤖 (BrowserAct + n8n + Gemini Tutorial)

Decodo-powered review aggregation to Google Sheets with Gemini analysis and Telegram alerts Who’s it for This template is designed for e-commerce owners, marketplace sellers, product teams, and CX/reputation managers who need an automated way to monitor product reviews. It’s ideal for anyone tracking Amazon listings or other URLs and wants AI-powered sentiment, summaries, and alerts without manual scraping. What it does This workflow automatically retrieves product URLs from Google Sheets, scrapes reviews using Decodo (community node), formats the extracted data, and analyzes it using Gemini AI. It produces both sentiment classification and a concise review summary. Results are saved to a Google Sheets log, and the workflow sends a Telegram alert whenever new reviews are processed. The entire pipeline runs on a schedule, ensuring continuous and fully automated monitoring. How it works A scheduled trigger starts the workflow. Google Sheets provides the list of product URLs. Each URL is processed through Decodo to extract user reviews. A Code node formats the raw review data. Gemini performs sentiment analysis and summarization. Results are appended to a Google Sheets review log. A Telegram message delivers a real-time summary and sentiment snapshot. Sign up for Decodo — get better pricing here Requirements Decodo API credentials (self-hosted community node) Google Sheets API Key Gemini AI credentials Telegram Bot + Chat ID n8n self-hosted (required for Decodo community node) How to set up Add your Decodo credentials to the Decodo node. Update both Google Sheets nodes with your document ID and sheet names. Insert your Gemini API key. Provide your Telegram Bot token and Chat ID. Adjust the schedule interval to your preference. Run the workflow once to validate mappings and output fields. How to customize Modify the Code node to change how reviews are formatted. Extend Gemini prompts for deeper analysis (keywords, categories, toxicity). Add filters to trigger alerts only on negative sentiment. Append additional metadata (timestamps, product IDs) to the Sheets log. Add email, Slack, or other communication channels. Disclaimer (Community Node) This workflow uses a community node (Decodo) and therefore works only on self-hosted n8n instances. Be sure to install and trust the package before using it.

LinkedIn URL → Scrape → Match → Screen → Decide, all automated This workflow automatically processes candidate LinkedIn profiles shared via Telegram, intelligently matches them to job descriptions, performs AI-powered screening analysis, and sends actionable summaries to your team in Telegram. Good to know Handles LinkedIn profile scraping via Apify API (extracts full profile data including experience, education, skills) Built-in spam prevention: limits users to 3 LinkedIn profile submissions Two-stage JD matching: prioritizes role mentioned in candidate's Telegram message, falls back to LinkedIn profile analysis if needed Uses Google Gemini API for AI screening (generous free tier and rate limits, typically enough to avoid paying for API requests - check latest pricing at Google AI Pricing and rate limits documentation) Automatic polling mechanism checks Apify extraction status up to 10 times (15-second intervals) Complete audit trail logged in Google Sheets with unique submission IDs Who's it for Hiring teams and recruiters who want to streamline first-round screening for candidates who share LinkedIn profiles directly. Perfect for companies accepting applications via messaging platforms (Telegram, WhatsApp, etc.), especially useful fortech-savvy audiences and remote/global hiring. How it works Telegram bot receives message containing LinkedIn profile URL from candidate Validates URL format and checks spam prevention (max 3 submissions per Telegram username) Sends confirmation message to candidate and notifies internal talent team via Telegram group Extracts clean LinkedIn URL and initiates Apify scraping job Polls Apify API up to 10 times (15-second intervals) until profile extraction completes AI agent matches candidate to best-fit job description by analyzing Telegram message context first (if candidate mentioned a role), or LinkedIn profile content as fallback (selects up to 3 potential JD matches) If multiple JDs matched, second AI agent selects the single best fit based on detailed profile analysis AI recruiter agent analyzes LinkedIn profile against selected JD and generates structured screening report (strengths, weaknesses, risk/reward factors, overall fit score 0-10 with justification) Logs complete analysis to Google Sheets tracker with unique submission ID Sends formatted summary to Telegram group with candidate details, matched JD, and overall fit score Requirements Telegram Bot Token (Create bot via @BotFather) Apify account with API token (Sign up for free tier) Google Drive account (OAuth2) Google Sheets account (OAuth2) Google Gemini API key (Get free key here) Google Drive folder for Job Descriptions (as PDFs or Google Docs) Telegram group for internal talent team notifications How to set up Create Telegram bot and internal Telegram chat group with new bot: Message @BotFather on Telegram Send /newbot and follow instructions to create your bot Save the API token provided Create Telegram group chat and invite your new bot + invite the @GetIDs bot Note down the group chat ID (How to get group chat ID) Setup Apify: Sign up at Apify Get your API token from Settings Note: Free tier includes sufficient scraping credits for testing and production ($0.01 per successful LinkedIn profile enriched, a free monthly limit of $5.00) - LinkedIn profile scraper "actor" details Create Google Sheet: Create new sheet named "LinkedIn Profile AI Candidate Screening" Add columns: Submission ID, Date, LinkedIn Profile URL, First Name, Last Name, Email (if known), Telegram Username, Strengths, Weaknesses, Risk Factor, Reward Factor, JD Match, Overall Fit, Justification Copy the spreadsheet ID from URL Setup Google Drive folder: Create folder named "Job Descriptions" Upload your JD files (PDFs or Google Docs) with clear, descriptive filenames Copy the folder ID from URL Configure workflow nodes: In "Receive Telegram Msg to Recruiter Bot" node: Add Telegram API credentials In "Extract LinkedIn Profile Information" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Check LinkedIn Profile Extraction Status" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Get Fully Extracted LinkedIn Profile Data" node: Replace YOUR_APIFY_API_TOKEN with your Apify token In "Access JD Files" node: Update folder ID to your "Job Descriptions" folder In "Get All Rows Matching Telegram Username" node: Select your Google Sheet In "Add Candidate Analysis in GSheet" node: Select your Google Sheet and verify column mappings In "Send Msg to Internal Talent Group" node: Update chat ID to your Telegram group chat ID In "Send Review Completed Msg to Talent Group" node: Update chat ID and Google Sheet URL Add your company description: In "JD Matching Agent" system message: Replace company description with your details In "Detailed JD Matching Agent" system message: Replace company description with your details In "Recruiter Scoring Agent" system message: Update company description Test the workflow: Send a LinkedIn profile URL to your bot from Telegram Monitor execution to ensure all nodes run successfully Check Google Sheets for logged results Activate workflow Customizing this workflow Change spam limits: Edit "Spam Check: Sent <4 LinkedIn Profiles?" node to adjust maximum submissions (currently 3) Adjust polling attempts: Edit "Checked 10x for LinkedIn Profile Data?" node to change maximum polling attempts (currently 10) or modify wait time in "Wait for LinkedIn Profile" node (currently 15 seconds) Change JD matching logic: Edit "JD Matching Agent" node prompt to adjust how LinkedIn profiles are matched to roles (e.g., weight current role vs. overall experience) Modify screening criteria: Edit "Recruiter Scoring Agent" node system message to focus on specific qualities (culture fit, leadership potential, technical depth, industry experience, etc.) Add more messaging platforms: Add nodes to support WhatsApp, Discord, or other messaging platforms using similar URL-based triggers Customize Telegram messages: Edit notification nodes to change formatting, add emojis, or include additional candidate data Auto-proceed logic: Add IF node after screening to auto-proceed candidates with fit score above threshold (e.g., 8+/10) and trigger different notification paths Add candidate responses: Connect nodes to automatically message candidates back via Telegram (confirmation, rejection, interview invite) Add interview scheduling: For approved candidates, send Telegram message with Cal.com or Calendly link so they can book their interview Enrich with additional data: Add nodes to cross-reference candidate data with other sources (GitHub, Twitter/X, company websites) Multi-language support: Add translation nodes to support candidates submitting profiles in different languages Add human approval step: Create buttons in Telegram group messages for instant Approve/Reject decisions that update Google Sheets Pro tip: Add your Telegram bot to your company's careers page with instructions like: "Want fast-track screening? Share your LinkedIn profile with our AI recruiter: @YourBotName" Troubleshooting Telegram bot not responding: Ensure bot token is correct in "Receive Telegram Msg to Recruiter Bot" node, and users have sent /start to your bot at least once "LinkedIn profile URL invalid" error: Check that candidates are sending full URLs in format https://www.linkedin.com/in/username (not shortened links or text without URL) Apify extraction failing: Verify Apify API token is correctly set in all three HTTP Request nodes ("Extract LinkedIn Profile Information", "Check LinkedIn Profile Extraction Status", "Get Fully Extracted LinkedIn Profile Data") LinkedIn extraction timeout: Increase polling attempts in "Checked 10x for LinkedIn Profile Data?" node (currently 10) or increase wait time in "Wait for LinkedIn Profile" node (currently 15 seconds) Spam check blocking valid users: Check "Get All Rows Matching Telegram Username" node is pointing to correct Google Sheet, and adjust limit in "Spam Check: Sent <4 LinkedIn Profiles?" node if needed JD matching returns no results: Check "Access JD Files" node folder ID points to your Job Descriptions folder, and JD files are named clearly (e.g., "Marketing Director JD.pdf") JD matching is not relevant for my company: Update the "Company Description" in the System Messages in all three AI agent nodes ("JD Matching Agent", "Detailed JD Matching Agent", "Recruiter Scoring Agent") "Can't find matching JD": Ensure candidate's Telegram message mentions role name OR their LinkedIn profile clearly indicates relevant experience for available JDs Google Sheets errors: Verify sheet name is "LinkedIn Profile AI Candidate Screening" and column headers exactly match workflow expectations (Submission ID, Date, LinkedIn Profile URL, First Name, Last Name, etc.) Telegram group notifications not appearing: Verify chat ID is correct in "Send Msg to Internal Talent Group" and "Send Review Completed Msg to Talent Group" nodes (use negative number for group chats, e.g., -4954246611) Missing candidate data in Google Sheets: LinkedIn profile may be incomplete - verify Apify successfully extracted data by checking "Get Fully Extracted LinkedIn Profile Data" node output Loop counter not working: Check "Restore Loop Counter" code node references correct node names ("Checked 10x for LinkedIn Profile Data?" and "Initialize Loop Counter to Poll for Completion") 401/403 API errors: Re-authorize all OAuth2 credentials (Google Drive, Google Sheets) and verify Apify and Telegram API tokens are valid AI analysis quality issues: Edit system prompts in "JD Matching Agent", "Detailed JD Matching Agent", and "Recruiter Scoring Agent" nodes to refine screening criteria and provide more context about your hiring needs Gemini API rate limit errors: Check your usage at Google AI Studio and consider upgrading to paid tier if exceeding free tier limits (see rate limits documentation) Sample Outputs Google Sheets - LinkedIn AI Candidate Screening - sample Telegram messages between AI recruiter bot and job applicant Telegram messages from AI recruiter bot in internal group chat

Workflow explaination video: https://youtu.be/z1grVuNOXMk Prerequisites Before running this workflow, you need to have the following set up: JotForm: A form with fields for describing the issue and optionally naming the team member involved. Google Sheet 1 (Issue Resolver Logic): A sheet with three columns: Issue Category, Normal Resolver, and Alternate Resolver. This sheet defines who handles which type of complaint. Google Sheet 2 (Issue Logs): A sheet to store all submitted complaints. It needs columns like: Issue, The person Caused by, case_awarded_to, resolver_email, email_subject, email_body_html, submitted_time, and status. Google Sheet 3 (Resolver Details): A simple sheet with two columns: resolver (e.g., "HR Team") and email (e.g., "[email protected]"). Credentials: You need to have connected accounts (credentials) in n8n for JotForm, Google (a Service Account for Sheets and OAuth for Gmail), and a Gemini API Key. Part 1: Initial Complaint Processing This part of the workflow triggers when a new complaint is submitted, uses AI to process it, logs it, and sends an initial notification. JotForm Trigger What it is:** The starting point of the workflow. How it works:** It constantly listens for new submissions on your specified JotForm. When someone fills out and submits the form, this node activates and pulls in all the submitted data (like the issue description and the person involved). AI Agent What it is:** The "brain" of the operation, which orchestrates several tools to make a decision. How it works:** This node receives the complaint details from the JotForm Trigger. It follows a detailed prompt that instructs it to perform a sequence of tasks: Classify: Analyze the complaint description to categorize it. Reason: Use its connected "tools" to figure out the correct resolver based on your business logic. Generate: Create a complete email notification and format the final output as a JSON object. Connected Tools:** Google Gemini Chat Model: This is the actual language model that provides the intelligence. The AI Agent sends its prompt and the data to this model for processing. Issue Resolver Allotment Logic Sheets tool: This allows the AI Agent to read your first Google Sheet. It can look up the issue category and find the designated "Normal Resolver" or "Alternate Resolver." Resolver Details Sheets tool: This allows the AI Agent to read your third Google Sheet. Once it knows the name of the resolver (e.g., "HR Team"), it uses this tool to find their corresponding email address. Structured Output Parser: This ensures that the AI's response is perfectly formatted into the required JSON structure (email, case_awarded_to, email_subject, etc.), making it reliable for the next steps. Save Complaint (Google Sheets Node) What it is:** The record-keeping step. How it works:* This node takes the structured JSON output from the AI Agent and the original data from the JotForm Trigger*. It then adds a new row to your second Google Sheet ("Issue Logs"), mapping each piece of data to its correct column (Issue, case_awarded_to, submitted_time, etc.). Send a message (Gmail Node) What it is:** The initial notification step. How it works:* After the complaint is successfully logged, this node sends an email. It uses the resolver_email, email_subject, and email_body_html fields generated by the AI Agent* to send a formal assignment email to the correct department or person. Part 2: Daily Follow-Up This second, independent part of the workflow runs every day to check for unresolved issues that are older than three days and sends a reminder. Schedule Trigger What it is:** The starting point for the daily check-up. How it works:** Instead of waiting for a user action, this node activates automatically at a predefined time each day (e.g., 10:00 AM). Get Complaint Logs (Google Sheets Node) What it is:** The data gathering step for the follow-up process. How it works:* When the schedule triggers, this node reads all* the rows from your "Issue Logs" Google Sheet, bringing every recorded complaint into the workflow for evaluation. If Node What it is:** The decision-making step. How it works:* This node examines each complaint passed to it from the previous step one by one. For each complaint, it performs a calculation: it finds the difference in days between the submitted_time and the current date. If that difference is greater than or equal to 3*, the complaint is passed on to the next step. Otherwise, the workflow stops for that complaint. Send a message1 (Gmail Node) What it is:** The reminder email step. How it works:* This node only receives complaints that met the "3 days or older" condition from the If* node. For each of these old complaints, it sends a follow-up email to the resolver_email. The email body is dynamic, mentioning how many days have passed and including the original issue description to remind the resolver of the pending task.

💼 LinkedIn Content Machine – AI-Powered Post Generator & Scheduler for X and LinkedIn How it works: This end-to-end workflow automates your personal or brand content strategy by: 🧠 Using Google Gemini or OpenAI to generate engaging LinkedIn/X content from a title or trending posts. 🗓️ Posting directly to LinkedIn and X (formerly Twitter). 📊 Pulling high-performing LinkedIn posts to inspire new ideas. ✍️ Saving AI-generated drafts to Google Sheets for review. 🔔 Notifying your team on Slack when drafts are ready. Steps to set up: Add your API keys for Google Gemini or OpenAI. Set up your LinkedIn, X (Twitter), Google Sheets, and Slack credentials. Customize prompt logic or post filters if needed. Schedule the idea generation module or trigger it manually. Start generating and posting consistent, high-quality content with zero manual effort!

Workflow explaination: https://youtu.be/ecafBTFPuvE?si=7csA1yNsaUxUG72F This workflow is designed to automatically handle new freelance project requests from a JotForm, analyze the requirements using AI, create a custom proposal, log the details in a Google Sheet, and send a personalized response to the client. JotForm Trigger Purpose**: This node is the entry point of the entire automation. It waits for a new freelance project submission from your specified JotForm. Action: When a potential client fills out and submits the form, this node **instantly triggers the workflow, passing all submitted data (name, email, project requirements, and budget) to the next node. Key Detail**: Uses a webhook for real-time activation, ensuring immediate processing of every new project request. AI Agent Purpose**: The central brain of your freelance workflow. 🧠 It takes the project submission and turns it into a structured, customized proposal. Action**: The agent follows a prompt sequence to perform these tasks: Calls the My Freelance Document Tool: Fetches your Google Doc containing details about your services, pricing, and project templates — your “source of truth.” Analyzes the Project Request: Reads the client’s requirements and goals from the form. Generates a Custom Proposal: Based on scope, budget, and relevance to your offerings, it prepares a short, tailored proposal or quote that fits the project. Creates a Personalized Email: Builds an HTML email with the proposal embedded, including next steps or a scheduling link for further discussion. Outputs Structured Data: Packages everything (project summary, proposal text, email subject, and body) into a clean JSON object for downstream use. Append or Update Row in Sheet (Google Sheets) Purpose**: Serves as your lightweight CRM for all project inquiries. Action**: Logs data from the AI Agent (proposal details, client info, and project summary) into a Google Sheet. Key Detail: Configured to **Append or Update—if an email already exists, it updates that row instead of duplicating. Keeps your client records clean and organized. If Purpose**: Acts as a control node to decide whether a proposal email should be sent. Action**: Checks the output from the AI Agent to ensure the proposal text is valid (not empty). Key Detail**: If the proposal generation fails or returns “NAN,” the workflow stops here to avoid sending incomplete responses. Send a Message (Gmail) Purpose**: Sends the final personalized proposal email to the client. Action: Pulls the recipient’s email from the sheet and sends the **AI-generated subject and HTML proposal email automatically. Key Detail**: The email is customized per project, giving the client an instant, professional response with no manual effort.

Stay ahead of the market with this powerful, automated workflow that performs real-time sentiment analysis on stock market news. By leveraging the advanced capabilities of Google Gemini, this solution provides you with actionable insights to make informed investment decisions. This workflow is designed for investors, traders, and financial analysts who want to automate the process of monitoring news and gauging market sentiment for specific stocks. It seamlessly integrates with Google Sheets for input and output, making it easy to track a portfolio of stocks. Key Features & Benefits Automated Daily Analysis: The workflow is triggered daily, providing you with fresh sentiment analysis just in time for the market open. Dynamic Stock Tracking: Easily manage your list of tracked stocks from a simple Google Sheet. AI-Powered Insights: Utilizes Google Gemini's sophisticated language model to analyze news content for its potential impact on stock prices, including a sentiment score and a detailed rationale. Comprehensive News Aggregation: Fetches the latest news articles from EODHD for each of your specified stock tickers. Error Handling & Validation: Includes built-in checks for invalid stock tickers and formats the AI output for reliable data logging. Centralized Reporting: Automatically logs the sentiment score, rationale, and date into a Google Sheet for easy tracking and historical analysis. How It Works This workflow follows a systematic process to deliver automated sentiment analysis: Scheduled Trigger: The workflow begins each day at a specified time. Fetch Stock Tickers: It reads a list of stock tickers from your designated Google Sheet. Loop and Fetch News: For each ticker, it retrieves the latest news articles using the EODHD API. AI Sentiment Analysis: The collected news articles are then passed to a Google Gemini-powered AI agent. The agent is prompted to act as a stock sentiment analyzer, evaluating the news and generating: A sentiment score from -1 (strong negative) to 1 (strong positive). A detailed rationale explaining the basis for the score. Data Formatting & Validation: The AI's output is parsed and validated to ensure it is in the correct JSON format. Log to Google Sheets: The final sentiment score and rationale are appended to your Google Sheet, alongside the corresponding stock ticker and the current date. Nodes Used Schedule Trigger Google Sheets SplitInBatches HttpRequest (EODHD) If Code (JavaScript) AI Agent (LangChain) Google Gemini Chat Model This workflow is a valuable tool for anyone looking to harness the power of AI for financial market analysis. Deploy this automated solution to save time, gain a competitive edge, and make more data-driven trading decisions.

Overview This workflow automatically creates hours-long wave music videos by combining AI-generated music from Suno with a background video, fully automated using n8n and ffmpeg-api. It connects music prompt generation, AI song creation, audio aggregation, video merging, and YouTube publishing into a single end-to-end automation. Once configured, the workflow runs continuously with no manual editing required. This workflow is built for creators producing lo-fi, wave, ambient, or long-play music content who want a reliable and scalable way to generate long-form videos automatically. What can this workflow do? Collect music themes, background video URLs, and track counts via an input form Generate multiple AI music tracks using Suno Automatically check rendering status and retrieve completed songs Concatenate multiple tracks into a single long-form audio file Merge the final audio with a background video using ffmpeg-api Upload the completed video to YouTube automatically Generate SEO-optimized titles and descriptions using an AI model This workflow reduces manual work while keeping the entire music video production process structured and repeatable. How it works You start by submitting a music theme, a background video URL, and the number of music tracks through an n8n form. The workflow initializes a working directory using ffmpeg-api to manage all audio and video assets. An AI agent converts the music theme into structured Suno prompts. Suno then generates multiple music tracks, and the workflow continuously checks their rendering status until all songs are ready. Once completed, the songs are downloaded, uploaded to ffmpeg-api storage, and concatenated into a single long-form audio track. This audio is merged with the background video to create the final hours-long wave music video. Finally, the completed video is uploaded to YouTube. An AI model generates SEO-friendly metadata, and the video is published automatically without manual intervention. Setup steps Connect an AI model (Gemini) for music prompt generation and YouTube metadata creation Configure Suno API access for AI music generation Set up ffmpeg-api for directory creation, file uploads, audio concatenation, and video merging Connect your YouTube account for automated uploads Review and customize the input form fields if needed After setup, the workflow runs end to end automatically. Documentation For a full walkthrough and advanced customization ideas, watch the detailed tutorial on YouTube.

This n8n template demonstrates how to use AI to score the all Resumes by matching it with Job profile Problem Statement: A Hr person is flooded with resume and spends hours manually checking each to find most suitable ones. How it works It is linked to Gmail Trigger which upon receving any mail with specific subject will check for the attachment. Attachment will be parsed to understand the resume Candidate informtion will be broken into Personal, Eductional and Professional type Job profile will be pulled from Notion Board A HR expert powered by Gemini LLM will score each profile on basis on its relevancy Information will be updated back to Gsheet Message lable will be updated back for clarity How to use The gmail trigger node is used as an example but feel free to replace this with other triggers such as webhook or even a form. Requirements Gemini account for LLM Google sheet for upload Gmail as trigger Llama parse credentials

This workflow automates the process of scraping real estate property listings from websites using ScrapeGraph AI, extracting structured data, and saving it to a Google Sheet. It is designed to handle paginated listing pages and can be adapted to any real estate site that uses URL parameters for pagination. NOTE: This workflow has been tested with Immobiliare.it, the #1 real estate website in Italy. However, it is designed to be adaptable by modifying the pagination parameter and the listing URL pattern, you can use it with any real estate website that structures its listings with URL-based pagination. Business Use Cases: Real estate market intelligence Lead generation for agencies Price trend analysis Property comparison dashboards CRM enrichment Competitor monitoring Key Advantages ✅ Fully Automated Lead Collection Automatically collects real estate listings without manual browsing. ✅ AI-Powered Extraction Uses AI instead of rigid selectors: More resilient to website layout changes Handles dynamic content better Reduces maintenance effort ✅ Structured Data Output The defined JSON schema ensures: Clean database-ready data Standardized fields Easy integration with CRM or analytics tools ✅ Pagination Scalability Can easily scale: Increase number of pages Change city Adapt to different portals ✅ Duplicate Prevention Google Sheets uses URL matching to: Avoid duplicates Update existing records ✅ Modular Architecture The workflow is modular and reusable: URL generation logic is independent Extraction schema is customizable Storage layer can be replaced (CRM, database, Airtable, etc.) ✅ Cost & Time Efficiency Eliminates manual data entry Saves research time Enables automated market monitoring How it works The workflow is structured in two main phases: Listing URL Discovery The user provides a base URL, the maximum number of pages to scrape, and the pagination parameter name (e.g., pag for Immobiliare.it). A Code node generates a list of page URLs by appending the pagination parameter. Each page URL is processed through the ScrapegraphAI node, which extracts all individual listing URLs. An Information Extractor node (powered by Google Gemini) filters and validates the extracted URLs based on a defined structure. A Wait node introduces a delay between requests to avoid rate limiting. A Loop Over Items node ensures all generated page URLs are processed. Data Extraction & Storage All collected listing URLs are aggregated and split into individual items. A second loop processes each listing URL through another ScrapegraphAI node, which extracts detailed property data (title, description, price, area, bedrooms, bathrooms, floor, rooms, balcony, terrace, cellar, heating, air conditioning, image URLs) based on a JSON schema. The extracted data is then written to a Google Sheet using the Google Sheets node, with each listing stored in a new row and deduplicated based on the listing URL. The workflow is fully automated and can scale to handle multiple listing pages and hundreds of individual property URLs. Set up steps To use this workflow, follow these steps: Import the workflow into your n8n instance. Configure credentials: ScrapegraphAI: Add your API key for ScrapegraphAI. Google Gemini (PaLM): Add your Google Gemini API credentials. Google Sheets OAuth2: Authenticate with the Google account where you want to store the data. Prepare your target Google Sheet: Create a new Google Sheet (or clone this template). Note the Sheet ID (from the URL) and the sheet name (tab name) where data should be written. Customize the input parameters: In the Set params node, define: url: The base URL of the listing page (without pagination parameters). max_pages: The number of pages to scrape. page_format_value: The query parameter used for pagination (e.g., pag for Immobiliare.it). Adjust the listing URL structure (if needed): In the Extract individual URL node, update the system prompt to match the URL pattern of the target website (e.g., https://www.xxx.it/xxx/xxxx). Review the output schema: In the Extract data node, you can modify the JSON schema to match the fields you want to extract from each listing. Update the Google Sheet node: Set the correct Document ID and Sheet Name in the Update real estate listings node. Ensure the column mapping matches your sheet structure. Activate the workflow and click Execute Workflow to start scraping. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

Overview Automatically generate viral short-form health videos using AI and publish them to social platforms with n8n and Veo 3. This workflow collects viral ideas, analyzes engagement patterns, generates AI video scripts, renders videos with Veo 3, and handles publishing and tracking fully automated, with no manual editing. Who is this for? This template is ideal for: Content creators building faceless health channels (Shorts, Reels, TikTok) Affiliate marketers promoting health products with video content AI marketers running high-volume short-form content funnels Automation builders combining LLMs, video AI, and n8n Teams that want a scalable, repeatable system for viral AI video production If you want to create health niche videos at scale without manually scripting, rendering, and uploading each video, this workflow is for you. What problem is this workflow solving? Creating viral short-form health videos usually involves many manual steps and disconnected tools, such as: Manually collecting and validating viral content ideas Writing hooks and scripts for each video Switching between AI tools for analysis and video generation Waiting for videos to render and checking status manually Uploading videos and tracking what has been published This workflow connects all these steps into a single automated pipeline and removes repetitive manual work. What this workflow does This automated AI health video workflow: Runs on a defined schedule Collects viral health content ideas from external sources Normalizes and stores ideas in Google Sheets Loads pending viral ideas for processing Analyzes each idea and generates AI-optimized video scripts Creates AI videos automatically using the Veo 3 API Waits for video rendering and checks completion status Retrieves the final rendered videos Optionally aggregates or merges video assets Publishes videos to social platforms Updates Google Sheets with processing and publishing results The entire process runs end-to-end with minimal human intervention. Setup Prepare Google Sheets Create a Google Sheet to manage your content pipeline with columns such as: idea / topic – Viral idea or source content analysis – AI analysis or hook summary script – Generated video script status – pending / processing / completed / failed video_url – Final rendered video link publish_result – Publishing status or notes Only rows marked as pending will be processed by the workflow. Connect Google Sheets Authenticate your Google Sheets account in n8n Select the spreadsheet in the load and update nodes Ensure the workflow can write status updates back to the same sheet Configure AI & Veo 3 Add credentials for your AI model (e.g. Gemini or similar) Configure prompt logic for health niche content Add your Veo 3 API credentials Test video creation with a small number of ideas before scaling Configure Publishing & Schedule Set up publishing credentials for your target social platforms Open the Schedule triggers and define how often the workflow runs The schedule controls how frequently new AI health videos are created and published How to customize this workflow to your needs You can adapt this workflow without changing the core structure: Replace viral idea sources with your own research or internal data Adjust AI prompts for different health sub-niches Add manual approval steps before video creation Disable publishing and use the workflow only for video generation Add retry logic for failed renders or API errors Extend the workflow with analytics or performance tracking Best practices Start with a small batch of test ideas Keep status values consistent in Google Sheets Focus on strong hooks for health-related content Monitor rendering and publishing nodes during early runs Adjust schedule frequency based on API limits Documentation For a full walkthrough and advanced customization ideas, see the Video Guide.

This n8n template demonstrates how to automate the creation of high-quality visual content using AI. The workflow takes simple titles from a Google Sheets spreadsheet, generates detailed artistic prompts using AI, creates photorealistic images, and manages the entire process from data input to final delivery. Use cases are many: Perfect for digital marketers, content creators, social media managers, e-commerce businesses, advertising agencies, and anyone needing consistent, high-quality visual content for marketing campaigns, social media posts, or brand materials! Good to know The Gemini 2.0 Flash Exp image generation model used in this workflow may have geo-restrictions. The workflow processes one image at a time to ensure quality and avoid rate limiting. Each generated image maintains high consistency with the source prompt and shows minimal AI artifacts. How it works Automated Trigger: A schedule trigger runs every minute to check for new entries in your Google Sheets spreadsheet. Data Retrieval: The workflow fetches rows from your Google Sheets document, specifically looking for entries with "pending" status. AI Prompt Generation: Using Google Gemini, the workflow takes simple titles and transforms them into detailed, artistic prompts for image generation. The AI considers: Specific visual elements, styles, and compositions Natural poses, interactions, and environmental context Lighting conditions and mood settings Brand consistency and visual appeal Proper aspect ratios for different platforms Text Processing: A code node ensures proper JSON formatting by escaping newlines and maintaining clean text structure. Image Generation: Gemini's advanced image generation model creates photorealistic images based on the detailed prompts, ensuring high-quality, consistent results. File Management: Generated images are automatically uploaded to a designated folder in Google Drive with organized naming conventions. Public Sharing: Images are made publicly accessible with read permissions, enabling easy sharing and embedding. Database Update: The workflow completes by updating the Google Sheets with the generated image URL and changing the status from "pending" to "posted", creating a complete audit trail. How to use Setup: Ensure you have the required Google Sheets document with columns for ID, prompt, status, and imageUrl. Configuration: Update the Google Sheets document ID and folder IDs in the respective nodes to match your setup. Activation: The workflow is currently inactive - activate it in n8n to start processing. Data Input: Simply add new rows to your Google Sheets with titles and set status to "pending" - the workflow will automatically process them. Monitoring: Check the Google Sheets for updated status and image URLs to track progress. Requirements Google Gemini API** account for LLM and image generation capabilities Google Drive** for file storage and management Google Sheets** for data input and tracking n8n instance** with proper credentials configured Customizing this workflow Content Variations: Try different visual styles, seasonal themes, or trending designs by modifying the AI prompt in the LangChain agent. Output Formats: Adjust the aspect ratio or image specifications for different platforms (Instagram, Pinterest, TikTok, Facebook ads, etc.). Integration Options: Replace the schedule trigger with webhooks for real-time processing, or add notification nodes for status updates. Batch Processing: Modify the limit node to process multiple items simultaneously, though be mindful of API rate limits. Quality Control: Add additional validation nodes to ensure generated images meet quality standards before uploading. Analytics: Integrate with analytics platforms to track image performance and engagement metrics. This workflow provides a complete solution for automated visual content creation, perfect for businesses and creators looking to scale their visual content production while maintaining high quality and consistency across all marketing materials.

AI-Powered Elementor Blog Post Automation System for Agencies Categories: Business Automation, Content Creation, SEO, AI This advanced workflow automates every step of content publishing for agencies, from managing multiple clients and creating SEO-optimized blog content to AI-powered image generation and publishing directly to Elementor-powered WordPress sites. It's a game-changer for scaling your content operations and freeing up your team for strategic work. Benefits Complete Automation** - An end-to-end solution that handles content generation, image creation, scheduling, and publishing. Elementor-Ready Content** - Creates posts that inherit your client's theme styling and responsiveness, eliminating manual design work. Centralized Management* - Organizes clients, content ideas, and publishing history in a simple Google Sheets* system. Intelligent AI Creation* - Uses Google Gemini* to produce high-quality, SEO-optimized content with customizable tone and strict guidelines. Flexible Publishing* - Offers both on-demand and scheduled* triggers to fit any content strategy. How It Works Flexible Triggers: The workflow can be initiated in two ways: Manual Trigger: Fill out a simple n8n form with client details, keywords, and content guidelines for an on-demand post. Automated Trigger: The workflow checks a Google Sheet hourly and automatically publishes any scheduled posts. Centralized Management: A three-sheet Google Sheets system acts as your core database for: Clients: Stores client information and WordPress app credentials. Blog Ideas/Schedule: Your content calendar where you plan and track upcoming posts. History: A log of every successfully published post. Intelligent AI Content Generation: An AI Agent with a customizable prompt leverages Google Gemini to: Analyze competitor URLs to create more comprehensive content. Adhere to strict SEO and formatting guidelines. Generate a unique featured image based on the article's keywords. Elementor Conversion: A custom JavaScript function parses the AI's HTML output and converts it into a native Elementor JSON format. This is the core magic that ensures the post is perfectly structured and responsive. Seamless WordPress Integration: The workflow uses a WordPress node to send the post's title and the Elementor JSON data to the client's site, publishing a new blog post that looks as if it was manually created with the Elementor editor. Requirements n8n Instance**: A self-hosted or cloud instance of n8n. Google Account**: A Google account for managing your client and content sheets. Google Gemini API Key**: A valid API key for content generation. WordPress App Passwords**: App passwords for each of your clients' WordPress sites. How to Use Set up your spreadsheet: Copy the provided Google Sheets template and populate the Clients sheet with your clients' details and credentials. Connect your accounts: Authenticate your Google Sheets, Google Gemini, and n8n accounts within your n8n instance. Run the workflow: Add your blog post ideas to the Schedule sheet for automated publishing, or use the n8n form for on-demand posts. The workflow will handle the rest. Business Use Cases Content Marketing Agencies** - Scale content production for dozens of clients without hiring more writers. SEO Agencies** - Instantly create high-quality, long-form content to improve client search rankings. Freelancers** - Offer comprehensive content services that would normally require a team. SaaS Companies** - Automate blog content to build an inbound marketing engine. Website Developers** - Provide ongoing content services to clients after a site launch. Revenue Potential This system allows you to: Scale content services** without scaling your team. Increase profitability** by reducing the time and cost per blog post. Offer a differentiated service that provides superior, Elementor-ready content. Potentially sell this automation as a service to other agencies. Difficulty Level: Intermediate Estimated Setup Time: 45 min Monthly Operating Cost: Low (variable based on AI usage)

🎥 AI Tour Video Generator with GPT-4o, RunwayML & ElevenLabs for Social Media' This n8n workflow generates 20-second faceless videos for social media by combining AI-generated images, audio, and video clips for a given tour destination. The output is a ready-to-publish video file, which can be pushed to social platforms and logged in a tracking sheet. ⚙️ Workflow Overview This system is divided into 4 main sections: 🧠 Generate Image Prompts 🎨 Generate Media (Images, Videos, Audio) 🛠️ Render & Upload 📈 Future Enhancements 🔌 Integration Setup Table | Integration | Service Used | Setup Instruction | |--------------------|----------------------------|------------------------------------------------------------------------------------| | OpenAI | GPT-4o (Prompt Generation) | Get API Key and configure in n8n | | Google Sheet | Idea I/O tracking | Connect Google account with OAuth/Credentials in n8n | | Piapia API | AI Image Generation | Sign up at piapia.ai and get API key | | Runway API | AI Video Generation | Register at runwayml.com for access | | ElevenLabs | AI Voice Generation | Sign up at elevenlabs.io for API key | | CreateMate API | Render Final Video | Visit createmate.ai to access API | | Google Drive | Upload/Share Final Video | Use n8n Google Drive node to configure credentials | ✅ Required Services & Tools Ensure you have active accounts with the following tools and services: ✅ OpenAI (GPT-4o + Embeddings) ✅ Google Sheets (for destination ideas and tracking) ✅ Piapia API (Image generation) ✅ RunwayML API (Video generation) ✅ ElevenLabs API (Voiceover TTS) ✅ Google Drive (Storage & Sharing) ✅ CreateMate (Video Rendering) ✅ Social Media Scheduler (Optional - Zapier, Buffer, Make.com) 🧠 1. Generate Image Prompts > Purpose: Prepares the content idea and generates visual prompts. | Step | Node Name | Function | |--------------|------------------------|-----------------------------------------------| | 🔁 Trigger | Schedule or Manual | Starts the workflow | | 📥 Grab Idea | Read Sheet | Pulls destination idea from Google Sheet | | ✍️ Set Content | Manual Input | Adds structure/narrative to the idea | | 🔀 Split | Split Out | Breaks input into chunks | | 🤖 GPT Agent | Image Prompt Agent | Uses GPT-4o to generate creative image prompts| | 🧹 Clean | Remove \n | Cleans up formatting | | 📌 Save | Set Prompts | Finalizes prompts for next stage | 🖼️ 2. Generate Media 🎨 Generate Images | Step | Function | |----------------|-----------------------------------------------------------| | Generate Image | Calls Piapia API with AI-generated prompts | | Wait | Adds delay for rendering (90 sec) | | Get Images | Retrieves final images for video | 🎥 Generate Videos | Step | Function | |----------------|-----------------------------------------------------------| | Generate Video | Calls RunwayML to generate video clips from the prompts | | Wait | 2-minute delay to allow video generation | | Get Videos | Fetches completed video clips | 🔊 Generate Audio | Step | Function | |------------------|----------------------------------------------------------| | Update Status | Logs progress in Google Sheet | | Sound Agent | Gemini or GPT generates narration text | | Set Audio | Formats narration for voice synthesis | | Generate Audio | Uses ElevenLabs for realistic voiceover | | Upload to Drive | Saves final audio to Google Drive | | Share File | Creates sharable URL for audio file | 🛠️ 3. Render & Upload > Purpose: Combines all elements (image, video, audio) into a single output and prepares for social media. | Step | Function | |-----------------|----------------------------------------------------------------| | Merge | Combines images, videos, and audio | | Split Out Parts | Breaks content for rendering | | Render Video | Uses CreateMate to render the final 20-second video | | Wait | Short delay to complete rendering | | Download Video | Saves output video locally or on Drive | | Update Sheet | Logs final video URL/status in Google Sheet | | Social Upload | (Coming Soon) Post to Instagram, YouTube Shorts, TikTok, etc. | 🧩 Pre-Conditions Before running the workflow: ✅ Google Sheet should be created with destination ideas ✅ All API keys must be configured in n8n ✅ Google Drive folder must exist for output videos ✅ Sufficient credit/quota must be available on AI platforms ✅ Internet access must be stable for external API calls 🚀 Outcome A polished 20-second travel destination video Combines AI visuals, short clips, and AI narration Ready for instant social media upload Fully automated** from idea to video file 🧠 Tech Stack Summary | Component | Tools Used | |-----------------|-------------------------------| | Language Model | GPT-4o (OpenAI), Gemini (Google) | | Image Generator | Piapia API | | Video Generator | RunwayML | | Audio Generator | ElevenLabs | | Storage | Google Drive | | Video Composer | CreateMate API | | Orchestration | n8n | 📈 Future Enhancements ✅ Smart Enhancements Dynamic hashtags & captions via AI Auto-post to TikTok, Instagram, YouTube via Buffer/Zapier Scene detection + matching B-roll Multilingual narration (e.g., Arabic, French, Malay) A/B testing of video versions to analyze performance 🧪 Testing Add-ons Add preview screen before upload Error tracking & retry flow Manual override before publishing 🧰 Customization Guide | Element | How to Customize | |----------------------|-------------------------------------------------------------------| | ✏️ Prompt Format | Change structure inside Set Content or Prompt Agent | | 🌍 Destination Ideas | Modify Google Sheet for different destinations/categories | | 🎨 Image Style | Customize prompt to Piapia (e.g., “in Pixar style”, “3D render”) | | 🎙️ Voiceover Script | Adjust tone/structure in the Sound Agent | | 📆 Posting Schedule | Use Zapier/Buffer for timed posting | | 🎯 Target Duration | Adjust number of clips or frame duration | 🙌 Community Value This workflow is ideal for: 📸 Travel content creators 🌍 Destination marketers 🏛️ Tourism boards 🧳 Travel SMEs looking for automation Feel free to fork, remix, or request a JSON export in the comments below!

LINE AI Handwritten Memo OCR & Tag Search System This workflow converts handwritten memo images sent via LINE into structured, searchable knowledge using AI.Users simply send a handwritten memo photo. The workflow automatically performs OCR, summarizes the content, generates tags, and stores the results in Google Sheets.Images are archived in Google Drive, allowing easy access to the original memo later. Main Features • AI OCR for handwritten memo recognition • Automatic title and summary generation • Tag extraction for knowledge organization • Image archiving in Google Drive • Structured storage in Google Sheets • Tag-based memo search via LINE • Tag list generation for easy navigation User Commands (via LINE) Send an image → The memo is analyzed, summarized, tagged, and saved automatically. #タグ名 → Searches memos that contain the specified tag. #タグリスト → Displays all tags currently stored in the database. Workflow Steps Receive message from LINE via Webhook Validate message type (image or command) Save image to Google Drive Run AI OCR and generate structured JSON Parse and validate AI output safely Store memo data in Google Sheets Send completion message to the user If OCR fails, the user receives guidance to retake the photo. Stored Data Structure Each memo record includes: • Title • Summary • Tags • Timestamp • Link to the original image

🕵️‍♂️ Reddit Intelligence Monitor: AI-Powered Scraping with BrowserAct Automate your market research and competitor analysis with this powerful "Set and Forget" workflow. It monitors Reddit for specific keywords and competitor subreddits, uses BrowserAct for stealth scraping, analyzes the sentiment with AI, and delivers a daily intelligence digest to your Google Sheets. 💡 Key Features Powered by BrowserAct**: Leverages cloud browser automation to stealthily scrape Reddit data without getting blocked. Dual-Track Monitoring**: Simultaneously tracks "Brand Competitors" (Subreddits) and "Topic Keywords" (Search Results). AI Analysis**: Summarizes the top 3 trending posts into a single concise daily report, filtering out noise. Structured Archive**: Automatically cleans, formats, and archives intelligence with source links into Google Sheets. 🛠️ How it Works Config Read: Reads a list of monitoring targets from a Google Sheet. Route: Splits the task into two paths (Competitor vs. Keyword) based on input type. Scrape: BrowserAct navigates to the target Reddit pages and extracts the latest posts. Process: Custom Code nodes clean the data and merge top 3 posts into a single prompt. Analyze: AI Agent generates an executive summary for each topic. Archive: Final reports are appended to your "Report" Google Sheet. 📋 Setup Guide Google Sheets: Create a sheet with two tabs: Config: Columns keywords (for search terms) and competitor (for subreddit names). Report: Columns Date, Competitor/Keyword, Summary, Link. BrowserAct: Connect your BrowserAct credentials and ensure you have the Reddit scraping task template ready. AI Model: Configure the Google Gemini Chat Model (or swap for OpenAI). Schedule: Enable the Schedule Trigger for daily automated runs.

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.

Shopify Product-to-Blog Automation with Perplexity web search, Gemini AI Agent & Google Sheets Shopify Blog Automation (From Shopify product to SEO-optimized blog post — fully automated) This workflow is an advanced n8n-powered automation that transforms newly created Shopify products into professionally written, SEO-ready blog posts using AI. By combining **Shopify Webhooks, Google Sheets, AI research, structured content generation, and automated HTML formatting**, this workflow removes all manual work from product-based content marketing. 💡 Key Advantages This Shopify Product-to-Blog Automation delivers the following benefits: 🛍️ Shopify Product Sync Automatically captures new product data (title, description, vendor, type, images) the moment a product is created. 🧠 AI-Powered Research & Writing Uses AI to perform market analysis, identify customer intent, and generate structured, high-quality blog content. 📊 Google Sheets Tracking Maintains a clear audit trail of products, generated blogs, and publishing status to prevent duplication. 🧩 Structured Content Output Generates strict JSON-based blog sections (problem, solution, features, usage, comparison, CTA) for consistency and scalability. 📤 End-to-End Automation Handles everything — from product detection to blog publishing — with zero manual writing. ⚙️ How It Works Step-by-Step Process Shopify Trigger Listens for products/create events in Shopify. Product Data Extraction Normalizes product fields and selects the primary product image. Google Sheets Storage Stores raw product data and sets initial processing status. AI Market & SEO Research Analyzes product intent, audience, use cases, FAQs, and keyword opportunities. AI Blog Content Generation Creates structured, SEO-focused blog content using a LangChain AI agent. HTML Structuring Cleans, escapes, and formats content into Shopify-safe, responsive HTML. Shopify Blog Publishing Automatically posts the article to the Shopify Blog via Admin API. Status Update & Tracking Updates Google Sheets to reflect successful blog publication. 🛠️ Setup Steps Required Node Configuration To run this workflow, configure the following nodes: Shopify Trigger** – Detect new product creation Set Node** – Normalize Shopify product fields Google Sheets Nodes** – Store and track workflow state AI Research Node** – Market & SEO analysis LangChain / Gemini Agent** – Blog content generation Code Node** – HTML formatting and safety handling HTTP Request Node** – Publish blog post to Shopify Error Handling Logic** – Retry and fail-safe routing 🔐 Credentials Required Before enabling the workflow, configure these credentials: Shopify Admin API Access Token** – For blog publishing Google Sheets OAuth** – For data tracking Google Gemini API Key** – For AI content generation Perplexity API Key** – For research and SEO insights 👤 Ideal For This automation is ideal for: Shopify store owners using content marketing Ecommerce teams managing large product catalogs SEO teams scaling product-driven blog content Agencies offering automated Shopify SEO solutions 💬 Bonus Tip This workflow is fully modular and extensible. You can easily enhance it to: Auto-link blogs to products Generate multilingual blog posts Schedule delayed publishing Route content by product category Add internal linking or schema markup All extensions can be implemented within the same n8n workflow. ✅ Result Every new Shopify product automatically becomes: Research-backed SEO-optimized Professionally structured Automatically published No manual writing. No copy-paste. Fully automated. Keywords shopify ai shopify automation shopify marketing automation shopify blog automation shopify content automation ai blog generator shopify shopify seo automation ecommerce automation ai ecommerce automation shopify workflow automation shopify product to blog auto generate shopify blogs shopify ai content how to automate shopify

Complete Video Documentation: https://youtu.be/O-bKlX3G7_4 Explanation WITH clean Video timestamps: Prerequisites: You need a rental agreement document, a BoldSign account (which has a free tier for testing) [00:44], a Google Sheet, and an n8n instance. BoldSign Setup: How to upload your agreement as a template, drag-and-drop the signature and text fields [01:13], get your API key [01:57], and set up a webhook to notify n8n when the agreement is signed or completed [02:13]. Workflow Logic: The video walks through the two main flows: Form Submission: A tenant fills out a form, which triggers n8n to save the details to Google Sheets and then call the BoldSign API to send the agreement to both the owner and tenant [03:01]. Completion: When both parties sign, BoldSign sends an event to the n8n webhook, which then filters for the "Completed" event and updates the Google Sheet [09:12]. Bonus: It also covers the Telegram bot setup, which lets an owner ask an AI about the status of agreements [11:52]. Prerequisites Before you build this, you'll need a few things: An n8n Instance: This can be on n8n.cloud or self-hosted. A Google Sheet: Create a new sheet with columns like Tenant Name, Tenant Email, Property, Estimated Rent per month, contract expiry, and agreement status. A BoldSign Account: An API Key. [01:57] A prepared rental agreement document (like a PDF or .docx). A BoldSign Template created from that document. You'll need to drag and drop the required fields (like signatures, dates, text boxes) onto the template. [01:13] A Telegram Bot (Optional): If you want the AI status checker, you'll need to create a bot with Telegram's BotFather to get an API token. A Google Gemini API Key (Optional): For the AI agent. In BoldSign, you would replace the {{...}} and [Date] parts with draggable form fields. Understanding the BoldSign API Node The key to sending the agreement is the Send aggrement to Tenant's Email node. This is a standard HTTP Request node, not a special BoldSign node. Method: POST URL: https://api.boldsign.com/v1/template/send?templateId=enter-your-template-id This is the official BoldSign API endpoint for sending a document based on a template. You must replace enter-your-template-id with the actual ID of the template you created in BoldSign [07:04]. Authentication: Header Auth BoldSign uses an API key in the header. You would create a credential in n8n where the Name is X-API-KEY and the Value is the secret API key you got from your BoldSign account [07:16]. Body: The jsonBody is the most important part [08:02]. It's a JSON object that tells BoldSign who to send the agreement to and what data to pre-fill. title: Sets the document title, like "Rental Agreement - 123 Main St". roles: This array defines the signers. One role is for the "Owner", dynamically filling their name and email from the form data. The second role is for the "Tenent" (Tenant), also filling their name and email. existingFormFields & mergeFields: This is where you dynamically insert data into the document. You map the data from your n8n form (like {{ $('Retrive Data from submitted form').item.json.address }}) to the id of the fields you created in your BoldSign template [08:16]. Workflow Explanation (From Scratch) This workflow is actually three separate flows that work together. Flow 1: New Tenant Onboarding (Form to Agreement) This is the main flow that kicks everything off when a new tenant is interested. Node: Tenant Form (Form Trigger) What it is: This node creates a public web form [03:10]. This is the starting point. From Scratch: You'd drag in a Form Trigger node. You add fields for "Your Name" (tenant's name) and "Your Email" (tenant's email). This Workflow: It also cleverly uses hidden fields [03:18] to store the owner's details, the property address, and the rent. This is a simple way to manage a single property. For multiple properties, you might use a database or a Google Sheet lookup. Node: Retrive Data from submitted form (Set) What it is: This node takes the messy data from the form and organizes it into clean, named variables (like tenant_name, address, estimated_rent) [05:25]. From Scratch: It's good practice to do this so the rest of your workflow is easy to read. It also calculates the expiry_date as one year from today. Node: Save the tenant Details (Google Sheets) What it is: This logs the new tenant in your Google Sheet before the agreement is sent [05:51]. From Scratch: You'd set this to "Append or Update" mode. It maps the variables ( tenant_name, tenant_email, etc.) to the correct columns in your sheet. Node: Send aggrement to Tenant's Email (HTTP Request) What it is: This is the BoldSign API call we just detailed. It takes all the data and sends the official signing request to both the owner's and tenant's email addresses [06:47]. Node: Update Agreement Status (Google Sheets) What it is: After the email is successfully sent, this node finds the row you just created (using the tenant's email as a key) and updates the agreement status column to "Pending Signing" [08:55]. This is great for tracking. Flow 2: Handling Signed Agreements (Webhook) This flow listens for activity. It doesn't run on a schedule; it waits for BoldSign to tell it something happened. Node: Webhook (Webhook Trigger) What it is: This node generates a unique URL [02:45]. You copy this URL and paste it into your BoldSign account's webhook settings [09:28]. From Scratch: Now, any time an event happens in BoldSign (like the document is viewed, signed, or completed), BoldSign will send a data packet to this URL, triggering the workflow. Node: If (If) What it is: This is a filter. The webhook gets all events, but we only care about the final one [10:49]. From Scratch: It's set to check the incoming data from the webhook. It looks at a header called x-boldsign-event and only continues if the value equals "Completed" [11:02]. This means it will ignore the "Signed" event (when just one person signs) and only proceed when both parties have signed. Node: Retrieve Tenant Email (Set) What it is: This node digs into the large JSON data packet from the webhook to find the tenant's email [11:17]. From Scratch: It uses a JavaScript .find() function to look through the signerDetails and pull the email for the person whose role was "Tenent" (Tenant). This gives us the unique key to update our spreadsheet. Node: Update Agreement Status as completed (Google Sheets) What it is: The final step\! Just like in Flow 1, this node finds the correct row in the Google Sheet (using the tenant's email) and updates the agreement status column to "Completed" [11:32]. Flow 3: AI-Powered Status Bot (Telegram) This is a bonus flow that lets the owner "chat" with the Google Sheet. Node: Telegram Trigger What it is: This listens for any new message sent to your Telegram bot [11:52]. Node: AI Agent (Langchain Agent) What it is: This is the "brain". It takes the message.text from the Telegram user [12:30]. From Scratch: Its prompt tells it to be a helpful assistant for rental agreements and to use the tools it's given. Node: Google Gemini Chat Model (Google Gemini) What it is: This is the Large Language Model (LLM) that the agent uses to think and form sentences. Node: Fetch Rental Agreements (Google Sheets Tool) What it is: This is not a regular node, but a Tool plugged into the AI Agent [12:35]. From Scratch: You give the AI agent this "tool" and tell it: "This tool, named 'Fetch Rental Agreements', can get all the data from the Google Sheet." When the user asks, "What's the status of Jane Doe's agreement?", the AI knows it must use this tool to get the sheet data before it can answer. Node: Send a text message (Telegram) What it is: This takes the final output from the AI Agent and sends it as a reply to the user in Telegram.

Streamline your recruitment process with AI-powered resume analysis that goes beyond keyword matching. Overview This workflow revolutionizes hiring by using specialized AI agents to intelligently analyze resumes for different positions. Unlike traditional ATS systems that rely on keyword matching, this solution provides deep, contextual analysis of candidate qualifications and automatically manages the entire screening process from application to response. How it works Application Submission - Candidates complete a form with personal details, select their desired position (ICT, Customer Care, Accounting, or HR), and upload their resume Secure Storage - Resumes are automatically saved to Google Drive for permanent record-keeping Intelligent Routing - A switch node classifies applications by position and routes them to specialized AI agents AI Analysis - Position-specific agents (each with customized prompts and guardrails) extract text from PDFs and rate candidates on a 1-10 scale with detailed commentary CRM Integration - All data (timestamp, candidate info, position, score, AI comments, resume link) flows into Google Sheets for easy tracking Automated Response - A secondary workflow sends interview invitations to high-scoring candidates (7-10) and professional rejection emails to others (below 7) Key Benefits ✅ Contextual Analysis - AI understands skills and experience, not just keywords ✅ Faster Hiring - Close applications once you have enough qualified candidates ✅ No Expertise Required - HR teams don't need technical knowledge in every field ✅ Fully Automated - From submission to interview invitation without manual intervention ✅ Customizable - Adjust AI prompts and scoring criteria for each position ✅ Transparent - All AI reasoning is logged for review Set up steps Time to set up: ~30-45 minutes Prerequisites: n8n instance (cloud or self-hosted) Google Drive account Google Sheets account AI provider credentials (OpenAI, Anthropic, or compatible API) Email service (Gmail, SMTP, or other n8n-supported service) Quick Setup: Import the workflow into your n8n instance Connect your Google Drive and Google Sheets accounts Configure your AI provider credentials in the agent nodes Customize AI prompts for each position in the respective agent nodes (detailed instructions in sticky notes) Set up your email service credentials Customize email templates for invitations and rejections Test with sample resumes for each position Deploy your application form and share the link Detailed configuration instructions are included in sticky notes within the workflow. Use Cases Startups scaling their team quickly HR departments handling high application volumes Agencies managing recruitment for multiple clients Companies hiring for specialized technical roles Customization Options Adjust scoring thresholds for each position Modify AI evaluation criteria via prompts Add additional positions with dedicated agents Integrate with your existing HRIS or ATS Add SMS notifications for candidates Note: This workflow includes two separate flows - the main screening workflow and an automated response workflow. Both are included in the download.

Automated SEO Watchlist: Continuous Audits Powered by Decodo, Gemini and Google Sheets Automate continuous SEO audits with Decodo and Gemini AI — live data, smart insights, and Google Sheets tracking with team alerts. Who’s it for This workflow is designed for SEO specialists, marketing teams, agencies, and website owners who want an effortless, automated way to monitor SEO health. It’s perfect for ongoing audits, content monitoring, and proactive SEO management — without the manual workload. How it works / What it does Every five days, the workflow: Reads a list of URLs from Google Sheets. Uses Decodo to fetch live on-page data — titles, meta descriptions, headings, schema, links, and Core Web Vitals. Passes that data to Gemini AI for an advanced SEO analysis and scoring based on key factors (content, metadata, links, speed, and structure). Parses results via a Structured Output Parser for clean JSON output. Stores findings in Google Sheets and sends a Telegram alert when the audit completes. Why Decodo matters Decodo is the backbone of this workflow. It powers the real-time page inspection, ensuring Gemini AI has complete, accurate data to analyze. Decodo transforms static audits into live, intelligent monitoring — making your SEO insights far more actionable and reliable. How to set up Connect your Decodo API credentials. Add your Google Sheets URL list. Configure your Telegram bot credentials. Enable the workflow — it runs automatically every 5 days. Requirements Decodo API credentials Google Sheets OAuth connection Telegram Bot token n8n instance (Cloud or Self-hosted) How to customize the workflow Change the trigger interval in the Schedule Trigger node. Modify the SEO Analyzer (LLM Chain) weights for different scoring. Extend the Store Result node to integrate with dashboards or databases. Adjust the AI prompt for additional SEO checks (e.g., backlinks, readability, image optimization). ✅ Highlights Automated SEO auditing Real-time data from Decodo Smart analysis powered by Gemini AI Structured reporting in Google Sheets Team notifications via Telegram

Who is this for This workflow is designed for content creators, digital marketers, bloggers, and businesses who need to produce high-quality, SEO-optimized blog posts and newsletters at scale. Perfect for marketing teams, content agencies, solopreneurs, and anyone looking to automate their content creation process while maintaining professional quality. What it does This multi-agent AI system generates complete, research-backed blog posts and newsletters automatically. Four specialized AI agents work in sequence: the Research Agent gathers facts and sources, the Outline Agent structures the content, the Writer Agent creates engaging Medium-style prose, and the Editor Agent polishes and optimizes for search engines. The workflow automatically routes content to either blog format (with DALL-E generated featured images) or newsletter format based on your input, then saves everything to Airtable or Google Sheets for easy management. Requirements OpenRouter API key (for Grok AI model) Google Gemini API key OpenAI API key (for DALL-E image generation) Airtable account Google Sheets account (for newsletters) Telegram bot token (optional, for notifications) How to set up Import the workflow into your n8n instance Add your API credentials to each language model node (OpenRouter, Google Gemini, OpenAI) Configure your Airtable base ID and table ID in the "Save Blog to Airtable" node Set your Google Sheets document ID in the "Save Newsletter to Google Sheets" node (Optional) Add your Telegram bot token and chat ID for notifications Test the workflow by submitting the form with a sample topic How to customize the workflow You can easily adapt this workflow to your specific needs. Replace the AI models with your preferred providers (Claude, GPT-4, Llama, etc.) by swapping the language model nodes. Modify the agent prompts to change writing style, tone, or target audience. Add additional agents for fact-checking, plagiarism detection, or brand voice alignment. Connect the output directly to publishing platforms like WordPress, Medium, Webflow, or email marketing services like Mailchimp. Adjust the image generation parameters to match your brand aesthetic, or skip image generation entirely if not needed.

This workflow automates the entire process of creating SEO-optimized meta titles and descriptions. It analyzes your webpage, spies on top-ranking competitors for the same keywords, and then uses a multi-step AI process to generate compelling, length-constrained meta tags. 🤖 How It Works This workflow operates in a three-phase process for each URL you provide: Phase 1: Self-Analysis When you add a URL to a Google Sheet with the status "New", the workflow scrapes your page's content. The first AI then performs a deep analysis to identify the page's primary keyword, semantic keyword cluster, search intent, and target audience. Phase 2: Competitor Intelligence The workflow takes your primary keyword and performs a live Google search. A custom code block intelligently filters the search results to identify true competitors. A second AI analyzes their meta titles and descriptions to find common patterns and successful strategies. Phase 3: Master Generation & Update The final AI synthesizes all gathered intelligence—your page's data and the competitor's winning patterns—to generate a new, optimized meta title and description. It then writes this new data back to your Google Sheet and updates the status to "Generated". ⚙️ Setup Instructions You should be able to set up this workflow in about 10-15 minutes ⏱️. 🔑 Prerequisites You will need the following accounts and API keys: A Google Account with access to Google Sheets. A Google AI / Gemini API key. A SerpApi key for Google search data. A ScrapingDog API key for reliable website scraping. 🛠️ Configuration Google Sheet Setup: Create a new Google Sheet. The workflow requires the following columns: URL, Status, Current Meta Title, Current Meta Description, Generated Meta Title, Generated Meta Description, and Ranking Factor. Add Credentials: Google Sheets Nodes: Connect your Google account credentials to the Google Sheets Trigger & Google Sheets nodes. Google Gemini Nodes: Add your Google Gemini API key to the credentials for all three Google Gemini Chat Model nodes. Scrape Website Node: In this HTTP Request node, go to Query Parameters and replace <your-api-key> with your ScrapingDog API key. Googl SERP Node: In this HTTP Request node, go to Query Parameters and replace <your-api-key> with your SerpApi API key. Configure Google Sheets Nodes: Copy the Document ID from your Google Sheet's URL. Paste this ID into the "Document ID" field in the following nodes: Google Sheets Trigger, Get row(s) in sheet1, and Update row in sheet. In each of those nodes, select the correct sheet name from the "Sheet Name" dropdown. ✅ Activate Workflow Save and activate the workflow. To run it, simply add a new row to your Google Sheet containing the URL you want to process and set the "Status" column to New.