# templates

name: Document RAG & Chat Agent: Google Drive to Qdrant with Mistral OCR
author_name: DIGITAL BIZ TECH
author_username: dbt
categories: []
created_at: 2025-10-24T01:10:25.155Z
updated_at: 2025-10-24T01:10:25.155Z
url: https://n8n.io/workflows/10096
scraped_at: 2025-12-24 13:02:41
description:
  Knowledge RAG & AI Chat Agent: Google Drive to Qdrant

  Description

  This workflow transforms a Google Drive folder into an intelligent, searchable knowledge base and provides a chat agent to query it.  
  It’s composed of two distinct flows:  
  An ingestion pipeline to process documents.  
  A live chat agent that uses RAG (Retrieval-Augmented Generation) and optional web search to answer user questions.  

  This system fully automates the creation of a “Chat with your docs” solution and enhances it with external web-searching capabilities.

  Quick Implementation Steps

  Import the workflow JSON into your n8n instance.  
  Set up credentials for Google Drive, Mistral AI, OpenAI, and Qdrant.  
  Open the Web Search node and add your Tavily AI API key to the Authorization header.  
  In the Google Drive (List Files) node, set the Folder ID you want to ingest.  
  Run the workflow manually once to populate your Qdrant database (Flow 1).  
  Activate the workflow to enable the chat trigger (Flow 2).  
  Copy the public webhook URL from the When chat message received node and open it in a new tab to start chatting.

  What It Does

  The workflow is divided into two primary functions:

  1. Knowledge Base Ingestion (Manual Trigger)  
  This flow populates your vector database.  

  Scans Google Drive:** Lists all files from a specified folder.  
  Processes Files Individually:** Downloads each file.  
  Extracts Text via OCR:* Uses *Mistral AI OCR API** for text extraction from PDFs, images, etc.  
  Generates Smart Metadata:** A Mistral LLM assigns metadata like document_type, project, and assigned_to.  
  Chunks & Embeds:* Text is cleaned, chunked, and embedded via *OpenAI’s text-embedding-3-small** model.  
  Stores in Qdrant:** Text chunks, embeddings, and metadata are stored in a Qdrant collection (docaiauto).  

  2. AI Chat Agent (Chat Trigger)  
  This flow powers the conversational interface.  

  Handles User Queries:** Triggered when a user sends a chat message.  
  Internal RAG Retrieval:* Searches *Qdrant Vector Store** first for answers.  
  Web Search Fallback:* If unavailable internally, the agent offers to perform a *Tavily AI web search**.  
  Contextual Responses:** Combines internal and external info for comprehensive answers.

  Who's It For

  Ideal for:

  Teams building internal AI knowledge bases from Google Drive.  
  Developers creating AI-powered support, research, or onboarding bots.  
  Organizations implementing RAG pipelines.  
  Anyone making unstructured Google Drive documents searchable via chat.

  Requirements

  n8n instance** (self-hosted or cloud).  
  Google Drive Credentials** (to list and download files).  
  Mistral AI API Key** (for OCR & metadata extraction).  
  OpenAI API Key** (for embeddings and chat LLM).  
  Qdrant instance** (cloud or self-hosted).  
  Tavily AI API Key** (for web search).

  How It Works

  The workflow runs two independent flows in parallel:

  Flow 1: Ingestion Pipeline (Manual Trigger)

  List Files: Fetch files from Google Drive using the Folder ID.  
  Loop & Download: Each file is processed one by one.  
  OCR Processing:  
     Upload file to Mistral  
     Retrieve signed URL  
     Extract text using Mistral DOC OCR  
  Metadata Extraction: Analyze text using a Mistral LLM.  
  Text Cleaning & Chunking: Split into 1000-character chunks.  
  Embeddings Creation: Use OpenAI embeddings.  
  Vector Insertion: Push chunks + metadata into Qdrant.  

  Flow 2: AI Chat Agent (Chat Trigger)

  Chat Trigger: Starts when a chat message is received.  
  AI Agent: Uses OpenAI + Simple Memory to process context.  
  RAG Retrieval: Queries Qdrant for related data.  
  Decision Logic:  
     Found → Form answer.  
     Not found → Ask if user wants web search.  
  Web Search: Performs Tavily web lookup.  
  Final Response: Synthesizes internal + external info.

  How To Set Up

  1. Import the Workflow
  Upload the provided JSON into your n8n instance.

  2. Configure Credentials
  Create and assign:

  Google Drive** → Google Drive nodes  
  Mistral AI** → Upload, Signed URL, DOC OCR, Cloud Chat Model  
  OpenAI** → Embeddings + Chat Model nodes  
  Qdrant** → Vector Store nodes  

  3. Add Tavily API Key
  Open Web Search node → Parameters → Headers  
  Add your key under Authorization (e.g., tvly-xxxx).  

  4. Node Configuration
  Google Drive (List Files):** Set Folder ID.  
  Qdrant Nodes:** Ensure same collection name (docaiauto).  

  5. Run Ingestion (Flow 1)
  Click Test workflow to populate Qdrant with your Drive documents.  

  6. Activate Chat (Flow 2)
  Toggle the workflow ON to enable real-time chat.  

  7. Test
  Open the webhook URL and start chatting!

  How To Customize

  Change LLMs:** Swap models in OpenAI or Mistral nodes (e.g., GPT-4o, Claude 3).  
  Modify Prompts:** Edit the system message in ai chat agent to alter tone or logic.  
  Chunking Strategy:** Adjust chunkSize and chunkOverlap in the Code node.  
  Different Sources:** Replace Google Drive with AWS S3, Local Folder, etc.  
  Automate Updates:* Add a *Cron** node for scheduled ingestion.  
  Validation:** Add post-processing steps after metadata extraction.  
  Expand Tools:** Add more functional nodes like Google Calendar or Calculator.

  Use Case Examples

  Internal HR Bot:** Answer HR-related queries from stored policy docs.  
  Tech Support Assistant:** Retrieve troubleshooting steps for products.  
  Research Assistant:** Summarize and compare market reports.  
  Project Management Bot:** Query document ownership or project status.

  Troubleshooting Guide

  | Issue | Possible Solution |
  |------------|------------------------|
  | Chat agent doesn’t respond | Check OpenAI API key and model availability (e.g., gpt-4.1-mini). |
  | Known documents not found | Ensure ingestion flow ran and both Qdrant nodes use same collection name. |
  | OCR node fails | Verify Mistral API key and input file integrity. |
  | Web search not triggered | Re-check Tavily API key in Web Search node headers. |
  | Incorrect metadata | Tune Information Extractor prompt or use a stronger Mistral model. |

  Need Help or More Workflows?
  Want to customize this workflow for your business or integrate it with your existing tools?  
  Our team at Digital Biz Tech can tailor it precisely to your use case  from automation logic to AI-powered enhancements.  

   We can help you set it up for free — from connecting credentials to deploying it live.

  Contact: shilpa.raju@digitalbiz.tech  
  Website: https://www.digitalbiz.tech  
  LinkedIn: https://www.linkedin.com/company/digital-biz-tech/  
  You can also DM us on LinkedIn for any help.

nodes_used:
  ["@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.lmChatMistralCloud","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.informationExtractor","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 13064 characters]


name: AI Website Scraper & Company Intelligence
author_name: DIGITAL BIZ TECH
author_username: dbt
categories: []
created_at: 2025-10-24T01:38:47.520Z
updated_at: 2025-10-24T01:38:47.520Z
url: https://n8n.io/workflows/10097
scraped_at: 2025-12-24 13:02:43
description:
  AI Website Scraper & Company Intelligence

  Description

  This workflow automates the process of transforming any website URL into a structured, intelligent company profile.  
  It's triggered by a form, allowing a user to submit a website and choose between a "basic" or "deep" scrape.

  The workflow extracts key information (mission, services, contacts, SEO keywords), stores it in a structured Supabase database, and archives a full JSON backup to Google Drive.  
  It also features a secondary AI agent that automatically finds and saves competitors for each company, building a rich, interconnected database of company intelligence.

  Quick Implementation Steps

  Import the Workflow: Import the provided JSON file into your n8n instance.
  Install Custom Community Node:  
     You must install the community node from:  
    https://www.npmjs.com/package/n8n-nodes-crawl-and-scrape
  FIRECRAWL  N8N Documentation
    https://docs.firecrawl.dev/developer-guides/workflow-automation/n8n


  Install Additional Nodes:  
     n8n-nodes-crawl-and-scrape and n8n-nodes-mcp fire crawl mcp   .
  Set up Credentials:  
     Create credentials in n8n for  FIRE CRAWL API,Supabase, Mistral AI, and Google Drive.
  Configure API Key (CRITICAL):  
     Open the Web Search tool node.  
     Go to Parameters → Headers and replace the hardcoded Tavily AI API key with your own.
  Configure Supabase Nodes:  
     Assign your Supabase credential to all Supabase nodes.  
     Ensure table names (e.g., companies, competitors) match your schema.
  Configure Google Drive Nodes:  
     Assign your Google Drive credential to the Google Drive2 and save to Google Drive1 nodes.  
     Select the correct Folder ID.
  Activate Workflow:  
     Turn on the workflow and open the Webhook URL in the “On form submission” node to access the form.

  What It Does

  Form Trigger
  Captures user input: “Website URL” and “Scraping Type” (basic or deep).

  Scraping Router
  A Switch node routes the flow:
  Deep Scraping →** AI-based MCP Firecrawler agent.  
  Basic Scraping →** Crawlee node.

  Deep Scraping (Firecrawl AI Agent)
  Uses Firecrawl and Tavily Web Search.
  Extracts a detailed JSON profile: mission, services, contacts, SEO keywords, etc.

  Basic Scraping (Crawlee)
  Uses Crawl and Scrape node to collect raw text.  
  A Mistral-based AI extractor structures the data into JSON.

  Data Storage
  Stores structured data in Supabase tables (companies, company_basicprofiles).
  Archives a full JSON backup to Google Drive.

  Automated Competitor Analysis
  Runs after a deep scrape.
  Uses Tavily web search to find competitors (e.g., from Crunchbase).
  Saves competitor data to Supabase, linked by company_id.

  Who's It For

  Sales & Marketing Teams:** Enrich leads with deep company info.  
  Market Researchers:** Build structured, searchable company databases.  
  B2B Data Providers:** Automate company intelligence collection.  
  Developers:** Use as a base for RAG or enrichment pipelines.

  Requirements

  n8n instance** (self-hosted or cloud)
  Supabase Account:** With tables like companies, competitors, social_links, etc.
  Mistral AI API Key**
  Google Drive Credentials**
  Tavily AI API Key**
  (Optional) Custom Nodes:  
    n8n-nodes-crawl-and-scrape  
  How It Works

  Flow Summary
  Form Trigger: Captures “Website URL” and “Scraping Type”.
  Switch Node:  
     deep → MCP Firecrawler (AI Agent).  
     basic → Crawl and Scrape node.
  Scraping & Extraction:  
     Deep path: Firecrawler → JSON structure.  
     Basic path: Crawlee → Mistral extractor → JSON.
  Storage:  
     Save JSON to Supabase.  
     Archive in Google Drive.
  Competitor Analysis (Deep Only):  
     Finds competitors via Tavily.  
     Saves to Supabase competitors table.
  End: Finishes with a No Operation node.

  How To Set Up

  Import workflow JSON.
  Install community nodes (especially n8n-nodes-crawl-and-scrape from npm).
  Configure credentials (Supabase, Mistral AI, Google Drive).
  Add your Tavily API key.
  Connect Supabase and Drive nodes properly.
  Fix disconnected “basic” path if needed.
  Activate workflow.
  Test via the webhook form URL.

  How To Customize

  Change LLMs:** Swap Mistral for OpenAI or Claude.  
  Edit Scraper Prompts:** Modify system prompts in AI agent nodes.  
  Change Extraction Schema:** Update JSON Schema in extractor nodes.  
  Fix Relational Tables:** Add Items node before Supabase inserts for arrays (social links, keywords).  
  Enhance Automation:** Add email/slack notifications, or replace form trigger with a Google Sheets trigger.

  Add-ons

  Automated Trigger:** Run on new sheet rows.  
  Notifications:** Email or Slack alerts after completion.  
  RAG Integration:** Use the Supabase database as a chatbot knowledge source.

  Use Case Examples

  Sales Lead Enrichment:** Instantly get company + competitor data from a URL.  
  Market Research:** Collect and compare companies in a niche.  
  B2B Database Creation:** Build a proprietary company dataset.

  WORKFLOW IMAGE 

  Troubleshooting Guide

  | Issue | Possible Cause | Solution |
  |-------|----------------|-----------|
  | Form Trigger 404 | Workflow not active | Activate the workflow |
  | Web Search Tool fails | Missing Tavily API key | Replace the placeholder key |
  | FIRECRAWLER / find competitor fails | Missing MCP node | Install n8n-nodes-mcp |
  | Basic scrape does nothing | Switch node path disconnected | Reconnect “basic” output |
  | Supabase node error | Wrong table/column names | Match schema exactly |

  Need Help or More Workflows?
  Want to customize this workflow for your business or integrate it with your existing tools?  
  Our team at Digital Biz Tech can tailor it precisely to your use case  from automation logic to AI-powered enhancements.  

   Contact: shilpa.raju@digitalbiz.tech  
   For more such offerings, visit us: https://www.digitalbiz.tech

nodes_used:
  ["n8n-nodes-base.supabase","@n8n/n8n-nodes-langchain.lmChatMistralCloud","n8n-nodes-mcp.mcpClientTool","n8n-nodes-mcp.mcpClientTool","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.supabase","n8n-nodes-crawl-and-scrape.crawleeNode","n8n-nodes-base.formTrigger","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.supabase","n8n-nodes-base.supabase","@n8n/n8n-nodes-langchain.lmChatMistralCloud","@n8n/n8n-nodes-langchain.informationExtractor","@n8n/n8n-nodes-langchain.lmChatMistralCloud","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-mcp.mcpClientTool","@n8n/n8n-nodes-langchain.lmChatMistralCloud","n8n-nodes-mcp.mcpClientTool","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.toolHttpRequest","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.googleDrive","n8n-nodes-base.supabase","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8968 characters]


name: AI-Powered Invoice Reminder & Payment Tracker for Finance & Accounting
author_name: Oneclick AI Squad
author_username: oneclick-ai
categories: []
created_at: 2025-10-24T07:41:05.638Z
updated_at: 2025-10-24T07:41:05.638Z
url: https://n8n.io/workflows/10111
scraped_at: 2025-12-24 13:02:41
description:
  Streamline invoice management with this automated n8n workflow. Triggered daily at 9 AM, it fetches pending invoices, filters overdue ones, uses AI to generate personalized reminders, and sends them to clients. It also tracks payments via webhooks, updates statuses, and provides daily summaries to the finance team, ensuring efficient cash flow oversight.

  Key Features  
  Daily checks at 9 AM ensure timely invoice tracking.  
  AI generates personalized reminders and payment confirmations.  
  Real-time webhook integration for payment updates.  
  Daily summaries and activity logs enhance financial visibility.  

  Workflow Process  
  Schedule Daily Check** runs every day at 9 AM to initiate the workflow.  
  Fetch Pending Invoices** queries the database for unpaid invoices.  
  Filter Overdue Invoices** separates overdue invoices based on due dates.  
  Calculate Reminder Logic** applies smart logic for reminder timing and urgency.  
  Prepare AI Prompt** formats data into a tailored prompt for AI.  
  AI Agent for Generate Email** uses AI to create personalized reminder emails.  
  Format Email** styles the email with HTML for a professional look.  
  Send Email Reminder** delivers the reminder to clients.  
  Update Reminder Status** logs the sent reminder in the database.  
  Create Activity Log** generates a manual log for auditing.  
  Save Input Log** archives raw input data for analysis.  
  Generate Daily Summary** creates a report of daily metrics.  
  Send Summary to Finance Team** emails the summary to the team.  
  Webhook Payment Received** captures payment confirmations via POST.  
  Update Payment Status** updates the invoice status to "paid" in the database.  
  Webhook Response** sends an acknowledgment to the payment gateway.  
  Webhook Logic Filtering** validates webhook data.  
  Prepare AI Prompt (in payment branch)** formats payment data for AI.  
  Chat Memory Tool (in payment branch)** maintains context for AI.  
  Generate Email (in payment branch)** creates a payment confirmation email.  
  Send Payment Confirmation** emails the confirmation to the client.  

  Setup Instructions  
  Import the workflow into n8n and configure database credentials (e.g., Google Sheets or SQL) for "Fetch Pending Invoices."  
  Set up the AI service (e.g., OpenAI GPT) with an API key for email generation.  
  Configure Gmail API Key for sending emails and Slack (if integrated) for team alerts.  
  Test the workflow by adding overdue invoices and simulating a payment webhook.  
  Adjust reminder logic and thresholds (e.g., 7 days overdue) as needed.  

  Prerequisites  
  Database access (e.g., Google Sheets OAuth2 or SQL credentials)  
  OpenAI API key for AI email generation  
  Gmail API Key for email notifications  
  Payment gateway webhook integration (e.g., Stripe)  
  Structured invoice data format  

  Database Structure:  
  Create a table/sheet with columns:  
     Invoice ID  
     Client Name  
     Amount  
     Due Date  
     Status  
     Reminder Sent  
     Payment Date  

  Modification Options  
  Adjust the "Schedule Daily Check" to a different time (e.g., 8 AM IST).  
  Customize "Calculate Reminder Logic" for escalation (e.g., multiple reminders).  
  Modify AI prompts for branded or localized email content.  
  Integrate with accounting software (e.g., QuickBooks) for real-time data.  
  Enhance "Generate Daily Summary" with custom financial metrics.  

  Discover more workflows – Get in touch with us

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.postgres","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.emailSend","n8n-nodes-base.postgres","n8n-nodes-base.set","n8n-nodes-base.postgres","n8n-nodes-base.code","n8n-nodes-base.emailSend","n8n-nodes-base.webhook","n8n-nodes-base.postgres","n8n-nodes-base.respondToWebhook","n8n-nodes-base.emailSend","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7732 characters]


name: Automate Facebook Reels Publishing with Google Sheets and Drive
author_name: Đỗ Thành Nguyên
author_username: nathando
categories: []
created_at: 2025-10-24T12:42:23.756Z
updated_at: 2025-10-24T12:42:23.756Z
url: https://n8n.io/workflows/10122
scraped_at: 2025-12-24 13:02:42
description:
  Publish a Reel on a Facebook Page
  🧠 Good to Know
  &gt;  Set up n8n self-hosted instance using https://tino.vn/vps-n8n?affid=388
  &gt;  Use the code ==VPSN8N== for up to 39% off.

  This workflow automatically uploads and publishes Facebook Reels using data from Google Sheets and video files stored in Google Drive. It runs on a schedule (every 30 minutes by default) and can be fully customized for your posting routine.

  ⚙️ How It Works

  Google Sheets provides the content data — video file ID, caption, and optional links.
  Google Drive hosts the actual video file (.mp4 format).
  The workflow initializes an upload session with the Facebook Graph API, uploads the video, and publishes it as a Reel on your Page.
  Finally, it updates your Google Sheet and adds a comment under the published Reel with your affiliate or product link.

  How to Use

  Open the template Google Sheet or make a copy:
     👉 Template Sheet

  Fill out each row with:

     File ID → the ID of your video file from Google Drive
     File name → optional
     Caption → your post caption
     Link Share → optional
     Link post → leave empty (it will be filled after posting)

  Ensure your video file:

     .mp4 format
     shared folder on Google Drive that’s accessible to your connected account

  Add your Facebook Page ID and Page Access Token to the “info” node.
     (Learn how to get these here: Facebook Reels Workflow Guide)

  📋 Requirements

  n8n instance (Self-hosted recommended):**

    Set up a self-hosted instance using https://tino.vn/vps-n8n?affid=388
    Use the code VPSN8N for up to 39% off.

  Facebook Page** with publishing permissions
  Page Access Token** (with pages_manage_posts, pages_read_engagement)
  Google Drive* and *Google Sheets** account connected to n8n
  Video files in .mp4 format, under the 1GB upload limit

  🎨 Customizing This Workflow

  Change schedule:* Adjust the *Schedule Trigger** node (e.g., every 2 hours or only during business hours).
  Track post links:** Add a node to fetch the permalink_url from the Graph API and update it in your sheet.
  Auto-comment control:** Modify or remove the “Create comment post” node to suit your campaign style.
  Improve security:* Replace hardcoded tokens with *n8n credentials, **secrets, or a Data Table lookup.

  This structure keeps your automation scalable, secure, and easy to adapt for multi-page or multi-brand use.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleDrive","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5392 characters]


name: Nested PDF Analysis with Mistral AI & OneDrive for Document Summarization
author_name: Jordan Hoyle
author_username: jordanhoyle
categories: []
created_at: 2025-10-24T17:26:08.778Z
updated_at: 2025-10-24T17:26:08.778Z
url: https://n8n.io/workflows/10132
scraped_at: 2025-12-24 13:02:41
description:
  Description
  Automate the discovery and analysis of PDF files across a deeply nested OneDrive folder structure. This workflow recursively searches folders, filters for new or updated PDFs, extracts text, and uses a Mistral AI agent to generate a concise Executive Summary, Key Findings, and Structured Metadata (Date, Location, etc.), storing all insights into a n8n Data Table for easy access and further automation.

  Key Features & How It Works
  Scheduled Trigger & Recursive Folder Search:

  The workflow runs automatically (scheduled for 8 PM in this template) to monitor a specified main folder on OneDrive.

  It performs a deep, multi-level search (up to 8 layers) across subfolders to ensure no documents are missed.

  Smart Deduplication & Filtering:

  It checks new files against an internal n8n Data Table using the Compare Datasets node, ensuring only new or unique PDF files are processed, saving AI credits and processing time.

  A size check is also included, preventing attempts to process excessively large files.

  AI-Powered Document Intelligence (Mistral LLM):

  For each new PDF, the workflow extracts the text and passes it to a Mistral AI model for dual-stream analysis:

  Overview Agent: Generates an impartial, professional Executive Summary, a list of Key Findings & Data Points, and the document's Scope/Context.

  Document Information Agent: Extracts crucial metadata, including the single most relevant date, location (City/State/Country), and professional information (Name, Title, Organization).

  Structured Output and Archiving:

  AI outputs are meticulously validated and reformatted into a clean JSON object using Structured Output Parsers.

  The complete analysis, along with the original file name and path, is then logged as a new row in an n8n Data Table.

  Setup Notes
  OneDrive Folder: You must specify the exact name of your main folder in the 'Search for Main Folder' node.

  Data Table: Ensure your n8n Data Table exists with the required columns: Summary, Key_Findings, Scope, Date, Location, File_Name, and Path.

  Deep Folder Structure: The current configuration supports up to 8 levels of subfolders. If your files go deeper, you may need to add more "Get items in a folder" and "If" nodes.

  AI Customization: Review the AI agent prompts and the structured output schemas to customize the fields you want to extract or the summary style you require.

  Extend This Workflow
  The final output is organized data. You can easily extend this workflow to:

  Send daily/weekly digest emails with new summaries.

  Sync the extracted data to a Google Sheet, Airtable, or other database.

  Add a secondary AI agent to perform follow-up actions based on the "Key Findings."

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.merge","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatMistralCloud","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitInBatches","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.compareDatasets","n8n-nodes-base.splitInBatches","n8n-nodes-base.splitInBatches","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.merge","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE71aa28bxxX9K4Q+tQDHnffDn9racWHArgPY6JcgKOYpE6VIg6SSuIb/e89SSrjizuwuzaSAIVjU8N5zZ+7jnNn9cnOXD/7m+Zeb1WZ/8JuYX6eb5zfBhug5tSzoKJyMXPosg2XZea+TZiIp6SI3SkvtRGBWKRq5FiGGQCMVN8ubQ777tPaH/GKX0/59Ptx/erHFJ/mQ4eCwu89flzebbcr7m+c/wHvn1TOTDM+W0EQVkTpn4g01xKQYuJSJ5ihheePvMla/jx9zul/nxYfd6vY271jn9POn7k8buyFH2yT4fX62f1z5uBDrPm33q8Nqu4FvohxfWvojPvQ7WD7kHSB9+fpg7F/47biOPeNfl7/iFLZYJwqhzEsis/fEaZVJ8ap4R4V03J9w/iMfFivsxn6x2iz8omzXaQzs3SrutvttObzb5Je71U/5DC4zeskcr+Dd5cPu87vNK79aP+zweQi/BWCDZgYnRyJjjkirBXGOZhKditmzRJnIEwHwqwKQtLbh8wMwgmWFVCE5lEAkD5z4nBSxXCYvqQwhsIkAxFUBaGqvCkBTU5TSgWSeMpGMBgLclORCbdJZck2nUkheFYBl+qoAJLVBWaWJpawQKWMgNlpNQsnUS25lMm4iAHVdDVAur4pABcFLEpFYbVDFVkniqEqE25C5pcppzSci0NdFwMV1ZWyYs1YrFK+JnsjIBLEKHSlx7xV6tbS5nCJ4m3e3uQ348a89kILKpXW1NHmCR/Q6Y/TJOR0ZYTlrpLVMxCtJkdtIliyiUD5N7Km5bk+lvK6zaGWCpdKTWLJAViSK3eWC0KxDl9kGI/EUAd+kxZvt9tPi3U95t3jdxTIyhj6tV4fXm7/7A+bR/il4xrVcOlbLh6eb/RtQmgKCLZZw49ACZRDEM22I9AbTWWvvS//wV/vDzq8XL9bb+7R48dEfFm+BbH0C+1eg/csJ8dpvbuNHv9o8W991yx8NHL9/Bl1ZuWR6OlFOmywsc0p7RbCpQMxCJtZQR2gUOTP0QaF7m/y329tdvgWVaO6s763oIeOwhCq7BFkCtJIjJ7poRqQpibgMZMEirz33SO4+BUEqxcM9GM7i3f3h0/1h8b3f7Y8MY2pXt8f1D8tPZs521im+ZEpNZgV7dsoLbtCQE7IhmmSRDd3eZsWJ8yIFGpAatFeCZ8n7TbkrLV0qWWvGjdRlNgStiiJGuCP90JjejpKokslSiMxzb3a83mCLDovd9ucmuuQP/oMP6/Pz7zoYk7Y2qhvnH5wTUvtIeO6oHcsFu3dsqY4LxRRjqTxtYMD1p/2fL4XG5pHOE+WMlIdoQXOEBa6QwRdMpsQWZ3VX8SX08zL7XfyIhrpbvEWyLV4dO+s3N1bRFfi3Uc7ljV//7D/vH8rjpe+0RvHrfT6NYcmdZYISKhRIfxQYGRzMjoLLZZYii0ZNjAx33cjQ8jouxzRXGAuGuIhMxtlEOI/ImawUuoiJLIVeOpfF9y9fLdpjYlWegqSNvX+ChveGMJOcpZwk0Z6iA7iEyUB1wgjjzPOYvOF2gKfN54d46uy9iSdHHXlImjA0ItQU5JKlaEvgJ8xyoTnk5QBPm54P8dTJeBMP2JF21gd0yGP7MV2N20Ig3pRKOXrj8wBPm20P8dS5dRMPOJyDWwCIaDxSW0ECh/a1NtNQwKd50QM8bfJcyZ86VW5vECYdWjM4kBMYglRi/kUwzJS8EJpZI7waAGpz4QqgOvNtAlJJUU/BdRQoEmZatsggVQgvkRmVosq+DAC1iWQFUJ02NgHFoL1UvhCTOQBR3g1Z/IgCTStRrkCHBoDsJYDqTamdQ7KUyFHzFAUOQKDgjmN4eRXQfTKnQcQngN6v/tvmU+d4ugnvLmtCnrsgUtd6mHJd0UNd8VJIYYVxDrnoY2/Gv0dbf7Va58XrlyOVv8+HsymKxF4yJmZoFHnKbhkTGL0lUdJOuQroJ7A7EkHvvYyuCMnryNo9coBMOgwWYS4CRrXgyXa7xSE4JHWYhNZEAsVRYhA+CsHqwEY0Rw2YmWaUfVzQgDwYgxRPDv0bIxnzRDICxu4yo/jU93B1t3x+lxfdrIf3NqWMDwt763owjbZLO6cETqzSQqCJgJpUiK8rgUyCk0i7bCnz+JP1okl8x7JuTLZRapeOT+I8oZSSQyIH1jV7ilbGPbKvGGJs0DFaRp23bZQjGThB0BnTF6Dk6BvdVS6RIoNuRiRlAAEmilPvoDLR9cwJ5cvtz5v11qdFWa1HbhgqXGy7+W632+66jrrdHFab+3z8/YEtnivkYxTTtd67owqcCgcJByEIiWwdiBkVnaBn2SujnXT0FMV3v0DgxsOxVX/IvxyageSHha9227tXDwFfHIbQF3B/pXzS3R0teB2ag4A6tdbhWDRFr1LUidJrWF22/LTKPbHU1KD+Nm8OF8I/in1Gp/nEif4l8CwPeRdCBD1WFGpPiEg0lVw5ihKV/bbWkNRsRjzzNTXXkwH0NXU2iSqaDOkusDrBaolzCj/Qnhk6o7I5Dk9g8ebN2+6qZbWZgf3488367sLjcHTecbBn5nTHwSmTrAgIFAu+maQigYFNadHlJfdJhNAv7nh/hzxZvN5AT975o+c/MLfEDJ5x4mHJWgNtQaC0urkJzhoKEgwFH6PQGEyUVkL5fx3MjFhwMNMa2STQEsXAxWNET7YyEgw0zBCpjVGQT4Wnfgmt4n8+L/65Hbkx2x/XPC7pK2LsXMeGz2EfI+5O9PnNTbtTGeo1LzwS4EHDNeDGVnlLTASlKTSlHGgV5wiBaQE1SBY+ZO3zgGK2YRe9gYKAEJUpu05ygQiGooz0wQUnqkDbMrAFlEuNTFDDEp2JVOokg6XEc4vuibwmAB4IGGuEjPWK2VhFOkJoGki7mzJoxW/dU2mS90xHYiQqENpeEohsRSJFNvAYs+w/0uohbUvZFlLJwK6Hl+XzcJaOTyfLiQLZAk4ok2DQ2wtLTFMKXcLqxdRWuO0dNbzGtucB9QxSW0ZBose4hK70xHsTUKJca8MY86leTW3l20xS0Fimh6J85slTYajNATUkMR6pZcQK090/ca4oZVrlXAXaVsTNHTW6E8fDq9N5SJngyhZuiA4aGiFaS2wMpbt7RIIKp63pcZHjE7ORJ/XDR2YPTxxmzGPxrH+36wBJOpKkZ939jyFOQZpGdCGkqIs61xNyRA20tk9wuxSX9iKsxt83OXZWjssfniXiP3fdEH3+ww9fju9y1K4W7h7G7GqT8i83z+nXH3+Eg8edrRmoPO2pmvjVUc3GiGxq2Xq4k60ZO3tuOjCwPC2delNizDm/3Dmbdi7mOReXO+fTzuU85/Jy52LauZrnXF3uXE471/Oc68udq2nnZp5zc7lzPe3czXNuL3duOudHG79J3JqNMfVVqd2jwVPPqba0ygPIamy9x4EzutLURp281oyNv3lQtfj0mqZmtH0FMtb1vgHK08vL6zfr6S3t7zESnt5Iz7E41WrPI6rZbF+ejh1A4yq4imLgoQejK4fjv2+OcZBAtSDHbxTO7S4Hlf2HZeUwR645I9Y8o6ncG+7679ABGlimTnT4lm0Ny9QLB+1Drb1C0eheg8ub5ghp7gMbzJCrzJ0mSPUwnpZWL/+r1+XjUfdrZbSoLhh7jTeTG7T+7K2F5gSsEOARi1O10GC1IxanMrpBVUcsTvHYBv8csThFThukcsTiFONsMMURi1M0skH/RizaqV5T7yI1i1Mv1ddVZ+slSHjwq393d773/jY/fjZ7Yg2+Wm10YwU6z8Jw/l32vW/3POOhzHWG5tl5SJKWiYdD7D8Dmt0gz7831yebcjqx9SNOv379H1IM4LebMwAA


name: Generate AI Videos from Text or Images with Sora 2/Pro & GPT-5 Enhancement
author_name: Daniel Nkencho
author_username: daniel-automates
categories: []
created_at: 2025-10-25T00:30:00.564Z
updated_at: 2025-10-25T00:30:00.564Z
url: https://n8n.io/workflows/10139
scraped_at: 2025-12-24 13:02:41
description:
  Harness OpenAI's Sora 2 for instant video creation from text or images using fal.ai's API—powered by GPT-5 for refined prompts that ensure cinematic quality. This template processes form submissions, intelligently routes to text-to-video (with mandatory prompt enhancement) or image-to-video modes, and polls for completion before redirecting to your generated clip.

  📋 What This Template Does
  Users submit prompts, aspect ratios (9:16 or 16:9), models (sora-2 or pro), durations (4s, 8s, or 12s), and optional images via a web form. For text-to-video, GPT-5 automatically refines the prompt for optimal Sora 2 results; image mode uses the raw input. It calls one of four fal.ai endpoints (text-to-video, text-to-video/pro, image-to-video, image-to-video/pro), then loops every 60s to check status until the video is ready.
  Handles dual modes: Text (with GPT-5 enhancement) or image-seeded generation
  Supports pro upgrades for higher fidelity and longer clips
  Auto-uploads images to a temp host and polls asynchronously for hands-free results
  Redirects directly to the final video URL on completion

  🔧 Prerequisites
  n8n instance with HTTP Request and LangChain nodes enabled
  fal.ai account for Sora 2 API access
  OpenAI account for GPT-5 prompt refinement

  🔑 Required Credentials

  fal.ai API Setup
  Sign up at fal.ai and navigate to Dashboard → API Keys
  Generate a new key with "sora-2" permissions (full access recommended)
  In n8n, create "Header Auth" credential: Name it "fal.ai", set Header Name to "Authorization", Value to "Key [Your API Key]"

  OpenAI API Setup
  Log in at platform.openai.com → API Keys (top-right profile menu)
  Click "Create new secret key" and copy it (store securely)
  In n8n, add "OpenAI API" credential: Paste key, select GPT-5 model in the LLM node

  ⚙️ Configuration Steps
  Import the workflow JSON into your n8n instance via Settings → Import from File
  Assign fal.ai and OpenAI credentials to the relevant HTTP Request and LLM nodes
  Activate the workflow—the form URL auto-generates in the trigger node
  Test by submitting a sample prompt (e.g., "A cat chasing a laser"); monitor executions for video output
  Adjust polling wait (60s node) for longer generations if needed

  🎯 Use Cases
  Social Media Teams**: Generate 9:16 vertical Reels from text ideas, like quick product animations enhanced by GPT-5 for professional polish
  Content Marketers**: Animate uploaded images into 8s promo clips, e.g., turning a static ad graphic into a dynamic story for email campaigns
  Educators and Trainers**: Create 4s explainer videos from outlines, such as historical reenactments, using pro mode for detailed visuals
  App Developers**: Embed as a backend service to process user prompts into Sora 2 videos on-demand for creative tools

  ⚠️ Troubleshooting
  API quota exceeded**: Check fal.ai dashboard for usage limits; upgrade to pro tier or extend polling waits
  Prompt refinement fails**: Ensure GPT-5 credential is set and output matches JSON schema—test LLM node independently
  Image upload errors**: Confirm file is JPG/PNG under 10MB; verify tmpfiles.org endpoint with a manual curl test
  Endless polling loop**: Add an IF node after 10 checks to timeout; increase wait to 120s for 12s pro generations

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.form","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi"]

workflow_json_compressed:
  [encoded data, 10364 characters]


name: Send WooCommerce Discount Coupons to Customers via WhatsApp Using Rapiwa API
author_name: Rapiwa
author_username: rapiwa
categories: []
created_at: 2025-10-25T03:47:51.211Z
updated_at: 2025-10-25T03:47:51.211Z
url: https://n8n.io/workflows/10140
scraped_at: 2025-12-24 13:02:46
description:
  Who is this for?
  This workflow is ideal for WooCommerce store owners who want to automatically send promotional WhatsApp messages to their customers when new coupons are created. It’s designed for marketers and eCommerce managers looking to boost engagement, streamline coupon sharing, and track campaign performance effortlessly through Google Sheets.

  Overview
  This workflow listens for WooCommerce coupon creation events (coupon.created) and uses customer billing data to send promotional WhatsApp messages via the Rapiwa API. The flow formats the coupon data, cleans phone numbers, verifies WhatsApp registration with Rapiwa, sends the promotional message when verified, and logs each attempt to Google Sheets (separate sheets for verified/sent and unverified/not sent).

  What this Workflow Does
  Listens for new coupon creation events in WooCommerce via the WooCommerce Trigger node
  Retrieves all customer data from the WooCommerce store
  Processes customers in batches to control throughput
  Cleans and formats customer phone numbers for WhatsApp
  Verifies if phone numbers are valid WhatsApp accounts using Rapiwa API
  Sends personalized WhatsApp messages with coupon details to verified numbers
  Logs all activities to Google Sheets for tracking and analysis
  Handles both verified and unverified numbers appropriately

  Key Features
  Automated coupon distribution: Triggers when new coupons are created in WooCommerce
  Customer data retrieval: Fetches all customer information from WooCommerce
  Phone number validation: Verifies WhatsApp numbers before sending messages
  Personalized messaging: Includes customer name and coupon details in messages
  Dual logging system: Tracks both successful and failed message attempts
  Rate limiting: Uses batching and wait nodes to prevent API overload
  Data formatting: Structures coupon information for consistent messaging

  Google Sheet Column Structure
  A Google Sheet formatted like this ➤ sample
  The workflow uses a Google Sheet with the following columns to track coupon distribution:

  | name        | number        | email                                               | address1  | couponCode | couponTitle    | couponType | couponAmount | createDate          | expireDate          | validity   | status   |
  | ----------- | ------------- | --------------------------------------------------- | --------- | ---------- | -------------- | ---------- | ------------ | ------------------- | ------------------- | ---------- | -------- |
  | Abdul Mannan | 8801322827799 | contact@spagreen.net     | mirpur-DOHS | 62dhryst   | eid offer 2025 | percent    | 20.00        | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | unverified | not sent |
  | Abdul Mannan  | 8801322827799 | contact@spagreen.net | mirpur-DOHS | 62dhryst   | eid offer 2025 | percent    | 20.00        | 2025-09-11 06:08:02 | 2025-09-15 00:00:00 | verified   | sent     |

  Requirements
  n8n instance with the following nodes: WooCommerce Trigger, Code, SplitInBatches, HTTP Request, IF, Google Sheets, Wait
  WooCommerce store with API access
  Rapiwa account with API access for WhatsApp verification and messaging
  Google account with Sheets access
  Customer phone numbers in WooCommerce (stored in billing.phone field)

  Important Notes
  Phone Number Format**: The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format.
  API Rate Limits**: Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly.
  Data Privacy**: Ensure compliance with data protection regulations when sending marketing messages.
  Error Handling**: The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls.
  Message Content**: The current message template references the first coupon only (coupons[0]). Adjust if you need to handle multiple coupons.

  Useful Links
  Dashboard:** https://app.rapiwa.com
  Official Website:** https://rapiwa.com
  Documentation:** https://docs.rapiwa.com

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.splitInBatches","n8n-nodes-base.wooCommerceTrigger","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.wooCommerce","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-rapiwa.rapiwa","n8n-nodes-rapiwa.rapiwa"]

workflow_json_compressed:
  [encoded data, 6956 characters]


name: Send WooCommerce Cross-Sell Offers to Customers via WhatsApp Using Rapiwa API
author_name: Rapiwa
author_username: rapiwa
categories: []
created_at: 2025-10-25T05:02:48.956Z
updated_at: 2025-10-25T05:02:48.956Z
url: https://n8n.io/workflows/10141
scraped_at: 2025-12-24 13:02:45
description:
  Who Is This For?
  This n8n workflow enables automated cross-selling by identifying each WooCommerce customer's most frequently purchased product, finding a related product to recommend, and sending a personalized WhatsApp message using the Rapiwa API. It also verifies whether the user's number is WhatsApp-enabled before sending, and logs both successful and unsuccessful attempts to Google Sheets for tracking.

  What This Workflow Does
  Retrieves all paying customers from your WooCommerce store  
  Identifies each customer's most purchased product  
  Finds the latest product in the same category as their most purchased item  
  Cleans and verifies customer phone numbers for WhatsApp compatibility  
  Sends personalized WhatsApp messages with product recommendations  
  Logs all activities to Google Sheets for tracking and analysis  
  Handles both verified and unverified numbers appropriately  

  Key Features
  Customer Segmentation:** Automatically identifies paying customers from your WooCommerce store  
  Product Analysis:** Determines each customer's most purchased product  
  Smart Recommendations:** Finds the latest products in the same category as customer favorites  
  WhatsApp Integration:** Uses Rapiwa API for message delivery  
  Phone Number Validation:** Verifies WhatsApp numbers before sending messages  
  Dual Logging System:** Tracks both successful and failed message attempts in Google Sheets  
  Rate Limiting:** Uses batching and wait nodes to prevent API overload  
  Personalized Messaging:** Includes customer name and product details in messages  

  Requirements
  WooCommerce store with API access  
  Rapiwa account with API access for WhatsApp verification and messaging  
  Google account with Sheets access  
  Customer phone numbers in WooCommerce (stored in billing.phone field)  

  How to Use — Step-by-Step Setup
  1. Credentials Setup
   WooCommerce API: Configure WooCommerce API credentials in n8n (e.g., "WooCommerce (get customer)" and "WooCommerce (get customer data)")  
   Rapiwa Bearer Auth: Create an HTTP Bearer credential with your Rapiwa API token  
   Google Sheets OAuth2: Set up OAuth2 credentials for Google Sheets access  

  2. Configure Google Sheets
   Ensure your sheet has the required columns as specified in the Google Sheet Column Structure section  

  3. Verify Code Nodes
   Code (get paying_customer): Filters customers to include only those who have made purchases  
   Get most buy product id & Clear Number: Identifies the most purchased product and cleans phone numbers  

  4. Configure HTTP Request Nodes
   Get customer data: Verify the WooCommerce API endpoint for retrieving customer orders  
   Get specific product data: Verify the WooCommerce API endpoint for product details  
   Get specific product recommend latest product: Verify the WooCommerce API endpoint for finding latest products by category  
   Check valid WhatsApp number Using Rapiwa: Verify the Rapiwa endpoint for WhatsApp number validation  
   Rapiwa Sender: Verify the Rapiwa endpoint for sending messages  

  Google Sheet Required Columns
  You’ll need two Google Sheets (or two tabs in one spreadsheet):
  A Google Sheet formatted like this ➤ sample
  The workflow uses a Google Sheet with the following columns to track coupon distribution:
  Both must have the following headers (match exactly):

  | name       | number      | email  | address1    | price | suk | title   | product link   | validity   | staus    |
  | ---------- | ------------- | ----------------------------------------------- | ----------- | ----- | --- | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------- | -------- |
  | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850   |     | Sharp Most Demanding Hoodie x Nike |  https://your_shop_domain/p-img-nike  | verified   | sent     |
  | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850   |     | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | unverified | not sent |
  | Abdul Mannan | 8801322827799 | contact@spagreen.net | mirpur dohs | 850   |     | Sharp Most Demanding Hoodie x Nike | https://your_shop_domain/p-img-nike | verified   | sent     |

  Important Notes
  Phone Number Format:** The workflow cleans phone numbers by removing all non-digit characters. Ensure your WooCommerce phone numbers are in a compatible format.  
  API Rate Limits:** Rapiwa and WooCommerce APIs have rate limits. Adjust batch sizes and wait times accordingly.  
  Data Privacy:** Ensure compliance with data protection regulations when sending marketing messages.  
  Error Handling:** The workflow logs unverified numbers but doesn't have extensive error handling. Consider adding error notifications for failed API calls.  
  Product Availability:** The workflow recommends the latest product in a category, but doesn't check if it's in stock. Consider adding stock status verification.  
  Testing:** Always test with a small batch before running the workflow on your entire customer list.  

  Useful Links
  Dashboard:** https://app.rapiwa.com
  Official Website:** https://rapiwa.com
  Documentation:** https://docs.rapiwa.com

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.wooCommerce","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-rapiwa.rapiwa","n8n-nodes-rapiwa.rapiwa"]

workflow_json_compressed:
  [encoded data, 8088 characters]


name: Website Chatbot with Google Drive Knowledge Base using GPT-4 and Mistral AI
author_name: DIGITAL BIZ TECH
author_username: dbt
categories: []
created_at: 2025-10-25T05:51:33.317Z
updated_at: 2025-10-25T05:51:33.317Z
url: https://n8n.io/workflows/10142
scraped_at: 2025-12-24 13:02:41
description:
  AI-Powered Website Chatbot with Google Drive Knowledge Base

  Overview
  This workflow combines website chatbot intelligence with automated document ingestion and vectorization — enabling live Q&A from both chat input and processed Google Drive files.  
  It uses Mistral AI for OCR + embeddings, and Qdrant for vector search.

  Chatbot Flow
  Trigger:** When chat message received or webhook based upon deployed chatbot
  Model:** OpenAI gpt-4.1-mini
  Memory:** Simple Memory (Buffer Window)
  Vector Search Tool:** Qdrant Vector Store 
  Embeddings:** Mistral Cloud
  Agent:** website chat agent
    Responds based on chatdbtai Supabase content
    Enforces brand tone and informative documents.
    Integratration  with both:
      Embedded chat UI
      Webhook 

  Document → Knowledge Base Pipeline
  Triggered manually to keep vector store up-to-date.

  Steps
  Google Drive (brand folder)  
     → Fetch files from folder Website kb (ID: 1o3DK9Ceka5Lqb8irvFSfEeB8SVGG_OL7)
  Loop Over Items  
     → For each file:
     Set metadata
     Download file
     Upload to Mistral for OCR
     Get Signed URL
     Run OCR extraction (mistral-ocr-latest)
  If OCR success  
     → Pass to chunking pipeline  
     Else → skip and continue
  Chunking Logic (Code node)  
     Splits document into 1,000-character JSON chunks  
     Adds metadata (source, char positions, file ID)
  Default Data Loader + Text Splitter  
     → Prepares chunks for embedding
  Embeddings (Mistral Cloud)  
     → Generates embeddings for text chunks
  Qdrant Vector Store (Insert mode)  
     → Saves embeddings into docragtestkb collection
  Wait  
     → Optional delay between batches

  Integrations Used
  | Service | Purpose | Credential |
  |----------|----------|------------|
  | Google Drive | File source | Google Drive account 6 rn dbt |
  | Mistral Cloud | OCR + embeddings | Mistral Cloud account 2 dbt rn |
  | Qdrant | Vector storage | QdrantApi account |
  | OpenAI | Chat model | OpenAi account 8 dbt digi |

  Agent System Prompt Summary
  &gt; “You are the official AI assistant for this website.  
  Use chatdbtai only as your knowledge source.  
  Respond conversationally, list offerings clearly, link blogs, and say  
  ‘I couldn’t find that on this site’ if no match.”

  Key Features
  ✅ Automated OCR + chunking → vectorization  
  ✅ Persistent memory for chat sessions  
  ✅ Multi-channel (Webhook + Embedded Chat)  
  ✅ Fully brand-guided, structured responses  
  ✅ Live data retrieval from Qdrant vector store  

  Summary
  &gt; A unified workflow that turns brand files + web content into a knowledge base that powers a intelligent chatbot — capable of responding to visitors in real time, powered by Mistral, OpenAI, and Qdrant.

  Need Help or More Workflows?
  Want to customize this workflow for your business or integrate it with your existing tools?  
  Our team at Digital Biz Tech can tailor it precisely to your use case  from automation logic to AI-powered enhancements.  

  💡 We can help you set it up for free — from connecting credentials to deploying it live.

  Contact: shilpa.raju@digitalbiz.tech  
  Website: https://www.digitalbiz.tech  
  LinkedIn: https://www.linkedin.com/company/digital-biz-tech/  
  You can also DM us on LinkedIn for any help.

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterCharacterTextSplitter","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.embeddingsMistralCloud","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.embeddingsMistralCloud","n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8212 characters]


name: Automated Template Delivery System with Stripe, GPT-4o & Gmail
author_name: Rahul Joshi
author_username: rahul08
categories: []
created_at: 2025-10-25T06:47:48.826Z
updated_at: 2025-10-25T06:47:48.826Z
url: https://n8n.io/workflows/10145
scraped_at: 2025-12-24 13:02:43
description:
  📊 Description
  Automate post-purchase workflows by instantly fetching successful Stripe payments, matching them to corresponding automation templates in Google Sheets, and sending customers personalized access emails using AI-generated content. This system ensures each buyer receives their digital template, password, and onboarding details automatically after payment. 💳📩🤖

  What This Template Does
  Step 1: Triggers daily at 7:00 AM IST to fetch all successful payment charges from Stripe. ⏰
  Step 2: Retrieves payment intent and product details for each successful charge to enrich context. 💰
  Step 3: Validates required fields (order reference, product name, customer name, email). ✅
  Step 4: Matches purchased product with the automation record in Google Sheets via AI lookup. 🔍
  Step 5: Combines Stripe and Sheet data into one record, ensuring accuracy and completeness. 🔄
  Step 6: Filters out already-processed customers to avoid duplicate sends. 🧮
  Step 7: Generates a personalized thank-you email using Azure OpenAI (GPT-4o-mini) including access links, password, and onboarding tips. 💌
  Step 8: Sends the email through Gmail to the customer automatically. 📧
  Step 9: Logs each transaction and email delivery into Google Sheets for tracking and auditing. 📊

  Key Benefits
  ✅ Fully automated Stripe-to-email delivery flow
   ✅ Zero manual intervention — instant template delivery
   ✅ AI-personalized HTML emails with customer details
   ✅ Centralized purchase logging and analytics
   ✅ Eliminates duplicates and ensures smooth customer experience

  Features
  Scheduled daily trigger (7:00 AM IST)
  Stripe API integration for payment and product details
  Google Sheets lookup for automation files and passwords
  GPT-powered email content generation
  Gmail API integration for delivery
  Google Sheets logging for audit trail

  Requirements
  Stripe API credentials
  Google Sheets OAuth2 credentials
  Gmail OAuth2 credentials
  Azure OpenAI API credentials

  Target Audience
  SaaS or digital product sellers using Stripe
  Automation template marketplaces
  Small teams delivering digital assets via email
  Businesses seeking instant customer fulfillment

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatAzureOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatAzureOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stripe","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.googleSheets","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  H4sIAAAAAAAAE7Va244bxxH9lQGfZHhb6ftFT1HWliHAtuzI8EMMIejrLiEuyZBDyRtBQJ7yAckf+ktymqS0XO7McoZCHqQld3u6T1dXnTpVPR8m0zR5NnGX72+//TVccfa3n1e+XU4uJje59ZNnHybT+br185hf1nFWSlEYpZZzY6PU3qtYhI/FlkKLoVQzz6OyIWajc/HRMhmY5o5aqZgxmLfNN8uZb/PlKqf169xulpcL/Ca3GQu0q03+eDGZ+5uM1Z5v2sUNhja/7J9pvsmz6bu8um3aRXO5WePPebVuympx07xuV9Nlbn7ytzd53q7rSv5qPXn22xvMt0i5fvyw220ukefgFVHJciJlocQyHomhOnPhqQ6CTu5Q/HOzys2rZZ4/f9lcXvu2+QHTzeoCt8s64M9zO/8T/pHtMmTm51fx2k/nT2c3dfj2+e3jUzyzXKyn7XQxBxquGL9g0nAgXPoVVmuxG9j8427qX/FtO5J9vNgjd9nzlDIjysdMZAqB2Owi0YKKQlXJWYY75DDJJrZYPTWvNu1y08I6q3VeDYC+2I7fDb+b5gi/NgPxPxWfdxAFz0K4QoorGjtwnsBZKEmlmISvhZpy0vbsy42vrR1pe0a95xq+Qg1XRDpViHUhEu4ZTV7aVLg4bfsh0IcY30k52vZeRl2CKUTowGB7m0jQKRLEc7EUPqS9u9vBd7ltVov3T9ZfNdN5s77O+I4P3y0WV7PcvK7f13ebudtH8Ov89Go7ajfol8Vidh+8ZXoQePlU37k+UzwGmYnVAo4jmCBgH06KUixa75Lk4T74PRU0L+dt/fHkRaUJOMXqKn/VC/y6bZd/zf/Y5HV7HzPRCqC506dB3/mM4JIqykAy0Vv4jI7wmewJtTqK4izNnB2BXi0SDhxM1/rpbN082ZLb/a2cg55T+Dtno9Brow0NKREaPUxOYXzHuCFJmSQSeFNTfYf+ZWG9uKblCI4UfBAc/pR/hlNSjDpKRUTShkiYjtgoAkkh+pKRgaw7MOan9NAgg8Tr6fyqF1zEx/vwmKYU8LQ8Ce8zOIU0yEp0xCkasT3qia/0HOG1IhbqKGWH7DCNb2+bHxdt7jfaejuojjkyHuMVnuL0GN4kLrYOgrkm/USmJMAoFkgGZ8Ep8V8wwRMeqcUeNCtJdkLl46E6h3Nm2p6HVJvItfWC2KLhgBJGRYIIJDDvjU3RBWE6kdrRSLmtHknlmTZNSnrIBkeiE6DWoARxOkgShFRWAGgy3UjdeKRSg/rB2WcildmKYsH6zkBC5GQgIQwjXnntpWZUy9TtqHQ8VM4BVZ17/NIq7UsEZ2oJo0oG/uEF4sfApZIzAoHQDXV8UHEqQZBMPGCkYVCFSMVD6xIjcOrITpbYROEEASqYq+B8Kd1QxwcVs1V3nR3+UTBXcoRvFggACdKCfbOErBGWl8KMLqIbqhgPtRIpOOA8pMGqkG3UhDHILqmoIjCkIc4LXrwuWpVuomJyPFKlYFQtzoSamHHJgkRzrlBlAf1nEGtEeRSE8C720b8aD5VXAlDnumplTWR1Ct8MOP8gDZaLnkQfuUlKcOVVN1Q9HiqtoulsVo0pKxXgpSZEQK1JyqYAFlBMGBcslbzHqmY01FoQnO2pJfpMCwqazLmtyhrhryQntCgjkQ20Cj2kOj5TCSu/IPoDg5vGwiGiEjjVywQRxTlEVAmOCdT3PHcjHZ+pQCWgVPpARQ0MqSKUiUhPYE9QKoiAeMcT4ckxJ0pxTvtumTI+UZFK/mfnKUGZFBLE5JOo5I/kb6OlCH4INWuL9yx2Iz1D/AkqL5w5M/a55RKRQ4nhGRI6qUAQ+opYI1HeIB9w252m+HjuJ4bWEtWem/y9cxb1B4Guhk4JiCsrVRX/AMyYTMHoTqhn6Gmc/Bfk/ugiLwraj0tbuR8liQ/eE8U88PNkKeX3GgO1T/WNb31zuZjNctzC6Addhx8DZtW0Qj/ggH6QyO4Gtb4gOkaATNDTToOhPHzXG8at9QcC9cV0hhmbP/713+b1Jsa8XpfNbF879xf9ZfvUEVbrQALiIbE+VulFwxWqTUoCd6idEfbI+bYQbqKyJYui+EGKev6yeX5Vq+Pmj3//535/ovl+sXi7WQ7oufg6w33opioCnGkH8lVuV7ev5i9Qou+alg82c2D5zAPlULGSJ08g3iNxCfpQSi6URWZzqpvHxoccZCf8AsnhPEc22aHEgijgIdDa4arlFhjNKoN6Ucns6GF3MV7ntIGpf1lNr67gLd/AGrf9mPfD96OPPVpwO8yjD9wk2KAtz3DiwmDZamMUhAJKJsWgQpE6H+D9IcN59z7cfP2ppbJvDn39qfHSi/+mPn6sbi9qxjwFWRxA1kJDKELSapqQKqiC+KrdDMqSlgbC3sp8DPn7xdU0Ni8WqxvfbnljRCeDSzrIrPyQd70qrNZbxdUU4UnQOhJttXXQHoWpAylzeZ3j26a2nKa11flimmepnyCO20DbSnYIugMLok6VXCVdez+IKQ9FgHyQCERNNnBUjbr2GN8PtQUEC27maTC2GkZ94d/fouLOiqAy4aA9IiPOGDnMEypRstgki7kHbnETpvP86eri6x1pPX7EXW4oqs4aYMZDR1QoSpTSkghUS0AqCmKdlSqymWCSBRTYj/eCa3L4abMCfa73dPuAbR9pCnc13KTq6gfm33PctPnVPOZOrpVPzedd1T6wcd6RTCl2VVAwhFqLFcZTVMkjyg4Z7Ofvm/0ZjLK35cPc9tDeVKeMsjsTUSzkjJMMapFBd6dii9U8uMMGwc5t9/dfmKv59vfp+pF2+7Hz7roZIyPL1c5SSchMoSaqiBzlKeoDJUUOqiSRzYGOwVkvm1fvwPsv23yzbhal+TG//+wR/VjXy9kUtPuXGpP5yA84r62NIaa9Y1TpU6FJECY1kpaVljgKO1umLVSjTCYfXih90grVe7+9QcaqHgAEg27FOkQCl1XfDKGJg14hSjDqPKS8RsCVzIgzSFvwq+KS5tj/YQmW56nxzQ00GJZvnnxXQfffAFzVPx+3Nqsz7CC+z+EaQbq9zA0qFVQDBvrXV92KYAElQJ3w7FESBuO36f6E/xxckBVfHZlC+KJGlz7U4kIGwrjXHrpCUnp4rbpc1p0tVs1mmerdLvjljlxqumugLHx8+1jrvp9RBB3oSZU+MMZDhr/7TDDr3LZYdyuddvyDsa9WCV7ybPKOVQ31bjfB1pJFlnoVyADKIGcyWZtr0HkGh8uRljTiEfAgwuY7ub+duF6Y4AcOrAL+7cP2mnpy1jXQdo6LyXSe8u+TZ/TjmzdAeEhvXeucJJnOWR9m1M65h6S27vkf3Nt0zd9J3Y/gPVYoXXOOqSOOl7r4kp2z/Xl1C+rO7Z8oIrv9oZtJOk1xVnB2r9oNtWvVgVVn5zJ9b2lgHT/9e6XwDTa9/13XoT+WEB7M0O1kD0Opa5fDE2fnRvtqgv4I71XnYwzJhltyQPicNGjvqys7FIdvSJx1nPcmGLo4G7z6MBM8CuKxnXRSwgmd0E2Oj5BVp0P1X6r3M+KZxUMn4McpojebDnoTpH8HY1sHnfR+EkgX+nsvVfy/AO5te5KYDgC+uRgZc91cczpe+mmts6jvXGbQm0y70G7ru0pfENLt7l2nLso+eTpdWz3ZAerd8DAF2b/muc7E90c7RkH8H9LkONI5U2JuI/vjx/8BxDo4T0UrAAA=


name: Local Document Question Answering with Ollama AI, Agentic RAG & PGVector
author_name: Jadai kongolo
author_username: jadai-ai-automation
categories: []
created_at: 2025-10-25T10:13:07.225Z
updated_at: 2025-10-25T10:13:07.225Z
url: https://n8n.io/workflows/10157
scraped_at: 2025-12-24 13:02:41
description:
  🚀 n8n Local AI Agentic RAG Template

  Author: Jadai kongolo

  What is this?
  This template provides an entirely local implementation of an Agentic RAG (Retrieval Augmented Generation) system in n8n that can be extended easily for your specific use case and knowledge base. Unlike standard RAG which only performs simple lookups, this agent can reason about your knowledge base, self-improve retrieval, and dynamically switch between different tools based on the specific question. 

  Why Agentic RAG?
  Standard RAG has significant limitations:
  Poor analysis of numerical/tabular data
  Missing context due to document chunking
  Inability to connect information across documents
  No dynamic tool selection based on question type

  What makes this template powerful:
  Intelligent tool selection**: Switches between RAG lookups, SQL queries, or full document retrieval based on the question
  Complete document context**: Accesses entire documents when needed instead of just chunks
  Accurate numerical analysis**: Uses SQL for precise calculations on spreadsheet/tabular data
  Cross-document insights**: Connects information across your entire knowledge base
  Multi-file processing**: Handles multiple documents in a single workflow loop
  Efficient storage**: Uses JSONB in Supabase to store tabular data without creating new tables for each CSV

  Getting Started
  Run the table creation nodes first to set up your database tables in Supabase
  Upload your documents to the folder on your computer that is mounted to /data/shared in the n8n container. This folder by default is the "shared" folder in the local AI package.
  The agent will process them automatically (chunking text, storing tabular data in Supabase)
  Start asking questions that leverage the agent's multiple reasoning approaches

  Customization
  This template provides a solid foundation that you can extend by:
  Tuning the system prompt for your specific use case
  Adding document metadata like summaries
  Implementing more advanced RAG techniques
  Optimizing for larger knowledge bases

  The non-local ("cloud") version of this Agentic RAG agent can be found here.

nodes_used:
  ["@n8n/n8n-nodes-langchain.documentDefaultDataLoader","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.memoryPostgresChat","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.respondToWebhook","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.webhook","n8n-nodes-base.extractFromFile","n8n-nodes-base.aggregate","n8n-nodes-base.summarize","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.switch","n8n-nodes-base.extractFromFile","n8n-nodes-base.set","n8n-nodes-base.extractFromFile","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.postgresTool","n8n-nodes-base.postgresTool","n8n-nodes-base.postgresTool","n8n-nodes-base.splitInBatches","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.stickyNote","n8n-nodes-base.localFileTrigger","n8n-nodes-base.readWriteFile","@n8n/n8n-nodes-langchain.embeddingsOllama","@n8n/n8n-nodes-langchain.embeddingsOllama","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","n8n-nodes-base.postgres","@n8n/n8n-nodes-langchain.vectorStorePGVector","@n8n/n8n-nodes-langchain.vectorStorePGVector"]

workflow_json_compressed:
  [encoded data, 9388 characters]


name: Customer Pain Analysis & AI Briefing with Anthropic, Reddit, X, and SerpAPI
author_name: Bhuvanesh R
author_username: bhuvanesh
categories: []
created_at: 2025-10-25T12:35:31.611Z
updated_at: 2025-10-25T12:35:31.611Z
url: https://n8n.io/workflows/10164
scraped_at: 2025-12-24 13:02:44
description:
  The competitive edge, delivered. This Customer Intelligence Engine simultaneously analyzes the web, Reddit, and X/Twitter to generate a professional, actionable executive briefing.

  🎯 Problem Statement

  Traditional market research for Customer Intelligence (CI) is manual, slow, and often relies on surface-level social media scraping or expensive external reports. Service companies, like HVAC providers, struggle to efficiently synthesize vast volumes of online feedback (Reddit discussions, real-time tweets, web articles) to accurately diagnose systemic service gaps (e.g., scheduling friction, poor automated systems). This inefficiency leads to delayed strategic responses and missed opportunities to invest in high-impact solutions like AI voice agents.

  ✨ Solution

  This workflow deploys a sophisticated Multisource Intelligence Pipeline that runs on a scheduled or ad-hoc basis. It uses parallel processing to ingest data from three distinct source types (SERP API, Reddit, and X/Twitter), employs a zero-cost Hybrid Categorization method to semantically identify operational bottlenecks, and uses the Anthropic LLM to synthesize the findings into a clear, executive-ready strategic brief. The data is logged for historical analysis while the brief is dispatched for immediate action.

  ⚙️ How It Works (Multi-Step Execution)
  1.  Ingestion and Parallel Processing (The Data Fabric)

  Trigger:** The workflow is initiated either on an ad-hoc basis via an n8n Form Trigger or on a schedule (Time Trigger).
  Parallel Ingestion:** The workflow immediately splits into three parallel branches to fetch data simultaneously:

    SERP API: Captures authoritative content and industry commentary (Strategic Context).
    Reddit (Looping Structure): Fetches posts from multiple subreddits via an Aggregate Node workaround to get authentic user experiences (Qualitative Signal).
    X/Twitter (HTTP Request): Bypasses standard rate limits to capture real-time social complaints (Sentiment Signal).

  2. Analysis and Fusion (The Intelligence Layer)

  Cleanup and Labeling (Function Nodes):** Each branch uses dedicated Function Nodes to filter noise (e.g., low-score posts) and normalize the data by adding a source tag (e.g., 'Reddit').
  Merge:** A Merge Node (Append Mode) fuses all three parallel streams into a single, unified dataset.
  Hybrid Categorization (Function Node):** A single Function Node applies the Hybrid Categorization Logic. This cost-free step semantically assigns a pain_point category (e.g., 'Call Hold/Availability') and a sentiment_score to every item, transforming raw text into labeled metrics.

  3. Dispatch and Reporting (The Executive Output)

  Aggregation and Split (Function Node):** The final Function Node calculates the total counts, deduplicates the final results, and generates the comprehensive summaryString.
  Data Logging:* The aggregated counts and metrics are appended to *Google Sheets** for historical logging.
  LLM Input Retrieval (Function Node):** A final Function Node retrieves the summary data using the $items() helper (the serial route workaround).
  AI Briefing:* The *Message a model (Anthropic) Node receives the summaryString and uses a strict HTML System Prompt to synthesize the strategic brief, identifying the top pain points and suggesting AI features.
  Delivery:* The *Gmail Node** sends the final, professional HTML brief to the executive team.

  🛠️ Setup Steps

  Credentials

  Anthropic:** Configure credentials for the Language Model (Claude) used in the Message a model node.
  SERP API, Reddit, and X/Twitter:** Configure API keys/credentials for the data ingestion nodes.
  Google Services:** Set up OAuth2 credentials for Google Sheets (for logging data) and Gmail (for email dispatch).

  Configuration

  Form Configuration:** If using the Form Trigger, ensure the Target Keywords and Target Subreddits are mapped correctly to the ingestion nodes.
  Data Integrity:** Due to the serial route, ensure the Function (Get LLM Summary) node is correctly retrieving the LLM_SUMMARY_HOLDER field from the preceding node's output memory.

  ✅ Benefits

  Proactive CI & Strategy:** Shifts market research from manual, reactive browsing to proactive, scheduled data diagnostic.
  Cost Efficiency:** Utilizes a zero-cost Hybrid Categorization method (Function Node) for intent analysis, avoiding expensive per-item LLM token costs.
  Actionable Output:** Delivers a fully synthesized, HTML-formatted executive brief, ready for immediate presentation and strategic sales positioning.
  High Reliability:** Employs parallel ingestion, API workarounds, and serial routing to ensure the complex workflow runs consistently and without failure.

nodes_used:
  ["n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.reddit","n8n-nodes-serpapi.serpApi","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.anthropic","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 12220 characters]


name: PPC Campaign Intelligence & Optimization with Google Ads, Sheets & Slack
author_name: Daniel Shashko
author_username: tomax
categories: []
created_at: 2025-10-25T17:01:17.918Z
updated_at: 2025-10-25T17:01:17.918Z
url: https://n8n.io/workflows/10174
scraped_at: 2025-12-24 13:02:41
description:
  How it Works

  This workflow automatically monitors your Google Ads campaigns every day, analyzing performance with AI-powered scoring to identify scaling opportunities and catch issues before they drain your budget. Each morning at 9 AM, it fetches all active campaign data including clicks, impressions, conversions, costs, and conversion rates from your Google Ads account.

  The AI analysis engine evaluates four critical dimensions: CTR (click-through rate) to measure ad relevance, conversion rate to assess landing page effectiveness, cost per conversion to evaluate profitability, and traffic volume to identify scale-readiness. Each campaign receives a performance score (0-100 points) and is automatically categorized as Excellent (75+), Good (55-74), Fair (35-54), or Underperforming (0-34).

  High-performing campaigns trigger instant Slack alerts to your PPC team with detailed scaling recommendations and projected ROI improvements, while underperforming campaigns generate urgent alerts with specific optimization actions. Every campaign is logged to your Google Sheets dashboard with daily metrics, and the system generates personalized email reports—action-oriented scaling plans for top performers and troubleshooting guides for campaigns needing attention.

  The entire analysis takes minutes, providing your team with daily intelligence reports that would otherwise require hours of manual spreadsheet work and data analysis.

  Who is this for?

  PPC managers and paid media specialists drowning in campaign data and manual reporting
  Marketing agencies managing multiple client accounts needing automated performance monitoring
  E-commerce brands running high-spend campaigns who can't afford budget waste
  Growth teams looking to scale winners faster and pause losers immediately
  Anyone spending $5K+ monthly on Google Ads who needs data-driven optimization decisions

  Setup Steps

  Setup time:** Approx. 15-25 minutes (credential configuration, dashboard setup, alert customization)
  Requirements:**
      Google Ads account with active campaigns
      Google account with a tracking spreadsheet
      Slack workspace
      SMTP email provider (Gmail, SendGrid, etc.)

  Create a Google Sheets dashboard with two tabs: "Daily Performance" and "Campaign Log" with appropriate column headers.
  Set up these nodes:
      Schedule Daily Check: Pre-configured to run at 9 AM daily (adjust timing if needed).
      Fetch Google Ads Data: Connect your Google Ads account and authorize API access.
      AI Performance Analysis: Review scoring thresholds (CTR, conversion rate, cost benchmarks).
      Route by Performance: Automatically splits campaigns into high-performers vs. issues.
      Update Campaign Dashboard: Connect Google Sheets and select your "Daily Performance" tab.
      Log All Campaigns: Select your "Campaign Log" tab for historical tracking.
      Slack Alerts: Connect workspace and configure separate channels for scaling opportunities and performance issues.
      Generate Action Plan: Customize email templates with your brand voice and action items.
      Email Performance Report: Configure SMTP and set recipient email addresses.

  Credentials must be entered into their respective nodes for successful execution.

  Customization Guidance

  Scoring Weights:** Adjust point values for CTR (30), conversion rate (35), cost efficiency (25), and volume (10) in the AI Performance Analysis node based on your business priorities.
  Performance Thresholds:** Modify the 75-point Excellent threshold and 55-point Good threshold to match your campaign quality distribution and industry benchmarks.
  Benchmark Values:** Update CTR benchmarks (5% excellent, 3% good, 1.5% average) and conversion rate targets (10%, 5%, 2%) for your industry.
  Alert Channels:** Create separate Slack channels for different alert types or route critical alerts to Microsoft Teams, Discord, or SMS via Twilio.
  Email Recipients:** Configure different recipient lists for scaling alerts (executives, growth team) vs. optimization alerts (campaign managers).
  Schedule Frequency:** Change from daily to hourly monitoring for high-spend campaigns, or weekly for smaller accounts.
  Additional Platforms:** Duplicate the workflow structure for Facebook Ads, Microsoft Ads, or LinkedIn Ads with platform-specific nodes.
  Budget Controls:** Add nodes to automatically pause campaigns exceeding cost thresholds or adjust bids based on performance scores.

  Once configured, this workflow will continuously monitor your ad spend, identify opportunities worth thousands in additional revenue, and alert you to issues before they waste your budget—transforming manual reporting into automated intelligence.

  Built by Daniel Shashko  
  Connect on LinkedIn

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleAds","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.slack","n8n-nodes-base.code","n8n-nodes-base.emailSend","n8n-nodes-base.slack","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7764 characters]


name: Create a Personalized Daily Newsletter with Google Gemini AI and RSS Feeds
author_name: Dixit Ram
author_username: dixitram
categories: []
created_at: 2025-10-26T08:56:29.207Z
updated_at: 2025-10-26T08:56:29.207Z
url: https://n8n.io/workflows/10196
scraped_at: 2025-12-24 13:02:41
description:
  Who's it for

  This workflow is for anyone who wants to stay informed without the overwhelm. Whether you're tracking industry news, following your favorite blogs, monitoring competitors, or just keeping up with topics you care about—this automated newsletter keeps you in the loop effortlessly.

  What it does

  This automated workflow fetches content from your favorite RSS feeds, filters it based on your interests using Google Gemini AI, and sends you a beautifully formatted HTML newsletter at your preferred time. The AI selects the top 10-15 items from each category based on keywords you define, delivering only what matters to you.

  How it works

  Schedule Trigger: Runs daily at your chosen time (default: 9:00 AM)
  RSS Feeds: Fetches content from your favorite news sources and websites
  Processing: Splits URLs, loops through feeds in batches to avoid rate limits
  Merge & Convert: Combines all RSS items into a single CSV file
  AI Curation: Google Gemini analyzes the content and selects relevant items based on your keywords
  Email Delivery: Sends a personalized HTML newsletter with summaries and images

  Requirements

  Google Gemini API** credentials (for AI curation)
  SMTP credentials** (for sending emails)
  Active n8n instance (self-hosted or cloud)

  How to set up

  Add your Google Gemini API credentials in both Gemini nodes
  Configure your SMTP settings in the "Send email" node
  Update the email addresses (from and to) in the email node
  Add your favorite RSS feed URLs in the "Set" nodes
  Customize the AI keywords in "Analyze document" to match your interests
  Set your preferred schedule time in the trigger node

  How to customize

  Add your RSS feeds**: Replace the example URLs in both "Set" nodes with RSS feeds from your favorite sources (blogs, news sites, podcasts, YouTube channels, etc.)
  Define your interests**: Modify the keywords in the "Analyze document" AI prompt to filter content that matters to you
  Adjust categories**: Change the two sections to match your needs (e.g., "Industry News" and "Competitor Updates" or "Learning Resources" and "Tools")
  Change email format**: Update the HTML template in the AI prompt to customize the newsletter design
  Modify delivery time**: Update the schedule trigger to run at your preferred time

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.splitOut","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.splitInBatches","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.stickyNote","n8n-nodes-base.merge","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.googleGemini","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.emailSend","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6572 characters]


name: Discord Setup Guidelines 📜 - Get All Channels & Categories Of A Discord Server
author_name: EoCi - Mr.Eo
author_username: eocimreo
categories: []
created_at: 2025-10-26T13:58:02.452Z
updated_at: 2025-10-26T13:58:02.452Z
url: https://n8n.io/workflows/10198
scraped_at: 2025-12-24 13:02:43
description:
  🌟 Test Your n8n Discord Connection!
  Trying to connect n8n to your Discord server but not sure where to start? 🤔 Setting up a Discord Bot and its credentials can be confusing. This workflow provides the perfect starting point, guiding you through the connection and running a test to fetch all channels from your server, confirming everything works!

  🎯 What This Does
  This workflow is a "getting started" template designed to solve one primary problem: creating and verifying your first Discord connection in n8n.

  Its main benefit is demystifying the Discord Bot setup process. It proves your connection is successful by connecting to your server and fetching a complete list of all channels and categories. It's the perfect first step for any n8n user, community manager, or developer who wants to build Discord automations but needs a clear, working starting point.

  🔄 How It Works
  Manual Trigger: You start the workflow by clicking 'Execute workflow'.

  Set Server ID: A 'Set' node is pre-configured to hold your specific Discord Server ID.

  Get Channels List: The Discord node uses your credentials and the Server ID to connect to Discord and retrieve a list of all channels and categories on that server.

  Separate Channels & Categories: An 'IF' node automatically sorts the list, sending channels down one path and categories down another.

  Process & Merge: Two 'Set' nodes clean up the data from each path, and a 'Merge' node combines them back into one organized list.

  Next Step!: The workflow finishes at a 'NoOp' node. You can click the 'Merge' node to see the final output a full list of your server's channels.

  Nodes Used
  When clicking ‘Execute workflow’ (Manual Trigger)
  Set - Server ID (Set)
  Get channels list (Discord)
  Separate Category & Channel (IF)
  Get Channels (Set)
  Get Server's Categories (Set)
  Merge (Merge)
  Next Step ! (NoOp)

  Setup Requirements 📜
  Credentials: Discord Bot Token (created via the Discord Developer Portal).
  Accounts: A Discord account.
  Specifics:
  A Discord Server you own or have admin permissions for.
  Developer Mode enabled in your Discord client (to copy your Server ID).
  A Server ID from your server to test with.
  Estimated Setup Time: &lt; 10 minutes.
  Set up steps
  Part 1:** Create Your Discord Bot & Get Token
  	Go to the Discord Developer Portal: Navigate to discord.com/developers/applications and log in.
  	Create New Application: Click the New Application button in the top right. Give it a name (e.g., "n8n Bot") and click Create.
  	Access Your Bot: On the left-hand menu, click the Bot tab, then Add Bot.
  	Get Your Bot Token: Under the bot's username, find the Token section. Click Reset Token (and confirm) to reveal your bot's token.
  	Copy the Token: This is your secret credential. Copy this token and keep it safe.
  Part 2:** Invite Your Bot to Your Server
  Go to URL Generator: Back in the Discord Developer Portal, go to the OAuth2 tab and then URL Generator.
  	Select Scopes: In the Scopes box, check the bot checkbox.
  	Set Permissions: A new Bot Permissions box will appear. Check the View Channels permission. This is all that's needed for this workflow.
  	Copy Invite URL: Scroll down and copy the Generated URL.
  	Invite Bot: Paste this URL into a new browser tab. Select the server you want to add the bot to, click Continue, and then Authorize.
  Part 3:** Add Credentials to n8n
  	Open Credentials: In n8n, go to Credentials &gt; Create Credential.
  	Select Credential Type: Search for and select Discord Bot API.
  	Paste Your Token: Give your credential a 'Name' (e.g., "My Discord Bot"). Paste the Bot Token you copied from Part 1 into the Bot Token field.
  	Save: Click Save to store your new credentials.
  	Link Credential: Back in the workflow, click the Get channels list node. In the 'Credentials' parameter, select the credential you just created.
  Part 4:** Configure and Test the Workflow
  Enable Developer Mode: In your Discord desktop app, go to User Settings (the gear icon) &gt; App Settings &gt; Advanced and turn on Developer Mode.
  	Copy Server ID: Go to your Discord server, right-click on the server icon (on the left), and click Copy Server ID.
  	Configure n8n Node: Back in your n8n workflow, click the Set - Server ID node.
  	Paste Server ID: In the 'Value' field for server_id, replace the placeholder value with the Server ID you just copied.
  	Execute Workflow: Click Execute workflow in the top right corner.

  If it succeeds, all nodes will turn green. Click the Merge node and select the 'Output' tab to see a complete JSON list of all channels and categories from your server. Congratulations, you're connected!

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.discord","n8n-nodes-base.noOp","n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6892 characters]


name: Predict Customer Churn with AI Analysis of HubSpot and Google Sheets Data
author_name: PollupAI
author_username: Pollup
categories: []
created_at: 2025-10-26T14:06:09.510Z
updated_at: 2025-10-26T14:06:09.510Z
url: https://n8n.io/workflows/10199
scraped_at: 2025-12-24 13:02:41
description:
  Who it’s for
  Built for Customer Success and Account Management teams focused on proactive retention. This workflow helps you automatically identify at-risk customers – before they churn – by combining CRM, usage, and sentiment data into one actionable alert.

  What it does
  This end-to-end workflow continuously monitors customer health by consolidating data from HubSpot and Google Sheets.
  Here’s how it works:
  Fetch deals from HubSpot.
  Collect context — linked support tickets and feature usage from a Google Sheet.
  Run sentiment analysis on the tickets to generate a customer health score.
  Evaluate risk — an AI agent reviews deal age, sentiment score, and usage trends against predefined thresholds.
  Send alerts — if churn risk is detected, it automatically sends a clear, data-driven email to the responsible team member with next-step recommendations.

  How to set it up
  To get started, configure your credentials and parameters in the following nodes:

  Credentials:
      HubSpot: Connect your account (HubSpot: Get All Deals).
      LLM Model: Add credentials for your preferred provider (Config: Set LLM for Agent & Chains).
      Google Sheets: Connect your account (Tool: Get Feature Usage from Sheets).
      Email: Set up your SMTP credentials (Email: Send Churn Alert).
  Tool URLs:
      In Tool: Calculate Sentiment Score, enter the Webhook URL from the Trigger: Receive Tickets for Scoring node within this same workflow.
      In Tool: Get HubSpot Data, enter the Endpoint URL for your MCP HubSpot data workflow. (Note: This tool *does call an external workflow)*.
  Google Sheet:
      In Tool: Get Feature Usage from Sheets, enter the Document ID for your own Google Sheet.
  Email Details:
      In Email: Send Churn Alert, change the From and To email addresses.

  Requirements
  HubSpot account with Deals API access
  LLM provider account (e.g. OpenAI)
  Google Sheets tracking customer feature usage
  n8n with LangChain community nodes enabled
  A separate n8n workflow set up to act as an MCP endpoint for fetching HubSpot data (called by Tool: Get HubSpot Data).

  How to customize it
  Tailor this workflow to match your business logic:
  Scoring logic:** Adjust the JavaScript in the Code: Convert Sentiment to Score node to redefine how customer scores are calculated.
  Alert thresholds:** Update the prompt in the AI Chain: Analyze for Churn Risk node to fine-tune when alerts trigger (e.g. deal age, score cutoff, or usage drop).
  Data sources:** Swap HubSpot or Google Sheets for your CRM or database of choice — like Salesforce or Airtable.

  ✅ Outcome: A proactive customer health monitoring system that surfaces risks before it’s too late — keeping your team focused on prevention, not firefighting.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.hubspot","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.webhook","n8n-nodes-base.code","n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.sentimentAnalysis","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.respondToWebhook","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.mcpClientTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.googleSheetsTool","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.markdown","n8n-nodes-base.emailSend"]

workflow_json_compressed:
  [encoded data, 7680 characters]


name: Generate Funny AI Videos with Sora 2 and Auto-Publish to TikTok
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-10-27T09:50:39.013Z
updated_at: 2025-10-27T09:50:39.013Z
url: https://n8n.io/workflows/10212
scraped_at: 2025-12-24 13:02:41
description:
  This automation creates a fully integrated pipeline to generate AI-powered videos, store them, and publish them on TikTok — all automatically.
  It connects OpenAI Sora 2, and Postiz (for TikTok publishing) to streamline content creation.

  Key Benefits

  ✅ Full Automation – From text prompt to TikTok upload, everything happens automatically with no manual intervention once set up.
  ✅ Centralized Control – Google Sheets acts as a simple dashboard to manage prompts, durations, and generated results.
  ✅ AI-Powered Creativity – Uses OpenAI Sora 2 for realistic video generation and GPT-5 for optimized titles.
  ✅ Social Media Integration – Seamlessly posts videos to TikTok via Postiz, ready for your audience.
  ✅ Scalable & Customizable – Can easily be extended to other platforms like YouTube, Instagram, or LinkedIn.
  ✅ Time-Saving – Eliminates repetitive steps like manual video uploads or caption writing.

  How it works

  This workflow automates the end-to-end process of generating AI videos and publishing them to TikTok. It is triggered either manually or on a recurring schedule.

  Trigger & Data Fetch: The workflow starts by checking a specified Form for new entries. It looks for rows where a video has been requested (a "PROMPT" is filled) but not yet generated (the "VIDEO" column is empty).

  AI Video Generation: For each new prompt found, the workflow sends a request to the Fal.ai Sora 2 model to generate a video. It then enters a polling loop, repeatedly checking the status of the generation request every 60 seconds until the video is "COMPLETED".

  Post-Processing & Upload: Once the video is ready, the workflow performs several actions in parallel:
      Fetch Video & Store: It retrieves the final video URL, downloads the video file
      Generate Title: It uses the OpenAI GPT-4o-mini model to analyze the original prompt and generate an optimized, engaging title for the video.
      Publish to TikTok: The video file is uploaded to Postiz, a social media scheduling tool, which then automatically publishes it to a connected TikTok channel, using the AI-generated title as the post's caption.

  Set up steps

  To make this workflow functional, you need to complete the following configuration steps:

  Prepare the Google Sheet:
      Create a Form with at least "PROMPT", "DURATION", and "VIDEO" fields.

  Configure Fal.ai for Video Generation:
      Create an account at Fal.ai and obtain your API key.
      In both the "Create Video" and "Get status" HTTP Request nodes, set up the "Header Auth" credential.
      Set the Name to Authorization and the Value to Key YOUR_API_KEY.

  Set up TikTok Publishing via Postiz:
      Create an account on Postiz and connect your TikTok account to get a Channel ID.
      Obtain your Postiz API key.
      In the "Upload Video to Postiz" and "TikTok" (Postiz) nodes, configure the API credentials.
      In the "TikTok" node, replace the placeholder "XXX" in the integrationId field with your actual TikTok Channel ID from Postiz.

  (Optional) Configure AI Title Generation:
      The "Generate title" node uses OpenAI. Ensure you have valid OpenAI API credentials configured in n8n for this node to work.

  Need help customizing?  
  Contact me for consulting and support or add me on Linkedin. 
  Header 2

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-postiz.postiz","n8n-nodes-base.httpRequest","n8n-nodes-base.formTrigger"]

workflow_json_compressed:
  [encoded data, 4516 characters]


name: Add Project Tasks to Google Sheets with GPT-4.1-mini Chat Assistant
author_name: Robert Breen
author_username: rbreen
categories: []
created_at: 2025-10-27T23:06:52.236Z
updated_at: 2025-10-27T23:06:52.236Z
url: https://n8n.io/workflows/10230
scraped_at: 2025-12-24 13:02:41
description:
  Let your team create, track, and manage project tasks through natural conversation.  
  This workflow uses an AI Project Manager Agent that chats with users, gathers the task details it needs, and automatically adds them to a Google Sheet.

  ✅ What this template does
  Lets you chat naturally with an AI to add new project tasks  
  Automatically detects if the user wants to create or update an item (updates coming soon)  
  Collects Task, Description, and Status fields — allows “don’t know” responses  
  Appends new entries directly into your connected Google Sheets  
  Provides real-time confirmation when the task is added  

  &gt; Trigger: n8n Chat Trigger  
  &gt; Integrations: OpenAI GPT-4.1-mini + Google Sheets (OAuth2)

  🧠 How it works
  The Chat Trigger starts a chat with the user.  
  The AI Project Manager Agent asks guiding questions to gather the task name, description, and status.  
  When all fields are complete (all Info = Yes), the data is passed to the Google Sheets node.  
  The task is automatically added to your project tracker sheet.  
  The AI confirms completion in chat.

  ⚙️ Setup instructions

  1. Connect OpenAI
  Go to OpenAI Platform → copy your API key.  
  In n8n, create New Credentials → OpenAI API and paste your key.  
  Ensure your account has active billing under OpenAI Billing.

  2. Connect Google Sheets (OAuth2)
  In n8n → Credentials → New → Google Sheets (OAuth2)  
  Sign in with your Google account and grant access.  
  Select your spreadsheet and tab (e.g., “Tasks”) when prompted.  
     Example sheet: https://docs.google.com/spreadsheets/d/1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84/edit

  3. Test your chat
  Click Execute Workflow, then start chatting:  
  &gt; “Add a task for reviewing the project report tomorrow.”  
  The agent will ask questions if needed, then add the record to your sheet.

  🧩 Customization ideas
  Add a Date Added or Assigned To column to the Google Sheet  
  Integrate with Slack or Outlook to message assigned users  
  Extend the agent to support task updates and deletes  
  Replace Google Sheets with Airtable or Notion if preferred  

  🪄 Requirements
  n8n version ≥ 1.100  
  OpenAI API key  
  Google Sheets account  

  📬 Contact  
  Need help customizing this (e.g., adding deadlines, linking to Notion, or Slack notifications)?  

  📧 robert@ynteractive.com  
  🔗 Robert Breen  
  🌐 ynteractive.com  

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.chat","n8n-nodes-base.if","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chat"]

workflow_json_compressed:
  [encoded data, 4784 characters]


name: Send Rapiwa WhatsApp Apology & Reorder Link When Shopify Order is Cancelled
author_name: Rapiwa
author_username: rapiwa
categories: []
created_at: 2025-10-28T05:08:54.996Z
updated_at: 2025-10-28T05:08:54.996Z
url: https://n8n.io/workflows/10237
scraped_at: 2025-12-24 13:02:46
description:
  Who Is This For?
  This n8n workflow listens for order cancellations in Shopify, extracts relevant customer and order data, checks if the customer’s phone number is registered on WhatsApp via the Rapiwa API, and sends a personalised apology message with a re-order link. It also logs successful and unsuccessful attempts in Google Sheets for tracking.

  What This Workflow Does
  Listens for cancelled orders in your Shopify store  
  Extracts customer details and order information  
  Generates a personalised apology message including a reorder link  
  Sends the message to customers via WhatsApp using a messaging API (e.g., Twilio or Rapiwa)  
  Logs the communication results for tracking purposes  

  Key Features
  Real-Time Cancellation Detection:** Automatically triggers when an order is cancelled  
  Personalised Messaging:** Includes customer name, order details, and a direct reorder link  
  WhatsApp Integration:** Sends messages via WhatsApp for higher engagement  
  Error Handling:** Logs successful and failed message deliveries  
  Reorder Link:** Provides a convenient link for customers to reorder with one click  

  Requirements
  n8n instance with nodes: Shopify Trigger, HTTP Request (for WhatsApp API), Code, Google Sheets (optional)  
  Shopify store with API access  
  WhatsApp messaging provider account with API access  
  Valid customer phone numbers stored in Shopify orders  

  How to Use — Step-by-Step Setup
  Credentials Setup  
     Shopify API: Configure Shopify API credentials in n8n to listen for order cancellations  
     WhatsApp API: Set up WhatsApp messaging credentials (e.g., Twilio, Rapiwa, or any supported provider)  
     Google Sheets (Optional): Configure Google Sheets OAuth2 if you want to log communications  

  Configure Trigger  
     Set the workflow to trigger on Shopify order cancellation events  

  Customize Message Content  
     Modify the apology message template to include your store branding and tone  
     Ensure the reorder link dynamically includes the customer's cancelled order info  

  Set Up WhatsApp Node  
     Connect your WhatsApp API credentials  
     Ensure the phone numbers are formatted correctly for WhatsApp delivery  

  Google Sheet Required Columns
  You’ll need two Google Sheets (or two tabs in one spreadsheet):
  A Google Sheet formatted like this ➤ sample
  The workflow uses a Google Sheet with the following columns to track coupon distribution:

  | Name       | Number    | Email  | Address       | Price   | Title      | Re-order Link        | Validity | Status |
  | -------------- | ------------- | --------------------------------------------------- | ----------------- | ----------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ | ---------- |
  | Abdul Mannan         | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | unverified   | not sent   |
  | Abdul Mannan         | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | verified     | sent       |

  Important Notes
  Phone Number Validation:** Ensure customer phone numbers are WhatsApp-enabled and formatted properly  
  API Rate Limits:** Respect your WhatsApp provider’s API limits to avoid throttling  
  Data Privacy:** Always comply with privacy laws when messaging customers  
  Error Handling:** Monitor logs regularly to handle failed message deliveries  
  Testing:** Test thoroughly with dummy data before activating the workflow live  

  Useful Links
  Dashboard:** https://app.rapiwa.com
  Official Website:** https://rapiwa.com
  Documentation:** https://docs.rapiwa.com

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.shopifyTrigger","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-rapiwa.rapiwa","n8n-nodes-rapiwa.rapiwa"]

workflow_json_compressed:
  [encoded data, 7116 characters]


name: Automate Job Searching & Resume Customization with AI, LinkedIn & Google Sheets
author_name: Jordan Hoyle
author_username: jordanhoyle
categories: []
created_at: 2025-10-28T18:42:23.524Z
updated_at: 2025-10-28T18:42:23.524Z
url: https://n8n.io/workflows/10256
scraped_at: 2025-12-24 13:02:42
description:
  🤖 AI-Powered Job Matcher & Resume Customizer

  Description

  This advanced workflow automates the entire job search and preparation process, moving beyond simple notifications to provide AI-driven career intelligence.

  It connects to LinkedIn to scrape fresh job postings, filters against jobs you've already seen, and then uses powerful LLMs (Mistral Large/Small) to perform a detailed resume-to-job match, generate tailored cover letters, and provide concrete resume improvement suggestions. All data is logged into a Google Sheet for comprehensive tracking, and a clean, single Daily Digest Email summarizes the top 5 matches found each day.

  ✨ Key Features

  Automated Scheduling:** Runs daily to find new job postings.
  Multi-Keyword Search:** Uses your main job title and three alternate titles generated by an AI Agent for maximum search coverage.
  LinkedIn Web Scraping:** Pulls new job URLs, details, location, and salary data from LinkedIn Search results.
  Duplicate Prevention:* Uses the *Compare Datasets** node to ensure only new, unseen jobs are processed against your master Google Sheet.
  Intelligent Matching (LLM):** The workflow performs a detailed job-to-resume comparison, generating:
      A Match Score (0-100) with evidence for alignment in skills, experience, and domain.
      A Tailored Cover Letter specific to the job title and company.
      Actionable Resume Improvement points (e.g., [ADD], [QUANTIFY]) to optimize your resume for the specific role.
  Centralized Tracking:* Saves all job data, match scores, cover letters, and resume suggestions to a *Google Sheet**.
  Professional Daily Digest:* Sends a single, clean *HTML email** summarizing the top 5 highest-scoring job matches for easy review.

  🛠️ Prerequisites

  n8n Credentials:
      Google Drive: To download your resume (PDF/DOCX file URL).
      Google Sheets: To connect to your job tracking sheet.
      Gmail: To send the daily digest email.
      Mistral Cloud: For the LLM processing (Resume Breakdown, Job Matching, and Resume Analysis).
  External Files:
      A Job Tracking Google Sheet (used as a master database).
      Your current Resume file (PDF recommended, hosted on Google Drive).
  Setup Notes:
      Update the file links (Download Resume node) and Google Sheet details (Get row(s)/Append nodes).
      Set your personal email address in the Send Digest Email node.
      Review the LLM prompts to tailor the AI agent's persona and output fields to your exact needs.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatMistralCloud","n8n-nodes-base.html","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.lmChatMistralCloud","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.extractFromFile","n8n-nodes-base.googleDrive","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.compareDatasets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.sort","n8n-nodes-base.limit","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61aa48TyxH9KyN/SiT3pt8PPoVHyCWCyxWQ5MMVivpRvevgtTf2+AJC+99TbS941u4Zj5eVABm7p/t0ddWpU9XzbXINrZ88+TaZLdatX0R4lSZPJsGG6Dm1LOgonIxcepDBMnDe66SZSEq6yI3SUjsRmFWKRq5FiCHQSMVkOmnh+mbuW3i+grR+D+3m5vkSv4EWcIF2tYHb6WSxTLCePPkdVy+rArXSiBAIDUYRGSEQyyIljgcwjGmVg8SZF/4acPSb2bpd+XnzfL7cpOb5lW+bNzjfvKz99aaM+OvCLv6Cf8l2HTL3i8t45WeLi/l1GX43wfZ5fOhmuZ61s+UC8RDmtJ1yKu1H/N6vcMEWVoj02+1u8n/h/7ZD2e30Drw2TGcJnnDFHZFaKxJS9sQ6KbyNSeUc9+B/+fDmNd8j3YMMfg0XV+31/BARVXrKhT6N6IL/wEQZ0CABbRlkIpJRTqzXhni0qg+OGmb8HtP7m/msbd5u2l5c6zJiN6CLzVo6ZY7T8cYynEnPXSBZJk6k0p54Y4Aw5YQVmnnNYA/s9XJ507z9A1bNK/Sq9TC8V4tnvo1XsD4AKSnFE7U1kPAF4qaFt+j9O9c8wC1+4OZSJq1dJIEXDzURiE9gSchCpKSMZll1DAqL1PjmGtZrfwm9sC+v/ezguBUv7kcL2M8QrpbLT9uw5B6dCzAieBCaoAXRbAoP1fmUFajojCpONXgI/GJ/DMC80AHDjFuP/kGjJkEJif+NDqz0KriOz75H08R2g/FcnORm0za/+dUaViMCbrkdvxu+n+bQxS2X44LuYn8iTgiJJJGJoswSadGnrDYYgCL7rCNnxrEOZ8Bq4CCu7369B4pLO2XWngQlOnHnOCRPPUdQGUEJ9BAndSCKU/T7ZBxAOE1k8nGYjE+55vIMIlNBeB4TScYGIrOUxIXECENPsYaGLEXHou9gvbmG5tkK/Ke0/LxgI0BjMCwOOWTLuMzKkyTCO3Y2nlJjkyFWaYwHrSLx4BTR3BqIQvHoxR7qP5aheVO4Yba4bJ6+ap4WGA/Hi3ZFPjkHrjY6KS0EcUagh0Yr0VcpohfaSRYkZ5ofWfbpws+/rmfrx0EsmT4HscqG0+AViREdQkpuiXfSomvIFBLl4EIngfwd2ma1/Pyn9Z+b2aIp5n4PfhWvWD/1LZeXc3h/BdAe8jUmKzllytY89xRhywuzN3piShmeiIIgiHTKkWA9kJSpi9JInbjZb+HpzU0h7eWq2dwkVC9lPz+/GcbGmb6LO2PqjoobAsZgiozOEVe83EOWEZNOjqqTav72BQkgtk1eLa+bnef0A4Xd4Jc49uVsfsh4vKAdE4l7ylCGpcRZJFoojzrDId9RJogw2lCrXIiZ7rG+QJqYL306iXNn0Ber2R9HrGwN73OOntTtKJWoXzVxmTL0A4NJHLwgLNoYWJIxs9TJdagg0mYOzYfV7PISVv0g13cj7wYeGpOW9DECaFe2IY+VXO6IDcYUlaEKwQWiUbwlC1xy2qG1Iqv9CpoXvkU87bofatyN/D7wAKreZl86goD3RvWWZm0yUlhKgDoOPwXPGCn0gP5uUdN1+OH1bPEJ0qvFXSQ1/3z3egBrOjp0zfSUaXeawX7gQynJFaoADP5y6AxzQ4gomCImDVS/3gmlB/Gp8wGOyWE/AEols/eWEwAUCeUzCQ4cidoKLhXPIQ4D1OcDdKe9cQ8wMOoSg4Tpg6EaSDph9eAxe1GfsBDUNqswCNCcDZAzfjqtdjQsk7ZogGTxnKXjknjqOAnapOAU6gDolBIvAfN/899lWO+o8jvggVKsvXkH/9vA+iifSkn73HEF7err28XLIuzrCYqjsvez9hm0nwEWSB6lEBYYfvsEIEFQbwIGE5pf8mJ5IyJxgOTvKH45ZmPiwTur+/Fj7AylcabRoMLUpTY1AWUb1vgkRUzMXBihu6VyfWezhx9Z3f8fY2MsWO01MMzZEoMFSzL0RdTPhmJJi/IOmVycPrJ+zjmxs57AeZSdgZTOBiDaWIo0kCyxnLvCCtoLhsFm3H5n/8bJ+tNQWara3UCFelDwslJXM4qpD9kaqztaqjuF/wgsTYU3Vm6T9onMuhcqMVCP+UmQzCBiTGHVG2jCKjpHKlw0wXfF4C8fPvzW3Nm7fzv9h1L6InebeqQzUfudaJY5k44IUToRsvTKEsc9+ZAjxEJ7fnKv3TTEBPV2U09P5xT2rpQJXnjQCdW34ghTgybW50S0zMJQj/LQdEL9oNHTj3iw08O4QLmNETFeHEZNo2fBkwgGiwSjHXJtyXfacORbCpiPO2I7zdrm5Qzmad3fw0OFVXOHER08cSH3UpCb6LL1hGaHh6usIIGpTHQOSYvsnQNWBTZgu0NgTo+qZLuwXNACVwZiAXLptQTipcIcHJKKKUC2utOpvV8XrkuB9LCSsFSwIxRqt4xiWWoZlMAKNpdOI0a8dY4SHS1F8uIRQrfFtVwNQFvjr0eCZRQi1iFSShWmAiTSwkDopehpVBFUMU5KpDThc1dPXQ8x6bz8fFBqanomIqzipUD3x6I+YYhiBsYaE0tO56IqjVjhul2Jp5eXK7jEyrgflf8+5D4yIc61FaeYNVkURGFEEok+R6xRQIT0qI0VavtuJ+p9O4ufvja/LhHbwBluR5VBte4jk8edsklcLtrSTnkymfRjjTq6FFG5i1i6j05izcY41kSgsPr1iUlh6lgHKKQXK6X2J7BaVJZYSUos9T3a1ViGMaEZUSIyzSE4amUd6wCr9GDl1k65FEc5cBxSECiBS5XOE4YMRrIhXjuESw2WwT5nyWwdqTwbqSptD2OO5Pw4pFwyA4BHLwCdQCZkax8xuDPWT4wFrrFKqSPtl3u95196ClgBPAypy0bK0nbUqHbQU73FkgIkSkh00phzsD7WkfbXmr1IeQmqiuAeB1XblLmXqDWTYqW9UD6V2g59gmXHbbI9Ru2vOvuDShez6oe6KqZpgcZkBKMdzWptIXaUljKJmAyKMsd9Hat9IFaUOUdkOg4reoArHWcitlclGQSyPcpImpHxORM29xGrOx+rLkqy0gEbB5UmS0W53wkJaUCCoUWZGeJCVFoLCY7VvZXTB3jrtoh6KAUwLI1Q1zLMT7lIR12a5dwTHnjyqIyw3IA61PPTFeLUx/X5ME4cjb8vIJY5tsN3t9D44drPyqy/f9teyfdK3O2w6WS2SPBl8oTefvyIq+xqi9oklQvl6gy7W7naDAd1S/XpnWarPX2onqqP72rV+uLV8q86y91StWlqiqm+kR/mqm6mtzaqTtZZtXo0PVfT1bnuOcMjYLtXptTmG3H11eOK3RPrc6hTDn34ukFtnuGS5mja6f7JU7eQVUhHVybVmB28Axqz1fppDFww3J+U3dvoQROouv7x1B0AONnuT5+fnZj8+Gq6ThJDLevDiadDzz3wMfXA5/QpPjm6w6rtv/82rh/MiIveHpY8tlkN0+kufZ1XagEwwC+1lxaqE1ejvUqr9/sHY42gzrLCKXqtusr4BWanzFyNmHM2MODw2wV6KPKETjllll6nqs178KLQGRPOHjAhv9NBfW804oR+9p/yescGs/Xdd+P8+ei5I5boe6trt2j3za0z1rz32NiTqKefQcux4RnrgTU4o6iFfJfifipF0uGTlmOPekgaDR35dLQOOek4/UiqKvicF2vqinbEDCPE6eAqt7f/Bz6yyqIRLQAA


name: Google Calendar Events with Gemini AI Follow-up Suggestions via WhatsApp & Email
author_name: Rapiwa
author_username: rapiwa
categories: []
created_at: 2025-10-29T11:58:04.970Z
updated_at: 2025-10-29T11:58:04.970Z
url: https://n8n.io/workflows/10270
scraped_at: 2025-12-24 13:02:44
description:
  Who Is This For?
  This n8n automation workflow is designed for sales teams, client managers, consultants, or anyone who regularly schedules and follows up on meetings — and wants to save time doing it.
  If you often find yourself juggling between Google Sheets, Google Calendar, email, and WhatsApp just to manage your meetings, confirmations, and follow-ups — this workflow is for you.

  What This Workflow Does
  This workflow is structured into two main, independently scheduled branches:
  1. Create Event (Schedule Meetings)
  Trigger:** Starts automatically on a schedule (e.g., every minute).
  Data Source:* Fetches new meeting data from a *Google Sheet**.
  Event Creation:* Creates a new event in *Google Calendar** using the data.
  Confirmation:* Sends a confirmation message via *WhatsApp (Rapiwa)* and *Email (Gmail)**.
  Status Update:* Updates the source *Google Sheet** to mark the meeting as 'sent'.

  2. Reminder Event (Schedule Follow-ups)
  Trigger:** Starts automatically on a schedule (e.g., every minute).
  Past Events:* Retrieves recent past events from *Google Calendar**.
  Deduplication:** Uses a "Mark as Seen" node to prevent processing the same event multiple times.
  Filtering:** Filters for specific events that require a follow-up ("Only Follow Ups" node).
  AI Follow-up:* An *AI Meeting Agent (using Gemini/LLM)* uses the details of the past meeting and the Calendar's *Availability** tool to find and suggest open slots for a future meeting.
  Communication:* Sends a message with the suggested slots via *WhatsApp (Rapiwa)* and *Email (Gmail)**.

  Key Features
  Scheduled Automation:** Both event creation and follow-up scheduling run on a recurring schedule.
  Data Synchronization:* Reads meeting details from and updates a *Google Sheet**.
  Google Calendar Integration:** Creates events and checks calendar availability.
  Multi-Channel Communication:* Sends confirmations/follow-ups via *WhatsApp (Rapiwa)* and *Email (Gmail)**.
  AI-Powered Follow-up:* Uses an *AI Agent (Gemini)** to intelligently find and format available slots for the next meeting, considering the details of the past meeting (day, time, duration).
  Idempotency:** The "Mark as Seen" node prevents duplicate follow-up attempts for the same event.

  Requirements
  n8n instance with nodes: Schedule Trigger, Google Sheets, Split In Batches, Date & Time, Code, Google Calendar, Rapiwa, Gmail, Filter, Agent (LangChain), LLM Chat (Google Gemini), Structured Output Parser (LangChain), Set, Remove Duplicates, Wait.
  Google Calendar** with an available calendar for event creation and availability checks.
  Google Sheets** for storing meeting details.
  Rapiwa** (WhatsApp API) account credentials.
  Gmail** account credentials.
  Google Gemini (PaLM) API** credentials for the AI agent.

  How to Use — Step-by-Step Setup
  Credentials Setup
      Google Sheets OAuth2: Configure to allow the workflow to read from and write to your Sheet.
      Google Calendar OAuth2: Configure to allow event creation and availability checks.
      Rapiwa API: Set up credentials for sending WhatsApp messages.
      Gmail OAuth2: Set up credentials for sending email confirmations/follow-ups.
      Google Gemini(PaLM) API: Set up credentials for the AI agent functionality.

  Configure "Create Event" Branch
      Get in sheet: Update the Document ID and Sheet Name to point to your meeting data spreadsheet. The node is set to filter by a status column.
      Create an event: Verify the correct Calendar ID is selected. The end time is dynamically generated by the previous Code node.
      Rapiwa / Send a message1: Update the recipient number/email address and customize the message templates.
      Update status in sheet: Ensure the correct Document ID, Sheet Name, and matching column (row\_number) are configured to update the status to "sent".

  Configure "Reminder Event" Branch
      Get Past Events: Verify the correct Calendar ID is selected.
      Only Follow Ups: Customize the filter condition if only a subset of past meetings needs follow-up (e.g., if you have a "Follow-up Status" column to check).
      Meeting Agent: Review the System Message to ensure the AI's logic for finding slots matches your business rules (e.g., preferred working hours, look-ahead period).
      Generate Message: Customize the message template, which formats the AI-suggested slots.
      Rapiwa1 / Send a message: Update the recipient number/email address for the follow-up messages.

  Google Sheet Required Columns
  The workflow expects a Google Sheet with meeting data to have at least the following columns:
  A Google Sheet formatted like this ➤ Sample Sheet

  | title                                   | description                                                                                                                                                                                                                                                  | location          | color_number | start time         | end time           | reminder status | status  |
  | :-------------------------------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :---------------- | :----------- | :----------------- | :----------------- | :-------------- | :------ |
  | 2025 Personal Planner & Events Calendar | Stay organized and never miss an important date! This calendar helps........ | Dhaka, Bangladesh | 4            | 10/28/2025 3:50:00 | 10/29/2025 5:30:00 | sent            | checked |
  | 2026 Personal Planner & Events Calendar | Stay organized and never miss an important date! This calendar helps........ | Dhaka, Bangladesh | 2            | 10/29/2025 3:50:00 | 10/30/2025 5:30:00 | sent            | checked |

  Useful Links
  Dashboard:** https://app.rapiwa.com
  Official Website:** https://rapiwa.com
  Documentation:** https://docs.rapiwa.com

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.splitInBatches","n8n-nodes-base.googleCalendar","n8n-nodes-base.dateTime","n8n-nodes-base.code","n8n-nodes-base.googleCalendar","n8n-nodes-base.removeDuplicates","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.set","n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-rapiwa.rapiwa","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi"]

workflow_json_compressed:
  [encoded data, 10748 characters]


name: Synchronize Events & Attendees Between KlickTipp and Google Calendar
author_name: KlickTipp
author_username: KlickTipp
categories: []
created_at: 2025-10-29T18:44:31.766Z
updated_at: 2025-10-29T18:44:31.766Z
url: https://n8n.io/workflows/10295
scraped_at: 2025-12-24 13:02:46
description:
  Community Node Disclaimer: This workflow uses KlickTipp community nodes.

  Introduction
  This workflow creates a complete two-way synchronization between KlickTipp and Google Calendar.  
  When a contact in KlickTipp is tagged, an event is automatically created in Google Calendar.  
  If event status changes or if attendees respond, their RSVP status and event status are reflected in KlickTipp — keeping your contact database, campaigns, and event insights always up to date.

  Perfect for marketers, coaches, or event organizers who want to automatically send event invites and instantly capture participation status without manual updates.

  How it works
  Google Calendar → KlickTipp:
  This template keeps your KlickTipp list in sync with Google Calendar across the full event lifecycle.  
  For every incoming event, the workflow follows these steps:

  Watch Google Calendar events
     Listens for:
       Event Created
       Event Updated
       Event Cancelled

  Iterate through attendees
     Each attendee is handled as a separate item.
     This ensures accurate contact updates and tagging even for large events or webinars.

  Filter attendees (optional)
     Attendees from internal or excluded email domains can be filtered out before any processing.

  Check if the attendee already exists in KlickTipp
     If the contact exists → update the contact.
     If the contact does not exist → subscribe the contact (with Single or Double Opt-In, depending on action).

  Transfer event data to KlickTipp
     Event details (summary, description, location, start and end time) are written into KlickTipp custom fields.
     Contacts always reflect the most recent event information.

  Route by attendee response status
     Attendees are routed based on their responseStatus:
       needsAction → contact was added to an event
       accepted → event confirmed
       declined → event declined
       tentative → event considered

  Apply tags in KlickTipp
     Based on event type and attendee status, the workflow applies the corresponding tags:
       Event created / updated
       Event canceled
       Event confirmed
       Event declined
       Event considered

  KlickTipp → Google Calendar:
  Watches for a tag like “Send an event invitation via Google Calendar”.
  Creates an event in Google Calendar using mapped KlickTipp fields.

  Setup Instructions
  KlickTipp Preparation
        Prepare custom fields
         Google Calendar | event summary, data type: "Single line"
         Google Calendar | event description, data type: "Single line"
         Google Calendar | event location, data type: "Single line"
         Google Calendar | event start datetime, data type: "Datetime"
         Google Calendar | event end datetime, data type: "Datetime" 
        Prepare tags:
         Google Calendar | event created/updated
         Google Calendar | event canceled
         Google Calendar | event declined
         Google Calendar | event confirmed  
         Google Calendar | event considered 
         Send an event invitation via Google Calendar
        Prepare outbound:
         Activation tag: Send an event invitation via Google Calendar
         Activation URL: webhook URL from trigger

  Credential Configuration
       Connect your Google Calendar account using Client ID and Client Secret from the Google Cloud.
       Authenticate your KlickTipp connection with username/password credentials (API access required).

  Customization
  Recommended poll frequency: every 1–5 minutes for near real-time updates.
  Adjust to your local timezone if necessary.  
  Each trigger works independently, allowing partial deployments if only certain event types are needed.  
  Ensure End &gt; Start in your data. If you prefer a fixed duration, compute End from Start + minutes in a Date & Time node.  
  If you want a Meet link, enable “Add Google Meet video conferencing” in the Calendar node instead of pasting a Calendar URL into Location.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-klicktipp.klicktipp","n8n-nodes-base.stickyNote","n8n-nodes-base.googleCalendarTrigger","n8n-nodes-base.googleCalendarTrigger","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-base.splitOut","n8n-nodes-base.switch","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.googleCalendarTrigger","n8n-nodes-klicktipp.klicktippTrigger","n8n-nodes-base.googleCalendar","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-base.stickyNote","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-klicktipp.klicktipp","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7192 characters]


name: Auto-Rename Workflow Nodes with AI (Gemini/Claude) for Better Readability (beta)
author_name: Dr. Christoph Schorsch
author_username: upfastai
categories: []
created_at: 2025-10-30T09:35:45.850Z
updated_at: 2025-10-30T09:35:45.850Z
url: https://n8n.io/workflows/10317
scraped_at: 2025-12-24 13:02:46
description:
  Rename Workflow Nodes with AI for Clarity

  This workflow automates the tedious process of renaming nodes in your n8n workflows. Instead of manually editing each node, it uses an AI language model to analyze its function and assign a concise, descriptive new name. This ensures your workflows are clean, readable, and easy to maintain.

  Who's it for?

  This template is perfect for n8n developers and power users who build complex workflows. If you often find yourself struggling to understand the purpose of different nodes at a glance or spend too much time manually renaming them for documentation, this tool will save you significant time and effort.

  How it works / What it does

  The workflow operates in a simple, automated sequence:

  Configure Suffix: A "Set" node at the beginning allows you to easily define the suffix that will be appended to the new workflow's name (e.g., "- new node names").
  Fetch Workflow: It then fetches the JSON data of a specified n8n workflow using its ID.
  AI-Powered Renaming: The workflow's JSON is sent to an AI model (like Google Gemini or Anthropic Claude), which has been prompted to act as an n8n expert. The AI analyzes the type and parameters of each node to understand its function.
  Generate New Names: Based on this analysis, the AI proposes new, meaningful names and returns them in a structured JSON format.
  Update and Recreate: A Code Node processes these suggestions, updates all node names, and correctly rebuilds the connections and expressions.
  Create & Activate New Workflow: Finally, it creates a new workflow with the updated name, deactivates the original to avoid confusion, and activates the new version.

nodes_used:
  ["n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.n8n","n8n-nodes-base.n8n","n8n-nodes-base.n8n","n8n-nodes-base.n8n","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.stickyNote","n8n-nodes-base.set"]

workflow_json_compressed:
  [encoded data, 5040 characters]


name: AI-Powered Facebook Comment Management: Auto-Reply, Delete, Ban & Notify
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-10-30T10:04:12.646Z
updated_at: 2025-10-30T10:04:12.646Z
url: https://n8n.io/workflows/10320
scraped_at: 2025-12-24 13:02:45
description:
  Who is this for?
  This n8n workflow is designed for Facebook Page administrators, social media managers, and community moderators who want to automate comment management on their Facebook Pages. It's perfect for businesses with high comment volume, content creators, and marketing teams who need to maintain a positive community environment without manually reviewing every comment. The workflow automatically filters and responds to positive/supportive comments while handling negative ones appropriately.

  What this Workflow Does
  This n8n workflow monitors Facebook Page comments, classifies them using  OpenAI, automatically responds to positive and supportive comments, and handles negative comments by deleting them and tracking repeat offenders. It can ban users who repeatedly post negative content and maintains a record of all interactions in Google Sheets.

  Key Features
  Automated Comment Monitoring**: Fetches posts and comments from a Facebook Page
  AI-Powered Classification**: Uses OpenAI to classify comments into positive, supportive, or negative categories
  Intelligent Response Generation**: Creates human-like replies in the same language as the original comment (English or Bangla)
  Negative Comment Management**: Deletes negative comments and tracks them in Google Sheets
  User Banning System**: Automatically bans users who repeatedly post negative content
  Admin Reply Detection**: Only processes comments that haven't already received admin replies
  Comprehensive Logging**: Records all comment interactions in Google Sheets for analysis

  Requirements
  Facebook Page access with Graph API credentials
  OpenAI API credentials for comment classification
  Google Sheets account for logging comment data
  n8n instance (self-hosted or cloud)
  Facebook Page ID (configured as 47104xxxxx69097 in the workflow)

  Google Sheet Column Structure
  A Google Sheet formatted like this** ➤ sample

  Workflow Components
  1. Post Retrieval Section
  Start**: Manual trigger to begin the workflow
  Get 0-100 Posts from Page**: Fetches up to 100 recent posts
  Split All Posts**: Breaks each post into individual items
  Loop Over Posts**: Iterates through each post for further processing

  2. Comment Processing Section
  Get Individual Post Comments**: Retrieves comments for each post
  Check Comment**: Verifies the presence of comments
  Split All Comments**: Splits retrieved comments into individual items
  Loop Over Comments**: Iterates through comments one by one
  Get Any Reply in Comment**: Checks if the comment has admin replies
  Check Reply**: Confirms presence or absence of replies

  3. Admin Reply Detection
  Edit Fields**: Extracts relevant data from comments
  Separatamento Without Admin Reply**: Filters out comments that haven't received admin replies
  Check Comment1**: Validates if such comments exist
  Split Out Without Admin Reply Comments**: Prepares these comments for AI classification

  4. Comment Classification (via OpenAI)
  Loop Over Items2**: Loops through comments without admin replies
  Replay Comment Data**: Uses OpenAI to classify comments

  5. Response Generation
  Switch**: Routes comments based on classification
  Positive Replay**: Generates a friendly, human-like reply for positive comments
  Support Replay**: Generates a warm, appreciative reply for supportive comments
  Reply to Comment**: Posts the AI-generated reply on Facebook

  6. Negative Comment Handling
  Delete Comment**: Removes negative comments from Facebook
  Append Row in Sheet**: Logs comment details in Google Sheets
  Get Row in Sheet**: Retrieves user history from the sheet
  Code in JavaScript**: Counts how many negative comments the user has posted
  If**: Checks if user has more than 1 negative comment
  Banned User**: Executes a Facebook ban on repeat offenders
  Update Row in Sheet**: Updates the user's status to banned in Google Sheets

  7. Optional Features
  Facebook Graph API**: Sends warning messages to users with negative comments

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.switch","n8n-nodes-base.facebookGraphApi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.set","n8n-nodes-base.manualTrigger","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.splitOut","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.splitOut","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.googleGeminiTool","n8n-nodes-base.noOp","n8n-nodes-base.googleDocsTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5684 characters]


name: Facebook Messenger Chatbot with GPT-4.1 & Human Escalation Support
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-10-30T10:05:50.517Z
updated_at: 2025-10-30T10:05:50.517Z
url: https://n8n.io/workflows/10321
scraped_at: 2025-12-24 13:02:43
description:
  Who is this for?
  This n8n workflow is designed for businesses, customer support teams, and page administrators who want to automate their Facebook Messenger responses while maintaining the ability to escalate to human agents when needed. It's perfect for e-commerce stores, service providers, and organizations that receive customer inquiries through Facebook Messenger and want to provide instant, intelligent responses 24/7. The workflow can handle both text messages and attachments, automatically detects when human intervention is needed, and seamlessly transfers the conversation to a human admin.

  What this Workflow Does
  This n8n workflow creates an intelligent Facebook Messenger chatbot that can understand and respond to customer messages in both English and Bengali. It automatically classifies incoming messages to determine if they require human assistance, processes attachments by identifying file types, generates appropriate responses using AI, and escalates conversations to human admins when necessary. The workflow maintains conversation context through memory and can reference external documents for more accurate responses.

  Key Features
  Multi-language Support**: Automatically detects and responds in English or Bengali
  Message Classification**: Determines if a message requires human intervention
  Attachment Handling**: Identifies and processes different file types (images, documents, etc.)
  AI-powered Responses**: Generates intelligent, context-aware responses using OpenAI
  Admin Escalation**: Seamlessly transfers conversations to human agents when needed
  Memory Management**: Maintains conversation context for more natural interactions
  Document Integration**: Can reference external Google Docs for information
  Webhook Verification**: Properly handles Facebook's webhook verification process

  Requirements
  Facebook Page with Messenger functionality
  Facebook Graph API credentials
  OpenAI API credentials
  Google Docs API credentials (optional)
  n8n Instance (self-hosted or cloud)
  Admin Facebook user ID for escalation

  Workflow Components
  1. Webhook Setup
  Webhook**: Receives incoming messages from Facebook Messenger
  If3**: Verifies webhook subscription requests
  Respond to Webhook**: Completes the verification process

  2. Message Processing
  If**: Determines if the message contains text or attachments
  Classify text**: Analyzes text messages to determine if human intervention is needed
  AI Agent1**: Identifies attachment types

  3. AI Response Generation
  AI Agent**: Generates intelligent responses to user messages
  OpenAI Chat**: Powers the AI Agent with language model capabilities
  Think**: Ensures responses match the user's language and tone
  Memory**: Maintains conversation context
  HTTP**: Enables external data retrieval
  Google Docs**: Allows referencing external documentation

  4. Escalation Logic
  If2**: Determines if escalation is needed based on classification
  Edit Fields1**: Prepares data for escalation messages
  Wait3**: Adds delay before sending messages

  5. Message Delivery
  Admin Message**: Notifies admin when escalation is needed
  User Message**: Confirms to user that their message was forwarded
  Admin Message1**: Notifies admin about attachments
  User Replay Message**: Sends AI-generated responses to users

  Notes
  The workflow uses a custom session key for memory management
  Admin ID should be updated to match your Facebook admin user ID
  The system is configured to respond in both English and Bengali
  Webhook verification requires a specific verify token (set to "admin" in this example)
  The workflow includes appropriate delays to prevent rate limiting

  Ideal Use Cases
  Customer service automation for e-commerce stores
  Lead qualification and initial response
  After-hours customer support
  Information dissemination for organizations
  Appointment scheduling and basic inquiries
  Product information and recommendation requests

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.respondToWebhook","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.httpRequestTool","n8n-nodes-base.googleDocsTool","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZS2/kxhH+K/Qcksu00i92s3Vx1muvs4nXu9iHDcM2gn5KjDjkhORIKywW2FziU+BTYgSx4UOcWSMIEiOHxLnYf2WwfyD5CanmjDSUxJFGa/siDdnV1V+9q5pPRrkb7Y5+/p49PHj01jv2ztvs8f3JbDQeTXyrR7tPRnnZtLq0/naks0Zp4lNGiRTSCEaEYFzSjHFCmfSp4IammdSGpEZyq7HOlDeY6pTxjDsBfFs/mRa69Tdr75oHvp1Nb1bwxrceDmjrmX86HpV64uG0G7fRverIA2FyS1tvquoguaf3fPJgNp1WdZvc3Netqdrd5MasrZL7flocJz9KHkx0XJs1bTXxdfIzXboiL/fi2XqvGe2+/yGcUDkffz5Zyp8Fl1mCU8RIxhA3RCClMouMt1gL4YNybHSK611v9gFLZHg8jS/KrEQdR2R043eOTtenVZO3eVXCSYildMxEBoev1juNUs+c9V4hyrhAnNoUKZ+mSGZSYG4VcdJHRrqGs1tfA+gnUUNV65vb5a2iOhrtBl00fjyqfVsf3y1v6bw4fRcBvgO7Ogx0PNLFkT5u7s7a6ax9XUcLd4RPxytFBBdEAIPB+YQAnDQgw3CGsEllwFx75sVaEfd9M61Kl4Dyr9JJvSR9WL07pJxUijFj4sOLgp4RgOzwU6SUuTRNg0TOSY24Si3SwnEUwDuZtphQoUc9V0pu7PmyXeP7KQD8yRpkocs9u6/zckev6HrwCKF4LCi/Ch/doaf4vKNYCIoRWBMjboNDmrKAtNbeigw7Sdwa38P9vDzYAlxbVcUJbecDQPxeNUt07ROdhDr34OzHCbh8kpetL4o8SpPYk2BoVpGjmyaPcd0moaphp5k1eembZueD8oMSGNbJryqT5A2Ydje+elQ6ELKNfNt9n8waX7949scmmcCeGJEWAIRZsTp6ZWyAAKzB4WCPbpNmvzpqkmNAOzvL7dcz30RNJwAlb5qZ71DEmJ7oNrc6sq274AaGr/lyTxd5kodTJMlRnYMqeqvjlQaSN8q9Im/2N1CvVrvjHlSAKinyg6jIfV9MQZxkfzbR5TgBTZ+s1BUknB04J7GF1/UYxKsny+OmVQGMO2b/+/yTP//364+Th1XpkzdnufOgxUeNT5o85rpx4g99fexAM9G0M9DgTvJ6VYJK24gxqWAZxAXbTHQR1dIdm9tkul9DNEUzvfFYR1YnEndWevHs08X8+WL+5eL57xbzfyzmf1vMv1nM58li/tvF/K9xIT5/lcSHSPLVYv6v7gfs+Gi58Onp9leW2/6+mH8Lv+YdxR8W8z/B84tn8xfPPjs98uPF/KOkO+3bxfzfi+efA23Svf79Yg4Pvzld/Lpj/cUSRvfmi+XaP+PfeMKXr3acT8RbmehEvIf7ujxoOqc9jl668r9Xkrd8Cw+J3ff2YOluK5qdNdCb1axwnQMCZ1Bjspcf+rgL/D+H7RUEkYOylxevnmz67JPkdohbfgxrs7KZwT/ga/XSVrpsoD6Nk0Yf716iDdDB/JtThUQNJ1EV8/90z50qnj/r6bjT3vKhU8pfvlgLsRIUpAPPi/HTBWn02eir5wLb+BZSVefOJ3p4O7pesgch10RJJhrcejaFaOicLYbhTvIL76ddxOUQJxC2dTs+CYmlq5e6ndW62DmXJinG44xnA2nyTL2KVf5CZifrzG6pVNRwZLmDYuyIQsoagpQA3sILYoTsFWOdt5sr8XKxj1HwbJXKz5Rhwg3UEQ1lP3AUuxmkaKqQs5pKxxmnXAyU4Y0ypNapVEIHQQXA545mwE8xZD1j1GWcGW4uVifycuWJZ3hM8PXKk7RQHwkWiKaCIi6h99EuKjnD1Nssw8L2ytPtsFHFeTjX5xAxltm1sIQgqCGgLC4llEpDHRicU+QDV0xj6rDudV8/e/jw3kY0+207ve+7gvIQSuU52zOabfDPM9h4D5vWjAZBJBKaR8dwDhlofEFZkkqWpSbgHrY3q2oPktbrlW02QtzraCLJAEKeim0QrvFlDhNniUEMem3EvcYo85KhYBRhKZYOGsw1vjsektzxFl426Qhfm4Xg63fz0kHYngWKJd0GKNlhp1AtZywoCCoD3RriwSro2OCX9WBs6QG74mfjmlwjsMHnToLghwxsK0RKiIW20wjo15UHfgxziBuTOp4aA9PQWog3HNSVW7kv3GZ/aPz5FEUZ3SqeWa8dtjCVpUw5FLI4RwQHw0umYKzQgqY6ZCEwMohrs44vAottMLs6tvu4AIROvfDglSnkGXAb0JcMSAjueWAMe0r6eYZunWikyMYpoddJNEJiyC6CIJlyDz259Ug5D4kGlJ2CYSFP47MeyK5bWpbq+SE9UGXMGU88MjhAefQKZgpDGPKeaW1gatV9IW64CTS6d5Zt0kZhwmq8frPW0/0b0/ycYArzMc2uDva1ohnGKsAYmVoCVtdWowyKLkhPtJfOESF6GB/Frvx7gMjFla7Z6zIk4UqBTzrmYdLVHCMjRUAK8joWzHiokBvUuDlktgC5TWCvUcI067XzAmEYGRE4C0fapgxhZjmXGY4xfk6R8RoEBovvQZ9bTLxrpNBMQOuQeQQODm6pHEWZDBnyLJNO45QT1UuMD2CYOThO3oa2cHP+6WhWJP0Og0OLkeHz0Ea2gokXeqPd0WgzTO4x4cJJiHkLCnU8gGdCr2kIhBNVHvMUD8K8JE9uwEkyqJFEvCTQmLiJ9RgSurGxWhpI6BlFjFrIfI4E3m88ekA3p6xLgSp+wdjbAdVYg51lhqiUEOFGC6SMAj8VaWBYKpwpMwiUXxsoxWB5zi7k/O2ACgglzTQgSzn0HwogGw6eAB06tpAANJPDpk9fTqMCX8iY2wFVXDqcOgMVg0nEU+9QRlnsliQMDp5j0r866gEV1wcqBWSklwXKVBqMDTCfUQ7NJ8whEEw+FqXYGrvAjEwHgcrrmz7LxlxduCHcDqenVAkOEwXUfrA84dAcqeBQaiSj0HUqT/0gzuzaOBX5DoY3MGhAWYKUZAP0J5BPUWZ87JWJIloZ4qjtN0ubQ31oKmPptZolbLDMoEigIKSPCYijTAmNmDXYERmcJr12/e7UlzDGxhv55A7gKLYYMopJJO92nis/3URLyRYXwr1JTTCYStIUglpCQQ8AFcazDAWcGSWhtKu+8m4W8aYkHCetf7zNrXC1AeUWHSjZydZZHbqNlGQAMoOZjUtI7RnHXX5XMFFAS6LtoFK/kzqV2HQvs1mbwWAF8yNyWbyE4RgjTWGeSImwyofAtbGDIbO5gd9Yzyl0Dtcu6ECtbZsf+tNvHTCvtHm5t9yqi8LX96oit8ew/6iqD0JRHTW36mryAI64e1T6GmDoQ50X2hT+dnnn5r1TVv6xt7MI727tgG53dEgihMPl8V1bbwhOQ6qgxQ0sQDWBwRtUAqOFJ05ZZ1nQUU6QofQ2supw3Q7x7wTMBYK//6T7DrXZGzu68Qjmb/94tItB5vWWgTujC+QfAuY4Ug0dOTwCbnPilQeywQMv+1g0yKi76AFOOv9l/OxxhtlFLCdU57l094NDeC5tlgcBLT+8fC+IyFU2uQLKcjbdKNaV8ozXuIcHxMFTV9dHSw1MVg9X6WBycud0ToKVDwzJcKayXeaS/XvJQcSniIaOOXt1fOn+YXudu6Ma5NC36RCPTZPlILP+/eJ39sN+dVkyO/kYtSzgV3I9S36J4Ju1d5mdI5OziXHYV+gVPC62JttKS64h7kB668HtSIYyzlmap0//D5RdmoGRIQAA


name: Facebook Lead Management: Automate Email Responses with Gmail & Google Sheets
author_name: SpaGreen Creative
author_username: spagreen
categories: []
created_at: 2025-10-30T10:19:05.756Z
updated_at: 2025-10-30T10:19:05.756Z
url: https://n8n.io/workflows/10323
scraped_at: 2025-12-24 13:02:43
description:
  Who is this for?
  This n8n workflow is designed for marketers, sales teams, and business owners who use Facebook Lead Ads to capture customer information. It's perfect for those who want to immediately engage with leads through multiple channels without manual intervention. The workflow automatically processes new leads from Facebook Lead Ads, sends personalized emails. Designed for businesses that want to improve lead response time and conversion rates through automated multi-channel communication.

  What this Workflow Does
  This n8n workflow automatically captures leads from Facebook Lead Ads, formats the data, saves it to Google Sheets, sends personalized emails to each and updates the status of each communication in Google Sheets. It can be triggered automatically when new leads are submitted or manually for testing purposes.

  Key Features
  Facebook Lead Ads Integration**: Automatically captures new leads in real-time
  Google Sheets Synchronization**: Saves and updates lead information in a structured format
  Multi-Channel Communication**: Sends both email messages
  Status Tracking**: Updates communication status in Google Sheets
  Flexible Triggers**: Can be triggered by new leads or manually executed
  Data Formatting**: Cleans and formats phone numbers for validation
  Conditional Processing**: Only processes leads with specific status values

  Requirements
  Facebook Lead Ads account with webhook access
  Google Sheets account with OAuth2 access
  Gmail account for sending emails

  Workflow Components
  1. Trigger Section
  Facebook Lead Ads**: Automatically triggers when new leads are submitted
  Executed by Another Workflow**: Allows this workflow to be called from another workflow
  Click to Start**: Manual trigger for testing purposes

  2. Data Processing Section
  Format Ads Lead Response Data**: Extracts and formats lead details
  Save Ads Lead In Sheet**: Inserts or updates lead information in Google Sheets

  3. Email Communication Section
  Send a Email**: Sends personalized emails to leads
  Save State of Rows in Email Sent**: Updates email status in Google Sheets

  5. Flow Control
  Get Row in Sheet**: Fetches rows with specific status values
  Loop Over Items**: Processes each lead individually
  Wait**: Adds delays between requests to prevent rate limits

  Google Sheet Column Structure
  A Google Sheet formatted like this ➤ sample

  Support & Help
  WhatsApp**: Chat on WhatsApp
  Discord**: SpaGreen Community
  Facebook Group**: SpaGreen Support
  Website**: https://spagreen.net
  Developer Portfolio**: Codecanyon SpaGreen

nodes_used:
  ["n8n-nodes-base.wait","n8n-nodes-base.splitInBatches","n8n-nodes-base.manualTrigger","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.facebookLeadAdsTrigger","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.noOp","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61XyW7bSBD9FYKHOamN3hfdnG1gIJkA8SA+DHzopVrmWCIFkbJjGP73KUqOpSik17nYktisevXq1dK3ZZXKaTmrvr876czZJx+/2PW/sZyUC+h8Ob0tq7rtfB3hpD8Xg/MMlODMaBO0YFoLabgVknFhQGkZuLLGB6aCkdFTbx0Eyr0S0sqk0W4Hi+Xcd/B+Bak9hW69fN/gL9ABOuhWa7iblLVfAHpDNBCa5rL4DD4VX3ztZ7CAupsWp1Cn4t16flmcXfiuPV4uiy/Qtvi8Lf4oPi58NW+L43XXLHxXRT+f3/Se/awtp/+co/0mQf/xdhs9l4JanoAwJSKR1DISJGckcu1oYsIxlcsHVGe+6nprN8v+W21rsjFHgm/h6Hr7cNm0VVc1Nfpg3OmJ1BLdXkO4wHA2TOoojQQlCYTeZ44JfSpFnLSC85go46w35FfotYMVwr2923r9jt82ttkRu5vcx0CFpobLSFwQBmNQkXgXMCRGDTXGM2PkLobPTbMsvl7BqjjBfLSj4bTLedWd1O98Fy+g/TUwjGkipT1/AqR4gJhsTIoLIBBFIkgw0hxUICKzIJMxoJ3ZQXw/r+Jl0TXFaedX44QvfL32879X1WwGqwPm9URJ+RS+HYXZUod6NSQ7CkQ6IYlLmROfDUvc0ihl3OH7+APiGkVbhJviuG66CyTzrFld5nlzPYoWti/9PDcGWyj+JOy93EsjOAjKiDDIqfQ8E+uyJEkZ6bIKApNfjlTVcRrPfr4/2R/Ec4NoCTd8IviBujOPlGfnSdYZEWVqUI1KEB4D6OQyviSeVPdDfMoLRhWTRFBNiVRUEh+0JaCZpRn/erGXmE/NCqu+D2wb4Tdol03dQvHBY0cbizXix4PIpN0G9ihK/oDSRqxAhRUYqRNEBuuJDTkRUFGlQKkSaq8CT/0V7DCe1MXpBcC4zGdNM5vD5sxBGWInfgZMeaR3dIYkQ2SCCO446pxHYpUORKLkI9LpA3U7oB+a4i9Ud1XPRsHVzdflQW+g9BmgdhmGFBMkLD1jnES9BE6s5pZEVG6PSEQDO0h/Qlesmuuiqov2laxxSZ/TvOSR2dEmTXYJmytXDNtDVox4HHnYzVLOgmfmedrLbz+h/HYUjeO7f7oHzFA5MC2yTVlZbJ0mWNQWYK07TQXx3CkfcZYor56qJ77XMTIXOiqcOc5HnD5aeYLzWqNWA8XyCli17ECr2IY7KJpcfGuu2576TWj9JH6Vain/GefzdWuCwjaAc1mFXq3RbkecxtLC0QmRRr4HGgf/5U2vXRgfb5sz90f2S19oOyGM/6aPMjZ110c8LctxNVPgxkRsUMx7TySDQKxhnIC0lEYWo01hECh/HVIU8+uAmuy5lTZg3pVGGdiM6wO2A5Y0Lm0glOJuEKh4MVCN+eZKvw4nD8ln6CeJyij/iFw6qrAIrUq4erLE5HDm9csJtfQNmQ8oQx9wu+EiOCQ0O2JB9oqVHKsMSzjSQaDmxUA5fUPicYkPzIAhySWLqxh2f08TrmIecJnHZmztME72ckIZp2+hNAcWAfcGIoLE3AtcJazB0meBoXRpzimzQajudcVk9AuB4mkfu+oKHWU/b2FSttB1OC83r243Pjz6dZVwd5qWV6y3cbV9f9PcnRYxWJ0Jso7zOHNKcGVThMuQwDtcnGxfbwiihtib2hjeXEPwP3bhHjveZfoIH9vtNycneKFL8KOc0rvzcwTyy5waMvf85j9o/2CNH/IwPs4HLR7Gt2fyfLKHe3AAD1r8DcDbaf19yR6y+cxVdThxwwvkkJuhFW7Q5qN3mv8hdY/HO6q+R9bkcWoek+yQp1+v9QN27+7+Ay0q2hQtEQAA


name: Automate AI Video Creation & Multi-Platform Publishing with GPT-4, Veo 3.1 & Blotato
author_name: Dr. Firas
author_username: drfiras
categories: []
created_at: 2025-10-30T17:49:57.827Z
updated_at: 2025-10-30T17:49:57.827Z
url: https://n8n.io/workflows/10358
scraped_at: 2025-12-24 13:02:41
description:
  💥 Automate AI Video Creation & Multi-Platform Publishing with Veo 3.1 & Blotato

  🎯 Who is this for?
  This workflow is designed for content creators, marketers, and automation enthusiasts who want to produce professional AI-generated videos and publish them automatically on social media — without editing or manual uploads. Perfect for those using Veo 3.1, GPT-4, and Blotato to scale video creation.

  💡 What problem is this workflow solving?
  Creating short-form content (TikTok, Instagram Reels, YouTube Shorts) is time-consuming — from writing scripts to video editing and posting.  
  This workflow eliminates the manual steps by combining AI storytelling + video generation + automated publishing, letting you focus on creativity while your system handles production and distribution.

  ⚙️ What this workflow does
  Reads new ideas from Google Sheets  
  Generates story scripts using GPT-4  
  Creates cinematic videos using Veo 3.1 (fal.ai/veo3.1/reference-to-video) with 3 input reference images  
  Uploads the final video automatically to Google Drive  
  Publishes the video across multiple platforms (TikTok, Instagram, Facebook, X, LinkedIn, YouTube) via Blotato  
  Updates Google Sheets with video URL and status (Completed / Failed)

  🧩 Setup
  Required accounts:
  OpenAI → GPT-4 API key  
  fal.ai → Veo 3.1 API key  
  Google Cloud Console → Sheets & Drive connection  
  Blotato → API key for social media publishing  

  Configuration steps:
  Copy the Google Sheets structure:  
     A: id_video  
     B: niche  
     C: idea  
     D: url_1  
     E: url_2  
     F: url_3  
     G: url_final  
     H: status  

  Add your API keys to the Workflow Configuration node.  
  Insert three image URLs and a short idea into your sheet.  
  Wait for the automation to process and generate your video.  

  🧠 How to customize this workflow
  Change duration or aspect ratio** → Edit the Veo 3.1 node JSON body (duration, aspect_ratio)  
  Modify prompt style** → Adjust the “Optimize Prompt for Veo” node for your desired tone or cinematic look  
  Add more platforms** → Extend Blotato integration to publish on Pinterest, Reddit, or Threads  
  Enable Telegram Trigger** → Allow users to submit ideas and images directly via Telegram  

  🚀 Expected Outcome
  Within 2–3 minutes, your idea is transformed into a full cinematic AI video — complete with storytelling, visuals, and automatic posting to your social media channels.  

  Save hours of editing and focus on strategy, creativity, and growth.

  👋 Need help or want to customize this?
  📩 Contact: LinkedIn  
  📺 YouTube: @DRFIRASS  
  🚀 Workshops: Mes Ateliers n8n

  📄 Documentation: Notion Guide
  Need help customizing?
  Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n  

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.merge","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 10156 characters]


name: Automated Facebook Group Scraper: Posts, Comments, and Sub-comments to Supabase
author_name: Muhammad Abrar
author_username: muhammadab1
categories: []
created_at: 2025-10-30T23:48:11.141Z
updated_at: 2025-10-30T23:48:11.141Z
url: https://n8n.io/workflows/10370
scraped_at: 2025-12-24 13:02:41
description:
  This n8n template demonstrates how to automate the scraping of posts, comments, and sub-comments from a Facebook Group and store the data in a Supabase database.

  Use cases are many: Gather user engagement data for analysis, archive posts and comments for research, or monitor community sentiment by collecting feedback across discussions!

  Good to know

  At the time of writing, this workflow requires the apify api for scraping and Supabase credentials for database storage.

  How it works

  The Facebook Group posts are retrieved using an Apify scraper node.
  For each post, comments and sub-comments are collected recursively to capture all levels of engagement.
  The data is then structured and stored in Supabase, creating records for posts, comments, and sub-comments.
  This workflow includes the option to adjust how often it scrapes and which group to target, making it easy to automate collection on a schedule.

  How to use

  The workflow is triggered manually in the example, but you can replace this with other triggers like webhooks or scheduled workflows, depending on your needs.
  This workflow is capturing data points, such as user interactions or media attached to posts.

  Requirements

  Apify account API
  Supabase account for data storage

  Customizing this workflow
  This template is ideal for gathering and analyzing community feedback, tracking discussions over time, or archiving group content for future use.

nodes_used:
  ["@apify/n8n-nodes-apify.apify","@apify/n8n-nodes-apify.apify","@apify/n8n-nodes-apify.apify","n8n-nodes-base.supabase","n8n-nodes-base.set","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.if","@apify/n8n-nodes-apify.apify","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger"]

workflow_json_compressed:
  H4sIAAAAAAAAE81abXPcthH+KxymM5Y0hwsBgm/quKks2a5bj+yxJHfSyOMBAVDHiEdeSFCyRtF/7wJ8OZ7Ee1GaTKoPuiO5eHax2H2wC969PZeK2Yf3dppXiuVcvhP2oZ0IxnFAQ5dS7Ev4Y9KNBfNcxqkbUZ8wQlw/ZiKSjvCxT6iLfc91Ay/CVASuPbGVnC8ypuRxKUV1JlW9OC7gjlQSFKiylg8TOy+ErOzDn0C71oojjzku95DHsY8o9ymKZOIgH1TFQRxy6gSAnLO5BOlPdW6x3Driqii1vruFvvt3tkiTu+/zMEcGHZnrqfkPUouiSlVa5KAUYUonCPtf4C4rAVPJstKemMt5Ud7Zh9h3QzqxmVagvXJvf/1aZo3xE3sO6KAPDJ/YNyyr9cWRerVI5aJ+d3FakWtyXdswSZXOZVErGA8XvK5UMX9VCMC3X95f5hb8Xdq8qHN1aR9a9/fWX36uinwKhirr4WHSSczZtxOZsTsthJ3l7TRf3u7vLsrim7nVKmju1pU80m742D3VE2kElnoqXrKFfFsW9eIjmFBNr/TXizLTAy7t3r66zMC8S3s5sCjVOaxBI5fL2696CtWlfZk/2K0Xz4q65NpR4IRSaudwiA6Zq5RlxvVmmcBIE5A6JNw7ungVfq5vhX/0n7f/uFguv5mKxbhxnf3w0ETAZ1hDs7z4YdJChMzzfcd1kXBxiKhDBQoDGqMoiL2AhzTwYrmEfSuVJZhiFXymEMPVbwktl4wGVpEkANsEQimrzhknjTqtqdVscvBl72shE1Zn6qR7CI7/Y30Hy5XdsrvqQ60WtdFrHyagRvZOdRzPJwkXCHvSQ9SPOKQqwSjmNMYJc4kX+Bucin9TwhJCJx6la/1qv7T/zx3b+y+WInEJixCNY4loIBmKYwb/fBq7QK/YwwP/HQlhHVk6H5d+WzosBuOnVb1g+suqywh1RiNRsThrmN4kKQxKUpmJ6sJM0nz/rDmtIWdzbaTBM0Dp4MxuxOeW+bRPIectcKXca5zbyh4p6wAYy3H2p1dSmef7mtisy3yXMap4X3CWyTNVpvnV3ot2yV5MrHtrXuRqdmi9yIr86oX18BxYMOVNnWU/SlYac2y9Mst5AruNzXBJfb/+auUwfmRkJcuvZtnWjweRqRZZj6Lkt1EXNwD66fqxMFeul7+JwbUgndixFluPVs1YKbdAGZktOLyYzyGntiC1UluwmFKMz7RgtR5qIDSds8Ues17+zWJ68fZXkL88PM34LpmGSX9S//Nn/upHl5/U2b/fHnnL7DxrpXfKe0bcOGAYhWEUIOoFIYpDIZHjhUmCAyHCRCyRX4tUWW9MZq5PfKlWcz7CZIIj8pQlF1qgarYfVlXpVd64UFPc8LIrx5IgIRFOBApcihElJEZhHBHkh9z1oEKkLiVLW9ulGxjKypLdDaojszZ7L55uBi/2p/rLdBgC1XJxVlzpTmnvTJrgyMEkQKHrwCbkEgfF0uNIxtgXPAkZM5Voa+CxIQGLWWVx+0waxe4any55tJSLLJW7MyngwCy/trMdDeNdXXWxiY9aPWsJZauSzWTTmrCRL3cx838hPKh2kzSTG21oZTa7qpHZTN6t0OlG+tab6iaXN/v5ceOXFW83I1OVyT+BnEJBPO45MYqxhKIkcn3EQkh45jsBh0wLQh48LkqO+wB+TkIhqJA9Em7IpwGd7JZQpk9pXDfidXD6gEx1hCdpWam9/Wm3pU8rSGC1d2l/f2nrpxnYtPeqKDLJ8n1Yl8Xe/rYFX6N70NGdm5VdC5MwLuOiuN4YymkONfnGQP69knK3MNZl6WN/moT9I5L8d0jOLL2W1ZY6xMjsVtFsg+rEtqAdPbOm0W33D+O39V9T8iili57BIQCHAgBYfs6upMkE66X1If5ZcjU1m3Slh+ilzMXejR568wOkRrr/1yVCKSGu8gGEkejm1Qs+7PeWPEolff/wzyq/HCax9HkEJQJPEHVchpgbQDUWSZ/ENJbcZ0vkdwley2tpsspogUMnxHnKaCtVF7hfpN314JF905lKJnYmE9UtPejgoO1M5lrRjewOn8z0WJbCvm2G2RW0R1yZ5rWYx2nO9KEYlGC5riaHavvijlAv9BlFSeAKRBPiIShNHeQm1I0ZdzAWmuuLhSwbrPveEfU8lmX/rNF/ZXQPTX9etfckO6CRT69mHZozUgmSKenXNZJB4rCQIOEksHMxlyLGsYP8wI+C0PcDGQ92rjNzxnX8pGB9xlEEdZzRo4ju7DCEavFZR4d15VXlt6Mf86q8vrq4ITe7HB1e2mnOs1rIU1lBf9vNSB/BmeOaSSNUKVZqpjcPfmoSsyeFS93srjncaw8H9ceXFusmlbcfTOA2Yz4dnf7r9cnXi9M3796fv/70+uTPP/Cjse/EoYORxNxF1CcJipgMkEdj4THhYiHjQTDobd/6UG8oYbREIzDsCbDrb++zDJGfF2cdxKCwWT8BEmBHEt9BQUig8cIEojnk+oQowRQLh/tDlhrWNbt3iYiE4fgh5XPbRE5cjwjpIMJDYBJXAKf6IkKJC8lHRcIFH7SJTVHSGlmZQ53HLeIgBO3eJ4kvHCnAJx7h0Oth6qAogN5UxNjzYkEcgulSy2L1qKxjrFYNxlsaS+4HYeCDsjjwQkRpGCIm/ASFSRDJMHAcmPMgglTKr++s00LJ9f43Mq3ICpH4dIKI93QdblOhZmArCZ2JPZOaDO1DMMXQudIl96H93XfWm7ZktAypgTetoxpowvAy5Gt+cLC8Pjg4tM5naWXdFuV1khW3VnPaX1nmFNBKymIO/XEPaUpqC/YQK80rWYKEmsk5XKgCxA4Oup334MBQvJloo/NMyQWK75D+1FrhJp7CiB7avGDobdYi5m2DBd1qa5RozAGNrR11pWenrxsm0N416ohG1me41puihJmqFvGsxVn0yFxXIHBHTwlqRS6rCq5imQA5wYfGN0SlJ2z1dYW2zDKdidamp/dGMqiCZAVaLnPUeRyGVd0iFEmjdqqff5IsQ5rLjZus6i7nWuY2VbNey3QDH3gy4JR4HjCYAEJzQ+jLfMgCHrtQswgaAyuMhuMGPlgXj9CVTUjwlNW6cMRQ5yzDEfuPwrGPwm4vssC31sdS3qRFXbWLPBKW73JYWYhMUKq08/Qyd1E6sW67oDD3Dw46DoXA0/D6ZrPIasYUSA+CSLIyS2W5DKbV6N4Wr1LxmZ6OiYHjXu2hDjXA5jOj+LG2yYr9VqJRIMtSsLA/3tohnD82IdqG8zmI9qN1NC8jWMdz0sT++nheydceqIlrpo/Qm4DUFhVQe0ENmTWT00E7bUL/WcHfK3mUBOPxr8E35ACLJOyJSYCCKOCIejFBkWQRihKXcJgx1LPjOUCenQO+fmniP63t2hQII3+ZAVADbs0AIOL++95ZHaPOL/ubMgEKusWjOOrY+uCgGqDAau7xgS6TDW3CZXd9aC6V6mgxYdHzuWHzSurpKtmEBKA+ipldU+VsxbZBprQ32yRl1Y5Zw/I7qz1dhcC0hlPfmi9D4dWcmXSbwWS37GGWSJNE6sPUgVc6X02ftTOsTGFDbgx1rmqcbswVz6WU+RFGcaLLFyaht3OiCPHEdUMaQKMrBhXZh9zMXls1TyuDtS5jtNw5cMOVqaZWyhjaVZO3Mp4Bvb5rKnEPalVJkePHULRFYEjMgwQlsH0Jx/exSHQlvql+1hrNudqhffHpvd3caV+J6Mb50VHgexbLrC8zFxmQ/azIhNTN8GvI0tJqUEr5S53C0hqk7vcoLcb5o6pxBfjU3O339zVK8lUpCwqmdgMrIMZLWF5YSSjbb1PodtsnDL72O9nYqw8ydR++GLbJJe+PDvQhhW48WaoXAvyQN93l6LsjIzWBrlHIb6arnvz05QvoWTZBY1Djb06eYGmgwZvqMaR1nfco1nAGo2BPO7dRnBXzB0CPlYz7cfxnRqOKVkTHsDb8uGSDN7sj9jHElSOqUYxHLt/JrG2YT+cxBjv2q4Xd4MZXYs0Lh1HIEVLbkiSb5/zw8F9pn2P1KicAAA==


name: Smart CSM Assignment & AI Welcome Emails for HubSpot Deal Wins with Gmail
author_name: PollupAI
author_username: Pollup
categories: []
created_at: 2025-10-31T16:17:11.912Z
updated_at: 2025-10-31T16:17:11.912Z
url: https://n8n.io/workflows/10398
scraped_at: 2025-12-24 13:02:44
description:
  Who's it for
  This template is for Customer Success and Sales teams who use HubSpot. It automates the critical handoff from sales to success, ensuring every new customer gets a fast, personalized welcome. It's perfect for anyone looking to standardize their onboarding process, save time on manual tasks, and improve the new customer experience using AI.

  What it does
  This workflow triggers when a deal's "Is closed won" property is set to True in HubSpot. It assigns a Customer Success Manager (CSM) by querying an n8n Data Table to find the 'least busy' CSM (based on a deal count) and fetches the deal's details to find all associated contacts.

  It then loops to identify the "Champion" contact by checking their "Buying Role" (hs_buying_role). An AI agent (in the AI: Write Welcome Email node) generates a personalized welcome email, which is converted to HTML and sent via Gmail. Finally, the workflow updates the Champion's contact record in HubSpot and updates the CSM's deal count in the Data Table to keep the logic in sync.

  How to set up
  Create and Populate Data Table: This template requires an n8n Data Table to manage CSM assignments.
      Create a Data Table named csm_assignments.
      Add two columns: csm_id (String) and deal_count (Number).
      Add one row for each CSM with their HubSpot Owner ID and a starting deal_count of 0.
  Link Data Table Nodes: Open the Get CSM List and Increment CSM Deal Count nodes and select the csm_assignments table you just created from the Table dropdown.
  Configure Variables: In the Configure Template Variables node, you must set your sender info (company_name, sender_name, and sender_email).
  Customize AI Prompt: In the AI: Write Welcome Email node, update the placeholder [Link to Your Video] and [Link to Your Help Doc] links with your own URLs.
  Check HubSpot Property: This workflow assumes you use the "Buying Role" (hs_buying_role) contact property to identify your "Champion". If you use a different property, you must update the HubSpot: Get Contact Details and If Role is 'Champion' nodes.

  Requirements
  Access to n8n Data Tables.
  HubSpot (Developer API):** A credential for the Trigger: Deal Is 'Closed Won' node.
  HubSpot (OAuth2):** A credential for all other HubSpot nodes (Get Deal Details, Get Contact Details, Assign Contact Owner).
  AI Credentials:** (e.g., OpenAI) Credentials for the AI Model node (the node connected to AI: Write Welcome Email).
  Email Credentials:** (e.g., Gmail) Credentials for the Gmail: Send Welcome Email node.

  How to customize the workflow
  You can easily customize this workflow to send different emails based on deal properties. Add an If node after the HubSpot: Get Deal Details node to check for the deal's value, product line, or region.

  Based on these properties, you can route the flow to different AI: Write Welcome Email nodes with unique prompts. For example, you could check the contact's 'industry' or 'company size' to send them links to different, more relevant 'Getting Started' videos and documentation.

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.hubspot","n8n-nodes-base.code","n8n-nodes-base.hubspot","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.markdown","n8n-nodes-base.gmail","n8n-nodes-base.hubspot","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.hubspotTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.dataTable","n8n-nodes-base.code","n8n-nodes-base.dataTable","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6440 characters]


name: Cryptocurrency Volume/MCap Screener - Automated Trading Alerts to Discord
author_name: Malik Hashir
author_username: malikx
categories: []
created_at: 2025-10-31T19:01:24.212Z
updated_at: 2025-10-31T19:01:24.212Z
url: https://n8n.io/workflows/10400
scraped_at: 2025-12-24 13:02:46
description:
  Purpose & Audience
  This n8n workflow template is designed for cryptocurrency traders, investors, and market analysts who want to automate the process of detecting unusual trading activity across 1,250+ cryptocurrencies. By continuously monitoring volume-to-market-cap ratios and price movements, the workflow delivers real-time alerts directly to your Discord server—helping you catch potential breakouts, pump schemes, or high-impact market events before they become mainstream news.

  What It Does
  Monitors 1,250+ cryptocurrencies from CoinGecko every 4 hours for unusual trading patterns
  Calculates volume-to-market-cap ratios to identify coins with abnormally high trading activity (&gt;30% ratio or &gt;$100M volume with significant price movement)
  Ranks and filters the top volume alerts based on trading intensity
  Sends beautifully formatted Discord embeds with coin metrics, price changes, market cap, and direct CoinGecko links
  Provides context with educational information about what volume/MCap ratios mean and trading warnings

  Who Is It For
  Day traders and scalpers seeking early signals for high-volatility opportunities
  Market analysts who want automated surveillance of unusual market activity across hundreds of coins
  Discord community managers looking to provide valuable trading insights to their members
  Anyone interested in catching potential pumps, breakouts, or news-driven price movements before the crowd

  Setup once and let it run 24/7. The workflow automatically scans the market every 4 hours and only sends alerts when something significant is detected. Customize the alert thresholds, add more coins, or adjust the schedule to fit your trading style. No coding required—just connect your CoinGecko API and Discord webhook, and you're ready to catch the next big move!

  How to Set Up
  Obtain a free CoinGecko API key and create a Discord webhook for your server
  Import the workflow and add your API credentials
  Customize alert thresholds and update frequency to match your trading preferences
  That's it—receive real-time volume alerts for potential trading opportunities automatically

  Preview: 
  Please click here for preview.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE72Xy25jNwyGX8Xw2gx0oSQqmyJAW0wXUxRtMZsiC12oxGhsp/bJoGmQdy/tSWOPfU59KdDd8TH967NE/qRexjPu0vj6ZTydr7o0L/xDHV+Pg2/OY+HIumH0nHyxztqmnavO6JCsTgGzzt5kTlYVGwKaiCGlUDmU8etkPF9UXo2vfxPpjWTA1HL1YFWOgNoQpKgZbI0YUYWmfR3Lr9KMJfp77sr96Kd0xyMnb7vnx/XbOc1hIws5rfjqvusef+Y/nnjVSczjYjXtpou5LAk6eDUxzt/K67QUyY6XwvLy+kXqk3zaROKVfp28AfpqSEWrgFATYA0eKBgLSZmSk6vetX7AS/kAPZ4DWBCTCrmCw+QAm4pAkRMoJiuCVk6qH9BfTGiIziGMNWoXrRyvpwpYXAXSEQHRaaaofM2mlzBcTKi1OYdQMtXpVBm4NeEqJgNxzmBDNomyTn7gkOlSQlJnJWEwLUmFgXcsZxwLQfbRQVS1lBxLTJG3fB95ecd6kGy2/nqfSXuawHEoe2XeoZxRxWtfwHnf5Gxrg1gpAObiQy5JNXJbqJt5enj+i0efFg9PMx7dlG76edo9D2MWedyjDNZPwB492S2i9cQYFEEgJ8VrlGReiwyqKY0YdMCv3GWxnKVu9O10VRbLOvrIq1X6t408JDTBSO4d9ZctILOtJbcG2dgiiZcQiNL6KTvbKmYS13wH/KWblt+fRz8uOh6EWm1i3kJ2N09sbF0Y1h8c8rgs5h3POxEb76Nuc1C83bhaEZprCZBJiyWSkb8brbbofazci2rOZ9XRbIpYHTjhaaxIzK7QupTlyDFVKwvqCoW0lv2O2AL1stoLWK2hXtM+DZW1DT5K2XB2GdDK3iabDDRsrZG1mGx/BuD5qHJeE2kTF5JmVaNzyUI0nqWYxImiFBFoY3TNqaSYsJd0uFUPktq1HeFhJZ14/EFzM01BkcFDejY3aThswFElomxy4dxLOtwSh0il0ciWhgtBmzVopMQhFG8FVDY3abRAtsrMEYpYqekFHe6MQ6Ce6D+A+pzFzhvBevIDdC1DzjIPRS3GKq5QYusvqPj/GxXlqorUDjSDUvzGSV+SaRUKV4tF66Z2PfW7z7x8HpnRh8WTrDEIW+65Pj3wr8vp3R0v94ndOgviUd/XO92TqLKOMgUVU4WySiFR0gGCC9EET00SY0v5Ia1GNw+87FbfDDJO26GLntIud7xIoMR3ZAwyUUsf5yCn7JQ4fpQib2xS2bV4nr83yS9wo27xT/c8fy7amNPx3ok7e6h9qsnJnCZ1JO09o4cYSoHilNw/5CLiVezNyuGePpyVft3bUZ2ZlBIt38+5rHU24W/TmTzN0nQtLVehNcBJM9LmJxO5lVX+c3ytXm9vZcndS0ef7P482Cuym2E7IreTrc7R+egYnbsADw9U/AUq+kAlXKBiDlToAhX7ReVr4+mT6b1M7u/xpC/cnxkfzoynM+PdsRwZyKy+XTnRdnrXGSywvoV6PbdH9vX1bxM1r1ovEQAA


name: Automated SEO Ranking Monitor with AI, Decodo Scraper & Multi-Channel Alerts
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-11-01T17:21:42.824Z
updated_at: 2025-11-01T17:21:42.824Z
url: https://n8n.io/workflows/10412
scraped_at: 2025-12-24 13:02:45
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Keep your SEO performance on track with this automated SEO Watchlist Monitor! 
    
  This workflow combines AI-powered strategy analysis with real-time search ranking checks to track keyword positions, identify content gaps, and alert you to critical ranking drops. Perfect for marketing teams ensuring search visibility and competitive intelligence across platforms. 🚀🔍

  What This Template Does  
  1️⃣ Triggers daily SEO intelligence checks to monitor keyword performance.   
  2️⃣ Configures target keywords, competitor domains, and geographic focus.  
  3️⃣ Validates SEO configuration to ensure proper setup. 
  4️⃣ Uses AI to analyze keyword competitiveness and strategic opportunities.  
  5️⃣ Checks real-time search rankings using Google Search scraper.  
  6️⃣ Detects critical ranking drops below position 10. 
  7️⃣ Saves SEO intelligence to Google Sheets for tracking. 
  8️⃣ Sends email alerts for urgent ranking issues. 
  9️⃣ Provides daily Slack summaries of SEO performance.  

  Key Benefits  
  ✅ Monitors keyword rankings and competitor movements daily  
  ✅ Identifies content gaps and strategic opportunities with AI analysis  
  ✅ Alerts instantly to critical ranking drops for quick action  
  ✅ Centralizes SEO intelligence in Google Sheets for team visibility  
  ✅ Combines AI insights with real-time search data for comprehensive monitoring  

  Features  
  Daily automated schedule for continuous monitoring  
  AI-powered SEO strategy analysis and competitive intelligence  
  Real-time search ranking checks using Decodo scraper  
  Critical alert system for ranking drops  
  Google Sheets integration for data centralization  
  Slack and Gmail notifications for team awareness  
  Configuration validation and error logging  
  Structured data parsing for consistent reporting  

  Requirements  
  OpenAI API credentials for AI analysis  
  Decodo API credentials for search scraping  
  Google Sheets OAuth2 credentials with edit access  
  Gmail OAuth2 credentials for email alerts  
  Slack Bot Token with chat:write permission  
  Environment variables for configuration settings  

  Target Audience  
  SEO and digital marketing teams 🎯  
  Content strategy and growth teams 📈  
  Competitive intelligence professionals 🔍  
  Marketing operations teams 🚀  
  Agency account managers managing multiple clients 💼  

  Step-by-Step Setup Instructions  
  1️⃣ Connect OpenAI credentials for AI analysis capabilities  
  2️⃣ Set up Decodo API credentials for search scraping functionality  
  3️⃣ Configure Google Sheets with required headers (Keyword, Rank, description, etc.)  
  4️⃣ Add Gmail and Slack credentials for alerting and notifications  
  5️⃣ Set your target keywords, competitors, and geographic focus in the configuration node  
  6️⃣ Configure the cron schedule (hourly) for daily monitoring frequency  
  7️⃣ Run once manually to verify all integrations and data flow  
  8️⃣ Activate for ongoing SEO performance tracking and alerting ✅  

  Pro Tip: Use coupon code "YARON" to get 23K requests for testing (in Decodo)

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.function","@n8n/n8n-nodes-langchain.agent","@decodo/n8n-nodes-decodo.decodoTool","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.slack","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6328 characters]


name: AI-Powered Content Analysis with Decodo Scraping & GPT-4o Insights
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-11-01T17:23:20.342Z
updated_at: 2025-11-01T17:23:20.342Z
url: https://n8n.io/workflows/10413
scraped_at: 2025-12-24 13:02:44
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  AI-Powered Content Analysis System

  Elevate your content quality with this AI-powered Content Analysis System!  
  This workflow automatically evaluates website content using advanced scraping and AI analysis, providing comprehensive SEO insights, readability scores, and actionable improvement recommendations. Perfect for content teams ensuring optimal performance and engagement across digital properties.

  What This Template Does
  Triggers via form submission for on-demand content analysis requests.  
  Checks previous analyses to prevent duplicate processing.  
  Scrapes target URLs using Decodo for comprehensive content extraction.  
  Uses AI to evaluate content quality, SEO effectiveness, and readability.  
  Saves analysis results to Google Sheets for historical tracking.  
  Generates professional Google Docs reports with actionable insights.  
  Sends email notifications with formatted analysis summaries.  
  Alerts teams via Slack for both normal and urgent findings.  
  Creates remediation plans and Trello tasks for low-quality content.

  Key Benefits
  Automated content quality assessment with AI-powered insights  
  Prevents duplicate analyses to optimize resource usage  
  Comprehensive SEO and readability scoring for data-driven decisions  
  Professional reporting with Google Docs and email integration  
  Immediate team alerts for urgent content improvements  
  Historical tracking and trend analysis capabilities  

  Features
  Form-based trigger for easy content analysis requests  
  Duplicate detection and prevention system  
  AI-powered content evaluation using GPT-4o  
  Real-time web scraping with Decodo integration  
  Automated Google Docs report generation  
  Multi-channel notifications (Slack, Gmail)  
  Quality threshold monitoring and alerting  
  Remediation plan generation for low-quality content  
  Trello integration for task management  
  Historical analysis database in Google Sheets  

  Requirements
  OpenAI API credentials for AI analysis  
  Decodo API credentials for web scraping  
  Google Sheets OAuth2 credentials with edit access  
  Google Docs OAuth2 credentials for report generation  
  Gmail OAuth2 credentials for email notifications  
  Slack Bot Token with chat:write permission  
  Trello credentials (optional for task management)  
  Environment variables for configuration settings  

  Target Audience
  Content marketing and strategy teams  
  SEO specialists and digital marketers  
  Content quality assurance teams  
  Digital agencies managing multiple clients  
  Website owners and publishers  
  Content operations managers  

  Step-by-Step Setup Instructions
  Connect OpenAI credentials for AI content analysis capabilities  
  Set up Decodo API credentials for web scraping functionality  
  Configure Google Sheets with required analysis headers  
  Add Google Docs credentials for automated report generation  
  Set up Gmail and Slack credentials for notifications  
  Optional: Configure Trello integration for task management  
  Customize the analysis form with your industry and focus areas  
  Test with sample URLs to verify all integrations and data flow  
  Deploy for ongoing content quality monitoring and optimization  

  Pro Tip: Use coupon code "YARON" to get 23K requests for testing the workflow with the Decodo scraper

  This workflow ensures your content maintains high quality standards with automated analysis, professional reporting, and immediate improvement alerts!

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.function","n8n-nodes-base.formTrigger","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.outputParserStructured","@decodo/n8n-nodes-decodo.decodoTool","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.slack","n8n-nodes-base.gmail","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.aggregate","n8n-nodes-base.googleDocs","n8n-nodes-base.googleDocs","n8n-nodes-base.trello","n8n-nodes-base.slack","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7916 characters]


name: AI Research Paper Analysis & Documentation with Decodo, GPT & Google
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-11-01T17:26:43.691Z
updated_at: 2025-11-01T17:26:43.691Z
url: https://n8n.io/workflows/10415
scraped_at: 2025-12-24 13:02:45
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Accelerate your research analysis with this Automated Research Intelligence System!  
  This workflow uses AI and web scraping to analyze research papers and articles, extracting key insights, validating content quality, and generating comprehensive research documents. Perfect for research teams, academics, and AI enthusiasts staying current with the latest developments in artificial intelligence and machine learning.

  What This Template Does
  Triggers via form submission for on-demand research URL analysis.  
  Validates URL accessibility and prepares for processing.  
  Uses Decodo scraper to extract research content from target URLs.  
  Analyzes research papers with AI for comprehensive understanding.  
  Validates summaries for accuracy, completeness, and relevance.  
  Generates key insights and actionable takeaways from research.  
  Creates professional Google Docs with formatted research summaries.  
  Evaluates research quality with AI-powered rating system.  
  Saves all research to Google Sheets for historical tracking.  
  Sends Slack alerts for high-quality research findings (9+ rating).  

  Key Benefits
  Automated research analysis saves hours of manual reading time  
  AI-powered insights extraction from complex research papers  
  Quality validation ensures accurate and relevant summaries  
  Centralized research database for team collaboration  
  Real-time alerts for breakthrough research findings  
  Professional documentation automatically generated  

  Features
  Form-based trigger for easy research submission  
  URL validation and accessibility checking  
  AI-powered research analysis and summarization  
  Decodo web scraping for reliable content extraction  
  Multi-stage validation for accuracy and relevance  
  Automated Google Docs report generation  
  Quality assessment with structured rating system  
  Google Sheets integration for research tracking  
  Slack notifications for premium research findings  
  Quality threshold filtering for optimal results  

  Requirements
  Decodo API credentials for research scraping  
  OpenAI API credentials for AI analysis  
  Google Docs OAuth2 credentials for document creation  
  Google Sheets OAuth2 credentials with edit access  
  Slack Bot Token with chat:write permission  
  Environment variables for configuration settings  

  Target Audience
  AI research teams and data scientists  
  Academic researchers and university labs  
  Machine learning engineers and developers  
  Technology innovation teams  
  Research and development departments  
  Content creators in AI/ML space  

  Step-by-Step Setup Instructions
  Connect Decodo API credentials for research scraping functionality  
  Set up OpenAI credentials for AI analysis and quality assessment  
  Configure Google Docs for automated research document generation  
  Add Google Sheets credentials for research tracking and history  
  Set up Slack credentials for high-quality research alerts  
  Customize quality thresholds for research rating (default: 6+ for processing, 9+ for alerts)  
  Test with sample research URLs to verify analysis and formatting  
  Deploy the form for team access to research analysis requests  
  Monitor research database for trends and insights  

  Pro Tip: Pro Tip: Use coupon code "YARON" to get 23K requests for testing

  This workflow transforms complex research into actionable intelligence with automated analysis, quality validation, and professional documentation!

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","@decodo/n8n-nodes-decodo.decodoTool","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","n8n-nodes-base.googleDocs","n8n-nodes-base.set","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleDocs","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.noOp","n8n-nodes-base.slack","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5836 characters]


name: Collect & Analyze Reviews with Decodo Scraping
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-11-01T17:27:57.306Z
updated_at: 2025-11-01T17:27:57.306Z
url: https://n8n.io/workflows/10416
scraped_at: 2025-12-24 13:02:45
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Automated Review Intelligence System

  Transform customer feedback into actionable intelligence with this Automated Review Intelligence System!  
  This workflow collects reviews from platforms like Trustpilot using advanced web scraping, analyzes sentiment and patterns with AI, and generates comprehensive business intelligence reports. Perfect for customer experience teams monitoring brand reputation and customer satisfaction across review platforms.

  What This Template Does
  Triggers manually to start review collection from specified sources.  
  Validates URL format to ensure proper review source configuration.  
  Uses AI agent with Decodo scraper to extract review data from platforms.  
  Parses and structures review data (ratings, comments, dates, locations).  
  Enriches review data with metadata and quality metrics.  
  Stores all review data in Google Sheets for historical tracking.  
  Reads aggregated reviews for comprehensive analysis.  
  Generates AI-powered summaries and key insights from review patterns.  
  Sends email reports with actionable business intelligence.  
  Provides error alerts for processing issues and invalid URLs.  

  Key Benefits
  Automated collection of customer reviews from multiple platforms  
  AI-powered sentiment analysis and pattern recognition  
  Historical tracking of review trends and customer satisfaction  
  Actionable business intelligence from customer feedback  
  Real-time alerting for review processing issues  
  Centralized review database for team visibility  

  Features
  Manual trigger for on-demand review intelligence  
  URL validation and error handling  
  AI-powered review collection and analysis  
  Decodo web scraping for reliable data extraction  
  Structured data parsing for consistent formatting  
  Google Sheets integration for data centralization  
  Automated summary generation with key insights  
  Email reporting for stakeholder communication  
  Multi-platform review source support  
  Historical trend analysis capabilities  

  Requirements
  Decodo API credentials for web scraping  
  OpenAI API credentials for AI analysis  
  Google Sheets OAuth2 credentials with edit access  
  Gmail OAuth2 credentials for email reports  
  Environment variables for configuration settings  
  Review source URLs (Trustpilot, etc.)  

  Target Audience
  Customer experience and success teams  
  Product management and development teams  
  Marketing and brand reputation managers  
  Business intelligence and analytics teams  
  Customer support operations teams  
  E-commerce and retail businesses  

  Step-by-Step Setup Instructions
  Connect Decodo API credentials for review scraping functionality  
  Set up OpenAI credentials for AI analysis and summary generation  
  Configure Google Sheets with required review data headers  
  Add Gmail credentials for report delivery and error notifications  
  Set your target review source URLs (Trustpilot, etc.)  
  Test with sample review pages to verify data extraction  
  Customize summary reports for your business intelligence needs  
  Define alert recipients for error notifications and reports  
  Run manually to generate your first review intelligence report  

  Pro Tip: Use coupon code "YARON" to get 23K requests for testing the workflow using Decodo

  This workflow ensures you stay informed about customer sentiment with automated review collection, intelligent analysis, and actionable business insights!

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@decodo/n8n-nodes-decodo.decodoTool","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.gmail","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5004 characters]


name: Automated Job Intelligence System with Decodo, AI Analysis, and Email Alerts
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-11-01T17:28:52.589Z
updated_at: 2025-11-01T17:28:52.589Z
url: https://n8n.io/workflows/10417
scraped_at: 2025-12-24 13:02:45
description:
  Stay ahead in your job search with this Automated Job Intelligence System!  
  This workflow scans company career pages daily for new job listings, uses AI to analyze job relevance and seniority levels, and sends personalized email alerts for high-priority opportunities while maintaining a comprehensive job database. Perfect for job seekers, recruiters, and career coaches tracking ideal opportunities across target companies.

  What This Template Does
  Triggers daily at 9 AM to scan for new job opportunities.  
  Retrieves company URLs from Google Sheets database.  
  Uses Decodo scraper to extract job listings from career pages.  
  Analyzes job data with AI to identify company names and positions.  
  Converts job data into individual listing items for processing.  
  Compares new jobs against existing database to filter duplicates.  
  Uses AI to assign relevance scores, seniority levels, and tech stack analysis.  
  Filters high-relevance jobs (score &gt;8/10) for priority alerts.  
  Stores all new jobs in Google Sheets for historical tracking.  
  Sends personalized email alerts for high-relevance opportunities.  

  Key Benefits
  Automated daily scanning of target company career pages  
  AI-powered relevance scoring and job matching  
  Duplicate prevention to avoid redundant notifications  
  Comprehensive job database for tracking and analysis  
  Personalized alerts for high-priority opportunities  
  Time-saving automation for job search activities  

  Features
  Daily automated scheduling for consistent monitoring  
  AI-powered job extraction and data structuring  
  Decodo web scraping for reliable career page access  
  Intelligent relevance scoring and seniority analysis  
  Duplicate detection and filtering  
  Google Sheets integration for job tracking  
  Personalized email alerts for premium opportunities  
  Multi-company monitoring capability  
  Historical job data maintenance  

  Requirements
  Decodo API credentials for web scraping  
  OpenAI API credentials for AI analysis  
  Google Sheets OAuth2 credentials with edit access  
  Gmail OAuth2 credentials for email alerts  
  Slack Bot Token for error notifications (optional)  
  Environment variables for configuration settings  

  Target Audience
  Job seekers and career changers  
  Recruitment and talent acquisition teams  
  Career coaches and placement agencies  
  HR professionals monitoring competitor hiring  
  Technology professionals tracking market opportunities  
  University career services and placement offices  

  Step-by-Step Setup Instructions
  Connect Decodo API credentials for career page scraping  
  Set up OpenAI credentials for job relevance analysis  
  Configure Google Sheets with company URLs and job tracking sheets  
  Add Gmail credentials for personalized job alerts  
  Optional: Set up Slack for error notifications  
  Populate company URLs in your Google Sheets database  
  Test with sample companies to verify job extraction and analysis  
  Customize relevance thresholds for your job preferences  
  Activate for daily automated job intelligence monitoring  

  Pro Tip: Use coupon code "YARON" to get 23K requests for testing (in Decodo)

  This workflow transforms your job search with automated intelligence, smart filtering, and personalized opportunity alerts!

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.agent","@decodo/n8n-nodes-decodo.decodoTool","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","n8n-nodes-base.slack","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","n8n-nodes-base.merge","n8n-nodes-base.gmail","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7380 characters]


name: Automated Daily Financial Analysis from Loyverse POS with Google Sheets & Email
author_name: Nik B.
author_username: nikkapoo
categories: []
created_at: 2025-11-01T19:27:12.342Z
updated_at: 2025-11-01T19:27:12.342Z
url: https://n8n.io/workflows/10420
scraped_at: 2025-12-24 13:02:41
description:
  Automatically fetches daily sales, shifts, and receipts from Loyverse. Calculates gross profit, net operating profit, other key metrics, saves them to a Google Sheet and sends out a daily report via email.

  Who’s it for
  This template is for any business owner, manager, or analyst using Loyverse POS who needs more advanced financial reporting. If you're a restaurant, bar, or retail owner who wants to automatically track daily net profit, compare sales to historical averages, and build a custom financial dashboard in Google Sheets, this workflow is for you.

  How it works / What it does
  This workflow runs automatically on a daily schedule. It fetches all sales data and receipts from your Loyverse account for the previous business day, defined by your custom shift times (even past midnight). 
  A powerful Code node then processes all the data to calculate the metrics that Loyverse either doesn't provide at all, or only spreads out across several separate reports instead of in one consolidated place. 

  Already set up are metrics like...
  -Total Revenue, Gross Profit, and Net Operating Profit
  Cash handling differences (over/under)
  Average spend per receipt (ATV)
  30-day rolling Net Operating Profit (NOP)
  Performance vs. your historical weekday average

  Finally, it appends the single, calculated row of daily metrics to a Google Sheet and sends an easily customizable summary report to your email.

  How to set up
  This workflow includes detailed Sticky Notes to guide you through the setup process.

  Because every business has a unique POS configuration (different POS devices, categories, and payment types), you'll need to set up a few things manually before executing the workflow. I've tried to make this as easy as possible to follow, and the entire setup should only take about 15 minutes.

  Preparations & Credential setup
  Subscribe to "Integrations" Add-on in Loyverse ($9 / month) to gain API access.
  Create an Access token in Loyverse
  Create Credentials: In your n8n instance, create credentials for Loyverse (use "Generic" &gt; "Bearer Auth"), Google Sheets (OAuth2), and your Email (SMTP or other).

  Make a copy of a prep-configured Google Spreadsheet
  (Link in the second sticky note inside the workflow).

  Fill MASTER CONFIG: 
  Open the MASTER CONFIG node. Follow the comments inside to add your Google Sheet ID, Sheet Names, business hours, timezone, and Loyverse IDs (for POS devices, payment types, and categories).

  Configure Google Sheet Nodes

  Configure Read Historical Data: Open this node. Follow the instructions in the nearby Sticky Note to paste the expressions for your Document ID and Sheet Name.
  Configure Save Product List: Open this node. Paste in the expressions for Document ID and Sheet Name. The column mapper will load; map your sheet columns (e.g., item_name) to the data on the left (e.g., {{ $json.item_name }}).
  Configure Save Latest Sales Data: Open this node. Paste in the expressions for Document ID and Sheet Name. Save and run the workflow. After that, the column mapper will load. This is the most important step: map your sheet's column names (e.g., "Total Revenue") to the calculated metrics from the Calculate All Metrics node (e.g., {{ $json.totalGrossRevenue }}).

  Activate the workflow. 🫡

  Requirements
  Loyverse Integrations Subscription
  Loyverse Access Token
  Credentials for Loyverse (Bearer Auth)
  Credentials for Google Sheets (OAuth2)
  Credentials for Email/SMTP sender

  How to customize the workflow
  This template is designed to be highly flexible.

  Central Configuration:
  Almost all customization (POS devices, categories, payment types, sheet names) is done in the MASTER CONFIG node. You don't need to dig through other nodes.

  Add/Remove Metrics:
  The Calculate All Metrics node has additional metrics already set up, just add the relevant collumns to the SalesData sheet or even add your own calculations to the node. Any new metric you add (e.g., metrics.myNewMetric = 123) will be available to map in the Save Latest Sales Data node.

  Email Body:
  You can easily edit the Send email node to change the text or add new metrics from the Calculate All Metrics node.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.emailSend","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  [encoded data, 10496 characters]


