WhatsApp Business Cloud and Google Sheets integration

This workflow is a complete, production-ready solution for recovering abandoned carts in Shopify stores using a multi-channel, multi-touch approach. It automates personalized follow-ups via Email, SMS, and WhatsApp, tracks every customer interaction for multi-touch attribution, and enables advanced retargeting and analytics. Key features: Multi-step, timed recovery sequence (Email → SMS → Email → WhatsApp) Customer segmentation (new, returning, VIP) and A/B testing Dynamic discounting and personalized messaging Touchpoint logging to Google Sheets for attribution analysis Facebook Custom Audience retargeting for unrecovered carts Slack notifications for high-value cart recoveries What does this workflow do? Listens for abandoned cart events from Shopify (or any e-commerce platform) via webhook. Normalizes and enriches cart data by fetching full cart details and customer purchase history. Predicts the likely reason for abandonment (e.g., price sensitivity, checkout complexity, technical issues) using rule-based logic. Segments the customer (new, returning, VIP), assigns an A/B test group, and generates a personalized discount and checkout URL. Runs a timed, multi-channel recovery sequence: 1 hour after abandonment: Checks if the order is completed. If not, sends a personalized Email #1 and logs the touchpoint. 4 hours after abandonment: Checks again. If not recovered, sends an SMS with a discount code and logs the touchpoint. 24 hours after abandonment: Checks again. If not recovered, sends Email #2 (with social proof/urgency) and logs the touchpoint. 48 hours after abandonment: Final check. If not recovered, sends a WhatsApp reminder and logs the touchpoint. If the cart is still not recovered: Hashes customer identifiers and adds them to a Facebook Custom Audience for retargeting. Logs every touchpoint (email, SMS, WhatsApp) to a Google Sheet for multi-touch attribution analysis. Sends a Slack notification if a high-value cart is recovered. Why is this workflow useful? Boosts recovery rates:** By using multiple channels and personalized timing, you maximize the chance of recovering lost sales. Improves attribution:** Every customer interaction is logged, so you can analyze which channels and messages drive conversions. Enables advanced retargeting:** Unrecovered carts are automatically added to a Facebook Custom Audience for paid retargeting. Saves time:** Fully automated, with easy configuration for your store, messaging, and analytics. Scalable and extensible:** Easily adapt the sequence, add more channels, or integrate with other tools. How to install and configure Prerequisites n8n instance (v2.0.2+ recommended) Shopify store with API access Accounts and API credentials for: SendGrid (email) Twilio (SMS) WhatsApp Business API Google Sheets (service account) Facebook Graph API (for Custom Audiences) Slack (for notifications) Setup steps Import the workflow into your n8n instance. Configure the “Workflow Configuration” node: Set your Shopify domain, API URLs, Google Sheets ID, and high-value threshold. Connect all required credentials in the respective nodes: Shopify, SendGrid, Twilio, WhatsApp, Google Sheets, Facebook Graph API, Slack. Create a Google Sheet named “Touchpoints” with columns: cart_id, customer_id, touchpoint_type, timestamp, channel, ab_group. Set up the webhook in your Shopify store (or e-commerce platform) to trigger the workflow on cart abandonment. Test the workflow with a sample abandoned cart event to ensure emails, SMS, WhatsApp, and logging work as expected. Enable the workflow in n8n for live operation. Node-by-node breakdown Abandoned Cart Webhook:** Receives abandoned cart events. Workflow Configuration:** Stores global settings (API URLs, Shopify domain, Google Sheets ID, high-value threshold). Normalize Cart Data:** Cleans and standardizes incoming cart data. Fetch Cart Details / Fetch Customer History:** Enriches data with full cart and customer info. Predict Abandonment Reason:** Uses business logic to guess why the cart was abandoned. Personalization Engine:** Segments the customer, assigns A/B group, calculates discount, and builds checkout URL. Customer Segment Check / Device Type Check:** Applies routing logic for personalized messaging. Wait / Check Order Status / Generate & Send Messages:** Timed sequence for Email, SMS, and WhatsApp, with order status checks at each step. Log Touchpoint (Google Sheets):** Records every message sent for attribution. Attribution Merge:** Combines all touchpoints into a single journey for analysis. Hash Customer Data for Facebook / Add to Retargeting Audience:** Adds unrecovered carts to a Facebook Custom Audience. Check Cart Value Threshold / Notify High-Value Recovery:** Sends Slack alerts for high-value recoveries. Customization tips Adjust wait times and message content to fit your brand and audience. Add or remove channels (e.g., push notifications, phone calls) as needed. Expand the Google Sheet for deeper analytics (e.g., add UTM parameters, campaign IDs). Integrate with your CRM or analytics platform for end-to-end tracking. Troubleshooting Make sure all API credentials are set and tested. Check Google Sheets permissions for the service account. Test each channel (email, SMS, WhatsApp) individually before going live. Review the workflow execution logs in n8n for errors or failed steps.

Automate Customer Feedback Analysis with Google Sheets, WhatsApp, and Email Introduction: Drowning in Data, Starving for Insight? Imagine this: Your team launches a new feature. Feedback starts pouring in emails, support tickets, social media mentions, and survey responses. You know gold is buried in there, but manually reading, tagging, and summarising hundreds, maybe thousands, of comments? It takes days, maybe weeks. By the time you have a clear picture, the moment might have passed. Sounds exhausting, right? What if you could have an AI assistant tirelessly working 24/7, instantly analysing every piece of feedback the moment it arrives? This isn't science fiction anymore. AI-powered automation can transform this slow, manual chore into a real-time insight engine, giving you the pulse of your customer base almost instantly. Let's explore how. What's the Goal? Understanding the Workflow Objective The core challenge is transforming raw, unstructured customer feedback into actionable intelligence quickly and efficiently. The Problem: Manual Overload: Sifting through vast amounts of feedback manually is incredibly time-consuming and prone to human error or bias. Delayed Insights: The lag between receiving feedback and understanding it means missed opportunities and slow responses to critical issues. Inconsistent Analysis: Different team members might interpret or categorize feedback differently, leading to unreliable trend spotting. The AI Solution: Automated Data Collection: Connects directly to feedback sources (surveys, social media, review sites, helpdesks). AI-Powered Analysis: Uses Large Language Models (LLMs) like GPT-4 or Claude to analyze sentiment, extract key topics, and summarize comments. Intelligent Categorization: Automatically tags feedback based on predefined or dynamically identified themes (e.g., "bug report," "feature request," "pricing issue"). Real-time Reporting: Pushes structured insights into dashboards, databases, or triggers notifications for immediate awareness. Outcome: You move from reactive problem-solving based on stale data to proactive, strategic decisions driven by a near real-time understanding of customer sentiment and needs. Why Does It Matter? Achieving 100X Productivity and Efficiency Look, automating feedback isn't just about saving time; it's about scaling your ability to listen and respond smarter, not harder. When you leverage AI, the gains aren't incremental - they're exponential. Here’s why this is a game changer: Blazing Speed: Analyse feedback 100x Faster (or more!) than manual methods. Insights appear in minutes or hours, not days or weeks. Unhuman Scalability: Process virtually unlimited volumes of feedback without needing to scale your human team proportionally. AI doesn't get tired or bored. Consistent Accuracy: AI applies analysis rules consistently, reducing human bias and ensuring reliable categorisation and sentiment scoring over time. Proactive Trend Spotting: Identify emerging issues or popular requests much earlier by analysing aggregated data automatically. Spot patterns humans might miss. Free Up Your Team: Let your talented team focus on acting on insights – improving products, fixing issues, engaging customers – instead of drowning in data entry. How It Works: AI Automation Step by Step Getting this set up is more straightforward than you might think, especially with tools like n8n acting as the central hub. Automated Feedback Triggering CRM/Website Event Node Trigger feedback requests after: Purchases (eCommerce) Support ticket resolution Feature usage (SaaS) Time-Based Node Schedule recurring NPS surveys Customer health check-ups Chat App Node (WhatsApp/Telegram/Messenger) Send conversational feedback prompts: "How was your recent experience with [specific interaction]?" Multi-Channel Feedback Collection Email Node (SendGrid/Mailchimp) Send personalized feedback requests Embed 1-5 rating widgets SMS Node (Twilio) Short mobile surveys: "Reply 1-5: How satisfied with your purchase?" Webhook Node Capture in-app feedback Process chatbot responses Social Media Node Monitor Twitter/X, Instagram mentions Analyze comments for unsolicited feedback AI-Powered Real-Time Analysis OpenAI/ChatGPT Node (Sentiment Analysis) Prompt: "Analyze sentiment (positive/neutral/negative) and key themes from: [customer feedback]" Output fields: Sentiment score (1-5) Urgency flag (high/medium/low) Key topics (billing, support, product, etc.) Translation Node (Optional) Convert multilingual feedback into a consistent language Instant AI Response System Conditional Node (Routing Logic) Positive feedback → Send thank-you + referral ask Neutral feedback → Follow-up question for details Negative feedback → Escalate to the human team AI Response Generator Node Prompt: "Create a personalized response to [feedback type] about [topic] with sentiment [score]" Adjust tone (professional/friendly/empathetic) Escalation Node Route critical issues to the support team with full context Automated Insights & Alerts Dashboard Node Real-time sentiment tracking Emerging issue detection Alert Node (Slack/Teams/Email) Notify teams of negative trends: "3+ complaints about checkout flow in the past hour!" Report Node Auto-generate weekly/monthly summaries: "Top 5 customer pain points this week" Product Board Integration Auto-create feature requests Prioritize based on feedback volume Tools of the Trade: AI & Automation Tech Stack You don't need a massive, complex tech stack. Focus on a few core, powerful tools: n8n: The workflow automation platform. This is the 'glue' that connects everything and orchestrates the process without needing deep coding knowledge. Honestly, it's incredibly versatile. OpenAI (GPT-4/GPT-4o): State-of-the-art LLM for high-quality text analysis, summarization, and classification. Great for complex understanding. Anthropic (Claude 3 Sonnet/Opus): Another top-tier LLM, known for strong performance in analysis and handling large contexts. Often, a great alternative or complement to GPT models. Feedback Sources APIs: Connectors for where your feedback lives (e.g., Typeform, SurveyMonkey, Twitter API, Zendesk API, Google Play/App Store review APIs). Data Storage/Destination: Where the processed insights go (e.g., Google Sheets, Airtable, Notion, PostgreSQL database, BigQuery). (Optional) Visualization Tool: Tools like Metabase, Grafana, Looker Studio, or Power BI to create dashboards from your structured feedback data. What's the Cost? Estimated Budget Let's talk investment. You're mainly looking at: Setup Costs: Primarily your time (or a consultant's) to design and build the initial workflow in n8n. Depending on complexity, this could range from a few hours to a few days. No major software licenses are usually needed upfront if using self-hosted n8n or starting with free/low-tier cloud plans. AI API Calls: You pay per usage to OpenAI/Anthropic. Costs depend heavily on volume but can start from $20-$50/month for moderate usage and scale up. Newer models are getting more cost-effective. n8n Hosting: Free if self-hosted (requires a server), or tiered cloud pricing starting around $20/month. Feedback Source APIs: Some platforms might have API access costs or rate limits on free tiers. Total Estimated Monthly Cost: For many businesses, ongoing costs can range from $50 - $500+ per month, highly dependent on feedback volume and AI model choice. The Return on Investment (ROI) is typically rapid. Consider the hours saved from manual analysis, the value of faster issue resolution, preventing churn, and the benefits of making product decisions based on real-time data. It often pays for itself very quickly. Who Benefits? Target Users and Industries This automated feedback loop isn't niche; it's valuable across many sectors and roles: Top Industries: SaaS (Software as a Service): Understanding user friction, feature requests, bug reports. E-commerce & Retail: Analyzing product reviews, post-purchase surveys, and support chats. Hospitality & Travel: Processing guest reviews, survey feedback. Mobile Apps: Monitoring app store reviews, in-app feedback. Financial Services: Gauging customer satisfaction with services, identifying pain points. Key Roles: Product Managers: Prioritizing features, understanding user needs, tracking launch reception. Customer Experience (CX) / Success Managers: Monitoring customer health, identifying churn risks, and improving support processes. Marketing Teams: Understanding brand perception, campaign feedback, and voice of the customer. Support Leads: Identifying recurring issues, measuring support quality, spotting training needs. This approach works for businesses of all sizes, from startups wanting to stay lean and agile to large enterprises needing to manage massive feedback volumes. How to use workflow? Importing a workflow in n8n is a straightforward process that allows you to use pre-built or shared workflows to save time. Below is a step-by-step guide to import a workflow in n8n, based on the official documentation and community resources. Steps to Import a Workflow in n8n Obtain the Workflow JSON Source the Workflow:** Workflows are typically shared as JSON files or code snippets. You might receive them from: The n8n community (e.g., n8n.io workflows page). A colleague or tutorial (e.g., a .json file or copied JSON code). Exported from another n8n instance (see export instructions below if needed). Format:** Ensure you have the workflow in JSON format, either as a file (e.g., workflow.json) or as text copied to your clipboard. Access the n8n Workflow Editor Log in to n8n:** Open your n8n instance (via n8n Cloud or your - self-hosted instance). Navigate to the Workflows tab in the n8n dashboard. Open a New Workflow:** Click Add Workflow to create a blank workflow, or open an existing workflow if you want to merge the imported workflow. Import the Workflow Option 1: Import via JSON Code (Clipboard): In the n8n editor, click the three dots (⋯) in the top-right corner to open the menu. Select Import from Clipboard. Paste the JSON code of the workflow into the provided text box. Click Import to load the workflow into the editor. Option 2: Import via JSON File: In the n8n editor, click the three dots (⋯) in the top-right corner. Select Import from File. Choose the .json file from your computer. Click Open to import the workflow. Note: If the workflow includes nodes for apps requiring credentials (e.g., Google Sheets), you’ll need to configure those credentials separately after importing.

This n8n workflow demonstrates how to automate customer interactions and appointment management via WhatsApp Business bot. After submitting a Google Form, the user receives a notification via WhatsApp. These notifications are sent via a template message. In case user sends a message to the bot, the text and user data is stored in Google Sheets. To reply back to the user, fill in the ReplyText column and change the Status to 'Ready'. In a few seconds n8n will fetch the unsent replies and deliver them one by one via WhatsApp Business node. Customize this workflow to fit your specific needs, connect different online services and enhance your customer communication! 🎉 Setup Instructions To get this workflow up and running, you'll need to: 👇 Create a WhatsApp template message on the Meta Business portal. Obtain an Access Token and WhatsApp Business Account ID from the Meta Developers Portal. This is needed for the WhatsApp Business Node to send messages. Set up a WhatsApp Trigger node with App ID and App Secret from the Meta Developers Portal. Right after that copy the WhatsApp Trigger URL and add it as a Callback URL in the Meta Developers Portal. This trigger is needed to receive incoming messages and their status updates. Connect your Google Sheets account for data storage and management. Check out the documentation page. ⚠️ Important Notes WhatsApp allows automatic custom text messages only within 24 hours of the last user message. Outside with time frame only approved template messages can be sent. The workflow uses a Google Sheet to manage form submissions, incoming messages and prepare responses. You can replace these nodes and connect the WhatsApp bot with other systems.

Automated LinkedIn Job Monitoring with AI Filtering, Google Sheets & Telegram Alerts 📋 Description Automates LinkedIn job searches across multiple countries and categories, filters results with AI, stores data in Google Sheets, and sends weekly Telegram notifications. Perfect for professionals seeking opportunities in software development, web development, and digital marketing. Workflow Process: Weekly scheduler triggers SerpAPI searches → AI processes and filters jobs → Saves to Google Sheets → Sends country-by-country analytics via Telegram/WhatsApp. 🛠️ Prerequisites SerpAPI Account** (free 100 searches/month) - Get API key from serpapi.com Telegram Bot Token** - Create via @BotFather Google Sheets** - OAuth2 credentials + shareable spreadsheet WhatsApp Business Cloud** (optional) 📋 Setup Instructions Create Google Spreadsheet Set column headers: job_title | company_name | location | salary_raw | salary_numeric | remote_status | description | application_url | date_posted | country | timestamp_added | job_id | source Replace Placeholders YOUR_SERPAPI_KEY_HERE → Your SerpAPI key YOUR_GOOGLE_SHEET_ID_HERE → Spreadsheet ID from URL YOUR_TELEGRAM_CHAT_ID_HERE → Your Telegram chat ID YOUR_PHONE_NUMBER_HERE → WhatsApp number (optional) Configure Search Parameters Modify "Initialize Variables" node: job_types: "software development,web development,digital marketing" countries: "qatar,uae,saudi arabia" Set Credentials Add SerpAPI HTTP credentials Configure Telegram bot credentials Set up Google OAuth2 credentials Column Requirements: Ensure Google Sheets has exact column names as specified above for proper data mapping.

WhatsApp Bulk Message Broadcast via Google Sheets (n8n Workflow) Use Case This workflow enables automated bulk WhatsApp message broadcasting using the WhatsApp Business Cloud API. It pulls recipient and message data from a Google Sheet, sends templated messages (optionally with image headers), and updates the sheet with the message status. It is ideal for marketing teams, support agents, and businesses handling high-volume outreach. Who Is This For? Businesses conducting WhatsApp marketing or outreach campaigns Customer support or notification teams Administrators seeking an automated, no-code message distribution system using Google Sheets What This Workflow Does Triggers automatically every minute to scan for pending messages Fetches unsent entries from a Google Sheet Limits the number of messages processed per execution to comply with API usage guidelines Sanitizes WhatsApp numbers for proper formatting Sends messages using a pre-approved WhatsApp template (text and optional image) Marks the row as "Sent" in the sheet upon successful delivery Workflow Breakdown (Node by Node) Trigger Every 5 Minutes Initiates the workflow every minute using a scheduled trigger to continuously monitor pending rows. Fetch All Pending Queries for Messaging Reads rows from a Google Sheet where the Status column is empty, indicating they haven’t been processed yet. Limit Restricts processing to 2 rows per execution to manage API throughput. Loop Over Items Uses SplitInBatches to iterate through each row individually. Clean WhatsApp Number A code node that strips non-numeric characters from the WhatsApp No field, ensuring the format is valid for the API. Send Message to 300 Phone No Sends a WhatsApp message using the WhatsApp Cloud API and a pre-approved template. Template includes: An image from the Image URL column (as header, optional) Dynamic variables for the recipient's Name and Message fields Template variables must be pre-defined and approved in the Meta Developer Portal, such as {{1}}, {{2}}. Change State of Rows in Sent1 Updates the Status column to Sent for each successfully processed row using the row number as a reference. Google Sheet Format Structure your Google Sheet as shown below: | WhatsApp No | Name | Message | Image URL | Status | |--------------|------------|---------------------------|---------------------|--------| | +8801XXXXXXX | John Doe | Hello, your order shipped | https://.../img.jpg | | Leave the Status column empty for rows that need to be processed. Requirements WhatsApp Business Cloud API access via Meta for Developers A properly structured Google Sheet as described above Active OAuth2 credentials configured in n8n for: googleSheetsOAuth2Api whatsAppApi Customization Options Update the Limit node to control how many rows are processed in each run Adjust the trigger schedule (e.g., change to every 5 minutes) Replace the message template ID with your own custom-approved one from Meta Add error-handling logic (e.g., IF or Try/Catch nodes) to log failures or set Status = Failed Sample Sheet Template View Sample Google Sheet Workflow Highlights Automated execution every 1 minute Reads and processes only pending records Verifies WhatsApp numbers and delivers templated messages Updates Google Sheet after each attempt Support & Community Need help setting up or customizing the workflow? WhatsApp: Contact Support Discord: Join SpaGreen Server Facebook Group: SpaGreen Community Website: Visit SpaGreen Creative

This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. Problem Statement & Target Audience Who is this for? This workflow is ideal for: SEO specialists monitoring keyword rankings. Website owners tracking performance. Agencies managing multiple client campaigns. It helps reduce manual effort by automatically checking rankings on a schedule and sending notifications only when there’s movement in position. Pre-conditions & API Requirements APIs & Services Used SerpAPI – Fetch Google search results Get API Key: https://serpapi.com/manage-api-key Docs for usage: SerpAPI Search API Note: Use Generic credential type in n8n for this to work with the preset configuration. Google Sheets API – To store and update keyword data Email API – To notify users of position changes WhatsApp API (e.g., Twilio, Ultramsg) – To send notifications > Setup help for Google Sheets, Email, and WhatsApp is available via the Docs tab in each respective node in n8n. Step-by-Step Workflow Explanation 🗓 1. Scheduled Trigger (Support Workflow) Marks all rows in the sheet as "notchecked" in the checkstatus column. This is the user-defined frequency trigger (e.g. weekly, daily). Triggers the main workflow. 🚀 2. Main Workflow Trigger Starts when a row with checkstatus = notchecked is found. 🔍 3. HTTP Node (SerpAPI Call) Sends a request to SerpAPI for each keyword. Fetches the current Google SERP for that keyword. 🧠 4. JavaScript Node (Parse Position) Loops through the SERP results and finds the position of the target URL. Extracts and returns the current rank. ✍️ 5. Google Sheets Node (Update Data) Writes the new ranking into the spreadsheet. Updates the currentposition and sets checkstatus to "checked". 🔀 6. Switch Node (Compare Rankings) Compares previousposition with currentposition: If rank has improved → send positive alert. If rank has dropped → send negative alert. If unchanged → no alert. 📩 7. Notification Nodes (WhatsApp / Email) Sends a message to chosen channels when a change is detected. Customization Guide ⏱️ Change Frequency Adjust the supporting schedule workflow to change how often the tracker runs. ✉️ Edit Notification Content Customize the WhatsApp and Email message content in their respective nodes. 🔗 Track Multiple URLs per Keyword (Advanced) Extend the JavaScript logic if you need to monitor several pages for the same keyword. 🌐 Expand Search Engine Targets SerpAPI also supports other search engines like Bing and Yahoo. Modify the request params to switch. How to Set Up This Workflow ✅ Step 1: Use This Google Sheets Template To get started quickly, make a copy of the template below: 👉 Google Sheets Template This template includes the required structure: keyword Website_url position timestamp checkstatus > ⚠️ Be sure to make your own copy to edit and connect via the Google Sheets node. 🔐 Step 2: Configure Your APIs SerpAPI:** Get API key from serpapi.com/manage-api-key Set credential type to Generic in n8n for compatibility. Google Sheets, Email & WhatsApp:* Use the instructions found in each node’s Docs tab* to connect your accounts. 📦 Step 3: Import the Workflow Both the main keyword tracking workflow and the supporting scheduler workflow are in one file ▶️ Step 4: The workflow will start Since the check status columns will be 'notChecked' schedule workflow. The update sheets node will update each processed row's checkstatus to 'checked' and the workflow will process the next row the schedule trigger workflow will update checkstatus = notchecked and triggers the keyword tracking automatically. 🎉 Done! From now on, your keyword positions will be monitored at the frequency you set. You’ll receive WhatsApp and/or email updates only when rankings change. in case you need customized workflows or wanna reach out here is my twitter and email.

⚠️ Heads up: this is satire. The "Hell Yeah!" workflow is a parody of "automate your whole life with AI agents" grindset content. The API endpoints are fictional and the function nodes are illustrative stubs. It's published as a template because the patterns underneath the joke — multi-channel social fan-out, marketplace scraping with follow-up sequences, CRM sync with chat alerts, cron-triggered daily chains — are genuinely useful starting points for n8n agencies building real lead-gen flows. Swap the jokes for your actual integrations and you've got a working skeleton. How it works A Rise and Grind cron kicks off a parallel "daily lifestyle" routine every morning A gambling → flex chain runs arbitrage math against a fake sportsbook and fans the "wins" out to Instagram, TikTok, Facebook, Threads, LinkedIn, and Twitter in one blast (this is the reusable multi-channel social posting pattern) A Facebook Marketplace lowball engine scrapes listings, filters them, fires templated lowball offers, and runs a relentless follow-up sequence (reusable pattern: scraper → filter → outreach → nurture) An eBay arbitrage loop finds profitable items, relists them, and logs every transaction to Google Sheets A Salesforce + Telegram branch handles "deal alerts" — the standard CRM-sync-with-chat-notification pattern every agency ships Extra satirical branches (Tinder auto-booking, Uber Black to the casino, steak delivery, playing Alice in Chains) are there for the bit — delete or replace them Set up steps Takes about 15–20 minutes if you're just importing to read through the patterns Takes 1–2 hours if you're stripping out the satirical branches and wiring the reusable patterns (social fan-out, marketplace outreach, CRM+Telegram) to your real credentials Replace every fictional HTTP endpoint with your actual API before activating Add credentials for whichever real nodes you keep: Salesforce, Telegram, Google Sheets, WhatsApp, Facebook Graph Detailed notes for each section live in the sticky notes inside the workflow itself

Who is this for This workflow is built for sales teams, agencies, and small businesses that receive inbound leads via WhatsApp and want to automate their first response, lead qualification, and CRM logging — without missing a single message. What this workflow does It listens for incoming WhatsApp messages, uses an AI agent to classify each message by intent (hot lead, warm lead, support, or needs qualification), sends a tailored auto-reply, logs every interaction to Google Sheets, and automatically books Google Calendar meetings with Meet links for qualified leads. How it works WhatsApp Trigger receives incoming messages and filters out bot/status messages to prevent loops. AI Agent (powered by Ollama or any connected LLM) classifies the message into one of four intent categories with confidence scoring. Smart Router directs each intent down a dedicated path. Hot & Warm Leads receive an instant reply, get logged to Google Sheets, have a Google Calendar meeting auto-booked, and receive the Meet link via WhatsApp. Support requests are logged and receive a ticket confirmation. Vague or incomplete messages trigger a smart follow-up question. Conversation memory ensures the AI re-classifies correctly when the user replies with more context. Setup steps Connect your WhatsApp Business API credentials (Meta Cloud API). Connect Google Sheets OAuth and set your spreadsheet ID in all three logging nodes. Connect Google Calendar OAuth and select your calendar in both booking nodes. Configure your LLM (Ollama endpoint, OpenAI, or any supported model). Update the BOT_NUMBERS array in the "Parse WhatsApp Message" node to match your WhatsApp Business phone number ID. Update the phoneNumberId in all WhatsApp Send nodes to your number. Send a test message and verify the full flow. Requirements WhatsApp Business API (Meta Cloud API) access Google Sheets and Google Calendar accounts with OAuth credentials An LLM endpoint (Ollama, OpenAI, or any n8n-supported model) n8n instance (cloud or self-hosted) How to customize Swap the AI model in the Ollama Chat Model node for OpenAI, Anthropic, or any supported LLM. Edit the auto-reply templates in each Reply code node to match your brand voice. Adjust meeting booking times (default: Hot = 2 hours out, Warm = 4 hours out). Add Slack or email notifications by branching from the Google Sheets logging nodes. Modify the AI classification prompt to add custom intent categories for your business.

How it works This workflow automatically detects completed orders in PostgreSQL and prepares them for AI-based post-purchase communication. It enriches each order with customer, product, and payment data, then generates a personalized message using an AI agent. The message is delivered via email and WhatsApp and finally logged in Google Sheets for tracking and auditing. Step-by-step Step 1: Fetch and prepare completed orders for AI processing** Postgres Trigger – Watches the orders table for updates and initiates the workflow. Postgres (Execute query) – Fetches only orders marked as completed. Split In Batches – Loops through completed orders safely and sequentially. Postgres (Execute query) – Retrieves full customer, product, and payment details using joins. AI Agent – Generates a personalized post-purchase message using order data. Groq Chat Model – Supplies the language model used by the AI agent. Merge – Combines AI-generated text with database results for downstream use. Step 2: Deliver messages and log post-purchase communication** Code – Formats AI output into clean email and WhatsApp message templates. Gmail – Sends the post-purchase email to the customer. WhatsApp – Sends the same message via WhatsApp. Set – Flags email and WhatsApp messages as successfully sent. Google Sheets – Appends customer, order, and communication details. Wait – Pauses before continuing to process the next completed order. Why use this? Automates post-purchase communication with zero manual effort. Ensures consistent, personalized messaging across email and WhatsApp. Adapts message tone automatically based on payment status. Creates a centralized audit log in Google Sheets. Scales easily as order volume grows.

This automated n8n workflow transforms raw CSV data into qualified, enriched lead databases with verified emails and AI-generated personalization. It processes uploaded CSV files through multiple validation, enrichment, and sorting stages before delivering organized results via Google Drive, WhatsApp, or Google Sheets. How It Works Stage 1: Data Intake & Normalization Form Submission: User uploads a CSV/XLSX file and selects: Delivery method (Google Drive, WhatsApp, or Google Sheets with processing) Two personalization prompts for AI-generated messages Column Mapping: The workflow automatically recognizes and standardizes 100+ column name variations into consistent fields Deduplication: Removes duplicate entries by website URL and contact name Initial Filtering: Identifies and flags invalid websites (social media profiles, link shorteners) Stage 2: Data Quality Routing The workflow analyzes each record and routes it based on available data: Route A: Invalid Website → Sends directly to "x Website" sheet Route B: No Website → Verifies existing email and categorizes by validity Route C: Valid Website + Email → Proceeds to email verification and enrichment Route D: Valid Website - Email → Scrapes website to find email addresses. Stage 3: Email Discovery & Verification For records needing enrichment: Website Scraping: Fetches HTML content from company websites Email Extraction: Uses regex patterns to identify email addresses AI Selection: GPT-5-NANO chooses the most relevant email from multiple options Dual Verification: Primary check via Reoon API (deliverability, SMTP, safety) Backup verification if primary fails Personal Email Processing: Separately validates personal emails when present Stage 4: Website Intelligence Gathering Parallel to email processing: Extracts HTML title tags for company context Captures meta descriptions for business understanding Pulls H1 headings for content insight Handles scraping failures gracefully with empty placeholders Stage 5: Email Categorization Logic Records are sorted into buckets: +1 Email**: Has exactly one verified email (business OR personal OR newly found) +2 Email**: Has two or more verified emails Single Source Records**: Only business email OR only personal email Stage 6: AI Personalization For records with verified emails: Context Assembly: Combines name, company, job title, website metadata, industry, keywords AI Processing: Sends to GPT-5-NANO or Gemini with user's custom prompts Structured Output: Generates: Cleaned contact name Shortened company name Personalization message 1 (per user prompt) Personalization message 2 (per user prompt) Stage 7: Final Delivery Based on user's initial selection: Google Drive**: Uploads timestamped CSV, sends email with link WhatsApp**: Converts to XLSX and sends document Google Sheets**: Populates separate sheets by category with completion email How To Use Active n8n instance with required credentials: Google Drive API access Google Sheets API access Gmail API access (for notifications) WhatsApp Business API credentials Reoon Email Verifier API keys OpenAI API key (GPT-5-NANO) Optional: Google Gemini API key Setup Steps Configure Google Sheets Destinations Create or use existing Google Sheets for data categorization: +1 Email Sheet**: Update document ID in "+1 Email" node +2 Email Sheet**: Update document ID in "+2 Email" node x Website Sheet**: Update document ID in "x Website Data" node No Website Sheet**: Update document ID in "- Website +- Email +- Phone Number" node Ensure all sheets have matching column headers as defined in the workflow. Set Up Google Drive Folder Create a destination folder in Google Drive Update the folder ID in the "Upload file" node Ensure the service account has write permissions Configure WhatsApp Add your WhatsApp Business Phone Number ID in the "Send CSV" node Update the recipient phone number (format: +country code) Customize Email Notifications Update sender and recipient emails in "Send a message" and "Send a Success Message" nodes Modify email templates as needed Verify API Keys Check that all API credentials are active: Reoon Email Verifier keys (two instances for redundancy) OpenAI API key for GPT-5-NANO All Google API credentials

How It Works This workflow automates cross-platform content distribution from Instagram to YouTube with intelligent AI enhancement. Designed for content creators, social media managers, and digital marketers who need to maximize their content reach across platforms efficiently. The template solves the challenge of manual video repurposing by automating the entire process from content retrieval to optimized publishing. It retrieves Instagram videos on schedule, generates engaging metadata using dual AI models (Anthropic Claude for creative titles/descriptions), uploads to YouTube, logs performance metrics to Google Sheets, and sends WhatsApp notifications upon completion. The workflow intelligently routes tasks between AI providers: Claude's language capabilities create compelling and platform-optimized content. This dual-model approach delivers superior results compared to single-AI solutions, combining creativity with precision for maximum engagement. Setup Steps Configure Instagram credentials Add Anthropic API key for Claude model in AI nodes Connect YouTube account and configure upload settings Link Google Sheets with target spreadsheet ID for logging Add WhatsApp Business API credentials Prerequisites Instagram Business/Creator account with API access Use Cases Social media agencies managing multiple client accounts Customization Modify AI prompts for brand-specific tone, adjust scheduling frequency Benefits Saves 2-3 hours daily on manual uploads, ensures consistent posting schedules

WORKFLOW OVERVIEW This workflow is an AI-powered business intelligence agent designed for founders and business owners. It automatically collects key business metrics, calculates performance KPIs, applies decision logic, uses AI reasoning, and sends clear, actionable notifications — without dashboards or manual reports. Key Features: ✅ Aggregates multiple data sources (MSSQL, Google Analytics, Google Sheets) ✅ Calculates critical KPIs: ROAS, CAC, Revenue & User Growth ✅ Applies rule-based decision logic for business risk and opportunity detection ✅ AI-powered reasoning: summarizes insights and recommends actions ✅ Multi-channel notifications: Email, WhatsApp, Slack, Telegram ✅ Fully automated daily execution via Cron trigger ✅ Enterprise-ready: error handling, structured data, KPI validation Setup & Requirements: API access to data sources (MSSQL, Google Analytics, Google Sheets) OpenAI or Google Gemini API for AI reasoning Messaging integration: Gmail, Twilio (WhatsApp), Slack, Telegram Workflow Flow: Cron Trigger – runs daily at a chosen time Data Collection – revenue, users, marketing spend, website analytics Merge Node – combines all data sources Function Node – consolidates into a single JSON object KPI Calculation – calculates ROAS, CAC, growth rates Business Logic Engine – identifies risks and opportunities AI Reasoning Agent – summarizes insights, suggests actions Notification Formatter – builds founder-friendly message Notification Delivery – sends via WhatsApp, Email, Slack, or Telegram Example Data Formation These data below Getting from all different channels. `{ "revenue": 4290, "registeredUsers": 20, "totalUsers": 3, "adSpend": 800 }` Applies rule-based logic to detect potential risks or opportunities `{ "ROAS": 5.36, "CAC": 40, "agentStatus": "normal", "agentPriority": "low", "insights": ["Marketing campaigns are performing very well"] }` Workflow Highlights Fully automated, runs daily without human intervention Integrates multiple business data sources Converts raw data into KPIs for actionable insight Applies both rule-based logic and AI reasoning Generates concise, human-friendly notifications Sending notification to different channels.

How it works This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The workflow then evaluates IST working days and hours, generates a context-aware AI response, and routes the reply to the correct channel. Finally, it logs the full interaction, response status, and timing into Google Sheets. Step-by-step Step 1: Lead intake & normalization** Incomming Lead whatsapp1 – Receives new WhatsApp lead messages via webhook. Incomming Lead facebook1 – Captures incoming Facebook lead messages. Incomming Lead instagram1 – Listens for Instagram lead messages. Incomming Lead linkdin1 – Captures LinkedIn lead messages. Incomming Lead Website1 – Receives website form submissions. Normalize Lead Data6 – Normalizes WhatsApp lead fields. Normalize Lead Data7 – Normalizes Facebook lead fields. Normalize Lead Data8 – Normalizes Instagram lead fields. Normalize Lead Data9 – Normalizes LinkedIn lead fields. Normalize Lead Data5 – Normalizes website lead data. Switch2 – Merges all normalized leads into a single processing path. Step 2: Working hours & AI response** Extract Day and Hours1 – Converts timestamps to IST and extracts day and time. Is Working Day and Working Hour?1 – Determines whether the lead arrived during business hours. Code in JavaScript3 – Builds the AI prompt using lead details and timing context. Get Ai Response1 – Generates a short, human-like response. Step 3: Send reply & log data** Code in JavaScript4 – Combines AI output with normalized lead data. Switch3 – Routes the response based on the source channel. Send message – Sends WhatsApp replies. Send Instagram Message1 – Sends Instagram responses. Send Facebook Messages1 – Sends Facebook replies. Send Linkdin Messages1 – Sends LinkedIn responses. Send a message1 – Sends email replies for website leads. Code in JavaScript5 – Finalizes response status and metadata. google-sheet-name – Appends or updates lead and response data in Google Sheets. Why use this? Replies instantly to leads across all major inbound channels Keeps all lead data standardized and easy to manage Automatically respects IST working days and hours Reduces manual SDR workload without losing response quality Maintains a complete response log for reporting and follow-up

How it works This workflow monitors Meta Ads and Google Ads campaigns on a daily schedule to detect performance drops. It fetches yesterday’s campaign data, standardizes metrics, and calculates CTR and ROAS against fixed benchmarks. Campaigns that fall below thresholds are flagged automatically. Alerts are then sent across multiple channels and all results are logged in Google Sheets for tracking. Step-by-step Step 1: Fetch ad performance data** Schedule Trigger (Daily Ad Check2) – Runs the Meta Ads performance check at the scheduled time. HTTP Request (Fetch Meta Ads Data) – Retrieves campaign metrics from the Meta Ads API. Set (Set Benchmarks) – Normalizes Meta Ads data and assigns platform details. Schedule Trigger (Daily Ad Check3) – Runs the Google Ads performance check at a separate scheduled time. Google Ads (Get many campaigns) – Fetches campaign performance data from Google Ads. Set (Set Benchmarks4) – Normalizes Google Ads data and assigns platform details. Step 2: Detect performance drops** Code (Detect Performance Drop) – Calculates CTR and ROAS, compares them with predefined benchmarks, and flags drops. If – Filters only campaigns where a performance drop is detected. Split In Batches (Loop Over Items) – Processes each affected campaign individually. Step 3: Alert and log results** WhatsApp (Send message1) – Sends instant WhatsApp alerts for critical visibility. Slack (Send a message) – Posts detailed alerts to a Slack channel. Gmail (Send a message4) – Sends email notifications with full campaign metrics. Code (Code in JavaScript) – Recombines campaign data after notifications. Wait (Wait1) – Ensures alert delivery before logging. Google Sheets (your-google-sheets-name) – Appends or updates campaign records for reporting and audit history. Why use this? Catch CTR and ROAS drops before ad spend is wasted. Monitor Meta Ads and Google Ads in a single automated flow. Notify teams instantly via WhatsApp, Slack, and Email. Keep a centralized performance log for analysis and reporting. Reduce manual checks with consistent daily monitoring.

How it works This workflow sends WhatsApp messages and emails in bulk using contact data stored in Google Sheets. Contacts are processed in small batches to control throughput and avoid API rate limits. WhatsApp and email are treated as independent channels and are sent only when their status is marked as pending. All success and failure results are written back to Google Sheets to enable tracking, retries, and safe re-runs. Step-by-step Step 1: Fetch contacts & batch processing** Manual Trigger – Starts the workflow manually. Get Contacts – Reads contact data from Google Sheets. Split In Batches – Processes contacts in controlled batch sizes. Step 2: Email preparation & sending** Has Email Address – Checks whether the contact has an email address. IF Mail Pending – Ensures the email is still marked as pending. PrepareEmail email – Loads the selected InboxPlus email template. Build HTML Email – Builds the final HTML email body. Fetch Email Image – Downloads images for inline or attachment usage. Send Gmail – Sends the email via Gmail. Delivered – Confirms successful email delivery. Step 3: WhatsApp message sending** Has Phone Number – Checks whether the contact has a phone number. IF WhatsApp Pending – Ensures the WhatsApp message is still pending. Send template – Sends the approved WhatsApp template message. Sent – Confirms message acceptance by WhatsApp. Step 4: Delivery status updates** Update Sheet – Writes successful delivery results back to Google Sheets. Mail Failure – Updates Google Sheets if email delivery fails. Whatsapp Failure – Updates Google Sheets if WhatsApp delivery fails. Why use this? Prevents duplicate messages with channel-level pending checks Handles WhatsApp and email independently in one workflow Supports safe retries without resending completed messages Keeps Google Sheets as the single source of truth Scales bulk outreach safely using batch-based execution

How It Works Automated daily scraping of competitor websites, pricing pages, job postings, and press releases feeds into an AI analyzer powered by OpenAI or Claude to extract trends, insights, and key metrics. The analyzed results are stored in Google Sheets for historical tracking and longitudinal comparison, and are automatically shared with stakeholders via email or WhatsApp. This workflow eliminates manual competitive research, enabling product teams and executives to monitor market movements efficiently and make timely, data-driven decisions. Setup Steps Configure the daily schedule trigger. Define competitor URLs using workflow variables. Add and configure the OpenAI or Claude API key. Authenticate Google Sheets using the appropriate credentials. Connect Gmail and WhatsApp Business API tokens. Test each scraper individually before enabling full automation. Prerequisites OpenAI/Claude API account, Google Sheets access, Gmail account, WhatsApp Business API, web scraping enabled Use Cases Market share monitoring, pricing strategy updates, competitor talent movement tracking, industry trend reports Customization Modify scrape targets, adjust AI prompt for different metrics, change alert frequency Benefits Real-time competitive visibility, reduced manual research 15+ hours/week, faster decision-making

How it Works. The workflow runs automatically every day and collects analytics data for both today and yesterday. It cleans and standardizes both datasets in the same way so they are easy to compare. After that, it measures how performance has changed from one day to the next and interprets those changes to understand trends and context. Once all calculations are finished, the AI creates a clear, easy-to-read summary of what happened. This summary is then formatted and sent through the required communication channels, while the final data is saved for tracking over time and for creating follow-up tasks if needed. Key Features: Trigger runs once per day recommended (11: 57 PM). Fetch seperate data for today and yesterday in node. Compare the two days data and highlight if traffic is less Add the trend lowTraffic for low traffic identification. Using GPT-4 Mini for human readable summary to suit different communication channels. Sending report to WhatsApp / Email Stored the final structure data to Google Sheet for future analytics and historical record Setup Steps Connect Required Credentials You must connect the following credentials: Google Analytics API Google Sheets OpenAi API Email SMTP WhatsApp API ClickUp API Replace Defalut Values Update the workflow with: Your Google Analytics Id's Your Google Sheet Tabs Replace SMTP Credentials, sender and recipients Change with your OpenAi API key Create your WhatApi API Credentials ClickUp API Key's Customize Email Template Modify subject, message body, or formatting style based on your reporting standards. Adjust Trigger You may choose: Manual Trigger Cron Trigger for daily/weekly report Webhook Trigger integrated with your system Detailed Process Flow Schedule Trigger Node Type: Trigger Node Purpose: Automates the start of the workflow. Details: Runs every day (or every hour if real-time monitoring is needed). Eliminates manual data collection and ensures consistent reporting. Analytics Reports Node Type :- Google Analytics Node Purpose: Fetch website performance data Metrics includes: users, sessions, page views Combine the Data Node Type: Merge Node (Append) Purpose: Combines today’s and yesterday’s datasets into a single item for comparison. Details: Prepares data for calculating percentage changes. Maintains proper structure for further nodes. Calculate Percent Changes Node Type: Function Node Purpose: Computes day-over-day percentage changes for users, sessions, and page views. Details: Formula: ((today - yesterday) / yesterday) * 100 Handles increases and decreases correctly. Outputs values used for trend indicators and alerts. Generate AI Summary Node Type: OpenAI Node Purpose: Produces human-readable, professional insights about the daily analytics. Details: Summarizes key changes, trends, and recommendations. Provides context such as low-traffic warnings. Text output is used in emails, WhatsApp, and ClickUp tasks. Send Email or Whatsapp to Dedicated Person / Marketing Team Node Type: Email Node / Whatspp Purpose: Sends daily alert or report emails or whatsapp. Details: Includes formatted metrics and AI summary. Email subject and body clearly indicate trends and recommendations. Workflow Benefits Fully automated daily GA reporting AI-generated summaries for clear insights Alerts only triggered when necessary Historical logging for trends and dashboards Actionable tasks automatically created in ClickUp Multi-channel delivery via Email and WhatsApp Handles low-traffic scenarios gracefully

Description How it works This powerful workflow helps businesses and freelancers automatically manage invoices received on WhatsApp. It detects new messages, downloads attached invoices, extracts key data using OCR (Optical Character Recognition), summarizes the details with AI, updates Google Sheets for record-keeping, saves files to Google Drive, and instantly replies with a clean summary message all without manual effort. Perfect for small businesses, agencies, accountants, and freelancers who regularly receive invoices via WhatsApp. Say goodbye to manual data entry and hello to effortless automation. Set up steps Setup takes around 10–15 minutes: Connect your WhatsApp Cloud API to trigger incoming messages. Add your OCR.Space API key to extract invoice text. Link your Google Sheets and Google Drive accounts for data logging and storage. Enter your OpenAI API key for AI-based summarization. Import the template, test once, and you’re ready to automate your invoice workflow. Why use this workflow Save hours of manual data entry Keep all invoices safely stored and organized in Drive Get instant summaries directly in WhatsApp Improve efficiency for client billing, and expense tracking.

Automatically track new freelance job postings from any platform using Apify Actors, process the results, and get real-time WhatsApp alerts for new opportunities. This workflow saves jobs to Google Sheets for record-keeping and sends instant notifications so you never miss a client lead. Who’s it for Freelancers, agencies, and business developers who want to monitor platforms like Upwork, Fiverr, or Freelancer for new jobs — without checking manually. How it works The workflow starts when a chat message or trigger event is received. It runs an Apify Actor to scrape job listings from your target platform. The dataset results are fetched via Apify’s API. A JavaScript Code node processes and filters the results for relevant jobs. The data is saved to Google Sheets for tracking and reporting. A formatted job summary is created and sent as a WhatsApp message directly to your phone. How to set up Create or use an Apify Actor for scraping job listings from your chosen site. Connect your Apify API token in n8n under credentials. Link your Google Sheets account and specify the sheet for storing job data. Add your WhatsApp Cloud API or Twilio WhatsApp credentials. Test the workflow by sending a trigger message — new jobs will be fetched, stored, and sent to WhatsApp. Requirements Apify account with API access Google Sheets integration WhatsApp Cloud API or Twilio account n8n Cloud or self-hosted instance How to customize 🧩 Add filters: Include keyword or budget filters in the JavaScript node. 🔄 Schedule runs: Replace the chat trigger with a Cron node for hourly or daily tracking. 📊 Change destination: Save results to Notion, Airtable, or Slack instead of Google Sheets. 🗣️ Multi-channel alerts: Send updates to Discord, Telegram, or Email as well. Stay ahead of freelance opportunities — this n8n workflow finds jobs, logs them, and alerts you instantly via WhatsApp.

Overview This workflow automates your entire sales outreach process across LinkedIn, Email, and WhatsApp using AI to create hyper-personalized messages for each prospect. Instead of spending hours crafting individual messages, the workflow analyzes your lead data and generates customized connection requests, emails, and WhatsApp messages that feel genuinely personal and researched. The workflow includes a built-in approval mechanism, so you can review all AI-generated messages before they're sent, ensuring quality control while still saving massive amounts of time. How It Works The workflow follows a seven-step process: Step 1: Data Collection The workflow starts by reading your lead data from a Google Sheet. Your sheet should contain information about each prospect including their name, title, company, industry, technologies they use, and any other relevant details that can be used for personalization. Step 2: Batch Processing To prevent overwhelming APIs and ensure smooth operation, the workflow processes leads in batches. Each lead's complete data is prepared and formatted for the AI agent to analyze. Step 3: AI Personalization This is where the magic happens. The AI agent receives all the prospect data and generates three distinct messages: A LinkedIn connection request (under 300 characters) that references their specific role, company, or industry A professional HTML email that demonstrates you've researched their business and explains how you can help A casual WhatsApp message that's friendly and approachable The AI is instructed to make these messages sound completely human, never generic or templated. Step 4: Data Cleanup and Storage The AI's output is parsed and cleaned up, then written back to your Google Sheet in separate columns. This creates a permanent record of all generated messages for your review. Step 5: Manual Approval Before anything gets sent, you receive an email asking for your approval. You can review all the generated messages in your Google Sheet, make any edits if needed, and then approve or reject the batch. This ensures you maintain full control over what goes out. Step 6: LinkedIn Automation Once approved, the workflow triggers your Phantombuster agent to send LinkedIn connection requests using the AI-generated messages. Phantombuster handles the actual LinkedIn interaction safely within their platform's limits. Step 7: Email and Notification Delivery Finally, the workflow sends out the personalized emails via Gmail and optionally notifies you via Telegram for each message sent. This happens sequentially to respect rate limits and maintain deliverability. Setup Requirements Before you can use this workflow, you'll need to set up several accounts and gather credentials: Essential Services: An n8n instance (cloud or self-hosted) A Google account with Google Sheets access A Gmail account for sending emails An OpenAI account with API access (for the AI agent) Phantombuster account (for LinkedIn automation) Optional Services: Telegram account and bot (for notifications) Credentials You'll Need: Google Sheets OAuth2 credentials Gmail OAuth2 credentials OpenAI API key Phantombuster API key and agent ID Telegram bot token and chat ID (if using notifications) How to Use This Workflow Initial Setup: Import this workflow into your n8n instance Add all required credentials in n8n's credential manager Create your Google Sheet with the following columns at minimum: First Name, Last Name, Title, Company Name, Personal Email, Industry, Website. Add three additional columns for output: Connection, AI Email, AI Whatsapp Message Copy your Google Sheet ID from the URL and update it in all Google Sheets nodes Open the AI Agent node and update the prompt with your personal information: your name, title, email, and LinkedIn URL Update the email addresses in the Gmail nodes to your actual email addresses Configure your Phantombuster agent for LinkedIn and add the API key and agent ID Running the Workflow: Add your lead data to the Google Sheet (you can start with just 2-3 leads for testing) Click "Execute Workflow" in n8n to start the process Wait for the AI to generate messages (this takes a few seconds per lead) Check your email for the approval request Review the AI-generated messages in your Google Sheet Reply to the approval email with your decision If approved, the workflow will automatically send LinkedIn requests, emails, and WhatsApp messages Best Practices: Start small. Process 5-10 leads at a time initially to test the quality of AI-generated messages and ensure everything works correctly. Once you're confident in the output, you can scale up to larger batches. Monitor your results. Keep track of response rates in your Google Sheet and adjust the AI prompt if certain types of messages aren't performing well. Respect rate limits. Gmail allows 100-500 emails per day depending on your account type, and LinkedIn has strict limits on connection requests (typically 100 per week through automation tools). Stay well within these limits to avoid account restrictions. Customizing This Workflow The workflow is designed to be highly customizable to fit your specific use case: Personalizing the AI Prompt: The most important customization is in the AI Agent node's prompt. You can modify it to: Emphasize different aspects of your value proposition Change the tone from formal to casual or vice versa Include specific pain points relevant to your target industry Add your company's unique selling points Adjust message length and structure Modifying the Output: You can change what the AI generates by editing the prompt. For example, you might want: Different message types (Twitter DMs instead of WhatsApp) Multiple email variations for A/B testing Follow-up message sequences Industry-specific templates Adding Features: The workflow can be extended with additional nodes: Add time delays between sends to appear more natural Include condition checks to segment leads by industry or company size Connect to your CRM to automatically log activities Add sentiment analysis to filter out negative-sounding messages Implement response tracking by monitoring your inbox Changing Tools: If you prefer different services, you can swap out nodes: Replace Phantombuster with other LinkedIn automation tools Use SendGrid or Mailgun instead of Gmail for higher volume Add Slack notifications instead of Telegram Connect to WhatsApp Business API for official messaging Data Source Alternatives: Instead of Google Sheets, you could: Connect directly to your CRM (HubSpot, Salesforce, Pipedrive) Use Airtable as your database Pull data from CSV files uploaded to cloud storage Integrate with lead generation tools like Apollo or Hunter Tips for Success The quality of your AI-generated messages depends heavily on the data you provide. The more information you have about each prospect (their role, company size, technologies used, recent news, pain points), the more personalized and effective the messages will be. Regularly review and refine your AI prompt based on the responses you're getting. If prospects aren't responding, your messages might be too sales-focused or not personal enough. Adjust the prompt to make messages feel more consultative and helpful. Don't send to your entire list at once. Even with approval gates, it's wise to test with small batches, measure results, iterate on your approach, and then scale up gradually. Always comply with email and LinkedIn best practices. Never spam, always provide value in your outreach, respect people's time and privacy, and make it easy for them to opt out if they're not interested. This workflow is a powerful tool that can save you hours of work while actually improving the quality of your outreach through AI-powered personalization. Use it responsibly and watch your response rates improve.

Short Description Automatically scrape new Upwork job listings, save them to Google Sheets, and get real-time WhatsApp alerts when new matching jobs appear. This workflow helps freelancers and agencies track new opportunities instantly — without checking Upwork manually. Who’s it for For freelancers, agencies, and automation enthusiasts who want to monitor Upwork jobs automatically and receive instant notifications for relevant projects. How it works This workflow connects with RapidAPI to fetch new Upwork job listings, filters relevant ones, stores them in a Google Sheet, and sends WhatsApp alerts for matching results. It includes: Trigger node** for scheduled or webhook-based execution HTTP Request node** connected to RapidAPI for scraping Google Sheets node** to store job data Filter (IF) node** to select relevant jobs WhatsApp API node** to send alerts automatically How to set up Get an API key from RapidAPI and subscribe to an Upwork scraper API. Create a Google Sheet with columns like Title, Budget, Category, Link, and Description. Connect your Google account to n8n using Google Sheets credentials. Set up your WhatsApp API endpoint (e.g., via Waha API or WhatsApp Cloud API). Paste your API keys into the HTTP Request nodes and test the workflow. Schedule the workflow to run automatically (e.g., every hour or once daily). Requirements RapidAPI account (for Upwork scraper API) Google Sheets account WhatsApp API access (Waha / Cloud API) n8n cloud or self-hosted instance How to customize You can modify this workflow to: Track specific job categories or keywords (e.g., “automation”, “AI”, “n8n”) Send alerts to Telegram, Discord, or Slack instead of WhatsApp Add budget or client rating filters for higher-quality job leads Connect it with Airtable or Notion for advanced job tracking

🧾An intelligent automation system that turns WhatsApp into your personal receipt manager — integrating Meta WhatsApp Cloud API, Google Drive, Google Sheets, and OpenAI GPT-4o-mini via n8n. 🎥 Demo: Watch the Loom walkthrough ⚙️ What It Does The AI-Powered WhatsApp Receipt Bot automates the complete invoice handling process through a conversational interface. Workflow Summary: User sends a receipt image via WhatsApp. The bot automatically downloads the media using the WhatsApp Cloud API. The image is uploaded to a Google Drive “Invoices” folder. The file is shared publicly, generating a shareable URL. The receipt is analyzed using OpenAI GPT-4o-mini to extract structured data: Store name Items purchased Payment method Total amount The extracted details are appended to a Google Sheet for record-keeping. The bot sends a human-readable summary back to WhatsApp with emojis and the invoice link. Output Example: 🏬 Store: Big Bazaar 📝 Items: Rice, Detergent, Snacks 💳 Payment: Card 💰 Total: ₹1520.75 🔗 Link: https://drive.google.com/file/d/1abcXYZ/view This system eliminates manual expense tracking, improves accuracy through OCR, and provides a seamless way to manage receipts in real time. 💡 Use Cases | Scenario | Description | | ------------------------------------- | --------------------------------------------------------------------------------------------------------------------- | | Personal Expense Management | Automatically store and categorize receipts from daily purchases. | | Business Accounting | Collect employee expense receipts through WhatsApp and centralize them in Google Sheets. | | Freelancer or Consultant Tracking | Keep a digital record of client reimbursements or software purchase receipts. | | Family Budgeting | Family members send receipts to one shared WhatsApp number, all data gets logged centrally. | | E-commerce / Delivery Teams | Drivers or delivery agents send invoices from the field to WhatsApp; data automatically goes to the accounting sheet. | 🔧 Setup Accounts and Tools Needed | Tool | Purpose | Link | | -------------------------- | ------------------------------------------- | -------------------------------------------------------------------------------------------- | | Meta Developer Account | To access WhatsApp Business Cloud API | https://developers.facebook.com/apps | | Google Cloud Account | For enabling Drive and Sheets APIs | https://console.cloud.google.com | | n8n Instance | Workflow automation engine (local or cloud) | https://app.n8n.cloud | | OpenAI API Key | For GPT-4o-mini model OCR + reasoning | https://platform.openai.com/account/api-keys | Meta Developer Setup (WhatsApp Cloud API) Go to Meta Developer Dashboard → My Apps → Create App → Business type. Add WhatsApp product under your app. Retrieve the following from WhatsApp > Configuration: Permanent Access Token Phone Number ID WhatsApp Business Account ID Add these credentials in n8n → Credentials → WhatsApp API. Use the same credentials for WhatsApp Trigger and Send Message nodes. Verify webhook in Meta with your n8n webhook URL. Important: In your HTTP Node, set the header as: Authorization: Bearer <access_token> Replace <access_token> with your WhatsApp Cloud API permanent token. Without this, the workflow will fail to send or receive WhatsApp messages properly. Google Drive Setup Create a folder named Invoices on your Google Drive. Copy the Folder ID (found in the Drive URL). In Google Cloud Console → APIs & Services → Enable APIs: Enable Google Drive API Enable Google Sheets API Go to Credentials → Create Credentials → OAuth 2.0 Client ID. Download the credentials.json file. Upload this to n8n → Credentials → Google Drive OAuth2 API. Authorize the connection on first workflow run. Google Sheets Setup Create a new Google Sheet titled Invoices. Add the following headers in Row 1: store name | discription | image_url | payment | total Copy the Sheet ID (from the URL). Add the ID under the Google Sheets Append node in n8n. Map each field to its corresponding value extracted from the OCR result. OpenAI Setup Generate an API key from https://platform.openai.com/account/api-keys. Add it to n8n → Credentials → OpenAI API. Use model gpt-4o-mini in the “Analyze Image” node. Can upgrade to gpt-4o for better OCR accuracy if account supports it. n8n Workflow Setup Import the provided n8n workflow JSON. Configure credentials for: WhatsApp API Google Drive OAuth2 Google Sheets OAuth2 OpenAI API Activate workflow and set webhook in Meta Developer console. Send a test receipt image to your WhatsApp Business number. The bot will automatically: Download → Upload → Extract → Log → Summarize → Reply 📊 Example Google Sheet Record | store name | discription | image_url | payment | total | | ---------- | ----------------------- | -------------------------------------------------------------------------------------------- | ------- | ------- | | Big Bazaar | Rice, Detergent, Snacks | https://drive.google.com/file/d/1abcXYZ/view | Card | 1520.75 | 🧠 Result A fully automated AI pipeline that transforms WhatsApp into a smart expense-tracking interface — integrating vision, automation, and natural language processing for zero-manual financial documentation. Support & Contact: If you face any issues during setup or execution, contact: 📧 Email: [email protected] 🔗 LinkedIn: Atharva Jaiswal

WhatsApp AI Assistant for Clinic Appointment Booking Automate your entire appointment lifecycle with an intelligent AI assistant that lives on WhatsApp. This workflow empowers any clinic or independent practitioner to manage bookings, take payments, and send reminders without manual intervention, using Google Sheets as a simple database. This template handles everything from the initial booking conversation to sending the final reminder, allowing you to focus on your patients, not your schedule. Features 🤖 Conversational AI Booking: A Google Gemini-powered agent guides patients through booking, rescheduling, and canceling appointments in a natural, friendly chat. 🗓️ Smart Scheduling: The AI checks for available slots based on your working hours and existing appointments in Google Sheets, preventing double-bookings. 🔔 Automated Reminders: A daily trigger automatically sends WhatsApp reminders to patients for their appointments on that day, reducing no-shows. 💳 Seamless Payments: Integrated with Stripe to handle online payments. The workflow sends a confirmation message upon successful payment. 📊 Centralized Management: Uses a single Google Sheet with separate tabs for Patients, Appointments, and Configuration, making it easy to view and manage all your data. 🔄 Easy Rescheduling & Cancellations: Patients can manage their own bookings through the WhatsApp chat, and all changes are instantly reflected in your Google Sheet. Prerequisites Before you begin, you will need the following accounts and credentials: n8n Account: A running n8n instance (cloud or self-hosted). WhatsApp Business Account: Access to the WhatsApp Cloud API. Google Account: For using Google Sheets and the Google Gemini (AI) API. Stripe Account: To process online payments. n8n Credentials: You must configure credentials in your n8n instance for: WhatsApp Cloud API Google Sheets (OAuth2) Google Gemini API Stripe Setup Instructions Follow these steps carefully to get your automated assistant up and running. Step 1: Set Up Your Google Sheet This workflow relies on a specific Google Sheet structure. Create a new Google Sheet. Rename the sheet to something memorable, like "Clinic Appointments". Create three tabs at the bottom with the exact names: Patients, Appointments, and Config. Set up the columns for each tab as follows (the header names must be an exact match): Patients tab: patient_id, whatsapp_number, name, age, gender Appointments tab: appointment_id, patient_id, whatsapp_number, date, time, payment_method, payment_status, status, stripe_payment_intent Config tab: key, value (Add a row with working_hours as the key and a value like 10:00-18:00) Step 2: Configure the Workflow Nodes Now, you'll link the workflow to your accounts and your new Google Sheet. Update All Google Sheets Nodes: Go through every Google Sheets node in the workflow (e.g., "Get Appointment sheet", "Add Patient", "Google Sheets Trigger") and do the following: Select your Google Sheets credential from the dropdown. In the Document ID field, paste the ID of your Google Sheet. Select the correct sheet (Appointments, Patients, etc.) from the Sheet Name dropdown. Update All WhatsApp Nodes: Go through every WhatsApp node (e.g., "Send message", "WhatsApp Trigger", "Send Payment Confirmation"): Select your WhatsApp credential. Enter your Phone Number ID from your Meta for Developers account. Update AI & Stripe Nodes: In the Google Gemini Chat Model nodes, select your Google Gemini credential. In the Stripe Trigger node, select your Stripe credential. Step 3: Activate the Workflow Click Save to apply your changes. Click the Activate toggle in the top-right corner to turn the workflow on. Your AI appointment assistant is now live! Send a message to your WhatsApp number to begin testing. Customization Change Reminder Time: To change the daily reminder time, open the Schedule Trigger node and adjust the hour from the default of 8 AM. Edit AI Personality: To modify how the AI communicates, edit the system message in the AI Agent node (the one connected to the WhatsApp Trigger). You can change its tone, instructions, or language.

GitHub Bounty Issue Tracker & Alert System (Google Sheets + Email/WhatsApp) Overview Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google Sheets, and sends instant alerts via Email (HTML-styled) or WhatsApp. Perfect for developers, freelancers, and open-source contributors who want to discover and claim paid opportunities faster. What This Workflow Does 🔎 Automated Bounty Discovery Searches GitHub hourly for all open issues labeled with “💎 Bounty.” Filters duplicates to avoid re-tracking the same issue. 📢 Smart Notifications Sends styled HTML email alerts with GitHub-themed design. WhatsApp Business API integration (optional, disabled by default). Alerts only for bounties created within the last 5 days. 📊 Google Sheets Tracking Sheet1**: Complete bounty list (all tracked issues). Sheet2**: Recent notification log (for quick reference). 🔄 Status Updates Checks every 6 hours for issue changes (open/closed state, new comments). Includes bounty amount, issue details, and direct GitHub links. Use Cases 👩‍💻 Freelance developers hunting for paid open-source work. 🛠 Development teams tracking bounty opportunities for their stack. 🌍 Community managers monitoring open-source bounty program engagement. 🤝 Open-source contributors looking for compensated tasks. Requirements GitHub Personal Access Token (with repo access). Google Sheets (2 sheets required: Sheet1 = bounties, Sheet2 = notifications). Gmail account (OAuth2 for sending email alerts). WhatsApp Business API credentials (optional). Configuration Notes This workflow supports pagination for large result sets and includes filters to prevent duplicate notifications. You can customize the GitHub search query in the HTTP Request node to target: Specific repositories Custom labels Team/organization projects Frequently Asked Questions (FAQ) Q: How often will I get notifications? A: By default, new bounties trigger alerts once an hour. Updates on existing issues (status/comments) are checked every 6 hours. Q: Do I need WhatsApp integration? A: No, it’s optional. Email alerts work out-of-the-box. Q: Can I filter by bounty amount? A: Yes, the workflow extracts bounty details and you can add filters in your Google Sheets or notification logic. Why Use This GitHub Bounty Tracker? Unlike manual searches, this workflow ensures you never miss a paid GitHub issue. Whether you’re a freelancer looking for income, a team seeking funded tasks, or a contributor wanting recognition and rewards, this system keeps you updated automatically.

Summarize YouTube Videos with Gemini AI, Google Sheets & WhatsApp/Telegram Aim The aim of the YouTube Video Summarizer Workflow is to automate the process of summarizing or extracting transcripts from YouTube videos with the help of Gemini AI, while optionally storing results and distributing them to users via WhatsApp, Telegram, or Google Sheets. This enables fast, consistent generation and sharing of English summaries or transcripts from public YouTube content. Goal The goal is to: Allow users to submit a YouTube link through various channels (Form Webhook, WhatsApp, Telegram). Use Gemini AI to either summarize the content or transcribe the complete video, always outputting in English. Return the output to the user via their original channel and optionally log it to Google Sheets for record-keeping. Requirements The workflow relies on specific integrations and configurations: n8n Platform**: Self-hosted or cloud n8n instance to host and automate the workflow. Node Requirements**: Form/Webhook Trigger: Web form for pasting the YouTube link. WhatsApp Trigger: Starts workflow from incoming WhatsApp messages (YouTube link as input). Telegram Trigger: Initiates workflow from Telegram chat messages containing YouTube links. Gemini AI Node: Consumes the YouTube link and processes it for summarization or transcription (always in English). Google Sheets Node: Writes the result (summary/transcript) into a Google Sheet for logging and future reference. WhatsApp/Telgram Send Message Nodes: Delivers summarized results or transcripts back to the user on the same platform where they triggered the workflow. Credentials**: Gemini/Google AI Platform account for AI summarization and transcription. Google Sheets account for storing output. WhatsApp Business API for WhatsApp automation. Telegram Bot API for Telegram automation. Input Requirements**: Publicly-accessible YouTube video link (max ~30 min, as per summarized logic). Output**: English video summary or full transcript, delivered via user’s requested channel and/or stored in Google Sheets. API Usage The workflow integrates several APIs for optimal automation: Gemini AI API**: Used in the main summarization node. Receives the YouTube link and a prompt with detailed instructions. Returns either a clear, concise English summary or a full transcript translated into English, handling Hindi, English, or mixed-language videos. [Ref: Workflow JSON] Google Sheets API**: Used to log the output for each processed video, making it easy to reference histories or track requests. [Ref: Workflow JSON] WhatsApp Business API**: Sends back the summary or transcript to the user who initiated via WhatsApp. [Ref: Workflow JSON] Telegram Bot API**: Sends results back to Telegram users directly in chat. [Ref: Workflow JSON] Output Formatting/Conversion The AI output is always in English, tailored to the option chosen (summary vs transcript). Structured output: Bulleted, neutral, and easy to read, suitable for sharing with users or for business documentation. Google Sheets node maps and writes each video’s results to a dedicated row for easy history review. How to Use By default, the workflow uses a manual trigger via a web form, but you may add triggers for WhatsApp or Telegram to suit your needs. Users paste a YouTube link, then select whether they want a summary or transcript (based on your implementation logic). Results are returned in their channel and optionally logged to your Google Sheet. All processing is handled securely using your Gemini API credentials. You can expand this logic by adding more integrations (email, Slack, etc.). Customising this Workflow Custom prompts can be written for different styles or output formats (e.g., SEO key points, step-by-step guides). Add logic for batch processing multiple videos or bulk export to different cloud drives. Integrate into central dashboards, CRMs, or content pipelines using n8n’s hundreds of available integrations. Good to Know Gemini pricing:** At the time of writing, each YouTube video summarization costs $0.039 USD. See official Gemini Pricing for current rates. Geo-restriction:** The Gemini video model may be geo-restricted (error: “model not found” outside some regions). Video Limits:** Intended for videos up to ~30 minutes for best processing reliability. Scaling:** Can be easily adapted for high-volume operations using n8n’s queue and scheduling features. Workflow Summary The YouTube Video Summarizer Workflow automates summarizing and transcribing YouTube videos using AI and n8n. Users send video links via web forms, WhatsApp, or Telegram. Results are generated via Gemini, sent back in-app, and logged to Google Sheets, enabling effortless knowledge sharing and organizational automation at scale. Timestamp: 12:37 PM IST, Wednesday, September 17, 2025

AI-Powered Customer Service Automation with Smart Routing How it works Core Intelligence Pipeline • Multi-Layer Message Analysis - Every customer interaction passes through three specialized AI classifiers: privacy detection (identifies sensitive data and security requirements), intent recognition (categorizes requests as purchases, inquiries, complaints, technical support, or order tracking), and sentiment analysis (monitors emotional tone from neutral to critical frustration levels) • Dynamic Knowledge Integration - The system maintains live connections to your company's knowledge base and order management systems, automatically querying relevant information before crafting responses. This ensures accuracy and eliminates outdated information while providing real-time order status updates • Conversational Memory & Context - Advanced chat memory preserves conversation history across sessions, enabling the AI to maintain context, avoid repetitive responses, and build on previous interactions for more natural, human-like conversations • Intelligent Response Generation - The AI agent synthesizes information from multiple sources (knowledge base, order systems, conversation history) while adapting its tone and approach based on detected customer sentiment and privacy requirements Smart Escalation System • Automated Triage Classification - A sophisticated routing engine categorizes each interaction into four escalation levels: Normal (AI-handled routine inquiries), Human Request (explicit agent requests), Critical Complaint (serious issues requiring immediate attention), and Owner Escalation (extreme situations with legal implications or persistent anger) • Context-Aware Handoffs - When escalation is required, the system automatically generates comprehensive situation summaries for human agents, including conversation history, customer sentiment analysis, and specific issue classification • Multi-Channel Notifications - Escalated cases trigger appropriate alerts via email to designated team members based on severity level, ensuring proper resource allocation and response times Data Intelligence & Analytics • Comprehensive Interaction Logging - Every conversation is captured with full context including customer sentiment, intent classification, AI responses, and escalation decisions, creating a rich dataset for performance analysis and system improvement • Conversation Context Generation - For escalated cases, the system automatically produces detailed conversation summaries and context reports to help human agents understand the full situation before taking over Set up steps Platform Integration (20-30 minutes) • Messaging Platform Connection - Configure your primary communication channel (supports multiple messaging platforms) with proper API credentials and webhook setup for real-time message processing • AI Service Configuration - Connect OpenAI API credentials for the language models powering the classification engines and response generation • Database Setup - Establish connections to your customer database and order management systems for personalized responses and order tracking capabilities Knowledge Base Preparation (45-60 minutes) • Company Information Import - Upload or connect your existing knowledge base, including product catalogs, policy documents, FAQ sections, and troubleshooting guides • Order Database Integration - Link your order management system to enable real-time order status queries, shipping tracking, and return processing • Response Templates - Configure standard response patterns and company voice guidelines to ensure consistent brand communication Escalation & Routing Setup (15-25 minutes) • Team Structure Configuration - Define escalation paths and assign notification recipients for different severity levels (standard support, critical complaints, owner-level issues) • Email Integration - Connect email service for automated escalation notifications with customizable templates for different situation types • Escalation Triggers - Fine-tune the classification thresholds that determine when conversations require human intervention Testing & Optimization (30-45 minutes) • Conversation Flow Testing - Run comprehensive test scenarios covering various customer intents, sentiment levels, and escalation triggers to validate system responses • Knowledge Base Validation - Verify that the AI can accurately retrieve and apply information from your knowledge base for common customer queries • Escalation Path Verification - Test all escalation routes to ensure proper notifications and handoff procedures are functioning correctly • Performance Monitoring Setup - Configure analytics tracking to monitor response accuracy, escalation rates, and customer satisfaction metrics Advanced Configuration (Optional - 30-60 minutes) • Multi-Language Support - Configure language detection and response capabilities for international customer base • Custom Classification Rules - Adjust intent and sentiment classification parameters based on your specific business context and customer communication patterns • Integration Extensions - Connect additional business systems (CRM, billing, inventory) for enhanced customer service capabilities Technical Specifications AI Models & Processing • Powered by GPT-4 family models for natural language understanding and generation • Real-time voice transcription capabilities for multi-modal customer interactions • Structured output parsing for consistent data classification and routing decisions • Context-aware memory management with configurable conversation history retention Data Security & Privacy • Automatic detection of sensitive information with privacy-first handling protocols • Configurable data retention policies and secure storage of conversation logs • Customer verification requirements for accessing sensitive account information • GDPR-compliant data processing and storage practices Scalability & Performance • Modular architecture supporting easy integration of additional messaging platforms • Database-agnostic design (supports PostgreSQL, Supabase, and other systems) • Horizontal scaling capabilities for high-volume customer service operations • Real-time processing with minimal latency for immediate customer responses Detailed technical implementation guides, API configuration examples, and troubleshooting documentation are embedded within the workflow nodes for development teams.

Who's it for Business owners, marketers, and web developers who want to instantly respond to website contact form submissions and maintain organized lead records without manual monitoring. What it does This workflow automatically processes contact form submissions from your website, sending immediate WhatsApp notifications with formatted lead details while simultaneously logging all data to Google Sheets for organized lead management and follow-up tracking. How it works When someone submits your website contact form, the webhook instantly receives the data, formats it into a professional WhatsApp message with emojis and structure, sends the notification to your phone, and logs all details (name, email, phone, service, message, timestamp) to a Google Sheets database for permanent storage and analysis. Requirements WhatsApp Business API credentials Google Sheets API access with a spreadsheet containing these columns: date (for timestamp) name (contact's full name) email (contact's email address) phone (contact's phone number) service (requested service/interest) message (contact's message/inquiry) Website contact form that can POST to webhook URL with fields: name, email, phone, service, message n8n instance (self-hosted or cloud) Google Sheets Setup Create a new Google Sheet with the following column headers in row 1: Column A: date Column B: name Column C: email Column D: phone Column E: service Column F: message The workflow will automatically populate these columns with each form submission and use the date column for duplicate checking. How to set up Credentials Setup: Configure WhatsApp Business API credentials in the WhatsApp node Set up Google Sheets API connection and grant necessary permissions Configuration: Update the recipient phone number in the WhatsApp node (format: +1234567890) Replace the Google Sheets document ID with your spreadsheet ID Ensure your Google Sheet has the required column structure mentioned above Integration: Copy the webhook URL from the Contact Form Trigger node Configure your website form to POST data to this endpoint with field names: name, email, phone, service, message Testing: Test the workflow by submitting a sample form entry Verify WhatsApp notification is received and data appears in Google Sheets How to customize the workflow Message Format:** Modify the WhatsApp message template in the Format Lead Data node Additional Fields:** Add more form fields by updating both the Code node and Google Sheets mapping Email Notifications:** Include email alerts by adding an Email node after the Format Lead Data node Conditional Logic:** Set up different notifications for high-priority services or VIP customers Data Validation:** Add filtering rules in the Code node to handle spam or invalid submissions Multiple Recipients:** Configure the WhatsApp node to send alerts to multiple team members

This n8n workflow monitors blood stock levels daily and sends alerts when availability is low. It fetches data from a Google Sheet, checks stock status, and notifies via WhatsApp. Key Features Daily Monitoring**: Checks blood stock every day. Automated Alerts**: Sends notifications when stock is low. Real-Time Updates**: Uses live data from Google Sheets. Efficient Delivery**: Alerts sent instantly via WhatsApp. Continuous Check**: Loops to ensure ongoing monitoring. Workflow Process Daily Check Blood Stock: Triggers the workflow daily. Fetch Blood Stock: Reads data from a Google Sheet. Get All Stock: Collects all available blood stock details. Check Stock Availability: Analyzes stock levels for low thresholds. Send Alert Message: Sends WhatsApp alerts if stock is low. Sheet Columns Blood Type**: Type of blood (e.g., A+, O-). Quantity**: Current stock amount. Threshold**: Minimum acceptable stock level. Last Updated**: Date and time of last update. Status**: Current status (e.g., Low, Sufficient). Setup Instructions Import Workflow**: Add the workflow to n8n via the import option. Configure Sheet**: Set up a Google Sheet with blood stock data. Set Up WhatsApp**: Configure WhatsApp API credentials in n8n. Activate**: Save and enable the workflow. Test**: Simulate low stock to verify alerts. Requirements n8n Instance**: Hosted or cloud-based n8n setup. Google Sheets**: Access with stock data. WhatsApp API**: Integration for sending alerts. Admin Access**: For monitoring and updates. Customization Options Adjust Threshold**: Change low stock limits. Add Channels**: Include email or SMS alerts. Update Frequency**: Modify daily trigger time.

This n8n workflow monitors medical equipment usage by reading data daily at 6 AM from a Google Sheet, processes alerts for maintenance or calibration, and sends notifications to technicians and supervisors. Good to Know Runs daily at 6 AM via cron trigger. Requires Google Sheet with equipment data. Sends alerts via email and WhatsApp. Logs all activities in the Google Sheet. Google Sheet Structure Sheet: A: Equipment ID | B: Equipment Name | C: Last Maintenance Date | D: Usage Hours E: Calibration Due | F: Status | G: Technician Email | H: Supervisor Email | I: Last Alert Date Sample Data: E001 | MRI Machine | 2025-07-01 | 150 | 2025-08-15 | Active | [email protected] | [email protected] | 2025-08-01 E002 | X-Ray Unit | 2025-06-15 | 200 | 2025-08-10 | Overdue | [email protected] | [email protected] | 2025-08-05 How It Works Daily Equipment Check (6 AM)** - Triggers the workflow. Read Equipment Data** - Fetches data from Google Sheet. Process Equipment Alerts** - Identifies maintenance needs. Task Break For 5 Sec** - Adds a delay for processing. Filter Equipment with Alerts** - Filters equipment needing attention. Send Technician Email** - Notifies technicians via email. Send Message (message: send)** - Sends WhatsApp alerts to technicians. Send Critical Alert to Supervisors** - Escalates critical issues via email and WhatsApp. Filter Overdue Equipment** - Identifies overdue maintenance. Update Equipment Status** - Updates sheet with new statuses. Log Maintenance Alerts** - Logs alerts in the sheet. How to Use Import workflow JSON into n8n. Configure nodes with Google Sheet ID, email, and WhatsApp API credentials. Add equipment data to the Google Sheet. Test manually, then activate for daily runs. Requirements Google Sheet with specified structure. Google service account credentials. Email SMTP setup (e.g., Gmail). WhatsApp Business API token. n8n instance. Customizing This Workflow Adjust cron time for different schedules. Modify alert thresholds in the Process Equipment Alerts node. Update notification templates in email and WhatsApp nodes. Extend filters for additional equipment statuses. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team

Overview Turn WhatsApp chats into instant answers and real-time bookings—all in one n8n workflow. Your AI Agent leverages Gemini embeddings + Pinecone for on-the-fly knowledge retrieval, then logs reservations directly into Google Sheets. Features AI-powered Q&A: Natural-language responses driven by Gemini + Pinecone vector search Seamless Reservations: Book services via WhatsApp; entries auto-append to Google Sheets Auto-Embedding Sub-workflow: Drag-and-drop Google Drive docs get indexed in Pinecone 24-Hour Follow-Up: Automated template messages if no response within a day Personal Support Pledge: Hands-on help until your workflow runs flawlessly Requirements n8n account (self-hosted or n8n.cloud) Google Cloud project with Gemini & Drive APIs enabled Pinecone account (free tier works) Google Sheets account WhatsApp Business API credentials (e.g. Twilio, 360dialog) Setup Instructions Import Workflow Download the .json file from your Gumroad purchase In n8n Editor → Import → From File → select the JSON Add Credentials Google Service Account (Gemini & Drive APIs) Pinecone (API Key + Environment) Google Sheets OAuth2 WhatsApp Business API (HTTP credential or native) Configure Nodes AI Agent: select Gemini credentials; update system prompt with your business name & services Pinecone Loader: point “Google Drive” node to your docs folder Sheets Append: set Spreadsheet ID, sheet name “reservations”, map Timestamp, UserID, Service, Date, Time, Notes WhatsApp Trigger & Send: set webhook URL; choose approved template name Test End-to-End Activate the workflow → send a test WhatsApp message → verify AI reply + new row in your sheet Google Sheet Structure Column Description Timestamp Auto-generated when a user books UserID : Unique WhatsApp user identifier Service : Chosen service or product name Date : Booking date Time : Booking time slot Notes : Any extra information (e.g., special requests) Customization Add New Services: Edit the system prompt’s services list Change Follow-Up Window: Adjust the “24-hour window check” node logic Embed Different Docs: Point the Drive node at any folder of PDFs/TXT 📞 Personal Support Pledge: I’ll work with you (via WhatsApp or email, remote desktop ) until your workflow is running flawlessly—no extra fees, no “good luck” drop‑off. Just send a message via: Email: [email protected] WhatsApp: +20 106 180 3236

This workflow automatically sends timely medication reminders to patients after a prescription is marked as sent in the system. It reads the medication schedule from prescription data, schedules reminders for each dosage time, and delivers notifications via WhatsApp, SMS, or email. All reminders are tracked and logged, ensuring patients stay on track with their treatment while providing healthcare providers with acknowledgment records. 📋 Simple Google Sheets Structure "Prescriptions" Sheet - Required columns: prescription_id patient_name patient_phone patient_email medication dosage times_per_day (1, 2, 3, or 4) duration_days (7, 14, 30, etc.) start_date (YYYY-MM-DD) prescription_status (set to "sent") reminders_created (auto-updated to "yes") "Reminders" Sheet (auto-created): Simple tracking of all scheduled reminders 🔧 Workflow Components (Only 10 Nodes!) Part 1: Schedule Creation Watch Sheet → Monitors for "sent" prescriptions Filter New → Only processes unscheduled prescriptions Create Schedule → Generates reminder times automatically Save Reminders → Stores schedule in sheet Mark Processed → Prevents duplicate scheduling Part 2: Send Reminders Cron Timer → Checks every 10 minutes Get Reminders → Retrieves all scheduled reminders Find Due → Identifies reminders due now Send Messages → WhatsApp + Email simultaneously Mark Sent → Updates status to prevent duplicates ⚙️ Simple Setup Replace these values: YOUR_GOOGLE_SHEET_ID YOUR_WHATSAPP_PHONE_NUMBER_ID Email sender address Add credentials: Google Sheets API WhatsApp API SMTP for email Sample data: prescription_id: RX001 patient_name: John Doe patient_phone: +1234567890 patient_email: [email protected] medication: Amoxicillin 500mg dosage: 1 tablet times_per_day: 3 duration_days: 7 start_date: 2025-01-15 prescription_status: sent reminders_created: no 📱 Default Schedule 1x daily:** 9:00 AM 2x daily:** 9:00 AM, 9:00 PM 3x daily:** 8:00 AM, 2:00 PM, 8:00 PM 4x daily:** 8:00 AM, 12:00 PM, 4:00 PM, 8:00 PM

This is a fully working n8n workflow that sends prescriptions to patients via email and WhatsApp when a doctor enters prescription data into a Google Sheet. 📋 Google Sheets Structure Main Sheet: Required columns: prescription_id (unique ID) patient_name patient_email patient_phone doctor_name prescription_date prescription_details dosage_instructions followup_date (optional) prescription_status (set to "new" for new prescriptions) Log Sheet: This will be auto-created with columns for tracking sent notifications. 🔧 Required Credentials Setup Google Sheets OAuth2 API: Connect your Google account SMTP Credentials: For email sending (Gmail, Outlook, etc.) WhatsApp API: Meta Business WhatsApp API credentials ⚙️ Configuration Steps Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID Replace YOUR_WHATSAPP_PHONE_NUMBER_ID with your WhatsApp Business phone number ID Update the email sender address in the "Send Email" node Set up your credentials in n8n 🌟 Features Included Automated Trigger**: Monitors Google Sheet for new prescriptions Smart Filtering**: Only processes prescriptions with status "new" Rich Email Format**: Professional HTML email with prescription details WhatsApp Integration**: Sends formatted prescription text Comprehensive Logging**: Tracks all sent notifications Status Updates**: Marks prescriptions as "sent" after processing Error Handling**: Logs success/failure status for both channels 📱 Sample Data Format Add rows to your sheet like this: prescription_id: RX001 patient_name: John Doe patient_email: [email protected] patient_phone: +1234567890 doctor_name: Dr. Smith prescription_date: 2025-01-15 prescription_details: Amoxicillin 500mg capsules dosage_instructions: Take 1 capsule 3 times daily with food followup_date: 2025-01-22 prescription_status: new

This automated n8n workflow monitors API uptime by periodically checking API availability and sending instant WhatsApp alerts if any service goes down. It retrieves API details from a Google Sheet and includes retry logic for failed requests. Good to Know Checks API status every 15 minutes Integrates with Google Sheets for API list management Implements a retry mechanism with up to 4 attempts Sends WhatsApp alerts for downtime Supports customizable API request configurations How It Works Schedule Trigger** - Triggers every 15 minutes Read API List** - Fetches all API URLs from a Google Sheet Process Each API1** - Loops through each API entry Init Retry Counter** - Initializes retryCount = 0 Test API** - Sends the first request to the API Check Response** - Checks if a valid response was received If No Response** - Branches into retry flow if down Wait 10 Min → Increment Retry → Retry API → Check Retry Response** - Wait and retry API call once If Still No Response** - Verifies if retry also failed If Still No Retry > 4** - Checks if retry limit is reached (≥ 4) Format Down Alert** - Formats the WhatsApp alert with API details Send WhatsApp Alert** - Sends API down alert to the configured number Continue Next API** - Moves to the next API in the list How to Use Import workflow into n8n Configure Google Sheets API for API list access Set up WhatsApp API for alerts Define API details in Google Sheet Test with sample APIs and verify alerts Adjust retry limits or schedule as needed Requirements Access to Google Sheets API WhatsApp API configuration Scheduled trigger setup in n8n Sheet Structure | Sheet Column | Example Data | | -------------------- | ------------------------------------------------------------ | | name | Timeout Test | | method | GET | | url | https://httpbin.org/delay/15 | | headers | {"Content-Type": "application/json"} | | body | {"key": "value"} | | expectedField | status | | expectedValue | success | | expectedStatusCode | 200 | Customizing This Workflow Modify trigger interval Adjust retry limits or wait times Customize WhatsApp alert format Add additional API headers or body data Integrate with other notification services

This n8n template demonstrates how to create an automated construction progress notification system for real estate companies. The workflow triggers daily at 8:00 AM IST to check a Google Sheet for contractor construction reports, automatically processes the data, and sends comprehensive project updates to buyers via email and WhatsApp. Perfect for real estate developers wanting to maintain transparent communication with buyers and ensure timely project status updates. Good to know Daily automated monitoring ensures no construction updates are missed Multi-channel communication (Email + WhatsApp) reaches buyers through their preferred method Smart filtering system only processes today's reports for relevant updates Comprehensive logging tracks all notification activities for audit purposes Built-in alert system notifies administrators when contractors fail to submit reports Handles multiple projects and contractors simultaneously without data conflicts How it works Daily Monitoring Workflow System triggers automatically every day at 8:00 AM IST to check for new construction reports Google Sheet configuration is set with Sheet ID, sheet name, and today's date for filtering All construction data is read from the designated Google Sheet containing contractor submissions Advanced filtering isolates only today's reports based on the Date column for processing Report Processing Workflow System checks if any construction reports were submitted for the current date If reports are found: Detailed notifications are prepared and sent to all registered buyers If no reports are found: Alert notifications are sent to administrators about missing submissions All project data is compiled into comprehensive summaries with progress percentages and status updates Notification Distribution Workflow Email notifications contain detailed construction summaries with all project information WhatsApp messages provide concise updates with key progress indicators and status Messages are personalized with project names, completion percentages, and contractor details Multiple recipients receive notifications simultaneously through both communication channels Activity Logging Workflow All notification activities are logged with precise timestamps and recipient information Success logs record project count, recipient numbers, and delivery confirmation Warning logs capture instances when no reports are found for administrative follow-up Complete audit trail maintains compliance and tracking for project management Google Sheet Structure Construction Reports Sheet Date - Report submission date (DD/MM/YYYY format) Project_Name - Name of the construction project Contractor_Name - Name of the responsible contractor Location - Project location or site address Progress_Percentage - Current completion percentage (0-100%) Status - Current project status (On Track, Delayed, Completed, etc.) Work_Description - Detailed description of today's construction activities Issues - Any problems or challenges encountered (optional) Budget_Status - Financial status update (On Budget, Over Budget, Under Budget) Next_Milestone - Upcoming project milestone or target date How to use Import the workflow into your n8n instance and configure Google Sheets integration Set up your Google Sheet with the required column structure for construction reports Configure email SMTP settings for professional construction update delivery Set up WhatsApp Business API for instant mobile notifications to buyers Add buyer email addresses and WhatsApp numbers to the notification recipient lists Contractors submit daily reports to the Google Sheet before 8:00 AM for same-day processing System automatically processes and distributes updates to all registered buyers Monitor logs for delivery confirmation and missing report alerts Requirements Google Sheets account for construction report data storage and management Email service integration (Gmail, SMTP, or corporate email system) WhatsApp Business API account for mobile messaging capabilities n8n instance with Google Sheets, Email, and WhatsApp connectors properly configured Valid credentials for all integrated services (Google OAuth, SMTP, WhatsApp API) Customising this workflow Construction update automation can be adapted for different project types and development scales Try popular use-cases such as weekly progress summaries, milestone notifications, or emergency construction alerts The workflow can be extended to include photo attachments from construction sites, weather impact assessments, and safety compliance reporting Integration possibilities include CRM systems for buyer management, project management tools for contractor coordination, and financial systems for budget tracking Notification scheduling can be adjusted for different time zones, multiple daily updates, or project-specific timing requirements Advanced features can include buyer feedback collection, contractor performance ratings, and automated delay notifications with mitigation plans

AI Blog Automation System Description This comprehensive N8N automation template revolutionizes content creation by delivering a complete end-to-end solution for AI-powered blog generation. Transform simple ideas into fully SEO-optimized, WordPress-ready articles that rank higher and drive organic traffic to your website. The system accepts blog requests from multiple communication channels (Telegram, WhatsApp, Slack, Gmail) and automatically processes them through an intelligent pipeline that includes advanced keyword research, competitor analysis, and market insights. Using cutting-edge AI models like GPT-4 and OpenRouter, the workflow generates detailed content outlines, conducts comprehensive research, and produces high-quality, engaging blog posts that are automatically formatted and published directly to your WordPress website. What sets this template apart is its focus on SEO excellence - every piece of content is optimized for search engines with proper keyword density, meta descriptions, internal linking strategies, and content structure that search engines love. The integrated content tracking system maintains a database of all published articles, enabling smart internal linking recommendations and content performance monitoring. Key Features 🤖 Advanced AI Content Generation GPT-4 & OpenRouter Integration** - Leverage the most powerful AI models for superior content quality Multi-stage content refinement** - From outline to final polish, ensuring professional-grade articles Topic research and fact-checking** - AI conducts deep research to create authoritative, well-sourced content 🎯 SEO Optimization at Every Step Intelligent keyword research** - Automatic discovery of high-volume, low-competition keywords Competitor analysis** - Analyze top-ranking content to identify content gaps and opportunities On-page SEO optimization** - Perfect keyword density, meta descriptions, and heading structure Internal linking strategy** - Smart recommendations for linking to existing content SEO-friendly URL generation** - Automatically create search-engine optimized permalinks 🔌 Seamless WordPress Integration Direct publishing** - Articles go live on your WordPress site without manual intervention Custom post formatting** - Proper heading tags, featured images, and category assignment Draft and scheduling options** - Choose immediate publishing or schedule for optimal timing Media handling** - Automatic image optimization and alt-text generation 📱 Multi-Platform Input System Telegram, WhatsApp, Slack, Gmail support** - Accept blog ideas from your preferred communication channels Voice message transcription** - Convert audio ideas into written blog requests Email parsing** - Extract blog topics from client emails or team communications Priority queue management** - Handle multiple requests efficiently with smart prioritization 📊 Content Management & Analytics Comprehensive content database** - Track all published articles, keywords, and performance metrics Internal linking opportunities** - Automatic suggestions for connecting related content Publishing schedule optimization** - AI-recommended posting times for maximum engagement Performance tracking** - Monitor which topics and keywords drive the most traffic 📋 Complete Setup Guide Included This template comes with a comprehensive step-by-step setup guide that walks you through: N8N workflow installation and configuration** API key setup** for all integrated services (OpenAI, WordPress, communication platforms) WordPress plugin installation** and permissions configuration Database setup** for content tracking and analytics Custom field configuration** for SEO optimization Webhook configuration** for multi-platform input Testing procedures** to ensure everything works perfectly Troubleshooting guide** for common issues Best practices** for content optimization and workflow management Perfect for content creators, digital marketers, SEO specialists, and enterprises looking to scale their content production while maintaining high quality and search engine visibility. Whether you're managing a single blog or multiple WordPress sites, this automation system transforms your content workflow from manual labor to intelligent automation.

Streamline restaurant reservations on WhatsApp Overview This n8n template automates table bookings via WhatsApp, letting users request, confirm, and manage reservations without manual intervention. It leverages AI to parse messages, apply group discounts, check availability, and send natural confirmations—all within a single, reusable workflow. Key Features AI‑powered parsing & responses**: Extracts guest name, date, time, and party size from free‑form WhatsApp messages and generates friendly confirmations.. Availability lookup**: Integrates with Google Sheets, Airtable, or MySQL to verify slot availability in real time. Automated reminders**: Optionally schedules follow‑up messages 24 hours before the booking. Modular design**: Swap triggers, storage, or messaging nodes to fit your infrastructure. How It Works Trigger: Incoming WhatsApp message via WhatsApp Business Cloud API. Parse & Validate: AI Function node extracts intent and guest details. Calculate Discount: Custom Function node computes group discount. Compose Confirmation: Open Ai text model generates a personalized response. Send Message:Request node posts back to WhatsApp. Optional Reminder: Wait node + HTTP Request for pre‑booking follow‑up. Requirements WhatsApp Business Cloud API access n8n Cloud or self‑hosted instance Reservation datastore (Google Sheets, Airtable, MySQL) Open ai key for AI text generation Customization Tips Menu Attachments**: Add media nodes to send PDFs or images. Alternate Slot Suggestions**: Use AI to propose new times if a slot is full. Upsell Offers**: Follow up with add‑on suggestions (e.g., wine pairings). Localization**: Extend prompts for multilingual support.