The Ultimate n8n TemplatesLibrary & Marketplace

Discover 7000+ premium n8n templates with AI-powered generation. The largest n8n templates marketplace enabling anyone to have a running workflow in 5 minutes

Start AI Generation Browse Templates

Or browse our extensive n8n templates collection. Try the AI generator to create custom n8n templates instantly.

10466+

Templates

50+

Integrations

50k+

Downloads

Latest n8n Templates

Freshly updated automation workflows to keep your n8n stack current

View All

Generate proposals with GPT-4o, Google Docs, Gmail and Slack

Who’s it for Consultants, agencies, freelancers, and professional service firms who need to create customized proposals and contracts quickly and efficiently. How it works / What it does This n8n workflow automates the entire proposal and contract creation process: Triggers when a new client is added to Google Sheets or CRM. Normalizes client data for processing. Generates personalized proposal content using OpenAI AI models based on templates, pricing, and client info. Creates a Google Doc proposal. Converts the proposal to PDF. Sends the proposal via Gmail or Outlook. Optionally routes the proposal to DocuSign or PandaDoc for e-signature collection. Logs the proposal and client info in Google Sheets for tracking. Sends Slack notifications to internal teams. Routes high-value clients for priority follow-up via email and Slack alerts. How to set up Connect Google Sheets or your CRM for client data. Configure Gmail or Outlook credentials. Add OpenAI credentials for proposal generation. Connect Slack for notifications. Optional: Connect DocuSign/PandaDoc. Customize decision nodes for priority clients or additional workflows. Requirements n8n account with Google Sheets, Gmail/Outlook, Slack integrations. Optional DocuSign/PandaDoc accounts for signature collection. OpenAI API key for AI proposal generation. How to customize Adjust templates in OpenAI prompts for company tone/style. Modify Sheet columns for additional client info. Change decision logic to define what counts as a high-value client. Add other integrations like CRM updates or analytics dashboards. Created by Hyrum Hurst / QuarterSmart Keywords: AI proposal automation, contract automation, consulting, proposal generation, n8n workflow, QuarterSmart

IntermediateManual Trigger

by Hyrum Hurst

Plan AI-powered travel itineraries with Apify, OpenAI, and Google Docs

Who is this for Travel agencies, freelance travel planners, or anyone who wants to automate personalized trip planning by combining real-time hotel and flight data with AI-generated recommendations. What this workflow does Collects travel details (airports, dates, travelers) through an n8n form Scrapes the top 5 hotels from Booking.com sorted by review score via Apify Scrapes the best available flights from Google Flights via Apify Generates restaurant, attraction, and day-by-day itinerary recommendations using OpenAI Merges all results into a formatted Google Doc and returns the link to the user How to set up Create an Apify account and add your API token as both an "Apify API" credential and an "HTTP Query Auth" credential (parameter name: token) Add your OpenAI API key as an "OpenAI" credential Connect your Google account via OAuth2 and update the folderId in the "Create Document" node to your Google Drive folder Activate the workflow and share the form URL Requirements Apify account with API token (for Booking.com and Google Flights scrapers) OpenAI API key Google account with Docs and Drive access How to customize Swap the form trigger for a webhook or chatbot input Change the output from Google Docs to email, Slack, or Notion Adjust the OpenAI prompt to focus on budget travel, luxury, or specific interests

BeginnerManual Trigger

Write daily tech news with OpenAI using RSS feeds and WordPress

Who is this for Tech bloggers, content creators, and site owners who want a fully automated daily news column without writing a single word. What this workflow does A schedule trigger fires daily at 8 AM and pulls articles from four RSS feeds (BBC Tech, The Verge, Ars Technica, TechCrunch). All feeds are merged, normalized to a common schema, filtered to the last 24 hours, sorted by date, and capped at 10. A Code node compiles the articles into a digest, which is passed to an OpenAI-powered AI agent. The agent picks the most newsworthy story (or combines 2–3 related ones), fetches full article text via a custom tool, and writes an original 600–1000 word article. The AI output is parsed into a title and HTML body, then posted as a draft to WordPress. How to set up Add your OpenAI API key under Credentials → OpenAI. The workflow uses gpt-5.1 by default — swap to any chat model in the "OpenAI Chat Model" node. Add your WordPress API credentials (site URL, username, and application password). Activate the workflow — it runs daily at 8 AM. Requirements OpenAI account and API key WordPress site with application password enabled How to customize Swap or add RSS feed URLs by duplicating an RSS node and connecting it to the Merge node (increase numberInputs accordingly). Change the Limit node value to control how many articles the AI reviews. Switch the WordPress post status from draft to publish for immediate publishing.

BeginnerManual Trigger

Track expenses via chat with Claude Haiku and Google Sheets

Send AI-parsed restaurant orders and status updates via Telegram and Google Sheets

🍕 AI-Powered Restaurant Order & Notification System A Complete n8n Workflow for Automated Ordering and Customer Updates This professional n8n workflow provides an end-to-end solution for small restaurants. It includes a Telegram Customer Bot for placing orders and an Automated Notification System that updates customers via Google Sheets. 📖 Description This system eliminates the need for manual order taking and status updates. It features: AI Order Bot: Customers chat with a Telegram bot to view the menu and place orders. An AI agent (Claude Haiku) parses natural language (e.g., "2 pizza + 1 coke") into structured data. Order Management: Orders are saved automatically to Google Sheets for staff to manage. Real-Time Notifications: As staff change the status in the sheet (e.g., to Preparing or Ready), n8n instantly notifies the customer via Telegram. Key Bot Commands | Command | Description | | :--- | :--- | | /start | Welcome message and instructions | | /menu | View today's food and drink offerings | | /help | See all available commands | | STATUS [Queue #] | Check the live status of an order | | CANCEL [Queue #] | Cancel an order (only if Pending) | | /myorders | View your last 5 orders | 🛠 Setup Requirements 1. Google Sheets Configuration Your spreadsheet acts as your Admin Dashboard. Ensure Row 1 has these exact headers in order: | Column | Header Name | Description | | :---: | :--- | :--- | | A | Queue Number | Auto-generated by the bot (e.g., #4582) | | B | Chat ID | Customer's Telegram ID — captured automatically | | C | Name | Customer's first name | | D | Order | Items ordered — parsed and cleaned by AI | | E | Status | Dropdown: Pending, Preparing, Ready, Completed, Cancelled | | F | Order Time | Timestamp of when the order was placed | | G | Order Date | Date of the order | | H | Last Status Sent | Internal: Tracks last notification sent to prevent duplicates | > ⚠️ Important: Set up a Data Validation dropdown on column E with the values: Pending, Preparing, Ready, Completed, Cancelled. This is how staff update order status. > ⚠️ Important: In the Read All Rows node, go to Options → Output Row Number and ensure it is enabled. The workflow uses row_number to write back to the correct cell. 2. n8n Credential Configuration You need 3 credentials set up in n8n before activating: | Credential Type | Where Used | Notes | | :--- | :--- | :--- | | Anthropic API | Claude Haiku node | Required for AI order parsing | | Google Sheets OAuth2 API | All Google Sheets nodes | Connect your Google account | | Telegram Bot API | All Telegram nodes | Use your bot token from @BotFather | Steps: Go to n8n → Settings → Credentials → Add Credential Add each credential type above After importing the workflow, open each node and select the correct credential 3. Workflow Import Steps Copy the workflow JSON In n8n, click + → Import from JSON → Paste and confirm Connect all credentials in each node Ensure Output Row Number is enabled in Read All Rows node options Pre-fill column H (Last Status Sent) with the current Status for all existing rows to prevent old rows from firing notifications on first run Turn the workflow Active 🏗 How It Works Phase 1: The Customer Bot (Workflow 1) Customer texts bot ↓ Route Message — detects command type ↓ ┌─────────────────────────────────────┐ │ /start → Welcome message │ │ /help → Help guide │ │ /menu → Today's menu │ │ /myorders → Last 5 orders │ │ STATUS → Live order status │ │ CANCEL → Cancel if Pending only │ │ [order] → AI parses → saves │ └─────────────────────────────────────┘ ↓ Order saved to Google Sheet (Status = Pending) Customer receives queue number + wait time Phase 2: The Staff Notification System (Workflow 2) Every 1 minute — Schedule Trigger fires ↓ Read ALL rows from Google Sheet ↓ For EACH row independently (runOnceForEachItem): Skip if no Queue Number or Chat ID Skip if Status = Pending Skip if Status = Last Status Sent (already notified) ✅ Send notification if Status changed ↓ Send Telegram message to that customer only ↓ Write new Status into column H (Last Status Sent) → Prevents duplicate notification next minute Status Flow & Customer Messages | Staff sets Status to | Customer receives | | :--- | :--- | | Preparing | 👨‍🍳 "Your order is being Prepared! We'll notify you when it's ready." | | Ready | 🍕 "Your order is READY for collection! Please collect from the counter." | | Completed | ✅ "Order marked as Completed. Thank you for dining with us!" | | Cancelled | ❌ "Your order has been Cancelled. We apologise for the inconvenience." | 🔒 Order Cancellation Rules Customers can only cancel orders in Pending status. All other states are protected: | Current Status | Customer tries CANCEL | Response | | :--- | :--- | :--- | | Pending | CANCEL 1234 | ✅ Cancelled successfully | | Preparing | CANCEL 1234 | ⚠️ Cannot cancel — being prepared | | Ready | CANCEL 1234 | ⚠️ Already ready — please collect | | Completed | CANCEL 1234 | ⚠️ Already completed | | Cancelled | CANCEL 1234 | ⚠️ Already cancelled | | Someone else's order | CANCEL 1234 | ❌ You can only cancel your own orders | 📦 Required Credentials Summary | Credential | Provider | Free Tier | | :--- | :--- | :--- | | Anthropic API | anthropic.com | Paid — ~$5 minimum deposit | | Google Sheets OAuth2 API | Google Cloud Console | Free | | Google Sheets Trigger OAuth2 API | Google Cloud Console | Free | | Telegram Bot API | @BotFather on Telegram | Free forever | 🧪 Test Scenarios Run these in order to verify the full system: /start → Should receive welcome message /menu → Should see the menu with prices Type 2 pizza + 1 coke → Should get queue number STATUS [queue] → Should show ⏳ Pending In sheet: change Status to Preparing → Within 1 min, customer gets 👨‍🍳 message In sheet: change Status to Ready → Customer gets 🍕 message STATUS [queue] → Should now show 🍕 Ready CANCEL [queue] → Should say "already ready, please collect" In sheet: change Status to Completed → Customer gets ✅ message /myorders → Should show order history with final status ⚠️ Known Limitations Notification delay:** Up to 1 minute between staff updating the sheet and customer receiving the message (due to polling interval) Column H required:** The Last Status Sent column must exist in your sheet. Without it, every row will fire a notification on every poll Anthropic API cost:** Claude Haiku is not free — very low cost (~$0.25 per million tokens) but requires a funded account Google Sheets trigger limitation:** The Google Sheets Trigger cannot detect which specific row changed, which is why a Schedule Trigger with row comparison is used instead 🗂 File Structure restaurant_WITH_STICKIES.json — Complete workflow (W1 + W2) with sticky notes restaurant_workflow_docs.md — This documentation file Built with n8n • Claude Haiku AI • Google Sheets • Telegram Bot API

Qualify real estate leads from Typeform to Airtable with Gemini and smart email routing

🏠 AI Real Estate Lead Qualifier — Typeform to Airtable with Smart Email Routing Automatically qualify property leads, score them with AI, save to Airtable, and send personalised emails — all in seconds. 📖 Description Every time a prospect submits your Typeform property inquiry, this workflow kicks in automatically. It extracts their details, runs them through an AI lead scoring engine, saves the record to Airtable, and sends a personalised email — a priority response for hot leads, a nurture email for everyone else. No manual review. No missed leads. No delayed follow-ups. This is built for real estate agencies, leasing companies, and property managers who receive inquiries through Typeform and want instant, intelligent responses without hiring extra staff. ✨ Key Features Instant lead capture** — triggers the moment Typeform receives a submission AI lead scoring** — Google Gemini classifies every lead as High, Medium, or Low automatically Smart email routing** — High leads get a priority response, others get a nurture sequence Airtable CRM sync** — every lead saved with full details + AI assessment Robust AI parsing** — 4-layer fallback system ensures AI output is always usable Personalised emails** — name, property type, location, budget pulled into every email automatically No-code maintenance** — update scoring rules in the prompt, email copy in the nodes 🔄 How It Works Prospect submits Typeform inquiry ↓ Webhook receives the form payload ↓ Extract Typeform Fields → name, email, phone, property type → purpose, location, budget, requirements ↓ AI Lead Qualifier (Google Gemini) → lead_score: High / Medium / Low → intent, timeline, notes ↓ Parse AI Output (4-layer fallback) ↓ Save to Airtable CRM ↓ High Lead? (IF check) ✅ YES → Priority Email (contact within 2 hours) ❌ NO → Nurture Email (contact within 1-2 days) 🤖 AI Lead Scoring Rules The AI automatically classifies leads based on these criteria: | Score | Criteria | | :--- | :--- | | 🔴 High | Has budget + specific location + clear purpose (investment or near-term buying) | | 🟡 Medium | Partial information — needs follow-up to qualify further | | 🟢 Low | Vague inquiry, missing budget or location, early exploration | The AI also extracts: Intent** — what the lead is trying to achieve Timeline** — how urgently they need a property Notes** — assessment summary for your sales team 📧 Email Templates High Lead Email Subject: 🏠 [Name], we have properties matching your needs! Dark blue header — premium feel Full inquiry summary (property, purpose, location, budget, timeline) AI assessment notes included Promise: senior agent contacts within 2 hours Nurture Email (Medium / Low) Subject: Thanks for reaching out, [Name]! Grey header — warm and professional Inquiry summary (property, location, budget) Preparation tips while they wait Promise: contact within 1-2 business days 🛠 Setup Requirements 1. Typeform Setup Create a Typeform with these fields and note their field ref IDs from the Typeform API: | Field | Type | Required | | :--- | :--- | :---: | | Full Name | Short text | ✅ | | Phone Number | Phone | ✅ | | Email Address | Email | ✅ | | Property Type | Multiple choice | ✅ | | Purpose | Multiple choice | ✅ | | Preferred Location | Short text | ✅ | | Budget Range | Multiple choice | ✅ | | Requirements | Long text | ✅ | | Consent | Yes/No | Optional | Connect Typeform webhook: Typeform Dashboard → Connect → Webhooks URL: your n8n webhook URL (Production URL from the Webhook node) Method: POST 2. Update Field Refs In the Extract Typeform Fields Code node, update the REF_* constants to match your actual Typeform field reference IDs: const REF_NAME = 'your-field-ref-here'; const REF_EMAIL = 'your-field-ref-here'; const REF_PHONE = 'your-field-ref-here'; // ... etc Find your field refs from the Typeform API or by logging a test webhook payload. 3. Airtable Setup Create an Airtable base with a table containing these fields: | Field Name | Field Type | | :--- | :--- | | Full Name | Single line text | | Email Address | Email | | Mobile Phone Number | Phone | | Property Type | Single line text | | Purpose | Single line text | | Preferred Location | Single line text | | Budget Range | Single line text | | Requirements | Long text | | Submit Date | Single line text | | Lead Score | Single line text | | Intent | Single line text | | Timeline | Single line text | | Notes | Long text | Update the Save to Airtable node with your Base ID and Table ID. 4. Credentials Required | Credential | Used for | Free? | | :--- | :--- | :--- | | Google Gemini (PaLM) API | AI lead scoring | Free tier available | | Airtable Personal Access Token | CRM save | Free | | SMTP | Sending emails | Depends on provider | 5. Email Configuration In both email nodes, update: fromEmail — your sending address SMTP credential — your email provider details Recommended SMTP providers for testing: Mailtrap (sandbox), Gmail, SendGrid ⚙️ Workflow Nodes | Node | Type | Purpose | | :--- | :--- | :--- | | Webhook | Webhook | Receives Typeform POST payload | | Extract Typeform Fields | Code | Parses answers by field ref ID | | AI Lead Qualifier | AI Agent | Scores lead using Gemini | | Google Gemini Chat Model | LLM | AI model for scoring | | Parse AI Output | Code | Extracts JSON with 4-layer fallback | | Save to Airtable | Airtable | Creates CRM record | | High Lead? | IF | Routes by lead score | | Priority Email | Email Send | Sends to High leads | | Nurture Email | Email Send | Sends to Medium/Low leads | 🔧 Customisation Change scoring criteria: Edit the prompt in the AI Lead Qualifier node. Add your own rules — e.g. score higher if budget exceeds a threshold, or if the purpose is investment. Add more email tiers: Add a third IF branch for Low leads with a different nurture sequence, or add a Slack/WhatsApp alert for High leads. Use a different form: The Extract Typeform Fields node uses Typeform's field.ref system. Replace it with a Google Forms or Jotform parser by adjusting how you read the incoming webhook body. Change the AI model: Replace the Google Gemini node with Claude, OpenAI, or any other LLM Chat Model node — no other changes needed. Add lead deduplication: Before saving to Airtable, add a search step to check if the email already exists and skip or update instead of creating a duplicate. 🛡 Robustness Features The Parse AI Output node uses a 4-layer fallback to ensure the workflow never breaks due to AI formatting issues: Direct JSON parse — if Gemini returns clean JSON Strip markdown fences — if Gemini wraps in Regex JSON extraction — if there's extra text around the JSON Field-by-field regex — if JSON is malformed, extracts each field individually Default fallback — if all else fails, sets lead_score: Medium This means the workflow continues and saves the record even if the AI returns unexpected output. 📊 Sample Airtable Record Full Name: Sarah Johnson Email Address: sarah@example.com Mobile Phone: +91 9876543210 Property Type: 2BHK Apartment Purpose: Investment Preferred Location: Bandra, Mumbai Budget Range: ₹80L - ₹1.2Cr Requirements: Parking, gym, sea view Submit Date: 2026-03-18T10:30:00Z Lead Score: High Intent: Serious buyer looking for investment property with strong rental yield Timeline: Within 3 months Notes: High-intent lead with clear budget and location. Has specific amenity requirements. Recommend immediate callback. 📦 Requirements Summary n8n (cloud or self-hosted) Typeform account (any paid plan for webhooks) Airtable account (free tier works) Google AI Studio account for Gemini API key (free tier available) SMTP email account 💡 Enhancement Ideas WhatsApp alert** — send instant WhatsApp to sales team for every High lead via Twilio Calendar booking link** — include a Calendly link in the High lead email Lead follow-up reminder** — add a Wait node + reminder email if no reply in 48 hours Slack notification** — ping your team channel instantly for High leads Lead scoring dashboard** — connect Airtable to a dashboard tool for weekly reports Built with n8n · Google Gemini AI · Typeform · Airtable · SMTP

Screen job applications from Google Forms with Google Gemini and email results

🤖 AI Resume Screener — Google Forms to Automated Shortlisting & Email Automatically score every job application with AI, update your tracking sheet, and send personalised emails to candidates — all without human review. 📖 Description This workflow automates your entire first-round resume screening process. When a candidate submits your Google Form application, the workflow triggers, extracts their details, scores them against the job description using AI, writes the results back to your Google Sheet, and sends the right email — a congratulations to shortlisted candidates, a polite rejection to others. Your HR team only reviews candidates the AI has already scored 7 or above. Built for companies hiring across multiple roles simultaneously, HR teams wanting to reduce screening time, and startups with no dedicated recruiting staff. ✨ Key Features Google Sheets Trigger** — fires automatically when a new application row is added Duplicate prevention** — tracks processed rows with a Processed column, never scores the same application twice Multi-role support** — built-in Job Description map for 5 roles, easily extendable AI scoring 1–10** — Google Gemini scores each candidate against the JD with strengths, weaknesses, recommendation Direct sheet write via API** — writes score + grade + status to exact row using Google Sheets API Smart email routing** — score ≥ 7 → shortlisted (HR alert + candidate email), score < 7 → rejection email Rate limit protection** — Wait node between HR alert and candidate email prevents SMTP throttling Robust AI parsing** — 3-layer fallback ensures AI output always produces a usable result 🔄 How It Works New Google Form submission ↓ Google Sheets Trigger (rowAdded, polls every minute) ↓ Read All Rows → Filter Unprocessed Rows (col_18 / Processed ≠ 1) ↓ Extract Fields + Load Job Description → name, email, phone, position, experience, skills, cover note → loads matching JD from built-in map ↓ AI Resume Scorer (Google Gemini) → score: 1–10 → grade: Strong Yes / Maybe / No → strengths, weaknesses, recommendation, summary ↓ Parse AI Output (3-layer fallback) ↓ Build Sheet Request → Write to Sheet via API → writes score, grade, strengths, weaknesses, recommendation, summary, status, timestamp, Processed=1 ↓ Score ≥ 7? ✅ YES → Alert Email to HR + Wait 10s → Shortlist Email to Candidate ❌ NO → Rejection Email to Candidate 🤖 AI Scoring System The AI scores each candidate from 1 to 10 against the job description: | Score | Grade | Action | | :---: | :--- | :--- | | 8–10 | Strong Yes | Shortlisted ✅ | | 7 | Strong Yes / Maybe | Shortlisted ✅ | | 5–6 | Maybe | Rejected ❌ | | 1–4 | No | Rejected ❌ | For each application the AI also provides: Strengths** — what the candidate does well vs the JD Weaknesses** — gaps or concerns Recommendation** — e.g. "Invite for technical interview" Summary** — 2–3 sentence overall assessment 📋 Built-in Job Descriptions Five roles are pre-configured and auto-matched by position name: | Role | Key Requirements | | :--- | :--- | | Frontend Developer | 2+ yrs React/Vue, HTML/CSS/JS, REST APIs, Git | | Backend Developer | 2+ yrs Node.js/Python/Java, PostgreSQL/MongoDB, Docker | | UI/UX Designer | 2+ yrs UI/UX, Figma or Adobe XD, portfolio | | Project Manager | 3+ yrs PM, PMP/Scrum preferred, Jira/Asana | | Digital Marketing Executive | 2+ yrs digital marketing, Google Ads, Meta Ads, GA4 | Add more roles by editing the JD_MAP object in the Extract Fields + Load JD node. 📧 Email Templates Shortlist Email (to candidate) Subject: Congratulations [Name] - You have been shortlisted! Navy blue header Score table (score/10, grade, position, experience, skills) Strengths highlighted in green AI assessment in blue Promise: HR contacts within 2 business days HR Alert Email (internal) Subject: Strong Candidate - [Name] for [Position] Amber header — urgent feel Full candidate details + complete AI breakdown Strengths, weaknesses, recommendation, summary all included Rejection Email (to candidate) Subject: Your application for [Position] - Update Grey header — professional and neutral Polite decline with encouragement No score or feedback shared 🛠 Setup Requirements 1. Google Form Create a Google Form with these fields: | Field | Type | | :--- | :--- | | Full Name | Short answer | | Email Address | Short answer | | Phone Number | Short answer | | Select the Position You Are Applying For | Dropdown | | Years of Experience | Short answer | | Relevant Skills | Long answer | | Cover Note | Long answer | Link the form to a Google Sheet (Responses tab). 2. Google Sheet — Response Sheet Columns The form creates columns A–H automatically. Add these columns manually for AI results: | Col | Header | Filled by | | :---: | :--- | :--- | | A | Timestamp | Google Forms | | B | Select the Position... | Google Forms | | C | Full Name | Google Forms | | D | Email Address | Google Forms | | E | Phone Number | Google Forms | | F | Years of Experience | Google Forms | | G | Relevant Skills | Google Forms | | H | Upload CV | Google Forms | | I | Cover Note | Google Forms | | J | AI Score | This workflow | | K | Grade | This workflow | | L | Strengths | This workflow | | M | Weaknesses | This workflow | | N | Recommendation | This workflow | | O | Summary | This workflow | | P | Status | This workflow | | Q | Processed At | This workflow | | R | Processed | This workflow (1 = done) | > Important: The workflow uses column R (Processed) to track which rows have been scored. Rows where R = 1 are skipped on subsequent triggers. 3. Credentials Required | Credential | Used for | Free? | | :--- | :--- | :--- | | Google Sheets Trigger OAuth2 | Detects new rows | Free | | Google Sheets OAuth2 | Read rows + write results | Free | | Google Gemini (PaLM) API | AI resume scoring | Free tier available | | SMTP | Sending emails | Depends on provider | 4. Update Sheet ID In the Read All Rows and Write to Sheet via API nodes, replace the Sheet ID with your own: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/... 5. Update Email Addresses In all three email nodes, update: fromEmail — your HR sending address HR alert toEmail — your internal HR inbox SMTP credential — your email provider ⚙️ Workflow Nodes | Node | Type | Purpose | | :--- | :--- | :--- | | Google Sheets Trigger | Trigger | Fires on new row (polls every minute) | | Read All Rows | Google Sheets | Reads all form responses | | Filter Unprocessed Rows | Code | Skips rows where Processed = 1 | | Extract Fields + Load JD | Code | Extracts candidate data + matches JD | | AI Resume Scorer | AI Agent | Scores candidate vs JD using Gemini | | Google Gemini Chat Model | LLM | AI model for scoring | | Parse AI Output | Code | Parses JSON with 3-layer fallback | | Build Sheet Request | Code | Prepares API write request for exact row | | Write to Sheet via API | HTTP Request | Writes results to columns J–R | | Score ≥ 7? | IF | Routes by score | | Alert Email - HR Team | Email Send | Notifies HR of strong candidates | | Wait 10s | Wait | Prevents SMTP rate limiting | | Shortlist Email - Candidate | Email Send | Congratulations to shortlisted | | Rejection Email - Candidate | Email Send | Polite rejection to others | 🔑 Key Technical Details Why HTTP Request for sheet write instead of Google Sheets node? The standard Google Sheets node cannot reliably write to a specific row by row number. Using the Sheets API PUT values/{range} endpoint writes to the exact cell range Form responses 1!J{rowNum}:R{rowNum} — always the correct row regardless of concurrent submissions. Why Read All Rows then Filter instead of reading one row? The Google Sheets Trigger fires on rowAdded but may not pass the exact new row data reliably. Reading all rows and filtering by Processed ≠ 1 is more reliable and handles backlog processing too. The Processed column (R) Set to 1 after scoring completes. This prevents re-processing if the trigger fires again before the workflow finishes, or if old unprocessed rows exist. 3-layer AI output fallback: Direct JSON parse Strip markdown fences then parse Regex extract JSON block Default values if all fail (score: 5, grade: Maybe) 📊 Sample Sheet Output After Scoring Col J (AI Score): 8 Col K (Grade): Strong Yes Col L (Strengths): 3+ yrs React experience; Strong TypeScript skills; Relevant API work Col M (Weaknesses): No Docker experience mentioned; No TypeScript explicitly listed Col N (Recommendation): Invite for technical interview Col O (Summary): Strong frontend candidate with solid React/Vue background. Experience aligns well with role requirements. Minor gaps in DevOps knowledge. Col P (Status): Shortlisted Col Q (Processed At): 2026-03-18T10:30:00.000Z Col R (Processed): 1 🔧 Customisation Add more roles: Edit the JD_MAP object in Extract Fields + Load JD: const JD_MAP = { 'Your New Role': 'ROLE: ... REQUIREMENTS: ...', // add as many as needed }; Change the score threshold: In the Score ≥ 7? IF node, change rightValue: 5 to any number. Setting to 8 makes the bar higher (only Strong Yes candidates shortlisted). Add a second HR alert channel: After the HR Alert Email, add a Slack or Telegram node to ping your team instantly for high-scoring candidates. Add calendar booking link: Include a Calendly link in the shortlist email so candidates can self-schedule interviews immediately. Extend with CV parsing: Add a Google Drive node before the AI scorer to download the CV attachment, extract text, and include it in the AI prompt for more accurate scoring. ⚠️ Important Notes The Google Sheets Trigger polls every minute — there may be up to a 1-minute delay after form submission before scoring begins The Processed column must exist in your sheet (column R) before activating the workflow Trailing spaces in Google Forms column headers are common — the key.trim() normalization in the code handles this automatically The Wait node between HR alert and shortlist email is intentional — prevents hitting SMTP rate limits when processing multiple candidates 💡 Enhancement Ideas CV download + parse** — download Google Drive CV attachment and include content in AI scoring Calendly integration** — auto-create interview slot and include booking link in shortlist email Slack alert** — instant Slack message to hiring manager for score ≥ 9 candidates Airtable sync** — mirror all candidate data to an Airtable CRM for pipeline tracking Telegram bot** — let HR check candidate status by texting a bot with the candidate email Multi-stage pipeline** — add a second workflow that triggers when HR marks a candidate for second round 📦 Requirements Summary n8n (cloud or self-hosted) Google Workspace account (Forms + Sheets) Google AI Studio account for Gemini API key (free tier available) SMTP email account (Gmail, SendGrid, Mailtrap etc.) Built with n8n · Google Gemini AI · Google Forms · Google Sheets · SMTP

Send weekly invoice summaries and overdue alerts from Google Sheets via Gmail and Slack

Most small businesses track invoices in Google Sheets, but nobody actually looks at the spreadsheet until cash flow gets tight. By then, invoices that should have been chased weeks ago are sitting there unpaid. This workflow gives you an automatic weekly report and alerts you when anything is overdue. Who is this for Freelancers, agencies, and small businesses that track invoices in Google Sheets and want a hands-off way to stay on top of what's been paid, what hasn't, and what's late. How it works Every Monday at 9 AM, the workflow pulls all rows from your invoice tracker in Google Sheets. A code node crunches the numbers: total paid, total unpaid, and total overdue. It builds an HTML email with a clean summary table that shows the overall picture plus a detailed breakdown of any overdue invoices, including how many days late each one is. That summary gets emailed to whatever address you configure. If there are any overdue invoices, a separate Slack alert goes out with the specifics so your team knows exactly what needs chasing. How to set it up Create a Google Sheet with an "Invoices" tab containing these columns: Invoice ID, Client Name, Amount, Due Date, Status (paid/unpaid/overdue) Open the "Configure Settings" node and fill in your Sheet ID, the email address you want the report sent to, your Slack channel ID, and your business name Connect your Google Sheets, Gmail, and Slack credentials in n8n Activate the workflow and wait for Monday, or trigger it manually to test Requirements Google Sheets (free) Gmail account with OAuth connected in n8n Slack workspace with OAuth connected in n8n Customizing the workflow You can change the schedule to daily or biweekly by editing the trigger node. The overdue threshold is based on the Due Date column, so if you want to flag invoices that are approaching their due date (not just past it), you can tweak the comparison in the code node. If you want to add more notification channels (email to the client directly, SMS alerts, etc.), just wire new nodes after the overdue check.

Beginner

Why Choose Us?

AI-Powered n8n Templates

GPT-4 powered intelligent engine that generates custom n8n templates from simple descriptions

Premium Quality n8n Templates

Every n8n template is tested and verified to ensure reliability and practical automation value

One-Click Import

Support one-click import to n8n, start using immediately

Ready to Get Started?

Start using AI to generate n8n templates now, or explore our comprehensive n8n templates library with 7000+ proven workflows

Start AI Generation Browse Templates