Can Google Docs connect with Gmail?

Yes, Google Docs can connect with Gmail using n8n.io. With n8n, you can create workflows that automate tasks and transfer data between Google Docs and Gmail. Configure nodes for Google Docs and Gmail in the n8n interface, specifying actions and triggers to set up their connection.

Can I use Google Docs’s API with n8n?

Yes, with n8n, you can programmatically interact with Google Docs’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.

Can I use Gmail’s API with n8n?

Yes, with n8n, you can programmatically interact with Gmail’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.

Is n8n secure for integrating Google Docs and Gmail?

Yes, it is safe to use n8n to integrate Google Docs and Gmail. n8n offers various features to ensure the safe handling of your data. These include encrypted data transfers, secure credential storage, RBAC functionality, and compliance with industry-standard security practices (SOC2 compliant). For hosted plans, data is stored within the EU on servers located in Frankfurt, Germany. You can also host it on your own infrastructure for added control. Learn more about n8n’s security practices here.

How to get started with Google Docs and Gmail integration in n8n.io?

To start integrating Google Docs and Gmail in n8n, you have different options depending on how you intend to use it: n8n Cloud: hosted solution, no need to install anything. Self-host: recommended method for full-control or customized use cases. Unlike other platforms that charge per operation, step, or task, n8n charges only for full workflow executions. This approach guarantees predictable costs and scalability, no matter the complexity or volume of your workflows.

Google Docs and Gmail: Automate Workflows with n8n

+10

Automate Social Media Content with AI for Instagram, Facebook, LinkedIn & X

AI Social Media Content Automation – n8n Workflow This workflow is built for creators, solopreneurs, SaaS founders, and agencies looking to automate their social media content process from idea to publication. It combines the power of OpenAI, Google Sheets, and official APIs for Instagram, Facebook, X (Twitter), and LinkedIn to deliver fully automated, brand-consistent social media posts — including text, images, hashtags, CTAs, and scheduling. No more switching tools, rewriting content, or forgetting to post. Just set it up once and let your brand grow automatically. 🔧 What the Workflow Does Generates platform-specific post ideas based on your brand tone. Selects the best idea (or lets you manually input one). Writes tailored posts for Instagram, Facebook, X, and LinkedIn. Auto-generates platform-specific visuals using OpenAI (DALL·E) and uploads to Cloudinary. Publishes content directly using official platform APIs. Logs all actions to Google Sheets and optionally sends a summary email via Gmail. ⚙️ How It Works Trigger the workflow manually, on a schedule, or from a chatbot. AI generates multiple post ideas and filters the best one. Based on the selected idea, it generates full posts for each platform. Custom visuals are created using OpenAI and uploaded to Cloudinary. Final post content is merged and sent to Instagram, Facebook, X, and LinkedIn. Logs and optional reports are created in Google Sheets and Gmail. 🛠️ Setup Steps Set up your accounts and credentials: OpenAI, Cloudinary, Gmail, Meta, LinkedIn, X, and Google Sheets. Import the workflow and subworkflow (Get Brand Brief) into n8n. Replace all placeholders (sheet IDs, access tokens, profile/page IDs, brand brief URLs). Optionally personalize prompts and output templates to match your brand voice. Setup time: ~30–45 minutes (including credentials and testing). Detailed configuration notes are included in sticky nodes throughout the workflow. 📦 Included in Your Package JSON workflow file (main flow + brand brief subflow) Google Sheets templates for history logging Setup documentation (Markdown & PDF) Placeholder reference sheet

+9

✨🩷Automated Social Media Content Publishing Factory + System Prompt Composition

Social Media Content Publishing Factory for Streamlined Content Creation Across Platforms Who is this for? This workflow is designed for content creators, social media managers, and marketing teams who need to efficiently create and publish content across multiple social media platforms. It's perfect for businesses looking to maintain a consistent presence across X (Twitter), Instagram, Facebook, LinkedIn, Threads, and YouTube Shorts without spending hours crafting platform-specific content manually. What problem is this workflow solving? Creating tailored content for different social media platforms is time-consuming and requires understanding each platform's unique requirements and audience expectations. This workflow solves the challenge of: Maintaining consistent messaging across platforms while respecting platform-specific formats Generating optimized content that follows best practices for each platform Creating accompanying visuals without graphic design skills Streamlining the approval process before publishing Reducing the time spent on repetitive content creation tasks What this workflow does This automated content factory takes your content idea and transforms it into platform-optimized posts for all major social media channels. The workflow: Accepts your content idea or topic through a chat interface Leverages AI to generate tailored content for each platform (X/Twitter, Instagram, Facebook, LinkedIn, Threads, YouTube Shorts) Creates appropriate images using AI image generation Sends content for approval via email before publishing Publishes approved content to selected platforms Maintains chat memory to improve future content generation Setup Connect your social media platform credentials (X/Twitter, Instagram, Facebook, LinkedIn) Set up your email account for the approval process Configure your OpenAI API key for AI content generation Update the image generation service credentials (Pollinations.ai is used by default) Customize the system prompts and schemas in the Google Docs nodes with your brand voice and content requirements How to customize this workflow to your needs Modify the system prompts in the Google Docs nodes to match your brand voice and content strategy Adjust the social media schemas to include specific fields relevant to your content Update the approval process to include additional stakeholders if needed Add or remove social media platforms based on your marketing strategy Customize the image generation prompts to better match your visual branding Integrate with your existing content calendar or CRM systems This workflow eliminates the need to manually craft different versions of the same content for each platform, saving hours of work while ensuring your social media presence remains consistent and optimized for maximum engagement.

+2

Automate client onboarding with Asana, Google Docs, Gmail, Slack and Sheets

📊 Description Automate short-term trading research by generating high-quality trade ideas using MCP (Market Context Protocol) signals and AI-powered analysis. 📈🤖 This workflow evaluates market context, catalysts, momentum, and risk factors to produce structured trade ideas with clear reasoning, confidence scores, and execution notes. Designed for fast-moving markets, it helps traders and analysts spot actionable opportunities consistently—without manual screening or emotional bias. Perfect for systematic traders, research teams, and AI-driven trading desks. ⚡📊 🔁 What This Template Does 1️⃣ Ingests market context and asset data from MCP inputs. 📥 2️⃣ Normalizes symbols, sectors, and time horizons for analysis. 🧾 3️⃣ Evaluates short-term momentum and catalyst strength. 🚀 4️⃣ Analyzes risk, volatility, and downside exposure. ⚠️ 5️⃣ Uses AI to generate a structured trade thesis. 🤖 6️⃣ Assigns a confidence score and risk level to each idea. 📊 7️⃣ Produces clear entry logic, rationale, and trade direction. 🧠 8️⃣ Filters out low-quality or low-conviction setups. 🚫 9️⃣ Outputs clean JSON-ready trade ideas for downstream systems. 🔁 ⭐ Key Benefits ✅ Automates short-term trade idea generation ✅ Reduces emotional bias with AI-based scoring ✅ Combines market context, catalysts, and momentum ✅ Produces structured, repeatable trade logic ✅ Saves hours of manual chart and news analysis ✅ Ideal for fast-paced trading environments 🧩 Features MCP (Market Context Protocol) data ingestion AI-powered trade thesis generation Confidence and risk scoring logic Short-term momentum and catalyst analysis Strict structured output for automation reliability Easy integration into dashboards or execution systems 🔐 Requirements MCP-compatible market data source OpenAI API credentials (GPT-4o or GPT-4o-mini recommended) n8n instance with AI nodes enabled Defined schema for trade idea output 🎯 Target Audience Short-term and swing traders Quant and discretionary trading teams Market research analysts Fintech platforms generating trade signals Automation engineers building trading workflows

Automate Full Agreement Lifecycle with JotForm, Approvals, Signwell E-Signatures & Tracking

Client Form → Draft → Approve → Sign → Deliver, fully automated This workflow automates the entire agreement lifecycle from client form submission to signed document delivery. It generates personalized agreements from templates, manages internal approvals, orchestrates e-signatures via Signwell, and delivers fully executed documents with complete audit trails in n8n Data Tables. Good to know Handles client data collection via JotForm with custom field mapping Automatically populates Google Doc templates with client-specific details Internal approval workflow with email-based confirmation Signwell integration for embedded e-signatures - test mode enabled by default - disable for legally binding documents Complete lifecycle tracking in n8n Data Tables (draft → approval → sent → signed) Auto-cleanup: removes documents from Signwell after completion to save storage Who's it for Service businesses, consultants, agencies, and freelancers who send agreements to clients regularly. Perfect for anyone wanting to avoid other costly e-signature platforms with limited API and automation capabilities. Signwell has an affordable entry level tier with generous API limits. If you're looking to eliminate manual document preparation, have an approval workflow, and track signatures while maintaining professional client communication, then this solution is a good fit. How it works Phase 1: Draft Creation JotForm trigger captures client submission (company name, address, contact details, position) Standardizes form data and duplicates Google Doc template with custom filename Replaces template variables with client information (company name, address, full name, position, dates) Creates clean document URL and logs initial record to Data Tables Emails internal team with draft review link and client details Phase 2: Approval & Preparation Gmail monitors inbox for "Approved" reply email Fetches agreement record from Data Tables and marks as approved Downloads Google Doc as PDF and uploads to Drive folder Grants temporary public sharing access (required for Signwell file import) Creates Signwell document with embedded signature fields and signing URL Emails client with personalized signing link Revokes public sharing access for security and updates Data Tables with Signwell details Phase 3: Signature & Delivery Gmail monitors for Signwell completion notification Extracts signed document download link from notification email Downloads fully executed PDF from Signwell Uploads to "Final Versions" folder in Google Drive Updates Data Tables with completion status and final document URLs Sends confirmation email to client with signed PDF attached Deletes document from Signwell to free up storage Requirements JotForm account (free tier works) Gmail account with OAuth2 access Google Drive account (OAuth2) Google Docs account (OAuth2) with a draft Agreement template Signwell account with API key n8n Data Tables (built-in, no external service needed) Google Drive folders: "Services Agreements - Drafts" and "Services Agreements - Final Versions" How to set up Add credentials: JotForm API, Gmail OAuth2, Google Drive OAuth2, Google Docs OAuth2, Signwell API key Create JotForm: Build form with fields: Company Name, Company Address (address field), Full Name (name field), Your Position/Job Title, Email In "JotForm Trigger" node: select your form Create Google Doc template: Add variables {{clientCompanyName}}, {{clientFullName}}, {{clientNamePosition}}, {{clientCompanyAddress}}, {{agreementDate1}}, {{agreementDate2}} In "Copy and Rename File" node: select your template document and update folder ID to your "Drafts" folder Create Data Table: Name it "Services Agreements" with columns: documentFileName, clientEmail, clientFullName, clientNamePosition, clientCompanyName, clientCompanyAddress, documentUrl, approvalStatus, sentDocumentPdfUrl, sentDate, signwellUrl, signwellDocID, docSigned, finalExecutedDocGDrive, finalExecutedDocSignwellUrl In "Insert Row" and all "Get/Update Row" nodes: select your Data Table Create Gmail labels: "_AGREEMENTS" with 2 nested (sublabels) Agreement-Approvals" and "Agreement-Completed" for filtering In "Check for Email Approval" node: select your approval label and update internal email address In "Check Email for Completed Notification" node: select your completed label In "Create Document in Signwell" node: update API key and adjust signature field coordinates for your document Set Signwell to live mode: Change "test_mode": true to "test_mode": false when ready for production Activate workflow Customizing this workflow Change template variables: Edit "Update New File" node to add/remove fields (e.g., pricing, terms, scope of work) Modify approval email: Edit "Share Email Draft" node to change recipient, subject line, or message format Adjust Signwell fields: Edit "Create Document in Signwell" node to change signature/date field positions (x, y coordinates) to match your agreement template, and add any other fields you'd like Add approval deadline: Add Wait node with timeout after "Share Email Draft" to auto-remind for pending approvals Multi-signer support: Modify "Create Document in Signwell" recipients array to add multiple signers (e.g., both parties) Change storage folders: Update folder IDs in "Upload PDF File" and "Upload Completed Doc" nodes Add Slack notifications: Add Slack nodes after key milestones (draft created, approved, signed) Custom client messaging: Edit "Send Prepared Agreement to Client" and "Send Client Completed Agreement PDF" nodes for personalized communication Add reminder logic: Insert Wait + Send Email nodes between signing and completion to remind client if not signed within X days Quick Troubleshooting JotForm not triggering: Verify webhook is active in JotForm settings and form ID matches "JotForm Trigger" node Template variables not replacing: Check variable names in template doc exactly match {{variableName}} format (case-sensitive) Wrong internal email for approval: Update email address in "Share Email Draft" node to your own email Approval email not detected: Confirm Gmail label "Agreement-Approvals" exists and reply contains exact word "Approved" Signwell document creation fails: Verify PDF has public sharing enabled before API call AND Signwell API key is valid in "Create Document in Signwell" node Signature fields in wrong position: Adjust x/y coordinates in "Create Document in Signwell" node (test in Signwell UI first to find correct pixel positions) Completed document not downloading: Check Signwell completion email format - Code node extracts link via regex pattern Data Tables errors: Ensure documentFileName exactly matches between "Insert Row" and "Get/Update Row" operations Client emails not sending: Re-authorize Gmail OAuth2 credentials and verify sender name/address in Gmail nodes Drive folder not found: Update folder IDs in "Copy and Rename File", "Upload PDF File", and "Upload Completed Doc" nodes to your own folder IDs Signwell deletion fails: Verify signwellDocID was correctly stored in Data Tables before deletion (check "Update Row - Additional Doc Details" output) 401/403 API errors: Re-authorize all OAuth2 credentials (Gmail, Google Drive, Google Docs) Test mode documents: Change "test_mode": true to "test_mode": false in "Create Document in Signwell" node for production signatures Sample Outputs Agreement Drafts and Final folders/files in Google Drive File References Agreement Template (sample) Final Agreement Signed (sample)

Automated New Hire Appointment Letters with Google Docs, HR Approval & Gmail

This n8n template demonstrates automating an appointment letter creation process using a template and then having the HR approve before emailing the appointment letter to the candidate. How it works Create an appointment letter template. e.g "Appointment Letter.doc" on Google Drive Form Submission node - Create a form trigger with the required fields that need to be capture as part of the appointment letter. Eg. Candidate Name, Position offered, Salary, Date of Joining, Candidate email, etc. Google Drive Copy node - Once the form is filled, it creates a candidate copy of the appointment letter by appending the candidate name to appointment letter. e.g. "Appointment Letter - <candidate name>.doc". This will be stored on the Google Drive Google Doc Update node - Fill the placeholders in the appointment letter with the candidate specific details such as Candidate Name, Position offered, Salary, Date of Joining, etc. Google Drive Download node - Create a PDF version of the candidate's appointment letter. e.g. "Appointment Letter - <Candidate Name>.pdf" and download it to Google Drive Google Drive Upload node - Upload the PDF to Google Drive Gmail Send Message node - Send an email to the HR requesting to review the candidate's appointment letter and 'Approve' or 'Reject' the appointment letter. This is the Human-In-The-Loop step If Node (for routing) - will return "true" if HR approves and "false" if HR rejects If HR approves, go to Step 9 and Step 10 Google Drive Download node - Get the PDF file Gmail Send Message node - Send an email to the candidate with the appointment letter (PDF) as the attachment How to use The Form trigger node is used as an example but feel free to replace this with other triggers such as Google Sheet Create an Appointment Letter Google document with the follwing fields - Date, Candidate Name, Position Name, Fixed CTC, Joining Date and To be signed by Date. See sample letter format below: <Appointment Letter.doc> (Google Document) Appointment Letter [Date] Dear [Candidate Name], Congratulations! We are pleased to offer you the [Position Name] at ABC Company. Fixed CTC - [Fixed CTC] Joining Date - [Joining Date] Requirements Google drive for upload and downloading the file Gmail for sending emails Sign the letter by - [To be signed by Date] Signature

Daily Email Digest with GPT-4 Summaries to Google Docs

A Customizable n8n Automation That Turns Your Inbox Into A Daily Digest. The goal of this workflow is to offer a highly customizable foundation that users can tailor to fit their specific platform and setup. While the current version uses Gmail, it can easily be adapted to work with other providers by replacing the email node with alternatives such as IMAP Email Trigger, Microsoft Outlook, or any compatible Email node. This workflow can also be extended to work with platforms like Telegram, WhatsApp, or any service that supports bots and n8n integration. The core objective is to generate scheduled email summaries whether it’s the most recent email, emails from a specific sender, or all emails received within a day. I built this workflow as a flexible building block for anyone looking to develop a more advanced email agent. It’s designed to reduce the mental load of reviewing emails each day by automatically delivering a summarized version of your inbox. Currently, the summary is saved to Google Docs, chosen for its simplicity and accessibility. However, users can easily modify this to integrate with other document management systems or destinations. I plan to continue updating and expanding this workflow to better serve the needs of users. If you have suggestions, ideas, or feedback, I’d love to hear them your input helps make this tool even more useful. Workflow Components Schedule Node – Triggers the workflow daily at a specified time. Gmail: Get Messages Node – Retrieves the latest email. Can be changed for any amount of emails. Limit Node – Ensures only one or any number emails is processed at a time. If Node – Checks if any emails were retrieved. Code Node – Cleans and formats the email content. Code Node – Provides a fallback message if no emails are found. OpenAI Summary Node – Summarizes the email using CharGPT. Create Google Doc Node – Creates a new Google Document for the summary. Update Google Doc Node – Inserts the summarized content into the document. Expanding The Workflow This workflow is fully modular and easy to extend. To send summaries via Telegram, Slack, or any other emails simply add the respective node after the summary is generated and connect your bot or webhook credentials. To use Outlook instead of Gmail, just swap the email input node with the Microsoft Outlook node or an IMAP Email Trigger, depending on your preferred setup. Need Help? Have Questions? For consulting and support, or if you have questions, please feel free to connect with me on LinkedIn or via email.

+3

🧠 Empower Your AI Chatbot with Long-Term Memory and Dynamic Tool Routing

Empower Your AI Chatbot with Long-Term Memory and Dynamic Tool Routing This n8n workflow equips your AI agent with long-term memory and a dynamic tools router, enabling it to provide intelligent, context-aware responses while managing tasks across multiple tools. By combining persistent memory and modular task routing, this workflow makes your AI smarter, more efficient, and highly adaptable. 👥 Who Is This For? AI Developers & Automation Enthusiasts: Integrate advanced AI features like long-term memory and task routing without coding expertise. Businesses & Teams: Automate tasks while maintaining personalized, context-aware interactions. Customer Support Teams: Improve user experience with chatbots that remember past interactions. Marketers & Content Creators: Streamline communication across platforms like Gmail and Telegram. AI Researchers: Experiment with persistent memory and multi-tool integration. 🚀 What Problem Does This Solve? This workflow simplifies the creation of intelligent AI systems that retain memory, manage tasks dynamically, and automate notifications across tools like Gmail and Telegram—saving time and improving efficiency. 🛠️ What This Workflow Does Save & Retrieve Memories**: Uses Google Docs for long-term storage to recall past interactions or user preferences. Dynamic Task Routing**: Routes tasks to the right tools (e.g., saving/retrieving memories or sending notifications). AI-Powered Context Understanding**: Combines OpenAI GPT-based short-term memory with long-term memory for smarter responses. Multi-Channel Notifications**: Sends updates via Gmail or Telegram. 🔧 Setup API Credentials: Connect to OpenAI (AI processing), Google Docs (memory storage), Gmail/Telegram (notifications). Customize Parameters: Adjust the AI agent's system message for your use case. Define task-routing rules in the tools router node. Test & Deploy: Verify memory saving/retrieval, task routing, and notification delivery. 💡 How to Customize Modify the system message in the OpenAI node to tailor your agent’s behavior. Add or adjust routing rules for additional tools. Update notification settings to match your communication preferences.

+9

Handle clinic WhatsApp support with GPT-4o-mini, Pinecone RAG and Gmail alerts

🏥 Clinic WhatsApp Customer Service Bot This workflow automates patient communication for medical clinics using the WhatsApp Business API. It supports appointment booking, rescheduling, service inquiries, follow-ups, and document submissions. The workflow includes AI capabilities, appointment management, human escalation logic, memory storage, and CRM synchronization. Good to know Supports text, voice notes, images, and document uploads. Uses an AI agent powered by GPT-4o-mini with retrieval-augmented generation for accurate answers. Includes sentiment and frustration detection to trigger human takeover. Conversation history and lead details are stored for context and follow-up. Appointment booking includes slot validation to reduce errors and conflicts. How it works The workflow receives WhatsApp messages through a webhook connection. The AI agent processes the message and identifies the intent: 📅 Appointment booking or rescheduling ❓ Service or doctor inquiry 📎 Document submission (e.g., lab results, insurance) 🤝 Human support request If the request is informational, the AI responds using GPT-4o-mini with RAG from Pinecone to ensure clinic-specific accuracy. If the request relates to booking, the workflow: Checks availability in Data Tables Validates slot selection Confirms, updates, or cancels the appointment If the user is confused, frustrated, or explicitly asks for a human, automation is paused and a staff member is notified. Voice messages are transcribed using Whisper API and images are processed using Vision API. All interactions are logged and synced to Google Sheets for CRM tracking. Requirements WhatsApp Business API access with active credentials OpenAI API key for GPT-4o-mini, Whisper, and Vision models Pinecone account for vector storage Google Sheets and Gmail for logging and notifications n8n instance (Cloud or self-hosted) Data Tables enabled for memory, appointments, and lead management

+2

Generate Comprehensive Business Analysis Reports with Gemini AI & Firecrawl

This workflow automates business intelligence. Submit one URL, and it scrapes the website, uses AI to perform a comprehensive analysis, and generates a professional report in Google Doc and PDF format. It's perfect for agencies, freelancers, and consultants who need to streamline client research or competitive analysis. How It Works The workflow is triggered by a form input, where you provide a single website URL. Scrape: It uses Firecrawl to scrape the sitemap and get the full content from the target website. Analyze: The main workflow calls a Tools Workflow (included below) which uses Google Gemini and Perplexity AI agents to analyze the scraped content and extract key business information. Generate & Deliver: All the extracted data is formatted and used to populate a template in Google Docs. The final report is saved to Google Drive and delivered via Gmail. What It Generates The final report is a comprehensive business analysis, including: Business Overview: A full company description. Target Audience Personas: Defines the demographic and psychographic profiles of ideal customers. Brand & UVP: Extracts the brand's personality matrix and its Unique Value Proposition (UVP). Customer Journey: Maps the typical customer journey from Awareness to Loyalty. Required Tools This workflow requires n8n and API keys/credentials for the following services: Firecrawl (for scraping) Perplexity (for AI analysis) Google Gemini (for AI analysis) Google Services (for Docs, Drive, and Gmail) ⚠️ Required: Tools Workflow This workflow will not work without its "Tools" sub-workflow. Please create a new, separate workflow in n8n, name it (e.g., "Business Analysis Tools"), and paste the following code into it. { "name": "Business Analysis Workflow Tools", "nodes": [ { "parameters": { "workflowInputs": { "values": [ { "name": "function" }, { "name": "keyword" }, { "name": "url" }, { "name": "location_code" }, { "name": "language_code" } ] } }, "type": "n8n-nodes-base.executeWorkflowTrigger", "typeVersion": 1.1, "position": [ -448, 800 ], "id": "e79e0605-f9ac-4166-894c-e5aa9bd75bac", "name": "When Executed by Another Workflow" }, { "parameters": { "rules": { "values": [ { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 2 }, "conditions": [ { "id": "8d7d3035-3a57-47ee-b1d1-dd7bfcab9114", "leftValue": "serp_search", "rightValue": "={{ $json.function }}", "operator": { "type": "string", "operation": "equals", "name": "filter.operator.equals" } } ], "combinator": "and" }, "renameOutput": true, "outputKey": "serp_search" }, { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 2 }, "conditions": [ { "id": "bb2c23eb-862d-4582-961e-5a8d8338842c", "leftValue": "ai_mode", "rightValue": "={{ $json.function }}", "operator": { "type": "string", "operation": "equals", "name": "filter.operator.equals" } } ], "combinator": "and" }, "renameOutput": true, "outputKey": "ai_mode" }, { "conditions": { "options": { "caseSensitive": true, "leftValue": "", "typeValidation": "strict", "version": 2 }, "conditions": [ { "id": "4603eee1-3888-4e32-b3b9-4f299dfd6df3", "leftValue": "internal_links", "rightValue": "={{ $json.function }}", "operator": { "type": "string", "operation": "equals", "name": "filter.operator.equals" } } ], "combinator": "and" }, "renameOutput": true, "outputKey": "internal_links" } ] }, "options": {} }, "type": "n8n-nodes-base.switch", "typeVersion": 3.2, "position": [ -208, 784 ], "id": "72c37890-7054-48d8-a508-47ed981551d6", "name": "Switch" }, { "parameters": { "method": "POST", "url": "https://api.dataforseo.com/v3/serp/google/organic/live/advanced", "authentication": "genericCredentialType", "genericAuthType": "httpBasicAuth", "sendBody": true, "specifyBody": "json", "jsonBody": "=[\n {\n \"keyword\": \"{{ $json.keyword.replace(/[:'\"\\\\/]/g, '') }}\",\n \"location_code\": {{ $json.location_code }},\n \"language_code\": \"{{ $json.language_code }}\",\n \"depth\": 10,\n \"group_organic_results\": true,\n \"load_async_ai_overview\": true,\n \"people_also_ask_click_depth\": 1\n }\n]", "options": { "redirect": { "redirect": { "followRedirects": false } } } }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.2, "position": [ 384, 512 ], "id": "6203f722-b590-4a25-8953-8753a44eb3cb", "name": "SERP Google", "credentials": { "httpBasicAuth": { "id": "n5o00CCWcmHFeI1p", "name": "DataForSEO" } } }, { "parameters": { "content": "## SERP Google", "height": 272, "width": 688, "color": 4 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 288, 432 ], "id": "81593217-034f-466d-9055-03ab6b2d7d08", "name": "Sticky Note3" }, { "parameters": { "assignments": { "assignments": [ { "id": "97ef7ee0-bc97-4089-bc37-c0545e28ed9f", "name": "platform", "value": "={{ $json.tasks[0].data.se }}", "type": "string" }, { "id": "9299e6bb-bd36-4691-bc6c-655795a6226e", "name": "type", "value": "={{ $json.tasks[0].data.se_type }}", "type": "string" }, { "id": "2dc26c8e-713c-4a59-a353-9d9259109e74", "name": "keyword", "value": "={{ $json.tasks[0].data.keyword }}", "type": "string" }, { "id": "84c9be31-8f1d-4a67-9d13-897910d7ec18", "name": "results", "value": "={{ $json.tasks[0].result }}", "type": "array" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ 592, 512 ], "id": "a916551a-009b-403f-b02e-3951d54d2407", "name": "Prepare SERP output" }, { "parameters": { "content": "# Google Organic Search API\n\nThis API lets you retrieve real-time Google search results with a wide range of parameters and custom settings. \nThe response includes structured data for all available SERP features, along with a direct URL to the search results page. \n\n👉 Documentation\n", "height": 272, "width": 496, "color": 4 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 976, 432 ], "id": "87672b01-7477-4b43-9ccc-523ef8d91c64", "name": "Sticky Note17" }, { "parameters": { "method": "POST", "url": "https://api.dataforseo.com/v3/serp/google/ai_mode/live/advanced", "authentication": "genericCredentialType", "genericAuthType": "httpBasicAuth", "sendBody": true, "specifyBody": "json", "jsonBody": "=[\n {\n \"keyword\": \"{{ $json.keyword }}\",\n \"location_code\": {{ $json.location_code }},\n \"language_code\": \"{{ $json.language_code }}\",\n \"device\": \"mobile\",\n \"os\": \"android\"\n }\n]", "options": { "redirect": { "redirect": {} } } }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.2, "position": [ 384, 800 ], "id": "fb0001c4-d590-45b3-a3d0-cac7174741d3", "name": "AI Mode", "credentials": { "httpBasicAuth": { "id": "n5o00CCWcmHFeI1p", "name": "DataForSEO" } } }, { "parameters": { "content": "## AI Mode", "height": 272, "width": 512, "color": 6 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 288, 720 ], "id": "2cea3312-31f8-4ff0-b385-5b76b836274c", "name": "Sticky Note11" }, { "parameters": { "assignments": { "assignments": [ { "id": "b822f458-ebf2-4a37-9906-b6a2606e6106", "name": "keyword", "value": "={{ $json.tasks[0].data.keyword }}", "type": "string" }, { "id": "10484675-b107-4157-bc7e-b942d8cdb5d2", "name": "result", "value": "={{ $json.tasks[0].result[0].items }}", "type": "array" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ 592, 800 ], "id": "6b1e7239-ee2b-4457-8acb-17ce87415729", "name": "Prepare AI Mode Output" }, { "parameters": { "content": "# Google AI Mode API\n\nThis API provides AI-generated search result summaries and insights from Google. \nIt returns detailed explanations, overviews, and related information based on search queries, with parameters to customize the AI overview. \n\n👉 Documentation\n", "height": 272, "width": 496, "color": 6 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 800, 720 ], "id": "d761dc57-e35d-4052-a360-71170a155f7b", "name": "Sticky Note18" }, { "parameters": { "content": "## Input", "height": 384, "width": 544, "color": 7 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ -528, 672 ], "id": "db90385e-f921-4a9c-89f3-53fc5825b207", "name": "Sticky Note" }, { "parameters": { "assignments": { "assignments": [ { "id": "b865f4a0-b4c3-4dde-bf18-3da933ab21af", "name": "platform", "value": "={{ $json.platform }}", "type": "string" }, { "id": "476e07ca-ccf6-43d4-acb4-4cc905464314", "name": "type", "value": "={{ $json.type }}", "type": "string" }, { "id": "f1a14eb8-9f10-4198-bbc7-17091532b38e", "name": "keyword", "value": "={{ $json.keyword }}", "type": "string" }, { "id": "181791a0-1d88-481c-8d98-a86242bb2135", "name": "results", "value": "={{ $json.results[0].items }}", "type": "array" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ 800, 512 ], "id": "83fef061-5e0b-417c-b1f6-d34eb712fac6", "name": "Sort Results" }, { "parameters": { "content": "## Internal Links", "height": 272, "width": 272, "color": 5 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 288, 1024 ], "id": "9246601a-f133-4ca3-aac8-989cb45e6cd2", "name": "Sticky Note7" }, { "parameters": { "method": "POST", "url": "https://api.firecrawl.dev/v2/map", "sendHeaders": true, "headerParameters": { "parameters": [ { "name": "Authorization", "value": "Bearer your-firecrawl-apikey" } ] }, "sendBody": true, "specifyBody": "json", "jsonBody": "={\n \"url\": \"https://{{ $json.url }}\",\n \"limit\": 400,\n \"includeSubdomains\": false,\n \"sitemap\": \"include\"\n }", "options": {} }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.2, "position": [ 368, 1104 ], "id": "fd6a33ae-6fb3-4331-ab6a-994048659116", "name": "Get Internal Links" }, { "parameters": { "content": "# Firecrawl Map API\n\nThis endpoint maps a website from a single URL and returns the list of discovered URLs (titles and descriptions when available) — extremely fast and useful for selecting which pages to scrape or for quickly enumerating site links. (Firecrawl)\n\nIt supports a search parameter to find relevant pages inside a site, location/languages options to emulate country/language (uses proxies when available), and SDK + cURL examples in the docs,\n\n👉 Documentation\n\n[1]: https://docs.firecrawl.dev/features/map \"Map | Firecrawl\"\n", "height": 272, "width": 624, "color": 5 }, "type": "n8n-nodes-base.stickyNote", "typeVersion": 1, "position": [ 560, 1024 ], "id": "08457204-93ff-4586-a76e-03907118be3c", "name": "Sticky Note24" } ], "pinData": { "When Executed by Another Workflow": [ { "json": { "function": "serp_search", "keyword": "villanyszerelő Largo Florida", "url": null, "location_code": 2840, "language_code": "hu" } } ] }, "connections": { "When Executed by Another Workflow": { "main": [ [ { "node": "Switch", "type": "main", "index": 0 } ] ] }, "Switch": { "main": [ [ { "node": "SERP Google", "type": "main", "index": 0 } ], [ { "node": "AI Mode", "type": "main", "index": 0 } ], [ { "node": "Get Internal Links", "type": "main", "index": 0 } ] ] }, "SERP Google": { "main": [ [ { "node": "Prepare SERP output", "type": "main", "index": 0 } ] ] }, "AI Mode": { "main": [ [ { "node": "Prepare AI Mode Output", "type": "main", "index": 0 } ] ] }, "Prepare SERP output": { "main": [ [ { "node": "Sort Results", "type": "main", "index": 0 } ] ] }, "Sort Results": { "main": [ [] ] } }, "active": false, "settings": { "executionOrder": "v1" }, "versionId": "6fce16d1-aa28-4939-9c2d-930d11c1e17f", "meta": { "instanceId": "1ee7b11b3a4bb285563e32fdddf3fbac26379ada529b942ee7cda230735046a1" }, "id": "VjpOW2V2aNV9HpQJ", "tags": [] } `

+43

Explore n8n Nodes in a Visual Reference Library

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.

+9

AI Email Auto-Responder System- AI RAG Agent for Email Inbox

AI Email Auto-Responder – Smart Client Reply Automation with RAG This workflow is built for individuals, teams, and businesses that receive regular inquiries via email and want to automate responses in a way that’s intelligent, brand-aligned, and always up to date. Its core purpose is to generate high-quality, professional email replies using internal company data, brand voice, and semantic search — fully automated through Gmail, Pinecone, and OpenAI. The system is divided into three steps. First, it allows you to index your internal knowledge base (Docs, Sheets, PDFs) with embeddings. Second, it injects a consistent brand brief into every interaction to ensure tone and positioning. Finally, the main flow listens for incoming emails, understands the user query, retrieves all needed data, and writes a full HTML reply — sending it directly to the original thread via Gmail. This solution is ideal for support teams, solopreneurs, B2B service providers, or anyone looking to scale high-quality client communication without scaling manual work. It can be extended to handle multilingual queries, intent routing, or CRM logging. How it works When a new email arrives in Gmail, the workflow checks whether it's a valid client inquiry. If so, it: Extracts the subject and message content Sends the message through OpenAI to understand the question Queries a Pinecone vector database (populated via a separate embedding workflow) to find relevant internal knowledge Loads a brand brief from a Google Doc or Notion block Combines retrieved data and brand context to generate a clear, structured HTML reply using OpenAI Sends the reply via Gmail and logs the message This process ensures every reply is relevant, accurate, and consistent with your brand — and takes under 10 seconds. Set up steps Getting started takes about 30–60 minutes. Create three workflows: one for embedding documents (Step 1), one sub-workflow for the brand brief (Step 2), and one main responder flow (Step 3) Connect the following APIs: Gmail (OAuth2), OpenAI, Pinecone, Google Drive, and optionally Notion Replace all placeholders: folder ID in Google Drive, Pinecone index and namespace, your brand brief URL or doc ID, and Gmail credentials Test your embedding workflow by uploading a document and verifying its presence in Pinecone Trigger the responder by sending an email and reviewing the AI’s reply Detailed setup instructions are stored in sticky notes within each workflow to guide you through configuration.

Transform Meeting Notes into Action Items with Gemini & Google Workspace

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ❓ What Problem Does It Solve? Manual transcription and action planning from meeting notes is often error-prone, time-consuming, and inconsistent. Important tasks, decisions, or deadlines can be overlooked or delayed. This workflow solves these pain points by automatically analyzing notes using AI and turning them into actionable, structured data. It drastically reduces follow-up delays, miscommunications, and administrative effort, letting teams focus on execution instead. 💡 Why Use Google Meet Automation? Save Hours of Manual Work:** Automatically transform raw meeting notes into structured tasks and emails without lifting a finger. Ensure Accurate Follow-up:** Never miss important action items or decisions buried in text; everything is extracted and assigned clearly. Improve Team Collaboration:** Instantly distribute meeting summaries and next steps to attendees, keeping everyone aligned. Leverage Advanced AI:** Utilize Google Gemini’s powerful natural language processing tailored specifically for meetings. Fully End-to-End Automated:** From receiving notes to task creation and email dispatch — your post-meeting workflow is completely hands-free. ⚡ Who Is This For? Project Managers:** Streamline task delegation and keep project timelines on track. Team Leads:** Quickly communicate key takeaways and follow-ups to team members. Sales and Account Teams:** Document client meetings efficiently and automate follow-up outreach. Remote Teams:** Ensure clarity and continuity after virtual meetings. Executives:** Get concise summaries and important decision logs automatically. 🔧 What This Workflow Does ⏱ Trigger: Activated via a POST webhook receiving meeting notes, title, attendees, date, and duration. 📎 Step 2: Validates inputs; if missing required fields, sends an error response. 🔍 Step 3: Extracts and formats meeting data into structured variables for processing. 🤖 Step 4: Sends meeting notes to Google Gemini AI for advanced analysis to identify action items, decisions, summaries, follow-ups, and dates. 💌 Step 5: Splits AI responses to create Google Tasks from action items and send personalized follow-up emails via Gmail. 🗂 Step 6: Generates a Google Docs meeting summary document and finally returns a success response with all processed results. 🔐 Setup Instructions Import the provided Google Meet Automation.json file into your n8n instance. use Payload example Set up credentials for: Google OAuth2 API (Google Tasks, Google Docs) Gmail OAuth2 API for sending emails Google Palm API (for Google Gemini AI access) Customize workflow parameters: Webhook URL and access permissions Google Tasks project or folders if applicable Email templates if desired (subject line, branding) Update any API endpoints or credential references to match your account setup. Thoroughly test with sample meeting note payloads to ensure smooth execution. 🧩 Pre-Requirements Active n8n instance (Cloud or Self-hosted) Google Cloud Platform project with: Google Tasks API enabled Google Docs API enabled Gmail API enabled Google Palm API access (Google Gemini AI) Valid OAuth2 credentials configured in n8n for above services API quota and permissions for sending emails, creating docs, and tasks 🛠️ Customize It Further Integrate with calendar apps (Google Calendar, Outlook) to auto-schedule next meetings. Add Slack or Microsoft Teams notifications for real-time alerts. Extend AI prompt for deeper insights like sentiment analysis or risk flags. Customize email templates with branding, signatures, or attachments. Connect task outputs with project management tools like Asana, Trello, or Jira. 📞 Support Made by: khaisa Studio Tag: automation, google meet, meeting notes, AI, google tasks, gmail, google docs Category: Productivity Need a custom? Contact Us

AI Audio Transcription & Google Docs Report Generator with VLM Run

Automatically transform audio files into professional transcription reports with AI-powered speech recognition, timestamp generation, and formatted Google Docs output. What this workflow does Monitors Gmail for incoming audio attachments Downloads and processes audio files using VLM Run AI transcription Generates accurate transcriptions with precise timestamps and segmentation Creates professional reports in Google Docs with formatted output Handles asynchronous processing for long audio files without timeouts Setup Prerequisites: Gmail account, VLM Run API credentials, Google Docs access, n8n. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Gmail OAuth2 for email monitoring Add VLM Run API credentials for audio transcription Set up Google Docs OAuth2 for report generation Create target Google Doc for transcription reports Update document URL in workflow nodes Test with sample audio file and activate Perfect for Meeting recordings and conference calls Voice memos and dictation workflows Interview transcriptions and journalism Podcast episode documentation Accessibility compliance and documentation Legal proceedings and court recordings Educational content and lecture notes Customer service call analysis Key Benefits Human-level accuracy** - Advanced AI speech recognition with automatic punctuation Timestamp precision** - Segmented transcriptions with exact time markers Multi-format support** - Handles MP3, WAV, M4A, AAC, OGG, FLAC files Asynchronous processing** - No timeouts for long audio files Professional formatting** - Beautifully structured Google Docs reports Automatic workflow** - Zero manual intervention required Saves hours per recording** - Transforms manual transcription into instant results Searchable documentation** - Google Docs integration enables easy content discovery How to customize Extend by adding: Speaker identification and diarization Integration with project management tools (Notion, Asana, Trello) Automatic summary generation from transcripts Translation to multiple languages Slack notifications for completed transcriptions Integration with CRM systems for call logging Audio quality enhancement preprocessing Custom formatting templates for different use cases Automatic keyword extraction and tagging Integration with calendar systems for meeting context This workflow revolutionizes audio documentation by combining cutting-edge AI transcription with professional report generation, making spoken content instantly accessible, searchable, and shareable across your organization.

+2

Generate Document Drafts from PDFs using Google Drive, GPT-4 & Notifications

Automate Drafts From Google Drive This workflow automates the end-to-end process of extracting and summarizing information from PDFs stored in a specific Google Drive folder. When a new PDF or any binary data is added, the workflow is triggered and begins by downloading and processing the PDF to extract all available text. If multiple PDFs are detected, their content is aggregated into a single, combined dataset. This automation eliminates the time consuming task of manually reading, taking notes, and drafting documents. By removing this burden, users can focus on more meaningful tasks while the workflow handles the repetitive, tedious work. The extracted content is then passed through an AI-powered information extractor that identifies key details such as names, dates, addresses, and any other structured data points the user wants to extract from the PDF. This step is highly customizable, allowing the user to define exactly what type of information should be extracted. While the workflow is designed to extract all available content from the PDF, specifying additional structured data points ensures that critical details are accurately captured. A second OpenAI Node uses the extracted information to draft a professional, formal summary suitable for documentation. This is the most important part of the workflow and can be fully customized to meet the user's specific needs. By editing the prompts, users can tailor the workflow to generate a wide variety of draft formats based on the extracted content. The workflow then generates a new Google Document containing the full draft and composes an email summarizing the key points in 3 to 5 bullet points. This email is automatically sent to the designated recipient along with a direct link to the Google Doc. This solution is ideal for insurance, legal, or administrative use cases where timely, accurate extraction and reporting from incoming PDFs is essential. How To Use The Workflow Step 1 - Place any binary data (e.g., PDF files) into the designated Google Drive folder. Step 2 - The workflow will automatically download each PDF, extract the text, and if multiple PDFs are present combine them into a single dataset for analysis. Step 3 - The OpenAI Draft Agent will analyze the extracted information, generate a formal draft, and create a Google Document. This document will be updated with the draft content and saved back into the same Google Drive folder. Step 4 - An email will be sent to the designated recipient(s), including a summary of the draft and key extracted information, along with a link to view the Google Document. Need Help? Have Questions? For consulting and support, or if you have questions, please feel free to connect with me on LinkedIn or email [email protected].

+4

Automated Website Change Monitoring with Bright Data, GPT-4.1 & Google Workspace

Note: This template is for self-hosted n8n instances only You can use this workflow to fully automate website content monitoring and change detection on a weekly basis—even when there’s no native node for scraping or structured comparison. It uses an AI-powered scraper, structured data extraction, and integrates Google Sheets, Drive, Docs, and email for seamless tracking and reporting. Main Use Cases Monitor and report changes to websites (e.g., pricing, content, headings, FAQs) over time Automate web audits, compliance checks, or competitive benchmarking Generate detailed change logs and share them automatically with stakeholders How it works The workflow operates as a scheduled process, organized into these stages: Initialization & Configuration Triggers weekly (or manually) and initializes key variables: Google Drive folder, spreadsheet IDs, notification emails, and test mode. Input Retrieval Reads the list of URLs to be monitored from a Google Sheet. Web Scraping & Structuring For each URL, an AI agent uses Bright Data's scrape_as_markdown tool to extract the full web page content. The workflow then parses this content into a well-structured JSON, capturing elements like metadata, headings, pricing, navigation, calls to action, contacts, banners, and FAQs. Saving Current Week’s Results The structured JSON is saved to Google Drive as the current week’s snapshot for each monitored URL. The Google Sheet is updated with file references for traceability. Comparison with Previous Snapshot If a prior week’s file exists, it is downloaded and parsed. The workflow compares the current and previous JSON snapshots, detecting and categorizing all substantive content changes (e.g., new/updated plans, FAQ edits, contact info modifications). Optionally, in test mode, mock changes are introduced for demo and validation purposes. Change Report Generation & Delivery A rich Markdown-formatted changelog is generated, summarizing the detected changes, and then converted to HTML. The changelog is uploaded to Google Docs and linked back to the tracking sheet. An HTML email with the full report and relevant links is sent to recipients. Summary Flow: Schedule/workflow trigger → initialize variables Read URL list from spreadsheet For each URL: Scrape & structure as JSON Save to Drive, update tracking sheet If previous week exists: Download & parse previous Compare, generate changelog Convert to HTML, save to Docs, update Sheet Email results Benefits: Fully automated website change tracking with end-to-end reporting Adaptable and extensible for any set of monitored pages and content types Easy integration with Google Workspace tools for collaboration and storage Minimal manual intervention required after initial setup

+4

🔊 Browser Recording Audio Transcribing and AI Analysis with Deepgram and GPT-4o

Overview Transcript Evalu8r V2 is a robust browser-based transcript analysis tool powered by Deepgram’s speech-to-text API and built into an n8n workflow template. This release introduces full in-browser audio recording, device selection, and playback functionality, allowing users to capture and analyze conversations without leaving their browser. Designed for researchers, support teams, podcasters, legal professionals, and analysts, Transcript Evalu8r simplifies how you extract value from voice data using intuitive tools, AI-powered insights, and seamless automation. ✅ What’s New in V2 | | | |:--|:--| |### 🔴 Record in Browser Users can now record audio directly in the browser with one click. Record meetings, calls, or voice notes instantly—no external software required. | ### 🎧 Select Audio Input Devices Users can choose from connected input devices (e.g., internal mic, USB mic, headset) before recording, ensuring maximum control and audio quality.| ▶️ Listen to Recording in Browser Once a recording is complete, users can immediately play back the audio in-browser to review before submitting for transcription—ensuring content is clear and relevant. How It Works Record or upload an audio file **Audio recording is uploaded to Google Drive Audio file is sent to Deepgram for transcribing and AI analysis Audio File is moved to completed folder JSON transcript is saved to Google Drive Google Doc of AI analysis, summary, key points, action items, and full transctip is created Use the Web UI to Explore: Speaker Names Transcript Key points & tasks Sentiment chart Topic and intent lists with time stamps Download or export transcript and insights Add Additional automations or continue workflow (e.g., send to Notion, Slack, Google Sheets, todoist) Key Features 🔹 Transcript Processing & Uploads Upload or record audio directly in your browser Track progress of file uploads in real-time View, select, or download transcripts in Google Docs, JSON, and other formats 🔹 Interactive Transcript Viewer Full transcript display with timestamps, speaker IDs, and auto-scroll Clickable word-level navigation for pinpointing dialogue Real speaker labeling (not just "Speaker 1") 🔹 AI-Powered Analysis Sentiment visualization** over time, per speaker Topic and intent extraction** with confidence scores Speaker contribution insights**, interruptions, and common word frequency 🔹 Insight Summaries Google Doc AI-generated summary, key points, and action items Speaker-specific task suggestions and idea highlights 🔹 UI Enhancements Collapsible sections for focused analysis Light and dark mode support Responsive design across desktop, tablet, and mobile Use Cases ✅ Interview & podcast summarization ✅ Customer support QA monitoring ✅ Legal or compliance transcription logging ✅ Market research and trend analysis ✅ Internal meeting follow-up automation Requirements n8n instance** (self-hosted or cloud) Deepgram API Key** (for audio transcription) Supported browser with mic permissions enabled Why Choose Transcript Evalu8r V2? 🚀 Instantly record and transcribe within your browser 🧠 Extract sentiment, insights, and intent automatically 📈 Visualize speaker tone and engagement 🎧 Choose audio input for cleaner recordings 🔗 Connect with your favorite tools using n8n’s integrations

+4

Audio Conversation Analysis & Visualization with DeepGram and GPT-4o

Transcript Evalu8r – AI-Powered Transcribing and Transcript Analysis Workflow Overview Transcript Evalu8r is an AI-powered transcript analysis workflow that automates the processing, visualization, and evaluation of transcribed conversations. This n8n workflow template is designed to help users quickly analyze sentiment, extract topics and intents, generate key insights, and enhance transcript navigation. It is ideal for customer service teams, legal professionals, researchers, content creators, and businesses seeking actionable intelligence from recorded conversations. Key Features 🔹 Automated Transcript Processing Audio-to-Text Conversion** – Upload an audio file and generate transcripts. File Upload Management** – Track file uploads with real-time progress indicators. Transcript Selection** – Browse and select previously analyzed transcripts from a dropdown. Download Transcripts* – Export transcripts in various formats (Google Docs and JSON*). Error Handling** – Detects and alerts users about upload or processing failures. 🔹 Advanced UI Components Interactive Transcript Viewer** – Displays full transcripts with: Timestamps and speaker identification. Clickable words for easy navigation. Auto-scrolling to highlight the active portion of the transcript. Key Points & Action Items Summary** – AI extracts: Critical insights from conversations. Actionable follow-ups detected in the discussion. Speaker Labeling* – Dynamically assigns real speaker names* instead of generic placeholders (e.g., "Speaker 1"). Collapsible Sections* – Enables users to expand/collapse* transcript details, key insights, and analysis sections. 🔹 AI-Powered Conversation Analysis Sentiment Analysis & Visualization** Dynamic sentiment graph tracks emotional shifts. Color-coded speaker sentiment tracking: 🔵 Positive ⚫ Neutral 🔴 Negative Time-based sentiment tracking – Shows sentiment fluctuations across the conversation. Topic & Intent Recognition** Automated Topic Extraction – Identifies key themes discussed. Hierarchical Topic Organization – Groups related topics for structured insights. Intent Classification – Recognizes whether statements reflect: Questioning Commands Decision-making Information seeking Confidence Scoring – Displays confidence levels for topic and intent detection. Speaker Contribution Metrics** Talk-time percentages per speaker. Interruption detection – Highlights moments where speakers cut each other off. Word Frequency Analysis – Identifies commonly used terms and phrases. 🔹 Seamless Workflow Automation API Integration* – Connects with transcription engines like OpenAI Whisper, AWS Transcribe, and Deepgram*. Webhook Support** – Automates workflows when new transcripts are available. Batch Processing* – Handles multiple transcript analyses* simultaneously. Export & Reporting** – Sends insights to Google Sheets, Notion, Airtable, or Slack. How It Works Upload an audio file or select a pre-existing transcript. Transcript Processing: Speech-to-text conversion (if required). AI-driven sentiment, topic, and intent analysis. Visualizations & Insights: Review sentiment charts, speaker contributions, and key topics. Extract action items and critical takeaways. Download results or trigger automated follow-ups. Use Cases ✅ Customer Support Review – Detect customer concerns and analyze sentiment trends. ✅ Podcast & Video Content Analysis – Summarize episodes and extract key themes. ✅ Sales Call Insights – Identify common objections and customer pain points. ✅ Market Research – Extract trends from focus groups and discussions. ✅ Legal Compliance Monitoring – Track policy violations in recorded conversations. Setup Instructions Import the Transcript Evalu8r workflow into your n8n instance. Connect DeepGram Speech to Text API. Configure workflow parameters (sentiment thresholds, topic extraction settings). Run the workflow to analyze and visualize transcript data. Review insights and export as needed. Why Use Transcript Evalu8r? 🚀 Automate tedious transcript analysis 💡 Unlock hidden insights in conversations 📊 Visualize conversations with interactive sentiment tracking ⚡ Boost efficiency with AI-powered automation 🔗 Seamlessly integrate with your existing workflows Requirements n8n instance** (cloud or self-hosted) API key for DeegGram API

+2

Automate Your RFP Process with OpenAI Assistants

This n8n workflow demonstrates how to automate oftern time-consuming form filling tasks in the early stages of the tendering process; the Request for Proposal document or "RFP". It does this by utilising a company's knowledgebase to generating question-and-answer pairs using Large Language Models. How it works A buyer's RFP is submitted to the workflow as a digital document that can be parsed. Our first AI agent scans and extracts all questions from the document into list form. The supplier sets up an OpenAI assistant prior loaded with company brand, marketing and technical documents. The workflow loops through each of the buyer's questions and poses these to the OpenAI assistant. The assistant's answers are captured until all questions are satisified and are then exported into a new document for review. A sales team member is then able to use this document to respond quickly to the RFP before their competitors. Example Webhook Request curl --location 'https://<n8n_webhook_url>' \ --form 'id="RFP001"' \ --form 'title="BlueChip Travel and StarBus Web Services"' \ --form 'reply_to="[email protected]"' \ --form 'data=@"k9pnbALxX/RFP Questionnaire.pdf"' Requirements An OpenAI account to use AI services. Customising the workflow OpenAI assistants is only one approach to hosting a company knowledgebase for AI to use. Exploring different solutions such as building your own RAG-powered database can sometimes yield better results in terms of control of how the data is managed and cost.

Create and send AI sales proposals using Gemini, Google Docs & Gmail

How it works This workflow automatically generates and sends personalized sales proposals when a new row is added to Google Sheets. It uses AI to create proposal content, updates contact details in HubSpot, and generates a formatted document. The document is converted into a PDF and emailed to the client. This eliminates manual proposal writing and ensures fast, consistent delivery. Step-by-step Capture lead and generate AI content** Google Sheets Trigger – Detects new form submissions in your sheet. Loop Over Items – Processes each new entry individually. Message a model – Uses Gemini AI to generate the proposal content. Code in JavaScript – Cleans and splits AI output into structured fields. Create contact and generate document** Create or update a contact – Stores or updates client data in HubSpot. Copy file – Duplicates a proposal template from Google Drive. Update a document – Replaces placeholders with real client and AI data. Download file – Converts the final document into a PDF file. Send proposal to client** Send a message – Emails the generated PDF proposal to the client. Why use this? Automatically generates professional proposals without manual writing Ensures consistent formatting using templates and placeholders Saves time by combining CRM, AI, and document creation Improves response speed for leads and increases conversion chances Scales easily for handling multiple client requests simultaneously

Generate and Send Personalized Quotations PDF

This Template Demonstrates How To Automate Generating and Sending Personalized Quotations as PDF. Use cases are many: send branded quotations to new leads after a discovery call, distribute pricing proposals to inbound form submissions, or push service packages to prospects. All without manually creating documents, exporting PDFs, or writing individual emails. Good to know OpenAI charges per token. The workflow uses gpt-4o-mini for cost efficiency (~$0.15/1M input tokens). Check OpenAI Pricing before running at scale. Google Docs template must be set up with placeholder variables before the first run. The workflow fills data in — it won’t generate a layout for you. Gmail has daily sending limits depending on your Google Workspace plan. Check your quota before sending large volumes. The form is hosted by n8n — share the form URL with your team or embed it in your internal tools. How it works PHASE 1: FORM INTAKE An n8n Form Trigger collects all quotation details: client name, email, company, service type, service description, price, validity date, and optional notes. The form is self-hosted on your n8n instance — no third-party form tools needed. Once submitted, all fields pass directly into the workflow as structured data. PHASE 2: AI PERSONALIZATION The form data is sent to OpenAI (gpt-4o-mini) which generates two pieces of content: – A personalized introduction paragraph addressing the client by name, referencing their company and specific needs. – A structured scope of work summary with deliverable bullet points based on the service description. Output is returned as JSON so it slots cleanly into the document template and email body. PHASE 3: DOCUMENT GENERATION The workflow copies your pre-built Google Docs quotation template to a new document, named automatically as “Quotation - {Company} - {Service}”. Nine placeholder variables are replaced in the copied document: {{client_name}}, {{company_name}}, {{client_email}}, {{service}}, {{price}}, {{valid_until}}, {{notes}}, {{intro}}, and {{scope_summary}}. The completed document is exported from Google Drive as a PDF. Your branding, layout, and formatting stay exactly as designed in the template. PHASE 4: EMAIL DELIVERY The PDF is attached to a personalized email sent via Gmail directly to the client’s email address. The email body includes the AI-generated intro, scope of work summary, total price, and validity date — no manual copy-pasting. The form submitter sees a confirmation response once the email is sent. Closed loop, fully hands-off. How to use Create your Google Docs template with your preferred layout, branding, and these placeholders: {{client_name}}, {{company_name}}, {{client_email}}, {{service}}, {{price}}, {{valid_until}}, {{notes}}, {{intro}}, {{scope_summary}}. Copy the template Document ID from the URL (docs.google.com/document/d/THIS_PART/edit) and paste it into the Copy Template node. Configure Google OAuth via Google Console. Create a project, apply your Client ID and Secret in the Google Drive, Google Docs, and Gmail node credentials. Set the OpenAI credential with your API key in the OpenAI Personalize node. Share the form URL with your team. The URL is generated automatically when the workflow is activated. Requirements • OpenAI API — personalized intro and scope generation • Google Drive OAuth — template copying and PDF export • Google Docs OAuth — variable replacement in the document • Gmail OAuth — personalized email delivery with PDF attachment • n8n instance (self-hosted or cloud) Customising this workflow • Swap the form trigger for a webhook or CRM integration (HubSpot, GoHighLevel, Airtable) if you want quotations generated from pipeline stage changes instead of manual form submissions. • Add a Slack or email approval step before sending — insert a Slack node between Export as PDF and Send Quotation Email if you want a manager to review before it goes out. • Replace Gmail with any email provider (Outlook, SMTP, SendGrid) if your team doesn’t use Google Workspace. • Add a Google Sheets logging step after sending to track all sent quotations with client name, date, service, and price for reporting. • This pattern works beyond quotations — try it for proposals, invoices, contracts, or any document where the structure stays fixed but the data changes. • Add multiple service line items by extending the form with repeating fields and adjusting the template to include a table of services with individual pricing.

Generate and track offer letters with Google Sheets, Docs, Drive and Gmail

How it works This workflow automates the full offer letter lifecycle, from generation to final candidate response tracking. When a new row with a Pending status is added to Google Sheets, it creates a personalized offer letter using a Google Docs template. The document is converted to PDF, stored in Google Drive, shared securely, and sent to the candidate via Gmail. Candidate responses are captured through webhooks, validated against deadlines, and used to update status and trigger follow-up communications. First set: Generate and send offer letter Monitor new candidates** Google Sheets Trigger – Watches for newly added rows in the offer sheet. If – Ensures only rows with a Pending status are processed. Generate offer letter** Google Drive – Copies the offer letter template for the candidate. Google Docs – Replaces placeholders with candidate-specific data. Google Drive – Converts the document to a PDF file. Store and share document** Google Drive – Saves the PDF to a designated folder. Google Drive – Assigns public read-only access to the file. Send offer email** Gmail – Sends the offer email with Accept and Decline action links. Google Sheets – Updates the sheet with offer link, date, and Sent status. Second set: Capture response and finalize outcome Capture candidate response** Webhook – Receives the candidate’s decision from email buttons. Google Sheets – Fetches the corresponding candidate record. If – Checks whether the response is already locked. Code – Validates decision against the response deadline. Finalize outcome** Switch – Routes Accepted, Rejected, or Timeout outcomes. Google Sheets – Updates final status and locks further responses. Gmail – Sends confirmation emails to the candidate and HR.

Create anti-cheating tests from PDFs with GPT-4o-mini and Google Docs

Extract content from PDFs, generate two different test versions with AI, and create formatted Google Docs with automated email delivery. This workflow extracts text from PDF teaching materials, uses OpenAI to generate 10 test questions in two different versions (Group A and B), creates a formatted Google Doc, and sends an email notification with the document link. Perfect for teachers who need to prevent student cheating while saving time on test creation. Tools used: OpenAI GPT-4o-mini, Google Docs, Google Drive, Gmail

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

+3

Generate AI SOPs from Google Drive with GPT‑4o, Google Docs and Sheets

This workflow automatically converts unstructured internal documentation into clear, actionable Standard Operating Procedures (SOPs). Instead of manually rewriting internal knowledge, teams can upload or update documents and let AI generate consistent, step-by-step SOPs that are easy to follow and scale across the organization. How it works When a new or updated document is detected in Google Drive, the workflow extracts the content and splits it into manageable sections. AI then analyzes the material, identifies implicit steps, and generates a structured SOP with clear actions, responsibilities, and outcomes. A second AI pass refines clarity and consistency. Completed SOPs are saved to Google Docs, logged in Google Sheets, and shared with stakeholders via Slack or email. Who it’s for Operations teams Consulting firms Agencies and service businesses Scaling startups Internal enablement teams Requirements Google Drive & Docs Google Sheets OpenAI credentials Slack or Gmail Built by QuarterSmart Created by Hyrum Hurst, AI Automation Engineer at QuarterSmart, specializing in practical, production-ready AI automation systems. For custom SOP automation or enterprise setups: [email protected]

+2

Create client onboarding projects, contracts and Slack channels from form data

📊 Description Streamline and standardize your entire client onboarding process with a single end-to-end automation. 🚀📋 This workflow captures detailed client intake data via webhook, automatically creates a fully structured Asana onboarding project, generates a personalized service contract from a Google Docs template, emails the agreement to the client, and logs all information in Google Sheets. It also creates a dedicated Slack channel for internal collaboration, ensuring every new client is onboarded consistently, professionally, and without manual effort. Perfect for service businesses scaling operations while maintaining quality and clarity. ✨📄🤝 🔁 What This Template Does 1️⃣ Receives detailed client intake form data via webhook. 📥 2️⃣ Parses and normalizes 70+ client, business, and technical fields. 🧾 3️⃣ Creates a new client-specific onboarding project in Asana. 📋 4️⃣ Copies sections and tasks from a predefined Asana template project. 🔄 5️⃣ Assigns all tasks into the new project with proper structure. ✅ 6️⃣ Retrieves a Google Docs contract template. 📄 7️⃣ Replaces placeholders with client-specific details (name, fees, dates). ✍️ 8️⃣ Downloads the personalized contract as a PDF. 📑 9️⃣ Sends a welcome email to the client with the contract attached. 📧 🔟 Resets the contract template for the next onboarding. 🔁 1️⃣1️⃣ Logs all client data into Google Sheets for tracking and reporting. 📊 1️⃣2️⃣ Creates a dedicated Slack channel for internal client communication. 💬 ⭐ Key Benefits ✅ Eliminates manual onboarding setup and repetitive admin work ✅ Ensures consistent project structure for every client ✅ Generates error-free, personalized contracts automatically ✅ Improves client experience with instant, professional communication ✅ Centralizes client data for operations and reporting ✅ Scales onboarding without adding operational overhead 🧩 Features Webhook-based client intake form processing Advanced data parsing for large intake payloads Asana project creation with template-based sections and tasks Google Docs dynamic contract generation Automated PDF download and email delivery Google Sheets client tracking with append/update logic Automatic Slack channel creation for internal teams Clean reset logic for reusable document templates 🔐 Requirements Asana OAuth2 credentials Google Docs OAuth2 credentials Google Drive OAuth2 credentials Google Sheets OAuth2 credentials Gmail OAuth2 credentials Slack API credentials Asana template project ID Google Docs contract template ID Google Sheets tracking document ID 🎯 Target Audience Service-based businesses onboarding new clients Agencies managing multi-step client engagements Operations and delivery teams SaaS or healthcare service providers with complex intake forms Automation teams building scalable onboarding systems

+4

Generate Comprehensive Client Brief Reports with Llama 3 AI & Google Workspace

How It Works Trigger: The workflow starts automatically when a new file (PDF, DOCX, or TXT) is uploaded to a specific Google Drive folder for client briefs. Configuration: The workflow sets up key variables, such as the folder for storing reports, the account manager’s email, the tracking Google Sheet, and the error notification email. File Type Check & Text Extraction: It checks the file type and extracts the text using the appropriate method for PDF, DOCX, or TXT files. Extraction Validation: If text extraction fails or the file is empty, an error notification is sent to the designated email. AI Analysis: The extracted text is analyzed using Groq AI (Llama 3 model) to summarize the brief, extract client needs, goals, challenges, and more. Industry Research: The workflow performs additional AI-powered research on the client’s industry and project type, using Wikipedia and Google Search tools. Report Generation: The analysis and research are combined into a comprehensive, formatted report. Google Doc Creation: The report is saved as a new Google Doc in a specified folder. Logging: Key details are logged in a Google Sheet for tracking and record-keeping. Notification: The account manager receives an email with highlights and a link to the full report. Error Handling: If any step fails (e.g., text extraction), an error email is sent with troubleshooting advice. Setup Steps Google Drive Folders: Create a folder for incoming client briefs. Create a folder for storing generated client summary reports. Google Sheet: Create a Google Sheet with a sheet/tab named “Brief Analysis Log” for tracking analysis results. Google Cloud Project: Set up a Google Cloud project and enable APIs for Google Drive, Google Docs, Google Sheets, and Gmail. Create OAuth2 credentials for n8n and connect them in your n8n instance. Groq AI Credentials: Obtain API credentials for Groq AI and add them to n8n. SerpAPI (Optional, for Google Search): If using Google Search in research, get a SerpAPI key and add it to n8n. n8n Workflow Configuration: In the “Workflow Configuration” node, set the following variables: clientSummariesFolderId: Google Drive folder ID for reports. accountManagerEmail: Email address to notify. trackingSheetId: Google Sheet ID for logging. errorNotificationEmail: Email for error alerts. Connect All Required Credentials: Make sure all Google and AI nodes have the correct credentials selected in n8n. Test the Workflow: Upload a sample client brief to the monitored Google Drive folder. Check that the workflow runs, generates a report, logs the result, and sends the notification email.

+2

SEO Blog Content Automation with GPT-4o-mini and Human Approval in Google Docs

Overview This n8n workflow automates the entire content creation process for SEO blog posts, from topic submission and AI drafting to human approval, revision, and final storage in Google Docs. It ensures high-quality, SEO-optimized content is generated efficiently while keeping a human in the loop for quality control. Prerequisites To use this workflow, you need the following accounts and credentials: Google Sheets Account: To manage the content tracker. The sheet must contain columns for Topic, Reference URL, Title, Status, and Link to document. OpenAI API Key (for GPT-4o-mini): To power the initial content drafting and subsequent revisions. Gmail Account: To send the content for human approval and wait for feedback. Google Docs Account: To create and store the final approved blog posts. How It Works The workflow operates in four main stages: Topic Submission, AI Content Creation, Human Approval & Revision Loop, and Final Publishing. Stage 1: Topic Submission and Tracking This stage captures a new blog topic and adds it to the content tracker. On form submission (Form Trigger): The workflow is initiated when a user submits a Topic and an optional Reference link through the form. Append row in sheet (Google Sheets): The new topic and reference link are added as a new row in your content tracker sheet. Get Topic from Google Sheets: The workflow fetches the newly added row, including the system-generated row_number for tracking updates. Stage 2: AI Content Creation (Initial Draft) The workflow uses an expert AI agent to generate the first draft of the blog post. Copywriter AI Agent: Acting as an expert SEO content strategist, the agent receives the topic and reference URL. The agent improves the provided topic into an SEO-optimized title. It writes a complete, conversational, SEO-friendly blog post (800–1200 words) using proper Markdown headings and lists. OpenAI Chat Model (GPT-4o-mini): Powers the agent's generation. Structured Output Parser: Ensures the output is in a JSON format with separate title and content keys. Set Data: The AI-generated title and content are mapped to workflow variables (Topic Title, Content) for easy use in subsequent nodes. Stage 3: Human Approval and Revision Loop This is the critical quality control step where a human reviews the draft and decides on the next action. Send Content for Approval (Gmail): The generated title and content are sent via email to the approver (<your email>). This uses a custom form that allows the user to choose Yes (Approve), No (Request Revision), or Cancel. The form also includes a Content Feedback textarea. Approval Result (Switch): The workflow pauses until the approver submits the form, and then directs the flow based on their choice. If "Yes" (Approved): Proceeds to the final publishing stage. The Update Topic Status on Google Sheets node is executed, setting the Status to Approved and logging the new Title. If "No" (Revision Requested): Proceeds to the revision loop. Copywriter Revision Agent: This agent takes the original content, the topic title, and the user's Content Feedback. It is instructed to incorporate the feedback, preserving the existing structure and tone, and outputs a revised blog post. The flow loops back through the Set Data node and then returns to the Send Content for Approval node for a new review. If "Cancel": Stops the workflow, and the Update Topic Status on Google Sheets node is executed. Stage 4: Final Publishing Once approved, the content is stored in Google Docs and the tracker is updated. Create Blog file (Google Docs): A new Google Doc is created using the approved Topic Title. Add blog content in file (Google Docs): The final Content (in Markdown format) is inserted into the newly created document. Update sheet with blog post link (Google Sheets): The final tracker update logs the Link to document and the Published date. Customization Tip Recommend using AI humanazier and AI detector tools before approval to make the SEO score better.

Automate Job Applications with AI Resume Tailoring using GPT-4o, LinkedIn & Gmail

Overview Stop applying manually. This workflow acts as your personal AI recruiter, automating the end-to-end process of finding high-quality jobs, tailoring your resume, and preparing personalized outreach emails to decision-makers. What this workflow does Scrapes Real-Time Jobs:** Uses Apify to pull live job listings from LinkedIn based on your specific keywords (e.g., "AI Automation"). Smart Filtering:** Uses GPT-4o-mini to analyze job descriptions against your skills and automatically discards roles that aren't a good fit. Hyper-Personalized Resume:** Uses GPT-4o to rewrite your "Master Resume" specifically for the target job description. Document Generation:** Creates a new Google Doc with the tailored resume and automatically sets sharing permissions. Decision Maker Enrichment:** Uses Anymail Finder to locate the verified email address of the Company CEO or Hiring Manager. Cold Email Draft:** Generates a personalized pitch in Gmail (Drafts folder) with the link to your custom resume attached. Setup Requirements To run this workflow, you will need to set up credentials in n8n for the following services. Please ensure you use n8n credentials and do not hardcode API keys into the HTTP nodes: Google Drive & Docs:** To read your master resume and create new application files. Apify Account:** To run the LinkedIn Job Scraper actor. OpenAI API Key:** For logic (GPT-4o-mini) and writing (GPT-4o). Anymail Finder API:** To find contact email addresses. Gmail:** To create the draft emails. How to use Upload Resume: Paste your "Master Resume" text into the first Google Docs node or connect your existing file. Configure Credentials: Add your API keys in the n8n credentials section for all services listed above. Set Search Criteria: Update the JSON body in the Apify node with your desired LinkedIn job search URL. Run: Execute the workflow and watch your drafts folder fill up with ready-to-send applications.

+4

AI-powered content analysis with Decodo scraping & GPT-4o insights

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. AI-Powered Content Analysis System Elevate your content quality with this AI-powered Content Analysis System! This workflow automatically evaluates website content using advanced scraping and AI analysis, providing comprehensive SEO insights, readability scores, and actionable improvement recommendations. Perfect for content teams ensuring optimal performance and engagement across digital properties. What This Template Does Triggers via form submission for on-demand content analysis requests. Checks previous analyses to prevent duplicate processing. Scrapes target URLs using Decodo for comprehensive content extraction. Uses AI to evaluate content quality, SEO effectiveness, and readability. Saves analysis results to Google Sheets for historical tracking. Generates professional Google Docs reports with actionable insights. Sends email notifications with formatted analysis summaries. Alerts teams via Slack for both normal and urgent findings. Creates remediation plans and Trello tasks for low-quality content. Key Benefits Automated content quality assessment with AI-powered insights Prevents duplicate analyses to optimize resource usage Comprehensive SEO and readability scoring for data-driven decisions Professional reporting with Google Docs and email integration Immediate team alerts for urgent content improvements Historical tracking and trend analysis capabilities Features Form-based trigger for easy content analysis requests Duplicate detection and prevention system AI-powered content evaluation using GPT-4o Real-time web scraping with Decodo integration Automated Google Docs report generation Multi-channel notifications (Slack, Gmail) Quality threshold monitoring and alerting Remediation plan generation for low-quality content Trello integration for task management Historical analysis database in Google Sheets Requirements OpenAI API credentials for AI analysis Decodo API credentials for web scraping Google Sheets OAuth2 credentials with edit access Google Docs OAuth2 credentials for report generation Gmail OAuth2 credentials for email notifications Slack Bot Token with chat:write permission Trello credentials (optional for task management) Environment variables for configuration settings Target Audience Content marketing and strategy teams SEO specialists and digital marketers Content quality assurance teams Digital agencies managing multiple clients Website owners and publishers Content operations managers Step-by-Step Setup Instructions Connect OpenAI credentials for AI content analysis capabilities Set up Decodo API credentials for web scraping functionality Configure Google Sheets with required analysis headers Add Google Docs credentials for automated report generation Set up Gmail and Slack credentials for notifications Optional: Configure Trello integration for task management Customize the analysis form with your industry and focus areas Test with sample URLs to verify all integrations and data flow Deploy for ongoing content quality monitoring and optimization Pro Tip: Get a free Web Scraping API subscription - https://decodo.com/scraping/web This workflow ensures your content maintains high quality standards with automated analysis, professional reporting, and immediate improvement alerts!

+3

Create Weekly Space Newsletter with NASA APIs, GPT-4 & Google Workspace

Who is it for This template is perfect for content creators, space enthusiasts, educators, and organizations who want to automatically generate and distribute engaging weekly space newsletters. It's especially useful for those who want to stay updated on space events without manual content creation. How it works This workflow automatically generates a comprehensive space newsletter every week by: Fetching the latest data from multiple NASA APIs (APOD, DONKI, NeoWS) Using AI to create an engaging newsletter from the raw data Creating a formatted document with the content Converting it to PDF format Distributing via email and archiving to your preferred platform Sending success notifications to your team Setup steps Get NASA API Key: Register at https://api.nasa.gov to get your API key (free) Configure OpenAI: Add your OpenAI credentials for content generation Set up Google Workspace: Connect Google Docs, Drive, and Gmail accounts Optional integrations: Configure Notion for archiving and Slack for notifications Customize schedule: Adjust the weekly trigger time to your preference Requirements NASA API key (free at api.nasa.gov) OpenAI API access Google Workspace account (Docs, Drive, Gmail) Optional: Notion and Slack accounts How to customize Modify the AI prompt to change the newsletter style and tone Adjust the date range for fetching space data Add or remove NASA API endpoints based on your interests Customize email recipients and notification channels Enable/disable the Notion archiving feature as needed

Generate Complete Lead Magnets with OpenAI, Claude, and Google Docs Automation

In this tutorial, I’ll walk you through a step-by-step N8N workflow that combines the power of OpenAI and Claude AI to generate professional, ready-to-use lead magnet plans for any niche. This workflow helps marketers, agencies, and freelancers create engaging lead magnets — such as guides, blueprints, and checklists — with zero manual writing and complete AI automation. Who is this for? Marketers and content strategists creating high-converting lead magnets Agencies looking to scale client content deliverables Freelancers offering marketing automation services Anyone who wants to combine AI + automation for efficient content creation What problem is this workflow solving? Manually writing lead magnets can be slow and inconsistent. This workflow eliminates that by: Using OpenAI and Claude AI to co-create detailed content frameworks Automating research, structure, and formatting of lead magnet documents Allowing full customization for different industries or audiences Reducing production time from hours to minutes What this workflow does This automation connects OpenAI, Claude AI, and Google Drive (or Docs) inside n8n to produce well-structured lead magnet documents. The process includes: Collecting a topic or niche input from a form or webhook. Generating an outline and content blocks using OpenAI. Refining, expanding, and organizing the text using Claude AI. Formatting the content and converting it to clean HTML or Google Docs format. Saving or uploading the final version to Google Drive or Notion. By the end of the tutorial, you’ll have a fully automated content agent that builds lead magnet plans from scratch — ready to deliver to clients or publish instantly. Setup Create Accounts: Sign up for n8n.io. Obtain API access for OpenAI, Claude (via OpenRouter), and Google Drive API. Add API Keys in n8n: Go to Credentials and add your OpenAI and Claude API keys securely. Build the Workflow: Use a Form Trigger or Webhook Node to capture topic input. Add OpenAI Node to generate structure and section ideas. Add HTTP Request Node for Claude API (OpenRouter) to expand sections into polished paragraphs. Use a Function Node to merge sections and format them into Markdown or HTML. Add Google Drive Node to upload or store the final file. Test Your Workflow: Input a test topic (e.g., “Dental Marketing Blueprint”). Wait for the AI to generate, merge, and store your lead magnet content automatically. How to customize this workflow to your needs Modify prompt templates to fit your target audience or writing style. Integrate Notion, Airtable, or Slack for automatic delivery. Add a scheduling trigger (e.g., weekly lead magnet generation). Incorporate branding or styling logic using Markdown → HTML conversion. Expand prompts for multilingual or niche-specific lead magnets. Notes This workflow requires API keys for both OpenAI and Claude (via OpenRouter). Ensure proper handling of text formatting nodes to avoid Markdown errors. Google Drive integration requires OAuth setup in n8n credentials. Works on both n8n Cloud and self-hosted environments. 🎥 Watch the Full Tutorial 👉 YouTube Video Tutorial

Daily Morning Haiku Generation with OpenRouter AI, Google Docs and Gmail

How it works This workflow automatically generates a new haiku poem every morning using AI, formats it in 5-7-5 structure, saves it to Google Docs, and sends it to your email inbox. Workflow steps: Schedule Trigger – Runs daily at 7:00 AM. AI Agent – Asks AI to output four words (kigo, noun, verb1, verb2) in JSON format. Code in JavaScript – Builds a 5-7-5 haiku using the AI-generated words and sets today’s title. Edit Fields – Prepares document fields (title and body) for Google Docs. Create a document – Creates a new Google Document for the haiku. Prepare Append – Collects the document ID and haiku text for appending. Update a document – Inserts the haiku into the existing Google Doc. Send a message – Sends the haiku of the day to your Gmail inbox. OpenRouter Chat Model – Connects the OpenRouter model used by the AI Agent. Setup steps Connect your OpenRouter API key as a credential (used in the AI Agent node). Update your Google Docs folder ID and Gmail account credentials. Change the email recipient address in the “Send a message” node. Adjust the Schedule Trigger time as you like. Run the workflow once to test and verify document creation and email delivery. Ideal for Writers and poets who want daily creative inspiration. Individuals seeking a fun morning ritual. Educators demonstrating AI text generation in a practical example. ⚙️ Note: Each node includes an English Sticky Note above it for clarity and documentation.

Automate UX Research Planning with Gemini AI, Google Docs, and Human Feedback

This workflow automates the entire UX research planning process — from gathering context to delivering a ready-to-share Google Doc report. Built for UX researchers and designers, it combines AI-powered generation with human feedback loops to make research planning faster, smarter, and more collaborative. 🧠 What it does Collects context** through an online form (organization, product, and research goals) Generates research questions** automatically using an AI Agent Sends approval emails** to the researcher or designer for review and feedback Refines and rewrites** questions based on user input Recommends suitable research methods** for each question, with clear rationales Formats the content** into a structured, professional HTML report Creates and updates a Google Doc** with the final approved research plan 🎯 Who it’s for Perfect for UX teams, design researchers, and product designers who want to streamline their workflow without losing human oversight. Whether you’re preparing a usability study or strategic research plan, this automation helps you focus on insight — not administration. Result: a fully-approved, polished UX Research Plan — ready for collaboration and presentation.

+4

Personalized Sales Outreach with Apollo, GPT, and Gmail Automation

This n8n template shows you how to turn outbound sales into a fully automated machine: scrape verified leads, research them with AI, and fire off personalized cold emails while you sleep. Use cases are simple: scale B2B lead gen without hiring more SDRs, run targeted outreach campaigns that don’t feel generic, and give founders or agencies a repeatable system that books more calls with less effort. Good to know At time of writing, each AI call may incur costs depending on your OpenAI plan. This workflow uses Apollo/Apify for lead scraping, which requires an active token. Telegram approval flow is optional but recommended for quality control. How it works Define your ICP (role, location, industry) in the workflow. Generate Apollo search URLs and scrape verified contacts. AI enriches leads with personal + company research. Hormozi-style cold emails are generated and queued for approval. Approve drafts in Telegram, then Gmail automatically sends them out. How to use Start with the included Schedule Trigger or replace with a Webhook/Form trigger. Adjust ICP settings in the Set node to fit your target audience. Test with a small batch of leads before scaling to larger runs. Requirements Google Sheets, Docs, Drive, and Gmail connected to n8n Apollo/Apify account and token OpenAI API key Telegram bot for approvals Customising this workflow Swap Apollo scraping with another data source if needed. Adapt the AI prompt for a different email tone (formal, friendly, etc.). Extend with a CRM integration to sync approved leads and outreach results.

+9

AI-Powered Multi-Platform Social Media Content Factory with Dynamic System Prompts & GPT-4o

Automated Social Media Content Publishing Factory + System Prompt Composition This workflow is a powerful automation for creating and publishing social media content. It uses AI to generate content and images based on external prompts and schemas, and routes the final posts to various social media platforms. How it Works This workflow operates as a "Content Publishing Factory". It generates platform-optimized content for platforms like LinkedIn, Instagram, Facebook, X (Twitter), Threads, and YouTube Shorts. A key feature is its dynamic system prompt and output schema composition, which pulls content from external Google Docs to ensure consistency. The workflow can also create images to match the content and send the final draft for approval via email before publishing. Use Cases Centralized Content Management**: Store and manage all system prompts and schemas in Google Docs for easy team collaboration and version control. Brand Consistency**: Ensure a consistent brand voice across all social media platforms by centralizing brand guidelines and content rules. Automated Publishing**: Automate content creation, image generation, and publishing, reducing manual effort and design bottlenecks. Fact-checking and Contextual Relevance**: Incorporate real-time research and fact-checking into content to ensure accuracy and relevance. Setup Instructions Google Docs: Create two Google Docs: one for the social media schema and one for the system prompt, and update the respective node IDs in the workflow. API Credentials: Provide credentials for the following services: OpenAI: For the AI agents and content creation. SerpAPI: For the web search tool to perform research. Gmail: For sending content for approval and notifications. Google Drive: For archiving images and final posts. Social Media Platforms: You'll need credentials for the platforms you wish to publish to (X, Instagram, Facebook, LinkedIn, etc.). Image Hosting: The workflow uses imgbb.com to host generated images, requiring an API key. Workflow Logic Routing Agent: The Social Media Router Agent receives a user prompt and uses a toolWorkflow node to route the request to the appropriate content generation workflow. Prompt & Schema Composition: The workflow fetches the system prompt and platform-specific schemas from Google Docs, parses them, and composes a dynamic prompt for the AI agent. Content Creation: The Social Media Content Creator agent uses the composed prompt and a web search tool to generate platform-optimized content and an image suggestion. Image Generation & Archiving: The workflow generates an image from the AI suggestion using an external service and archives both the image and the final post content in Google Drive. Approval Process: The draft content is sent to a Gmail address for approval. Publishing: If the content is approved, the Social Media Publishing Router node directs the content to the correct publishing node for the specified platform (e.g., X Post, Instagram Image, Facebook Post, etc.). Node Descriptions | Node Name | Description | |-----------|-------------| | When chat message received | A trigger node that initiates the workflow based on a chat message. | | Social Media System Prompt | A Google Docs node that retrieves the main system prompt for the AI agent. | | Social Media Schema | A Google Docs node that retrieves the JSON schema for each social media platform's output. | | Social Media Content Creator | An AI agent that generates content based on user prompts, system prompts, and schemas, using a web search tool for research. | | pollinations.ai1 | An HTTP Request node that generates an image from a text prompt using an external service. | | Gmail User for Approval | Sends a draft of the social media post for approval and pauses the workflow until a decision is made. | | Social Media Publishing Router | A Switch node that routes the workflow to the correct publishing node based on the user's selected platform. | | X Post, Instagram Post, Facebook Post, LinkedIn Post | These nodes publish the final, approved content to their respective social media platforms. | Customization Tips You can replace the pollinations.ai image generation service with any other online service that produces an image file. Replace the gpt-4o and gpt-4o-mini models with other LLMs and web search tools to suit your needs. Adjust the content and parameters for each social media platform to better fit your brand and audience. Suggested Sticky Notes for Workflow Start Here**: "Update all Social Media Platform Credentials as required. Adjust parameters and content for each platform to suit your needs". External System Prompt and Schema**: "Create Google Doc for the Social Media Schema and copy the provided schema. Update the Google Doc ID in the Social Media Schema node.". Create Post Image**: "Replace pollinations.ai with any online image generation service that produces an image file you can download". Social Media Content Creator**: "Replace Chat model with other LLMs and test out the results. Add more tools or try other web search tools to suit your use case." Testing Tips Start the workflow with a manual trigger and verify that the social media content and a related image are generated and sent for approval via Gmail. Approve the content in the Gmail email to test the publishing side of the workflow. Check the specified social media accounts to confirm that the post was published correctly. Suggested Tags & Categories SocialMedia Automation AI ContentCreation Publishing GoogleDocs OpenAI

Summarize Google Docs & PDFs with GPT-4 and Send to Slack or Email

📄 AI-Powered Document Summarizer & Notifier This workflow monitors a Google Drive folder for new files (Google Docs or PDFs), extracts text, summarizes content with OpenAI, and sends results to Slack or Email. 🔧 How It Works Monitors a Google Drive folder for new files. Detects file type → Google Doc vs PDF. Extracts text (via Google Docs API or PDF extractor). Summarizes & analyzes content using OpenAI. Sends results to Slack and/or Email. 👤 Who Is This For? Business teams → Quick digests of reports, proposals, contracts. Educators / researchers → Summaries of long study materials. Founders / managers → Daily summaries without opening every file. Operations teams → Compliance and documentation tracking. 💡 Use Case / Problem Solved Reading long documents is time-consuming. Sharing key points across teams requires manual effort. Important context (sentiment, action items) is often missed. 👉 This workflow solves it by auto-summarizing documents and notifying teams instantly. ⚙️ What This Workflow Does Monitors Google Drive for new Google Docs or PDFs. Extracts text automatically. Uses OpenAI to generate: Title Summary Key Points Suggested Action Items Language detection Sentiment (positive, neutral, negative) Pushes output to Slack channel and/or Email inbox. 🛠️ Setup Instructions Prerequisites Google Drive (OAuth2) Google Docs (OAuth2) OpenAI API Key Slack (OAuth2) or Gmail (OAuth2) Steps to Configure Connect Google Drive Choose the folder you want to monitor. Set up file type routing Use an IF node to split Docs vs PDFs. For Google Docs Use Google Docs Get → extract text. For PDFs Use Google Drive Download → Extract PDF. Send text to OpenAI Connect to your OpenAI model. Customize the system prompt to generate title, summary, sentiment, etc. Notify Send output to Slack channel or Gmail. Save & activate your workflow. 📌 Notes Adjust OpenAI prompt to suit your context. For large PDFs, consider splitting into smaller chunks.

Transcribe and Analyze Meetings or Podcasts with ElevenLabs and Google Gemini AI

This workflow automates the process of transcribing audio/video files into text using ElevenLabs Speech-to-Text, saving the transcripts to Google Docs, and generating AI-powered summaries and analysis, which are then emailed to a specified address. This ElevenLabs Speech-to-Text model excels in scenarios requiring accurate speech-to-text conversion: Transcription Services: Perfect for converting audio/video content to text Meeting Documentation: Ideal for capturing and documenting conversations Content Analysis: Well-suited for audio content processing and analysis Multilingual Recognition: Supports accurate transcription across 99 languages Files up to 3 GB in size and up to 10 hours in duration are supported. This API supports uploading both audio and video files for transcription. Key Advantages ✅ Automation of Repetitive Tasks: Eliminates manual transcription, note-taking, and reporting. ✅ High-Accuracy Transcription: Powered by ElevenLabs, supporting multiple languages and long files. ✅ Structured Insights: AI-powered analysis (Gemini) transforms raw transcripts into professional summaries with action items and key decisions. ✅ Seamless Integration: Works with Google Sheets, Google Docs, and Gmail for easy workflow adoption. ✅ Scalable & Reusable: Handles multiple recordings in batch and integrates smoothly into existing processes. ✅ Improved Productivity: Teams save time by receiving clear, well-structured meeting recaps without effort. How It Works The workflow operates in a linear sequence, processing one audio URL at a time from a Google Sheet. Trigger & Data Fetch: The process starts manually. It first reads from a specified Google Sheet to get a list of audio file URLs that haven't been processed yet (marked with "DONE"). Transcription: For each audio URL, it sends a request to the ElevenLabs Speech-to-Text API, passing the cloud storage URL of the audio file. Document Creation & Storage: Upon receiving the transcription text from ElevenLabs, the workflow: Creates a new Google Doc named after the transcription ID. Writes the full raw transcript text into this newly created document. Analysis & Summary: The raw transcript text is passed to Google Gemini AI. The AI analyzes the text based on a detailed, pre-defined system prompt that instructs it to extract key points, decisions, action items, and insights, formatting the output as a structured summary. Notification: The AI-generated analysis (converted from Markdown to HTML) is sent via Gmail as an email to a predefined address. Status Update: Finally, the workflow updates the original row in the Google Sheet, marking it as "DONE" (with an 'x') and recording the ID of the newly created Google Doc for future reference. This ensures the same audio file is not processed again on the next run. Set Up Steps To configure this workflow, you need to complete the following steps: Credentials Setup: ElevenLabs API: In the "Speech-to-Text" HTTP Request node, configure the HTTP Header Auth credentials. The header name should be xi-api-key and the value should be your valid ElevenLabs API key. Google Services: Ensure your Google Sheets, Google Docs, and Gmail nodes are connected to valid Google OAuth2 credentials with the necessary permissions to read, write, and send emails. Google Gemini AI: The "Transcript Analysis" node must be connected to valid Google Gemini (PaLM) API credentials. Google Sheet Configuration: Make a copy of the provided Google Sheet template. In the "Get audio urls" node, update the documentId parameter to match the ID of your new Google Sheet. Similarly, update the documentId in the "Update row" node. Populate your sheet with the URLs of the audio/video files you want to process in the 'AUDIO URL' column. Output Configuration: In the "Send email" node, change the sendTo parameter to the email address where you want to receive the analysis summaries. The "Create Doc" node specifies a folderId; change this to the ID of the specific Google Drive folder where you want the transcripts to be saved. Need help customizing? Contact me for consulting and support or add me on Linkedin.

+4

Create Professional Email Drafts with GPT-4, Telegram & Contact Database

Transform your email workflow with this intelligent automation that drafts professional emails through Telegram commands using AI and contact retrieval. Key Features 📱 Telegram Integration: Send email requests directly from Telegram 🤖 AI-Powered Email Generation: Uses OpenAI GPT-4 to create formal, professional emails 📧 Smart Contact Retrieval: Leverages Pinecone vector database with RAG to automatically find recipient email addresses ✉️ Gmail Draft Creation: Automatically creates email drafts in your Gmail account 📋 Google Docs Integration: Sync contact data from Google Docs to vector database 🎯 Structured Email Formatting: Ensures consistent professional email format with proper recipients and formal tone How It Works Send Message: Send a message via Telegram with your email request AI Processing: AI agent processes your request and queries the contact database to find recipient emails Email Generation: OpenAI generates a professionally formatted email based on your input Draft Creation: Gmail draft is automatically created with the formatted content Confirmation: Receive confirmation via Telegram with a completion sticker Perfect For Business professionals managing multiple contacts Academic professionals (professors, researchers) who frequently send formal emails Anyone wanting to streamline their email creation process with AI assistance Required Credentials Telegram Bot API OpenAI API google OAuth2 for(gmail&docs) Pinecone Vector Database Setup Instructions Load Contact Data: Add your contact information to the Google Docs document Configure Pinecone: Set up your Pinecone index with namespace "contacts" Connect Services: Add all required API credentials to their respective nodes Customize AI: Modify the AI system message and sender name in the AI Agent node Test Workflow: Run the manual trigger to populate your vector database first ** Ex. of the google docs data

+2

AI-Powered Sales Assistant with Airtable CRM, Gmail and Web Research

Overview of the n8n Workflow This n8n workflow automates sales processes using AI agents integrated with Airtable as a CRM and Gmail for email handling. It consists of two main workflows: one for handling Airtable status changes to send automated emails, and another for processing incoming emails to add new leads to the CRM or respond to existing leads/clients. The agents personalize emails, research leads via web searches, update CRM notes, and include human approval for responses. Sticky Notes: Setup and Customization Guidance The workflows include sticky notes with Markdown formatting for key instructions (assume these are added to the cloned workflows): Editable Fields (Airtable and Gmail Credentials) Editable Fields Update Airtable base ID and table ID in trigger/search nodes to match your CRM. Set Gmail credentials for triggers and email nodes. Editable Fields (API Keys and Models) Editable Fields Replace Tavily API key in HTTP request nodes with your own (sign up at tavily.com). Update OpenAI model in chat model nodes if needed (e.g., to gpt-4o). Editable Fields (Google Docs Templates) Editable Fields Replace Google Docs URLs in document nodes with your own templates for each status/email type. Ensure Google Docs credentials have read access. How to Set Up the Workflow To use these workflows in n8n (setup time: ~10-15 minutes): Import the JSONs: Paste the provided JSON into n8n to create the two workflows ("Airtable sales agent" and "Email sales Agent"). Configure Credentials: Airtable: Add API token credentials for your base. Gmail: Set up OAuth2 credentials for your email account. OpenAI: Add API key for chat models. Google Docs: Set up OAuth2 credentials with read access to your templates. Update Editable Fields: In Airtable nodes: Set your base ID and table ID. In HTTP nodes: Replace Tavily API key. In Google Docs nodes: Update URLs to your email templates/knowledge base. No need to rebuild nodes; all are pre-configured. Activate Workflows: Enable the triggers and test with sample data. Potential Customizations Change Status Templates**: Add more switch outputs and Google Docs nodes for additional Airtable statuses. Adjust AI Prompts**: Modify system messages in AI Agent nodes for different personalization or response styles. Replace Search API**: Swap Tavily HTTP requests with another search tool if preferred. Add More Tools**: Extend the AI Agent with additional tools for CRM updates or integrations. Considerations and Improvements API Limits**: Monitor Tavily and OpenAI usage to avoid rate limits; add waits if needed. Error Handling**: Add IF nodes for cases like no matching lead or failed searches. Data Privacy**: Ensure sensitive lead data in Airtable and emails complies with regulations. Testing**: Use test emails and Airtable records to verify before going live. Conclusion These n8n workflows create an efficient AI-powered sales system, automating lead addition, CRM updates, and email communications with minimal setup. They integrate seamlessly with Airtable and Gmail, allowing focus on high-value tasks. Customize as needed via the editable fields outlined.

Automate Marketing Agency Client Onboarding: Typeform to GDrive + OpenAI Research

Who's it for Marketing agencies, digital agencies, and freelancers who need to streamline their client onboarding process and create consistent, professional documentation for new clients. Perfect for teams handling multiple client intakes who want to save hours of manual setup work while maintaining quality standards. What it does This workflow automates the entire client onboarding journey from the moment a prospect fills out your Typeform intake questionnaire. It instantly creates a complete Google Drive folder structure with 6 main folders and 15+ subfolders tailored for marketing projects, sends the intake information to your team via Slack, generates an AI-powered marketing research brief using OpenAI, implements an approval workflow with revision capabilities, and delivers a professional welcome email to the client. The system ensures nothing falls through the cracks while maintaining consistent quality across all client projects. How it works Intake Trigger: When a client submits your Typeform intake form, the workflow automatically initiates Folder Creation: Creates a branded client folder in Google Drive with organized subfolders for ads, raw footage, product images, research, drafts, and archives Team Notification: Posts detailed intake responses to your designated Slack channel for immediate team visibility AI Brief Generation: Uses OpenAI to analyze intake responses and generate a comprehensive marketing research document including customer personas, pain points, positioning strategies, and marketing angles Approval Process: Sends the brief for team review with built-in approve/revise functionality Document Creation: Upon approval, creates a Google Doc with the finalized research brief Client Communication: Sends a personalized welcome email to the client confirming their onboarding How to set up Configure the workflow: Start by filling in all values in the "⚙️ Configuration" node: Your Typeform ID from your intake form Google Drive parent folder ID where client folders will be created Slack channel IDs for new client notifications and internal reviews OpenAI model preference (GPT-4 recommended) Welcome email template with your agency branding Connect your accounts: Typeform: Create credentials and connect your account Google: Authenticate with Drive, Docs, and Gmail permissions Slack: Add the n8n bot to your workspace and relevant channels OpenAI: Add your API key for AI content generation Test the workflow: Submit a test entry through your Typeform Verify folder creation in Google Drive Check Slack notifications are posting correctly Confirm the approval process works as expected Requirements Typeform** account with a client intake form created Google Workspace** account with Drive, Docs, and Gmail access Slack** workspace with appropriate channels created OpenAI API** key with credits for content generation n8n** instance (self-hosted or cloud) version 1.0+ How to customize the workflow Folder Structure**: Modify the subfolder nodes to match your agency's project organization needs Intake Fields**: Update the Slack message blocks and AI prompt to match your specific Typeform fields Research Brief Template**: Customize the OpenAI prompt to generate briefs aligned with your agency's format Approval Logic**: Add additional approval stages or skip approval for certain client types Welcome Email**: Personalize the email template with your branding, links, and next steps Notification Channels**: Route different types of notifications to specific Slack channels based on client tier or project type

Analyze Weekly Notes with GPT-4 for Actionable Tasks & Summaries

This n8n template demonstrates how to automatically analyze all your accumulated notes from the past week and generate actionable insights, task lists, and priorities using AI. Use cases are many: Try automating weekly planning sessions, extracting action items from meeting notes, identifying recurring themes in your thoughts, or creating data-driven weekly reports for personal productivity tracking! Good to know ChatGPT analysis costs approximately $0.01-0.05 per week depending on the volume of notes The workflow uses advanced date filtering to process exactly 7 days of content Email sending requires SMTP configuration (Gmail, Outlook, etc.) Perfect companion:* Works seamlessly with the "Audio Notes to Google Docs*" workflow - it reads and analyzes all notes created by that system! How it works A schedule trigger runs every Sunday at your preferred time (default: 11 PM) The workflow reads your complete Google Doc containing all accumulated notes A smart filter function extracts only entries from the past 7 days using date stamp recognition The filtered content gets sent to ChatGPT which analyzes patterns and extracts: Actionable tasks for next week Important deadlines and appointments Key insights and learnings Top 3 priorities Category distribution (Work, Private, Health, etc.) A second AI call creates a personalized email summary with context and recommendations The structured analysis gets appended to your Google Doc as a weekly summary You receive a Telegram notification when the review is complete A detailed email report lands in your inbox with the full analysis and action items How to use The workflow runs automatically every Sunday - no manual intervention needed Adjust the schedule trigger to your preferred day/time for weekly planning Review the email summary and use the extracted tasks for your upcoming week planning The Google Doc serves as your permanent archive of weekly insights Requirements Google Docs API access to read your notes document OpenAI API account for ChatGPT analysis (GPT-4 recommended for best results) SMTP email configuration for sending summary reports Telegram Bot Token for notifications Prerequisite:* The "Audio Notes to Google Docs*" workflow or similar system that creates timestamped entries Customising this workflow Modify the AI analysis prompt to focus on specific areas (business metrics, health tracking, learning goals) Add multiple analysis modes (daily, bi-weekly, monthly reviews) Include additional outputs like calendar event creation, task manager integration, or team sharing Connect to project management tools like Notion, Asana, or Monday.com for automatic task creation

Generate AI-Powered Sales Proposals from JotForm Leads with OpenAI and Google Docs

⚙️ Proposal Generator Template (Automates proposal creation from JotForm submissions) 🧑‍💻 Author: [LeeWei] 🚀 Steps to Connect: JotForm Setup Visit JotForm to generate your API key and connect to the JotForm Trigger node. Update the form field in the JotForm Trigger node with your form ID (default: 251206359432049). Google Drive Setup Go to Google Drive and set up OAuth2 credentials ("Google Drive account") with access to the folder containing your template. Update the fileId field in the Google Drive node with your template file ID (default: 1DSHUhq_DoM80cM7LZ5iZs6UGoFb3ZHsLpU3mZDuQwuQ). Update the name field in the Google Drive node with your desired output file name pattern (default: ={{ $json['Company Name'] }} | Ai Proposal). OpenAI Setup Visit OpenAI and generate your API key. Paste this key into the OpenAI and OpenAI1 nodes under the "OpenAi account 3" credentials. Update the modelId field in the OpenAI1 node if needed (default: gpt-4.1-mini). Google Docs Setup Set up OAuth2 credentials ("Google Docs account") with edit permissions for the generated documents. No fields need editing as the node dynamically updates based on previous outputs. Google Drive2 Setup Ensure the same Google Drive credentials ("Google Drive account") are used. No fields need editing as the node handles PDF conversion automatically. Gmail Setup Go to Gmail and set up OAuth2 credentials ("Gmail account"). No fields need editing as the node dynamically uses the prospect's email from JotForm. How it works The workflow triggers on JotForm submissions, copies a Google Drive template, downloads an audio call link, transcribes it with OpenAI, generates a tailored proposal, updates a Google Docs file, converts it to PDF, and emails it to the prospect. Set up steps Setup time: Approximately 15-20 minutes. Detailed instructions are available in sticky notes within the workflow.

Generate Weekly Document Digests from Google Docs with GPT-4 and Email Delivery

📄 AI Summarize Weekly Google Docs Updates → Send Email This workflow automatically reviews selected Google Docs every week, checks for updates, and generates a professional weekly summary email using AI. It’s perfect for keeping your team or leadership informed without manually digging through multiple documents. ⚙️ How It Works Weekly Monday 9AM Trigger A Cron node runs every Monday at 9 AM (adjustable). Ensures summaries arrive at the start of the workweek. Prepare Docs List A Code node defines which Google Docs to monitor. Includes doc IDs, names, and categories (e.g., Projects, Meetings, Updates). Sets a 7-day date range for updates. Fetch Google Docs & Metadata Retrieves document content and metadata (last modified, user, version). Filters only docs that have been updated in the past week. Process Doc Data Extracts plain text content from Google Docs. Cleans and normalizes text for summarization. Collects key details: word count, modified by, last updated date. Aggregate Updated Docs Gathers all updated docs into one combined content block. Prepares context for the AI model to create a weekly digest. Generate AI Summary Uses GPT-4 to generate a business-style weekly summary. Includes: Executive summary Key updates by document Important changes Action items Next week’s focus Prepare Email Content Formats the AI response into both plain text and HTML email. Adds a list of updated documents with last modified info. Send Summary Email Sends the final summary to the configured team emails via Gmail. Subject line includes the date range for easy reference. 🛠️ Setup Steps Google Docs Setup Add document IDs in the Prepare Docs List node. Enable the Google Drive API in your Google account. Connect Google OAuth credentials in n8n. OpenAI API Key Get your key from platform.openai.com. Add it to your n8n credentials. Uses GPT-4 for high-quality summaries. Email Recipients Update the Gmail node with your team’s email addresses. Customize the subject line and template if needed. Schedule Default: Every Monday at 9 AM. Adjust the Cron node if you prefer a different time. 📧 Example Output Subject: 📄 Weekly Document Updates Summary – 08/22/2025 – 08/29/2025 Body (excerpt): Dear Team, Here's your weekly document updates summary: Executive Summary: Project Status Doc updated with new timelines. Meeting Notes highlight three key decisions from leadership. Team Updates document includes two new hires and onboarding tasks. Key Updates by Document: • Project Status Doc (Projects) - Updated by Alice on 08/27 • Meeting Notes (Meetings) - Updated by Bob on 08/28 • Team Updates (Updates) - Updated by Sarah on 08/29 Action Items: Confirm revised project deadlines. Follow up on onboarding checklist. This summary was automatically generated by your n8n workflow. ⚡ With this workflow, you’ll never miss important document changes — your team gets a clear, AI-generated weekly digest straight in their inbox.

Generate Professional Zoom Meeting Summaries with GPT-4O and Google Docs

How it Works This automated workflow transforms Zoom meeting emails into professional summaries and Google Docs. It monitors your Gmail for Zoom meeting notification emails, extracts meeting content using AI-powered analysis, and generates both email-safe HTML summaries and Google Docs-compatible text. The workflow intelligently parse meeting transcripts, creating structured summaries with attendee lists, key discussion points, action items, and next steps. It automatically creates Google Docs for record-keeping and sends formatted email summaries to meeting participants. Who is it For Perfect for project managers, team leads, executives, and meeting coordinators who regularly conduct Zoom meetings and need consistent, professional documentation. Ideal for organizations that require structured meeting records, action item tracking, and seamless integration between communication tools. Especially valuable for distributed teams, consulting firms, and corporate environments where meeting accountability and follow-up are critical. Benefits for Using this Workflow Time Savings**: Eliminates 30-60 minutes of manual meeting summary creation per meeting. Professional Consistency**: Ensures all meeting summaries follow the same structured format with headers, attendees, discussion points, and action items. Automated Documentation**: Creates searchable Google Docs archives and distributes summaries without manual intervention. Enhanced Accountability**: Clear action item tracking with assignees and deadlines improves follow-through. Multi-Format Output**: Provides both email-friendly HTML and plain text formats for maximum compatibility across different platforms and systems. Setup Requirements Prerequisites**: Active n8n instance, Gmail account, Google Docs access, OpenAI API key. Required Credentials**: Configure Gmail OAuth2 for both trigger and sending, Google Docs OAuth2 for document creation, OpenAI API for GPT-4 processing. Configuration Steps**: 1) Import workflow and activate Gmail trigger with filter for Zoom meeting emails, 2) Set up Google Drive folder permissions for document creation, 3) Configure OpenAI credentials and verify AI agent tools connection, 4) Test workflow with a sample Zoom email to ensure proper formatting and delivery. Optional Customization**: Modify Gmail search filters, adjust Google Docs folder location, customize email templates, or fine-tune AI prompt for specific meeting formats.

Cost-Free Email Follow-Up Sequence with Google Sheets and Gmail

Simple But Powerful Email Automation for Everyone: No AI, No API Costs! This n8n workflow template, "Email Outreach Automation," is designed to help you set up an automated email outreach system using tools you might already be familiar with: Google Sheets and Google Docs. At its core, this workflow is a sequence of steps that n8n follows to send personalized emails to a list of contacts. The best part? It's built to be incredibly cost-effective, meaning you won't need to pay for any external API services or AI subscriptions to make it work. This makes it an ideal starting point for anyone new to automation or looking to manage their budget. How Does This Workflow Work? Think of this n8n workflow as a digital assistant that handles your email outreach from start to finish. Here's a simplified breakdown of what happens behind the scenes: Your Contact List (Google Sheet): The workflow starts by reading your contact information (like names, emails, and company details) from a Google Sheet. This is where you'll keep all the people you want to email. Email Content (Google Docs): Instead of writing each email individually, you'll create email templates in Google Docs. The workflow can then pull the content from these documents and personalize it for each recipient. This means you can use placeholders like {{firstname}} or {{company}} in your Google Doc, and the workflow will automatically replace them with the correct information for each person. Smart Email Sequencing: The workflow is designed to send a series of emails to each contact. It keeps track of which email was sent last to each person in your Google Sheet. This ensures that your contacts receive the emails in the correct order and don't get the same email twice. Sending Emails (Gmail or SMTP): Once the workflow has the contact's details and the personalized email content, it uses your Gmail account (or any other SMTP service you configure) to send the email. It even includes a built-in delay to avoid hitting email sending limits. Updating Your Records: After sending an email, the workflow updates your Google Sheet to record which email was sent and when. This helps you keep track of your outreach efforts and ensures that contacts who have completed the email sequence are not emailed again. Key Features for Beginners: No Coding Required:** While n8n involves visual programming, you don't need to write complex code to use this workflow. It's pre-built and ready for you to configure with your Google Sheet and Google Doc IDs. Free to Use (No Hidden Costs):** This is a major advantage! Unlike many other email automation tools that charge per email or require expensive API keys, this workflow leverages free services. You can run your campaigns without worrying about unexpected bills. Easy Configuration:** The workflow includes a "Settings" node where you can easily input your Google Sheet and Google Doc IDs, as well as your email subjects. This centralizes all your important settings in one place. Built-in Safeguards:** Features like the "Filter passes only unprocessed contacts" and "Has contact completed email sequence?" nodes ensure that you only email the right people at the right time, preventing accidental re-sends. Scalable:** As you get more comfortable, you can easily expand this workflow to handle more contacts or more complex email sequences. It's a great foundation for learning more about automation. What You'll Need to Get Started: An n8n instance (you can run it locally, use a cloud provider, or n8n.cloud) A Google account (for Google Sheets and Google Docs) A Gmail account (or SMTP credentials for sending emails) This workflow is your entry point into efficient and affordable email automation. It's designed to be straightforward for beginners while offering powerful capabilities. Get ready to automate your outreach and see the results! Setup Guide: Sample Google Doc Sample Google Sheet Need Help? Reach me: https://www.linkedin.com/in/gerald-akhidenor-1ab1a45/ Work with me: https://dominixai.com/ My website: https://jobmonkey.dev My email: [email protected] This guide will walk you through the process of setting up and running the Email Outreach Automation. This powerful workflow allows you to automate personalized email campaigns using n8n, Google Sheets, and Google Docs, all without incurring any API or AI subscription costs. Follow these steps to get your automated outreach up and running. Prerequisites Before you begin, ensure you have the following: An n8n Instance:** This can be a local installation, a self-hosted server, or an n8n.cloud account. If you don't have one, you can find installation instructions on the official n8n website [1]. A Google Account:** You will need this to create and manage your Google Sheets (for contacts) and Google Docs (for email templates). A Gmail Account (or SMTP Credentials):** This workflow uses Gmail by default for sending emails. If you prefer to use another email service, you will need its SMTP credentials. Step 1: Import the Workflow into n8n Download the Workflow: Ensure you have the EmailOutreachAutomation.json file downloaded to your computer. Open n8n: Log in to your n8n instance. Import: In the n8n dashboard, click on the "Workflows" tab in the left sidebar. Then, click the "New" button (or the + icon) and select "Import from JSON". Upload the File: A dialog box will appear. Click "Browse" or drag and drop the EmailOutreachAutomation.json file into the designated area. Click "Import". Save the Workflow: Once imported, the workflow will open in the editor. Click the "Save" button (usually located in the top right corner) to save your new workflow. Step 2: Prepare Your Google Sheet for Contacts This workflow uses a Google Sheet as your contact database. You need to create a new Google Sheet and populate it with your contact information. The workflow expects specific column headers to function correctly. Create a New Google Sheet: Go to Google Sheets (sheets.google.com) and create a new blank spreadsheet. Name Your Sheet: Give your spreadsheet a descriptive name (e.g., "JobMonkey Email List"). Add Required Columns: In the first row of your sheet, add the following column headers exactly as they appear below (case-sensitive): firstname lastname email company last_email_sent (This column will be updated by the workflow to track the last email sent to each contact. Leave it blank initially.) last_email_date (This column will be updated by the workflow with the date the last email was sent. Leave it blank initially.) processed (This column will be updated by the workflow to mark contacts as processed. Leave it blank initially.) Populate with Data: Fill in your contact data under the respective columns. Ensure the email column contains valid email addresses. Get Your Google Sheet ID: The Google Sheet ID is part of the URL when you open your spreadsheet. It's the long string of characters between /d/ and /edit. Copy this ID; you will need it in Step 4. Step 3: Prepare Your Google Docs Email Templates This workflow sends a sequence of up to 9 emails. You will create a separate Google Doc for each email in your sequence. The workflow uses placeholders in these documents to personalize the emails. Create New Google Docs: Go to Google Docs (docs.google.com) and create a new blank document for each email you plan to send (e.g., "Email 1 Template", "Email 2 Template", etc.). The workflow is configured for up to 9 emails, but you can use fewer. Write Your Email Content: Write the content for each email in its respective Google Doc. You can use the following variables (placeholders) which the workflow will automatically replace with data from your Google Sheet: {{firstname}} {{lastname}} {{company}} {{email}} Get Your Google Doc IDs: For each Google Doc, copy its ID from the URL. It's the long string of characters between /d/ and /edit. You will need these IDs in Step 4. Step 4: Configure the 'Settings' Node in n8n This is the most crucial step for customizing the workflow. The 'Settings' node holds all the essential IDs and subjects for your campaign. Open the Workflow: In n8n, open the Email Outreach JobMonkey copy workflow you imported. Locate the 'Settings' Node: Find the node named "Settings" (it's usually near the top, connected to the 'Schedule Trigger'). Double-click it to open its configuration. Update 'googlesheetid': Find the assignment named googlesheetid. Replace the existing value with the Google Sheet ID you copied in Step 2. Update 'googledocid_X' and 'emailsubject_X': For each email in your sequence (e.g., googledocid_1, googledocid_2, etc.), replace the value with the corresponding Google Doc ID you copied in Step 3. Similarly, for each emailsubject_X, update the value with the subject line you want for that specific email. Close the 'Settings' Node: Click "Done" or close the node configuration. Step 5: Configure Email Sending Credentials (Gmail or SMTP) The workflow uses a 'Send a message' node (Gmail node) to send emails. You need to provide your Gmail credentials or configure an SMTP service. Option A: Using Gmail (Recommended for Simplicity) Locate the 'Send a message' Node: Find the node named "Send a message" (it's a Gmail node) in the workflow. Double-click it. Add Gmail Account: Under the 'Credentials' section, click "Add new" next to gmailOAuth2. Connect to Google: A new window will open, prompting you to connect your Google account. Follow the on-screen instructions to grant n8n access to send emails on your behalf. Select the Gmail account you wish to use for sending. Save Credentials: Once connected, save the credentials. Close the Node: Click "Done" or close the node configuration. Option B: Using an SMTP Service (Advanced) If you prefer to use a different email service via SMTP: Replace the 'Send a message' Node: Delete the existing "Send a message" (Gmail) node. Add a New SMTP Node: Search for and add an "SMTP" node to your workflow. Connect it in place of the deleted Gmail node. Configure SMTP Credentials: Double-click the new SMTP node. You will need to provide your SMTP host, port, username, and password. Consult your email provider's documentation for these details. Map Fields: Ensure the To, Subject, and Message fields in the SMTP node are correctly mapped to the data coming from the previous nodes (e.g., ={{ $(\'Loop Over Items\').item.json.email }} for the recipient email, ={{ $(\'Settings\').item.json[\'emailsubject_\' + $(\'Determine Email Number\').item.json.emailNumber] }} for the subject, and ={{ $json.html }} for the message body). Close the Node: Click "Done" or close the node configuration. Step 6: Configure the Schedule Trigger (Optional but Recommended) The 'Schedule Trigger' node determines when your workflow will run automatically. By default, it's set to run at 6 AM, 12 PM, and 6 PM. Locate the 'Schedule Trigger' Node: Find the node named "Schedule Trigger" (it's the very first node in the workflow). Double-click it. Adjust Schedule: You can modify the schedule to fit your needs. For example, to run daily at 9 AM, you would set the hour to 9. Close the Node: Click "Done" or close the node configuration. Step 7: Activate and Test Your Workflow Once all configurations are complete, it's time to activate and test your workflow. Activate the Workflow: In the top right corner of the n8n editor, toggle the "Active" switch to ON. Test Manually (Optional but Recommended): To perform a test run without waiting for the schedule, click the "Execute Workflow" button (usually a play icon) in the top right corner. This will run the workflow once. Monitor Execution: After execution, check the 'Executions' tab in n8n to see the status of your workflow runs. You can also check your Google Sheet to see if the last_email_sent and processed columns have been updated, and check your email outbox to confirm emails were sent. Important Considerations Email Sending Limits:** Be aware of the sending limits of your email provider (e.g., Gmail has a daily sending limit). The workflow includes a 'Wait' node to help space out emails, but adjust it (amount parameter in the 'Wait' node) if you encounter issues. Google API Quotas:** While this workflow avoids paid API subscriptions, Google services do have free usage quotas. For very high volumes, you might eventually hit these, but for typical outreach, this should not be an issue. Error Handling:** The workflow has basic error handling. If you encounter issues, check the 'Executions' tab in n8n for error messages, which can help you diagnose problems. Customization:** Feel free to explore and customize other nodes in the workflow as you become more familiar with n8n. For example, you can adjust the 'Limits the number of emails per run' node to control how many emails are sent in each execution. By following these steps, you will have a fully functional, automated email outreach system that is both powerful and cost-effective. Happy automating!

+2

Generate Comprehensive Financial Reports with GPT-4 Analysis and Anomaly Detection

How It Works ⚙️ Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated system does for you, turning raw financial chaos into crystal-clear insights. Automated Data Gathering (The Collector): What happens: The system automatically connects to your bank accounts, investment platforms, and accounting software (like QuickBooks or Xero) on a schedule you define (e.g., daily, weekly). It pulls in all your latest financial data – every transaction, income, expense, and investment update. Data In: Transaction descriptions, amounts, dates, investment details, income/expense categories (if available). AI-Powered Data Cleaning & Categorization (The Organizer & Detective): What happens: Once collected, the data is sent to our first two AI brains. AI Agent 1 (The Categorizer): Reads through every transaction description and intelligently assigns it to a standard financial category (e.g., "Dining," "Groceries," "Utilities," "Software Subscriptions"). No more manual tagging! AI Agent 2 (The Anomaly Detector): Scans the categorized data for anything unusual – a transaction amount that's too high, a potential duplicate entry, or any suspicious activity. It flags these items immediately. Data Out: Clean, categorized transactions, flagged anomalies with reasons. Deep Financial Analysis & Insight Generation (The Strategist): What happens: With clean data in hand, specialized AI agents get to work on the strategic analysis: AI Agent 3 (Spending Pattern Analyst): Identifies your key spending trends over time. Are you spending more on certain categories? Where can you save? AI Agent 4 (Investment Performance Insight): Reviews your investment gains and losses and gives you a clear picture of your portfolio's health. AI Agent 5 (Overall Financial Health Assessor & Recommender): This top-tier AI synthesizes ALL the insights. It provides a concise summary of your overall financial health and, critically, gives you 3-5 clear, actionable recommendations on how to improve your finances or capitalize on opportunities. Data Out: Analysis summaries, spending insights, investment performance notes, overall financial health assessment, and precise recommendations. Automated Reporting & Smart Alerts (The Communicator): What happens: All the AI-generated insights are automatically compiled into a professional financial report. This report populates a pre-designed Google Docs template, making it look polished and ready for review. Immediate Alerts: If AI Agent 2 flagged any anomalies, you get an instant notification (e.g., via Slack) so you can investigate immediately. Report Delivery: The full report is automatically sent to your email inbox, and a summary notification is sent to your team's Slack channel. Outcome: You receive regular, detailed, and actionable financial reports without lifting a finger, always staying informed and ahead. Setup Steps 🛠️ Building this powerful system is simpler than you might think. Here’s your step-by-step guide: Prepare Your Digital Foundation: Financial Data Access: Figure out how you'll get your raw data. For APIs (Recommended): If your bank, investment platform, or accounting software has an API (like Plaid, QuickBooks, Xero), get your API keys and understand their basic HTTP Request structure. For CSVs: If you download CSV statements, ensure they have consistent formats (Date, Description, Amount at minimum). You'll use CSV Read nodes instead of HTTP Request. Google Sheets Database: Create two separate Google Sheets in your Google Drive: "Raw Financial Data" Sheet: This sheet will store all the untouched data collected from your sources. Set up columns like Date, Description, Amount, Source, Transaction Type, Asset, etc. "Categorized Financial Data" Sheet: This sheet will store the data after it's been cleaned and categorized by the AI. Add columns for Category, Is Flagged, Flag Reason, alongside the raw data columns. Financial Report Template (Google Docs): Create a new Google Doc that will be your professional report template. Design it how you want your final report to look. Insert clear placeholders like {{ report_title }}, {{ executive_summary }}, {{ spending_analysis }}, {{ overall_assessment_recommendations }}, etc., where the AI content will go. Crucially, copy the Document ID from the URL of this template. Get Your API Keys & Credentials: OpenAI API Key: This is essential for all the AI brains. Get it from your OpenAI account. Google Sheets Credentials: You'll need to create an OAuth2 credential in n8n to link to your Google Sheets. Gmail Credentials: For sending the final reports. Set up an OAuth2 credential. Slack Credentials: If you want alerts and notifications. Get a Bot Token from your Slack app settings. (Optional) Other API Keys: If you're using specific financial APIs (e.g., Plaid, QuickBooks), gather their respective API keys and authentication details. Import the n8n Workflow: We've provided the detailed node structure in previous responses. You'll translate that into an n8n workflow by adding each node manually and connecting them as described. This gives you full control and understanding! Connect Your Tools (N8n Credentialing & Linking): Go to each node in your n8n workflow that requires a credential (e.g., OpenAI, Google Sheets, Gmail, Slack, HTTP Request). Select the credential you created in Step 2. This links n8n to your external services. Customize Your Workflow Nodes (The Smart Part!): Cron Node (Node 1): Set your desired Schedule (e.g., "Every 1 Day" for daily reports, or "Every 1 Week" for weekly). HTTP Request Nodes (Nodes 2, 3, 4): Paste the exact URLs for your financial APIs. Configure the Method (GET/POST) and Authentication type (e.g., "Header Auth," "OAuth2") specific to each API. If using CSVs: Replace these nodes with CSV Read nodes and point them to your CSV file paths. Google Sheets Nodes (Nodes 7, 8, 13, 14): Paste the Spreadsheet IDs for your "Raw Financial Data" and "Categorized Financial Data" sheets. Ensure the Sheet Name is correct (e.g., "Sheet1" or "Transactions"). Crucially, map the Values correctly so that the data goes into the right columns in your sheets. OpenAI Nodes (Nodes 10, 11, 16, 17, 18): This is the most powerful part! Carefully review and refine the Prompts within these nodes. Tailor the categories for AI Agent 1, specify what counts as an "anomaly" for AI Agent 2, and ensure the tone and focus of recommendations from AI Agent 5 match your needs. Test these prompts extensively! Google Docs Node (Node 20): Paste your Template Document ID from Step 1. Map the Values from your consolidated AI insights ({{ $json.report_title }}, etc.) to the placeholders you created in your Google Doc template. Slack Nodes (Nodes 22, 24): Enter the specific Chat IDs (channel IDs) for where you want anomaly alerts and general report notifications to appear. Test & Activate! Run Manual Tests: Before activating, manually trigger the workflow a few times. Check each node's output to ensure data is flowing correctly and AI agents are generating the expected results. Activate: Once you're confident everything is working, click the "Inactive" toggle in the top-right corner of your workflow to set it live. Congratulations! You've just built a sophisticated, AI-powered financial analysis and reporting system that will bring unprecedented clarity and control to your finances.

+9

Generate Platform-Optimized Social Media Content Across 6 Platforms with GPT-4o

Who’s it for This workflow is ideal for marketers, content creators, agencies, and small businesses that want to streamline the process of creating and publishing platform-optimized posts across multiple social media channels. How it works / What it does From a single user prompt, the workflow uses a custom system prompt and schema to generate tailored social media content for LinkedIn, Instagram, Facebook, Twitter (X), Threads, and YouTube Shorts. It creates platform-specific captions, hashtags, calls to action, and even AI-generated image suggestions, then routes the content to the correct publishing channel. How to set up Connect your social media platform credentials in n8n. Add your Google Docs links for the system prompt and content schema. Configure the IMGBB_API_KEY and any other required API credentials. Optionally connect Gmail and Telegram for approval workflows and notifications. Requirements n8n instance (self-hosted or cloud) API credentials for desired platforms Google Docs and Google Drive accounts How to customize the workflow Edit the system prompt and schema in Google Docs to adjust tone, style, and content format for each platform. Modify routing logic or add new platform integrations as needed.

Transform Meeting Transcripts into LinkedIn Content with AI and Google Docs

🎯 Universal Meeting Transcript to LinkedIn Content Automatically transform your meeting insights into engaging LinkedIn content with AI Perfect for coaches, consultants, sales professionals, and content creators who want to share valuable insights from their meetings without the manual effort of content creation. How it works Calendar trigger detects when your coaching/meeting ends Waits for meeting completion, then sends you a form via email You provide the meeting transcript and specify post preferences AI analyzes the transcript using your personal brand guidelines Generates professional LinkedIn content based on real insights Creates organized Google Docs with both transcript and final post Sends you links to review and publish your content How to use Connect your Google Calendar and Gmail accounts Update the calendar filter to match your meeting types Customize the AI prompts with your brand voice and style Replace email addresses with your own Test with a sample meeting transcript Requirements Google Calendar (for meeting detection) Gmail (for form delivery and notifications) Google Drive & Docs (for content storage) LangChain AI nodes (for content generation) Good to know AI processing may incur costs based on your LangChain provider Works with any meeting platform - just copy/paste transcripts Can be adapted to use webhooks from recording tools like Fireflies.ai Memory nodes store your brand guidelines for consistent output Happy Content Creating!

Generate and Send Contract Documents with Typeform, Google Docs and Gmail

This workflow is designed for teams or freelancers who want to auto-generate and send contracts based on information gathered from a Typeform (e.g., client name, project scope, deadlines). Perfect for HR onboarding, client agreements, or legal operations. Prerequisites To use this workflow, you’ll need: A Typeform account and a published form Access to Google Docs (or use a local document template) Gmail or SMTP email integration in n8n n8n Desktop or a hosted n8n instance How It Works Trigger:** Listens for new Typeform submissions. Extract Data:** Parses the answers from the form. Generate Contract:** Fills a contract template using form inputs. Create PDF:** Exports the filled contract as a PDF. Send Email:** Sends the PDF to the client’s email address provided in the form. Nodes Used Typeform Trigger** – Triggers on form submission. Set Node** – Maps form answers into variables. Google Docs (or HTTP Request)** – Uses a template to generate the contract. Google Drive / PDF Converter** – Converts to PDF (if needed). Email (Gmail/SMTP)** – Sends the completed contract to the recipient. Tips Replace the Google Docs template ID with your own. Ensure the variable placeholders (like {{client_name}}) match your document. Use the Cron node instead of Typeform Trigger if you want to poll periodically.

+5

Automate RSS to Medium Publishing with Groq, Gemini & Slack Approval System

This n8n template demonstrates how to build a complete AI-powered content pipeline that pulls fresh news from RSS feeds, transforms it into engaging Medium articles. Categories Content Creation AI Automation Publishing Social Media Share Yes, this n8n workflow is straight FIRE for content creators who want to automate their entire publishing game! 🔥 This template creates a complete content pipeline that pulls fresh tech news from RSS feeds, transforms it into engaging Medium articles using AI, generates matching cover images, and handles the entire approval-to-publishing process through Slack integration. Good to know Uses multiple AI models (Groq, Google Gemini) for content generation Integrates with Medium publishing API for automated posting Includes smart duplicate checking via Google Sheets Generates professional cover images using Pollinations AI Full Slack approval workflow with human oversight Automatic storage and organization in Google Drive How it works RSS Content Fetching Pulls fresh content from The Verge, TechCrunch, and Ars Technica RSS feeds on a 6-hour schedule Smart filtering ensures only new, unposted articles are processed AI Content Generation Groq and Google Gemini models transform RSS content into engaging Medium-style articles Automatic image prompt generation creates relevant cover visuals Pollinations AI generates professional marketing-style images Smart Review & Approval Creates Google Doc with formatted article for easy review Sends preview to Slack channel/DM for human approval Waits for explicit approval before publishing Multi-Platform Publishing Auto-publishes to Medium upon approval Sends formatted content via Gmail Stores everything in Google Drive for archiving Updates Google Sheets to prevent duplicates Rejection Handling Clean rejection notifications via Slack No publishing if content doesn't meet standards Key Features That'll Blow Your Mind Zero-Duplicate Publishing**: Smart Google Sheets integration tracks all published content Human-in-the-Loop**: Slack approval system keeps quality control tight Full AI Pipeline**: From RSS parsing to image generation, everything's automated Multi-Source Content**: Aggregates from top tech news sources Professional Formatting**: Articles come out Medium-ready with proper structure Cloud Storage**: Everything gets archived in Google Drive automatically Email Distribution**: Auto-sends content to your mailing list How to use Clone this workflow and connect your credentials Set up your Google Sheets tracking document Configure Slack notifications for your approval channel Add your Medium API credentials for publishing The schedule trigger runs every 6 hours, but you can adjust timing Manual trigger available for testing and one-off runs Requirements Google Workspace**: Sheets, Docs, Drive, Gmail access Slack Workspace**: For approval notifications and review Groq API**: For AI content generation Google Gemini API**: For image prompt creation Medium API**: For automated publishing Pollinations**: Free AI image generation (no API key needed) Customizing this workflow This isn't just another automation—it's your new content creation superpower. Here's how to make it yours: Switch RSS Sources**: Replace tech feeds with your niche (finance, health, etc.) Modify AI Prompts**: Adjust the content generation style to match your brand voice Change Publishing Destinations**: Swap Medium for WordPress, Ghost, or other platforms Add More Approval Steps**: Include multiple reviewers or different approval criteria Customize Image Generation**: Modify prompts for different visual styles Schedule Flexibility**: Adjust timing from 6 hours to daily, weekly, whatever fits Pro Tips: The workflow includes comprehensive error handling and logging Sticky notes provide detailed documentation for each section Modular design makes it easy to swap components Built-in duplicate prevention saves you from embarrassing reposts This template is perfect for content creators, digital marketers, tech bloggers, and anyone who wants to scale their content game without losing quality control. It's like having a full content team working 24/7, but smarter and way more consistent. Use cases that work incredibly well: Tech blog automation for agencies News aggregation and commentary sites Personal brand content scaling Client content creation workflows Multi-platform publishing systems

Google Docs and Gmail integration

How to connect Google Docs and Gmail

Step 1: Create a new workflow and add the first step

Step 2: Add and configure Google Docs and Gmail nodes

Step 3: Connect Google Docs and Gmail

Step 4: Customize and extend your Google Docs and Gmail integration

Step 5: Test and activate your Google Docs and Gmail workflow

✨🩷Automated social media content publishing factory + system prompt composition

Popular Google Docs and Gmail workflows