by Robert Breen
This workflow pulls marketing data from Google Sheets, aggregates spend by channel, generates an AI-written summary, and outputs a formatted PDF report using a custom HTML template on PDF.co. ⚙️ Setup Instructions 1️⃣ Prepare Your Google Sheet Copy this template into your Google Drive: Sample Marketing Data Add or update your marketing spend data in rows 2–100. Connect Google Sheets in n8n Go to n8n → Credentials → New → Google Sheets (OAuth2) Log in with your Google account and grant access Select the Spreadsheet ID and Worksheet in the workflow 2️⃣ Set Up PDF.co for PDF Reports Create a free account at PDF.co In PDF.co Dashboard → HTML to PDF Templates, create a new Mustache template Paste the HTML provided at the bottom of this description Save, and note your Template ID In n8n → Credentials → New → PDF.co API, paste your API Key and save In the workflow, select your PDF.co credential in the Create PDF node Replace the templateId with your Template ID 🧠 How It Works Google Sheets Node**: Pulls marketing spend data Summarize Nodes**: Aggregate total spend and spend per channel OpenAI Node**: Writes a daily summary of marketing performance Code Node**: Converts aggregated data into the correct shape for the PDF template PDF.co Node: Generates a final, formatted **PDF report 📬 Contact Need help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your PDF)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com 📄 HTML Template (for PDF.co) > Paste this into a new HTML Template on PDF.co and reference its Template ID in your workflow. <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Invoice {{invoiceNumber}}</title> <style> body { font-family: Arial, Helvetica, sans-serif; margin: 36px; color: #222; } .header { display: flex; justify-content: space-between; align-items: center; } .brand { max-height: 56px; } h1 { margin: 12px 0 4px; font-size: 22px; } .meta { font-size: 12px; color: #555; } .two-col { display: flex; gap: 24px; margin-top: 16px; } .box { flex: 1; border: 1px solid #ddd; padding: 12px; border-radius: 6px; } .label { font-size: 11px; color: #666; text-transform: uppercase; letter-spacing: .02em; } table { width: 100%; border-collapse: collapse; margin-top: 16px; } th, td { border-bottom: 1px solid #eee; padding: 10px 8px; font-size: 13px; } th { background: #fafafa; text-align: left; } tfoot td { border-top: 2px solid #ddd; font-size: 13px; } .right { text-align: right; } .totals td { padding: 6px 8px; } .grand { font-weight: 700; font-size: 14px; } .notes { margin-top: 18px; font-size: 12px; color: #444; } </style> </head> <body> Invoice {{invoiceNumber}} Date: {{invoiceDate}} | Due: {{dueDate}} {{#company.logoUrl}} {{/company.logoUrl}} From {{company.name}} {{company.address}} {{company.phone}} {{company.email}} Bill To {{billTo.name}} {{billTo.address}} {{billTo.email}} Description Qty Unit Price Line Total {{#items}} {{line}} {{description}} {{qty}} {{unitPriceFmt}} {{lineTotalFmt}} {{/items}} Subtotal {{subTotalFmt}} Tax ({{taxRatePct}}) {{taxAmountFmt}} Discount -{{discountFmt}} Total {{totalFmt}} Notes: {{notes}} Terms: {{terms}} </body> </html>
by David Olusola
🎥 Auto-Summarize Zoom Recordings → Slack & Email Never lose meeting insights again! This workflow automatically summarizes Zoom meeting recordings using OpenAI GPT-4 and delivers structured notes directly to Slack and Email. ⚙️ How It Works Zoom Webhook – triggers when a recording is completed. Normalize Data – extracts meeting details + transcript. OpenAI GPT-4 – creates structured meeting summary. Slack – posts summary to your chosen channel. Email – delivers summary to your inbox. 🛠️ Setup Steps 1. Zoom Create a Zoom App with the recording.completed event. Add workflow webhook URL. 2. OpenAI Add your API key to n8n. Use GPT-4 for best results. 3. Slack Connect Slack credentials. Replace YOUR_SLACK_CHANNEL with your channel ID. 4. Email Connect Gmail or SMTP. Replace recipient email(s). 📊 Example Slack Message 📌 Zoom Summary Topic: Sales Demo Pitch Host: alex@company.com Date: 2025-08-30 Summary: Reviewed Q3 sales pipeline Discussed objections handling Assigned action items for next week ⚡ Get instant summaries from every Zoom meeting — no more manual note-taking!
by Don Jayamaha Jr
Create your own Bitcoin Liquidity Exchange Channel with an AI Agent—fully integrated with 10 major centralized exchanges. This workflow acts as a liquidity intelligence agent, connecting multiple exchange order books into a unified dataset, then applying AI analysis to generate actionable trading insights. It’s the ultimate tool for Bitcoin traders, analysts, community managers, and researchers who need cross-exchange liquidity monitoring—delivered instantly through Telegram. 🔌 Supported Exchanges (Integrated) Binance Coinbase Bybit MEXC Gate.io Bitget OKX Kraken HTX (Huobi) Crypto.com 🌟 What Makes This Workflow Special? This isn’t just raw order book data—it’s an AI-powered aggregator that: Fetches BTC/USDT order books (up to 5000 levels deep) from 10 exchanges Normalizes & merges** liquidity data into a single view Uses GPT-4.1 or GPT-4.1-mini to detect liquidity clusters, imbalances, and support/resistance Generates two structured outputs: Liquidity Report (raw snapshots from all exchanges) AI Trading Brief (intraday + weekly signals) Publishes insights directly into a Telegram channel 🔍 What You Can Do 📊 Cross-Exchange Liquidity View Monitor total liquidity depth across top 10 exchanges Spot hidden bid/ask clusters and weak order book levels ⚡ Real-Time Signals Detect when liquidity evaporates at key price points Receive intraday + weekly trading briefs 📢 Community Ready Run your own public or private Telegram channel with automated liquidity updates ✅ Example Alerts “BTC liquidity depth update: $30M bid wall forming at $62,000 across Binance & OKX.” “Ask-side liquidity dropped 20% in the last hour on Bybit + Coinbase.” “Daily summary: Cross-exchange liquidity balanced, net inflow +3.2%.” “Liquidity cluster detected: strong support between $61,800 – $62,150.” 🛠️ Setup Instructions Create a Telegram Bot Use @BotFather to generate a bot token Add the bot to your channel and get the channel ID Configure API Keys OpenAI API Key (GPT-4.1 or GPT-4.1-mini) Telegram Bot Token + Channel ID Import Workflow into n8n Add credentials in the Set node (no hardcoding in HTTP nodes) Configure schedule trigger (15m, hourly, daily, etc.) Deploy & Test Run the workflow and confirm liquidity + AI insights appear in Telegram ⚙️ Workflow Architecture AI Brain** → GPT-4.1 or GPT-4.1-mini Data Sources** → 10 centralized exchanges (BTC/USDT order books) Data Normalization** → Unified liquidity dataset Outputs** → Liquidity Report (raw exchange stats) AI Trading Brief (signals + summaries) Delivery** → Telegram Channel 📝 Included Sticky Notes System Overview** (workflow purpose & design) Exchange Data Integration** (order book depth per CEX) Setup Guide** (Telegram + API keys) Customization Notes** (change frequency, extend signals) Legal Disclaimer** (AI analysis, not financial advice) Your Bitcoin liquidity insights—unified, AI-analyzed, and delivered in real time to Telegram.
by Adem Tasin
✔ Short Description Automate your lead qualification pipeline — capture Typeform Webhook leads, enrich with APIs, score intelligently, and route to HubSpot, Slack, and Sheets in real-time. 🧩 Description Automate your lead management pipeline from form submission to CRM enrichment and routing. This workflow intelligently processes Typeform Webhook submissions, enriches leads using Hunter.io and Abstract API, scores them with dynamic logic, and routes them into HubSpot while keeping your sales team and tracking sheets up to date. It’s a full-stack automation designed to turn raw form submissions into prioritized, qualified CRM-ready leads — without manual intervention. 💡 Who’s it for Marketing teams managing inbound leads from web forms Sales operations teams that qualify and route leads CRM administrators automating lead data entry and scoring Automation professionals building data enrichment systems ⚙️ How it works / What it does Trigger: Receives new Typeform Webhook submissions via Webhook. Data Extraction: Parses name, email, and company info. Email Verification: Validates email deliverability with Hunter.io. Company Enrichment: Fetches company data (industry, size, country) using Abstract API. Lead Scoring Logic: Calculates a lead score and assigns a tier (Hot / Warm / Cold). Conditional Routing: Hot Leads (≥70) → Sent to HubSpot as Qualified. Warm/Cold Leads (<70) → Sent to HubSpot as Nurture stage. Revalidation Loop: Waits (e.g., 3 days) → Rechecks Nurture leads in HubSpot. Logs them to Google Sheets and alerts your Slack channel. 🧰 How to set up Connect accounts: Typeform Webhook (for inbound lead capture) Hunter.io (API key for email verification) Abstract API (for company enrichment) HubSpot (via OAuth2 credentials) Slack (for notifications) Google Sheets (for logging) Customize the Webhook URL inside your Typeform Webhook integration. Replace API keys with your own (Hunter.io, Abstract). Adjust scoring logic inside the Lead Scoring & Routing Logic node to fit your business. Set Wait duration (default: 10 seconds for testing → change to 3 days for production). Activate the workflow and test it with a sample form submission. 🔧 Requirements Typeform account with webhook capability Hunter.io account + API key Abstract API account + API key HubSpot account with OAuth2 credentials Slack workspace & channel Google Sheets integration 🎨 How to customize the workflow Scoring rules:** Modify the “Lead Scoring & Routing Logic” node to adjust how points are calculated (e.g., country, industry, employee size). CRM target:** Replace HubSpot nodes with another CRM (e.g., Pipedrive, Salesforce). Notification channel:** Swap Slack for Email, Discord, or MS Teams. Data source:** Replace Typeform Webhook with another trigger like Webflow Forms, Airtable, or custom API input. Tracking:** Add Google Analytics or Notion API for additional reporting. 🧭 Summary End-to-end lead automation workflow that combines form data, enrichment APIs, CRM updates, and Slack alerts into one intelligent system. Ideal for any team looking to centralize and qualify leads automatically — from submission to sales. 🧑💻 Creator Information Developed by: Adem Tasin 🌐 Website: ademtasin 💼 LinkedIn: Adem Tasin
by Vladimir
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automated Meeting Bot: Google Meet → AI Summary → Slack How it works Automatically joins Google Meet calls, transcribes conversations, and posts AI-generated summaries to Slack - completely hands-free meeting notes for busy teams. The workflow triggers when a Google Meet starts in your calendar, joins the meeting with a bot, waits for completion, then generates and posts a structured summary to your Slack channel. Set up steps Connect Google Calendar API for meeting detection Set up Vexa.ai account and obtain API key for meeting bot functionality Configure OpenAI API credentials for AI-powered summarization Create Slack bot token and add to desired channel Update calendar ID and Slack channel in workflow settings Test with a sample meeting to verify end-to-end functionality Keep detailed descriptions in sticky notes inside your workflow for easy configuration and troubleshooting.
by kiran adhikari
📝 Description This workflow automates the collection, filtering, and scoring of trending AskReddit posts for viral potential. It pulls posts from Reddit, removes duplicates, calculates a custom virality score, and writes the final candidates into Google Sheets for later use in content creation. This is Phase 1 of the AskReddit → YouTube Shorts automation pipeline. It prepares clean, high-quality data that can be used in the next phases (script generation, AI video creation, and publishing). ⚙️ Setup Steps Import Workflow into your n8n instance. Reddit API: Add your Reddit API credentials in the "Get AskReddit Posts" node. Google Sheets: Connect your Google account. Point the "Write Candidates" node to your target Google Sheet. Virality Scoring: The "Add Virality Score" node assigns weights (e.g., upvotes, comments). Adjust the scoring logic as needed for your niche. Run Workflow: Execute manually or schedule with Cron. Verify that trending AskReddit posts appear in your sheet, scored and cleaned.
by Robert Breen
This beginner-friendly n8n workflow teaches essential data manipulation techniques using Google Sheets and AI. You'll learn how to: ✅ Merge two datasets by a shared column (Channel) 🔍 Filter rows based on performance metrics (Clicks, Spend) 🔀 Branch logic into "Great" vs. "Poor" outcomes 📊 Summarize results by team leader 🤖 Use an OpenAI-powered agent to generate a written analysis highlighting the best and worst performers Perfect for marketers, analysts, or anyone learning how to clean, transform, and interpret data inside n8n. Includes: 📁 Sample Google Sheet to copy 🛠 Setup instructions for Google Sheets & OpenAI ✨ AI summary powered by GPT-4o-mini 👋 Questions or Feedback? Feel free to reach out — I’m happy to help! Robert Breen Founder, Ynteractive 🌐 ynteractive.com 📧 robert@ynteractive.com 📺 YouTube: YnteractiveTraining 🔗 LinkedIn: linkedin.com/in/robertbreen
by zawanah
This n8n workflow demonstrates how to use AI to update your grocery list in Asana via Telegram chat or voice. Use cases Update grocery list details in Asana eg. check or uncheck the items, update expiry dates, update quantities etc. How it works Instruct telegram bot (via chat or voice) to update a grocery item using natural language. For example, "we just bought 10 cartons of milk that expires in 6 months". If via text, just the text message will be sent to the Grocery Agent. If via voice, voice file will be downloaded then transcribed into text using OpenAI. Once Grocery agent receives the text, it will search the item in your grocery list in Asana. It will then check the item since it's bought, and update the quantity and expiry date accordingly. Once task is done, it will respond with the changes it made and insert a hyperlink to Asana if you want to see it. How to set up Set up Telegram bot via Botfather. See setup instructions here Setup OpenAI API for transcription services (Credits required) here Set up Openrouter account. See details here Set up Asana API using the account where you have your grocery list set in. See details here Customization Options You can have other custom fields you use to track other than expiry dates or quantity. For example, food type, date purchased etc. Requirements Asana account where you manage your grocery list Telegram bot Open AI account Open Router account
by Avkash Kakdiya
How it works This workflow automates the classification and routing of incoming Intercom conversations. When a new customer message arrives, it is analyzed by AI to determine category, sentiment, urgency, and tags. Based on this classification, the workflow creates tasks in ClickUp for Support or Product requests, or sends real-time alerts to Slack for Sales inquiries. Step-by-step Webhook Intake Triggered when Intercom sends a new conversation payload. Captures customer details, message content, and metadata. AI Classification Sends the conversation JSON to OpenAI (gpt-4o-mini) with a structured prompt. AI returns a JSON object with category (Support, Product, Sales, Other), sentiment, urgency, reasoning, and tags. Processing & Structuring A Code node parses the AI output and merges it with conversation details. Prepares formatted task fields such as title, description, customer info, and priority. Conditional Routing Support requests → Task created in ClickUp with urgency and tags. Product requests → Task created in ClickUp with structured details. Sales inquiries → Slack alert sent to the Sales channel with context and AI reasoning. Other → No task/action triggered. Benefits Automates Intercom ticket triage and routing in real time. Ensures consistent, AI-driven classification of all customer conversations. Reduces manual review time for Support, Product, and Sales teams. Creates structured tasks with enriched metadata for faster resolution. Keeps Sales teams instantly informed with Slack alerts for urgent leads.
by Yar Malik (Asfandyar)
Who’s it for This template is for users who want to combine the power of AI with Google Sheets for managing and calculating data quickly. It’s ideal for small businesses, data entry teams, and anyone who tracks lists, orders, or tasks in Google Sheets and needs AI-driven insights or calculations. How it works The workflow connects an AI agent with Google Sheets and a calculator tool. When a user sends a chat message, the AI interprets the request, retrieves or updates rows in the connected sheet, and performs calculations when needed. For example, it can read a list of orders from a sheet and calculate totals or averages instantly. It also supports creating, updating, and deleting rows from the sheet through natural language instructions. How to set up Copy the provided Google Sheet into your Google Drive. Connect your Google Sheets credentials in n8n. Add your OpenAI credentials for the AI agent. Deploy the workflow and start interacting with it by sending chat prompts. Requirements OpenAI account (for AI responses) Google Sheets account with a spreadsheet n8n instance with LangChain nodes enabled How to customize the workflow Change the spreadsheet fields (ID, Name, etc.) to match your own data structure. Modify the AI prompt to guide the agent’s tone or behavior. Extend the workflow by adding more Google Sheets operations or AI tools for advanced tasks.
by David Olusola
📧 Master Your First AI Email Agent with Smart Fallback! Welcome to your hands-on guide for building a resilient, intelligent email support system in n8n! This workflow is specifically designed as an educational tool to help you understand advanced AI automation concepts in a practical, easy-to-follow way. 🚀 What You'll Learn & Build: This powerful template enables you to create an automated email support agent that: Monitors Gmail** for new customer inquiries in real-time. Processes requests** using a primary AI model (Google Gemini) for efficiency. Intelligently falls back to a secondary AI model** (OpenAI GPT) if the primary model fails or for more complex queries, ensuring robust reliability. Generates personalized and helpful replies** automatically. Logs every interaction** meticulously to a Google Sheet for easy tracking and analysis. 💡 Why a Fallback Model is Game-Changing (and Why You Should Learn It): Unmatched Reliability (99.9% Uptime):** If one AI service experiences an outage or rate limits, your automation seamlessly switches to another, ensuring no customer email goes unanswered. Cost Optimization:** Leverage more affordable models (like Gemini) for standard queries, reserving premium models (like GPT) only when truly needed, significantly reducing your API costs. Superior Quality Assurance:** Get the best of both worlds – the speed of cost-effective models combined with the accuracy of more powerful ones for complex scenarios. Real-World Application:** This isn't just theory; it's a critical pattern for building resilient, production-ready AI systems. 🎓 Perfect for Beginners & Aspiring Automators: Simple Setup:** With drag-and-drop design and pre-built integrations, you can get this workflow running with minimal configuration. Just add your API keys! Clear Educational Value:** Learn core concepts like AI model orchestration strategies, customer service automation best practices, and multi-model AI implementation patterns. Immediate Results:** See your AI agent in action, responding to emails and logging data within minutes of setup. 🛠️ Getting Started Checklist: To use this workflow, you'll need: A Gmail account with API access enabled. A Google Sheets document created for logging. A Gemini API key (your primary AI model). An OpenAI API key (your fallback AI model). An n8n instance (cloud or desktop). Embark on your journey to building intelligent, resilient automation systems today!
by Intuz
This n8n template from Intuz provides a complete and automated solution for powerful cold outreach campaigns. It connects a Google Sheet of prospect data with Google Gemini to automatically generate highly personalized emails. By analyzing specific keywords and data points like company name, industry, or job title from your sheet, this automated workflow crafts unique, relevant messages that feel one-to-one, creating a complete system to dramatically improve your engagement and response rates. How it Works Manually writing personalized emails for a long list of leads is a significant bottleneck. This workflow eliminates that friction by creating an automated system that reads your lead list, understands the context, and writes compelling drafts for you. Scheduled Lead Processing:** On a schedule you define (e.g., daily), the workflow automatically activates to process your lead list. Fetches Your Lead List:** It connects to your designated Google Sheet and reads all the lead data you've prepared, such as names, companies, roles, and any custom notes or pain points. Intelligent Filtering:** The workflow is smart enough to know which leads have already been processed. Using an "If" node, it filters out any rows that already contain a generated email, ensuring it only works on new, untouched leads. AI-Driven Personalization (Google Gemini):** This is the core of the engine. For each new lead, it sends the relevant data to the Google Gemini Chat Model. The AI follows a custom prompt you define to draft a completely unique email, including a compelling subject line and a personalized body. Structured Data Output:** The workflow uses a Structured Output Parser to ensure the AI's response is always in a clean, predictable JSON format (e.g., {"subject": "...", "body": "..."}), making the data easy to handle in the next steps. Seamlessly Updates Your Spreadsheet:** Finally, the generated subject line and email body are written back into the correct row for that lead in your Google Sheet, ready for your team to copy, paste, and send. How to Use: Quick Start Guide 1. Import Workflow Template: Download the template’s JSON file and import it into your n8n instance via “File” > “Import from JSON.” 2. Configure Credentials: Google Gemini: Create and apply your API key credentials to the “Google Gemini Chat Model” node. Google Sheets: Set up and apply OAuth credentials for the Google account that owns your lead spreadsheet. Apply this credential to both the "Read Leads from Sheet" and "Update Sheet with Email" nodes. 3. Customize Nodes & Spreadsheet: Prepare Your Google Sheet:** Ensure your sheet has columns for lead data (e.g., FirstName, Company, Role) and empty columns to receive the output (e.g., GeneratedSubject, GeneratedEmail). Read Leads from Sheet:** Double-click this node and select your spreadsheet and sheet name from the list. If Node:** Update the condition to check your specific output column. For example, if your output column is named GeneratedEmail, the condition should check if {{$json.GeneratedEmail }} is empty. Basic LLM Chain Node:** This is the most important step. Edit the Template prompt to match your product, service, and desired tone. In the Template Variables section, make sure the values (e.g., {{ $('Read Leads from Sheet').item.json.FirstName }}) match the exact column names from your Google Sheet. Update Sheet with Email Node:** Select your spreadsheet and sheet name. Set the Lookup Column to a unique identifier for each lead (like their Email address). Then, map the output from the Prepare Data for Sheet node to the correct destination columns in your sheet. 4. Test & Activate: Test Run:** Click “Execute Workflow” to perform a test run. Check your Google Sheet to see if the first unprocessed lead was updated correctly with a new subject and body. Activate:** Once satisfied, toggle the workflow “Active” switch to enable it to run on your defined schedule. Requirements To use this workflow template, you will need: 1. n8n Instance: A running n8n instance (cloud or self-hosted). 2. Google Gemini Account: For generating the email content (requires a Google Gemini API Key from Google AI Studio). 3. Google Sheets Account: With a prepared spreadsheet containing your lead list and columns for the generated output. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started