Workflow Templates

How it works: When a user submits a form with event details, the workflow sends this information to OpenAI's GPT-5 model, which generates a curated list of 18–32 songs tailored to the occasion and audience. The workflow then searches Spotify for each recommended song, creates a new playlist on the user's Spotify account, adds all the tracks, and sends the user an email with a direct link to listen. Key Features: AI-Powered Playlist Generation: Uses OpenAI's GPT-5 model to create contextually relevant song recommendations based on event type, audience, and personal preferences. Automated Spotify Integration: Searches Spotify's API for each song and automatically adds them to a new playlist on the user's account. One-Click Listening: Users receive an email with a direct Spotify link to listen, follow, and modify the playlist immediately after creation. Multi-Language Support: The AI responds in the same language as the user's input, making the workflow accessible globally. Email Confirmation: Users instantly receive an email notification confirming playlist creation with a shareable Spotify link. Step-by-step: Form Submission Trigger: User submits event details (occasion, guests, preferences, and email) through the web form. AI Playlist Generation: OpenAI's GPT-5 generates a curated list of 18–32 songs based on the provided event context. Spotify Integration: The workflow searches Spotify for each song, creates a new playlist, and adds all found tracks to the user's account. Email Notification: User receives an email with the playlist name and a direct Spotify link to listen immediately. API Keys Required OpenAI API Key: Required to access GPT-5 for generating playlist recommendations. Spotify Client ID & Secret: Required to authenticate with Spotify's API for searching, creating playlists, and adding tracks. SMTP Credentials: Required to send the confirmation email to the user (server, port, username, password, and sender email). Response Generation The AI model receives event details and generates a structured JSON response containing a playlist name, 18–32 song recommendations with artist credits, and HTML-formatted content for website integration, all in the user's language.

How it works This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CRM leads, then calculates KPIs and insights automatically. The workflow sends structured reports via email and stores historical data in Google Sheets. It ensures consistent reporting without manual effort. Step-by-step Step 1: Trigger & report type detection** Schedule Trigger2 – Triggers the workflow weekly at a predefined time. Schedule Trigger3 – Triggers the workflow monthly at a predefined time. check month and week1 – Identifies whether the run is weekly or monthly and sets flags. Set Websites and Campaings1 – Defines websites, GA4 property IDs, and mapped ad campaigns. Expand Websites1 – Expands the website array into individual website items. Attach Run Flags1 – Attaches weekly or monthly flags to each website record. Step 2: Website & ads data processing** Loop Websites1 – Iterates through each website independently. Get a report – Fetches website traffic and engagement metrics from analytics. Get many campaigns – Retrieves Google Ads campaign data. Fetch Meta Ads – Fetches Meta Ads performance data via API. Filter Google Ads By Website1 – Filters Google Ads campaigns by website. Filter Meta Ads By Website1 – Filters Meta Ads campaigns by website. Merge1 – Merges analytics, Google Ads, and Meta Ads datasets. Build Website Dataset1 – Builds a unified dataset per website. Calculate KPIs & Campaign Insights1 – Calculates spend, CTR, CPA, CPL, conversions, and performance insights. Append or update row in sheet2 – Stores website-level marketing metrics in Google Sheets. Step 2.1: Marketing report generation** Prepare Report Data2 – Combines all website datasets into a unified report object. Switch – Routes execution based on weekly or monthly report type. Send Weekly Marketing report2 – Sends the weekly marketing performance email. Send Monthly Marketing Report2 – Sends the monthly marketing performance email. Step 3: HubSpot lead analysis** Fetch1 – Fetches leads from HubSpot CRM. Filter Hubspot Leads – Filters leads based on weekly or monthly time range. Summarize Hubspot Leads – Aggregates lead status and lifecycle metrics. Prepare Report Data3 – Prepares CRM summary data for reporting. Step 3.1: CRM reporting & storage** Switch3 – Routes CRM reporting by report type. Send Weekly Marketing report3 – Sends the weekly CRM summary email. Send Monthly Marketing Report3 – Sends the monthly CRM summary email. Code in JavaScript1 – Transforms CRM data for storage. Append or update row in sheet3 – Stores CRM lead performance data in Google Sheets. Switch3 – Routes CRM reporting by report type. Send Weekly Marketing report3 – Sends the weekly CRM summary email. Send Monthly Marketing Report3 – Sends the monthly CRM summary email. Code in JavaScript1 – Transforms CRM data for storage. Append or update row in sheet3 – Stores CRM lead performance data in Google Sheets. Why use this? Automates complex weekly and monthly marketing reporting. Unifies website analytics, ad platforms, and CRM data in one flow. Delivers consistent KPI calculations and insights every run. Maintains historical performance logs in Google Sheets. Scales easily across multiple websites and campaigns.

Description Automatically qualify and route new leads from a Google Sheet into your CRM with AI-powered scoring and instant sales notifications. Turn raw form submissions into prioritized opportunities—effortlessly. ⚡ What This Template Does Monitors a Google Sheet for new form submissions. 📄 Uses Azure OpenAI (GPT-4o-mini) to analyze lead details (value, stage, company) and generate action items. 🤖 Parses the AI response into clean JSON for structured processing. 🗂️ Saves qualified lead data and AI-generated action items into a Lead Status sheet for tracking. 💾 Categorizes leads into Hot, Warm, or Cold based on AI scoring. 🔥❄️ Creates/updates the contact in HighLevel CRM. 📇 Sends an email notification to the assigned sales rep with lead details and priority. 📧 Key Benefits Save time with automated lead qualification instead of manual checks. ⏱️ Ensure consistent Hot/Warm/Cold scoring across all leads. ✅ Centralize lead data in both Google Sheets and CRM for tracking. 📊 Keep sales teams aligned with instant notifications. 🚀 Fully no-code configurable and customizable for your business logic. 🧩 Features Google Sheets Trigger for new form rows. 📥 AI Agent with Azure OpenAI (GPT-4o-mini) for lead scoring. 🧠 JSON parsing node to clean AI output. ✂️ Lead logging to “Lead Status” sheet. 📊 Function node to categorize leads by score. 🎯 CRM sync with HighLevel to update/create contact records. 🔗 SMTP email notification to sales reps. ✉️ Requirements n8n instance (cloud or self-hosted). 🧰 Google Sheet with headers: Lead Name, Lead Email, Lead Contact No., Company Name, Opportunity Value, Stage of Lead; shared with n8n Google account. 📑 Azure OpenAI access with a GPT-4o-mini deployment. ☁️ HighLevel CRM account connected via OAuth. 📇 SMTP email account configured in n8n. 📧 Target Audience Sales teams handling inbound leads. 📈 Agencies managing multiple client pipelines. 🤝 Founders/startups wanting quick qualification and CRM sync. 🚀 Ops teams needing reliable reporting of lead qualification. 🗂️ Step-by-Step Setup Instructions (Concise) Create a Google Sheet with required headers; share with n8n account. 📋 Configure the Google Sheets Trigger with the sheet’s Document ID. 🔐 Connect your Azure OpenAI credentials and link to the AI Agent node. 🧠 Assign your HighLevel CRM account credentials. 📇 Set up SMTP credentials for the email send node. ✉️ Import the workflow, update node configs, and run a test submission. ▶️ Security Best Practices Share Google Sheets only with the n8n Google account (Editor). 🔒 Keep API keys and credentials encrypted in n8n, not hardcoded. 🛡️ Validate AI outputs before saving to CRM (via the parse node). ✅ Regularly back up your Lead Status sheet and CRM data. 📂

How it works Automatically generates professional PDF invoices from webhook data and delivers them via email while storing backups in Google Drive. Perfect for freelancers, small businesses, and service providers who need automated billing workflows. Set up steps Configure environment variables for company information (name, address, email, phone). Set up your PDF generation API service account (PDFShift recommended). Configure SMTP email credentials for invoice delivery. Set up Google Drive OAuth2 for cloud storage. Deploy the workflow and test with sample invoice data. Key features Smart invoice number generation if not provided Automatic tax calculations with configurable rates Professional HTML templates with company branding Parallel processing for email and storage Comprehensive error handling and validation Detailed success confirmation responses Required environment variables COMPANY_NAME - Your business name COMPANY_ADDRESS - Business mailing address COMPANY_EMAIL - Billing contact email COMPANY_PHONE - Business phone number PDF_API_URL - PDF generation service endpoint PDF_API_KEY - API authentication key GDRIVE_INVOICE_FOLDER_ID - Google Drive folder ID API requirements PDF generation service (PDFShift, HTML/CSS to PDF API, or similar), SMTP email service for delivery, Google Drive API access for storage. Input format { "customerName": "John Smith", "customerEmail": "john@example.com", "items": [ {"description": "Web Design", "quantity": 1, "price": 500} ], "dueDate": "2025-02-15" }

📊 Description Every company has documents sitting in Google Drive that nobody reads. HR policies, sales playbooks, product FAQs, financial guidelines — all written once, never found again. This workflow turns all of those documents into a live, searchable AI knowledge base that any team member can query instantly via a simple API call. Ask it anything. It finds the right document, pulls the exact relevant section, and answers in plain english — with the source cited so you always know where the answer came from. No hallucinations, no guessing, no manual searching. Built for founders, ops teams, and automation agencies who want company knowledge to be instantly accessible without building a custom RAG system from scratch. What This Workflow Does 📂 Reads all Google Docs from your Knowledge Base folder in Google Drive automatically ✂️ Splits each document into semantic chunks with overlap for better context retrieval 🤖 Converts every chunk into vector embeddings using OpenAI text-embedding-3-small 📌 Stores all embeddings in Pinecone with document metadata for fast semantic search 🌐 Accepts any question via webhook — from Slack, a form, or any internal tool 🔍 Searches Pinecone for the 5 most semantically relevant chunks to the question 🧠 Sends retrieved context to GPT-4o which answers using only what's in your documents 📝 Logs every question, answer, source, and confidence score to Google Sheets 🔄 Every Sunday checks Drive for new or updated documents and re-ingests them automatically 📧 Sends a weekly knowledge base digest showing what's current, new, or updated Key Benefits ✅ Zero hallucinations — GPT-4o only answers from your actual documents ✅ Always cites the source document so answers are verifiable ✅ Semantic search finds relevant content even if exact words don't match ✅ Knowledge base stays fresh automatically every Sunday ✅ Every Q&A logged to Google Sheets for full audit trail ✅ Works with any Google Docs — just drop them in the folder and run SW1 How It Works The workflow runs across 3 sub-workflows — one for ingestion, one for answering, one for maintenance. SW1 — Document Ingestion Pipeline (Run manually) You point it at your Google Drive Knowledge Base folder. It downloads every Google Doc as plain text, splits each one into 500-character chunks with 100-character overlap so context is preserved across boundaries. Each chunk gets converted into a 1536-dimension vector embedding using OpenAI's text-embedding-3-small model and stored in Pinecone with the document name as metadata. Every ingested document is logged to your Document Registry sheet with the ingestion date. Run this once when setting up, then SW3 handles updates automatically. SW2 — Question & Answer Agent (Always active via webhook) Someone sends a POST request with a question and their email. The question gets converted to an embedding using the same model used during ingestion. Pinecone finds the 5 most semantically similar chunks — ranked by cosine similarity score. Chunks scoring below 0.3 are filtered out to avoid irrelevant results. The remaining context gets sent to GPT-4o with strict instructions to only answer from what's provided. If the answer isn't in the knowledge base, it says so clearly instead of making something up. The response includes the answer, source document, confidence level, and whether it was found in the knowledge base. Everything is logged to your Q&A Log sheet. SW3 — Knowledge Base Manager (Every Sunday 11AM) Pulls your current Drive folder contents and compares every document ID against your Document Registry. New documents get flagged for ingestion. Existing documents get checked — if the file was modified after the last ingestion date, it gets re-ingested automatically. You get a weekly digest email showing what's current, what was updated, and what's new. No manual monitoring needed. Features Manual ingestion trigger for initial setup Google Drive folder monitoring for new and updated docs Recursive character text splitting with configurable chunk size and overlap OpenAI text-embedding-3-small for high quality 1536-dimension embeddings Pinecone vector database for fast cosine similarity search Relevance score filtering — only chunks above 0.3 score are used GPT-4o grounded answering with strict no-hallucination prompt Source citation in every answer Confidence scoring — high, medium, or low per response Full Q&A audit log in Google Sheets Weekly automated document registry sync Weekly KB digest email with full status report Modular 3-stage architecture — easy to extend with Slack or Teams integration Requirements OpenAI API key (text-embedding-3-small + GPT-4o access) Pinecone account — free tier works (index: dimensions 1536, metric cosine) Google Drive OAuth2 connection Google Sheets OAuth2 connection Gmail OAuth2 connection A Google Drive folder with your company documents as Google Docs A configured Google Sheet with 2 sheets: Q&A Log and Document Registry Setup Steps Create a Pinecone account at pinecone.io — free tier is enough Create a Pinecone index with dimensions 1536 and metric cosine Create a Google Drive folder called "Knowledge Base" Add your company documents as Google Docs inside that folder Copy the Google Sheet template and grab your Sheet ID Add all credentials — Pinecone, OpenAI, Google Drive, Google Sheets, Gmail Paste your Knowledge Base folder ID into both Google Drive nodes Paste your Sheet ID into all Google Sheets nodes Test by sending a POST request to the webhook with a question from your docs Target Audience 🧠 Founders who want instant answers from company documents without digging through Drive 📋 Ops and HR teams tired of answering the same internal questions repeatedly 💼 Sales teams who need instant access to product, pricing, and competitor information 🤖 Automation agencies building internal AI tools and knowledge systems for clients

Weekly Google Analytics 4 Report - Full WoW Tracking & Auto-Generated with Gemini AI Stop manually building weekly analytics reports. This workflow automatically fetches your GA4 data every Monday morning, generates an AI-written executive summary using Gemini, builds a premium formatted HTML email with deep Week-over-Week (WoW) comparisons for every metric, and delivers it straight to your stakeholders' inboxes — fully hands-free. 👤 Who is this for? Marketing teams* and *agency owners** who report GA4 metrics weekly to clients Product managers* and *founders** who want a Monday morning performance digest Freelancers** managing analytics for multiple clients who want to automate reporting Anyone who spends 30–60 minutes every week manually pulling GA4 numbers and calculating WoW changes 🚩 What problem does this solve? Manual GA4 reporting is repetitive, error-prone, and time-consuming. This template eliminates that entirely — every Monday at 8:00 AM in your configured timezone, a fully formatted report lands in your inbox. With the new dual-node architecture, it automatically calculates accurate WoW trends for your overall metrics, specific pages, traffic sources, and more, all contextualized by a Gemini-generated executive summary. ⚙️ What this workflow does ⏰ Triggers every Monday at 8:00 AM via the Schedule Trigger node 📡 Fetches 14 GA4 reports in parallel - pulling both Current Week and Previous Week data simultaneously for speed: Overview metrics Top 5 Screens / Pages by views Top 5 Traffic Sources / Referrals Top 5 Events by count Top 5 Countries by sessions Device breakdown (mobile / desktop / tablet) New vs Returning users 🔀 Merges all 14 responses and passes the complete historical dataset forward 🤖 Gemini writes a 3-5 bullet point summary analyzing the full WoW dataset to highlight performance trends, audience behaviour, and actionable recommendations 🧮 Code node processes all data - aligns current vs. previous week data, calculates WoW % changes for every single category, handles new/dropped entries, and builds the full inline-CSS HTML email 📧 Sends the report via standard SMTP / Email node to your configured recipients 📧 What the email report includes Header** - dark luxury card with 4 KPI tiles (Users, Sessions, Bounce Rate, Avg Duration) and WoW arrows AI Executive Summary** - 3-5 bullet point Gemini-generated insight (hidden automatically if Gemini fails) Overview Table** - all 5 core metrics with This Week / Last Week / WoW % change pill badges Audience** - New vs Returning users with visual progress bars and WoW changes Top Screens** - ranked by views, including previous week values and WoW trend pills. (not set) and (empty) rows are preserved for transparency Traffic Sources** - top referral channels with WoW changes; direct traffic auto-labelled as Direct / App Open Top Events** - tracks interaction trends with WoW changes; system events (first_open, os_update, etc.) are filtered out automatically Geography** - top 5 countries by sessions with WoW comparisons Devices** - mobile / desktop / tablet with visual progress bars and WoW trend pills 🛠️ Setup Instructions Step 1 - Google Analytics 4 Credential Go to n8n Credentials → Add new → search Google Analytics OAuth2 Sign in with the Google account that has access to your GA4 property Assign this credential to all 14 GA4 nodes Step 2 - Set your GA4 Property ID Open each of the 14 GA4 nodes In the Property ID field, replace {YOUR_PROPERTY_ID} with your GA4 numeric property ID Find your Property ID at: GA4 Admin → Property Settings → Property ID (looks like 123456789) Step 3 - Gemini API Credential Get your free API key at aistudio.google.com Go to n8n Credentials → Add new → search Google Gemini Paste your API key and assign it to the Generate AI Summary node Step 4 - Email / SMTP Credential Go to n8n Credentials → Add new → search SMTP (or swap the node for Gmail OAuth2 if preferred) Enter your email host, port, and login credentials Assign to the Send Weekly Report node Step 5 - Set Recipients Open the Send Weekly Report node (or the Code node depending on your mapping preference) Update the To Email field with your recipient address(es): 'email@example.com, email2@example.com' Alternatively, update the recipients: line at the bottom of the Build Report & Email HTML Code node. Step 6 - Set Timezone Open the Weekly Monday Trigger node Update the workflow settings to match your local timezone so the 8:00 AM trigger fires correctly. 🔧 How to Customise Change the schedule** → Open the trigger node, adjust the day and time to any cadence you need (daily, bi-weekly, monthly) Change the client brand in the footer** → Search for AppStoneLab Technologies in the Code node and replace it with your client or company name Filter or change events** → In the Code node, find the EXCLUDE_EVENTS array and add/remove event names to control which events appear in the report Change the AI summary language or tone** → Edit the prompt inside the Generate AI Summary Gemini node to match your client's preferred reporting style 📦 Requirements | Service | Purpose | Free Tier Available | | --- | --- | --- | | Google Analytics 4 | Source of all report data | ✅ Yes | | Google Gemini API | AI executive summary generation | ✅ Yes (via AI Studio) | | SMTP / Email | Email delivery | ✅ Yes | ⚠️ Notes Mobile app properties** - If your GA4 property tracks a mobile app, the workflow uses unifiedScreenName instead of pagePath, which works correctly for both web and app properties WoW calculations** - Bounce rate change is intentionally inverted (a decrease is shown as positive/green). If a metric like a specific page or country is new this week, the workflow dynamically tags it as "New" instead of breaking the calculation. Gemini failure handling** - If the Gemini node fails for any reason, the AI summary section is automatically hidden and the rest of the report sends normally Execute Once** - All 14 GA4 nodes have Execute Once enabled to prevent duplicate rows from the merge operation

This workflow automatically notifies travelers about their pending trip payments and provides secure payment links through Email and WhatsApp. It runs twice daily (at 7 AM and 7 PM) to ensure timely reminders before the due date. Designed for travel agencies, it simplifies payment tracking, reduces manual follow-up, and ensures every traveler receives personalized reminders with real-time payment status updates. 🔧 Main Components Daily Payment Check – 7 AM & 7 PM Scheduled triggers that start the workflow daily at 7 AM and 7 PM. Read Pending Travel Payment Fetches traveler payment records from an Excel sheet (using getAll method). Process Payment Reminders Filters records to find pending payments due within the next 3 days. Create Payment Reminders Generates personalized payment reminders. Make Reminder For Email Prepares email-friendly messages with payment links. Send Email Reminder Sends the payment reminder email with a secure payment link to the traveler. Prepare WhatsApp Reminder Generates WhatsApp-friendly messages with payment and payment details. Send WhatsApp Message Sends the message to the traveler’s WhatsApp number using a message API. Update Status Of Reminder Updates the Excel file to mark reminders as sent to avoid duplicates. 🧩 Channels Used 📧 Email – with personalized payment link 💬 WhatsApp – formatted reminder message 🔐 Payment Integration Secure payment links are auto-generated per traveler to enable direct and safe online payments. ✅ Essential Prerequisites Excel sheet with payment records (travel_payment_data.xlsx) SMTP credentials for sending email WhatsApp API or provider integration (like Twilio or Gupshup) Access to a payment gateway or service for link generation File storage access to update reminder status in Excel 📁 Required Excel File Structure (travel_payment_data.xlsx) | Traveler ID | Name | Email | Phone | Payment Due Date | Amount | Reminder Sent | |-------------|------------|-------------------|---------------|------------------|---------|---------------| | TR001 | Arjun Patel| arjun@example.com | +919876543210 | 2025-10-20 | ₹3000 | No | 🧾 Expected Input Format Example { "travelerId": "TR001", "name": "Arjun Patel", "email": "arjun@example.com", "phone": "+919876543210", "dueDate": "2025-10-20", "amount": "₹3000", "reminderSent": "No" } 🚀 Key Features ⏰ Scheduled Daily Execution – Fully automated at 7 AM and 7 PM 🧮 Due-Date Filtering – Only targets payments due in the next 3 days 💬 Multi-Channel Notifications – Sends reminders via both Email and WhatsApp 🔗 Secure Payment Links – Auto-generated for each traveler 🔄 Reminder Tracking – Prevents duplicate reminders by updating status ⚙️ Quick Setup Guide Import Workflow JSON into your n8n instance. Configure schedule in the “Daily Payment Check” node (default: 7 AM & 7 PM). Set Excel file path in the “Read Pending Travel Payment” node. Update your payment processing logic in the “Process Payment Reminders” node. Add email credentials in the “Send Email Reminder” node. Integrate WhatsApp provider API in the “Send WhatsApp Message” node. Define how you generate secure payment links. Test with sample data and activate workflow.

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 monitors competitor product prices stored in Google Sheets. It scrapes product pages, extracts pricing and offer data using AI, and compares it with historical values. Based on changes, it updates records and generates a market intelligence report. The workflow then emails the report and resets data for the next execution cycle. Step-by-step Step 1: Database sync** Schedule Trigger – Runs the workflow at a scheduled time. Get row(s) in sheet – Fetches competitor data and product URLs. Step 2: Scraping** Loop Over Items – Processes each competitor entry. HTTP Request3 – Retrieves raw HTML using ScraperAPI. Clean Content – Cleans and prepares text for AI processing. Step 3: Price extraction** AI Agent1 – Extracts product name, price, and offers. Groq Chat Model1 – Provides AI extraction capability. current Price and offer – Converts AI output into structured data. If2 – Checks if it's the first recorded entry. First time price and offer added – Stores initial values. If1 – Compares current vs previous price and offers. Updated current price and offer in sheet – Updates if changes detected. If No changes then update – Updates sheet even when no change is found. Step 4: Analysis** Get row(s) in sheet1 – Retrieves updated dataset. Data Aggregator – Builds structured market comparison data. AI Agent – Generates strategic insights and recommendations. Groq Chat Model – Powers the analysis output. Update row in sheet – Saves AI-generated summary in sheet. Step 5: Reporting** Edit Fields1 – Formats the report into HTML email layout. Send a message – Sends the final report via Gmail. Step 6: Reset** Get row(s) in sheet2 – Retrieves final processed data. Update row in sheet1 – Moves current data to history and clears fields. Why use this? Ensures all price scenarios (change or no change) are handled properly Keeps your Google Sheets always updated with accurate data Provides AI-powered competitive intelligence automatically Sends clean, formatted reports without manual effort Maintains structured historical tracking for better decision-making

This workflow continuously monitors CVE databases, threat intelligence feeds, and public security advisories to surface emerging zero-day threats, correlates them against your registered infrastructure assets and software inventory, and uses Claude AI to score exploitability, assess business impact, and generate actionable remediation playbooks — all before attackers can operationalise the vulnerability. How it works Trigger — Hourly schedule or on-demand webhook for immediate threat scans Load Asset Inventory — Fetches registered infrastructure (IPs, hostnames, software, versions) from Airtable Scrape CVE Sources — Queries NVD API, CISA KEV, and GitHub Security Advisories in parallel Fetch Threat Feeds — Pulls OSINT feeds (AlienVault OTX, abuse.ch, Shodan) for active exploitation signals Normalise & Deduplicate — Merges all findings, deduplicates by CVE ID, enriches with CVSS scores Correlate with Assets — Matches CVEs to your specific software/version inventory AI Threat Assessment — Claude AI scores exploitability, blast radius, and urgency per matched threat Filter Critical Findings — Keeps only threats scoring above configurable risk threshold Route by Severity — Branches CRITICAL / HIGH / MEDIUM for different response paths Alert SOC via Slack — Immediate notification with threat summary and patch status Create Incident Tickets — Auto-opens Jira/ServiceNow issues for CRITICAL and HIGH threats Email Security Team — Detailed HTML threat brief with CVE details and remediation steps Update Threat Register — Appends findings to Google Sheets threat intelligence log Trigger Patch Workflow — Webhooks downstream patch management system for auto-remediation Return API Response — Structured JSON result for SIEM/SOAR integration Setup Steps Import workflow into n8n Configure credentials: Anthropic API — Claude AI for threat assessment NVD API Key — NIST National Vulnerability Database CISA KEV — Known Exploited Vulnerabilities catalogue (public) AlienVault OTX API — Open Threat Exchange pulses Shodan API — Internet exposure checks Airtable — Asset/software inventory Google Sheets OAuth — Threat intelligence log Slack OAuth — SOC alerts Jira API — Incident ticket creation SendGrid / SMTP — Security team email digests Register your asset inventory in Airtable (hostnames, IPs, software, versions) Set your risk score threshold (default: 65) in the filter node Set your Slack SOC channel IDs Configure downstream patch webhook URL Activate the workflow Sample Webhook Payload (On-Demand Scan) { "scanType": "targeted", "software": "Apache HTTP Server", "version": "2.4.51", "urgency": "high", "requestedBy": "soc-analyst@company.com" } Threat Sources Monitored NVD (NIST)** — Full CVE database with CVSS v3.1 scores CISA KEV** — Actively exploited vulnerabilities catalogue GitHub Security Advisories** — Open source dependency vulnerabilities AlienVault OTX** — Community threat intelligence pulses abuse.ch URLhaus** — Malware distribution and C2 URLs Shodan** — Internet-exposed asset enumeration EPSS** — Exploit Prediction Scoring System probabilities AI Assessment Dimensions CVSS Score** — Base, temporal, and environmental scoring EPSS Probability** — Likelihood of exploitation in the wild Asset Exposure** — Internal vs external facing, attack surface Patch Availability** — Vendor patch, workaround, or no fix status Active Exploitation** — CISA KEV / OTX confirmation Business Impact** — Confidentiality, integrity, availability impact Blast Radius** — Number of affected assets and systems Urgency Score** — Composite prioritisation score (0–100) Features Multi-source CVE aggregation with deduplication Asset correlation against software/version inventory EPSS-weighted AI exploitability scoring Automated CRITICAL/HIGH/MEDIUM severity routing Jira ticket creation with full CVE context Patch management webhook integration Full threat intelligence audit log SIEM/SOAR-ready JSON output Explore More Automation: Contact us to design AI-powered lead nurturing, content engagement, and multi-platform reply workflows tailored to your growth strategy.

📈 Automated Customer Rewards Platform: Jotform Integration This blueprint details a highly efficient, AI-powered workflow designed to automate customer reward fulfillment. Leveraging the accessible interface of Jotform, this system delivers superior reliability and exceptional processing speed. 📊 Reliability, Productivity, and Performance This workflow is engineered to maximize operational efficiency and maintain data integrity: Instant Fulfillment: Automation handles receipt scanning (OCR), AI calculation, logging, and notification in seconds, eliminating manual delays. Seamless Data Capture: Leverages the user-friendly Jotform interface for fast, reliable customer submission and file uploads. 🛠️ Quick Configuration Guide Jotform Webhook:* In your *JotForm* settings, paste the n8n *Jotform Trigger URL** into the Webhook Integration. Done. API Access:* Generate a *"Full Access"** JotForm API key and insert it into the required n8n nodes (Jotform Trigger and Fetch All Receipts). Credential Setup:** Plug in your necessary API keys (Gemini, OCR.Space) and update the Notion Database ID and internal email recipient. 🚀 How It Works (Practical Flow) Submission:* Customer submits their request via *Jotform**. Processing:** System extracts text from the receipt (OCR), the AI calculates the reward, and the If node verifies the total. Fulfillment:** Transaction logged, confirmation emails sent to both the customer and the internal team. If you need any help Get in Touch

AI appointment bot with Google Calendar, Gmail and Sheets 📌 Overview This workflow automates end-to-end appointment scheduling for your business using an AI-powered chatbot. Clients can book, reschedule, or cancel meetings through a simple chat interface — no manual coordination needed. Two independent flows run in parallel. The AI Chat Flow handles real-time client conversations using Groq LLaMA 4 Scout, managing calendar availability, event creation, updates, and Gmail confirmations automatically. The Daily Sync Flow runs every morning to refresh your Google Sheet with the day's appointments and email an admin summary report. All times are handled in IST (GMT+05:30) with full ISO 8601 formatting. ⚙️ How it works AI Chat Flow Client sends a message to the bot AI Agent collects name, email, purpose, date, time, and duration Checks Google Calendar for availability Creates, updates, or deletes calendar events based on request Sends Gmail confirmation or cancellation email to the attendee Daily Sync Flow Triggers every morning at 9:30 AM IST Clears previous rows from Google Sheets (keeps header) Fetches all of today's Google Calendar events Formats and inserts each event into the sheet Emails the admin a summary report with total meeting count and sheet link 🛠️ Setup steps Import this workflow into n8n Add a Google Calendar OAuth2 credential and set your calendar email Add a Gmail OAuth2 credential for the agent and admin report Add Google Sheets OAuth2 (for Clear node) and Service Account (for Insert node) Add your Groq API key for the LLaMA 4 Scout model Update your admin email, calendar email, and Google Sheet ID in the workflow Activate the workflow — both flows run independently 🚀 Features AI-powered scheduling Books, reschedules, and cancels appointments via chat Checks real-time calendar availability before confirming Suggests 3 alternative slots if the requested time is unavailable Sends automatic Gmail confirmations to attendees Maintains conversation memory across the session (last 50 messages) Daily reporting Auto-clears and refreshes the Google Sheet every morning Syncs all calendar events with full details (name, email, time, duration) Emails admin a daily count summary with a direct sheet link 📋 Requirements n8n (cloud or self-hosted) Google Calendar, Gmail, and Google Sheets access Groq API key (free tier supported) 🎯 Benefits Zero manual appointment coordination Clients self-serve via chat 24/7 Admin always has a fresh daily schedule in Google Sheets Automatic email confirmations build client trust IST timezone enforced consistently across all events 👨‍💻 Author BytezTech Pvt Ltd