Gmail and Google Gemini Chat Model integration

This project presents an intelligent email management system powered by advanced artificial intelligence. It utilizes Google's Gemini 2.0 AI model to automatically categorize incoming emails into queries, project updates, and feedback, and generates context-specific responses in real time. Approach: The system processes emails promptly, ensuring consistent and timely communication. In addition to crafting automated replies, it streamlines workflow efficiency by sending calendar invitations for meetings without manual intervention. Results: The Smart Email Auto-Responder enhances email management by marking emails as read, applying appropriate labels, and systematically logging correspondence. This significantly reduces manual workload while improving client engagement and operational productivity.

Turn raw feedback into actionable product insights. This workflow collects feedback from both customers and staff via a single Jotform, uses Gemini AI to analyze and categorize it, then intelligently routes it: Actionable bugs and feature requests* become tasks in specific Trello* lists, tagged with source and priority. General feedback* is logged in a structured Airtable* base for later review. Urgent bugs* trigger instant Slack* alerts for your dev team. An optional confirmation email is sent via Gmail if the submitter provides their address. Stop manually sorting feedback and ensure nothing falls through the cracks. This workflow centralizes input, automates triage, and delivers structured data directly to your product and development teams. Features Unified Feedback Collection:** Uses a single Jotform for customers and staff. AI-Powered Triage:** Gemini AI categorizes feedback (Bug, Feature Request, General), suggests priority, and extracts keyword tags. Intelligent Filtering:** An IF node separates actionable tasks from general comments. Automated Task Creation:** Creates Trello cards in specific lists ("Bugs," "Feature Backlog") with relevant labels (Source, Urgent). Structured Logging:** Saves all general feedback to an Airtable base for review and trend analysis. Conditional Alerts:* Notifies a Slack channel *only for high-priority bugs. Optional Email Confirmation:** Sends a thank-you email if the submitter provides their address. Nodes Used 🟣 Jotform Trigger (Jotform Trigger) ✉️ Gmail (Send Confirmation Email) 🧠 AI Agent (AI Feedback Triage) 🃏 Trello (Create Trello Card) 📣 Slack (Alert Dev Team) 🗂️ Airtable (Log General Feedback to Airtable) 🔧 Set, **❓ IF, 🚫 No Operation, do nothing How to use this template Follow these steps to configure the workflow with your accounts and specific IDs. Set up Jotform, Trello, and Airtable (CRITICAL) Before starting, you must create the Jotform form, Trello board, and Airtable base exactly as described in the "Required Setup" section at the end of this document. Configure the Jotform Trigger Node Credentials:** Connect your Jotform account. Form:** Select your "Help us improve IdeaToBiz" form (replace the title with your company name). Resolve Data:* Ensure the "Resolve Data" toggle in the node's parameters is turned ON*. Configure the Config (Set) Node This node stores your Trello IDs. You must replace the placeholder values. Find Your IDs:** Open your Trello board, add .json to the URL, and press Enter. Search the JSON page for your List names ("Bugs," "Feature Backlog") and Label names ("Customer," "Staff," "Other," "Urgent") to find their corresponding "id" values. Action:** Paste your unique IDs into the value fields in this node. Configure the Email Provided? (IF) and Send Confirmation Email (Gmail) Nodes IF Node:** No configuration needed. Gmail Node:** Credentials: Connect your Gmail (or other email service) account. Customize: Edit the Subject and Body to match your company's voice. Configure the AI Feedback Triage Node Credentials:** Connect your Google AI (Gemini) credentials. Check Prompt:** Ensure the prompt correctly references your feedback field (e.g., {{ $('Jotform Trigger').item.json['Feedback Details'] }}). Check Schema:** Ensure the "Structured Output" JSON schema matches the required fields (task_title, category, suggested_priority, tags). Configure the Is it a Bug or Feature? (IF) Node No configuration needed. This node filters based on the AI output. Configure the Create Trello Card Node Credentials:** Connect your Trello credentials. Board ID:** Select your Product Feedback board. Check Expressions:** Verify that the expressions for List ID and Labels correctly pull the IDs from your Config node and data from the AI Feedback Triage and Jotform Trigger nodes. The template should be pre-filled, but double-check node names if you renamed them. Configure the Is it an Urgent Bug? (IF) Node No configuration needed. This checks the AI output before alerting Slack. Configure the Alert Dev Team (Slack) Node Credentials:** Connect your Slack credentials. Channel:** Select the channel for urgent bug alerts (e.g., #dev-alerts). Customize:** Edit the message text if desired. Ensure the Trello card URL expression ({{ $('Create Trello Card').item.json.shortUrl }}) is correct. Configure the Log General Feedback to Airtable Node Credentials:** Connect your Airtable credentials. Base ID:** Select your Product Feedback Log base. Table ID:** Select your Feedback Submissions table. Enable Typecast:* In the node's Options, ensure the *Typecast toggle is ON. This is crucial for allowing n8n to create new tag options in Airtable. Check Field Mappings:** Verify that the field mappings correctly reference the AI Feedback Triage and Jotform Trigger nodes. Activate Your Workflow! Once all credentials and IDs are configured, save and activate your workflow. How to Adapt the Template Change Task Destination:* Replace the Trello node with ClickUp, *Asana, Jira, or another task manager. You'll need to adapt the field mappings. Change Logging Destination:* Replace the Airtable node with Google Sheets, *Notion, or send logs via Email or Discord. Adjust AI Prompt:** Modify the prompt in the AI Feedback Triage node to change how feedback is categorized, prioritized, or tagged. Modify Filtering Logic:** Change the conditions in the Is it a Bug or Feature? IF node (e.g., maybe you also want "UI/UX Issue" to go to Trello). Refine Alerting:** Change the conditions in the Is it an Urgent Bug? IF node or send alerts for different categories (e.g., alert the design team for UI issues). Required Setup Jotform Form Setup Create Account: If needed, sign up at Jotform. Create Form: Build a form titled "Help us improve IdeaToBiz" (or similar). Add Fields: Radio Button: Label I am a..., Options Customer, Staff, Other (Required: ON). Email: Label Your Email (Optional) (Required: OFF). Long Text: Label Feedback Details (Required: ON). Submit Button: Label Submit Feedback. Trello Board Setup Create Board: Create a new Trello board named Product Feedback. Create Lists (Columns): Add at least these two lists: Feature Backlog Bugs Create Labels: Go to Menu -> More -> Labels and create: Urgent (Red recommended) Customer (Blue recommended) Staff (Green recommended) Other (Grey recommended) Airtable Base Setup Create Base: Create a new Airtable base named Product Feedback Log. Create Table: Name the table Feedback Submissions. Configure Fields: Rename the primary field (Name) to Feedback Summary (Type: Single line text). Rename Notes to Full Feedback (Type: Long text). Delete Assignee. Rename Status to Source (Type: Single select, Options: Customer, Staff, Other). Add Email field (Type: Email). Add AI Tags field (Type: Multiple select). Add Submitted At field (Type: Created time).

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.

What this workflow does This workflow creates an automated web scraper that accepts form submissions, extracts specific data from any website using AI, and emails the results back to you. Step by step: Web Scraper Form Submission provides a web form interface where users submit a URL and specify what data to extract Get HTML from Source URL fetches the complete HTML content from the provided website HTML Extractor processes the raw HTML and extracts the body content for analysis Data Extractor LLM Chain uses Google Gemini AI to intelligently analyze the content and extract only the specific data requested by the user Structured Output Parser formats the AI response into clean JSON structure with standardized format Gmail Send Result delivers the extraction results via email including the source URL, extraction request details, and clean extracted results How to set up Connect your Google Gemini API to the Google Gemini Chat Model node for AI-powered data extraction Connect your Gmail account to the Gmail node for sending result emails Update the recipient email in the Gmail node Customize the extraction prompt in the Data Extractor LLM Chain node based on your specific requirements How to customize this workflow to your needs Switch AI models**: Replace Google Gemini with OpenAI, Claude, or other LLM providers in the Chat Model node based on your accuracy requirements and budget preferences Change result delivery**: Replace Gmail with Google Sheets for data storage, Outlook for corporate email, Slack for team notifications, or webhook integrations for custom applications Customize extraction prompts**: Modify the LLM prompt in the Data Extractor Chain to handle specific data types, extraction formats, or industry-specific terminology for your use case Need help customizing? Contact me for consulting and support: 📧 [email protected]

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automated Research Reports with AI and Tavily Search An intelligent research automation workflow designed for Japanese users that transforms user queries into comprehensive HTML reports via email. Using Google Gemini AI and Tavily search, this workflow generates optimized search queries, conducts multi-perspective research, and delivers structured analysis reports in Japanese. Who's it for Content creators, researchers, analysts, and businesses in Japan who need comprehensive research reports on various topics without manual information gathering. Particularly valuable for Japanese professionals conducting competitive analysis, market research, and technical comparisons who prefer reports in their native language. How it works The workflow follows a strategic four-step process: Query Optimization: Google Gemini AI analyzes user input and generates three optimized search queries for comprehensive coverage Multi-Query Research: Tavily's advanced search executes all queries with deep search parameters and AI-generated answers Report Synthesis: Another Gemini AI model consolidates findings, eliminates duplicates, and structures information into readable HTML format Email Delivery: Gmail automatically sends the final HTML report to specified recipients Requirements Google Gemini API credentials (for three separate AI nodes) Tavily API credentials for advanced search functionality Gmail authentication for email delivery Basic n8n workflow execution permissions How to set up Configure API credentials in all Google Gemini and Tavily nodes Update email settings in the "Send a message" node with your recipient address Customize your query in the "Edit Fields" node (default: "n8nとdifyの違い") Test the workflow to ensure all connections work properly How to customize the workflow Research depth: Increase max_results in Tavily search for more comprehensive data gathering. Query optimization: Modify system prompts in the Query Generator for domain-specific searches. Report format: Adjust the Report Agent's system message to change output structure, language, or focus areas. Multi-recipient delivery: Duplicate the Gmail node for multiple email destinations. The workflow processes Japanese and English queries effectively, with built-in support for Japanese language output, making it ideal for Japanese professionals who need multilingual research capabilities. Advanced search parameters ensure high-quality, relevant results for professional research applications.

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.

How it works This workflow acts like your own personal AI assistant, automatically fetching and summarizing the most relevant Security, Privacy, and Compliance news from curated RSS feeds. It processes only the latest articles (past 24 hours), organizes them by category, summarizes key insights using AI, and delivers a clean HTML digest straight to your inbox—saving you time every day. Key Highlights Handles three independent tracks: Security, Privacy, and Compliance Processes content from customizable RSS sources (add/remove easily) Filters fresh articles, removes duplicates, and sorts by recency Uses AI to summarize and format insights in a digestible format Sends polished HTML digests via Gmail—one per category Fully modular and extensible—adapt it to your needs Personalization You can easily tailor the workflow: 🎯 Customize feeds: Add or remove sources in the following Code nodes: Fetch Security RSS, Fetch Privacy Feeds, and Fetch Compliance Feeds 🔧 Modify logic: Adjust filters, sorting, formatting, or even AI prompts as needed 🧠 Bring your own LLM: Works with Gemini, but easily swappable for other LLM APIs Setup Instructions Requires Gmail and LLM (e.g., Gemini) credentials Prebuilt with placeholders for RSS feeds and email output Designed to be readable, maintainable, and fully adaptable

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.

Zoho CRM - Smart Meeting Scheduler This workflow automatically schedules meetings for new Zoho CRM leads by detecting their timezone, checking the sales rep’s Google Calendar, generating conflict-free time slots, creating a Zoom meeting and sending a personalized AI-generated email to the lead. If no slots are available, it sends a fallback message to the lead without updating Zoho CRM. When a meeting is created, all details are logged inside Zoho CRM for visibility. ⚡ Quick Implementation Steps (Fast Start Guide) Import the workflow JSON into n8n. Configure Zoho CRM, Google Calendar, Gmail, Zoom OAuth and Gemini AI credentials. Update meeting duration, working hours, buffer time and search window. Set email recipient to the lead’s email instead of test/static values. Add the webhook URL to Zoho CRM → Automation → Webhooks. Test with a new lead and activate the workflow. 📘 What It Does This workflow automates scheduling for new Zoho CRM leads. As soon as a lead is created, it retrieves full lead and owner details, detects the lead’s timezone and checks the assigned sales rep’s upcoming Google Calendar events. This helps identify when the rep is available. Using your settings—working hours, meeting duration, buffer before/after and days to evaluate—the system generates valid meeting time slots with no conflicts. If suitable slots exist, it authenticates with Zoom and creates a meeting for the earliest option, then generates a polished HTML invitation using Gemini AI and emails it to the lead. This ensures a fast, smart and personalized lead engagement process. If no slots exist, the workflow sends a fallback email informing the lead that no availability is open in the next few days. In this branch, Zoho CRM is not updated, because no meeting was scheduled. 🎯 Who’s It For This workflow is perfect for: Sales teams managing high inbound volume CRM managers automating lead qualification & engagement SaaS companies scheduling demos automatically Agencies booking consultation calls Any team struggling with timezone-based scheduling manually 🔧 Requirements to Use This Workflow Platform Requirements n8n (Cloud or self-hosted) Required Integrations Zoho CRM OAuth2 Google Calendar OAuth2 Gmail OAuth2 Zoom OAuth (account-level) Gemini AI / Google PaLM API Required Lead Fields Email (mandatory for sending the invite) Country / State (for timezone detection) Lead Owner (to fetch rep details) 🔄 How It Works Zoho CRM Webhook triggers when a new lead is created. Workflow fetches full lead and owner details. Detects the lead’s timezone using country/state mapping. Fetches the sales rep’s availability from Google Calendar. Generates valid time slots based on working hours, buffers and meeting duration. If slots exist: Authenticate with Zoom Create a Zoom meeting Generate personalized HTML invite using Gemini AI Send email to the lead Log meeting details in Zoho CRM If no slots exist: Generate fallback message Send fallback email to the lead (Zoho CRM is NOT updated in this path) 🛠️ Setup Steps (Configuration Guide) Import Workflow Go to: n8n → Workflows → Import and upload the JSON file. Add Required Credentials Configure the following inside n8n: Zoho CRM OAuth Google Calendar OAuth Gmail OAuth Zoom OAuth Gemini AI API key Update Workflow Configuration Node Set: Meeting duration Buffer before/after Working hours Days to look ahead Default meeting provider (Zoom) Fix Email Recipient In Send Meeting Invite node, set: sendTo = {{$('Detect Lead Timezone').item.json.Email}} yaml Copy code Update Google Calendar Email/ID Ensure the calendar ID matches the sales rep’s Google Calendar. Add Webhook in Zoho CRM Navigate to: Setup → Automation → Webhooks → Create Webhook → Lead Created Paste the webhook URL from n8n. Test the Automation Verify: Correct timezone detection Calendar availability check Zoom meeting creation AI email sent to the lead Zoho CRM updated only when meeting is created Activate Workflow Enable the workflow for live operation. 🧩 How To Customize Nodes Adjust Meeting Logic Modify the Workflow Configuration node to change: Slot duration Buffer time Working hour ranges Days to consider Expand Timezone Detection Edit the Detect Lead Timezone node to add new countries/states. Personalize Email Content Update the prompt inside the Generate Personalized Invite node. Add New Regions Duplicate timezone logic for new regions (Australia, Middle East, etc.) Replace Zoom Swap Zoom with Google Meet, Microsoft Teams or Zoho Meeting. ➕ Add-Ons (Optional Enhancements) Auto-book calendar events when lead confirms a slot WhatsApp notifications via Twilio or Gupshup Slack/Email internal alerts for reps Follow-up reminder emails Log lead activity to Google Sheets Attach downloadable ICS calendar file 💼 Use Case Examples SaaS demo scheduling Consultation & discovery calls Global timezone-based sales teams Onboarding/support calls Event follow-up scheduling (And many more…) 🩻 Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | Lead not receiving email | Gmail OAuth expired / wrong email field | Reconnect Gmail OAuth & fix sendTo value | | Wrong time slots | Incorrect timezone detection | Update mapping in Detect Lead Timezone | | Zoom meeting not created | Invalid/expired Zoom OAuth | Reconnect Zoom credentials | | CRM not updated after fallback email | Expected behavior | No CRM update when slots don’t exist | | Workflow not triggering | Missing Zoho webhook | Re-add webhook | | Empty AI email | Gemini key incorrect | Reconfigure Gemini credentials | 🤝 Need Help? If you want assistance setting up, customizing or extending this workflow, the n8n automation team at WeblineIndia is here to help. We specialize in: Advanced automation workflows Multi-timezone scheduling systems CRM-integrated AI communication Custom Zoho + n8n development End-to-end automation architecture 👉 Contact WeblineIndia for expert workflow development and enhancements.

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.

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.

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

Improve your chess automatically — get a personalized AI coaching report delivered. This workflow connects to the free Chess.com public API, fetches your most recent game, and sends it to an AI language model that acts as your personal chess coach. Within minutes, you receive a structured HTML email covering everything from critical turning points to a personalized training plan. 🔧 How It Works Trigger — Runs on a daily schedule or manually on demand Config Node — Set your Chess.com username and email address (one-time setup) Fetch Games — Pulls your current month's games from Chess.com's public API (no API key required) Sort & Enrich — Identifies your color, result (Win/Loss/Draw), opponent details, ratings, and ECO opening code AI Analysis — Sends the full PGN and game context to your chosen LLM with a structured coaching prompt Email Report — Delivers a clean HTML coaching report directly to your inbox via Gmail 📊 What's in the Coaching Report Game Summary — Opening, middlegame, and endgame narrative Critical Moments — 3–5 turning points with explanations of what happened and what should have been played Mistake Categories — Tactical oversights, positional errors, opening issues, endgame technique, time management What Went Well — Genuine strengths recognized and reinforced Five Key Lessons — Specific, memorable takeaways tied to your actual game Training Plan — Targeted drills and study resources based on your weaknesses Closing Motivation — Encouraging next step to keep you improving ⚙️ Setup (Under 5 Minutes) Import the workflow into n8n Open the Config node and enter your Chess.com username and target email address Connect your Gmail OAuth2 credential Connect your preferred LLM credential (Google Gemini is pre-wired; swap for OpenAI or Claude if preferred) Activate the workflow — done! 🤖 Supported AI Models The quality of the results depends on the model you choose. You can start with the free Gemini models and compare the output with your expected results. The LLM node is plug-and-play, allowing you to switch between different models with a single click. Google Gemini 2.5 Flash (pre-configured) OpenAI GPT-4o — Best overall chess analysis quality Anthropic Claude Sonnet — Excellent at explanations and coaching tone Mistral / Llama — Self-hosted options for privacy-conscious users 💡 Stronger models produce better analysis. GPT-4o or Claude Sonnet are recommended for players rated 1000+. 📬 Extend the Workflow After the email step, you can easily add nodes to also send the report via: Telegram — instant mobile notifications Slack — post to a personal or team channel Notion — build a game review database Google Drive — archive reports as files Discord — share with your chess study group ✅ Requirements n8n (self-hosted or cloud) A Chess.com account with at least one game this month Gmail OAuth2 credential Any supported LLM API credential (Google Gemini, OpenAI, Anthropic, etc.)

This template and YouTube video goes over 5 different implementations of evaluations within n8n. Categorization Correctness Tools used String similarity Helpfulness You’ll learn when to use each type, how to set up test datasets in Google Sheets or data tables, and how to track your results over time. I also explain best practices like only changing one variable at a time, documenting your prompts and model settings, and building proper training datasets with enough examples to confidently validate your workflow. YouTube Video: https://www.youtube.com/watch?v=-4LXYOhQ-Z0 Thank you for downloading our free n8n Evaluations template. If you enjoyed the template + tutorial please subscribe to the YouTube channel. We are uploading weekly content on AI/n8n Connect With Us Check out the links down below. If you need help with this template, want 1:1 coaching, or have a n8n project you want to build, reach out at [email protected] Free Skool AI/n8n Group: https://www.skool.com/data-and-ai LinkedIn: https://www.linkedin.com/in/ryan-p-nolan/ Twitter/X:https://x.com/RyanMattDS Website: https://ryanandmattdatascience.com/

💬 AI Gmail Support Automation with Google Gemini, OpenAI & Pinecone 🚀 How it Works This workflow turns your Gmail inbox into an AI-powered customer support assistant using Google Gemini, OpenAI embeddings, and Pinecone vector search. It automatically classifies incoming emails, retrieves context-based answers from your knowledge base, and replies instantly saving your support team valuable time. 🔁 Workflow Overview Gmail Trigger** → Detects new incoming customer emails. Intent Classifier** → Identifies if the email is a support query or something else. Vector Store (Pinecone)** → Retrieves the most relevant information. Email Support Agent (Gemini)** → Generates a clear, human-like response. Gmail Node** → Sends the AI-generated reply automatically. Slack Notification** → Updates your team about the response. Label Query** → Adds Gmail labels for tracking and organization. This automation provides 24/7 AI-based email support, faster customer responses, and zero manual data lookup — ideal for busy teams handling repetitive queries. 👥 Who It’s For SaaS companies** managing frequent customer support requests Startups and agencies** looking to automate inbox replies Customer success teams** aiming to improve response time Freelancers or small businesses** who want smart, auto-handled Gmail support ⚙️ Set Up Steps Estimated setup time: 10–15 minutes Connect your Gmail and Slack accounts to n8n. Add your API keys: Google Gemini API key OpenAI API key Link your Pinecone Vector Database (or create a new one). Customize the system message in the “Email Support Agent” node to match your tone or brand style. Send test emails to ensure the automation responds correctly and labels messages as intended. Check Slack notifications to confirm your team gets updates on replies. 💡 Detailed setup notes are included in the sticky notes inside the workflow. 🧩 Integrations Used Gmail API Google Gemini LLM OpenAI Embeddings Pinecone Vector Database Slack API 💡 Key Benefits Provides instant AI-based email replies 24/7 Reduces manual workload for support teams Maintains consistent and accurate tone using your knowledge base Keeps your inbox organized with automatic labels and team alerts Ideal for scaling customer support without hiring more agents

Generate AEO strategy from brand input using AI competitor analysis This workflow automatically creates a comprehensive Answer Engine Optimization (AEO) strategy by identifying your top competitors, analyzing their positioning, and generating custom recommendations to help your brand rank in AI-powered search engines like ChatGPT, Perplexity, and Google SGE. Who it's for This template is perfect for: Digital marketing agencies** offering AEO services to clients In-house marketers** optimizing content for AI search engines Brand strategists** analyzing competitive positioning Content teams** creating AI-optimized content strategies SEO professionals** expanding into Answer Engine Optimization What it does The workflow automates the entire AEO research and strategy process in 6 steps: Collects brand information via a user-friendly web form (brand name, website, niche, product type, email) Identifies top 3 competitors using Google Gemini AI based on product overlap, market position, digital presence, and geographic factors Scrapes target brand website with Firecrawl to extract value propositions, features, and content themes Scrapes competitor websites in parallel to gather competitive intelligence Generates comprehensive AEO strategy using OpenAI GPT-4 with 15+ actionable recommendations Delivers formatted report via email with executive summary, competitive analysis, and implementation roadmap The entire process runs automatically and takes approximately 5-7 minutes to complete. How to set up Requirements You'll need API credentials for: Google Gemini API** (for competitor analysis) - Get API key OpenAI API** (for strategy generation) - Get API key Firecrawl API** (for web scraping) - Get API key Gmail account** (for email delivery) - Use OAuth2 authentication Setup Steps Import the workflow into your n8n instance Configure credentials: Add your Google Gemini API key to the "Google Gemini Chat Model" node Add your OpenAI API key to the "OpenAI Chat Model" node Add your Firecrawl API key as HTTP Header Auth credentials Connect your Gmail account using OAuth2 Activate the workflow and copy the form webhook URL Test the workflow by submitting a real brand through the form Check your email for the generated AEO strategy report Credentials Setup Tips For Firecrawl: Create HTTP Header Auth credentials with header name Authorization and value Bearer YOUR_API_KEY For Gmail: Use OAuth2 to avoid authentication issues with 2FA Test each API credential individually before running the full workflow How it works Competitor Identification The Google Gemini AI agent analyzes your brand based on 4 weighted criteria: product/service overlap (40%), market position (30%), digital presence (20%), and geographic overlap (10%). It returns structured JSON data with competitor names, URLs, overlap percentages, and detailed reasoning. Web Scraping Firecrawl extracts structured data from websites using custom schemas. For each site, it captures: company name, products/services, value proposition, target audience, key features, pricing info, and content themes. This runs asynchronously with 60-second waits to allow for complete extraction. Strategy Generation OpenAI GPT-4 analyzes the combined brand and competitor data to generate a comprehensive report including: executive summary, competitive analysis, 15+ specific AEO tactics across 4 categories (content optimization, structural improvements, authority building, answer engine targeting), content priority matrix with 10 ranked topics, and a detailed implementation roadmap. Email Delivery The strategy is formatted as a professional HTML email with clear sections, visual hierarchy, and actionable next steps. Recipients get an immediately implementable roadmap for improving their AEO performance. How to customize the workflow Change AI Models Replace Google Gemini** with Claude, GPT-4, or other LLM in the competitor analysis node Replace OpenAI** with Anthropic Claude or Google Gemini in the strategy generation node Both use LangChain agent nodes, making model swapping straightforward Modify Competitor Analysis Find more competitors**: Edit the AI prompt to request 5 or 10 competitors instead of 3 Add filtering criteria**: Include factors like company size, funding stage, or geographic focus Change ranking weights**: Adjust the 40/30/20/10 weighting in the prompt Enhance Data Collection Add social media scraping**: Include LinkedIn, Twitter/X, or Facebook page analysis Pull review data**: Integrate G2, Capterra, or Trustpilot APIs for customer sentiment Include traffic data**: Add SimilarWeb or Semrush API calls for competitive metrics Change Output Format Export to Google Docs**: Replace Gmail with Google Docs node to create shareable documents Send to Slack/Discord**: Post strategy summaries to team channels for collaboration Save to database**: Store results in Airtable, PostgreSQL, or MongoDB for tracking Create presentations**: Generate PowerPoint slides using automation tools Add More Features Schedule periodic analysis**: Run monthly competitive audits for specific brands A/B test strategies**: Generate multiple strategies and compare results over time Multi-language support**: Add translation nodes for international brands Custom branding**: Modify email templates with your agency's logo and colors Adjust Scraping Behavior Change Firecrawl schema**: Customize extracted data fields based on industry needs Add timeout handling**: Implement retry logic for failed scraping attempts Scrape more pages**: Extend beyond homepage to include blog, pricing, and about pages Use different scrapers**: Replace Firecrawl with Apify, Browserless, or custom solutions Tips for best results Provide clear brand information**: The more specific the product type and niche, the better the competitor identification Ensure websites are accessible**: Some sites block scrapers; consider adding user agents or rotating IPs Monitor API costs**: Firecrawl and OpenAI charges can add up; set usage limits Review generated strategies**: AI recommendations should be reviewed and customized for your specific context Iterate on prompts**: Fine-tune the AI prompts based on output quality over multiple runs Common use cases Client onboarding** for marketing agencies - Generate initial AEO assessments Content strategy planning** - Identify topics and angles competitors are missing Quarterly audits** - Track competitive positioning changes over time Product launches** - Understand competitive landscape before entering market Sales enablement** - Equip sales teams with competitive intelligence Note: This workflow uses community and AI nodes that require external API access. Make sure your n8n instance can make outbound HTTP requests and has the necessary LangChain nodes installed.

This workflow automates the process of extracting structured, usable information from unstructured email messages across multiple platforms. It connects directly to Gmail, Outlook, and IMAP accounts, retrieves incoming emails, and sends their content to an AI-powered parsing agent built on OpenAI GPT models. The AI agent analyzes each email, identifies relevant details, and returns a clean JSON structure containing key fields: From** – sender’s email address To** – recipient’s email address Subject** – email subject line Summary** – short AI-generated summary of the email body The extracted information is then automatically inserted into an n8n Data Table, creating a structured database of email metadata and summaries ready for indexing, reporting, or integration with other tools. Key Benefits ✅ Full Automation: Eliminates manual reading and data entry from incoming emails. ✅ Multi-Source Integration: Handles data from different email providers seamlessly. ✅ AI-Driven Accuracy: Uses advanced language models to interpret complex or unformatted content. ✅ Structured Storage: Creates a standardized, query-ready dataset from previously unstructured text. ✅ Time Efficiency: Processes emails in real time, improving productivity and response speed. ✅ Scalability:* Easily extendable to handle additional sources or extract more data fields. How it works This workflow automates the transformation of unstructured email data into a structured, queryable format. It operates through a series of connected steps: Email Triggering: The workflow is initiated by one of three different email triggers (Gmail, Microsoft Outlook, or a generic IMAP account), which constantly monitor for new incoming emails. AI-Powered Parsing & Structuring: When a new email is detected, its raw, unstructured content is passed to a central "Parsing Agent." This agent uses a specified OpenAI language model to intelligently analyze the email text. Data Extraction & Standardization: Following a predefined system prompt, the AI agent extracts key information from the email, such as the sender, recipient, subject, and a generated summary. It then forces the output into a strict JSON structure using a "Structured Output Parser" node, ensuring data consistency. Data Storage: Finally, the clean, structured data (the from, to, subject, and summarize fields) is inserted as a new row into a specified n8n Data Table, creating a searchable and reportable database of email information. Set up steps To implement this workflow, follow these configuration steps: Prepare the Data Table: Create a new Data Table within n8n. Define the columns with the following names and string type: From, To, Subject, and Summary. Configure Email Credentials: Set up the credential connections for the email services you wish to use (Gmail OAuth2, Microsoft Outlook OAuth2, and/or IMAP). Ensure the accounts have the necessary permissions to read emails. Configure AI Model Credentials: Set up the OpenAI API credential with a valid API key. The workflow is configured to use the model, but this can be changed in the respective nodes if needed. Connect the Nodes: The workflow canvas is already correctly wired. Visually confirm that the email triggers are connected to the "Parsing Agent," which is connected to the "Insert row" (Data Table) node. Also, ensure the "OpenAI Chat Model" and "Structured Output Parser" are connected to the "Parsing Agent" as its AI model and output parser, respectively. Activate the Workflow: Save the workflow and toggle the "Active" switch to ON. The triggers will begin polling for new emails according to their schedule (e.g., every minute), and the automation will start processing incoming messages. Need help customizing? Contact me for consulting and support or add me on Linkedin.

🧠 AI-Powered Outreach Engine (Jotform + Gemini AI + HeyReach + Data Tables) 🚀 Overview This workflow turns every Jotform submission — whether from your website or a live marketing campaign — into a fully automated, AI-personalized outreach sequence. Using Google Gemini AI, it instantly generates LinkedIn messages and email content tailored to each lead’s company and context. Depending on the data provided (like LinkedIn profile or email), it automatically routes the message to the right platform — HeyReach for LinkedIn outreach or Gmail for email follow-up — and logs all activity into n8n Data Tables for tracking and visibility. The result? Zero manual copywriting, zero campaign setup, and instant activation of every inbound lead through personalized, human-sounding communication. ⚙️ What It Does Trigger:** Starts when a new submission is received from a Jotform attached to your website or ongoing campaign. Lead Enrichment (Optional):** You can add an enrichment node (like Clearbit) to pull company, role, and domain details. AI Message Generation:** Uses Google Gemini AI (LangChain) to write both a LinkedIn outreach message and a short, conversational email. Each message is context-aware — referencing the company, role, or query captured from the Jotform submission. Conditional Routing Logic:** If the form includes a LinkedIn URL, the workflow sends the lead and message to HeyReach, adding them to the correct campaign automatically. If not, it sends the email variant via Gmail, ensuring no lead is missed. Data Tracking:** All lead details, messages, and campaign statuses are automatically saved into n8n Data Tables, creating a single source of truth for your outreach history. Result:** Personalized, multi-channel follow-up happens in seconds — turning inbound form leads into active, engaged prospects instantly. 🧠 Example Use Case Imagine a SaaS or marketing agency running a “Request a Demo” or “Get Pricing” campaign via a Jotform on their website. With this workflow, every time someone fills the form: Their details are captured and stored in n8n Data Tables. Gemini AI instantly writes a relevant, human-sounding LinkedIn and email message. The lead is automatically added to a HeyReach campaign or receives a Gmail follow-up if LinkedIn isn’t available. All statuses (message type, delivery, and timing) are tracked in real time. This workflow replaces hours of manual effort with automated, AI-personalized communication that feels natural — not robotic. 🧩 Ideal For B2B SaaS teams** generating inbound leads through website forms Agencies** managing multi-channel LinkedIn + email campaigns Sales and growth teams** using form submissions for lead capture Marketers** running Jotform-based campaigns looking to instantly activate leads 💡 Key Integrations JotForm** → Capture and trigger workflow from form submissions Google Gemini AI (LangChain)** → Generate personalized LinkedIn & Email messages HeyReach** → Add AI-written messages directly into your LinkedIn campaign Gmail** → Send AI-personalized cold emails automatically n8n Data Tables** → Store, monitor, and analyze every lead and message generated 🧠 Workflow Logic | Step | Node | Description | |------|------|-------------| | 1 | JotForm Trigger | Captures lead data submitted through your form | | 2 | HTTP Request (Optional Enrichment) | Pulls company details from Clearbit or any enrichment API | | 3 | Insert Row (n8n Data Table) | Stores raw lead submission for tracking | | 4 | If Node | Determines if LinkedIn profile URL is available | | 5 | Google Gemini AI (LinkedIn Agent) | Creates personalized LinkedIn message | | 6 | HeyReach Node | Adds lead + message to selected campaign | | 7 | Google Gemini AI (Email Agent) | Generates personalized HTML email | | 8 | Gmail Node | Sends the AI-generated email if no LinkedIn is found | | 9 | Insert Row (n8n Data Table) | Logs campaign status, sent message, and timestamps | 🧾 Example Output (AI Node) { "To": "[email protected]", "Subject": "AI automation ideas for CompanyX 🚀", "Email Type": "LinkedIn or Cold Email", "HTML": "Hey Alex, noticed CompanyX is scaling fast — congrats! 👏At Amply, we help growing businesses use AI-driven automations to eliminate repetitive ops work and boost team productivity by 30–50%.Would it make sense to explore if this could free up your ops bandwidth too?", "Message": "Hey Alex, noticed CompanyX is scaling fast — congrats! 👏 At Amply, we help growing businesses use AI-driven automations to eliminate repetitive ops work and boost team productivity by 30–50%. Would it make sense to explore if this could free up your ops bandwidth too?" }

Who’s it for Teams that collect product feedback with Jotform and want automated triage: instant alerts for urgent issues, knowledge-based replies to questions, and a clean backlog for suggestions. How it works / What it does New Jotform submissions are classified by Feedback Type (comments, questions, suggestions) and analyzed for sentiment. Angry or negative messages trigger a Telegram alert to your support channel. Questions are answered automatically using an agent that consults your internal Google Sheet “Q&A” database, then replies via Gmail with a styled HTML email. Suggestions are summarized, sent to a team chat, and appended to a Google Sheets backlog with name, email, summary, and date. All comments are logged to a structured sheet for reporting. How to set up Connect your Jotform form and map fields (Name, E-mail, feedback text). Add credentials for Google Sheets, Gmail, Telegram, and LLM. Point the agent to your “Q&A” sheet/tab. Test each branch (comments, questions, suggestions) with sample entries. Requirements Jotform account and live form n8n (self-hosted recommended if using community/LLM nodes) Google Sheets, Gmail, Telegram bot, and LLM API keys How to customize the workflow Adjust sentiment thresholds or add new categories in the Switch node. Edit the Gmail HTML template and subject line. Change backlog columns or target sheets/tabs. Add rate-limits, SLA timers, or different alert channels. Best practice: rename all nodes, add a yellow Sticky Note with this description and per-step notes, and group user-config variables in a Set node. Remove any hard-coded IDs before sharing Knowledge base table Suggestions database Sentiment database

🧩 What Problem Does It Solve? In real estate, inquiries come from many sources and often require immediate, personalized attention. Brokers waste significant time manually: Qualifying leads:** Determining if a prospect's budget, neighborhood, and needs match available inventory. Searching listings:** Cross-referencing customer criteria against a large, static database. Data entry:** Moving contact details and search summaries into a CRM like Zoho. Initial follow-up:** Sending an email to confirm the submission and schedule the next step. 🛠️ How to Configure It Jotform & CRM Setup Jotform Trigger:** Replace the placeholder with your specific Jotform ID. Zoho CRM:** Replace the placeholder TEMPLATED_COMPANY_NAME with your actual company name. Gmail:** Replace the placeholder Calendly link YOUR_CALENDLY_LINK in the Send a message node with your real estate consultant's booking link. Database & AI Setup Google Sheets:** Replace YOUR_GOOGLE_SHEET_DOCUMENT_ID and YOUR_SHEET_GID_OR_NAME in both Google Sheets nodes. Your listings must be structured with columns matching the AI prompt (e.g., bedrooms, rent, neighborhoods). AI Models:** Ensure your Google Gemini API key is linked to the Google Gemini Chat Model node. AI Agent Prompt:** The included prompt contains the exact matching and scoring rules for the AI. You can edit this prompt to refine how the AI prioritizes factors like supplier_rating or neighborhood proximity. 🧠 Use Case Examples Small Startups:** Collect High-Quality Leads: New inquiries must be quickly logged for sales follow-up, but manual entry is slow. B2B Sales:** High-Value Lead Enrichment: Need to prioritize leads that match specific product requirements and budget tiers. Travel/Hospitality:** Personalized Itinerary Matching: Quickly match customer preferences (e.g., dates, group size, activity level) to available packages. E-commerce:** Manual Product Recommendation: Sales teams manually recommend expensive, configurable items (e.g., furniture, specialized equipment). If you need any help Get in Touch

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who’s it for Community managers, content marketers, and builders who want a daily, skimmable update from a subreddit—automatically summarized, formatted, and cross-posted to DEV Community. Here is a Link to video hackathon detailing this build. What it does Collects fresh posts from a subreddit (seeded via RSS). Uses the Bright Data node to batch-scrape each post for richer fields (upvotes, comment count, comments). Flattens comments/replies with JMESPath and trims payload size. Summarizes into a Morning Brew–style brief (Top Stories, Quick Hits, Community Q\&A, Comment Spotlight). Converts to clean Markdown and publishes to DEV with HTTP Request. Optional: emails the same digest via Gmail. How to set up Trigger: Start with Manual Trigger; swap to Cron (daily) when ready. RSS → URLs: Set the subreddit RSS of your choice, just add .rss to the end of the subreddit URL. Update AI Prompt to fit your needs Requirements DEV Community API key. Bright Data account + the Bright Data api key Found Here. Optional: LLM provider credentials (OpenAI, Gemini). How to customize Swap DEV publishing for email/Slack; or post both. Add more subreddits and dedupe by URL. Best practices No hardcoded API keys**—use credentials. Pin long-running outputs while building to save credits. Only collect publicly available data with Bright Data.

Who's it for This workflow is perfect for individuals, small businesses, or households who need to: Automatically process and categorize expense receipts Extract structured data from invoices and receipts using AI Store receipts in multiple locations (Google Drive and S3) Send automated email notifications with expense details Send documents to accounting systems via email hooks How it works This comprehensive expense processing workflow combines AI-powered document analysis with automated file management and notifications. Here's the complete flow: Form Submission: Users submit expenses through a web form with receipt upload and category selection (Personal, Business, or Shared/Home) AI Document Processing: The workflow extracts text from PDF receipts using OCR, then uses Google Gemini AI to parse and structure the data into a standardized JSON format including vendor details, amounts, dates, and categorization Smart Routing: Based on the expense category, receipts are automatically routed to different processing paths with category-specific folder organization Multi-Destination Storage: Receipts are uploaded to: Google Drive (organized by year/month folders) S3 cloud storage buckets Different destinations based on expense type Email Notifications: Sends formatted HTML email notifications with complete expense details and links to stored receipts Accounting System Integration: Automatically forwards business expenses to accounting systems via email hooks (customizable per user requirements) Requirements Credentials needed: Google Gemini API**: For AI-powered document analysis Google Drive OAuth2**: For personal and business drive access Gmail OAuth2**: For sending email notifications S3 Storage**: For cloud backup (AWS S3, Wasabi, etc.) Services used: Google Drive (multiple accounts supported) Google Gemini AI Gmail S3-compatible storage Form trigger webhook How to set up Step 1: Configure Credentials Set up Google Gemini API credentials in n8n Configure Google Drive OAuth2 for both personal and business accounts Add Gmail OAuth2 credentials Set up S3 storage credentials Step 2: Update Configuration Replace all placeholder values: YOUR_GEMINI_CREDENTIAL_ID with your Gemini credential ID YOUR_PERSONAL_GDRIVE_CREDENTIAL_ID with personal Drive credential YOUR_BUSINESS_GDRIVE_CREDENTIAL_ID with business Drive credential YOUR_GMAIL_CREDENTIAL_ID with Gmail credential YOUR_S3_CREDENTIAL_ID with S3 credential Update Google Drive folder structure: Replace YOUR_BUSINESS_DRIVE_ID and YOUR_SHARED_DRIVE_ID with actual drive IDs Update the JavaScript code in the three Code nodes with your actual folder mapping Configure email addresses: Replace [email protected] with your notification email Replace [email protected] with your accounting system's email hook (this is a mail hook for uploading documents to small business accounting systems - can be modified per user requirements) Update S3 bucket names: Replace business-expenses, personal-expenses, and shared-expenses with your bucket names Step 3: Set Up Folder Structure Create organized folder structures in your Google Drives: Drive Root/ ├── 2024/ │ ├── January/ │ ├── February/ │ └── ... (all months) ├── 2025/ │ ├── January/ │ └── ... (all months) └── 2026/ └── ... (all months) Step 4: Test the Workflow Activate the workflow Submit a test expense through the form Verify files are uploaded to correct locations Check email notifications are received How to customize the workflow Expense Categories Modify the form dropdown options and conditional logic to add/remove expense categories: Edit the "On form submission" node form fields Update the IF condition nodes for routing Add new processing paths as needed AI Processing Schema Customize the structured output parser schema to extract different fields: Modify the JSON schema in the "Structured Output Parser" node Update the AI system prompt for different extraction requirements Add new fields for specific business needs Storage Destinations Add or modify storage locations: Duplicate upload nodes for additional cloud services Modify folder organization logic in Code nodes Add new conditional routing for different storage rules Email Templates Customize the HTML email template: Edit the email message content in the Gmail node Add/remove expense fields in the table Modify styling and branding Folder Organization Update the JavaScript code in Code nodes to match your folder structure: Modify the CSV data with your actual folder IDs Change the date-based organization logic Add custom folder naming conventions Integration Extensions Extend the workflow with additional integrations: Add Slack notifications Connect to accounting software (QuickBooks, Xero) Integrate with expense management platforms Add approval workflows for business expenses

Upwork Messages Notifications (Gmail to Slack) - Fully Automated Alerts This n8n workflow streamlines how you receive Upwork client messages, sending instant notifications to Slack. It demonstrates two approaches: a code-based extraction and an AI-powered one with Google Gemini. Use Cases Instant Communication:** Get real-time alerts for new Upwork client messages in your team's Slack channel. Improved Responsiveness:** Quickly respond to client inquiries and maintain strong communication. Centralized Notifications:** Keep all your essential work-related notifications in one place. Good to Know The workflow is set to poll your Gmail every 3 minutes for unread Upwork messages, which can be reduced or increased. The AI Information Extractor with Google Gemini provides a more refined and robust method for data parsing compared to custom code. Usage of Google Gemini may incur costs. Refer to Gemini Pricing for updated information. Google Gemini models can be geo-restricted. If you encounter a "model not found" error, it might not be available in your region. How it Works Method 1: Code-Based Extraction Gmail Trigger: The workflow starts by monitoring your Gmail for new, unread emails from "via Upwork". Code Node: A custom JavaScript code block is used to extract the client's name and the message content directly from the email's text. Slack Notification: The extracted client name and message are then formatted and sent as a new message to a designated Slack channel. Method 2: AI-Powered Extraction with Google Gemini (Recommended) Gmail Trigger X: Similar to Method 1, this part also triggers on new unread Upwork emails. Information Extractor (AI): This powerful node, powered by Google Gemini, takes the entire email text and intelligently extracts structured information like the "client" name and the "message" content based on a defined schema. This method is more robust and requires less manual parsing logic. Google Gemini Chat Model: (Implicitly used by the Information Extractor) This node provides the underlying AI capabilities for intelligent information extraction. Send to Slack X: The refined output from the AI Information Extractor (client name and message) is then sent to a Slack channel. How to Use Gmail Credentials: Ensure you have configured your Gmail OAuth2 credentials in n8n for both "Gmail Trigger" nodes. Slack Credentials: Set up your Slack OAuth2 credentials in n8n for both "Send to Slack" nodes and select the desired Slack channel. Google Gemini Credentials: For the AI-powered workflow, you'll need to set up your Google Gemini API key as a credential in n8n. Activate Workflows: Enable both workflows in n8n to start receiving notifications. You can compare the output quality of each method. Requirements n8n instance** (self-hosted or cloud) Gmail Account** connected to Upwork notifications. Slack Workspace** and a designated channel for notifications. Google Gemini API key** for the AI-powered extraction workflow.

WATCH THE n8n STARTER GUIDE 👇 This template is featured in the n8n Starter Guide series. The template is free, but comes with two additional PDFs and a Quick Start video if you grab the full download pack on gumroad. How it works This template is a visual map of many useful n8n nodes. It groups nodes like Triggers, AI tools, and App connectors onto the canvas. Explore the sections to learn about different nodes and easily copy them for your own workflows. It acts as a handy visual reference guide. Set up steps • Setup takes about 5 minutes. • Import the template into your n8n instance. • Explore the node categories visually on the canvas. • A Quick Start video is included in the download pack, along with a prompts PDF and PDF with links to other awesome n8n templates here on the n8n template gallery.

Proxmox AI Agent with n8n and Generative AI Integration This template automates IT operations on a Proxmox Virtual Environment (VE) using an AI-powered conversational agent built with n8n. By integrating Proxmox APIs and generative AI models (e.g., Google Gemini), the workflow converts natural language commands into API calls, enabling seamless management of your Proxmox nodes, VMs, and clusters. Buy My Book: Mastering n8n on Amazon Full Courses & Tutorials: http://lms.syncbricks.com Watch Video on Youtube How It Works Trigger Mechanism The workflow can be triggered through multiple channels like chat (Telegram, email, or n8n's built-in chat). Interact with the AI agent conversationally. AI-Powered Parsing A connected AI model (Google Gemini or other compatible models like OpenAI or Claude) processes your natural language input to determine the required Proxmox API operation. API Call Generation The AI parses the input and generates structured JSON output, which includes: response_type: The HTTP method (GET, POST, PUT, DELETE). url: The Proxmox API endpoint to execute. details: Any required payload parameters for the API call. Proxmox API Execution The structured output is used to make HTTP requests to the Proxmox VE API. The workflow supports various operations, such as: Retrieving cluster or node information. Creating, deleting, starting, or stopping VMs. Migrating VMs between nodes. Updating or resizing VM configurations. Response Formatting The workflow formats API responses into a user-friendly summary. For example: Success messages for operations (e.g., "VM started successfully"). Error messages with missing parameter details. Extensibility You can enhance the workflow by connecting additional triggers, external services, or AI models. It supports: Telegram/Slack integration for real-time notifications. Backup and restore workflows. Cloud monitoring extensions. Key Features Multi-Channel Input**: Use chat, email, or custom triggers to communicate with the AI agent. Low-Code Automation**: Easily customize the workflow to suit your Proxmox environment. Generative AI Integration**: Supports advanced AI models for precise command interpretation. Proxmox API Compatibility**: Fully adheres to Proxmox API specifications for secure and reliable operations. Error Handling**: Detects and informs you of missing or invalid parameters in your requests. Example Use Cases Create a Virtual Machine Input: "Create a VM with 4 cores, 8GB RAM, and 50GB disk on psb1." Action: Sends a POST request to Proxmox to create the VM with specified configurations. Start a VM Input: "Start VM 105 on node psb2." Action: Executes a POST request to start the specified VM. Retrieve Node Details Input: "Show the memory usage of psb3." Action: Sends a GET request and returns the node's resource utilization. Migrate a VM Input: "Migrate VM 202 from psb1 to psb3." Action: Executes a POST request to move the VM with optional online migration. Pre-Requisites Proxmox API Configuration Enable the Proxmox API and generate API keys in the Proxmox Data Center. Use the Authorization header with the format: PVEAPIToken=<user>@<realm>!<token-id>=<token-value> n8n Setup Add Proxmox API credentials in n8n using Header Auth. Connect a generative AI model (e.g., Google Gemini) via the relevant credential type. Access the Workflow Import this template into your n8n instance. Replace placeholder credentials with your Proxmox and AI service details. Additional Notes This template is designed for Proxmox 7.x and above. For advanced features like backup, VM snapshots, and detailed node monitoring, you can extend this workflow. Always test with a non-production Proxmox environment before deploying in live systems. Start with n8n Learn n8n with Amjid Get n8n Book What is Proxmox

🧠 Overview A dual-engine, AI-driven n8n workflow that automates the monitoring of both vendor policy webpages and compliance-related RSS feeds. It intelligently detects recent updates, evaluates their potential risk, and delivers a structured HTML digest categorized by severity — right to your inbox. ⚙️ How It Works 1️⃣ Scheduled Execution ⏰ Runs daily at 3 AM to ensure timely and consistent monitoring. 2️⃣ Dual Data Streams 📰 RSS Feed Monitoring: Ingests articles from selected feeds focused on security, privacy, and compliance. 🌐 Vendor Webpage Monitoring: Fetches specified policy URLs and checks for updates using Last-Modified headers and in-page content analysis. 3️⃣ Content Filtering 🧹 Applies logic to filter out stale or irrelevant data, focusing only on updates within the past 24 hours. 4️⃣ AI-Powered Risk Categorization 🤖 Two dedicated AI agents (one per stream) analyze content to: 📝 Generate a 2-line compliance/risk-focused summary 🚦 Assign a risk score: High, Medium, Low, or Informational 5️⃣ Digest Generation 🖼️ Summaries are grouped by risk level and formatted into a visually polished HTML report, using category-specific styles and color coding. 6️⃣ Email Delivery 📧 Automatically sends out two separate email reports via Gmail: 🗂️ One for vendor webpage updates 📰 One for RSS feed-based vendor news ✨ Key Features 🔁 Automates daily monitoring across feeds and policy pages 🤖 AI-driven summarization and structured risk scoring 🧾 Clean, HTML-formatted digests grouped by risk category 🧩 Fully customizable: feed sources, vendor URLs, AI prompts, and email styling 🛡️ Designed for compliance, security, and risk teams needing proactive intelligence

Smart Email Auto-Responder with AI Classification Automatically Categorize and Reply to Emails using LangChain + Google Gemini + Gmail + SMTP + Brevo This n8n workflow is designed to intelligently manage incoming emails and automatically send personalized responses based on the content. It classifies emails using LangChain's Text Classifier, sends HTML responses depending on the category, and updates Gmail and Brevo CRM accordingly. Key Features Triggers and Classifies Emails Listens for new Gmail messages every hour Uses AI-based classification to identify the type of inquiry For Example: Guest Post YouTube Review Udemy Course Inquiry Responds Automatically Sends professional HTML replies customized for each type Uses SMTP to deliver emails from your domain Enhances Workflow with Automation Marks processed emails as read Applies Gmail labels Adds sender to Brevo contact list Optional AI Chat Integration Uses Google Gemini (PaLM 2) to enhance classification or summarization Tools & Integrations Required Gmail account (OAuth2) LangChain (Text Classifier node) Google Gemini API account SMTP credentials (e.g., Gmail SMTP, Brevo, etc.) Brevo/Sendinblue account and API key Step-by-Step Node Guide Gmail Trigger Polls Gmail every hour for new emails. Filters out internal addresses (e.g., @syncbricks.com). Avoids replying to already-responded emails (Re: subject filter). LangChain Text Classifier Uses AI to categorize the content of the email based on pre-defined categories: Guest Post** Youtube** Udemy Courses** Google Gemini (PaLM) Chat Model (Optional) Provides additional AI support to enhance classification accuracy. Can be used to summarize or enrich the context if needed. Email Send Nodes Each response category has a separate SMTP node with a custom HTML email: Guest Post Inquiry** YouTube Video Inquiry** Udemy Course Inquiry** Gmail: Mark as Read Marks the email so it isn’t processed again. Gmail: Apply Label Adds a label (e.g., Handled by Bot) for organization. Brevo: Create/Update Contact Saves the sender to your CRM for future communication or marketing. Email Templates Included Guest Post Template Includes pricing, website list, submission guidelines, and payment instructions. YouTube Review Template Includes package pricing, review samples, video thumbnails, and inquiry instructions. Step by Step Tutorial GET n8n Now N8N COURSE n8n Book More courses: http://lms.syncbricks.com YouTube Channel: https://youtube.com/@syncbricks How to Use Import the template into your n8n instance. Configure your Gmail OAuth2 and SMTP credentials. Set up your LangChain Text Classifier and Google Gemini API credentials. Update label ID in the Gmail node and ensure all custom fields like from.value[0].name match your use case. Run the workflow and watch it respond intelligently to new inquiries. Best Practices Always test with mock emails first. Keep the Google Gemini node optional if you want to reduce cost/API calls. Use Gmail filters to auto-label certain types of emails. Monitor your Brevo contacts to track new leads. Attribution & Support Developed by Amjid Ali This template took extensive time and effort to build. If you find it useful, please consider supporting my work. Buy My Book: Mastering n8n on Amazon Full Courses & Tutorials: http://lms.syncbricks.com Follow Me Online: LinkedIn: https://linkedin.com/in/amjidali Website: https://amjidali.com YouTube: https://youtube.com/@syncbricks

🚀 AI-Powered Email to Purchase Order Workflow Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets — all without manual effort. ✨ Core Capabilities ⏱ Runs every minute to check unread emails 📧 Filters emails by subject 🤖 Uses Gemini AI to summarize email content & extract structured order details 📅 Formats dates into ISO calendar weeks 📊 Adds product data from Google Sheets to complete order info ✅ Appends final purchase order records into a Google Sheet (without replacing previous ones) 🛠 Setup Essentials 📩 Gmail account for fetching unread emails 🔑 Google Gemini (PaLM) API credentials 📒 Google Sheet with predefined purchase order headers 📖 Activation Guide ⚙️ Configure Gmail & Google Sheets credentials in n8n 🎯 Adjust the subject filter to match your email rules 🔌 Connect Gemini AI with your API credentials 📑 Create a Google Sheet with the required headers ▶️ Activate the workflow and let it run in the background 🎨 Customizing the Workflow 🔍 Email Filters → Change keywords in the filter node to match your purchase order email subjects 🏷 Order Fields → Modify Set and Append to Google Sheet nodes if your schema differs ✍️ AI Instructions → Adjust the AI Agent’s prompt to fit your company’s email style or product details ⏲ Frequency → Update the Cron node if you want to scan emails less often 📂 Target Google Sheet → Point to a different sheet or tab depending on your department or customer

Who's it for This workflow is perfect for sales teams, customer service departments, and businesses that frequently handle spare parts inquiries via email. It's especially valuable for companies managing multiple products with complex pricing structures who want to automate their quotation process while maintaining professional, multilingual communication. What it does This workflow: Monitors your Gmail inbox** for incoming spare parts requests Automatically generates professional HTML price quotes** in the sender's language Sends personalized replies** Uses AI to detect the email language (supports Turkish, English, German, and more) Extracts project or part codes** Fetches pricing data from Google Sheets** Calculates totals accurately** Formats everything** into a clean, professional quote that matches your brand How it works Schedule Trigger runs every minutes to check for new emails Gmail node fetches the latest unread email Keyword detection filters for spare parts-related terms in multiple languages AI Agent processes the request by: Detecting the email's language Extracting project/part codes Querying three Google Sheets: CRM, Bill of Materials, Pricing Calculating line totals and grand total Generating a professional HTML quote in the sender's language Gmail reply sends the quote and marks the original email as read Requirements n8n self-hosted or cloud instance Gmail account with OAuth2 authentication Google Sheets with proper structure (3 sheets for CRM, BoM, and Pricing data) Google Gemini API key for AI processing Basic understanding of Google Cloud Console for OAuth setup How to set up Import the workflow into your n8n instance Create three Google Sheets with the following column structure: CRM Sheet: Email, ProjectCode, CustomerName Bill of Materials: ProjectCode, PartCode, PartDescription, Quantity Pricing Sheet: PartCode, UnitPriceEUR, PartDescription Configure credentials: Set up Gmail OAuth2 in Google Cloud Console Configure Google Sheets OAuth2 (can use same project) Get your Google Gemini API key from Google AI Studio Update the workflow: Replace placeholder Sheet IDs in the CRM, BoM, and Pricing nodes Adjust company name in the AI Agent’s system message Modify keyword detection if needed Test with a sample email before activating How to customize the workflow Add more languages**: Update the keyword detection node with additional terms Modify the quote template**: Edit the HTML in the AI Agent's message to match your branding Change data sources**: Replace Google Sheets with PostgreSQL or MySQL nodes Add approval steps**: Insert a manual approval node for quotes above a certain value Include attachments**: Add PDF or product spec file nodes Enhance notifications**: Add Slack or Teams notifications after quote is sent Implement follow-ups**: Create a separate workflow for reminder emails This template provides a solid foundation for automating your quotation process, while staying flexible to fit your specific business needs. Feel free to contact me for further implementation guidelines: LinkedIn: Berke

🧠 Who is this for? Marketing teams, content creators, solopreneurs, and agencies who want to generate emotionally-resonant, SEO-optimized content tailored to audience psychology and buyer journey stages — and get picked up by AI discovery engines like ChatGPT, Gemini, and Perplexity. How it works: ✅ Decodes why people buy (using buyer psychology) ✅ Creates SEO + emotionally resonant content for 4 formats: → Blog Posts, Newsletters, Landing Pages, Social Media ✅ Structures the content to be picked up by ChatGPT, Gemini, Perplexity & Google ✅ Automatically routes it to Google Sheets, Gmail, or even WordPress This isn’t just about writing better content — it’s about getting seen by the tools that shape the internet. How long does it take to set-up: 30 Mins

Description Quickly organize your inbox with AI! This simple workflow automatically classifies incoming emails into different categories — like High Priority, Work Related, or Promotions — and applies Gmail labels accordingly. Setup takes less than 2 minutes, and it runs 24/7, helping you stay focused on what matters most without manual sorting. Tools/Services Needed Gmail: To trigger the workflow and label emails. Google Gemini (or any LLM Model): To intelligently classify email content. How It Works Gmail Trigger: Detects every new incoming email. Text Classifier Node: Classifies the email content into predefined categories. Google Gemini Chat Model: Provides the AI-powered understanding behind the classification. Conditional Labeling: If the email is High Priority, label it accordingly. If it’s Work Related (e.g., internal emails), apply the work label. If it’s a Promotion, sort it into the promotions label. Gmail Labeling: Automatically adds the correct label to the email. Setup Instructions Connect your Gmail account to n8n. Connect your Google Gemini (or other LLM) credentials. Customize the categories and labels if needed. Activate the workflow — and that's it! Notes You can easily add more categories (like "Finance," "Newsletters," etc.) by adjusting the classification prompt. Works best with a clean and minimal set of categories to avoid overlap. Can be adapted to work with any other large language model (OpenAI, Claude, etc.) if preferred.

Who’s it for This workflow is for hotel managers, travel agencies, and hospitality teams who receive booking requests via email. It eliminates the need for manual data entry by automatically parsing emails and attachments, assigning booking cases to the right teams, and tracking performance metrics. What it does This workflow goes beyond simple automation by including enterprise-grade logic and security: 🛡️ Gatekeeper:** Watches your Gmail and filters irrelevant emails before spending money on AI tokens. 🧠 AI Brain:** Uses OpenAI (GPT-5-mini) to extract structured data from unstructured email bodies and PDF attachments. ⚖️ Business Logic:** Automatically routes tasks to different teams based on urgency, room count, and VIP status. 🔒 Security:** Catches PII (like credit card numbers) and scrubs them before they hit your database. 🚨 Safety Net:** If anything breaks, a dedicated error handling path logs the issue immediately so no booking is lost. 📈 ROI Tracking:** Calculates the time saved per booking to prove the value of automation. How to set up Create your Google Sheet: Create a new sheet and rename the tabs to: Cases, Team Assignments, Error Logs, Success Metrics. Add Credentials: Go to n8n Settings → Credentials and add your Gmail (OAuth2), Google Sheets, and OpenAI API keys. Configure User Settings: Open the "Configuration: User Settings" node at the start of the workflow. Paste your specific Google Sheet ID and Admin Email there. Adjust Business Rules: Open the "Apply Business Rules" node (Code node) to adjust the logic for team assignment (e.g., defining what counts as a "VIP" booking). Customize Templates: Modify the email templates in the Gmail nodes to match your hotel's branding. Test: Send a sample booking email to yourself to verify the filters and data extraction. Setup requirements Gmail account (OAuth2 connected) Google Sheets (with the 4 tabs listed below) OpenAI API key (GPT-5-mini recommended) n8n Cloud or self-hosted instance How to customize Filter Booking Emails:** Update the trigger node keywords to match your specific email subjects (e.g., "Reservation", "Booking Request"). Apply Business Rules:** Edit the Javascript in the Code node to fit your company’s internal logic (e.g., changing priority thresholds). New Metrics:** Add new columns in the Google Sheet (e.g., “Revenue Metrics”) and map them in the "Update Sheet" node. AI Model:** Switch to GPT-5 if you need higher reasoning capabilities for complex PDF layouts. Google Sheets Structure Description This workflow uses a Google Sheets document with four main tabs to track and manage hotel booking requests. Cases This is the main data log for all incoming booking requests. case_id:** Unique identifier generated by the workflow. processed_date:** Timestamp when the workflow processed the booking. travel_agency / contact_details:** Extracted from the email. number_of_rooms / check_in_date:** Booking details parsed by the AI. special_requests:** Optional notes (e.g., airport transfer). assigned_team / priority:** Automatically set based on business rules. days_until_checkin:** Dynamic field showing urgency. Team Assignments Stores internal routing and assignment details. timestamp:** When the case was routed. case_id:** Link to the corresponding record in the Cases tab. assigned_team / team_email:** Which department handles this request. priority:** Auto-set based on room count or urgency. Error Log A critical audit trail that captures details about any failed processing steps. error_type:** Categorization of the failure (e.g., MISSING_REQUIRED_FIELDS). error_message:** Detailed technical explanation for debugging. original_sender / snippet:** Context to help you manually process the request if needed. Success Metrics Tracks the results of your automation to prove its value. processing_time_seconds:** The time savings achieved by the automation (run time vs. human time). record_updated:** Confirmation that the database was updated. 🙋 Support If you encounter any issues during setup or have questions about customization, please reach out to our dedicated support email: [email protected]

Who is this for SMB sales teams and SaaS companies who want to automatically prioritize and nurture new leads without manual qualification. Perfect for businesses getting 50+ leads per month who need to identify high-value prospects quickly. How it works When a new contact is created in HubSpot, the workflow automatically enriches their data using Clearbit's company database. A scoring algorithm evaluates company size, industry fit, and job title relevance, then Gemini AI analyzes the enriched data to provide additional insights and generate personalized outreach content. Hot leads (score 80+) receive immediate personalized emails and trigger Slack notifications to the sales team. Warm leads (50-79) are added to nurturing sequences. Cold leads are simply scored for future reference. All scoring data and reasoning are logged to Google Sheets for analysis and optimization. How to set up Configure credentials for HubSpot, Clearbit API, Gemini AI, Gmail, Slack, and Google Sheets. Create a Google Sheet for scoring history with the column headers shown in the workflow. Update the Slack channel name in the notification node and customize the Gmail sender settings. Requirements HubSpot with contact creation access Clearbit Enrichment API account Google Gemini AI API key Gmail account for sending emails Slack workspace for notifications Google Sheets for tracking How to customize Adjust scoring criteria in the Set node including target industries, company size weights, and role priorities. Modify hot/warm score thresholds (default 80/50). Customize email templates and Slack message format within the Gemini AI prompt. Add additional scoring factors in the Code node calculation.

Who is this for Product managers, customer success teams, and small business owners who collect feedback via Google Forms and want automated sentiment analysis without manual review. Ideal for teams processing 10-100+ responses weekly. What this workflow does This workflow reads new Google Forms responses from a linked Google Sheets spreadsheet, sends them to Gemini AI for sentiment analysis and topic categorization, then writes results back to the sheet, logs weekly insights in a Notion database, and emails an HTML summary report to your team. Each response gets a sentiment label (positive, neutral, negative), a 1-10 score, a category tag, and a key theme extraction. How to set up Create a Google Form and link responses to a Google Sheet. Add four columns to the sheet: Processed, Sentiment, Category, Score. Connect your Google Sheets OAuth2 credential and select the responses sheet. Connect your Google Gemini API credential (requires a Google AI Studio API key). Create a Notion database with columns: Date, Total Responses, Positive Rate, Top Themes, Recommendation. Connect your Notion API credential. Connect your Gmail OAuth2 credential and set the recipient email address. Activate the workflow. Requirements Google Sheets OAuth2 credentials (linked to a Google Form) Google Gemini API key (Google AI Studio) Notion API integration token Gmail OAuth2 credentials How to customize Change the schedule trigger interval for more or less frequent analysis runs. Edit the AI prompt in the Analyze feedback node to add custom categories relevant to your product. Modify the email HTML template in the Parse results node to match your branding. Add a Slack notification node after the email for real-time team alerts.

Who is this for Customer support teams and operations managers who receive support requests via email and need automated triage. Works well for small to mid-size teams using Notion as their ticket tracker. What this workflow does This workflow watches a Gmail inbox for incoming support emails. Each email is analyzed by Gemini AI to determine its category (billing, technical, feature request, or general), priority level, and a suggested response draft. A new page is created in a Notion database with all classified fields. Critical tickets trigger an immediate Slack alert to the on-call team, while all tickets get a summary notification. Setup Add a Gmail OAuth2 credential and configure label or address filters. Add a Google Gemini API credential for email classification. Add a Notion API credential and create a database with columns: Title, Category, Priority, Status, Summary. Add a Slack OAuth2 credential and set your alerts channel. Requirements Gmail account with OAuth2 access Google Gemini API key Notion workspace with API integration enabled Slack workspace with OAuth2 app How to customize Edit the AI prompt in "Classify ticket with AI" to add more categories or adjust priority rules. Change the critical priority condition in "Is critical priority" to include high-priority tickets. Replace Notion with Airtable or Google Sheets for a different ticket backend.

Who is this for Template creators who want to validate their n8n workflows against the official Creator Hub approval criteria before submitting. Useful for both new and verified creators looking to reduce rejection rates. What this workflow does This workflow scrapes the latest approval guidelines from four n8n Creator Hub Notion pages, generates a structured pass/fail checklist using Gemini AI, then reviews your uploaded workflow JSON against every criterion. The results are delivered as a formatted HTML email report with a score and specific fixes. Setup Add a Google Gemini (PaLM) API credential for criteria generation, file upload, and review. Add a Gmail OAuth2 credential for sending the results email. Activate the workflow and open the generated form URL. Requirements Google Gemini API key (used for three separate calls: criteria generation, file uploads, and final review) Gmail account with OAuth2 access enabled How to customize Change the Gemini model in the "Google Gemini for criteria generation" and "Review workflow against criteria" nodes. Edit the review prompt in the "Review workflow against criteria" node to adjust scoring weight or add custom checks. Replace the Gmail node with another email service or a Discord/Slack webhook for different delivery methods. Important disclaimer This workflow provides AI-generated feedback based on n8n Creator Hub guidelines available as of February 2026. The review results are not a guarantee of approval or rejection — actual decisions are made by the n8n review team. Guidelines and criteria may change over time. Always check the latest official information on the n8n Creator Hub before submitting your template.

Generate SEO-Optimized PWA Website with AI and Deploy to S3 Who's it for This workflow is designed for agencies, freelancers, and businesses who want to generate production-ready static websites with built-in SEO optimization and PWA (Progressive Web App) capabilities — all without manual coding. It is best suited for users who need landing pages, portfolios, event pages, or client microsites that are mobile-friendly, SEO-optimized, and installable as apps on any device. What it does This workflow collects website requirements via an n8n form, uses Google Gemini AI to generate a complete HTML page with SEO metadata and PWA components (service worker, manifest, offline support), assembles all files, uploads them to AWS S3, and sends the published URL via email. Unlike basic AI website generators, this workflow produces three separate AI-generated outputs that are assembled into a complete, deployable package: ✅ SEO-optimized meta tags, Open Graph, and structured data (Schema.org) ✅ PWA manifest + service worker for offline support and "Add to Home Screen" ✅ Responsive, single-page website with embedded CSS and JavaScript ✅ All files deployed as a cohesive package to S3 How it works Website Request Form — User fills out requirements (name, purpose, colors, content, keywords). Process Form Data — Workflow structures the input for AI processing. Generate SEO Metadata (Gemini AI) — Creates meta tags, Open Graph tags, Twitter cards, and JSON-LD structured data based on the site's purpose and keywords. Generate Website HTML (Gemini AI) — Produces a complete, responsive HTML/CSS/JS page incorporating the SEO metadata. Generate PWA Components — Creates manifest.json and service-worker.js for offline capability and app-like behavior. Assemble All Files — Merges HTML, manifest, and service worker into a deployment-ready package. Convert to Binary — Prepares all files for S3 upload. Upload to S3 — Deploys all files (index.html, manifest.json, sw.js) with proper content types. Build Response — Constructs the live URL and deployment summary. Send Confirmation Email — Delivers the live URL, SEO report, and PWA installation instructions to the user. Requirements To use this workflow, you will need: A Google Gemini API key (Gemini 1.5 Flash or Pro recommended) An AWS account with S3 access An S3 bucket configured for static website hosting A Gmail account for sending confirmation emails (or replace with another email service) AWS Setup Guide Step 1: Create an IAM User for n8n Go to AWS Console → IAM → Users → Create user User name: n8n-s3-uploader Attach the following custom policy: { "Version": "2012-10-17", "Statement": [ { "Sid": "S3WebsiteUpload", "Effect": "Allow", "Action": [ "s3:PutObject", "s3:PutObjectAcl", "s3:GetObject", "s3:ListBucket" ], "Resource": [ "arn:aws:s3:::YOUR_BUCKET_NAME", "arn:aws:s3:::YOUR_BUCKET_NAME/*" ] } ] } Create access key → Select "Application running outside AWS" Save the Access Key ID and Secret Access Key for n8n credential setup Step 2: Create an S3 Bucket Go to AWS Console → S3 → Create bucket Bucket name: Choose a globally unique name (e.g., my-ai-websites-12345) Region: Select your preferred region Object Ownership: Select "ACLs enabled" → "Bucket owner preferred" Block Public Access: Uncheck "Block all public access" and acknowledge the warning Create bucket Step 3: Enable Static Website Hosting Go to your bucket → Properties tab Scroll to "Static website hosting" → Edit Enable static website hosting Index document: index.html Error document: index.html (for PWA routing) Save changes Note the bucket website endpoint URL (e.g., http://YOUR_BUCKET_NAME.s3-website-REGION.amazonaws.com) Step 4: Add Bucket Policy for Public Access Go to your bucket → Permissions tab Scroll to "Bucket policy" → Edit Paste the following policy: { "Version": "2012-10-17", "Statement": [ { "Sid": "PublicReadGetObject", "Effect": "Allow", "Principal": "*", "Action": "s3:GetObject", "Resource": "arn:aws:s3:::YOUR_BUCKET_NAME/*" } ] } Replace YOUR_BUCKET_NAME with your actual bucket name Save changes Step 5: Configure n8n Credentials In n8n, go to Credentials → Add credential → AWS Enter the Access Key ID and Secret Access Key from Step 1 Set the region to match your S3 bucket region Save the credential Important limitations Generated websites are single-page only (no multi-page navigation). The AI may occasionally produce varying results depending on prompt complexity. S3 bucket must have public access enabled for the websites to be viewable. PWA "Add to Home Screen" requires HTTPS — use CloudFront for production deployments. No custom domain support out of the box (requires additional CloudFront/Route53 setup). Service worker caching is basic (cache-first strategy); for advanced caching, customize the generated sw.js. AWS charges may apply based on S3 storage and data transfer usage. How to set up Complete the AWS Setup Guide above. Add your Google Gemini API credential in n8n. Add your AWS credential in n8n (from Step 5 above). Update the S3 bucket name in the "Upload to S3" node. Update the bucket URL in the "Build Response" node. Configure Gmail OAuth2 credential (or replace with your email service). Activate the workflow and share the form URL. How to customize AI Model**: Swap Google Gemini for OpenAI, Anthropic, or any LLM supported by n8n. Form fields**: Add fields for target audience, language preference, or industry-specific requirements. SEO depth**: Extend the SEO prompt to generate sitemaps, robots.txt, or additional structured data types. PWA features**: Customize the service worker for push notifications, background sync, or advanced caching strategies. Notifications**: Replace Gmail with Slack, Discord, or webhook notifications. Storage**: Add a database node to track generated websites with analytics. Domain**: Integrate with CloudFront + Route53 for custom domains with HTTPS. Error handling**: Add error handling nodes and retry logic for production use. What makes this different Most AI website generators create a basic HTML file. This workflow goes further: | Feature | Basic Generator | This Workflow | |---------|----------------|---------------| | HTML/CSS/JS | ✅ | ✅ | | SEO Meta Tags | ❌ | ✅ (AI-generated) | | Open Graph / Twitter Cards | ❌ | ✅ | | Schema.org Structured Data | ❌ | ✅ (JSON-LD) | | PWA Support | ❌ | ✅ (manifest + service worker) | | Offline Capability | ❌ | ✅ | | "Add to Home Screen" | ❌ | ✅ | | Multiple AI Calls | 1 | 2 (specialized prompts) | | Deployment Files | 1 (index.html) | 3+ (html + manifest + sw.js) | Security Considerations The generated websites are publicly accessible. Do not use this for sensitive content. Consider adding authentication if you want to restrict who can generate websites. Review AWS costs regularly to avoid unexpected charges. For production use, set up CloudFront with HTTPS (required for full PWA functionality). Service workers require HTTPS in production; localhost is exempt for testing. Note: This workflow was built using Google Gemini AI and AWS S3 static website hosting. For production deployments, we recommend adding CloudFront for HTTPS, custom domains, and global CDN distribution.

Automate your lead qualification process by connecting Jotform to Gemini AI. This workflow instantly analyzes new form submissions, assigns a priority score, filters out spam, and routes legitimate leads for immediate action. Stop manually sorting through submissions and let your sales team focus on what matters: closing deals with hot leads. This template captures a lead from a "Talk to an Expert" form, uses AI to determine its quality, sends a real-time notification to your sales team on Slack, and automatically sends a tiered, personalized email response to the lead based on their qualification score. Features Automated Spam Filtering: Uses Gemini AI to analyze incoming leads and automatically discard spam. AI-Powered Lead Scoring: Assigns a priority score (1-10) to every legitimate lead based on the content of their inquiry. Instant Team Notifications: Sends a detailed alert for every qualified lead to a designated Slack channel. Tiered Email Responses: Automatically sends a different, personalized email to hot, warm, and cold leads. Seamless Jotform Integration: Triggers the moment a new form is submitted. Nodes Used 🟣 Jotform Trigger: Starts the workflow when a new form submission is received. 🧠 AI Agent / Google AI: Connects to Gemini to analyze the form data. ❓ IF: Filters out submissions flagged as spam. 📣 Slack: Sends a real-time notification to your team. 🔀 Switch: Routes the lead down different paths based on its AI-generated score. ✉️ Gmail: Sends a personalized follow-up email to the lead. How to use this template This workflow is designed to be easy to set up. Follow these steps to get it running: Set up your Jotform Trigger: In the Jotform Trigger node, connect your Jotform account. Select the specific form you want to use for lead capture from the dropdown list. Ensure your form has the required fields as described in the "Required Jotform Fields" section below. Configure the AI Agent / Google AI Node: Connect your Google AI credentials to the node. Ensure the prompt is set up to analyze the message from your form and return a JSON object with is_spam (a boolean) and lead_score (an integer) keys. Set up the IF Node: This node should check the is_spam value from the AI node. The workflow should only continue on the false path. Configure the Slack Node: Connect your Slack account credentials. In the "Channel" field, select the channel where you want lead notifications to be sent (e.g., #sales-leads). Configure the Switch Node: This node should be set to route based on the lead_score from the AI node. The template is pre-configured with three paths: Hot: Score is 8 or higher. Warm: Score is between 5 and 7. Cold: Score is 4 or lower (the "Default" path). Configure the Gmail Nodes Connect your Gmail account credentials to each of the three Gmail nodes. This step is critical for personalization, and you must adapt the content to fit your business. The provided text is a template; its effectiveness depends on your customization. For each of the three email templates (Hot, Warm, and Cold), be sure to: Update the Email Body:** Rewrite the text to match your company's tone and brand voice. Change Company/Team Information:** Replace placeholder text like [Your Company Name] and update the signature from The Team to your specific team or company name (e.g., The Sales Team at Acme Corp). Customize Your Links:** In the 'Hot' lead email, replace the placeholder [Your Calendly/Booking Link] with your actual link from Calendly, HubSpot Meetings, or another scheduling tool. In the 'Warm' lead email, replace [Link to a resource or case study] with a real link to a relevant blog post, whitepaper, or case study on your website. Activate your Workflow: Once all nodes are configured, save and activate your workflow. Now, every new Jotform submission will be processed automatically\! How to Adapt the Template This workflow is a powerful starting point. Here are a few ideas to customize it for your specific needs: Integrate Your CRM: Add a node for your CRM (like HubSpot, Salesforce, or Pipedrive) after the IF node. You can create or update a contact and a deal, and then include the link to the CRM record directly in the Slack notification for easy access. Use a Different Notification Service: If your team doesn't use Slack, you can easily replace the Slack node with one for Microsoft Teams, Discord, or even a simple email notification. Create Tiered Notifications: For a more advanced setup, use the Switch node's outputs to send notifications to different channels. For example, send "Hot" leads to a high-priority #sales-urgent channel with an @channel mention, and send "Warm" or "Cold" leads to a less noisy #leads-review channel. Adjust the Scoring Logic: Your definition of a "hot" lead might be different. Simply change the values in the Switch node to match your business rules (e.g., you might consider any score of 7 or higher to be a hot lead). Required Jotform Fields for this Workflow For this template to work correctly, your Jotform should have the following fields. The names in parentheses are the internal field names used in the n8n expressions. Full Name (Full Name): A text input for the user's name, used for personalizing emails. Work Email (Work Email): An email field, used as the recipient for the automated follow-up. Role (Role): A text input for the user's job title, providing context for your sales team. Number of Employees (Number of Employees): A dropdown or number input for company size, used for lead segmentation. How can we help you? (How can we help you?): A text area. This is the most critical field, as its content is sent to the AI for spam checking and lead scoring. More Information About Jotform Jotform is a powerful and easy-to-use online form builder that helps you create and publish online forms without writing a single line of code. It's an excellent tool for capturing leads, conducting surveys, accepting payments, and much more. Its seamless integration capabilities make it a perfect starting point for all kinds of n8n automations. If you don't have an account yet, you can get started with Jotform through the link above.

AI Email Support Agent with RAG & Cohere Reranking Transform your inbox into an intelligent support system: automatically detect new emails, retrieve relevant knowledge from Pinecone, rerank with Cohere for precision, generate contextual replies using Gemini AI, and respond—all while maintaining conversation history. What It Does This workflow triggers on incoming Gmail messages, leverages a LangChain agent with PostgreSQL memory for context, queries a Pinecone vector store (RAG) enhanced by Cohere reranking and OpenAI embeddings, crafts personalized responses via Gemini 2.5, and auto-replies to keep support flowing. Key Features Gmail Integration** - Real-time polling for new emails every minute RAG with Pinecone** - Retrieves top 10 relevant docs from "agency-info" index as agent tool Cohere Reranking** - Boosts retrieval accuracy by reordering results semantically Persistent Memory** - Postgres chat history keyed by email ID for ongoing threads Gemini-Powered Agent** - Handles queries with custom system prompt for agency support Seamless Auto-Reply** - Sends formatted text responses directly in Gmail Perfect For Agencies**: Automate client FAQs on services, pricing, and ownership Support Teams**: Scale responses without losing conversation context Small Businesses**: Handle inquiries 24/7 with AI-driven accuracy Developers**: Prototype RAG agents with vector stores and rerankers Marketers**: Personalize outreach replies based on knowledge base Consultants**: Quick, informed answers from internal docs Technical Highlights Built on n8n's LangChain ecosystem, this workflow highlights: Trigger-to-response pipeline with polling and webhooks Hybrid retrieval: Embeddings + vector search + semantic reranking Stateful agents with database-backed memory for multi-turn chats Multi-provider setup: OpenAI (embeddings), Cohere (rerank), Google (LLM) Scalable for production with configurable topK and session keys Setup Instructions Prerequisites n8n instance with LangChain nodes enabled Accounts for: Gmail (OAuth2), OpenAI (API key), Cohere (API key), Google Gemini (API key), Pinecone (API key and index), Postgres (database connection, e.g., Neon or Supabase) Required Credentials Gmail OAuth2 Enable Gmail API in Google Cloud Console Create OAuth2 credential in n8n with scopes: https://www.googleapis.com/auth/gmail.readonly, https://www.googleapis.com/auth/gmail.send OpenAI API Get API key from platform.openai.com Add as OpenAI credential in n8n Cohere API Sign up at cohere.com Copy API key to n8n Cohere credential Google Gemini API Generate key at https://aistudio.google.com/ Add as Google PaLM credential in n8n (compatible with Gemini) Pinecone API Create index "agency-info" with dimension 1024 Add API key to n8n Pinecone credential Postgres Set up database (e.g., Neon/Supabase) with a table for chat history Add connection details (host, database, user, password) to n8n Postgres credential Configuration Steps Import the workflow JSON into your n8n instance Assign all required credentials to the respective nodes Populate the Pinecone "agency-info" index with your knowledge base documents (use a separate upsert workflow or Pinecone dashboard) Customize the tableName in the Postgres Memory node if needed (default: "email_support_agent_") Adjust the agent's system prompt or topK retrieval if required for your use case Activate the workflow and test by sending a sample email to trigger it Troubleshooting No trigger firing**: Verify Gmail scopes and polling interval Empty retrieval**: Check Pinecone index population, dimensions (must be 1024), and document embeddings Rerank errors**: Ensure Cohere API key is valid and has sufficient quota Memory issues**: Confirm Postgres connection and that sessionKey uses email ID Perfect for deploying hands-off email automation. Import, connect credentials, and activate!

This n8n template drafts customer-ready email replies using Google Gemini, enriched with HubSpot context (contact, deals, companies, tickets). Each draft is routed to Slack for one-click approval before it’s sent from Gmail—so you move fast without losing control. Ideal for support and sales teams that want speedy, personalized responses while keeping humans in the loop. How it works Gmail Trigger** watches for new inbound emails. Sender filter** excludes internal domains (e.g., n8n.io) to avoid auto-replying to teammates. HubSpot contact lookup* finds the sender and fetches associated deals/companies/tickets* via association + batch read. CRM context is normalized** into clean, LLM-friendly fields (no IDs or sensitive noise). Gemini (Google AI Studio)** generates a concise, friendly reply using: Sender name, subject, and message snippet Safe, relevant HubSpot context (e.g., top 1–2 deals or an open ticket) Style constraints (≤ \~150 words, single CTA, optional clarifying question) Slack approval* posts the draft to a channel; if approved, n8n *replies via Gmail in the original thread. How to use Gmail: Connect the same account for the trigger and reply nodes. HubSpot: Connect OAuth on the search + HTTP request nodes. Gemini: Add your Google AI Studio API key to the Google Gemini Chat Model node. Slack: Connect and select the channel for draft approvals. (Optional) Filter: Adjust the Allowed Sender filter before going live. (Optional) Prompt: Edit “Draft Reply (AI Agent)” tone/length or how much CRM detail to include. Activate the workflow. New emails will produce Slack-approved replies automatically. Requirements Gmail** (trigger + send) HubSpot** (OAuth2) for contact + associations Slack** for approval step Google Gemini** (Google AI Studio API key) Notes & customization Safety rails:** The prompt avoids exposing IDs/raw JSON and caps CRM details to what’s useful. Auto-send mode:** Skip Slack if you want fully automated replies for specific senders/labels. Richer context:** Extend the batch read to pull more properties (e.g., next step, renewal date). Triage:** Branch on subject/labels to route billing vs. technical requests to different prompts. QA queue:* If the model asks a clarifying question, keep it to one*—the node enforces that.

Lead Qualification & Smart Outreach — Automated Scoring System Automate your lead intake, scoring, and outreach pipeline. This workflow collects leads from forms, enriches and scores them using Relevance AI, routes them by quality, and triggers the right follow-up — all without manual busywork. 🚀 What it Does Collects leads from your forms in real-time. Enriches each lead (individual + company) for better context. Scores leads automatically using Relevance AI templates. Routes leads into HOT / WARM / COLD tiers for prioritization. Drafts or sends personalized outreach emails for each tier. Logs all leads and outcomes into your CRM or Google Sheets. Notifies your team (e.g., via Slack) when a hot lead arrives. 🧩 Why Use It Save time:** stop manually sorting through raw leads. Focus on the best opportunities:** route only top leads to your sales team. Personalized outreach:** automated but tailored by lead quality. Scalable & repeatable:** works for startups, agencies, or larger teams. Adaptable:** swap CRMs, forms, or email providers easily. 🔧 Prerequisites & Setup Before importing or running the workflow, set up these connections: Relevance AI** Clone the tools (Resources provided in the workflow) for lead scoring and company scoring, and copy your API key into the HTTP Request nodes. Form Intake** Use n8n’s built-in form trigger or connect Typeform, Tally, HubSpot Forms, or any webhook-based intake. CRM or Database** Start with Google Sheets (included in the sample workflow) or connect HubSpot, Salesforce, Pipedrive, Zoho, Airtable, Notion, or any SQL/NoSQL DB. Email Provider** Use Gmail (included), or swap in Outlook, HubSpot Email, SendGrid, Mailgun, etc. Team Notifications (Optional)** Configure Slack (or other tools) for instant alerts on hot leads. ⚙️ How It Works (Simplified Flow) Lead Intake: Collects leads from your form or CRM. Lead Enrichment: Uses Relevance AI to score: Individual Fit: role, expertise, influence. Company Fit: size, industry, market relevance. Scoring & Insights: Combines both into a final lead score with labels and notes. Routing: Splits leads into HOT / WARM / COLD tiers. Outreach: HOT → drafts a review-ready email for your team. WARM / COLD → auto-sends appropriate follow-up emails. Logging & Alerts: Saves structured data to your CRM or sheet and notifies your team of hot leads. 🙋‍♂️ Who is This For Startups & SaaS teams** that need to prioritize a flood of inbound leads. Agencies & consultancies** qualifying prospects from ads or webinars. Small sales teams** that want to spend time only on the best leads. Freelancers or solopreneurs** who want a lightweight but effective qualification process. Automation newbies* who want a production-ready system to sell for 1k-3k* 💡 Why It Stands Out Real intelligence:** uses data-driven Relevance AI scoring rather than static rules. Action-oriented:** routes and triggers the right next step immediately. Personalized yet scalable:** adapts outreach to each lead tier. Flexible integrations:** works with most popular CRMs, forms, and email tools. 🔥 Best Practices & Tips Adjust the weighting of individual vs. company scores in your Relevance AI template (default: 40% vs 60%). Tune Router thresholds (e.g., HOT ≥ 80, WARM 60-79, COLD < 60) to match your sales goals. Add a human approval step for high-value deals. Expand with enrichment APIs (e.g., Clearbit, Apollo) for richer lead data. Keep all API keys private and out of screenshots or repos. 🎉 With this workflow, Sales teams can focus on building relationships — while the system qualifies and organizes leads automatically OR You can sell to sales teams for ~3k Note: Demo data is pinned in some nodes to help you understand what the data looks like. Make sure to unpin those nodes when using for production.

Local Lead Finder + Cold Email Sender (Form → Apify → AI → Gmail + Google Sheets) Fill a short form with business type, location, and how many leads you want. This workflow finds local businesses, grabs a valid email from each website, writes a cold email in your chosen style, sends it, and logs everything to Google Sheets. Benefits Simple form input (business type, location, lead count, email style) Finds local businesses with Apify and filters only those with a website Scrapes one best email address from each site Writes cold emails with AI (style: Friendly / Professional / Simple) Sends via Gmail and updates Google Sheets with status + send time How It Works Form Submit: Enter Business Type, Location, Lead Number, Email Style. Find Leads (Apify): Search places in the target location (up to your lead count). Filter: Keep only results that include a website. Extract Email (AI): Visit the website and pull one valid email address. Save Lead (Sheets): Add company name, category, website, phone, address, email. Generate Email (AI): Create subject + body using your selected style. Send (Gmail): Email the scraped address; retry-safe. Log Result (Sheets): Mark “Cold Mail Status = ✅” and add send time. Batching/Wait: Process leads one by one with a short wait to avoid limits. Who Is This For Agencies doing local outreach Freelancers offering lead gen services SMBs testing cold email in a city or niche Setup Connect the built-in Form Trigger (use provided fields) Add Apify actor endpoint + token Add Google Gemini (for email extraction) and OpenAI (for email writing) keys Connect Gmail OAuth2 to send emails Connect Google Sheets (Spreadsheet ID + Sheet1) ROI & Monetization Spin up targeted campaigns in minutes (no manual research) Sell as a local lead-gen + outreach package ($500–$2k/campaign) Reuse the form for any niche and city to scale quickly Strategy Insights In the full walkthrough, I show how to: Tune the Apify search for better niches and categories Improve email extraction prompts for higher-quality addresses Adjust templates for short, compliant cold emails Add fallbacks (no email → skip or save for manual review) Check Out My Channel For more AI outreach workflows that get real results, check out my YouTube channel where I share the exact setups I use to win clients and scale to $20k+ monthly revenue.

Say goodbye to endless applications and hello to more time for perfecting your interview skills! The JOB Hunter Agent uses the power of Google Gemini and SerpAPI to find the perfect job match and generate a personalized cover letter. Result example: 💡 Why Use JOB Hunter Agent? Save Precious Time: Stop sifting through countless job boards; this agent does the heavy lifting, saving you hours every week. Land Your Dream Job Faster: Get laser-focused job matches and a custom-crafted cover letter that speaks directly to the hiring manager, increasing your chances of getting noticed. Never Miss an Opportunity: Your personal AI assistant works 24/7, ensuring you're always on top of the latest openings, even while you sleep! Stand Out from the Crowd: A perfectly tailored cover letter generated on the fly gives you an edge over generic applications, making you look like a superstar. ⚡ Perfect For Job Seekers: Anyone actively looking for a new role who wants to streamline their application process. Busy Professionals: Those with limited time who need an efficient way to find relevant opportunities. Career Changers: Individuals exploring new industries who need a helping hand in crafting compelling applications. 🔧 How It Works ⏱ Trigger: You submit your CV and job preferences through a simple n8n form. 📎 Process: Your CV is extracted from the PDF, and your preferences (location, job type, salary, email) are neatly organized. 🤖 Smart Logic: The "Job Hunter Agent" uses Google Gemini and SerpAPI to find the single best job match for you and then drafts a bespoke cover letter based on your CV and the job description. It's like magic, but with more code! 💌 Output: A beautifully formatted HTML email containing your profile summary, the best job match, your personalized cover letter, and handy application tips is sent straight to your inbox. 🗂 Storage: All the initial data from your form submission is processed and used to craft your perfect job application package. 🔐 Quick Setup Import JSON file to your n8n instances Add credentials: Google Gemini (Gemini 2.5 Pro model) and SerpAPI Customize: Adjust the system prompt in the "Job Hunter Agent" to fine-tune the cover letter tone or length, update the email footer, and expand job filters. Update: Ensure your Gmail OAuth2 credentials are valid for sending emails. Test: Run the workflow with your own CV and preferences to see the magic happen! 🧩 You'll Need Active n8n instances Google Gemini API key (for Gemini 2.5 Pro) SerpAPI account for Google Jobs search results A Gmail account for sending personalized job match emails 🛠️ Level Up Ideas Integrate with LinkedIn, Jobstreet, or Indeed APIs for a wider range of job sources. Allow the agent to find multiple job matches and present them as a curated list. Add an option to attach a parsed CV summary as a PDF to the email for quick reference. Made by: khaisa Studio Tags: AI, Gemini, Google Jobs, Job Search, Automation, Cover Letter Category: job hunter Need custom work? Contact me