# templates

name: Publish videos to 9 social platforms from Google Sheets with Blotato
author_name: giangxai
author_username: giangxai
categories: []
created_at: 2026-01-20T04:05:08.546Z
updated_at: 2026-01-20T04:05:08.546Z
url: https://n8n.io/workflows/12836
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Auto Publish Videos to 9 Social Media Platforms

  Schedule and load content from Google Sheets, then publish videos in parallel across 9 social media platforms.

  Who is this for?

  This template is ideal for:

  Content creators publishing videos at scale
  Social media managers handling multiple platforms
  Affiliate marketers running automated content funnels
  AI automation builders using Google Sheets as a control panel
  Teams that want reliable, scheduled, multi-platform video publishing

  If you already have videos ready and want to automate distribution instead of manual uploading, this workflow is for you.

  What problem is this workflow solving?

  Manually publishing videos across multiple social platforms is slow and error-prone. Common challenges include:

  Re-uploading the same video to multiple platforms
  Tracking which videos have been published
  Handling publishing errors across different APIs
  Maintaining consistent posting schedules
  Managing content in spreadsheets without automation

  This workflow turns Google Sheets into a single source of truth and fully automates video distribution.

  What this workflow does

  This automated publishing workflow:

  Triggers on a defined schedule
  Loads pending video content from Google Sheets
  Publishes videos in parallel to 9 social media platforms:
    Instagram
    TikTok
    YouTube
    Facebook
    X (Twitter)
    Threads
    LinkedIn
    Pinterest
    Bluesky
  Marks successfully published content in Google Sheets
  Logs publishing errors for failed platforms

  Setup

  1. Prepare Google Sheets

  Create a Google Sheet with at least the following columns:

  video_url – Direct link to the video file
  caption – Post caption or description
  platforms – Platforms to publish (optional logic-based use)
  status – pending / published / error
  error_message – Stores error details if publishing fails

  Only rows marked as pending will be processed.

  2. Connect Google Sheets

  Authenticate your Google Sheets account in n8n
  Select the spreadsheet in the Read Pending Posts (Google Sheets) node
  Ensure the update nodes can write back to the same sheet

  3. Configure Social Platform Credentials

  For each platform node:

  Add API credentials or OAuth tokens
  Verify required permissions for video publishing
  Test each platform individually if needed

  Supported platforms:

  Instagram
  TikTok
  YouTube
  Facebook
  X (Twitter)
  Threads
  LinkedIn
  Pinterest
  Bluesky

  4. Configure the Schedule Trigger

  Open the Schedule Content Publishing trigger
  Set how often the workflow runs (hourly, daily, or custom cron)
  This schedule controls when pending videos are published

  How to customize this workflow to your needs

  You can adapt this workflow without changing the core structure:

  Disable platforms you don’t want by turning off their publishing nodes
  Add content filters or platform-specific captions
  Insert an approval step (Slack, Telegram, Email) before publishing
  Add retry logic for failed platforms
  Extend the workflow to support images or carousel posts
  Add analytics or reporting steps after publishing

  Best practices

  Ensure video URLs are publicly accessible
  Use platform-safe video formats and dimensions
  Start with a small batch to test credentials
  Monitor the Log Publishing Errors node for debugging
  Keep status values consistent in Google Sheets

  📄 Documentation

  For a full walkthrough and advanced customization ideas, see:

  Video Guide

nodes_used:
  ["@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","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4304 characters]

metadata_json:
  {"categories":["Marketing","Content Creation"],"complexity":"medium","use_cases":["video scheduling","multi-platform publishing","content automation","social media management"],"estimated_setup_minutes":15,"required_services":["Google Sheets","Blotato"],"key_features":["parallel video publishing","Google Sheets content control","scheduled publishing across multiple platforms"],"target_audience":["content creators","social media managers","affiliate marketers"]}


name: Generate personalized cold email icebreakers from LinkedIn or website data with GPT-4
author_name: Matthew
author_username: matthew-synteria
categories: []
created_at: 2026-01-20T05:06:57.386Z
updated_at: 2026-01-20T05:06:57.386Z
url: https://n8n.io/workflows/12837
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  Multi-Channel Cold Email Generator (LinkedIn + Website Fallback)

  Description
  This workflow automates the generation of hyper-personalized cold emails. It intelligently switches between two data sources: LinkedIn Activity and Company Website.

  If the lead has recent LinkedIn posts, the AI generates an icebreaker referencing their specific thoughts or news. If no posts are found, the workflow falls back to scraping their company website and generating an angle based on their business proposition.

  How it Works
  Fetch Data: Pulls a list of leads from a Google Sheet.
  Scrape LinkedIn: Uses Apify to attempt to scrape recent posts for the lead.
  Conditional Logic:
     Path A (Posts Found): Aggregates the posts, analyzes the context using GPT-4, and writes an email referencing the content.
     Path B (No Posts): Scrapes the URL provided in companyWebsite, converts the HTML to Markdown, analyzes the company value prop, and writes an email based on that.
  Save Results: Writes the generated Icebreaker, Intro, and CompanyType back to the original Google Sheet.

  Requirements
  n8n:** Self-hosted or Cloud.
  Google Sheets Account:** A sheet containing columns for email_final, linkedin_url, and companyWebsite.
  Apify Account:** You must have the LinkedIn Scraper actor (ID: A3cAPGpwBEG8RJwse or similar) configured and an API Token.
  OpenAI API Key:** Access to GPT-4 model is recommended for best quality.

  Setup Instructions
  Import the JSON: Copy the provided JSON template and paste it into your n8n canvas.
  Configure Credentials:
     Set up your Google Sheets and OpenAI credentials in n8n.
  Apify Token:
     Locate the Apify LinkedIn Scraper node (HTTP Request).
     In Header Parameters &gt; Authorization, replace YOUR_APIFY_API_TOKEN with your actual Apify Bearer token.
  Google Sheet Configuration:
     Open the Fetch Leads node. Select your generic Sheet and specific Workbook.
     Open both Update Row nodes (there are two: one for the Website branch, one for the LinkedIn branch) and ensure they point to the same Sheet/Workbook.
  Customize AI Prompts:
     Open the two Write Email Copy nodes.
     In the system prompt, look for [YOUR_BUSINESS_TYPE] and [YOUR_COMPANY_NAME]. Replace these with your actual business details to ensure the AI generates relevant outreach.

  Customization
  Model Selection:** You can switch the OpenAI model to gpt-3.5-turbo to save costs, though the quality of the "Icebreakers" may decrease.
  Output Columns:* The workflow currently outputs Icebreaker, intro, and companyType. You can modify the *Update Row** nodes to map these to different column headers in your sheet if needed.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.markdown","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","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, 9352 characters]

metadata_json:
  {"categories":["Sales","Marketing","AI/ML","Data Processing","Communication"],"complexity":"medium","use_cases":["personalized cold Outreach","email icebreaker creation","LinkedIn integration","fallback lead research"],"estimated_setup_minutes":15,"required_services":["GPT-4","LinkedIn API","Website scraper/HTTP"],"key_features":["Intelligent source switching","AI-driven personalization","Multi-channel data sources","Fallback mechanisms"],"target_audience":["Sales managers","Business development","Cold outreach specialists"]}


name: Build a LinkedIn job intelligence pipeline with Apify and Google Sheets
author_name: Ahmed Salama
author_username: ahmedsalama
categories: []
created_at: 2026-01-20T05:11:16.704Z
updated_at: 2026-01-20T05:11:16.704Z
url: https://n8n.io/workflows/12838
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Categories  
  Lead Generation, Market Intelligence, Recruitment Automation, Business Intelligence

  LinkedIn Job Intelligence Automation (n8n + Apify)

  This workflow creates a fully automated LinkedIn job intelligence system that continuously scrapes job postings, enriches them with time-based insights, removes duplicates, and stores them in a structured Google Sheet for analysis, outreach, or decision-making.

  Built for founders, recruiters, sales teams, and consultants who want real-time hiring signals instead of static lead databases, this workflow turns job postings into actionable business intelligence.

  Benefits

  Real-Time Hiring Signals**  
    Detect company growth, hiring urgency, and budget intent before announcements.

  Automated Lead Discovery**  
    Identify companies actively hiring relevant roles, indicating readiness to buy services or tools.

  Zero Manual Work**  
    Fully automated scraping, enrichment, and storage.

  De-duplicated Data**  
    Prevents repeated job entries using job ID matching logic.

  Time-Based Insight**  
    Automatically calculates how many days ago a job was posted.

  Flexible Output**  
    Stored in Google Sheets for BI tools, CRMs, AI agents, or manual review.

  How It Works

  LinkedIn Job Scraping (Apify Actor)

  Uses Apify LinkedIn Jobs Scraper actor  
  Accepts up to 10 LinkedIn job search URLs  
  Extracts up to 100 jobs per run (configurable)  
  Pulls structured data including:
    Job ID
    Job title
    Company name
    Location
    Posting date
    Job URL

  Data Enrichment & Transformation

  Standardizes all job fields using a Set node  
  Computes “How many days since posted” using runtime date comparison  
  Prepares clean, analysis-ready records

  Batch Processing Control

  Uses Split In Batches to:
    Avoid API throttling
    Maintain stable execution
    Scale safely for larger job volumes

  De-Duplication Logic

  Checks Google Sheets for existing job IDs  
  Only inserts new jobs  
  Ensures clean historical datasets with no duplicates

  Persistent Storage (Google Sheets)

  Appends validated job records to a centralized sheet  
  Acts as:
    Lead database
    Market intelligence log
    BI or AI agent data source

  Required Setup Configuration

  Apify Integration

  Connect Apify OAuth credentials
  Use the LinkedIn Jobs Scraper actor  
  Customize:
    Keywords
    Location
    Job count
    Company scraping toggle

  Google Sheets Integration

  Create a target Google Sheet  
  Columns required:
    Job ID
    Job URL
    Title
    Company Name
    Location
    Posted Date
    Days Since Posted  
  Enable OAuth access for n8n

  n8n Configuration

  Manual trigger (can be replaced with Cron for automation)  
  Batch size control for scaling  
  Error-safe execution with continuation enabled

  Business Use Cases

  Sales & Lead Generation Teams
  Target companies actively hiring roles related to your offer  
  Prioritize outreach based on hiring urgency

  Founders & CEOs
  Monitor competitor hiring velocity  
  Identify market expansion signals early

  Recruiters & Staffing Agencies
  Build live job pipelines without manual LinkedIn searches  
  Reduce sourcing time dramatically

  Consultants & Agencies
  Detect companies entering problem-aware or scaling phases  
  Align service offers with real hiring pain points

  Market & VC Analysts
  Use hiring data as a leading indicator for growth or decline

  Revenue Potential

  This workflow enables multiple monetization paths:

  Lead Intelligence as a Service**  
    Sell curated hiring signals to sales teams or agencies

  Recruitment Automation**  
    Reduce recruiter sourcing costs by 70–90%

  Consulting Insights**  
    Bundle hiring data into strategy or growth audits

  Outbound Acceleration**  
    Increase reply rates by targeting active hiring companies

  Difficulty Level  
  Beginner to Intermediate

  Estimated Build Time  
  30–45 minutes

  Monthly Operating Cost

  Apify usage (based on volume)  
  Google Sheets: Free  
  n8n: Self-hosted or cloud plan  

  Typical range: $10–25/month

  Why This Workflow Works

  Hiring data reflects real budget allocation  
  Job posts act as pre-revenue intent signals  
  Time-based metrics enable prioritization  
  De-duplication ensures long-term data quality  
  Simple storage makes it easy to extend with:
    CRMs
    AI agents
    BI dashboards
    Email or LinkedIn outreach automations

  Advanced Extensions

  Auto-enrich companies with LinkedIn company data  
  Push qualified jobs into CRM as leads  
  Trigger outbound emails based on posting age  
  Add AI classification for role relevance  
  Connect to Slack or email alerts for new jobs

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","@apify/n8n-nodes-apify.apify","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4760 characters]

metadata_json:
  {"categories":["Recruitment Automation","Market Intelligence","Data Processing","Lead Generation","Business Intelligence"],"complexity":"medium","use_cases":["scrape job postings","track market conditions","monitor competitor hiring","identify leads","analyze hiring trends"],"estimated_setup_minutes":120,"required_services":["Apify","Google Sheets"],"key_features":["duplicate removal","time-based enrichment","consistent data structures","automated workflow triggers"],"target_audience":["founders","recruiters","Hiring Managers"]}


name: Draft personalized Outlook support email replies with Supabase RAG and OpenAI
author_name: Matthew
author_username: matthew-synteria
categories: []
created_at: 2026-01-20T05:14:09.959Z
updated_at: 2026-01-20T05:14:09.959Z
url: https://n8n.io/workflows/12839
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Description
  This workflow automates the first line of customer support by intelligently drafting email replies. It bridges the gap between your CRM (Supabase), your technical documentation (Vector Store), and your inbox (Outlook). By analyzing the sender's identity and the technical content of the query, it ensures that every draft reply is personalized, accurate, and follows strict business rules.

  How It Works
  Trigger: Monitors a Microsoft Outlook inbox for new incoming messages.
  Contact Enrichment: Queries a Supabase contacts table using the sender's email to retrieve their name, organization, and department.
  Context Construction: A Code node prepares a "Chat Input" that includes the email body, sender metadata, and specific brand "Business Rules."
  AI Intelligence (RAG):
      An AI Agent (GPT-4o) analyzes the request.
      If technical details are required, the Agent uses a Supabase Vector Store tool to retrieve semantic matches from your product manuals.
  Draft Creation: The AI generates an HTML-formatted reply which is saved as a Draft in Outlook for manual review.
  Audit Trail: Logs the intent, urgency, and outcome into a Google Sheet for performance tracking.

  Requirements
  Microsoft Outlook:** Business/Office 365 account.
  Supabase:** * A table for contact lookups.
      A vector-enabled database containing document embeddings.
  OpenAI API:** For the GPT-4o model and embeddings.
  Google Sheets:** To maintain an execution summary log.

  Setup Instructions
  Import: Paste the workflow JSON into your n8n canvas.
  Credentials: Set up and select credentials for Outlook, OpenAI, Supabase, and Google Sheets.
  Placeholder Updates:
      Fetch Contact Info: Set the table name to your specific CRM table.
      Vector Store: Update the table name and query function to match your Supabase Vector Store setup.
      Log to Google Sheets: Replace the Document ID and Sheet Name with your specific spreadsheet details.
  Persona Tuning: Open the AI Support Agent node and the Build AI Prompt code node to replace the [YOUR_COMPANY] and [YOUR_NAME] placeholders with your actual brand identity.

  Customization Ideas
  Urgency Routing:** Add an If node after the Agent to send a Slack or Teams notification if the AI detects the urgency is "high."
  Attachments:** Modify the Outlook node to include specific PDF brochures based on the primary_product_codes identified by the AI.
  Human-in-the-loop:** Use n8n "Wait for Webhook" or "Manual Approval" nodes if you want to approve the draft within the n8n UI before it hits the Outlook drafts folder.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.microsoftOutlookTrigger","n8n-nodes-base.set","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.vectorStoreSupabase","@n8n/n8n-nodes-langchain.embeddingsOpenAi","n8n-nodes-base.code","n8n-nodes-base.supabase"]

workflow_json_compressed:
  [encoded data, 5204 characters]

metadata_json:
  {"categories":["Customer Support","AI/ML"],"complexity":"medium","use_cases":["automate support email drafting","retrieve technical documentation context","draft personalized responses"],"estimated_setup_minutes":20,"required_services":["Microsoft Outlook","Supabase","OpenAI"],"key_features":["RAG-based knowledge retrieval","context-aware email drafting","business rule compliance","personalized replies"],"target_audience":["customer support agents","IT professionals","technical writers"]}


name: Report spam and phishing URLs from IMAP mailboxes to Spamhaus
author_name: Vitali
author_username: vquie
categories: []
created_at: 2026-01-20T13:02:47.073Z
updated_at: 2026-01-20T13:02:47.073Z
url: https://n8n.io/workflows/12846
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  This workflow automates URL reporting to Spamhaus based on incoming spam/phishing sample emails. It watches one or more IMAP folders, extracts URLs from each email body, removes duplicates and common noise, and submits the remaining URLs to the Spamhaus submission API with the appropriate threat context.

  What it does
  Monitors one or more IMAP mailboxes/folders containing abuse samples (spam/phish).
  Processes each email individually in a loop.
  Extracts and normalizes URLs from the email text.
  De-duplicates URLs (per run) and filters out common false positives (images, tracking pixels, privacy/imprint pages).
  Submits each URL to Spamhaus via POST /portal/api/v1/submissions/add/url.
  Optionally runs:
    mail-specific jobs (per email) for enrichment, logging, ticketing, notifications, etc.
    run-specific jobs (once per workflow execution) for summaries, metrics, cleanup, or follow-up workflows.

  How it works (high level)
  IMAP triggers fetch new messages from configured folders.
  An initial Set node attaches metadata such as:
    threat_type (e.g., spam or phish)
    reason.url (human-readable reason for the submission)
  SplitInBatches loops over each email.
  A Code node extracts all URLs from the email body, normalizes them, and removes obvious noise (e.g., trailing punctuation).
  Remove Duplicates clears dedupe history and ensures only unique URLs are processed per run.
  URLs are split into single items, filtered, and then packaged into the Spamhaus request body.
  HTTP Request submits each URL to Spamhaus.
  Aggregate collects results, enabling optional per-run actions at the end.

  Extending with more IMAP triggers
  You can add as many additional IMAP triggers as needed.
  To do so, connect each new IMAP trigger to the same initial Set node (or duplicate that Set node per trigger) to define the correct threat_type and reason.url. The downstream flow stays unchanged.

  Customization points
  Threat classification: Adjust threat_type and reason.url in the initial Set nodes.
  URL extraction rules: Update the regex and normalization logic in extract all URLs.
  Filtering: Extend the filter regex to exclude additional benign paths/domains.
  Per-email actions: Add nodes or call a sub-workflow from add mail specific job.
  Per-run actions: Add nodes after the loop to add run specific job (summaries/metrics/cleanup).

  Requirements
  An IMAP account with access to the folders containing sample emails.
  A Spamhaus API credential (configured as an HTTP Header Auth credential in n8n).
  n8n credentials set up for:
    IMAP
    HTTP Header Auth (Spamhaus)

  Notes
  Ensure run-specific logic is connected to the loop’s done / “No items left” output so it runs once after all emails are processed (not per email).
  This workflow only extracts URLs from the email text content. If you need URL extraction from HTML parts or attachments, extend the extraction step accordingly.

nodes_used:
  ["n8n-nodes-base.emailReadImap","n8n-nodes-base.emailReadImap","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.aggregate","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.removeDuplicates","n8n-nodes-base.splitOut","n8n-nodes-base.filter"]

workflow_json_compressed:
  [encoded data, 4632 characters]

metadata_json:
  {"categories":["Security","Data Processing"],"complexity":"medium","use_cases":["automate URL reporting to threat databases","monitor email for malicious links","integrate with Spamhaus API"],"estimated_setup_minutes":20,"required_services":["IMAP","Spamhaus submission API"],"key_features":["monitors IMAP folders for spam samples","extracts and normalizes URLs from emails","removes duplicates and common noise","submits URLs to threat intelligence APIs"],"target_audience":["security analysts","ops engineers"]}


name: Facebook Messenger Chatbot That Learns From Your Documents
author_name: Tristan V
author_username: tristanv
categories: []
created_at: 2026-01-20T13:52:20.984Z
updated_at: 2026-01-20T13:52:20.984Z
url: https://n8n.io/workflows/12848
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Quickstart Guide: Facebook Messenger Chatbot with Pinecone RAG

  Step-by-step instructions to get this workflow running in n8n.

  Prerequisites

  Self-hosted n8n instance (v1.113.0+ recommended)
  Community nodes enabled in n8n
  Facebook Page (you must be an admin)
  OpenAI account
  Pinecone account (free Starter plan works)

  Workflow Architecture

  This workflow uses two webhooks with the same URL path but different HTTP methods:

  | Webhook | Method | Purpose |
  |---------|--------|---------|
  | Facebook Verification Webhook | GET | Handles Facebook's webhook verification |
  | Facebook Message Webhook | POST | Receives incoming messages |

  Both webhooks share the same URL: https://your-n8n.com/webhook/facebook-messenger-webhook

  n8n automatically routes requests based on HTTP method:
  GET** requests → Verification flow
  POST** requests → Message processing flow

  RAG Enhancement

  User Message → Batching → AI Agent ─┬─ OpenAI Chat Model
                                      ├─ Conversation Memory
                                      └─ Pinecone Assistant Tool (RAG)
                                                │
                                                ▼
                                      Search your documents
                                                │
                                                ▼
                                      Answer with citations

  Step 1: Install the Pinecone Assistant Community Node

  The Pinecone Assistant node is a community node that must be installed separately.

  In n8n, go to Settings → Community Nodes
  Click Install a community node
  Enter: @pinecone-database/n8n-nodes-pinecone-assistant
  Click Install
  Restart n8n if prompted

  &gt; Note: Community nodes must be enabled in your n8n instance. For Docker, set N8N_COMMUNITY_PACKAGES_ALLOW_INSTALL=true.

  Step 2: Create Pinecone Account & Assistant

  2.1 Create Pinecone Account

  Go to Pinecone
  Sign up for a free account (Starter plan includes 100 files per assistant)
  Complete the onboarding

  2.2 Create an Assistant

  In the Pinecone console, go to Assistants
  Click Create Assistant
  Name it n8n-assistant (or choose your own name)
  Select your preferred region
  Click Create

  2.3 Upload Your Documents

  Click on your newly created assistant
  Go to the Files tab
  Click Upload Files
  Upload your documents (PDFs, text files, etc.)
  Wait for processing to complete

  2.4 Get Your Pinecone API Key

  In the Pinecone console, click on your profile/account
  Go to API Keys
  Copy your API key (or create a new one)

  Step 3: Get Your OpenAI API Key

  Go to OpenAI Platform
  Sign in with your OpenAI account
  Click Create new secret key
  Copy and save the API key

  Step 4: Create Facebook App & Get Page Access Token

  4.1 Create Facebook App

  Go to Facebook Developers
  Click My Apps → Create App
  Select Other → Next
  Select Business → Next
  Enter app name and contact email
  Click Create App

  4.2 Add Messenger Product

  In your app dashboard, scroll to Add products to your app
  Find Messenger and click Set up

  4.3 Connect Your Facebook Page

  In Messenger settings, find Access Tokens section
  Click Add or Remove Pages
  Select your Facebook Page and grant permissions
  Click Done

  4.4 Generate Page Access Token

  Back in Messenger settings, find your page in the list
  Click Generate Token
  Copy and save the token

  Step 5: Create Your Verify Token

  The verify token is a secret string for Facebook webhook verification.

  Create a random string (e.g., my-secret-token-12345)
  Save this value - you'll need it in Steps 7 and 10

  Step 6: Create n8n Credentials

  6.1 Pinecone Credential

  In n8n, go to Credentials → Add Credential
  Search for "Pinecone" (or "Pinecone API")
  Configure:
     Name: Pinecone API
     API Key: Paste your Pinecone API key from Step 2.4
  Click Save

  6.2 OpenAI API Credential

  In n8n, go to Credentials → Add Credential
  Search for "OpenAI API"
  Configure:
     Name: OpenAI API
     API Key: Paste your OpenAI API key from Step 3
  Click Save

  6.3 Facebook Graph API Credential

  In n8n, go to Credentials → Add Credential
  Search for "Facebook Graph API"
  Configure:
     Name: Facebook Page Access Token
     Access Token: Paste your Page Access Token from Step 4.4
  Click Save

  Step 7: Import the Workflow

  In n8n, click Add Workflow → Import from File
  Select the workflow.json file from this folder
  The workflow will open in the editor

  7.1 Configure the Verify Token

  Find the "Is Token Valid?" node
  Click on the node to open its settings
  In the conditions, find Value 2 that shows YOUR_VERIFY_TOKEN_HERE
  Replace it with your verify token from Step 5

  7.2 Configure the Pinecone Assistant Name

  Find the "Get context snippets in Pinecone Assistant" node
  Click on the node to open its settings
  Change Assistant Name from n8n-assistant to your actual assistant name (from Step 2.2)

  Step 8: Connect Credentials to Nodes

  8.1 Connect Facebook Credential

  Update these 3 nodes with your Facebook credential:

  Click on "Send Seen Indicator" → Select your Facebook Page Access Token credential
  Click on "Send Typing Indicator" → Select your Facebook Page Access Token credential
  Click on "Send Response to User" → Select your Facebook Page Access Token credential

  8.2 Connect OpenAI Credential

  Click on "OpenAI Chat Model" → Select your OpenAI API credential

  8.3 Connect Pinecone Credential

  Click on "Get context snippets in Pinecone Assistant" → Select your Pinecone API credential

  Step 9: Publish the Workflow

  Click Save to save the workflow
  Click the Publish button to make the workflow live
  Copy the webhook URL (e.g., https://your-n8n.com/webhook/facebook-messenger-webhook)

  Step 10: Configure Facebook Webhook

  Go to Facebook Developers → Your App → Messenger Settings
  Find Webhooks section
  Click Add Callback URL
  Enter:
     Callback URL: Your n8n webhook URL from Step 9
     Verify Token: Same value from Step 5
  Click Verify and Save
  After verification, subscribe to webhook fields:
     messages (required)
     messaging_postbacks (recommended)

  Step 11: Test Your Chatbot

  11.1 Add Test Users (if needed)

  With Standard Access, only users with app roles can message the bot:

  Go to your Facebook App → App Roles → Roles
  Add users as Testers
  Those users must accept the invitation

  11.2 Send a Test Message

  Open Facebook Messenger
  Search for your Facebook Page
  Try these test messages:
     "Hello!" - Should get a friendly greeting
     "What information do you have?" - Should search your documents
     "Tell me about [topic in your docs]" - Should return relevant information with context

  How Pinecone RAG Works

  User asks: "What are your return policies?"
           │
           ▼
  ┌─────────────────────────┐
  │  AI Agent receives msg  │
  └─────────┬───────────────┘
            │
            ▼
  ┌─────────────────────────┐
  │  Calls Pinecone Tool    │ → Searches your documents
  └─────────┬───────────────┘
            │
            ▼
  ┌─────────────────────────┐
  │  Gets relevant snippets │ ← "Return Policy.pdf: Items can be..."
  └─────────┬───────────────┘
            │
            ▼
  ┌─────────────────────────┐
  │  AI formulates answer   │ → "According to our policy, items can be..."
  └─────────────────────────┘

  Troubleshooting

  | Problem | Solution |
  |---------|----------|
  | "Pinecone Assistant Tool" not found | Ensure community node is installed (Step 1) |
  | "No relevant information found" | Upload more documents to your Pinecone Assistant |
  | Webhook verification fails | Check verify token matches in n8n and Facebook |
  | No response from bot | Check n8n execution logs for errors |
  | "Error validating access token" | Regenerate Page Access Token in Facebook |
  | AI Agent not using Pinecone tool | After import, open the "AI Agent1" node, make a small edit to the system message (e.g., add a space), and save. This re-initializes the tool bindings. |

  Customization

  Change the AI Behavior

  Edit the "AI Agent1" node's system message to:
  Adjust how it cites sources
  Change personality/tone
  Add specific instructions for your use case

  Change the Assistant

  Update the "Get context snippets in Pinecone Assistant" node to use a different assistant name.

  Adjust Response Length

  The workflow truncates responses to 1900 characters for Messenger. Edit the "Format Response" node to change this.

  Resources

  Pinecone Assistant Documentation
  Pinecone Assistant n8n Node (GitHub)
  Facebook Messenger Platform
  OpenAI API Documentation
  n8n Documentation

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.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.webhook","n8n-nodes-base.if","n8n-nodes-base.respondToWebhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.set","@pinecone-database/n8n-nodes-pinecone-assistant.pineconeAssistantTool","@n8n/n8n-nodes-langchain.agent"]

workflow_json_compressed:
  [encoded data, 8168 characters]

metadata_json:
  {"categories":["AI/ML","Communication","No-Code"],"complexity":"medium","use_cases":["Build custom Facebook Messenger chatbots","Improve chatbot responses using documents","Implement RAG for conversational AI","Create intelligent customer support bots","Enable document-based Q&A in Messenger"],"estimated_setup_minutes":25,"required_services":["Facebook Messenger API","OpenAI","Pinecone","Metabase (optional)","PostgreSQL (for n8n instance)"],"key_features":["Retrieval-Augmented Generation via Pinecone","Facebook Page integration","Document-based Q&A","Chatbot learning from external docs","Dual webhook handling"],"target_audience":["End-to-end developers","Marketing teams","Customer service managers"]}


name: Track SEC Form D filings and send issuer and investor data to Google Sheets
author_name: Naveen Choudhary
author_username: n8nstein
categories: []
created_at: 2026-01-20T14:52:20.473Z
updated_at: 2026-01-20T14:52:20.473Z
url: https://n8n.io/workflows/12851
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Who's it for

  This workflow is designed for venture capitalists, private equity professionals, investment analysts, and financial researchers who need to track private securities offerings and fundraising activities in real-time. It's particularly valuable for firms building deal flow pipelines, monitoring competitor fundraising, or conducting private market research.

  What it does

  This automation continuously monitors the SEC's EDGAR database for new Form D filings, which companies file when raising capital through private placements. Every 10 minutes during business hours (Monday-Friday, 6 AM - 9 PM), it checks for new filings, downloads the complete documents, and extracts critical information into a structured Google Sheets database.

  The workflow captures comprehensive details including company name and contact information, key executives and their roles, fund classification, target offering amount, current capital raised, total investor count, sale status, filing dates, and regulatory exemptions being utilized (such as Rule 506(b) or 3(c)(7)).

  How it works

  The workflow operates in five main stages:

  Stage 1 - Feed Monitoring: A scheduled trigger activates every 10 minutes during business hours, fetching the latest Form D filing feed from the SEC EDGAR system in XML format.

  Stage 2 - Initial Processing: The XML feed is parsed to extract basic filing metadata including CIK numbers, company names, form types, and document URLs. The system then filters out any previously processed filings using deduplication logic and adds only new filings to your Google Sheet tracking database.

  Stage 3 - Selective Processing: The workflow identifies unprocessed Form D and Form D/A (amendment) filings that need detailed extraction, filtering out other form types and already-processed entries.

  Stage 4 - Deep Data Extraction: For each unprocessed filing, the workflow downloads the complete Form D text document, parses the embedded XML structure, and systematically extracts four categories of information: issuer details (company name, address, CIK, jurisdiction, entity type, industry classification), key personnel (executives, directors, promoters with their specific roles), offering information (total offering amount, amount already sold, remaining amount, investor count, accredited investor status), and regulatory details (exemptions claimed, sale status, offering duration).

  Stage 5 - Database Update: All extracted data is consolidated into a summary format and used to update the corresponding row in your Google Sheet, marking the filing as "processed". A wait node introduces a brief delay between document retrievals to comply with SEC rate limiting policies.

  Requirements

  To use this workflow, you'll need:

  A Google Sheet configured with these specific columns: cikNumber, title, formType, filingLinkHtml, filingLinkTxt, updated, companyName, keyExecutive, executiveRole, fundType, targetAmount, amountRaised, investorCount, salesStatus, filingDate, exemptions, status, and comment

  Google Sheets OAuth2 credentials connected in n8n to enable read/write access

  Compliance with SEC EDGAR requirements: you must update the User-Agent headers in both HTTP Request nodes (replacing the placeholder email with your own valid email address as required by SEC's fair access policy)

  Setup instructions

  Step 1: Create or prepare your Google Sheet with the exact column structure listed in the requirements section. Note your Google Sheet ID from the browser URL.

  Step 2: In n8n, configure your Google Sheets OAuth2 credentials through the credentials panel. Test the connection to ensure it's working properly.

  Step 3: Open both Google Sheets nodes in the workflow ("Add New Filing to Tracking Sheet" and "Update Filing Status in Sheet"). Update the Document ID field with your Google Sheet ID.

  Step 4: Critical compliance step - Open both HTTP Request nodes ("Fetch SEC Form D Feed" and "Retrieve Form D Document"). In the headers section, replace nchoudhary110792@gmail.com with your actual email address. The SEC requires this for their access logs.

  Step 5: Test the workflow manually first by clicking "Execute Workflow" to ensure everything connects properly and data flows to your sheet correctly.

  Step 6: Once verified, activate the workflow using the toggle switch. It will now run automatically on the configured schedule.

  Customization options

  Adjust monitoring frequency: Modify the Schedule Trigger node's cron expression to run more or less frequently. The default */10 6-21 * * 1-5 runs every 10 minutes during business hours on weekdays.

  Filter by fund type or size: Add a Filter (IF) node after "Consolidate Filing Data" to only process filings that meet specific criteria (e.g., offerings above $10M, specific fund types like hedge funds or venture capital).

  Add real-time notifications: Connect a Slack, Discord, or Email node after "Update Filing Status in Sheet" to receive instant alerts when high-priority filings are detected (based on criteria you define).

  Enrich with external data: Add HTTP Request nodes to query APIs like Crunchbase, PitchBook, or LinkedIn to supplement SEC data with additional company intelligence, funding history, or executive backgrounds.

  CRM integration: Replace or supplement the Google Sheets nodes with connections to your CRM (Salesforce, HubSpot, Pipedrive) to automatically create deal records or update company profiles when relevant filings appear.

  Historical analysis: Add a Set node to calculate metrics like month-over-month filing volume, average raise sizes by industry, or track specific companies' filing patterns over time.

  Multi-sheet organization: Use Router nodes to send different filing types to separate sheets (e.g., venture capital funds vs. hedge funds vs. real estate offerings) for easier analysis.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.xml","n8n-nodes-base.code","n8n-nodes-base.removeDuplicates","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.wait","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"]

workflow_json_compressed:
  [encoded data, 9224 characters]

metadata_json:
  {"categories":["Finance","Data Processing","Compliance"],"complexity":"medium","use_cases":["Monitor SEC Form D filings","Extract issuer and investor data","Track private securities offerings","Analyze competitor fundraising","Generate investment research reports"],"estimated_setup_minutes":45,"required_services":["SEC EDGAR Database","Google Sheets"],"key_features":["Real-time EDGAR monitoring","XML to JSON parsing","Static detail extraction","Deal flow pipeline integration","Compliance automation"],"target_audience":["Venture capitalists","Investment analysts","Financial researchers"]}


name: Monitor company budgets with Bexio, Google Sheets and Gmail alerts
author_name: Kamil Ostrowski
author_username: ostkam
categories: []
created_at: 2026-01-20T14:54:49.801Z
updated_at: 2026-01-20T14:54:49.801Z
url: https://n8n.io/workflows/12852
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  This n8n template allows you to automatically monitor your company's budget by comparing live Bexio accounting data against targets defined in Google Sheets, sending automated weekly email reports. It also exports your financial data from Bexio into a flexible spreadsheet environment.

  Financial overspending often goes unnoticed until it's too late. This workflow transforms reactive accounting into proactive management by automatically calculating monthly actuals and flagging budget overages in real-time, eliminating the need for manual spreadsheet updates.

  Who’s it for
  This workflow is built for Founders and CFOs who want to replace reactive accounting with proactive financial management. It is the ideal solution for leadership teams needing to eliminate manual data entry, synchronize live Bexio actuals against Google Sheet targets, and receive automated weekly email reports that proactively flag budget overages before they become critical issues.

  How it works
  The workflow automates the extraction and analysis of your Bexio accounting journal through several stages:

  Data Extraction: It uses a recursive pagination loop to fetch journal entries from the Bexio API in batches of 1,000 records.

  Data Synchronization: It utilizes the "Append or Update" operation in Google Sheets to ensure records stay current without creating duplicates.

  Financial Analysis: The system reads target thresholds from a "Budgets" sheet and aggregates costs per account by calculating the delta between Debits and Credits.

  Automated Reporting: A logic engine compares monthly actuals against budgets and generates a summary report sent via Gmail if thresholds are exceeded.

  How to set up
  Credentials: Connect your Bexio (Bearer Token), Google Sheets (OAuth2), and Gmail accounts in their respective nodes.

  Target Sheet: In the "Update Records" node, select your specific Google Spreadsheet and target tab for the journal entries. Use this template to create your database - Google Sheet Template

  Budget Configuration: Clone the template spreadsheet and define your specific metrics and monthly budget limits in the "Budgets" sheet.

  Date Filtering: Open the "Get Records" node and adjust the from and to query parameters (currently set for the 2025 fiscal year) to match your reporting period.

  Gmail: Enter the recipient email address in the "To" field of the Gmail node.

  Requirements

  Bexio Account: Must have API access enabled.

  Google Workspace: Access to Google Sheets for data storage and Gmail for sending reports.

  How to customize the workflow
  Budget: You can set budgets for as many metrics as you want for every accounting period.

  Sync Frequency: The "Schedule Trigger" can be adjusted from its weekly default to daily or hourly for more frequent updates.

  Notification Channels: Swap the Gmail node for Slack or Microsoft Teams to receive report via different channels.

  Rate Limiting: If processing a very large journal, increase the "Delay" node duration to remain within Bexio’s API rate limits.

  Pagination Reuse: The pagination logic can be adapted to retrieve any other Bexio data limited by API batch sizes.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6764 characters]

metadata_json:
  {"categories":["Finance","Communication","Data Processing"],"complexity":"medium","use_cases":["monitor company budgets","detect overspending","send automated reports","sync financial data to spreadsheets"],"estimated_setup_minutes":15,"required_services":["Bexio","Google Sheets","Gmail"],"key_features":["auto-calculates monthly actuals","flags budget overages","sends weekly email reports","extracts data to spreadsheet"],"target_audience":["finance managers","accountants","business owners"]}


name: Create Kling 2.6 ad videos and post them to YouTube using the YouTube API
author_name: Ari Nakos
author_username: just-aristides
categories: []
created_at: 2026-01-20T21:28:53.626Z
updated_at: 2026-01-20T21:28:53.626Z
url: https://n8n.io/workflows/12854
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  What it is
  An automated workflow for creating Kling 2.6 videos and posting them to YouTube.

  The workflow is divided into three main phases.

  Create Kling 2.6 Video
  Wait for Video Processing
  Post to YouTube

  Create Kling 2.6 Video
  This phase handles the initial video creation based on user input.

  Type Prompt: A form trigger allows the user to input details for the video, including:

  Prompt: A simple scenario for the video.

  Video Style: (e.g., Dialogue, Monologue, Advertisement, Documentary)

  Aspect Ratio: (e.g., 16:9, 9:16, 1:1)

  Videography (AI Refinement): Refines the user’s prompt into a detailed “script-to-screen” format suitable for video generation.

  FAL.AI Request: The refined prompt is sent to the Fal.ai Kling 2.6 model via an HTTP request to generate the video.

  Store Data: Details of the video request, including the date requested, the refined prompt, and the request URL, are stored in a Google Sheet.

  Wait for Video Processing
  Wait 5 mins: The workflow pauses for 5 minutes. This waiting period is necessary as it typically takes 3–5 minutes for the video to be ready after the generation request.

  Post to YouTube
  This phase focuses on generating YouTube SEO details and uploading the video.

  YT Video SEO (AI Generation): 
  An AI agent (using OpenRouter’s OpenAI GPT-5 Mini model) acts as a YouTube SEO specialist and viral content strategist. It generates the following details for the YouTube video:

  Video Title: A compelling title (less than 6 words).

  Video Description: A detailed description.

  Video Tags: Relevant tags to maximize discoverability.

  The AI agent is configured to follow guidelines for virality and YouTube’s tag limits.

  Structured Output: Parses the structured JSON output from the AI agent.

  Get Keywords: Extracts and formats the video tags into a comma-separated list suitable for YouTube.

  Fetch Video Credentials: Fetches the video URL and other credentials from Fal.ai.

  Download Video: Downloads the generated video file.

  Post on YouTube: The video is uploaded to YouTube using the generated title, description, and tags.

  Setup
  To run this workflow, you need to set up credentials in n8n for:

  OpenRouter: Generate API key from your OpenRouter account.

  Google Sheets: Uses OAuth 2.0. Connect by authenticating your Google account.

  YouTube Data API: Configure credentials to allow posting videos to YouTube.

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.formTrigger","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  H4sIAAAAAAAAE61X227bRhD9FYLPWnfv3PVTE6cpgiZ1EBspgiAI9jIrCZFIlaLgGIH+PUPZkCh5FclFXwyJHp49M3PmzOpHOYfOlZc/ymm97Fwd4E0sL0vlrUuJQojgWVVZFqj0VoALFQdhQVumWEhOi4oaayioaIV2HqygxptQjsoO5ouZ6+Cqhbi8gW61uGrwCXSAB3TtCtajsm4iLMvLz3h6fyoglNZeEepoIFKlREzgiXiXqhCkMyn0yLWbA0bfdE0LxSuH9PG0+0X/rDY12YDiO0u4GDfNeAY3E4BuiUGLZjntpk2NJzLLR8TQL/jQtYjXQYtEfqwfkD7it02cvFDr0SM7lSoporfEKiWIdJUmVoIhQUYpgXrBVbVjd4swxfsWU+6O0ktNO79tp+MxtPvsCNMjIoxEenfgJ03zbdMVKpKhyiCDaBSRFg93IVjCQ+A2BOc97xn8MiN+wbcZ0Sij0ogiODWIFyXxUGHlnbCGKcukkbuM/nHTrlDFHIVyNKM7jNlPRVL6WOhhJlUvK8Y0kdxhLXXSxAtWEeF1YpVx1HBxKhN2wbaZhEC9pC4RKQUQbBMn1hhHKo0qkt4bU7mhctpV6FYozOJ61S1Wgw79jgn9tktq5upxmLhpfdFsAt+7dgnt7v0DUXEzEtqcEhUbtEA7wbDmjBhROYL1psRw/KqDTVxoBi4ORPXiTfGyRTZn8J3Nryauu15A/QGp5wR2DtMtT8s1egAoUtFAiQzco/gZTioNglKpAanueP4JXfEX3N81bTyulYAfn2oFB/MUq131XLAhUhmIDb1sg40ETUKQiksWPBVch7Rj9em2+DiN0BQ3f1yfUUE3hrpXxtx9xyHtfYo/qWGebQtde39dv3bT2YPVPRGAxXHAUXkJ3R1A/QiPhaTb1KLgxkLE4TARFa28J05zHHirmYnKVynsCePr/yMMXqEvci7PVwan0ThvJFEqoSlRDjjKEHESpaaaJorGtCP6vll2RVMXn5rV7crDUXHcb/9/oA/Fn6FaiClxJiRxvvcGVXFijDREm8h44jywjc1sbWEavt0XfzcdsKPElpugPuZgopTNV64MTd31Srosy+NMY9KBWtx6UeNUSW2BODCaJDCCJc+YE4N2v4YuTB7F3O9XhJ+62fFRm3Td4gP8u4Jl99QHzqioHDiWwilDj6YEC+jRaj30mkxEaSMFC7g/9GBJbziOW7eY3J+hzc3ft7N5RpMP2/CEr+odSyms9yERTUPvq44Sa3FtR8eY9chfCrNj+aq5q2eNiw8lfX4Z+9vEM8sYg0F/wmVFoZ9vYdC6RGLoqlYoIWKoot4RfOe+QfH6xdsL3AA7Bv+h2efcedYYgaKtIfQvbjS8XTz42U2/9h1boT++w1PR4j7jBa4ncNRjn7wywutmhO/lJV1/+YIEtv51Cj+rp5Pwg6siHjDfHDQAzd5s5g92ug80vNXlkLL0skjDyBzSLzueRRxmkUPMtyYLtbe/c1gnDSgLu8cgB5u/N2SxDkY2h3Z012QBD6MHiI8aOrw0Pmh1eDE8bxT23jikket7Lrncr59sXsdalQM95oMZ4PX6J61CrSs7DgAA

metadata_json:
  {"categories":["Marketing","AI/ML","DevOps"],"complexity":"medium","use_cases":["Automate video generation","Schedule YouTube posts","Create ad content"],"estimated_setup_minutes":15,"required_services":["YouTube API","Kling 2.6","OpenRouter"],"key_features":["Prompt-based video creation","Automated YouTube scheduling","Multi-step video production pipeline"],"target_audience":["marketers","content creators","social media managers"]}


name: Extract and qualify local business leads and draft cold emails with OpenAI, Apify and Hunter
author_name: Chris Zhang
author_username: clissz
categories: []
created_at: 2026-01-20T21:49:22.304Z
updated_at: 2026-01-20T21:49:22.304Z
url: https://n8n.io/workflows/12855
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:55
description:
  AI-Powered Business Lead Scraping, Qualification & Outreach System

  Description
  Search → Scrape → Qualify → CRM → Email Draft Automation

  Categories: Lead Generation, Sales Automation, AI Enrichment, Revenue Ops

  This workflow automatically finds local businesses, extracts real contact details from their websites, qualifies them, and writes everything into a CRM — with personalized cold email drafts ready to send.

  It’s designed to remove the manual grind from lead sourcing and first-touch outreach.

  Search → leads → context → drafts → done.

  What This Workflow Does

  This automation takes raw local business results and turns them into usable, qualified leads:

  Pulls local business websites from a search dataset  
  Scrapes each site for real contact information  
  Normalizes emails, phones, names, and addresses  
  Qualifies leads based on reachability and ops signals  
  Writes clean, deduplicated records into a CRM  
  Generates human-sounding cold email drafts  

  No copying websites. No guessing emails. No messy spreadsheets.

  Why This Exists

  Most lead gen systems fail before outreach even starts.

  They rely on:
  Shallow scraped data  
  Guessy enrichment  
  Low-quality lists  
  Manual cleanup  

  This system fixes that by grounding everything in what actually exists on the business website, then using AI only where it makes sense.

  Human judgment at the edges. Automation in the middle.

  How It Works (High Level)

  1. Lead Source Ingestion (Apify Dataset)

  The workflow starts with a dataset of local business search results.

  This can be:
  Google search results  
  Industry-specific directories  
  Any Apify-powered source that includes URLs  

  Batch size is intentionally limited for safety.

  2. Website Scraping

  Each business website is fetched and stripped down to raw text.

  Failures are allowed — broken sites simply don’t qualify later.

  The raw content becomes the single source of truth.

  3. AI Contact Extraction & Normalization

  AI parses the site content to extract:
  Emails and phones  
  Company name and address  
  Contact people and titles  
  Social links and contact pages  
  Context snippets for traceability  

  Everything is normalized and returned as strict JSON.  
  If something isn’t clearly present, it stays empty.

  4. Lead Qualification

  Leads are scored based on:
  Reachability (email + website)  
  Basic operational signals  
  Optional social presence  

  Low-quality or unreachable leads are filtered out automatically.

  5. CRM Write (Google Sheets)

  Qualified leads are written into a lightweight CRM:

  Append-or-update by email  
  Safe to re-run  
  Easy to inspect and debug  

  This sheet becomes the system of record.

  6. Cold Email Draft Generation

  For each qualified lead, AI generates a personalized cold email draft:

  Casual, human tone  
  Uses real site context  
  Stored as drafts only  
  Never auto-sent  

  Perfect for review, sequencing, or export into an outreach tool.

  Tools Used

  n8n** — workflow orchestration  
  Apify** — lead sourcing  
  OpenAI** — extraction, qualification, email drafting  
  Google Sheets** — lightweight CRM  
  Hunter** — email verification  
  Tavily** — optional enrichment & validation  

  Who This Is For

  Automation and AI agencies  
  Consultants doing outbound  
  Freelancers selling repeatable services  
  Local-service lead gen operators  
  Anyone tired of low-quality scraped lists  

  Customization Notes

  Swap Google Sheets for Airtable, HubSpot, or Notion  
  Adjust qualification thresholds to control lead volume  
  Replace Apify source with any directory or search dataset  
  Plug drafts into any outbound sequencing tool  
  Extend metadata for analytics or CRM sync  

  Difficulty & Cost

  Difficulty: Intermediate  
  (Simple concept, careful execution)

  Estimated setup time: 30–45 minutes  

  Ongoing cost:  
  OpenAI + Apify + verification APIs only

  Summary

  This is not just a scraper.

  It’s a lead intelligence pipeline that turns raw search results into real, usable outbound opportunities.

  Search → scrape → qualify → CRM → drafts  
  No guessing. No junk leads. No manual cleanup.

nodes_used:
  ["n8n-nodes-base.html","n8n-nodes-base.filter","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@apify/n8n-nodes-apify.apify","n8n-nodes-base.manualTrigger","n8n-nodes-base.limit","n8n-nodes-base.httpRequest","n8n-nodes-base.splitInBatches","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.hunter","@tavily/n8n-nodes-tavily.tavily","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 11112 characters]

metadata_json:
  {"categories":["Lead Generation","Sales Automation","Marketing","Data Processing"],"complexity":"medium","use_cases":["scrape local business contact data","qualify leads with AI","draft personalized cold emails","sync leads to CRM"],"estimated_setup_minutes":25,"required_services":["Apify","OpenAI","CRM (e.g., HubSpot, Salesforce)","Google Sheets"],"key_features":["automated lead discovery","AI-powered lead qualification","email drafting automation","data enrichment"],"target_audience":["sales developers","marketing managers","revenue ops engineers"]}


name: Make outbound sales calls from Google Sheets using a Retell AI voice agent
author_name: Marcus Taylor
author_username: intellagents
categories: []
created_at: 2026-01-20T22:20:17.583Z
updated_at: 2026-01-20T22:20:17.583Z
url: https://n8n.io/workflows/12856
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  This n8n workflow automates outbound phone calls to new leads using Retell AI, with built-in timezone detection to ensure you're only calling during business hours.

  Use cases include appointment setting, lead qualification, follow-up surveys, payment reminders, and sales outreach—anywhere you need to scale phone conversations without scaling headcount.

  Good to know

  You'll need a Retell AI phone number and configured voice agent before using this workflow.
  Retell AI offers $10 free credit when you sign up (~73 minutes of calls). Create your account here.
  The timezone logic covers common country codes (UK, US, EU, Australia, India, UAE, Singapore, Japan). You can extend this in the Code node.

  How it works

  A new row in Google Sheets triggers the workflow (you can swap this for a webhook, form, or CRM trigger).
  The phone number is sanitised—stripping spaces, dashes, and brackets so it's in the correct format for dialling.
  The lead's timezone is determined from their country code, and the workflow checks whether it's between 8am-5pm local time. If not, it waits and retries.
  Retell AI places the outbound call using your configured voice agent.
  The workflow polls Retell's API until the call ends, then retrieves the transcript. You can replace this with a Retell webhook if you'd rather.
  The Google Sheet is updated to mark the lead as "Called", as well as entering the call summary, transcript, call sentiment, and other useful details from Retell's call logs.

  Requirements

  Retell AI account with a phone number and voice agent
  Google Sheets with columns: Phone Number, Name, Status

  Customising this workflow

  Change the trigger**: Replace Google Sheets with a webhook, n8n form, or CRM trigger (HubSpot, Pipedrive, etc.)
  Adjust calling hours**: Modify the IF node to change the 8am-5pm window
  Expand timezone coverage**: Add more country codes to the mapping in the "Get lead's timezone" Code node
  Add your own AI analysis**: We currently use Retell AI's default call summary - but you could add an agent that extracts different insights (e.g., buying signals, objections)
  Route the output elsewhere**: Send results to Slack, a CRM, email, or Airtable instead of updating Google Sheets

  Built by Marcus Taylor (@intellagents / voiceai.guide)

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  [encoded data, 5796 characters]

metadata_json:
  {"categories":["Communication","Sales Operations","Data Processing"],"complexity":"medium","use_cases":["appointment setting","lead qualification","follow-up surveys","payment reminders","sales outreach"],"estimated_setup_minutes":15,"required_services":["Retell AI","Google Sheets"],"key_features":["automated outbound calling","timezone-aware business hours","voice agent integration","lead data from spreadsheets","automated follow-up"],"target_audience":["sales teams","entrepreneurs","marketing managers"]}


name: 💾 Generate Blog Posts on Autopilot with GPT‑5, Tavily and WordPress
author_name: N8ner
author_username: n8ner
categories: []
created_at: 2026-01-21T04:55:19.669Z
updated_at: 2026-01-21T04:55:19.669Z
url: https://n8n.io/workflows/12858
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who Is This For?

   This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents.
  ​

  Whether you run a blog, SaaS, personal brand, newsletter, or client accounts, this tool helps you keep a consistent content pipeline without manually writing every article, creating images, and posting to each platform one by one.
  ​
  ​
  💪🏼 While the template is wired around classic blog + social media distribution, the underlying logic is universal. You can easily adapt it to any niche by editing prompts, swapping models, and re‑wiring nodes. You can plug in any LLM you like, from ChatGPT to Claude, Gemini, Mistral, DeepSeek, OpenRouter, or even local models through Ollama.
  ​

  What Problem Is This Workflow Solving?

  🤯 Most teams waste hours on the same repetitive loop: research a topic, gather links, write a blog post, craft social captions, generate visuals, upload everything to multiple platforms, and archive assets.
  ​
  ​
  💎 This workflow solves that by automating the full content chain—from research and blog‑post generation to image creation, publishing across channels, and logging everything in your content database—so your feeds stay active while you focus on strategy, not busywork.
  ​

  What This Workflow Does

  ✨ Generates in‑depth blog posts tailored to your topic and target audience, enriched with fresh references from the web via Tavily/SerpAPI search tools.
  ​
  ✨ Creates an image prompt and title from the article, generates the visual with OpenAI Images (gpt-image-1), and converts it into a ready‑to‑use image file.
  ​
  ✨ Automatically publishes content to your connected platforms (WordPress for blog posts, Telegram, X/Twitter, Facebook, LinkedIn) while saving images to Google Drive and logging each publication in Google Sheets for tracking.
  ​

  How It Works?

  Surprisingly simple ☺️

  The workflow is triggered by another n8n workflow or by one of several triggers (Facebook, RSS, Google Sheets, Airtable, Postgres) that pass in the blogTopic, targetAudience, and Telegram chatID.
  ​
  ​
  The Blog Post Agent (LLM with access to Tavily/SerpAPI) researches the topic, writes a structured article for the specified audience, and sends its output to the Image Prompt Agent, which turns the content into a visual prompt and title.
  ​

  🎯 The end result: you provide a topic, run the workflow, and receive a complete blog post, matching image, and ready‑made social posts shipped directly to your channels and archives—no manual copy‑paste.
  ​
  How to Customize This Workflow to Your Needs  

  🎨 Switch AI models and fine‑tune prompts so the agent can handle your exact formats: tutorials, case studies, listicles, product updates, thought‑leadership pieces, or campaign landing posts. 
  🔍 Refine research sources inside Tavily/SerpAPI to prioritize the domains, blogs, and docs your audience trusts, keeping posts accurate and up to date. 
  ⏰ Adjust posting cadence and schedules to align with peak engagement for your audience, mixing automated slots with manual “launch” runs for special announcements.  
  📱 Expand or trim channels as needed: keep just WordPress + LinkedIn, add Telegram as a content feed, or plug the workflow into additional automations like email campaigns or RSS feeds.
  📊 Use Google Sheets as your content hub to store ideas, angles, CTAs, references, and performance notes so you can double‑down on topics and formats that perform best.  
  🎬 Swap images for video by replacing the image generation node with video tools (for example, Runway‑style APIs) if your strategy is video‑first while keeping the same prompt pipeline. 
  💾 Build a reusable prompt library in Sheets, Notion, or Airtable so you can rotate proven prompt patterns each month and keep quality high without reinventing the wheel.  


  🤖 The system will continuously generate blog posts, visuals, and social updates and publish them across your selected platforms while archiving everything in Drive and Sheets—keeping your brand visible, consistent, and professional with minimal ongoing effort.

nodes_used:
  ["@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflowTrigger","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.lmChatMistralCloud","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatXAiGrok","@n8n/n8n-nodes-langchain.lmChatDeepSeek","@n8n/n8n-nodes-langchain.lmOpenHuggingFaceInference","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.lmChatOllama","@n8n/n8n-nodes-langchain.lmChatAzureOpenAi","n8n-nodes-base.apiTemplateIo","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolSerpApi","@n8n/n8n-nodes-langchain.lmChatAwsBedrock","@n8n/n8n-nodes-langchain.lmChatGroq","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.httpRequest","n8n-nodes-base.wordpress","n8n-nodes-base.twitter","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.linkedIn","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.facebookTrigger","n8n-nodes-base.rssFeedReadTrigger","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.airtableTrigger","n8n-nodes-base.postgresTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","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, 9996 characters]

metadata_json:
  {"categories":["Marketing","Content Creation","DevOps"],"complexity":"complex","use_cases":["automate blog post generation","schedule social media content","create visual assets for articles","publish to WordPress automatically","maintain consistent content pipeline"],"estimated_setup_minutes":45,"required_services":["WordPress","GPT-5","Tavily","Mistral Cloud","OpenRouter","Google Drive"],"key_features":["AI-driven content research","multimodal content generation","visual image creation","automated publishing workflow","scheduled dissemination"],"target_audience":["marketers","content creators","agencies"]}


name: Manage garage service reminders, pickups and feedback with Airtable, WhatsApp and Gmail
author_name: InfyOm Technologies
author_username: infyom
categories: []
created_at: 2026-01-21T07:32:57.848Z
updated_at: 2026-01-21T07:32:57.848Z
url: https://n8n.io/workflows/12861
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  ✅ What problem does this workflow solve?

  Garage and auto service businesses handle much more than just vehicle repairs — they manage service schedules, customer reminders, pickups, feedback, and repeat visits. When handled manually, this often leads to missed reminders, delayed pickups, unhappy customers, and lost repeat business.

  This workflow delivers a fully automated, end-to-end customer communication system for garages using n8n + Airtable + WhatsApp + Email, ensuring timely, professional, and consistent engagement at every stage of the service lifecycle.

  ⚙️ What does this workflow do?

  This automation suite consists of four interconnected workflows, each handling a critical touchpoint:

  WF-01: Scheduled Service Reminders
  Runs daily at 9 AM
  Identifies upcoming, due-today, or overdue services
  Sends branded reminders via WhatsApp + Email
  Automatically marks reminders as sent to avoid duplicates

  WF-02: Pickup Notification
  Triggers when service status changes to “Done”
  Instantly notifies customers that their vehicle is ready
  Sends confirmation via WhatsApp + Email
  Updates Airtable to track pickup notifications

  WF-03: Feedback Collection
  Triggers when service status becomes “Delivered”
  Sends a polite feedback request with a form link
  Uses WhatsApp + Email for higher response rates
  Ensures feedback requests are sent only once

  WF-04: Next Service Reminder
  Runs daily at 9 AM
  Tracks upcoming next-service dates
  Sends reminders for:
    Overdue services
    Services due today
    Upcoming services (next 7 days)
  Encourages repeat visits and long-term retention

  🧠 How it Works – High-Level Flow

  1. Central Data Source (Airtable)
  Airtable acts as the single source of truth for:
  Customer details
  Vehicle information
  Service status
  Service dates & next service dates
  Notification tracking flags

  2. Smart Triggers & Scheduling
  Schedule Triggers** run daily reminders automatically
  Airtable Triggers** react instantly to status changes (Pending → Done → Delivered)

  3. Personalized Message Generation
  Dynamic WhatsApp and Email messages are generated using customer, vehicle, and service data
  Messages are branded and context-aware (overdue, today, upcoming, completed, feedback)

  4. Multi-Channel Notifications
  WhatsApp** messages are sent via Twilio
  Email** notifications are sent via Gmail
  Customers are reached on their preferred channels

  5. Automatic Tracking & Deduplication
  Each step updates Airtable flags:
    Reminder sent
    Pickup notification sent
    Feedback sent
    Next service reminder sent
  Prevents duplicate messages and ensures clean automation

  🔧 Integrations Used

  Airtable** – Customer, vehicle, and service management
  Twilio WhatsApp API** – Instant customer notifications
  Gmail** – Professional email communication
  n8n Schedule & Trigger Nodes** – Time-based and event-based automation

  👤 Who is this for?

  Perfect for:
  🚘 Auto garages & service centers  
  🛠 Multi-location workshop chains  
  🚗 Car detailing & maintenance businesses  
  ⚙️ Agencies building automation solutions for automotive clients  

  🎯 Business Outcomes

  ✅ No missed service or follow-up reminders  
  ✅ Faster pickups and smoother operations  
  ✅ Automated feedback collection  
  ✅ Higher repeat visits and customer retention  
  ✅ Zero manual follow-ups for staff  

  🚀 Result

  This workflow transforms a garage into a fully automated, customer-centric service operation, ensuring every customer is informed, engaged, and encouraged to return — without adding operational overhead.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.airtable","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.twilio","n8n-nodes-base.gmail","n8n-nodes-base.airtable","n8n-nodes-base.airtableTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.twilio","n8n-nodes-base.gmail","n8n-nodes-base.airtable","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.airtable","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.twilio","n8n-nodes-base.gmail","n8n-nodes-base.airtable","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.airtableTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-base.twilio","n8n-nodes-base.gmail","n8n-nodes-base.airtable"]

workflow_json_compressed:
  [encoded data, 9532 characters]

metadata_json:
  {"categories":["Business Process Automation"],"complexity":"medium","use_cases":["automate customer service reminders","coordinate vehicle pickups","collect automatic feedback","reduce administrative overhead"],"estimated_setup_minutes":80,"required_services":["Airtable","WhatsApp API","Gmail","n8n"],"key_features":["end-to-end workflow automation","multi-channel customer communication","scheduled reminders system","customer feedback collection","automated workflow triggers"],"target_audience":["auto service managers","administrative staff","business owners"]}


name: KodoFlow - Futures & Options Trading Copilot
author_name: Paul Abraham
author_username: hellopaul
categories: []
created_at: 2026-01-21T08:48:05.431Z
updated_at: 2026-01-21T08:48:05.431Z
url: https://n8n.io/workflows/12864
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:21
description:
  This n8n template automates futures and options market intelligence by combining multi-timeframe price behavior, options context, and real-time news sentiment to deliver clear, risk-aware AI insights for US equity markets.

  Instead of producing noisy trading signals, KodoFlow focuses on market behavior, institutional conviction (or lack of it), and disciplined decision-making, including when waiting is the highest-edge outcome.

  Use cases
  Analyze US equity behavior across 15m, 1h, and 1d timeframes
  Detect regime alignment or divergence in futures and options markets
  Combine price action with options context to assess conviction
  Aggregate real-time news sentiment for contextual awareness
  Build a professional Telegram market intelligence assistant
  Power AI-driven trading dashboards or research tools

  Good to know
  This workflow integrates market data, options context, and news sentiment, then uses an AI model (Google Gemini or OpenAI) to generate market bias, stance, confidence level, and a risk-aware verdict. It does not provide buy/sell calls, price targets, or execution signals. KodoFlow is designed for analysis, clarity, and discipline, not hype. Setup typically takes 10 minutes.

  Requirements
  n8n Cloud or self-hosted instance
  MarketData API key (Steps given Inside)
  News API key (Steps given Inside)
  AI model API key (Google Gemini or OpenAI)
  Telegram Bot Token 

  Customising this workflow
  Replace Telegram with Slack, Discord, or Notion for alerts
  Adjust timeframes or add additional regimes
  Extend options logic for different expiries or strategies
  Add confidence thresholds for alerts or dashboards
  Adapt the workflow for crypto, forex, or index futures with minimal changes

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.telegramTrigger","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code"]

workflow_json_compressed:
  H4sIAAAAAAAAE62YW28jxRKA/8rID0egdYe+X/YJtMCCdLJcsvCCVqgv1c5o7bGxJ0BY5b9T42TX47jHHlu8JJbdU/3VvWo+TBbQ+snLD5O62bS+ifB9mrychMCS0F4GF6mQWfmEn6nkykvForeGgXcJgEcTpEpGJTzsQ2YyCim1mUwnLSxWc9/CqzWkzQ20d6tXS/wGWsAL2vUdPEwnzTLBZvLyN7y9u9VIISN3jAiUQ2TOifjgFJGG8QAq5qgoSm78AvD0TVvH9/fVm2ULrrvvftV929iGbMWS4Ddwtdke6s7gkdVyU7f1ssEbCROaTiXT7/Brv0aJLaw3nR3ismmhaVHU5OFR6q/4y/Yp9jD9SOqCytJLwrN0REbGiHPaolSuQAdJnQ070rcwhxneUb1d17MZrAdp26eDu3N9ZM7l1FKKxH9BuF0u329dpRg1gkdFhJecSO0tCUIJQimPCYxwJnTm2VPyQLEr/kk1bm1UPCliQkLVhALiLDj0SWSKod4uq51qP/r1BqpfmgTr+X3dzAZVi/hxXx/6pMxRsh1XVIZZFYB4BqinBENcNJqgvb3lVqoQ5Y5rR1S98k2aw6ZiajFId9u2q5/hjzvYtPuQgsqppvYUprwSvdigUaPxSBKcEQmcYhQDJZgoLAjDlHL6OOjtZZwjzNnn9IE5l6knmRuJgaM5CdYirKdSiZiclyc402Wczhxk3TFOq72ODANSWJeIVF6hKVnAEKDGq0QBjN1xvlmuF35e/wNH/b2BZ1zK6DF+FldylyiKMcatJyFptJ+yhlhpM/E8W2ZopN5CkWvYvUWsEW7dw2LWSGcY0bkzkoeAROhlpZkxhlqeUixiDXuziDXCi30s6aNTYNBaImJZ4coSG6QkMTslRRBeQK+sXMN6Bh8DbZBr0Z3aJ3NjDdYrLJYFiRAkqmyRTGAtZ9h10FLOGeNiDr1ajk0s1M1ptsN6x5i2U3vYcYZLngw2Z41V3SaFXVCGQKxnkWiTlLVSJ6dCMUN/untseBckJ+PnVRFrwHMjInHJo1+9xkIXfSTAbQLnQSNxr11gN65uVsu2elF98/eqXt+fYcAu6sbg7QwYaDZOoAE9CE9kMljiZJKEaow5wN9M7JW4H1bdRdWrW1831WfXfv0e2q9966/8avX5+da0bhxu35rYxDBtERMwWbsmh7WOukyAAksQZDC5V1O+hnX9J1SP3Jvqpp41fn5eSI70+M6klAebKBMku4xVz+KnYJIlIiiPDUPgyNGb0d7AX8M8x+NQntd1hQhMCGdJ9gItF6wmTnJDvLKBA3rasLzj+raeo8zqKN5AAI7g2lkL4wswgQUWE4qzAFYT4pMFwiOgsSDkKNK+taobHD7rBf6pvkJv3v/THxe/RMQvdphz38xiF61Xs+VyNofXsKib+llBZHwU8262xbzAFgaZ4HBAiXQ8kJATEGrB8MSSwbr9vFJ/9nEmePEpGl9srTucN4XizVTneGpHtOGdib3NSnpBCcV60wUkdmDpDaFARYaQgIee419vDVU9WqpL9ba6Rqb5CBvPF93x14OWZkYiPa4V402djDZdypOAIzuRzEpcI7AJxZCYRn2iT72m+O3/fqi+mnW7yWlY/3TugA8z/qR1d7b1WuiIoaAjRoHEFYcEwHLkErVSWs1A9fgwclP1ade5hs3Gz4a70MddZx+Sb3P/EbK/5UTnoosJKzk6G0kUZrbniaBOihrufE72nC1H4Z6JnQBIZh7lSY1NPwMQG4WIweAoaExx1Tx70+RKT4Xil+2ZuFFTrrttTljVLXeZBIUjJ1AaeHASRH/p6WGyiziZcBeCRhqt5DhwpmRwSJfRdAsxdomMnqMgMg2xCMrPBrVaXm5QmTQk3CeIECLj0I6wjqlui+RoXIODoHFFTnERJxOHU/I4UMA92yrMuuSwi0mHo7LvJmdPOU4BXjDtRRFUng2Kcynu4vagbo0DFTnEDDj7JR4xkwKXxGpcfE1MKWkeWY69TPru7fX/qxvf1K3f3j6++XKKlGPKF3/AE4jeQNx2ok6TbaPH/wusjSjrtw/bV09Dg8D21HRS40D99+QlfXj3Du/YVd+SnEG9yrJ6t5aknRwEilL3drmS2IGtal8YPxB2e7kw9ihs/2xJ2uBadUpTXPIvpnuS9vzuYXljxpziFc/Do3TFifZZlHvw+q0k+NS7sOeSp0efvL30wXTmg8+W2OFnRiTvwRvYkp2G32UWZR6gFmUeWXjLHj18oCR35K56CrznnGIdKr4dGi20XDjKb8KKQgcW3P8yQdkw/kBpGXjDWC5UA4X8v9TgqWAPbjZ4l69/71aDOywoT9/1W+DhWnFw/rlex8OvpN2pdxVF8500SbGlH+pTEP7w8C/ES4RI+xoAAA==

metadata_json:
  {"categories":["AI/ML","Finance","Trading"],"complexity":"medium","use_cases":["Analyze market behavior","Generate trading insights","Track institutional conviction","Monitor news sentiment","Manage risk exposure"],"estimated_setup_minutes":15,"required_services":["Google Gemini API","Telegram Bot API","Financial Data Provider","News API","Trading Platform API"],"key_features":["Multi-timeframe analysis","AI-powered sentiment analysis","Institutional signal detection","Risk-aware decision making","Automatic trade journaling"],"target_audience":["Traders","Financial Analysts","Algorithmic Developers"]}


name: Scrape high-engagement LinkedIn posts and auto-post with Gemini images
author_name: Roshan Ramani
author_username: rawsun007
categories: []
created_at: 2026-01-21T09:32:17.270Z
updated_at: 2026-01-21T09:32:17.270Z
url: https://n8n.io/workflows/12865
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Who's it for

  This workflow is ideal for:

  Content creators who want to replicate successful LinkedIn strategies
  Social media managers monitoring competitor content performance
  Marketing teams analyzing trending topics in their industry
  Personal brands looking to create data-driven content
  Agencies managing multiple LinkedIn accounts

  What it does

  This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement patterns, identifies trending topics, generates original AI-powered content based on those trends, creates accompanying images, and automatically publishes to your LinkedIn profile or company page.

  How it works

  Phase 1: Data Collection (Runs every 12 hours)

  Scheduler triggers the workflow twice daily
  Fetches LinkedIn profile URLs from Google Sheets
  Processes profiles in batches of 3 to respect API limits
  Uses Apify API to scrape recent posts from each profile
  Adds 3-second delays between requests to avoid rate limiting
  Filters for high-engagement posts (20+ likes, comments, or reposts)
  Saves viral posts to Google Sheets with full metadata

  Phase 2: Content Generation (Triggered by new data)

  Monitors Google Sheets for new viral posts every minute
  Filters posts published within the last 3 days that haven't been analyzed
  Aggregates trending content into a single dataset
  Analyzes patterns using Google Gemini AI to identify:
    Common themes and topics
    Engagement triggers and hooks
    Successful content structures
    Trending hashtags and formats
  Generates original LinkedIn post with proper formatting
  Creates AI image prompt optimized for minimal text
  Generates professional image using Google Imagen
  Publishes complete post to your LinkedIn account
  Marks analyzed posts as complete to prevent duplication

  Setup steps

  1. Configure Google Sheets

  Create a new Google Sheet with two tabs:
    Tab 1: "usernames & links" - Add LinkedIn profile URLs you want to monitor
    Tab 2: "scrape data" - Leave empty (auto-populated by workflow)
  Connect your Google Sheets credentials in both nodes
  Replace all instances of YOUR_GOOGLE_SHEET_ID with your actual sheet ID
  Replace SHEET_GID values with your actual sheet GIDs

  2. Set up Apify API

  Sign up for Apify account and get API token
  Replace YOUR_APIFY_API_TOKEN in "Scrape LinkedIn Posts API" node
  Note: Apify has free tier with limited requests

  3. Configure Google Gemini credentials

  Obtain Google PaLM API credentials
  Add credentials to both "Google Gemini Chat Model" and "Generate an image" nodes

  4. Set up LinkedIn publishing

  Connect your LinkedIn credentials in "Publish to LinkedIn" node
  If posting as organization, replace YOUR_LINKEDIN_ORGANIZATION_ID with your company page ID
  If posting as individual, change "postAs" parameter to "person"

  5. Configure scheduling

  Default schedule: every 12 hours
  Adjust "LinkedIn Content Automation Scheduler" trigger if needed
  Consider your API rate limits when changing frequency

  6. Test the workflow

  Manually trigger Phase 1 to scrape posts
  Verify data appears in Google Sheets "scrape data" tab
  Wait for Phase 2 trigger or manually activate it
  Check that content is generated and published correctly
  Verify posts are marked as analyzed in Google Sheets

  Requirements


  Google Sheets API access (free)
  Google Sheets Trigger OAuth2 (free)
  Apify API token (free tier available, $49/month for more)
  Google PaLM/Gemini API key (pay-per-use pricing)
  LinkedIn OAuth credentials (free)

  How to customize

  Adjust scraping targets:

  Add more LinkedIn profile URLs to your Google Sheets
  Change batch size in "Process Profiles in Batches" (default: 3)
  Modify post limit per profile in Apify API call (default: 1 post)

  Modify engagement filters:

  Edit "Filter High-Engagement Posts" node thresholds
  Default: 20+ likes OR 20+ comments OR 20+ reposts
  Adjust based on your niche's typical engagement rates
  Add additional criteria like views or impressions

  Customize content analysis window:

  Change "Filter Recent Posts (3 Days)" to analyze different timeframes
  Options: 24 hours for fast-moving trends, 7 days for broader patterns
  Balance between recency and data volume

  Refine AI content generation:

  Edit system prompt in "LinkedIn Content Strategy AI" node
  Adjust content length, tone, or style preferences
  Add industry-specific guidelines
  Include brand voice requirements
  Modify hashtag strategy

  Customize image generation:

  Edit image prompt structure in AI prompt
  Change visual style, colors, or composition
  Adjust for brand guidelines
  Modify dimensions or aspect ratios

  Change posting schedule:

  Adjust "LinkedIn Content Automation Scheduler" frequency
  Consider optimal posting times for your audience
  Balance between content quality and posting frequency
  Coordinate with other marketing activities

  Enhance data collection:

  Increase posts per profile in Apify settings
  Add more profile URLs to monitor
  Implement competitor tracking
  Track additional metrics like impressions or click-through rates

  Add notifications:

  Connect Slack/Email nodes after successful posts
  Set up alerts for high-performing content
  Create reports of analyzed trends
  Monitor API usage and errors

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.filter","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.filter","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.linkedIn","n8n-nodes-base.code","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.googleGemini","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, 9912 characters]

metadata_json:
  {"categories":["Marketing","AI/ML","Communication"],"complexity":"complex","use_cases":["scrape LinkedIn viral posts","analyze engagement patterns","auto-post AI-generated content","generate images with Gemini"],"estimated_setup_minutes":30,"required_services":["LinkedIn","Google Gemini","Google Sheets","OpenAI"],"key_features":["automated social listening","competitor content analysis","AI-powered image generation","scheduled content publishing"],"target_audience":["content creators","social media managers","marketing teams"]}


name: Auto-dub Viral Instagram and TikTok videos 📲 with Fal AI ElevenLabs dubbing 🎙️
author_name: Davide Boizza
author_username: n3witalia
categories: []
created_at: 2026-01-21T10:18:07.231Z
updated_at: 2026-01-21T10:18:07.231Z
url: https://n8n.io/workflows/12867
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  This workflow automates the process of dubbing videos using Fal AI's ElevenLabs integration and publishing them directly to Instagram and TikTok.

  This workflow is ideal for social media managers, content creators, and marketing teams who need to quickly localize and publish video content across multiple social platforms like Instagram and TikTok.

  Using this workflow, you can take a video in one language (e.g., English) and automatically generate a dubbed version in another language (e.g., Spanish) for publishing on Instagram and TikTok.

  The workflow supports multiple target languages through ElevenLabs, including but not limited to: English (en), Spanish (es), Italian (it), French (fr), German (de), and many others.

  Key Advantages
  ✅ Streamlined Social Media Localization  
     Automates the entire dubbing and publishing process specifically for Instagram and TikTok, two of the most popular social platforms.

  ✅ Rapid Content Adaptation  
     Quickly adapt existing video content for different language audiences without manual editing or voiceover work.

  ✅ Dual-Platform Publishing  
     Simultaneously publishes dubbed content to both Instagram and TikTok from a single workflow execution.

  ✅ Cost-Effective Content Repurposing  
     Maximizes the value of existing video content by making it accessible to international audiences with minimal effort.

  ✅ Consistent Brand Messaging  
     Maintains consistent audio quality and tone across different language versions using ElevenLabs' professional dubbing technology.

  ✅ Time-Saving Automation  
     Eliminates the need for separate dubbing, editing, and publishing steps—everything happens in one automated sequence.

  How It Works
  The workflow begins with a manual trigger that sets input parameters: video URL and target language for dubbing (e.g., es for Spanish).
  The video is sent to Fal AI's ElevenLabs Dubbing API, which processes the audio dubbing in the specified target language.
  The workflow waits 30 seconds to allow initial processing time.
  It then checks the dubbing status and continues waiting if not completed, or proceeds if ready.
  Once dubbing is complete, it retrieves the final dubbed video URL.
  The dubbed video file is downloaded.
  The video is processed in parallel:
     Uploaded to TikTok via Upload-Post.com API
     Uploaded to Postiz for Instagram publishing
  Finally, the workflow triggers Postiz to publish the content to Instagram with prepared metadata.

  Setup Steps
  Configure Input Parameters  
     In the Set params node, define:
     video_url: Direct URL to the source video
     target_audio: Language code (e.g., en, es, it) for dubbing

  Set Up Credentials  
     Ensure the following credentials are configured in n8n:
     Fal AI API (for ElevenLabs dubbing)
     Postiz API  (for Instagram publishing)
     Upload-Post API (for TikTok uploading)

  Customize Platform Settings
     For TikTok: Update YOUR_USERNAME and title in the Upload to TikTok node
     For Instagram: Configure channel ID and content in the Postiz nodes

  Adjust Wait Time if Needed  
     Modify the 30-second wait period based on your typical video length and processing requirements.

  Test the Workflow  
     Activate the workflow in n8n, click "Execute workflow," and monitor the execution to ensure all API connections and uploads work correctly.

  Ideal Use Cases
  Localizing promotional videos for different regional markets
  Creating multilingual versions of educational or tutorial content
  Repurposing successful video content for international audiences
  Maintaining consistent social media presence across language-specific accounts

  👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.

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

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-postiz.postiz","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5052 characters]

metadata_json:
  {"categories":["Marketing","Communication","Content Creation"],"complexity":"medium","use_cases":["Automated video dubbing","Multi-platform content localization","Social media video publishing"],"estimated_setup_minutes":5,"required_services":["Instagram","TikTok","Fal AI","ElevenLabs","Postiz"],"key_features":["AI-powered voice generation","Language localization","Direct social publishing","Workflow automation"],"target_audience":["social media managers","content creators","marketing teams"]}


name: Send new WooCommerce product notifications to Slack, Gmail and Google Sheets
author_name: WeblineIndia
author_username: weblineindia
categories: []
created_at: 2026-01-21T13:20:49.425Z
updated_at: 2026-01-21T13:20:49.425Z
url: https://n8n.io/workflows/12872
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Retail – New Product Drop Notifications

  This workflow automatically detects when a new product is created in WooCommerce and instantly notifies internal teams through Slack and email. At the same time, it logs all product details into Google Sheets for tracking and reporting. A centralized data formatting step ensures consistent and reusable product data across all nodes.

  Quick Implementation Steps

  Import the workflow JSON into n8n.
  Connect WooCommerce, Slack, Gmail and Google Sheets credentials.
  Review the Format Product Details node for field mappings.
  Select the Slack channel and Google Sheet.
  Activate the workflow.

  What It Does

  This workflow listens for new product creation events from WooCommerce. When a product is created, the workflow extracts key product attributes such as name, price, status, permalink and images and prepares them in a single centralized configuration node.

  Using this standardized data, the workflow sends a real-time Slack notification to inform internal teams, sends a formatted HTML email announcing the product launch and appends the same product information into a Google Sheet for historical reference and reporting.

  By centralizing data preparation and reusing it across all downstream nodes, the workflow remains easy to maintain, highly readable and simple to extend for future requirements.

  Who’s It For

  This workflow is ideal for:
  E-commerce teams using WooCommerce
  Marketing teams managing product launches
  Operations teams maintaining product logs
  Sales teams needing instant product visibility
  Business owners tracking new product releases

  Prerequisites

  To use this workflow, you need:
  An active n8n instance (self-hosted or cloud)
  WooCommerce REST API credentials
  Slack workspace with API access
  Gmail account with OAuth2 access
  Google Sheets API access
  A Google Sheet with predefined columns

  How to Use & Setup

  Import the workflow JSON into n8n.
  Configure WooCommerce – New Product Created with your WooCommerce credentials.
  Review the Format Product Details node to verify product field mappings.
  Configure Notify Team on Slack and select the target Slack channel.
  Configure Send Product Launch Email and update the recipient email if required.
  Configure Log Product in Google Sheets and select the target spreadsheet and sheet.
  Save and activate the workflow.

  Once activated, the workflow runs automatically whenever a new product is created in WooCommerce.

  How To Customize Nodes

  Format Product Details**
    Add or remove product attributes such as SKU, categories or tags.
    Modify how images are processed or stored.
  Slack Notification**
    Customize message format, emojis or mentions.
  Email Notification**
    Adjust branding, layout or additional product details.
  Google Sheets Logging**
    Add more columns like product ID, category or creator.

  Add-ons (Optional Enhancements)

  This workflow can be extended to:
  Prevent duplicate product entries in Google Sheets
  Route Slack notifications to different channels by category
  Send emails to multiple stakeholder groups
  Add approval or review steps before notifications
  Integrate with CRM or ERP systems
  Generate daily or weekly product launch summaries

  Use Case Examples

  Marketing teams receiving instant alerts for new product launches.
  Operations teams maintaining a centralized product creation log.
  Sales teams staying updated on new offerings.
  Business owners tracking product launch activity over time.
  Teams ensuring consistent communication across Slack, email and reports.

  There can be many additional use cases depending on business needs.

  Troubleshooting Guide

  | Issue | Possible Cause | Solution |
  |------|---------------|----------|
  | Slack message not sent | Invalid Slack credentials | Reconnect Slack API credentials |
  | Email not delivered | Gmail OAuth expired | Reauthorize Gmail account |
  | Google Sheet not updated | Sheet permissions missing | Verify Google Sheets access |
  | Images missing | Product has no images | Check WooCommerce product data |
  | Workflow not executing | Workflow inactive | Activate the workflow |

  Need Help?

  If you need help setting up, customizing or extending this workflow or want to build similar automations tailored to your business, our n8n developers at WeblineIndia can assist with advanced workflow design and automation solutions.

nodes_used:
  ["n8n-nodes-base.wooCommerceTrigger","n8n-nodes-base.set","n8n-nodes-base.slack","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4208 characters]

metadata_json:
  {"categories":["E-commerce","Communication","Data Processing"],"complexity":"medium","use_cases":["new product notifications","team updates","product logging"],"estimated_setup_minutes":20,"required_services":["WooCommerce","Slack","Gmail","Google Sheets"],"key_features":["real-time notifications","data logging","centralized formatting"],"target_audience":["retail managers","store operators","admins"]}


name: Find qualified leads in Reddit posts with Firecrawl and GPT-4.1-mini
author_name: Joseph
author_username: mjomba
categories: []
created_at: 2026-01-21T19:51:38.302Z
updated_at: 2026-01-21T19:51:38.302Z
url: https://n8n.io/workflows/12882
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Reddit Lead Generation Automation (Batch Processing Version)

  Overview
  Automatically find potential customers on Reddit who are actively looking for solutions like your product. This workflow analyzes your product website, generates targeted keywords, searches Reddit for relevant conversations, and filters them using AI to give you only the most qualified leads.

  What This Workflow Does

  Analyzes Your Product - Takes your product URL and uses Firecrawl to understand what your product does and who it's for
  Generates Smart Keywords - Uses AI to create 10 targeted keyword phrases based on problems your product solves
  Searches Reddit - Finds 10 recent conversations for each keyword (100 total posts)
  Filters with AI - Scores each conversation 1-10 and keeps only genuine leads (score 7+)
  Outputs Clean Report - Delivers a formatted markdown report with all qualified leads, sorted by relevance

  Perfect For
  Finding your first customers
  Product validation and market research
  Community management and engagement
  B2B/B2C lead generation
  Content creators looking for audience feedback
  Anyone wanting to find relevant Reddit discussions at scale

  How to Use

  Set Up Credentials:
     Firecrawl API key
     Reddit OAuth2 API credentials
     AI provider (Gemini, OpenAI, or Claude)

  Activate the Workflow

  Trigger via form triggger node

  Get Results:
     The workflow returns a complete markdown report with:
     Total qualified leads found
     Conversation titles and content
     Subreddit links
     Engagement metrics (upvotes, comments)
     Lead scores and reasoning
     Direct links to posts

  Key Features

  ✅ 100% Automated - No manual keyword research or scrolling through Reddit  
  ✅ AI-Powered Filtering - Only get conversations where people genuinely need your solution  
  ✅ Comprehensive Data - See engagement metrics, post content, and direct links  
  ✅ Customizable - Adjust filtering threshold, keyword count, posts per keyword  
  ✅ Time-Saving - Processes 100 posts in ~2 minutes vs hours of manual work  
  ✅ Smart Scoring - AI explains why each conversation is a good lead  

  Requirements

  APIs/Services:
  n8n (self-hosted or cloud)
  Firecrawl API (500 free credits/month)
  Reddit Developer Account (free)
  AI provider: Gemini (recommended, generous free tier), OpenAI, or Claude

  Credentials to Set Up:
  Firecrawl API Key
  Reddit OAuth2 API
  Google Gemini / OpenAI / Anthropic Claude

  Customization Options

  Adjust Search Parameters:
  Change Reddit search timeframe (month/week/day)
  Modify number of posts per keyword (default: 10)
  Add/remove keywords (default: 10)

  Modify AI Filtering:
  Adjust score threshold (default: 7+)
  Customize filtering criteria in the prompt
  Change AI model for different quality/cost balance

  Schedule Automation:
  Add a Schedule Trigger node to run daily/weekly
  Automatically email results
  Store leads in a database

  Tips for Best Results

  Start with known products to test the workflow (e.g., notion.so, slack.com)
  Review generated keywords after first run and adjust the AI prompt if needed
  Lower score threshold to 6 if getting too few results
  Focus on problem-based keywords rather than product names
  Check multiple subreddits by analyzing where your leads appear

  Use Cases

  SaaS Founders: Find people asking for tools in your category  
  Content Creators: Discover what your audience is discussing  
  Market Researchers: Validate product ideas and pain points  
  Community Managers: Monitor brand mentions and competitor discussions  
  Sales Teams: Generate warm leads from genuine product inquiries  

  Version Information

  This is the batch processing version - it runs completely within n8n and outputs all results at once. Perfect for:
  Manual trigger workflows
  Scheduled automation
  One-time research projects
  Learning and testing

  For a frontend-integrated version with progressive loading and real-time updates, check out my creator profile.

  Tags: reddit, lead generation, automation, AI filtering, web scraping, market research, sales automation, keyword research, firecrawl, gemini

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.aggregate","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.reddit","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.aggregate","n8n-nodes-base.aggregate","@mendable/n8n-nodes-firecrawl.firecrawl","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6496 characters]

metadata_json:
  {"categories":["Marketing","Data Processing","Customer Acquisition"],"complexity":"medium","use_cases":["generate product insights","extract target keywords","scrape Reddit threads","identify qualified leads","automate qualitative research"],"estimated_setup_minutes":15,"required_services":["Firecrawl","n8n","OpenAI (GPT-4.1-mini)","Reddit"],"key_features":["website analysis","keyword extraction","batch processing","Reddit conversation monitoring","AI-powered lead qualification"],"target_audience":["sales teams","marketing managers","product managers"]}


name: Send instant replies to new Yelp leads with LeadResponder.ai
author_name: Lead Responder
author_username: leadresponderai
categories: []
created_at: 2026-01-21T20:02:13.346Z
updated_at: 2026-01-21T20:02:13.346Z
url: https://n8n.io/workflows/12883
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  Automate replies for new Yelp leads. This workflow helps small businesses win clients through immediate engagement the moment they reach out and increasing revenue by 30%.

  How it works
  Yelp is monitored every minute for new leads. Once a lead is detected, an automated reply is sent immediately.

  Setup steps
  First, sign up at https://app.leadresponder.ai/ to obtain an API key. Then, enter the key into the workflow settings.

  Customization
  Upgrade from static messages to AI-generated personalization. Additionally, you can automate your scheduling by sending availability in your response.

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

workflow_json_compressed:
  H4sIAAAAAAAAE61Wa2/bNhT9K5y6ARsgOnrQengotixrUaPdErRNs64OCoq8spnIlCdSdt3A/32Xsuw5rYO12L5J5H2c+zqXd56S3sgbN5en51cfm0sGqbmRyydXeRJ5vjcHy73Rnae0sVwLGDvhgPGCBSKSQgrGhxABj7MiKINAFowHIZdpHsZBlkAR8qRIM1HmYSTyMklZnoWBt/E9zeeApt5CtaAvgEv6Esyi1hIa9Gr51Hijd9coVktwn3dbmAWP02GSZzRJi5SyoBzSDEqgWVkkrMyCYRzm3t74Ga8qYmsiZiBuiYYVqdCTcQ7WCyegM007D7TgBgYzaxcv4a8WjEWZRW2UVbVG71GQ+QGiWfAGLVtojMtJ21RowymZ0ckJX6iBM9/s4hhwdbLG8E46pyfoHo3WC2fSqWMODGj5DC87e7Zpwfdm3e/FPT+HXjERfXB/0NOLMX3+5K23ud5stiG9QZkOMRvEvserFV+b89YuWvsrd3UseWVg4/fJTJO4FBAN6TAOhpRFeUQzETIqwkBGPJc85uyfZF40gECAzMEYPgVS1g3Bo2r9YDoFft7PIwuTI3mcO7mR17T6HDvsad084WI2tjBH5Rtztr2daIF5szv37y18sOQxmXjPoKrqb8jrGde3pkeF+kpPSd3aAbkC4mA3sFSwcqfrunUyXZkJ15KsFLbJFCwpOLYJ9gtKEDOrG1utBxPvx4me6AZs22hyN9GEIJAlQucuqPdKjsi3N6bWPw0+Ofed7CHc0b2/id54n5Yt2tcm4zxnBcQ05GlMWSFSWoRlSaEYDmUUxixg8qA2rZntC8MN4dvKuFj4vu8HX9/3ScT+Q9/3gE52XYIWZrUL7uL81etjs/BLLde7QTgyGwVef8lkfFIH9LTkVetuHt/dPVAssnHV2Js4LNRx/Xt96JSvN//n9O4bIefAWJwDjZIkoqwMEppLkdAkF2ESgYiC+IDxXiHVybYC8rpR0yk03TyEZK50a2HLgw92gel1e9X7nRAc6YMGhbe7AU8wRV18pYLK4d66dFzbf433UuGRkMODkAXDNEZD7PikSChL44LmPIxpAUESIcUnaRYdhGyVuF2T32sLD4fWyfQiB1FRljCfxhn7LLaVknaGA5lGrqpqOrPeKM2Y75rLgsY/79Ej4rYXcduL7LfXRJ+2tp5zC90MKthykhvCTrpbBgOkK2XIqm5uy6pekRneGGLmbl8VrVEamwsVka6IQBPaGmJnTd1OZ0TN5yCVMw96ig04x1u8RF6ud5/rLQM6+uv4TWmBB8ZxH7Ig6BZIsSZx8N3AMdsjjOMZYlC2w2MmusOJ8Oa1VrZuQBLUata7LtqF00fiOBtZxv05JYkpFBakj64J71Mhez7Ce+NA7oNwBNtjeIUMuyDGwgIhPFWNsT4xaqoJnnJLdnTzGdU4kqsLyzFX6BGnitzC2iUYtI85woJ26cFDTATKup994g1Yi3kxexRnrUHI6mPHCxN9uZg2ONKkbOo5YsNTseNZ4xyfjukUNDRdjAvsnVrzqtcekFMpu07Dsq79bquIg6RsF1E/da44WBTHeu6TL7mqeKEqZR3s3c5yYWM778C+URLqif75HV7btoDr719cnV1extGfz4PTHz7bLjh3+CgQVi2hfwo4mt0mwPV877SCsf7t7GIvAh9AtC6M88a9zkbeMnSml1uz3YMQ33dxgM8GKoaAE8ugoEXJcyoylklIkyxmidfNjsbm6En/weeZexJgOXE+HV9u1/8XvD46HR/ZSMIHbxRsrh0jP6x31MtX7tGjLr+Eg485/9fX6hFvm83fEalka8ALAAA=

metadata_json:
  {"categories":["Marketing","Customer Service","Sales"],"complexity":"simple","use_cases":["Automate Yelp lead responses","Increase engagement with new prospects","Win clients through immediate replies","Boost revenue via instant messaging"],"estimated_setup_minutes":10,"required_services":["Yelp","LeadResponder.ai"],"key_features":["Real-time lead monitoring","Instant messaging automation","API key integration for external services","Schedule-based trigger for new notifications","Webhook-based outbound communication"],"target_audience":["small business owners","customer service managers","sales teams"]}


name: Generate Reddit customer leads from a product URL with OpenAI and Firecrawl
author_name: Joseph
author_username: mjomba
categories: []
created_at: 2026-01-21T20:02:28.684Z
updated_at: 2026-01-21T20:02:28.684Z
url: https://n8n.io/workflows/12884
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Reddit Lead Generator - Frontend Integrated (Productized Version)

  Overview
  Production-ready Reddit lead generation system with progressive data loading for optimal UX. This workflow integrates with a web frontend, sending results in real-time as they're processed instead of waiting for everything to complete.

  Key Features

  ✅ Progressive Loading - Users see results as they come in (website analysis → keywords → conversations)  
  ✅ 5 Response Stages - Data sent in batches for better UX  
  ✅ Webhook Authentication - Secured with API key headers  
  ✅ Frontend Ready - Built to work with the companion web app  
  ✅ Real-Time Updates - No waiting for 2-minute batch processing  

  What This Workflow Does

  Receives product URL from frontend via webhook
  Immediately responds "processing started"
  Analyzes website with Firecrawl → sends data to frontend
  Generates 10 keywords with OpenAI → sends to frontend
  Searches Reddit and filters conversations → sends in 3 batches
  Frontend displays results progressively as they arrive

  Response Flow

  Stage 1: website_analysis - Product details, favicon, summary  
  Stage 2: keywords_generated - All 10 keywords  
  Stage 3: conversations_partial1 - First keyword results  
  Stage 4: conversations_partial2 - Second keyword results  
  Stage 5: conversations_final - Remaining keywords (3-10) in markdown  

  Quick Setup

  Set Environment Variables in the "Set Environment Variables" node:
     BACKEND_API_URL - Your frontend API endpoint
     WEBHOOK_API_KEY - Your webhook security key

  Configure Credentials:
     Firecrawl API
     Reddit OAuth2
     OpenAI API

  Deploy Frontend & Backend:
     Clone repo: https://github.com/juppfy/leads-gen
     Deploy frontend on Vercel
     Deploy backend on Railway
     Full instructions in the repo README

  Activate Workflow and update your frontend with the webhook URL

  Requirements

  n8n (cloud or self-hosted)
  Firecrawl API key
  Reddit Developer Account
  OpenAI API key
  Frontend + Backend deployed (see GitHub repo)

  Resources

  📖 Complete Setup Guide: https://bit.ly/mediumarticleredditworkflow  
  🎥 Video Tutorial: https://bit.ly/youtubetutorialredditworkflow  
  💻 GitHub Repo: https://github.com/juppfy/leads-gen  

  Frontend Integration

  This workflow requires the companion web app to receive and display results. The frontend handles:
  User input and URL validation
  Real-time result display
  Conversation cards with pagination
  Request tracking by searchId

  Deploy instructions and complete code available in the GitHub repo above.

  Difference from Batch Version

  This Version (Frontend):
  Progressive data loading
  Real-time updates
  Production-ready UX
  Requires frontend deployment

  Batch Version:
  Single output at end
  No frontend needed
  Perfect for testing/scheduled runs
  Simpler setup

  Support

  Questions? Check the Medium article or YouTube tutorial first. Both have detailed setup instructions and troubleshooting tips.

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.reddit","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.reddit","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.reddit","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","@mendable/n8n-nodes-firecrawl.firecrawl"]

workflow_json_compressed:
  [encoded data, 14112 characters]

metadata_json:
  {"categories":["Marketing","Customer Support"],"complexity":"medium","use_cases":["Generate customer leads","Extract Reddit discussions","Dock into customer support workflows"],"estimated_setup_minutes":15,"required_services":["Reddit","OpenAI","Firecrawl","Node-RED or similar hosting environment for frontend"],"key_features":["Progressive result loading","Real-time data streaming","Website URL analysis","Conversation extraction and enrichment"],"target_audience":["marketing teams","customer success managers","product managers"]}


name: Transform chatbots into AI advisors with memory and real-time context
author_name: Yenire
author_username: yenire
categories: []
created_at: 2026-01-21T20:31:05.063Z
updated_at: 2026-01-21T20:31:05.063Z
url: https://n8n.io/workflows/12885
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  How it works
  • Receives a user message from a chat 
  • Uses an LLM node to understand user intent and generate a response
  • Retrieves and stores conversation memory in a database (Supabase)
  • Fetches real-time product or business data from an external API (e.g. Shopify)
  • Applies custom logic to ensure a consistent, human-like tone
  • Sends a contextual response back to the user

  Set up steps
  • Import the workflow into n8n
  • Create and connect the required credentials (LLM, database, API)
  • Configure environment variables and placeholders
  • Adjust the prompt and logic to your specific business needs
  • Test the workflow using sample user messages

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.shopify","@n8n/n8n-nodes-langchain.memoryPostgresChat","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"]

workflow_json_compressed:
  [encoded data, 5804 characters]

metadata_json:
  {"categories":["AI/ML","Data Processing"],"complexity":"medium","use_cases":["create autonomous AI advisors","implement conversation memory","integrate external business data","enhance chatbot intelligence"],"estimated_setup_minutes":360,"required_services":["Large Language Model API","PostgreSQL or Database API","e-commerce API (Shopify)","Telegram Bot API"],"key_features":["persistent conversation context","real-time data retrieval","custom tone management","multi-channel messaging"],"target_audience":["developers","technical founders"]}


name: Send a daily WooCommerce sales snapshot to Slack with Google Sheets logging
author_name: WeblineIndia
author_username: weblineindia
categories: []
created_at: 2026-01-22T10:21:00.129Z
updated_at: 2026-01-22T10:21:00.129Z
url: https://n8n.io/workflows/12901
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  Daily WooCommerce Sales Snapshot to Slack with Google Sheets Logging

  This workflow automatically collects WooCommerce sales data every day, calculates key sales metrics, sends a clean summary to Slack and logs the same data into Google Sheets for historical tracking. It helps teams stay informed about daily performance without manually checking dashboards or reports.

  Quick Implementation Steps (Get Started Fast)

  Import the workflow JSON into n8n.
  Connect your WooCommerce, Slack and Google Sheets credentials.
  Verify the Slack channel and Google Sheet selection.
  Activate the workflow.
  Receive daily sales updates automatically.

  What It Does

  This workflow runs on a daily schedule and fetches all recent orders from a WooCommerce store. It filters the orders to include only paid ones (Processing and Completed) and further narrows them down to those created within the last 24 hours.

  Using separate Code nodes, the workflow calculates essential sales metrics such as total revenue, number of orders, average order value (AOV) and the top-selling products. These metrics are merged into a single structured object for consistent downstream use.

  Finally, the workflow sends a formatted sales summary to a Slack channel for quick visibility and appends the same data as a row in Google Sheets. This creates a reliable daily log that can be used for trend analysis and reporting.

  Who’s It For

  WooCommerce store owners  
  Sales and operations teams  
  Marketing teams tracking daily performance  
  Business managers who prefer Slack updates  
  Analysts maintaining sales history in spreadsheets  

  Requirements to Use This Workflow

  Active WooCommerce store with API access  
  n8n instance (self-hosted or cloud)  
  Slack workspace with permission to post messages  
  Google Sheets document for logging data  
  Valid credentials configured in n8n for:
    WooCommerce
    Slack
    Google Sheets

  How It Works

  A Schedule Trigger runs the workflow once per day.
  Orders are fetched from WooCommerce.
  Only paid orders (Processing / Completed) are considered.
  Orders from the last 24 hours are filtered.
  Sales metrics are calculated:
     Total Revenue
     Order Count
     Average Order Value (AOV)
     Top Selling Products
  Metrics are merged into a single object.
  A formatted summary is:
     Sent to Slack
     Appended or updated in Google Sheets

  How To Set Up

  Configure the Schedule Trigger time.
  Add WooCommerce credentials.
  Review paid order filtering logic.
  Select Slack channel.
  Select Google Sheet and worksheet.
  Test the workflow.
  Activate it.

  How To Customize Nodes

  Change schedule time in the Schedule Trigger.
  Modify order statuses in the Filter Paid Orders node.
  Adjust the 24-hour window in the Code node.
  Increase or decrease top products count.
  Customize Slack message formatting.
  Add or remove Google Sheets columns.

  Add-ons (Optional Enhancements)

  Weekly or monthly summaries
  Revenue comparison (day-over-day / week-over-week)
  Revenue threshold alerts
  Multiple Slack channels
  Dashboard integrations from Google Sheets

  Use Case Examples

  Daily sales snapshot for store owners  
  Morning updates for sales teams  
  Automated sales logging for finance teams  
  Performance tracking without dashboards  
  Remote team visibility via Slack  

  Many more variations are possible depending on business needs.

  Troubleshooting Guide

  | Issue | Possible Cause | Solution |
  |------|---------------|----------|
  | Slack message not received | Slack credentials or channel issue | Verify Slack API and channel |
  | Google Sheet not updating | Incorrect sheet or mapping | Recheck sheet selection |
  | Orders missing | Order status filter too strict | Update filter conditions |
  | Revenue incorrect | Time filter issue | Verify last 24-hour logic |
  | Workflow not running | Workflow inactive | Activate workflow |

  Need Help?

  If you need help setting up, customizing or extending this workflow, our n8n automation experts at WeblineIndia can assist.

  We specialize in:
  n8n automation workflows
  Business process automation
  Custom integrations and reporting

  Contact WeblineIndia to build reliable and scalable automation tailored to your business.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.wooCommerce","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.slack","n8n-nodes-base.googleSheets","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, 4940 characters]

metadata_json:
  {"categories":["Marketing","Data Processing"],"complexity":"simple","use_cases":["monitor daily sales performance","automate sales reporting","track historical sales data","notify team on sales updates"],"estimated_setup_minutes":10,"required_services":["WooCommerce","Slack","Google Sheets"],"key_features":["scheduled data collection","custom sales metrics calculation","Slack notification integration","Google Sheets data logging"],"target_audience":["e-commerce managers","sales analysts","marketing teams"]}


name: Manage LinkedIn outreach sequences with Linked API and Google Sheets
author_name: Linked API
author_username: linkedapi
categories: []
created_at: 2026-01-22T13:19:13.386Z
updated_at: 2026-01-22T13:19:13.386Z
url: https://n8n.io/workflows/12915
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  Automate your LinkedIn outreach with this n8n workflow powered by Linked API. Sends connection requests, monitors acceptance, delivers your pre-written messages, and follows up automatically – all tracked in Google Sheets.

  How it works

    Connection phase – Sends connection requests to leads with status NEW, respects daily limits
    Monitoring – Checks if connections were accepted, expired, or declined
    Messaging – Sends your pre-written messages (up to 3) after connection is accepted
    Follow-up – Automatically follows up if no reply, marks leads as NO_RESPONSE after timeout
    Tracking – All statuses and timestamps are saved to Google Sheets

  Setup steps

    Copy the Google Sheet template

    Connect credentials:
       Google Sheets (OAuth2)
       Linked API (get key here)

    Configure DOCUMENT_LINK in the Config node (paste your spreadsheet URL)

    Add leads with Status = NEW and fill in Message 1, Message 2, Message 3

    Activate the workflow

  Configuration

  | Setting | Default | Description |
  |---------|---------|-------------|
  | DOCUMENT_LINK | – | URL to your Google Sheet |
  | SHEET_NAME | Leads | Name of the sheet with leads |
  | DAILY_CONNECTION_LIMIT | 25 | Max connection requests per day |
  | HOURS_TO_CHECK_IF_CONNECTION_ACCEPTED | 24 | Check frequency for connection acceptance |
  | HOURS_TO_CHECK_IF_REPLIED | 4 | Check frequency for message replies |
  | HOURS_DELAY_AFTER_CONNECTION_ACCEPTED | 24 | Delay before first message |
  | DAYS_DELAY_BETWEEN_MESSAGES | 2 | Delay between follow-ups |
  | DAYS_WAIT_FOR_CONNECTION_ACCEPTANCE | 10 | Timeout for connection requests |
  | DAYS_WAIT_AFTER_LAST_MESSAGE | 4 | Days to wait after last message before marking as no response |

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.filter","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.noOp","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.switch","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.noOp","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-linked-api.linkedApi","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","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, 12560 characters]

metadata_json:
  {"categories":["Marketing","Communication"],"complexity":"medium","use_cases":["automated LinkedIn outreach","connection request management","lead message sequencing","campaign tracking"],"estimated_setup_minutes":20,"required_services":["LinkedIn","Google Sheets"],"key_features":["sends connection requests","monitors connection status","delivers personalized messages","automated follow-up sequences","tracking in spreadsheets"],"target_audience":["marketing team","sales team","business development"]}


name: Generate scheduled B2B leads from Google Maps with Lemlist, Claude, and Pitchlane
author_name: Jannik Hiller
author_username: jannik-mtm
categories: []
created_at: 2026-01-22T14:45:20.076Z
updated_at: 2026-01-22T14:45:20.076Z
url: https://n8n.io/workflows/12920
scraped_at: 2026-05-02 08:04:51
metadata_generated_at: 2026-05-02 08:36:22
description:
  How it works

  Runs on schedule (Monday-Friday at 9 AM) to automate lead generation

  Searches for companies on Google Maps by location and category

  Extracts owner information from company websites and impressum pages

  Enriches leads with email addresses and LinkedIn profiles using Lemlist

  Generates personalized compliment messages using Claude AI

  Creates custom video messages with Pitchlane

  Uploads qualified leads to your CRM for follow-up

  Set up steps

  Configure Google Maps search parameters (location, category, search terms)

  Add Serper API credentials for Google Maps search

  Connect Lemlist for lead enrichment and upload

  Configure Pitchlane API credentials for video creation

  Set up Google Docs for documentation and notes

  Connect Claude AI for personalized message generation

  Adjust the schedule trigger time if you want a different time than 9 AM

  Keep detailed workflow notes in the sticky notes inside your workflow

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.anthropic","@n8n/n8n-nodes-langchain.googleGemini","n8n-nodes-base.code","n8n-nodes-base.googleDocs","n8n-nodes-base.code","n8n-nodes-base.lemlist","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 15072 characters]

metadata_json:
  {"categories":["Lead Generation","Marketing Automation","Data Processing"],"complexity":"medium","use_cases":["Automate B2B prospecting","Extract company contact info","Generate personalized outreach","Create video follow-ups","Qualify leads for CRM"],"estimated_setup_minutes":15,"required_services":["Google Maps","Google Gemini","Anthropic (Claude)","Lemlist","Pitchlane","CRM (e.g., HubSpot, Salesforce)"],"key_features":["Scheduled automated searches","Multi-source lead enrichment","AI-driven message personalization","Video outreach integration","CRM data synchronization"],"target_audience":["sales teams","marketing managers","business development reps"]}


name: Create AI YouTube SRT subtitles 📢 with ElevenLabs 🎧 and Google Drive
author_name: Davide Boizza
author_username: n3witalia
categories: []
created_at: 2026-01-22T19:25:27.071Z
updated_at: 2026-01-22T19:25:27.071Z
url: https://n8n.io/workflows/12924
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  This workflow is a simple yet brilliant automation designed to generate time-coded SRT subtitles starting directly from a video URL using ElevenLabs.

  With just a single video link, the workflow automatically extracts the audio, transcribes it using AI speech recognition, and converts the transcription into a properly formatted SRT subtitle file with accurate timestamps.

  This workflow automates the creation of SRT subtitle files for YouTube videos using AI speech recognition, eliminating the need for manual captioning and saving creators hours of work.

  It’s a fast, reliable, and fully automated solution, perfect for YouTube creators, video editors, and content producers who want to improve accessibility, engagement, and SEO with minimal effort.

  With just one input (a video link), the workflow:

  Downloads the video
  Automatically transcribes the audio using AI speech-to-text
  Intelligently splits the transcription into readable subtitle segments
  Generates a perfectly formatted SRT file with accurate timestamps
  Uploads the final subtitle file to Google Drive, ready to use

  It’s a lightweight, no-friction workflow that turns a raw video into professional subtitles in a fully automated way.

  Key Advantages

  1. ✅ Extremely Simple, Yet Powerful

  This workflow proves that automation doesn’t need to be complex to be effective.
  A minimal number of nodes delivers a complete end-to-end subtitle generation process.

  2. ✅ Automatic Time-Based SRT Generation

  Subtitles are not just plain text:
  they are properly time-aligned, making them immediately compatible with YouTube, video editors, and media players.

  3. ✅ Smart Subtitle Splitting

  The workflow intelligently splits text based on punctuation and length, producing subtitles that are:

  Easy to read
  Well-paced
  Aligned with natural speech flow

  4. ✅ Perfect for Video Creators

  This workflow is ideal for:

  YouTube creators**
  Content marketers
  Educators
  Podcasters
  Social video producers

  It dramatically reduces the time needed to add subtitles, improving:

  Accessibility
  Engagement
  SEO and watch time

  5. ✅ Fully Automatable & Scalable

  Once set up, it can be reused endlessly:

  One video or hundreds
  Manual trigger or automated pipelines
  Easy to extend with translations, publishing, or notifications

  This workflow automates the creation of SRT subtitle files from YouTube videos using AI speech recognition. 

  The process begins when the workflow is manually triggered, requiring a YouTube video URL as input. The system first fetches the video content via HTTP request, then sends the audio to ElevenLabs for transcription. 

  The AI returns timestamped text segments which are intelligently split into readable subtitle chunks based on punctuation and length constraints. 

  These segments are formatted into standard SRT (SubRip) format with precise timing, converted to a binary file, and finally uploaded to a specified Google Drive folder as a ready-to-use subtitle file.

  Set up Steps

  Configure Video Source: In the "Set Video Url" node, replace the placeholder value with a valid YouTube video URL or set up a method to dynamically provide URLs
  API Credentials Setup:
     Configure ElevenLabs API credentials in the "Transcribe audio or video" node with your API key
     Set up Google Drive OAuth2 credentials in the "Upload file" node with appropriate folder permissions
  Customize Output: Adjust the SRT generation parameters in the "From Elevenlabs to Srt" node if different subtitle formatting is needed
  Destination Folder: Verify the Google Drive folder ID in the upload node points to your desired destination
  Execution: Trigger the workflow manually and provide a video URL when prompted to generate and upload subtitles

  👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.

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

nodes_used:
  ["n8n-nodes-base.manualTrigger","@elevenlabs/n8n-nodes-elevenlabs.elevenLabs","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleDrive","n8n-nodes-base.set","n8n-nodes-base.httpRequest","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, 4744 characters]

metadata_json:
  {"categories":["AI/ML"],"complexity":"complex","use_cases":["Auto-generate subtitles","Transcribe video audio","Extract video links","Convert to SRT format","Upload subtitles to drive"],"estimated_setup_minutes":5,"required_services":["ElevenLabs","Google Drive","YouTube"],"key_features":["AI Speech Recognition","SRT Timestamp Generation","URL Parsing","Automated Format Conversion","Drive Upload"],"target_audience":["Content Creators","Video Editors","Media Managers"]}


name: Generate AI video clips from YouTube using Reka Vision API and Gmail
author_name: Frank Boucher
author_username: fboucheros
categories: []
created_at: 2026-01-22T22:03:33.812Z
updated_at: 2026-01-22T22:03:33.812Z
url: https://n8n.io/workflows/12926
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:20
description:
  Try It Out!
  This n8n template demonstrates how to use Reka API via HTTP to AI generate a clip automatically from a YouTube video and send email notifications.

  How it works
  Looking at the RSS feed of a YouTube channel, the flow will be triggered when there is a new video published.
  Using Reka's API, we will submit a request for creating a clip using AI. You can customize: 
    the prompt to generate the clip
    decide if you want captions or not
    decide the minimum or maximum duration of the clip
    
  Wait a little while, the magic happens
  Check if the job status is completed
    If yes, it send an success email
    If no, it will loop
    As a failsafe, after 10 iterations in the loop, it will send an error email 

  🔧 Configurations

  After importing the template, here is some information to customize your clips the way you like them.

  🔘 When New Video

  Set the Feed URL to the YouTube channel you want to follow 
  ex: https://www.youtube.com/feeds/videos.xml?channel_id=UCAr20GBQayL-nFPWFnUHNAA

  🔘 Create Reel Creation Job

  This API call will upload the video into your Reka's library and create a job for the clip.

  Parameters

  video_urls (string, required): URLs of input videos
  prompt (string, required): Description of the reel to generate

  generation_config

  template (“moments” | “compilation”, default: “moments”)
  num_generations (integer, default: 1)
  min_duration_seconds (integer, optional)
  max_duration_seconds (integer, optional)

  rendering_config

  subtitles (boolean, default: true)
  aspect_ratio (string, default: “9:16”) examples: “9:16”, “16:9”, “1:1”, “4:5”

  Example of a complete JSON

  {
    "video_urls": ["{{ $json.link }}"],
    "prompt": "Create an engaging short video highlighting the best moments",
    "generation_config": {
      "template": "moments",
      "num_generations": 1,
      "min_duration_seconds": 0,
      "max_duration_seconds": 30
    },
    "rendering_config": {
      "subtitles": true,
      "aspect_ratio": "9:16"
    }
  }

  🔘 Send Clip Ready EMail

  Using the information of all previous nodes, customize an email that contains all the information the way you like.

  Here is an example:
  Hello! Your clip is ready to be downloaded. 

  Title: {{ $('Check clip job status').item.json.output[0].title }}  

  Download it here: {{ $('Check clip job status').item.json.output[0].video_url }} 

  Description: {{ $('Check clip job status').item.json.output[0].caption }}

  Requirements
  Reka AI API key (it's free! Get yours from here from Reka)
  Gmail account (feel free to change it to another mail provider)

  Need Help?
  Join the Discord

  Happy clipping!

nodes_used:
  ["n8n-nodes-base.rssFeedReadTrigger","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.if","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.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.wait"]

workflow_json_compressed:
  [encoded data, 4416 characters]

metadata_json:
  {"categories":["AI/ML","Communication"],"complexity":"medium","use_cases":["automate video clip generation","send video clip notifications","monitor YouTube channel updates","create social media content clips"],"estimated_setup_minutes":15,"required_services":["Reka API","YouTube RSS Feed","Gmail API"],"key_features":["AI-driven video clipping","RSS-based automation triggers","customizable clip parameters","automatic email notifications","format customization options"],"target_audience":["content creators","social media managers","marketing teams"]}


name: Generate and post Apple App Store review replies with Anthropic Claude
author_name: Ertay Kaya
author_username: ertay
categories: []
created_at: 2026-01-22T23:48:52.510Z
updated_at: 2026-01-22T23:48:52.510Z
url: https://n8n.io/workflows/12927
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  Generate and post Apple App Store review replies with Anthropic Claude, Google Drive and App Store Connect API 
  This workflow empowers app developers and community management teams by automating the generation and posting of responses to user reviews on the Apple App Store. Designed to streamline the engagement process, it drastically reduces the manual workload on community managers by integrating AI-driven responses with necessary human oversight. By leveraging n8n's workflow automation capabilities, this solution eliminates the need for costly third-party platforms like AppFollow or Appbot, making it a cost-effective and efficient alternative.

  Pre-requisites
  Google Drive & Google Sheets access: To store and manage review spreadsheets.
  App Store Connect API credentials: To fetch and respond to app reviews.
  LLM credentials (e.g., Anthropic): Required for generating responses.
  Slack account

  Workflow steps
  1. Initialise and trigger workflow: The process begins daily at 10 AM through a scheduled trigger.

  2. Fetch application data: Utilizes a data table (Apple App Store apps) to retrieve a list of applications with their app id and name, essential for identifying review sources.

  3. Collect App Store Reviews: Retrieves previous day's reviews from the App Store Connect API based on app data. Stores the reviews in Google Sheets for further processing.

  4. Generate AI Responses: AI model generates initial responses based on review content. Responses are structured and stored along with reviews within a Google Spreadsheet located in a Google Drive folder called ToReview. A Slack message is sent with the URL of the file

  5. Human Review & Modification: Community managers review and refine AI-generated responses. Reviewed spreadsheets are moved to the ToSubmit Google Drive folder by the editor.

  6. Post Verified Responses: Workflow triggers again at 5 PM to access reviewed spreadsheets in ToSubmit folder. It posts the human-verified responses back to the respective reviews on Apple App Store using App Store Connect API. Logs are maintained, recording each response's success or failure.

  7. Archive processed spreadsheets: After posting the responses, workflow moves the processed files from ToSubmit  to a different folder called Archived

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.scheduleTrigger","n8n-nodes-base.jwt","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.slack","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.dataTable","n8n-nodes-base.splitInBatches","n8n-nodes-base.filter","n8n-nodes-base.sort","n8n-nodes-base.convertToFile","n8n-nodes-base.googleDrive","n8n-nodes-base.filter","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitOut","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.jwt","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.extractFromFile","n8n-nodes-base.googleDrive","n8n-nodes-base.dataTable","n8n-nodes-base.dataTable"]

workflow_json_compressed:
  [encoded data, 10764 characters]

metadata_json:
  {"categories":["Communication","App Development","AI/ML"],"complexity":"medium","use_cases":["automating app review responses","generating reply drafts","posting store feedback responses"],"estimated_setup_minutes":30,"required_services":["Anthropic API","Google Drive","App Store Connect API"],"key_features":["human-verified AI drafts","scheduled interactions","centralized document storage"],"target_audience":["community managers","app developers","customer support teams"]}


name: Create AI product review videos with Gemini, Veo 3, Blotato and Google Sheets
author_name: giangxai
author_username: giangxai
categories: []
created_at: 2026-01-23T03:26:03.318Z
updated_at: 2026-01-23T03:26:03.318Z
url: https://n8n.io/workflows/12929
scraped_at: 2026-05-02 08:04:49
metadata_generated_at: 2026-05-02 08:36:21
description:
  Overview

  This workflow automatically creates AI product review videos from a product image and short description using n8n and Veo 3.

  It connects content generation, image creation, video rendering, video merging, and publishing into a single automated flow. Once configured, the workflow runs end to end with minimal manual input.

  The workflow is designed for creators, marketers, and affiliate builders who want a reliable and repeatable way to produce short-form product review videos without manual editing.

  What can this workflow do?

  Automatically generate AI product review videos from product images
  Create review scripts and structured prompts using an AI model
  Generate product images and video scenes with AI services
  Merge multiple video scenes into a single final video
  Publish videos automatically to social platforms
  Track publishing results and errors in Google Sheets

  This workflow helps reduce manual work while keeping the video production process structured and scalable.

  How it works

  You start by submitting a product image and basic product information through a form. The workflow analyzes the image to understand visual context and key product features. An AI Agent then generates a review script along with structured image and video prompts.

  Next, image generation APIs create product visuals, and video generation APIs such as Veo 3 render short video scenes. All generated scenes are automatically merged into one final product review video. The finished video is then uploaded and published to platforms like TikTok, Facebook Reels, and YouTube Shorts. Publishing results are logged to Google Sheets for monitoring.

  Setup steps

  Connect an AI model (Gemini or OpenRouter) for script and prompt generation.
  Add image and video generation API keys (Veo 3 or compatible providers).
  Configure the video merge step (custom request or ffmpeg-based API).
  Add Blotato API credentials for automated publishing.
  Connect Google Sheets to log publishing results.

  Once set up, the workflow runs automatically without manual intervention.

  Documentation

  For a full walkthrough and advanced customization ideas, watch the detailed tutorial on YouTube.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.code","@blotato/n8n-nodes-blotato.blotato","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.formTrigger","@n8n/n8n-nodes-langchain.googleGemini","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.splitInBatches","n8n-nodes-base.aggregate","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@blotato/n8n-nodes-blotato.blotato","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 11860 characters]

metadata_json:
  {"categories":["Marketing"],"complexity":"medium","use_cases":["generate product review videos","create short-form video content","automate social media posts","produce affiliate marketing videos"],"estimated_setup_minutes":25,"required_services":["Google Sheets","Google Gemini","Google Veo 3","Blotato"],"key_features":["image to video generation","AI script creation","automated video merging","spreadsheet data integration"],"target_audience":["content creators","marketers","affiliate marketers"]}


name: Scrape Google Maps business data with BrowserAct and Google Sheets
author_name: Kristian Ekachandra
author_username: aichandre
categories: []
created_at: 2026-01-23T09:29:27.927Z
updated_at: 2026-01-23T09:29:27.927Z
url: https://n8n.io/workflows/12937
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  Automatically scrape Google Maps business data using BrowserAct AI automation and save results directly to Google Sheets.

  🎯 What This Workflow Does:
  Collects business information from Google Maps based on location and category
  Extracts name, phone, rating, address, website, and latest reviews
  Automatically saves data to Google Sheets with deduplication
  User-friendly form interface for easy data collection

  🔧 Requirements:
  BrowserAct Community Node
  BrowserAct account
  Google Sheets OAuth2 credentials
  BrowserAct Google Maps Detail Scraper template

  ✨ Perfect For:
  Lead generation and prospecting
  Market research and competitor analysis
  Building business directories
  Local SEO research
  Sales outreach campaigns

  📊 Extracted Data Includes:
  Business Name
  Phone Number
  Category
  Rating
  Full Address
  Website URL
  Latest Review Summary

  💡 Easy Setup:
  Just fill in the form with your target location and business category, and let BrowserAct AI handle the scraping while results automatically populate your Google Sheets.

  🎥 Full tutorial on YouTube

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-browseract-workflows.browserAct","n8n-nodes-base.extractFromFile","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZ3W7byBV+lQlTNHEgyvwRKUpA0PonTt3YcdaW46SSEQxnhhIj/oUztOMEBnrT2y3Q7VVbIO3FPkKBRXvRd+kLbB6hZ4akSFlykE22V7FmDs/5zv+Zk/dazATWhu+1MOECJ4TtU22o2czzA6/XxwNs2dRkpukGhtejvucS1zACB/cD3zUxdkxi+9SkxGRBYHq+63p9l7paRxMsziIs2E7OKD9hosh2UjhhgoEAkRfsuqMlKWVcG45BupRKfcug/gDrPcPv672B6eo+GfT1ge0wYlm2PQhM4JzgmAH1UYKCNI8RL/w45DxMEyn1KpN3iZfoirnuY866km6Uh9Mpy4EmS3koJPlwbHSM8452yfxZms6V5pZF7YCaA51h29V71LJ0j1CqM5t4xLWdoG8YkgfOAYVgOZe2SzPJT/4JSilhoYgkjhOS4ywLkyk6xBnXysu9kEVUfXeBo6IyQCAPn5aaHaQEi1IfdXyAfRap8znmoZQeYcJmaURBn6H2WzzHOTixo+XsTRGCvZWE2srLvLcLHiaM81c74Jtpml/dFPKkPA/RdsiTkK9IO2YQJ0WOE3GLwPPr69IPz8E6ysxW15EwlI+ZF7gm6WPdGhBwtOUw3Wemr5vU69v9AbXZwGt8fFwkCKPLNJ8HUXqJcELRJQ6FdDwKBUc540Uk1vo9Ty85yzERev0571aHW0Qsh4Fl9VQgLHu1/k7FRd/pOYZjupbnOqY9cG2pfZEc4rdnAGgUSrgDw+hAHmWFeLbEqM0WXJ2seFnFARw9fP8e/eI1T5NufYmurzVpu+R2761+vEKluJyDWzClSmccLYJQeouAC1kiQhwpvI2ZtrJQ1QZpgcdvevnJy0C8ePTu+DlL7MZL2wt6hAlJi0QgS1uJAnMRAzRwLEosomObMcjz3kDHDDKeEOZ4tm30XNNvuD96K6QbUZCnMdoLIa9uS3NWUu4BYUXX8rHbt9b4uJW5K3i7DWKDOnbgOJ5u9mwTyhPA9gdOT3c8x4Vo8AMDqtoC8VaWMYhUiNEio+ACBPZBYYL4jLH1wSrRT9N0GrETScOXoXsDdw10kkZFnDR1RP4BSY7boTC+9+O//yMz/965jIGOthUBhViKli1KIY14eX8MUZdMl+7Lo/J6xCKWSUzaw3sLgmezNGHl/RnzAfVyNFZnJUFdXZYo2mHa0U4jzHGCRpC881mYL6cF5uKkiGNcxXRH42TGpM51D1EWWJiYi1yq09FoyKGMXZUlStatOL2QjSiAkGdNHVscVPRV0ayYUhZgKDeHWJDZgpLgZJudckZHaXVRl12Fp7bYZ0D6JISGz5egWJj9a2G0GH0Jjiq8vhbFgs2XYKhS4GsxLNh8CYY6T74WRMPnS1DczLSvRbPK76egggIXl8PSIRRF2SZYAG1sm0EL1uQdkMLlTl32xmVawmdYyGFTjNKdNLlguRiBFrwRVx6WDW+UnpS6lbdQQJZmtzQD7GXV1bCq4kf5qarhgECV71LV99qrV3lUmyUu8UYhF61+PA3pQzkqEgwlih6rSeVUfqTNhMj4cHOTpoRXZb9L0niTZznDVInhm3TTfLVt6wN6umW8eLoT5s/J1uBNrr9jJy+evHo3/91xeua9fSH6F98E0dYmg8Z+d53Iun5gPpf1EmQWMfR6OdSs1aKAk0aJ/xfUXxU8e8hnWPlizQjSboZHW4WYWe1R5PV8/sg8MnaSZG/vgu+JpvU+Vt+h8sN6GlmdRXrd/iILbNPs+5QOdBf7MJH6BtZx3zLgAUCJYfTJwPBas85jJtAuFq0ec6ONS4sdQ54wfmPI7PW8NV28UBHRdLi0EDA/dgOYX/jYqLr2J6aUXtdeaII9YhNMPZ05TgCayKeT61Pdo32v5zHi9Unr/XQiQjK/Qk9TcftExRVNRdLSRQdddGdgrc7MIRWQ0D3T7WgzFk5nMGs4pqWyUIB/QcTdu+jjhz9/j/bSSM70h1doZ4aThEV8kuymyT2B5HMOgSEQzL8PHmztq7kfgiCNVW4+eIAqbndqJjED2uEk+fjh2+/hk5dpMSp8NgTK8a9xSIA/zDjn9+tovry87F6BAKBR0dzQbCAkuXz3A3DZly/iKWj3ST5hTaU43WT07T+B0Sicj9L5J7mIcC7S+U0wE9D1wSRRFvvuX2iviCI0AjvkkCaTZHxnfCaLIhIzhi5CylJpsEr3hn0YT5eUvQg33UP7N1fB0ct3z/c3je7rbLrRkCvSrs/aRCUQ7faJ3qGuYbvY0CllNryaHQcmesfS4cyFFx0MyEF/beSZPz30HOuW2IOBOIVxsd9ZRKFnNFFompaxEoZ//fuPP/wRfVOAKKR2FOhxAYaU6u5AgROMIv9KOe5JDtU9hO72aI5L9+CWzaBXQCDMN9uuk367i/77tz+gE8EyZA6RCihwYeu9tJPGcZGEQlpDyq1JxmCN2+mWYyfJ4tdcuTbDZI6nbPPTz+AN+RYBN+dICqn3Pt0VxNYQwdtgCUVTpCcJ2AveNyWjcUPUYGtkd3G4Oa8MuIG2nu2jVrmXaADIqnwbLBZnaS7aEM7qXcCo2i+BzUoimQXjqv7LbQvaZQKHEVI7GJYvPlg2XguktGC9tdJlb2LNzzTQy5YEIwrXqeKs85KzbhmWqxsm/LvpWi4NyKBvOGbQcykZMGZQI7Btt2fZXh9vIJGWJlt9NK9aoFd6YLmprXNC2SKXrKqey7U9dqK0oBBECU+jlgFIedAl8rrd3jdudYozRLtFFoVEvmtrk6JfonJKQgeQBQDL7KJxQyZmIb+hhFhxxs85YZA0u4IMtLo1LBkbywBkeqDT44OFP8AGCaR7S+yK7u5QmjAIp0XO1sbk/u4kaUm8bM6lPeXR5DNXWhOtRAjo1OBbYgxVpLOlnKw5LVz18cOf/lHi7Q/BQ1ygfXFHueQIBlqFQu1NpfL3VZRM1uxSKwClFR9B0czRYid1n3Wn3Q58Vm0eJ9qG0qPeO6HFg35B2WwNgXiS2F10IkWJBZxJ0uvCIMCgECtVl70ljVNmG60MxKW6TXf8y+/R2QwLNJKhtpsyLi/LzF+EniwKUMr9GiX4CSPZa6jsm1GtndSEVAp0JD45hOBq+iBQnK8QxxdMsgLvLOHslqCesTxgRLlU9o4DCCg0ZUn1tOiAR/M55C0ownBOZh0YZ+KMiRAaO0jH0RUPeaeFE55cRDZ9VguoVmIAXI6iQ2kFXYXpwgNy6q8Py/3M0yL2WV6f1R6qf5cv6vpXtRKqf1avzPrnAXwLUXXMLkJ2iap1zG0TwrnquQkoUE2wzQQNf8c4lD1dLkXL18cnln2KVu5XKXurDY3rc7nQXKVfx/UzF3JrJaz5b4Z1In7qpnqtrM9ksk7+6rtkjYTr6/8BAqiPM/AZAAA=

metadata_json:
  {"categories":["Data Processing","Marketing"],"complexity":"medium","use_cases":["Scrape Google Maps listings","Extract business reviews","Automate lead collection","Populate spreadsheet databases"],"estimated_setup_minutes":30,"required_services":["BrowserAct","Google Sheets"],"key_features":["AI-driven web automation","Form-based data input","Automatic deduplication","Review extraction"],"target_audience":["data analysts","marketing teams","business researchers"]}


name: Create and publish SEO blog posts using Google Sheets, Gemini/OpenAI, Ideogram, and WordPress
author_name: Incrementors
author_username: incrementors
categories: []
created_at: 2026-01-23T12:59:25.213Z
updated_at: 2026-01-23T12:59:25.213Z
url: https://n8n.io/workflows/12939
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:22
description:
  This workflow automates the complete blog publishing process. It removes manual work from content creation, image generation, category management, and WordPress publishing by using AI and n8n. It helps agencies, SEO teams, and content creators manage blogs at scale.

  Key Features

  Scheduled or manual blog publishing
  Automated topic research and content writing
  AI-generated featured and in-content images using Ideogram
  Dynamic WordPress category detection and creation
  Automatic media upload with SEO-friendly alt text
  Internal linking using sitemap data
  Google Sheets logging for published URLs
  Error notifications for failed executions

  What This Workflow Does

  Input

  Blog topics or keywords stored in Google Sheets
  Target WordPress site details
  Publishing rules and schedule

  Processing

  Triggers the workflow on a schedule or manual run
  Fetches blog posting data from Google Sheets
  Validates active projects or websites
  Performs topic and SEO research
  Writes long-form, SEO-optimized blog content
  Generates image prompts and creates images using Ideogram
  Uploads images to WordPress with alt text
  Detects or creates blog categories dynamically
  Publishes the blog post to WordPress

  Output

  Live published blog post URL
  Updated Google Sheet with publishing details
  Notification alerts if any step fails

  Setup Instructions

  Prerequisites

  n8n instance (cloud or self-hosted)
  WordPress site with REST API access
  Google Sheets access
  AI model credentials (Google Gemini, OpenAI, or DeepSeek)
  Ideogram API access
  Notification service (Discord or Slack)

  Step 1: Import the Workflow

  Download or copy the workflow JSON
  In n8n, go to Workflows → Import from file / JSON
  Import the workflow

  Step 2: Configure Credentials

  Set up the required credentials inside n8n's credential manager:

  Google Sheets OAuth**: For reading posting data and saving URLs
  WordPress API**: For publishing posts and uploading media
  AI Model**: Connect Google Gemini, OpenAI, or DeepSeek
  Ideogram API**: For AI image generation
  Discord/Slack Webhook**: For error notifications

  Important: No credentials are hardcoded. All must be connected via n8n's credential manager.

  Step 3: Configure Google Sheets

  Prepare a Google Sheet containing:

  Blog topic or keyword
  Target website or domain
  Publishing status fields
  Domain ID for tracking

  Update the Sheet ID inside the Get_Post_Data node after import.

  Step 4: Configure Website Access

  Update the PBN_Website_Access node with your WordPress site access endpoint or API. This node should return:

  Complete WordPress URL
  Basic authentication token
  Sitemap post URL

  Step 5: Configure Publishing & Schedule

  Adjust the Schedule Trigger if auto-publishing is required
  Modify publishing frequency or time zone
  Review WordPress post status (draft or publish)

  Step 6: Test & Activate

  Add one test row in Google Sheets
  Run the workflow manually
  Verify:
     Content creation
     Image generation
     WordPress publishing
     Sheet updates
  Activate the workflow

  Usage Guide

  Adding New Blog Posts

  Add a new row in the connected Google Sheet with the required blog topic and website details. The workflow will automatically process and publish the post on the next execution.

  Understanding the Output

  After execution, the workflow:

  Publishes a complete blog post on WordPress
  Attaches featured and in-content images
  Assigns the correct category
  Logs the live URL back to Google Sheets

  Workflow Node Breakdown

  Get_Post_Data
  Fetches blog posting details from Google Sheets based on the current day. It pulls keywords, landing pages, domain IDs, and posting websites.

  get_client_status
  Checks the client's project status from the project sheet. It verifies whether the client is active or inactive before proceeding further. This prevents publishing content for paused or stopped clients.

  PBN_Website_Access
  Fetches WordPress website access details such as site URL, authentication token, and sitemap URL. These details are required for publishing posts, uploading images, and managing categories.

  Do the Research on the Topic
  Performs deep SEO research on the target keyword. It analyzes search intent, content gaps, and audience needs. This ensures the generated content is informative, relevant, and SEO-optimized.

  sitemap_crawl (internal_linking)
  Crawls the website sitemap to collect internal URLs. These URLs are later used for internal linking inside the blog content. Internal links help improve SEO and site structure.

  write_content
  Uses AI to write an 800-1000 word SEO-optimized blog article based on research data. The content includes proper HTML formatting, internal links, and anchor keyword placement.

  extract_title_body
  Separates the H1 title from the blog body content for proper WordPress publishing format.

  classify_category
  Automatically determines the most suitable category for the blog post by analyzing the blog title and content context. This keeps the website's category structure clean and relevant.

  get_category & create_category
  Checks if the determined category exists in WordPress. If not, it creates a new category automatically.

  generate_image_prompt
  Analyzes the blog content and generates AI prompts for creating relevant images including thumbnail and in-content images.

  Thumbnail Image Generator & Blog Image Generator
  Generate high-quality images using Ideogram API based on AI-generated prompts. Images are created with proper resolution and rendering settings.

  Thumbnail Uploading & Blog Image Uploading
  Upload generated images to WordPress media library and retrieve media IDs for post attachment.

  Add Alt Text in Images
  Adds SEO-friendly alt text to uploaded images to improve accessibility and search engine optimization.

  Blog and Photo Merge
  Merges the generated images into the blog content at appropriate positions within the article.

  publish_blog
  Publishes the complete blog post to WordPress with title, content, category, featured image, and publish status.

  save_live_url
  Saves the live published blog URL back into Google Sheets along with keyword, website URL, and timestamp for tracking and reporting.

  If Error Existed Then Get Notified
  Sends instant Discord or Slack notifications when any error occurs during workflow execution, ensuring no failure goes unnoticed.

  Customization Options

  Change blog length or tone in the content generation node
  Modify image style or resolution in Ideogram nodes
  Add multi-site publishing using Switch nodes
  Replace notification channel (Discord to Slack or Email)
  Extend workflow to social media posting

  Troubleshooting

  Blog not published  
  Check WordPress credentials and REST API permissions.

  Images not generated  
  Verify Ideogram API credentials and prompt formatting.

  Sheet not updating  
  Ensure correct Sheet ID and OAuth permissions.

  Workflow stopped  
  Review execution logs and error notification messages.

  Use Cases

  SEO blog automation for agencies
  Content publishing for niche websites
  Scalable blog management
  AI-assisted content operations
  Hands-free WordPress publishing

  Final Notes

  This workflow is designed to be reusable, scalable, and creator-friendly. It follows n8n best practices, avoids hardcoded credentials, and is suitable for public sharing as a workflow template.

  For any questions or support, please contact:
  info@incrementors.com or fill out this form: https://www.incrementors.com/contact-us/

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatDeepSeek","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.discord","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.discord","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 15000 characters]

metadata_json:
  {"categories":["Marketing","AI/ML"],"complexity":"medium","use_cases":["Automated SEO blog post creation","AI-driven content writing and image generation","WordPress content scheduling","Automatic category detection","Media upload automation"],"estimated_setup_minutes":30,"required_services":["Google Sheets","Google Gemini","OpenAI","Ideogram","WordPress","Discord","DeepSeek"],"key_features":["Scheduled publishing automation","Automated topic research","AI content generation","Dynamic category creation","AI image generation for blog posts"],"target_audience":["SEO specialists","Content creators","Marketing managers"]}


name: Create a daily market brief from Google Sheets, Alpha Vantage, Reddit, OpenAI, and Slack
author_name: Rahul Joshi
author_username: rahul08
categories: []
created_at: 2026-01-23T14:03:39.152Z
updated_at: 2026-01-23T14:03:39.152Z
url: https://n8n.io/workflows/12944
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  📊 Description
  This workflow automatically creates a daily market intelligence brief for your stock portfolio. Instead of checking prices, news, and social media separately, it brings everything together into one clear update.
  On a scheduled basis, the workflow reads your stock list from Google Sheets and processes each stock individually. It fetches the latest stock price data, recent market news, and investor sentiment from public sources. All this information is then analyzed by AI to identify what truly matters, filtering out noise and repeated information.
  The AI generates a concise market summary that highlights overall sentiment, key drivers, risks, and one actionable insight for the day. The final result is sent directly to Slack as a clean, easy-to-read message, helping you stay informed without manual effort.
  This workflow is ideal for anyone who wants a clear daily view of market conditions without spending hours monitoring multiple platforms.

  ⚙️ What This Workflow Does
  Runs automatically on a daily schedule
  Reads stock symbols from Google Sheets
  Fetches latest stock price data
  Collects recent market news
  Gathers investor sentiment from public discussions
  Uses AI to summarize market-moving signals
  Sends one actionable daily brief to Slack

  ✅ Key Benefits
  Saves time by automating market monitoring
  Reduces noise and highlights what actually matters
  Combines prices, news, and sentiment in one place
  Provides clear daily insights instead of raw data
  Easy to adjust for different portfolios or schedules

  🧩 Features
  Scheduled daily execution
  Portfolio-based stock tracking
  Market news collection via RSS
  Social sentiment analysis from Reddit
  AI-driven market intelligence summary
  Structured output for alerts or reporting
  Slack integration for daily delivery

  🔐 Requirements
  To use this workflow, you will need:
  Alpha Vantage API key for stock price data
  OpenAI account for AI analysis
  Google Sheets access for portfolio input
  Slack account for message delivery
  n8n instance (cloud or self-hosted)

  🎯 Target Audience
  Stock investors
  Portfolio managers
  Market analysts
  Finance teams
  Founders and operators tracking markets
  Automation builders in finance

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.rssFeedRead","n8n-nodes-base.code","n8n-nodes-base.rssFeedRead","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","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/n8n-nodes-langchain.openAi","n8n-nodes-base.slack"]

workflow_json_compressed:
  [encoded data, 6416 characters]

metadata_json:
  {"categories":["Finance","Data Processing"],"complexity":"medium","use_cases":["generate daily market reports","monitor stock prices","track investor sentiment"],"estimated_setup_minutes":15,"required_services":["Google Sheets","Alpha Vantage","Reddit","OpenAI","Slack"],"key_features":["automated data aggregation","stock price monitoring","sentiment analysis","scheduled execution"],"target_audience":["investors","financial analysts","portfolio managers"]}


name: Classify guest enquiries and send replies with GPT-4o, Gmail and Slack
author_name: Rahul Joshi
author_username: rahul08
categories: []
created_at: 2026-01-23T14:07:18.678Z
updated_at: 2026-01-23T14:07:18.678Z
url: https://n8n.io/workflows/12946
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  📘 Description
  This workflow automates guest enquiry intake, intent classification, response generation, and internal routing for hospitality businesses using webhooks, GPT-4o, Gmail, and Slack. It converts raw guest enquiries into structured, actionable items while ensuring fast acknowledgements, correct team assignment, and SLA visibility.
  When a guest submits an enquiry through a webhook (website form, booking page, or external system), an AI agent analyzes the message to detect intent—booking, pricing, availability, or policy. The agent generates a polite, human-like acknowledgement message and determines the most suitable internal team to handle the request. Based on the detected intent, the workflow assigns the enquiry to the correct team with a predefined SLA.

  If the guest prefers email communication, an automated reply is sent via Gmail. In parallel, a detailed enquiry summary—including guest details, detected intent, assigned agent, and SLA—is posted to Slack for internal visibility and follow-up. All AI responses are also logged to Slack for transparency. Any workflow failure triggers an immediate Slack alert with diagnostic details.

  ⚙️ What This Workflow Does (Step-by-Step)
   📥 Webhook Trigger – Guest Enquiry Intake
   Receives guest enquiry data (name, email, message, dates, preferences).
   🧠 AI Intent Classification & Reply Generation
   GPT-4o analyzes the enquiry, detects intent, and generates a polite acknowledgement.
   🔍 Extract Detected Category
   Parses AI output to identify the enquiry category.
   🔀 Route by Intent Category
   Directs enquiries to booking, pricing, availability, or policy flows.
   👥 Team Assignment with SLA
   Assigns the enquiry to the correct team and sets response SLA.
   📧 Send Email Reply to Guest (Conditional)
   Automatically replies if the guest prefers email contact.
   💬 Post Enquiry Summary to Slack
   Shares full enquiry context, assignment, and SLA for team follow-up.
   📝 Log AI Reply to Slack
   Stores the generated guest reply for internal reference.
   🚨 Error Handler → Slack Alert
   Sends instant alerts if any node fails.

  🧩 Prerequisites
   • n8n webhook endpoint
   • OpenAI / Azure OpenAI (GPT-4o or GPT-4o-mini) credentials
   • Gmail OAuth2 credentials
   • Slack API credentials

  💡 Key Benefits
   ✔ Instant AI-driven enquiry classification
   ✔ Faster guest acknowledgements
   ✔ Correct team routing with SLA enforcement
   ✔ Reduced manual triage for front-desk and sales teams
   ✔ Full visibility of enquiries and replies in Slack
   ✔ Built-in error monitoring

  👥 Perfect For
  Hotels and resorts
  Vacation rental operators
  Hospitality sales and front-desk teams
  Property management companies
  Businesses handling high volumes of guest enquiries

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.set","n8n-nodes-base.switch","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.if","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.errorTrigger","n8n-nodes-base.slack","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5924 characters]

metadata_json:
  {"categories":["Communication","AI/ML"],"complexity":"medium","use_cases":["Automate guest enquiry intake","Classify enquiry intent","Generate automated replies","Route tasks to team members","Acknowledge guests via email"],"estimated_setup_minutes":30,"required_services":["Gmail","Slack","GPT-4o"],"key_features":["AI-driven intent classification","Automated email responses","Team task routing","SLA visibility","Webhook-based intake"],"target_audience":["hospitality managers","customer support agents","small business owners"]}


name: Track weekly portfolio risk using GPT-4.1, Slack alerts, and Google Sheets
author_name: Rahul Joshi
author_username: rahul08
categories: []
created_at: 2026-01-23T14:09:10.313Z
updated_at: 2026-01-23T14:09:10.313Z
url: https://n8n.io/workflows/12947
scraped_at: 2026-05-02 08:04:50
metadata_generated_at: 2026-05-02 08:36:21
description:
  📊 Description
  This workflow reads your portfolio from Google Sheets, fetches market data, evaluates key risk factors such as sector concentration, volatility, and stock correlation, and generates an easy-to-understand risk summary using AI.
  When meaningful risk is detected, the workflow sends a structured alert to Slack and stores a weekly risk snapshot in Google Sheets for tracking trends over time. This automation is designed to help investors, analysts, and teams understand portfolio risk clearly without manual analysis or constant monitoring.

  🔁 What This Workflow Does
  1️⃣ Runs automatically on a weekly schedule using a Schedule Trigger
   2️⃣ Reads portfolio holdings from Google Sheets
   3️⃣ Validates portfolio data to ensure required fields are present
   4️⃣ Processes stocks in batches to avoid API rate limits
   5️⃣ Fetches historical price data from Alpha Vantage
   6️⃣ Normalizes market data into a consistent structure
   7️⃣ Calculates portfolio-level risk metrics.
   8️⃣ Generates a single portfolio risk score and risk flag
   9️⃣ Uses AI to explain detected risks in simple language
   🔟 Sends a clear weekly risk alert to Slack
   1️⃣1️⃣ Stores a summarized weekly risk snapshot in Google Sheets
   1️⃣2️⃣ Handles invalid data safely to avoid noisy or misleading alerts

  ⭐ Key Benefits
  ✅ Understand portfolio risk at a glance
   ✅ Detect sector overexposure and diversification issues early
   ✅ Receive only meaningful, high-signal alerts
   ✅ Simple AI explanations instead of raw numbers
   ✅ Automatic weekly risk history stored in Google Sheets
   ✅ No financial advice, only analytical insights
   ✅ Designed for reuse and easy customization

  🧩 Features
  Weekly automated portfolio risk analysis
  Google Sheets–based portfolio input
  Alpha Vantage market data integration
  Batch processing with rate-limit protection
  Sector, volatility, and correlation risk analysis
  Portfolio risk scoring system
  AI-generated risk explanations
  Slack alerts for detected risk
  Google Sheets storage for historical tracking

  🔐 Requirements
  Google Sheets credentials
  Alpha Vantage API key
  Slack credentials (OAuth or webhook)
  AI provider API key 

  🎯 Target Audience
  Long-term and active investors
  Portfolio and risk analysts
  Finance and operations teams
  Fintech and investment platforms
  Automation engineers building financial workflows

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.slack","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.scheduleTrigger"]

workflow_json_compressed:
  [encoded data, 9432 characters]

metadata_json:
  {"categories":["Financial Services","Data Processing"],"complexity":"medium","use_cases":["track weekly portfolio risk","evaluate sector concentration","generate AI risk summary","alert on risk thresholds","store risk snapshots"],"estimated_setup_minutes":30,"required_services":["Google Sheets","Slack","GPT-4.1 (AI/ML)"],"key_features":["automated risk analysis","AI-powered summary generation","real-time risk alerts","trend tracking over time","customizable risk factors"],"target_audience":["investors","financial analysts","team leads"]}


