by Cheng Siong Chin
Introduction Automates travel itinerary creation by searching flights and hotels via APIs, then uses AI to generate personalized recommendations delivered as HTML emails through Gmail. How It Works Webhook receives travel requests, searches Skyscanner and Booking.com APIs in parallel, merges results, uses AI to create optimized itineraries, formats as HTML email, sends via Gmail. Workflow Template Webhook → Parse & Validate → Parallel Searches (Flights: Skyscanner | Hotels: Booking.com) → Merge Data → AI Generate Itinerary → Format HTML Email → Send Gmail → Webhook Response Workflow Steps Trigger & Validate: Webhook receives request, extracts destination/dates/budget/preferences, validates data, converts to API parameters. Parallel Search: Skyscanner fetches flights with price/duration/airline. Booking.com retrieves hotels with ratings/pricing. Merge combines both into single JSON object. AI Generation: AI analyzes merged data, evaluates by price/duration/rating, creates itinerary with daily schedule, pairings, costs, and rankings. Delivery: Converts JSON to HTML email with tables and booking links. Gmail sends email. Webhook confirms success. Setup Instructions API Configuration: Add Skyscanner and Booking.com API credentials in n8n. Gmail Setup: Configure OAuth2 authentication. Customization: Copy webhook URL, adjust validation rules, modify AI prompts and HTML template. Prerequisites Skyscanner API key Booking.com API credentials Gmail with OAuth2 n8n instance Use Cases Personal vacation planning Business travel arrangements Customization Add APIs (Kiwi, Expedia) Filter by budget, Modify email design Benefits Saves 2-3 hours per trip Real-time pricing comparison
by Shelly-Ann Davy
Who’s it for Busy homemakers, creators, and anyone who wants a simple, no-cost way to plan weekly meals and get a ready-to-shop grocery list—without extra apps. What it does Runs on a weekly Cron schedule, generates a grocery list, creates rows in your Notion database (Ingredient, Quantity, Status), and emails the list (optional Telegram confirmation). It includes a Notion connection check, detailed error notifications (email and optional Telegram), a success email with timestamp, and optional persistent logging to a Notion “Logs” database. Requirements Notion account + integration connected to your database SMTP credentials for the Email node (Optional) Telegram bot and chat ID for alerts (Optional) Notion log database if you want persistent logs How to set up Import the workflow and open Set: Configuration to fill: fromEmail, emailTo, notifyEmail, notionDb, telegramChatId (Optional) logToNotion (true/false), notionLogDb In Notion, create a DB with properties: Ingredient (Title), Quantity (Rich text), Status (Select: “To Buy”) Attach your Notion and SMTP credentials (and Telegram if used). Run once to test, then set Cron to your preferred weekly time. How to customize Edit the recipe/grocery items in the Code node. Change the Cron schedule (test with “Every minute,” then revert to weekly). Enable Telegram alerts, and/or turn on Notion logging for audit trails.
by Emir Belkahia
Automated Weekly Newsletter for E-commerce Promotions (based on Algolia) This workflow automatically sends a beautifully designed HTML newsletter every Sunday at 8 AM, featuring products currently on sale from your Algolia-powered e-commerce store. Who's it for Perfect for e-commerce store owners, marketing teams, and anyone running promotional campaigns who wants to automate their weekly newsletter without relying on expensive email marketing platforms. How it works Triggers every Sunday at 8:00 AM - Scheduled to start each new promotion week Fetches discounted products - Queries your Algolia index for 6 products marked with on_sale:true Calculates promotion dates - Automatically generates the week's date range (Sunday to Saturday) Builds HTML newsletter - Populates a responsive email template with product images, prices, and descriptions Retrieves subscribers - Pulls the latest subscriber list from your Google Sheets Sends personalized emails - Delivers the newsletter to all subscribers via Gmail Set up steps Setup time: ~15 minutes Connect your Algolia credentials (Search API key + Application ID) Update the Algolia index name to match your store (currently set to dogtreats_prod_products) Create a Google Sheet with subscriber emails (column named "Email") Connect your Google Sheets and Gmail accounts (Optional) Customize the HTML template colors and branding to match your store Requirements Algolia account with a product index containing on_sale, price_eur, original_price_eur, image, name, and description fields Google Sheets with subscriber list Gmail account for sending emails How to customize Change promotion criteria**: Modify the filter in "Request products from Algolia" node (e.g., category:shoes instead of on_sale:true) Adjust product count**: Change hitsPerPage value (currently 6) Modify schedule**: Update the trigger node to run on different days/times Personalize email design**: Edit the HTML template node to match your brand colors and style Add unsubscribe logic**: Extend the workflow to handle unsubscribe requests 💡 Pro tip: Use the manual execution button to test the workflow mid-week - it's "smart" enough to calculate the current promotion week even when not running on Sunday.
by David Olusola
Overview This n8n workflow automates the process of sending a daily weather report for a specified city directly to your email inbox. It's a simple yet effective way to stay informed about the weather without manually checking. How It Works This workflow operates in four main steps: Daily Schedule Trigger: The workflow begins with a Cron node, which acts as a scheduler. It's configured to trigger the workflow automatically at a specific time each day (e.g., every morning at 8:00 AM). Fetch Weather Data: Next, an HTTP Request node is used to interact with the OpenWeatherMap API. This node constructs a URL to query the API for current weather conditions in a specified city (e.g., "London"). It includes parameters like units=metric (for Celsius temperatures) and your unique appid (API key) for authentication with OpenWeatherMap. Format Weather Report: A Code node receives the raw JSON weather data from the OpenWeatherMap API. Inside this node, JavaScript code extracts relevant information such as city name, weather description, temperature (current and "feels like"), humidity, and wind speed. It then formats this information into a human-readable text string, creating the actual weather report message. Send Email Report: Finally, a Gmail node takes the formatted weather report from the Code node. It uses your configured Gmail credentials to send an email to your specified recipient address. The email's subject line dynamically includes the city name, and the body contains the full formatted weather report. Setup Steps To get this workflow up and running, follow these instructions: Step 1: Get Your OpenWeatherMap API Key Go to the OpenWeatherMap website. Sign up for a free account if you don't already have one. Once logged in, navigate to the "API keys" section of your profile. Copy your unique API key. You will need this in Step 4. Step 2: Create Gmail Credentials in n8n In your n8n instance, click on Credentials in the left sidebar. Click New Credential. Search for and select "Gmail OAuth2 API" or "Gmail API" (OAuth2 is generally preferred). Follow the on-screen instructions to connect your Gmail account. This usually involves clicking an "Authenticate with Google" button and granting n8n the necessary permissions. Save the credential. Make note of the Credential Name (e.g., "My Gmail Account").
by Asuka
Who's it for Customer support teams, sales representatives, and international business professionals who need to handle multilingual email communication efficiently while maintaining quality control through human approval. How it works This workflow automates email responses by: Monitoring Gmail for emails with a specific label (e.g., "To_Process") Translating the email content using DeepL to your preferred language Generating an AI-powered summary and draft reply using OpenAI Requesting approval via Slack with a summary and one-click approval link Sending the reply only after human approval is received Removing the label to prevent reprocessing Set up steps Setup takes approximately 15-20 minutes: Configure credentials for Gmail, DeepL, OpenAI, and Slack Create a Gmail label for emails to process Update the Slack channel ID in the configuration node Ensure n8n is accessible via webhook (tunnel or production mode required) Requirements Gmail account with OAuth2 authentication DeepL API key (free tier available) OpenAI API key Slack workspace with OAuth2 app configured n8n instance accessible via webhook URL How to customize the workflow Change translation language**: Modify the DeepL node's target language Adjust AI model**: Switch between GPT-4 or GPT-3.5 in the OpenAI node Customize approval message**: Edit the Slack message format Add multiple languages**: Duplicate the translation node for multi-language support Filter specific senders**: Add conditions to process only certain email addresses
by Fahmi Fahreza
This template sets up a weekly ETL (Extract, Transform, Load) pipeline that pulls financial data from QuickBooks Online into Google BigQuery. It not only transfers data, but also cleans, classifies, and enriches each transaction using your own business logic. Who It's For Data Analysts & BI Developers** Need structured financial data in a warehouse to build dashboards (e.g., Looker Studio, Tableau) and run complex queries. Financial Analysts & Accountants** Want to run custom SQL queries beyond QuickBooks’ native capabilities. Business Owners** Need a permanent, historical archive of transactions for reporting and tracking. What the Workflow Does 1. Extract Fetches transactions from the previous week every Monday from your QuickBooks Online account. 2. Transform Applies custom business logic: Cleans up text fields Generates stable transaction IDs Classifies transactions (income, expense, internal transfer) 3. Format Prepares the cleaned data as a bulk-insert-ready SQL statement. 4. Load Inserts the structured and enriched data into a Google BigQuery table. Setup Guide 1. Prepare BigQuery Create a dataset (e.g., quickbooks) and table (e.g., transactions) The table schema must match the SQL query in the "Load Data to BigQuery" node 2. Add Credentials Add QuickBooks Online and Google BigQuery credentials to your n8n instance 3. Configure Business Logic Open the Clean & Classify Transactions node Update the JavaScript arrays: internalTransferAccounts expenseCategories incomeCategories Ensure these match your QuickBooks Chart of Accounts exactly 4. Configure BigQuery Node Open the Load Data to BigQuery node Select the correct Google Cloud project Ensure the SQL query references the correct dataset and table 5. Activate the Workflow Save and activate it The workflow will now run weekly Requirements A running n8n instance (Cloud or Self-Hosted) A QuickBooks Online account A Google Cloud Platform project with BigQuery enabled A BigQuery table with a matching schema Customization Options Change Schedule**: Modify the schedule node to run daily, monthly, or at a different time Adjust Date Range**: Change the date macro in the Get Last Week's Transactions node Refine Classification Rules**: Add custom logic in the Clean & Classify Transactions node to handle specific edge cases
by Jitesh Dugar
Dynamic Email Signature Creator (PDF + HTML) Create gorgeous, branded, professional email signatures automatically — from a simple POST request. This workflow turns user details into a premium HTML signature, converts it into PDF, and delivers it instantly via Gmail, along with a clean JSON response. ✨ What This Template Does This workflow automatically: Receives user details (name, role, email, phone, links) via Webhook Extracts & validates inputs Generates a modern, premium HTML signature with icons + layout Converts HTML → high-quality PDF using HTMLCSS → PDF service Emails both the HTML signature preview + PDF attachment to the user Returns a clean JSON success response with the pdf_url Works 100% automated — no manual designing needed Perfect for: HR onboarding Corporate identity management Personal branding Team signature standardization Automated client signature setup 🔥 Features Beautiful modern design** Clean branding layout with icons (LinkedIn, Instagram, Website) Professional color palette + typography Auto-generated PDF (print-ready) Mobile-friendly & email-safe HTML Supports any social links Extremely easy to integrate with forms, portals, CRMs Fast: Signature generated in < 3 seconds 🧩 How It Works Webhook receives user information Input extractor formats the fields HTML template dynamically inserts user values HTML → PDF generator creates high-resolution output Email node sends signature + PDF Workflow responds with JSON (pdf_url, status, etc.) ⚙️ Setup Needed Connect these credentials in n8n: HTML → PDF** (PDFMunk account) Gmail** (for sending the final signature email) Update inside the HTML template: Brand colors Logo URL (optional) Social icon colors / links (optional) That’s it — your automated signature generator is live. 🏷️ Tags email-signature, branding, pdf-generator, html-template, gmail, automation, onboarding, corporate
by Angel Menendez
Who it's for This workflow is ideal for YNAB users who frequently shop on Amazon and want their transaction memos to automatically show itemized purchase details. It's especially helpful for people who import bank transactions into YNAB and want to keep purchase records tidy without manual entry. How it works The workflow triggers on a set schedule, via a webhook, or manually. It retrieves all unapproved transactions from your YNAB budget, filters for Amazon purchases with empty memo fields, and processes each transaction individually. Using Gmail, it searches for matching Amazon emails (within ±5 days of the transaction date) and sends the email data to an AI agent powered by OpenAI. The AI extracts product names and prices, generating a concise memo line (up to 499 characters). If no valid purchase info is found, a fallback message is added instead. A 5-second delay prevents API rate limiting. How to set up Connect your YNAB account with valid API credentials. Connect Gmail with OAuth2 authentication. Add your OpenAI (or other LLM) API credentials. Configure the schedule trigger or use manual/webhook start. Run the workflow and monitor execution logs in n8n. Requirements YNAB API credentials Gmail OAuth2 connection OpenAI API key (or another compatible AI model) How to customize You can change the AI model (e.g., Gemini or Claude) or add HTML-to-Markdown conversion to lower token costs. Adjust the wait node delay to fit your API rate limits or modify the email date range for greater accuracy. Security note: Never store or share API keys or personal email data directly in the workflow. Use credential nodes to manage sensitive information securely.
by Christian Lutz
How it works This workflow automates the delivery of personalized, AI-generated reports or roadmaps for new leads. When someone submits their information through a form, the workflow: Captures and stores the lead data. Uses an AI model to generate a customized report or roadmap. Formats the output into a professional, email-ready HTML document. Sends the report automatically to the lead via email. Optionally sends internal notifications (e.g., via chat or email) for tracking and follow-up. The process eliminates manual work and ensures every lead receives instant, high-quality output tailored to their input. Setup steps Webhook – Connect your form or website to the webhook endpoint to receive lead data. Data Table – Create or link a table to store incoming leads and track delivery status. AI Configuration – Add your OpenAI (or compatible) API credentials and customize prompts for your desired output. Email Setup – Configure SMTP credentials and define sender/recipient addresses for report delivery. Notifications – Optionally connect a chat or messaging service (e.g., Telegram) for internal alerts. Activation – Test the workflow, confirm the data flow and email delivery, then activate it for live use. This workflow transforms manual lead engagement into a fully automated, AI-driven experience that delivers instant, personalized value to every new contact.
by Summer
Website Leads to Voice Demo and Scheduling Creator: Summer Chang AI Booking Agent Setup Guide Overview This automation turns your website into an active booking agent. When someone fills out your form, it automatically: Adds their information to Notion AI researches their business from their website Calls them immediately with a personalized pitch Updates Notion with call results Total setup time: 30-45 minutes What You Need Before starting, create accounts and gather these: n8n account (cloud or self-hosted) Notion account - Free plan works duplicate my notion template OpenRouter API key - Get from openrouter.ai Vapi account - Get from vapi.ai Create an AI assistant Set up a phone number Copy your API key, Assistant ID, and Phone Number ID How It Works The Complete Flow Visitor fills form on your website Form submission creates new record in Notion with Status = "New" Notion Trigger detects new record (checks every minute) Main Workflow executes: Fetches lead's website AI analyzes their business Updates Notion with analysis Makes Vapi call with personalized intro Call happens between your AI agent and the lead When call ends, Vapi sends webhook to n8n Webhook Workflow executes: Fetches call details from Vapi AI generates call summary Updates Notion with results and recording
by Robert Breen
This n8n automation notifies you whenever someone books a meeting with you via Calendly. It sends a customized email via Outlook and a Slack message using details from the event. 📌 What This Workflow Does Listens for new Calendly meeting bookings (invitee.created). Extracts key details (name, email, reason for meeting, start time). Uses an AI agent to generate both: A HTML email sent to you via Outlook. A Slack message sent to your chosen channel. ⚙️ Step-by-Step Setup Instructions 1. 🔗 Calendly API Setup In n8n: Go to Credentials → Add Credential → Calendly API. Connect your account with the personal access token. In the Calendly Trigger node, set event to invitee.created. 2. 📧 Microsoft Outlook Credential Add Microsoft Outlook credentials via OAuth2 in n8n → Credentials. Select it in the "Send a message" node. 3. 💬 Slack Setup Add Slack OAuth2 credentials. Select your Slack workspace and choose the channel (e.g., #leads). 4. 🧠 Configure the AI Agent (OpenAI) Provide your OpenAI API key under Credentials → OpenAI API. The AI Agent node is pre-configured to: Format a custom Slack message Format a custom Outlook HTML email 5. 🛠 Node Details Calendly Event** (Trigger): Listens for new bookings Edit Fields**: Extracts values like name, email, start time, and form answers Email Generator** (AI Agent): Creates formatted email + Slack message Send a message** (Outlook): Sends the formatted email to your inbox Slack Message**: Sends the AI-generated Slack alert 🧪 Example Output Slack Message:
by Madame AI
Track AI search rankings from Perplexity to Google Sheets and Slack This workflow automates Generative Engine Optimization (GEO) tracking by monitoring how your company appears in AI search results. It generates strategic queries, simulates searches on AI engines like Perplexity via BrowserAct, logs the responses for historical tracking, and delivers a graded performance report to Slack. Target Audience SEO specialists, brand managers, marketing directors, and growth teams focusing on AI visibility and reputation management. How it works Initialize Tracking: The workflow runs on a schedule, creates a new dated tab in your Google Sheet, and fetches your company details (Name and Category). Generate Strategy: An AI Agent (using OpenRouter/Gemini) generates three specific search queries: Discovery: Broad category search (e.g., "Best CRM for startups"). Comparison: Direct competitor face-off (e.g., "Pipedrive vs Salesforce"). Validation: Specific fact-checking (e.g., "Is Pipedrive good for visual pipelines?"). Simulate Searches: BrowserAct executes these queries on an AI answer engine (like Perplexity) to capture the real-time AI response. Log Data: The workflow loops through the results and saves the raw AI answers to the daily Google Sheet. Analyze & Report: A second AI Agent reviews the saved data, grades the visibility (Green/Yellow/Red), and sends a summarized "GEO Scorecard" to Slack. How to set up Configure Credentials: Connect your Google Sheets, Slack, BrowserAct, and OpenRouter accounts in n8n. Prepare BrowserAct: Ensure the GEO Results & Rank Tracking template is saved in your BrowserAct account. Setup Google Sheet: Create a Google Sheet with a tab named Main Sheet. Add headers: Company name and Worknig category. Fill in row 2 with your details. Select Spreadsheet: Open the Create sheet, add headers, Get Company data, Retrieve Stored Data, and Store Extracted Data nodes to select your specific spreadsheet. Configure Notification: Open the Send Message to Team on Slack node and select your target Slack channel. Google Sheet Headers Tab 1: Main Sheet (Input) Company name Working Category Tab 2+: [Date] (Generated automatically by the workflow) Search Result Requirements BrowserAct* account with the *GEO Results & Rank Tracking** template. Google Sheets** account. Slack** account. OpenRouter** account (or compatible LLM credentials). How to customize the workflow Change the AI Engine: Modify the BrowserAct template to search on ChatGPT or Google Gemini instead of Perplexity. Adjust Grading Logic: Update the system prompt in the Company data analyzer node to change how the AI scores the results (e.g., focus more on sentiment than ranking). Expand Reporting: Add an Email node to send a weekly summary of the Google Sheet data to stakeholders. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video Master GEO: Track Your AI Search Rankings with n8n & Perplexity 🌍