# templates

name: Get a summary of each podcast in your YouTube playlist daily automatically free
author_name: ARRE
author_username: arre
categories: []
created_at: 2025-07-13T00:00:02.024Z
updated_at: 2025-07-13T00:00:02.024Z
url: https://n8n.io/workflows/5926
scraped_at: 2025-12-24 13:02:41
description:
  Understand the workflow better.
  watch this video
  Good to know:

  This workflow automatically transcribes your favorite podcasts or videos saved in a YouTube playlist and generates a comprehensive, AI-powered summary—so you can quickly understand the main topics and insights without having to watch or listen to the entire episode.

  👤 Who is this for?

  Podcast fans who want to save time and get the key points from episodes

  Busy professionals who follow educational or industry videos and need quick takeaways

  Content creators or researchers who organize and review large amounts of video/audio material

  Anyone who wants to efficiently capture and summarize information from YouTube playlists

  ❓ What problem is this workflow solving?

  This workflow solves the challenge of information overload from long-form podcasts and videos. It:

  Automatically transcribes each video or podcast episode in your chosen YouTube playlist

  Uses AI to create a clear, well-structured summary of the content

  Lets you learn and extract valuable information without watching or listening to the entire recording

  Organizes everything in a Google Sheets document for easy tracking and future reference

  ✅ What this workflow does:

  📺 Fetches all videos from a specified YouTube playlist

  🔗 Extracts video titles, URLs, and IDs

  📝 Retrieves and combines transcripts for each video or podcast episode

  📜 Processes transcript data for clarity

  🤖 Uses AI to generate a detailed, sectioned summary that covers all main topics and insights

  📊 Automatically logs video titles, transcripts, summaries, and row numbers to a Google Sheets spreadsheet

  ⚙️ How it works:

  🟢 Trigger: Start the workflow manually or on a schedule

  📺 Fetch videos from your chosen YouTube playlist

  🔗 Extract and organize video details (title, URL, ID)

  📝 Retrieve the transcript for each video or podcast episode

  📜 Combine transcript segments into a single script

  ✂️ Extract the first sentences for focused summarization

  🤖 AI agent creates a comprehensive summary of the episode or video

  📊 Save all data—title, transcript, summary, and row number—to Google Sheets

  🛠️ How to use:

  Set up YouTube OAuth2 credentials in n8n

  Configure Google Sheets OAuth2 credentials

  Set up API credentials for transcript and AI processing

  Create and link your Google Sheets document

  Input your playlist ID and adjust any filters as needed

  Activate the workflow

  📝 Requirements:

  n8n instance (cloud or self-hosted)
  YouTube account with OAuth2 access
  Google Sheets account
  Access to transcript and AI APIs
  Basic n8n workflow knowledge

  🟢 Customizing this workflow:

  Change the YouTube playlist ID to target your preferred podcasts or video series

  Adjust the transcript retrieval process for other APIs or formats

  Customize the AI prompt for different summary styles or focus areas

  Add or remove fields in the Google Sheets output

  Change the workflow trigger or polling frequency

  Switch to a different AI model if desired

  This workflow is designed to help you quickly learn from podcasts and videos you care about—without spending hours consuming the full content.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.function","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4892 characters]


name: AI-Powered Lead Research & Personalized Email Generation with Groq & Google Sheets
author_name: ainabler
author_username: ainabler
categories: []
created_at: 2025-07-13T14:08:18.685Z
updated_at: 2025-07-13T14:08:18.685Z
url: https://n8n.io/workflows/5938
scraped_at: 2025-12-24 13:02:41
description:
  Overall Description & Potential

  &lt;&lt; What Does This Flow Do? &gt;&gt;

  Overall, this workflow is an intelligent sales outreach automation engine that transforms raw leads from a form or a list into highly personalized, ready-to-send introductory email drafts. The process is: it starts by fetching data, enriches it with in-depth AI research to uncover "pain points," and then uses those research findings to craft an email that is relevant to the solutions you offer.

  This system solves a key problem in sales: the lack of time to conduct in-depth research on every single lead. By automating the research and drafting stages, the sales team can focus on higher-value activities, like engaging with "warm" prospects and handling negotiations. Using Google Sheets as the main dashboard allows the team to monitor the entire process—from lead entry, research status, and email drafts, all the way to the send link—all within a single, familiar interface.

  &lt;&lt; Potential Future Enhancements &gt;&gt;

  This workflow has a very strong foundation and can be further developed into an even more sophisticated system:

  Full Automation (Zero-Touch): Instead of generating a manual-click link, the output from the AI Agent can be directly piped into a Gmail or Microsoft 365 Email node to send emails automatically. A Wait node could be added to create a delay of a few minutes or hours after the draft is created, preventing instant sending.

  Automated Follow-up Sequences: The workflow can be extended to manage follow-up emails. By using a webhook to track email opens or replies, you could build logic like: "If the intro email is not replied to within 3 days, trigger the AI Agent again to generate follow-up email #1 based on a different template, and then send it."

  AI-Powered Lead Scoring: After the research stage, the AI could be given the additional task of scoring leads (e.g., 1-10 or High/Medium/Low Priority) based on how well the target company's profile matches your ideal customer profile (ICP). This helps the sales team prioritize the most promising leads.

  Full CRM Integration: Instead of Google Sheets, the workflow could connect directly to HubSpot, Salesforce, or Pipedrive. It would pull new leads from the CRM, perform the research, draft the email, and log all activities (research results, sent emails) back to the contact's timeline in the CRM automatically.

  Multi-Channel Outreach: Beyond email, the AI could be instructed to draft personalized LinkedIn Connection Request messages or WhatsApp messages. The workflow could then use the appropriate APIs to send these messages, expanding your outreach beyond just email.

nodes_used:
  ["n8n-nodes-base.if","@tavily/n8n-nodes-tavily.tavilyTool","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","@tavily/n8n-nodes-tavily.tavilyTool","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent"]

workflow_json_compressed:
  [encoded data, 10376 characters]


name: Automated Competitor Pricing Monitor with Bright Data MCP & OpenAI
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T18:58:33.809Z
updated_at: 2025-07-13T18:58:33.809Z
url: https://n8n.io/workflows/5948
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors competitor pricing changes and website updates to keep you informed of market movements. It saves you time by eliminating the need to manually check competitor websites and provides alerts only when actual changes occur, preventing information overload.

  Overview

  This workflow automatically scrapes competitor pricing pages (like ClickUp) and compares current pricing with previously stored data. It uses Bright Data to access competitor websites without being blocked and AI to intelligently extract pricing information, updating your tracking spreadsheet only when changes are detected.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping competitor websites without being blocked
  OpenAI**: AI agent for intelligent pricing data extraction and parsing
  Google Sheets**: For storing and comparing historical pricing data

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Google Sheets: Connect your Google Sheets account and set up your pricing tracking spreadsheet
  Customize: Set your competitor URLs and pricing monitoring schedule

  Use Cases

  Product Teams**: Monitor competitor feature and pricing changes for strategic planning
  Sales Teams**: Stay informed of competitor pricing to adjust sales strategies
  Marketing Teams**: Track competitor messaging and positioning changes
  Business Intelligence**: Build comprehensive competitor analysis databases

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #competitoranalysis #pricingmonitoring #brightdata #webscraping #competitortracking #marketintelligence #n8nworkflow #workflow #nocode #pricetracking #businessintelligence #competitiveanalysis #marketresearch #competitormonitoring #pricingdata #websitemonitoring #competitorpricing #marketanalysis #competitorwatch #pricingalerts #businessautomation #competitorinsights #markettrends #pricingchanges #competitorupdates #strategicanalysis #marketposition #competitiveintelligence

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 7604 characters]


name: Extract Customer Pain Points from Support Forums with Bright Data & GPT-4
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:00:22.001Z
updated_at: 2025-07-13T19:00:22.001Z
url: https://n8n.io/workflows/5952
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors customer support forums and Q&A platforms to extract valuable customer insights and pain points. It saves you time by eliminating the need to manually browse through forum discussions and provides structured analysis of customer questions, answers, and recurring issues.

  Overview

  This workflow automatically scrapes customer support forums like Stack Exchange and SuperUser to find questions and discussions related to specific topics or brands. It uses AI to analyze forum content, extract customer pain points, and identify recurring issues, then sends structured insights directly to your product team via email.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping forum pages and Q&A platforms without being blocked
  OpenAI**: AI agent for intelligent forum content analysis and insight extraction
  Gmail**: For sending automated insight reports to your team

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Gmail: Connect your Gmail account for sending team notifications
  Customize: Set target forum URLs and define the topics or brands to monitor

  Use Cases

  Product Teams**: Identify customer pain points and feature requests from forum discussions
  Customer Support**: Monitor common issues and questions customers are asking
  Market Research**: Understand customer needs and challenges in your industry
  Competitive Analysis**: Track how customers discuss competitor products and services

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #forummonitoring #customersupport #brightdata #webscraping #customerinsights #n8nworkflow #workflow #nocode #forumautomation #customerresearch #supportmonitoring #painpointanalysis #communitymonitoring #forumanalysis #customerfeedback #productinsights #supportforums #stackexchange #customervoice #userresearch #productfeedback #techsupport #communitylistening #customerexperience #supportanalysis #forumdata #qandamonitoring #customerpainpoints

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 5964 characters]


name: Automate Email Campaign Analysis & Smart Follow-ups with Bright Data & OpenAI
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:00:30.213Z
updated_at: 2025-07-13T19:00:30.213Z
url: https://n8n.io/workflows/5953
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically tracks email campaign performance metrics and triggers smart follow-up actions based on engagement data. It saves you time by eliminating the need to manually monitor campaign reports and provides intelligent re-engagement strategies for improving email marketing ROI.

  Overview

  This workflow automatically scrapes email service provider (ESP) reports to extract campaign performance metrics like open rates, click-through rates, and bounce rates. It uses AI to analyze the data and automatically sends targeted follow-up emails to re-engage subscribers who opened but didn't click, maximizing campaign effectiveness.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping ESP campaign reports without being blocked
  OpenAI**: AI agent for intelligent campaign data analysis and decision making
  Gmail**: For sending automated follow-up engagement emails

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Gmail: Connect your Gmail account for sending follow-up emails
  Customize: Set ESP report URLs and define engagement thresholds for triggering follow-ups

  Use Cases

  Email Marketing**: Automatically optimize campaign performance with smart follow-ups
  Marketing Automation**: Trigger re-engagement campaigns based on behavior data
  Performance Tracking**: Monitor email metrics without manual ESP login
  Customer Retention**: Re-engage subscribers who showed interest but didn't convert

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #emailmarketing #campaigntracking #brightdata #webscraping #emailautomation #n8nworkflow #workflow #nocode #emailcampaigns #marketingautomation #emailperformance #campaignanalysis #emailmetrics #reengagement #marketingdata #emailoptimization #campaignmonitoring #emailanalytics #digitalmarketing #performancetracking #emailstrategy #conversionoptimization #marketinganalytics #emailroi #campaigninsights #emailengagement #marketingefficiency #automatedemail

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 6220 characters]


name: Track SEO Keyword Rankings with Bright Data MCP and GPT-4o AI Analysis
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:01:44.254Z
updated_at: 2025-07-13T19:01:44.254Z
url: https://n8n.io/workflows/5962
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors keyword rankings across search engines to track SEO performance and identify optimization opportunities. It saves you time by eliminating the need to manually check keyword positions and provides comprehensive ranking data for strategic SEO decision making.

  Overview

  This workflow automatically scrapes search engine results pages (SERPs) to track keyword rankings, competitor positions, and search features. It uses Bright Data to access search results without restrictions and AI to intelligently parse ranking data, track changes, and identify SEO opportunities.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping search engine results without being blocked
  OpenAI**: AI agent for intelligent ranking analysis and SEO insights
  Google Sheets**: For storing keyword ranking data and tracking changes

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Google Sheets: Connect your Google Sheets account and set up your ranking tracking spreadsheet
  Customize: Define target keywords and ranking monitoring parameters

  Use Cases

  SEO Teams**: Track keyword performance and identify ranking improvements
  Content Marketing**: Monitor content ranking success and optimization needs
  Competitive Analysis**: Track competitor keyword rankings and strategies
  Digital Marketing**: Measure organic search performance and ROI

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #keywordrankings #seo #searchrankings #brightdata #webscraping #seotools #n8nworkflow #workflow #nocode #ranktracking #keywordmonitoring #seoautomation #searchmarketing #organicseo #seoresearch #rankinganalysis #keywordanalysis #searchengines #seomonitoring #digitalmarketing #serp #keywordtracking #seoanalytics #searchoptimization #rankingreports #keywordresearch #seoinsights #searchperformance

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 5868 characters]


name: Automated Content Marketing Intelligence with OpenAI, Ahrefs & Multi-platform Integration
author_name: Nikan Noorafkan
author_username: nikkannoora
categories: []
created_at: 2025-07-13T19:59:53.938Z
updated_at: 2025-07-13T19:59:53.938Z
url: https://n8n.io/workflows/5979
scraped_at: 2025-12-24 13:02:41
description:
  🤖 AI-Powered Content Marketing Research Tool

  &gt; Transform your content strategy with automated competitor intelligence

  ⚡ What It Does

  Never miss a competitor move again. This workflow automatically:

  🔍 Monitors competitor content across multiple domains
  📊 Tracks trending keywords by region  
  💬 Extracts audience pain points from Reddit & forums
  🤖 Generates AI strategy recommendations via OpenAI
  📋 Outputs to Airtable, Notion & Slack for instant action

  🎯 Perfect For
  Growth marketers** tracking competitor strategies
  Content teams** discovering trending topics
  SEO specialists** finding keyword opportunities
  Marketing agencies** managing multiple clients

  🛠️ Technical Setup

  Required APIs & Credentials

  | Service | Credential Type | Monthly Cost | Purpose |
  |---------|----------------|--------------|---------|
  | Ahrefs | Header Auth | $99+ | Backlink & traffic analysis |
  | SEMrush | Query Auth | $119+ | Keyword research |
  | BuzzSumo | Header Auth | $199+ | Content performance |
  | OpenAI | Header Auth | ~$50 | AI recommendations |
  | Reddit | OAuth2 | Free | Audience insights |
  | Google Trends | Public API | Free | Trending topics |

  📊 Database Schema

  Airtable Base: content-research-base

  Table 1: competitor-intelligence

  timestamp (Date)

  domain (Single line text)

  traffic_estimate (Number)

  backlinks (Number)

  content_gaps (Long text)

  publishing_frequency (Single line text)

  Table 2: keyword-opportunities  

  timestamp (Date)

  trending_keywords (Long text)

  top_questions (Long text)

  content_opportunities (Long text)

  🚀 Quick Start Guide

  Step 1: Import & Configure
  Import the workflow JSON
  Update competitor domains in 📋 Configuration Settings
  Map all API credentials

  Step 2: Setup Storage
  Airtable:** Create base with exact schema above
  Notion:** Create database with properties listed
  Slack:** Create #content-research-alerts channel

  Step 3: Test & Deploy
  First run populates:
  ✅ Airtable tables with competitor data
  ✅ Notion database with AI insights
  ✅ Slack channel with formatted alerts

  💡 Example Output

  AI Recommendations Format
  {
  "action_items": [
  {
  "topic": "Copy trading explainer",
  "format": "Video",
  "region": "UK",
  "priority": "High"
  }
  ],
  "publishing_calendar": [
  {"week": "W34", "posts": 3}
  ],
  "alerts": [
  "eToro gained 8 .edu backlinks this week"
  ]
  }

  Slack Alert Preview
  🚨 Content Research Alert

  📊 Top Findings:

  Sustainable packaging solutions

  Circular economy trends

  Eco-friendly manufacturing

  📈 Trending Keywords:

  forex trading basics (+45%)

  social trading platforms (+32%)

  copy trading strategies (+28%)

  💡 AI Recommendations:
  Focus on educational content in UK market...

  🔧 Advanced Features

  ✅ Data Quality Validation
  Automatic retry** for failed API calls
  Data validation** before storage
  Error notifications** via Slack

  ⚙️ Scalability Options
  Multi-region support** (US, UK, DE, FR, JP)
  Batch processing** for large competitor lists  
  Rate limiting** to respect API quotas

  🎨 Customization Ready
  Modular design** - disable unused APIs
  Industry templates** - forex, ecommerce, SaaS
  Custom scoring** algorithms

  📈 ROI & Performance

  Cost Analysis
  Setup time:** ~2 hours
  Monthly API costs:** $400-500
  Time saved:** 15+ hours/week
  ROI:** 300%+ within first month

  Success Metrics
  Competitor insights:** 50+ data points daily
  Keyword opportunities:** 100+ suggestions/week  
  Content ideas:** 20+ AI-generated topics
  Trend alerts:** Real-time notifications

  🛡️ Troubleshooting

  Common Issues & Solutions

  | Symptom | Cause | Fix |
  |-------------|-----------|---------|
  | OpenAI timeout | Large data payload | Reduce batch size → Split processing |
  | Airtable 422 error | Field mismatch | Copy schema exactly |
  | Reddit 401 | OAuth expired | Re-authorize application |

  Rate Limiting Best Practices
  Ahrefs:** Max 1000 requests/day
  SEMrush:** 3000 requests/day  
  OpenAI:** Monitor token usage

  🌟 Why Choose This Template?

  &gt; "From manual research to automated intelligence in 15 minutes"

  ✅ Production-ready - No additional coding required  
  ✅ Cost-optimized - Uses free tiers where possible  
  ✅ Scalable - Add competitors with one click  
  ✅ Actionable - AI outputs ready for immediate use  
  ✅ Community-tested - 500+ successful deployments

  Start your competitive intelligence today 🚀

  Built with ❤️ for the n8n community

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","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.airtable","n8n-nodes-base.airtable","n8n-nodes-base.notion","n8n-nodes-base.slack","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.stopAndError","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 7304 characters]


name: Security Reconnaissance with Google Dorks, Parsera Scraping, and Gmail Reports
author_name: Sean Birmingham
author_username: knute
categories: []
created_at: 2025-07-13T21:23:12.789Z
updated_at: 2025-07-13T21:23:12.789Z
url: https://n8n.io/workflows/5980
scraped_at: 2025-12-24 13:02:46
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  How it Works:
  - Accepts a domain from a web form
  - Generates a list of Google dorks targeting that domain
  - Scrapes Google search results for each dork 
  - Filters out junk links (Google internal, non-http)
  - Formats valid results as a markdown report
  - Emails the report to your inbox

  For this workflow you will need to configure credentials in n8n as well as create a Parsera.io agent:

  1. AI Scraper Account
  Create an account for: https://app.parsera.io
  Create an agent named "Google" and use the URL https://google.com
  Copy/Paste your Parsera.io API key to the 'Scrape with agent' node in the n8n workflow

  2. Gmail OAuth2
  Go to Google Cloud Console
  Enable Gmail API
  Create OAuth2 credentials
  Copy/Paste the Gmail API key to the Gmail node in the n8n workflow

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-aiscraper.aiScraper","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.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE51Ya1PbSBb9K70KNdgJsvW25BTLMmQzoTYTUoHMfsDM0upu2QK55ZFkCOvxf9/TLfkByGSyVRRuy7fv49x7z+3WwpiKihrDhZHKsqKSiVNuDA3LpsKnIrYSy3V8Swxsz43sxLaYZ1txIrwoYczlAfNdNwmDOBSM0sjxQi7igWv5xoFRiekso5U4KQQvz0U1n53keCIqAQNVMRfLA0PmXJTG8BLWlVUeu0kysIUZUt82PZcGJg1obIYsgIGI8iixoFnSqYD0+7yYklM5m1fK2sNMPZOhNLVSM6al6CUQuSjS8VgUkJnlZVqluYRB03ZC68C0o9C6OjDuRTzJ81sdeRJQNxkEtul7XJgePDIjN05MK3ARe2jHPqNKFy3gRSWKUmE3o9Xkr+/NZ8oLtREQaBfTKlPe/1NCIbmgxVhU5F0+pak0aon3qci4NnVHs3mDWaIefqSxyLD365ePyq2MMjHJM46Ah8akqmblsN8X36hCvsfyqbG8Wi5ruH6D8xoNZ3nQJCCxBEfmHdOPGAIYCNuMmc8Qhev7bhBHg4GzScD5LEuVn8VtSc6kMOMHEx87k1Eq8VP5M63YBBE8zkfobdLxGNtHaMVq83n6X6gPn4Zhr8OwLYv7bmibnA8QhutyVBSzTBGElhtbjsfDcBNGHcBFU67kXNCCTXZGwbB8WktWsMv5m/JEyQ8NhhAqkqpq/Vpk5JDs3ZS5vBypvI2Mq7cjOZK1zFSFCIGVbE8/6PR/7xwNdUKPhqNRH3/dIzy5v78fjXpYXv6OR1dvuv20+3aliusSgq5a51H9eWlfkSHZ3yqK/S3zXKNxSK5HEhGKYW9Ljohv1XDGE/hWqWUq7/KUCfLn6gHlvBBluXPrZAZZtbopVytaztrE53JeZMP+OK368CtJxysTI+OyENO8EiNjYxcP4wLkNRkZbcogpToMYqeSi28kT0j/ZcksHwO4P7d2lulY4mtjVTmnZV42h4BTmeTYtHb0w8XF5/98ODu/2OlALXcCRioFSdJMtEt2ahxz2QAJd5pV9a1qVgq6ZinkXXckr7cyzeZllU/RS/xdk3Od+5EkpFcV6bTT1Uvdtp390Uju1w+mdNbJUinI4d/JQj0hpFYopGoODkX16uuXU0X5uRSy0jt6hdAE1UH5rmLBCtH0xwfkure3qCt2ed1VRaw0FxgchSQLoiId4lP5OCTXK2pD/ffGeT6uQemXunmP/jjcWzTeLK/Jkiy1tmVXR9+ofBL+W2M3LTLO7YSLxEycKAGfKFqMgoGZ8DARPKahZ/tbtMgKOhPkPq0mhI4RexuX0LTUYkWPpvWGpxMqcHaRCooPug4Xi5pEegoSslxiP5ovnxdMmVpZ1p+fas9qoLTcHxgi1dmGWhE8w6CGbEozbWXt1/Es1ecDhcSXs89nMvDcKf9q3TgX+Sbq41PSyBPKWD6H8WeDZsPQLsU5woti02ZBDEQZGJpT13QotV0W2Y7lBRvdJ5mgkpzNq5dmfQsxe9Z3ebkphj3Ntj2aZZ2uLnC023Rd4HV5o4JvFS/jl57G/SMe6IoipN8n79NMTW/FCmyzKS1/o1mKnqjLWev46afNlx4OXUVV/hvF0tlXRb3fXf/+Ny2QSpbNEWVnf1Pnz4S2tTRN8KLMq/1u43kDQONnLX+01W9MYS+4inVYu492qsWGRM6zDHqW3V6io+/8nOdKXil/oZ9Ch/PEt7jJXOGbnu8wkzI7NJkI/TgMme0P6Cb7vwgpCjWZP1z8+vGH5nL4F8eyCkvx3/MqUCWQ1tneAqLGDkdZDNTiluf3asaOjFevXpF/iQfyUas71c2EMxrHvJbqz9DbVKnkBaCbxgIdB+NlVR6QeTmH3QdCSZlKpJlIca9ZNi1Bp/l8PCFpQqqJaHZCSP2kAoACmOpp1R/ye3EnioOVcCEw8QrUJWTLKs0yks2nGErgW5wrmdKiiap2UUkVeQxmrLUdq6RKWqV3Ins4wBzBLGA48/26Cls5T8oHWdFvw5Fco/HmsMZUg9jJ4E1XIXm9t0jJG2Ive+Ryb5Etrzrqf/e627vJU6lnjB4z2zR9uSnFtXpU4NVLfJ0wYePiwE07CFywABVm5IBdYo9yn2IoWOHWPeIcEAH2KQ4uIMudBTbGZMoeV5jXfoWIB4MEVwHbZJa6BlgDVd6Ob0bhwOYWD2PU+rMrRAkvwKdDo5mL/9D29JH9wFj5ts36GzSWT+8U5Ty+EaxS4r9ozmgO6V/ELC8q4znXa1tnx/Nq4qyp/p0z+DSenk3fH0dWOS2TrYZU0rtZ3ulteD7iLve5jQsFSN30Qi/BSZ9aZiwskTgBLkvJYCsTVcpuH8gnnO523yK0TCPyqNtdlQ4Ho+NZu09EOp4ADtwLDlTLq3aBZrRrfeNSZ3B5MUHx4091DbKpDlxY0wr9ga6JBakHNld9QzjFpXn3eAutMAhDxzEFw2XKG7ixSSNOURCDiLlJILwgag3b/vG4g0CHHTwP+z7l6lrqhk+j/kyLEpQKi1yM5LGsjylkir5XgaI4QLccZ9G1ZCwQtQBJKcKoFFLKtR450aLoHrBVowW7HnAIWW9t6gSQlZM4pwUnDEQH9SOjLk6cjik6cF4KjT2SQVanu83EUz9Jks/wT5tXruttQmdQWzz+fEpuwb+bx83I3Ce0zmvtoYK990L2KNLjxE5oCiQLRRv4JmYSM9mAeT5Fhe0qWuf/qFrL0unzXqha52n+tpsa+SOrVy2qfAEjJ1XeJHHrlNtMOeUOxw0oWYNdD70X8AgSEQd2EJks8TzTo0lgUmEBGd+yo8HAd5MwacXD/XE8wl1oNMWsXtu8gIx+z0RqgjquC28kX79+l89jAMYwvW5fv1bwCI4xti5kXTL1PXOOMtfV9IjltmpKwYY4qlTNRdy+RC1X33zbYLzSPkoQcsPQ22+u8E2/5hleXi7067Dvv5BoXgul6iprDK3l1RVsPjoityndcYpqVfZYtk3brpnZqu75hahNZfshv1VhO0Ctfn7nFVW7v+2bWvXvvuu1qF4u/weoOeDvbxUAAA==


name: Bilingual Newsletters with GPT-4o, AI Images & Videos for HubSpot & SP
author_name: plemeo
author_username: plemeo
categories: []
created_at: 2025-07-14T09:15:48.670Z
updated_at: 2025-07-14T09:15:48.670Z
url: https://n8n.io/workflows/5988
scraped_at: 2025-12-24 13:02:42
description:
  Who’s it for  
  Marketing, growth, and automation teams that need to ship polished bilingual newsletters—complete with images, optional video, and multi-channel distribution—without writing a line of code.

  How it works / What it does  
  A Webhook receives a plain-language request (e.g. “Create a newsletter about XYZ and store it in SharePoint”). The Webhook can be changed to another trigger, fr example Manual Trigger.
  An AI Agent (OpenAI GPT-4o) drafts German & English newsletter copy following a strict JSON schema.  
  SharePoint fetches an HTML template; a Code node injects AI copy into the placeholders.  
  Optional creative assets:  
     Pollinations AI → image (resolution check & frame overlay)  
     FAL AI → short video + Lyria2 audio → merged via FFmpeg API  
  A Gmail Approval step sends the draft to an approver; the flow continues only on “Approve”.  
  Depending on user intent the workflow:  
     Emails the newsletter to HubSpot contacts, and/or  
     Saves HTML (+ JPG/Video URL) to a SharePoint library.  

  How to set up  
  Import the template
  Open the yellow sticky note and follow the checklist 
     Create credentials for OpenAI, HubSpot (App Token), Microsoft 365, Gmail, and FAL AI.  
     Enter them in n8n Credential Manager (never in the HTTP node).  
  Edit the Configuration Settings Set node with your ENV_* variables.   
  Activate the workflow, copy the production Webhook URL, and trigger it with JSON body { "text": "…" } or with a desired trigger.

  Requirements  
  OpenAI account
  Microsoft 365 tenant (SharePoint & Outlook)  
  HubSpot App Token  
  FAL AI API Key (video & audio generation)  

  How to customize  
  Want a different language? Tweak the AI prompt inside AI Agent.  
  Want a different storage provider? Change the SharePoint nodes to Google Drive or Dropbox.
  Skip video generation: set include_video to false in the incoming prompt.  
  Change the distribution logic by adjusting the WF Result Switch node.  
  Add more channels (e.g. Slack) by inserting additional branches after the Switch and modifying the intent determination at the beginning of the workflow.

nodes_used:
  ["n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.hubspot","n8n-nodes-base.splitInBatches","n8n-nodes-base.switch","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.set","n8n-nodes-base.convertToFile","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.if","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.extractFromFile"]

workflow_json_compressed:
  [encoded data, 4424 characters]


name: 🤖 Create a Documentation Expert Bot with RAG, Gemini, and Supabase
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-14T11:46:58.169Z
updated_at: 2025-07-14T11:46:58.169Z
url: https://n8n.io/workflows/5993
scraped_at: 2025-12-24 13:02:41
description:
  How it works

  This template is a complete, hands-on tutorial for building a RAG (Retrieval-Augmented Generation) pipeline. In simple terms, you'll teach an AI to become an expert on a specific topic—in this case, the official n8n documentation—and then build a chatbot to ask it questions.

  Think of it like this: instead of a general-knowledge AI, you're building an expert librarian.

  The workflow is split into two main parts:

  Part 1: Indexing the Knowledge (Building the Library)
      This is a one-time process you run manually. The workflow automatically scrapes all the pages of the n8n documentation, breaks them down into small, digestible chunks, and uses an AI model to create a special numerical representation (an "embedding") for each chunk. These embeddings are then stored in your own private knowledge base (a Supabase vector store). This is like a librarian reading every book and creating a hyper-detailed index card for every paragraph.

  Part 2: The AI Agent (The Expert Librarian)
      This is the chat interface. When you ask a question, the AI agent doesn't guess the answer. Instead, it uses your question to find the most relevant "index cards" (chunks) from the knowledge base it just built. It then feeds these specific, relevant chunks to a powerful language model (like Gemini) with a strict instruction: "Answer the user's question using ONLY this information." This ensures the answers are accurate, factual, and grounded in your provided documents.

  Set up steps

  Setup time: ~15-20 minutes

  This is an advanced workflow that requires setting up a free external database. Follow these steps carefully.

  Set up Supabase (Your Knowledge Base):
      You need a free Supabase account.
      Follow the detailed instructions in the large Workflow Setup sticky notes in the top-right of the workflow to:
          Create a new Supabase project.
          Run the provided SQL query in the SQL Editor to prepare your database.
          Get your Project URL and Service Role Key.

  Configure n8n Credentials:
      In your n8n instance, create a new Supabase credential using the Project URL and Service Role Key from the previous step.
      Create a new Google AI credential with your Gemini API key.

  Configure the Workflow Nodes:
      Select your new Supabase credential in the three Supabase nodes: Your Supabase Vector Store, Official n8n Documentation and Keep Supabase Instance Alive.
      Select your new Google AI credential in the three Gemini nodes: Gemini Chunk Embedding, Gemini Query Embedding and Gemini 2.5 Flash.

  Build the Knowledge Base:
      Find the Start Indexing manual trigger node at the top-left.
      Click its "Execute workflow" button to start the indexing process. This will take several minutes as it scrapes and processes the entire n8n documentation. You only need to do this once.

  Chat with Your Expert Agent:
      Once the indexing is complete, Activate the entire workflow.
      Open the RAG Chatbot chat trigger node and copy its Public URL.
      Open the URL in a new tab and start asking questions about n8n! For example: "How does the IF node work?" or "What is a sub-workflow?".

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.vectorStoreSupabase","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.removeDuplicates","n8n-nodes-base.filter","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.vectorStoreSupabase","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.splitOut","n8n-nodes-base.removeDuplicates","n8n-nodes-base.executeWorkflow","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","n8n-nodes-base.supabase","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.chatTrigger","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.executeWorkflowTrigger","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 18024 characters]


name: 🎓 Learn Workflow Logic with Merge, IF & Switch Operations
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-14T12:43:14.513Z
updated_at: 2025-07-14T12:43:14.513Z
url: https://n8n.io/workflows/5996
scraped_at: 2025-12-24 13:02:41
description:
  How it works

  Ever wonder how to make your workflows smarter? How to handle different types of data in different ways? This template is a hands-on tutorial that teaches you the three most fundamental nodes for controlling the flow of your automations: Merge, IF, and Switch.

  To make it easy to understand, we use a simple package sorting center analogy:
  Data Items** are packages on a conveyor belt.
  The Merge Node is where multiple conveyor belts combine into one.
  The IF Node is a simple sorting gate with two paths (e.g., "Fragile" or "Not Fragile").
  The Switch Node is an advanced sorting machine that routes packages to many different destinations.

  This workflow takes you on a step-by-step journey through the sorting center:

  Creating Packages: Three different "packages" (two letters and one parcel) are created using Set nodes.
  Merging: The first Merge node combines all three packages onto a single conveyor belt so they can be processed together.
  Simple Sorting: An IF node checks if a package is fragile. If true, it's sent down one path; if false, it's sent down another.
  Re-Grouping: After being processed separately, another Merge node brings the packages back together. This "Split &gt; Process &gt; Merge" pattern is a critical concept in n8n!
  Advanced Sorting: A Switch node inspects each package's destination and routes it to the correct output (London, New York, Tokyo, or a Default bin).

  By the end, you'll see how all packages have been correctly sorted, and you'll have a solid understanding of how to build intelligent, branching logic in your own workflows.

  Set up steps

  Setup time: 0 minutes!

  This template is a self-contained tutorial and requires zero setup.

  There are no credentials or external services to configure.
  Simply click the "Execute Workflow" button.
  Follow the flow from left to right, clicking on each node to see its output and reading the detailed sticky notes to understand what's happening at each stage.

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

workflow_json_compressed:
  [encoded data, 5488 characters]


name: 🎓 Learn Data Synchronization: Warehouse Inventory Audit Tutorial
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-14T13:19:04.372Z
updated_at: 2025-07-14T13:19:04.372Z
url: https://n8n.io/workflows/5999
scraped_at: 2025-12-24 13:02:41
description:
  How it works

  This template is a hands-on tutorial for one of n8n's most powerful data tools: the Compare Datasets node. It's the perfect next step after learning basic logic, showing you how to build robust data synchronization workflows.

  We use a simple Warehouse Audit analogy to make the concept crystal clear:
  Warehouse A:* Our main, "source of truth" database. This is the master list of what our inventory *should be.
  Warehouse B:** A second, remote database (like a Notion page or Google Sheet) that we need to keep in sync.
  The Compare Datasets Node:* This is our *Auditor**. It takes both inventory lists and meticulously compares them to find any discrepancies.

  The Auditor then sorts every item into one of four categories, which correspond to the node's four outputs:
  In A only: New products found in our main warehouse that need to be added to Warehouse B.
  Same: Products that match perfectly in both warehouses. No action needed!
  Different: Products that exist in both places but have different details (e.g., stock count). These need to be updated in Warehouse B.
  In B only: Extra products found in Warehouse B that aren't in our master list. These need to be deleted.

  This pattern is the foundation for any two-way data sync you'll ever need to build.

  Set up steps

  Setup time: 0 minutes!

  This workflow is a self-contained tutorial and requires no setup or credentials.

  Click "Execute Workflow" to start the audit.
  Explore the two Set nodes ("Warehouse A" and "Warehouse B") to see the initial data we are comparing.
  Click on "The Auditor" (Compare Datasets node) to see how it's configured to use product_id as the matching key.
  Follow the outputs to the four NoOp nodes to see which products were sorted into each category.
  Read the sticky notes next to each output—they explain exactly why each item ended up there.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.set","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.compareDatasets","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.splitOut","n8n-nodes-base.splitOut"]

workflow_json_compressed:
  [encoded data, 4128 characters]


name: Weekly Google Search Console SEO Pulse: Catch Top Movers Across Keyword Segments
author_name: MattF
author_username: the-curious-automator
categories: []
created_at: 2025-07-14T18:50:55.228Z
updated_at: 2025-07-14T18:50:55.228Z
url: https://n8n.io/workflows/6006
scraped_at: 2025-12-24 13:02:42
description:
  This workflow tracks week-over-week changes in Google Search Console performance and highlights the top movers across keyword segments like brand, nonbrand, and content categories.

  Instead of providing a routine check, it focuses on significant movements by:
  Sending a Slack alert only if a query crosses a defined movement threshold.
  Emailing a structured report with the Top 25 increases and Top 25 decreases for clicks, including % changes and linked URLs

  It’s designed to surface the most important shifts, helping SEO teams catch big wins, losses, or anomalies early.

  How it works
  Runs weekly (e.g. every Monday) to compare last week’s GSC data to the week prior.
  Segments traffic based on query and page (e.g. brand terms, category page URLs, etc.).
  Calculates delta and % change for clicks, CTR, impressions, and position.
  Filters and flags top movers with large shifts (default: ±200 clicks and ±30%).
  Sends Slack alerts only if meaningful changes are detected.
  Emails a full HTML table report showing the Top 25 up/down queries per segment.

  Setup steps
  Requires a connected Google Search Console account.
  Slack alert is included by default (can be replaced with email, webhook, or other tools).
  Customize your brand terms and URL filters to match your segments (e.g. recipes, blog, category pages).
  Typical setup time: 15–25 minutes depending on the number of segments and filters you want.

  Note: “Recipes” is used in the example to show how to segment by content type. You can update this to reflect your own site’s structure.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if","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.code","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.slack","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.merge","n8n-nodes-base.slack","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.switch","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.code"]

workflow_json_compressed:
  [encoded data, 9240 characters]


name: AI-Powered Lead Generation System with Email Personalization and LinkedIn
author_name: Matthieu
author_username: yaznow
categories: []
created_at: 2025-07-15T13:55:47.458Z
updated_at: 2025-07-15T13:55:47.458Z
url: https://n8n.io/workflows/6027
scraped_at: 2025-12-24 13:02:41
description:
  🔧 AI-Powered B2B Prospecting Automation

  This automation is a complete end-to-end system designed to find, qualify, and contact B2B leads — fully automated and powered by AI.

  1. Lead Discovery & Scoring

  Searches for target companies on LinkedIn via Ghost Genius API, using filters like location, and company size.
  Enriches each company with details like website, description, and follower count.
  Uses OpenAI to score each company (0 to 10) based on fit with your product.
  Filters out irrelevant companies and stores only qualified ones (score ≥ 7) into a Google Sheet CRM.

  2. Decision-Maker Enrichment & Outreach

  Finds key decision-makers at each qualified company via LinkedIn Sales Navigator.
  Retrieves their job titles, descriptions, and LinkedIn summaries.
  Generates a fully personalized 3-email cold outreach sequence using OpenAI.
  Retrieves verified email addresses using a waterfall enrichment system.
  Stores all contact data and email content in your CRM and updates lead status.

  Key Features

  Fully automated**: runs daily with no manual input required.
  Smart targeting**: all filters and parameters managed in Google Sheets.
  AI-enhanced**: leverages OpenAI for scoring, personalization, and copywriting.
  Compliant & safe**: uses Ghost Genius API (cookieless scraping).

  Ideal for B2B startups, agencies, or growth teams looking to scale outbound without manual effort.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.aggregate","n8n-nodes-base.googleSheets","n8n-nodes-base.filter","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.splitOut","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.limit","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.stopAndError","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 15212 characters]


name: Create Research-Based LinkedIn Posts with OpenAI, Perplexity and Human Review
author_name: Alberto Bordoni
author_username: abordoni
categories: []
created_at: 2025-07-15T15:38:55.027Z
updated_at: 2025-07-15T15:38:55.027Z
url: https://n8n.io/workflows/6030
scraped_at: 2025-12-24 13:02:46
description:
  What This Workflow Does:
  Generates original, research-based LinkedIn posts
  Combines AI insights with personal storytelling
  Includes human-in-the-loop selection & revision steps
  Automatically creates a conceptual image via DALL·E 3
  Sends the final post and image via email, ready to publish

  Perfect For:
  Professionals who want to share high-quality AI-assisted content
  Content creators balancing consistency and authenticity
  Consultants and solopreneurs building a personal brand
  Anyone who wants to turn AI research into personal, sharable stories

  📋 WORKFLOW PROCESS OVERVIEW

  Step 1: 🔍 Perplexity finds 3 recent, verifiable AI-related topics  

  Step 2: 📧 Email sent – you choose your favorite topic  

  Step 3: ✍️ OpenAI generates a LinkedIn post draft  

  Step 4: 📨 You review the post and approve or suggest changes 
   
  Step 5: 🛠️ If needed, AI revises the post based on your feedback  

  Step 6: 🎨 DALL·E creates a conceptual image to match the content  

  Step 7: 📬 Final email sent – post text + image ready to copy-paste on LinkedIn  

nodes_used:
  ["@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.perplexity","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","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","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail"]

workflow_json_compressed:
  [encoded data, 14636 characters]


name: 🤖 Create Your First AI Agent with Weather & Web Scraping (Starter Kit)
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-15T17:40:19.267Z
updated_at: 2025-07-15T17:40:19.267Z
url: https://n8n.io/workflows/6035
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  How it works

  This template is your personal launchpad into the world of AI-powered automation. It provides a fully functional, interactive AI chatbot that you can set up in minutes, designed specifically for those new to AI Agents.

  What is an AI Agent?
  Think of it as a smart assistant that doesn't just talk—it acts. You give it a set of "tools" (like other n8n tool nodes), and it intelligently decides which tool to use to answer your questions or complete your tasks.

  This starter kit comes with a pre-built "toolbox" of superpowers, allowing your agent to:
  Get the Weather:** Ask for the forecast anywhere in the world.
  Get the News:** Fetch the latest headlines from n8n, CNN, and others.

  The workflow is designed to be a hands-on learning experience, with detailed sticky notes explaining every component, from the chat interface to the agent's "brain" and "memory."

  Set up steps

  Setup time: ~2-3 minutes

  This workflow is designed to be incredibly easy to start. You only need one free API key to get it working.

  Add Your AI Key:
      The workflow uses Google's Gemini model by default. You will need a free Gemini API key.
      Find the Gemini node on the canvas. The sticky note right below it (How to Get Google Gemini Credentials) provides a link and simple instructions to get your key.
      In the Gemini node, click the Credential dropdown and select + Create New Credential to add your key.

  Activate the Workflow:
      At the top-right of the screen, click the "Inactive" toggle switch. It will turn green and say "Active". Your agent is now live!

  Start Chatting:
      Open the Example Chat Window node (it has a 💬 icon).
      In its parameter panel, you will see a Chat URL. Click the link to copy it.
      Paste the URL into a new browser tab and start asking your agent questions!

  Optional: The template also includes disabled OpenAI chat model node and tools for Google Calendar, and Gmail. You can enable and configure these later to change the underlying AI model or give your agent even more superpowers!

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.rssFeedReadTool","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 14960 characters]


name: Outreach for your product using Apollo, LinkedIn, GPT-4.1 and SendGrid
author_name: Misek
author_username: misek987
categories: []
created_at: 2025-07-15T19:45:39.731Z
updated_at: 2025-07-15T19:45:39.731Z
url: https://n8n.io/workflows/6039
scraped_at: 2025-12-24 13:02:44
description:
  &gt; 💛 Sticky Note: 
  &gt; This Hyperpersonalized Outreach n8n template automates AI‑powered B2B email campaigns by combining Apollo.io lead scraping, LinkedIn enrichment, GPT‑4 generation, and SendGrid delivery. Follow the setup steps below to get started in minutes!

  🔥 TLDR
  Build a scalable, AI‑driven email outreach pipeline that:
  Scrapes up to 500 leads from Apify  
  Enriches profiles with LinkedIn work history & posts  
  Filters and scores leads via Apollo.io
  Generates personalized HTML emails with GPT‑4.1 .   
  Sends via SendGrid and logs status in Supabase  

  👥 Who’s It For
  Sales teams, growth marketers, and founders who need:
  High‑touch cold outreach at scale  
  Data‑driven personalisation using real profile insights  
  Automated lead qualification and tracking  

  ⚙️ How It Works / What It Does
  Apollo Scraper: Uses Apify HTTP nodes (no hard‑coded API keys) to pull lead data.  
  Supabase Sink: Persists email, linkedin_url, and ingestion timestamp.  
  LinkedIn Enrichment: Fetches career history and latest 5 posts via RapidAPI.  
  Data Validation: Conditional nodes drop incomplete or irrelevant leads.  
  Product Description Agent: Creates a customer profile based on the product and how it can help them.  
  Story Agent: Has the persona, style of speech and rules to generate reply for the customer based on the pain points and solution found by the Product Description agent. 
  HTML Modifier: Contains a fix format to keep the output format of each mail consistent and also generate a subject for the mail. 
  SendGrid Dispatch: An SMTP service which delivers emails in large quantity and also keep your mail spam free otherwise if you use gmail node your mail will go staright to spam; updates status=true/false in Supabase.  

  🛠️ How to Set Up
  Clone the workflow JSON into your n8n instance.  
  Configure environment variables for Apollo.io, RapidAPI, OpenAI, SendGrid, and Supabase.  
  Rename credentials and test each HTTP node.  
  Activate the workflow and monitor executions in n8n’s UI.  

  ✅ Requirements
  n8n 0.300.0+  
  Accounts & API keys for Apollo.io, RapidAPI (LinkedIn), OpenAI, SendGrid, Supabase  
  Supabase to store LinkedIn id and gmails of leads, also useful to eliminate the risk of having duplicate data. 

  🎨 How to Customize
  Adjust lead batch size in the Apollo HTTP node.  
  Swap the HTML email template to match your brand.  
  Add A/B subject‑line experiments by cloning the Email Agent.  


  &gt; 🔐 Security Reminder: All credentials must be stored in n8n’s credential manager—never hard‑code API keys in HTTP nodes.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.manualTrigger","n8n-nodes-base.supabase","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.aggregate","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.supabase","n8n-nodes-base.supabase","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.aggregate","n8n-nodes-base.set","n8n-nodes-base.noOp","n8n-nodes-base.sendGrid","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent"]

workflow_json_compressed:
  [encoded data, 6328 characters]


name: AI Video Generator with Google Veo3 API (Veo 3 Fast)
author_name: damo
author_username: zengyichao
categories: []
created_at: 2025-07-16T06:51:45.451Z
updated_at: 2025-07-16T06:51:45.451Z
url: https://n8n.io/workflows/6047
scraped_at: 2025-12-24 13:02:41
description:
  Overview
  This workflow leverages the KIE. AI Veo3 model to generate AI videos from simple text descriptions.  Users interact via a form interface, inputting a prompt (e.g., a scene description), and the system automatically submits the request to the KIE. AI API, monitors the generation status in real time, and retrieves the final video output.  It's ideal for content creators, marketers, or developers exploring text-to-video AI creation, supporting intelligent video generation with minimal setup.

  Prerequisites
  A KIE. AI account and API key: Sign up at KIE.AI to obtain your free or paid API key.
  An active n8n instance (cloud or self-hosted) with HTTP Request and form submission capabilities.
  Basic knowledge of AI prompts for video generation to achieve optimal results.

  Setup Instructions
  Obtain API Key: Register at KIE. AI and generate your API key.  Store it securely—do not share it publicly.
  Configure the Form: In the "On Form Submission" node, ensure fields like "prompt" (for video description) and "api_key" are set up.  Example prompt: "A serene mountain landscape at sunset with birds flying." 
  Test the Workflow:
  Click "Execute Workflow" in n8n.
  Access the generated form URL, submit your prompt and API key.
  The workflow will poll the API every 10 seconds until the video is ready, then display the results.
  Handle Outputs: The final node formats and displays the video file URL for download or embedding.

  Customization Tips
  Enhance Prompts**: Include specifics like duration, style (e.g., realistic, animated), actions, and visual elements to improve AI video quality.

  Keywords for SEO**: This template focuses on AI video generation, text-to-video models, Veo3 API integration, and automated workflows.

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

workflow_json_compressed:
  [encoded data, 4736 characters]


name: Auto-Bidder for Freelancer.com with Telegram Approval and AI Proposals
author_name: Mohamed Abdelwahab
author_username: mohelwah
categories: []
created_at: 2025-07-16T07:06:40.417Z
updated_at: 2025-07-16T07:06:40.417Z
url: https://n8n.io/workflows/6048
scraped_at: 2025-12-24 13:02:41
description:
  🔁 Auto-Bidder for Freelancer.com with Telegram Approval and AI Proposals

  This n8n template automates your freelance bidding workflow on Freelancer.com, combining API calls, Telegram interactions, and AI-generated proposals. Ideal for freelancers who want to bid smarter, faster, and hands-free.

  ✨ Features

  🔍 Skill-Based Project Search  
    Searches for active projects on Freelancer.com using your chosen skill keywords (e.g., n8n, Python, Django).

  🚫 Duplicate Bid Prevention  
    Automatically checks if you’ve already bid on a project and skips it.

  🤖 AI Proposal Generation  
    Generates short, persuasive, and customized proposals using an AI agent.

  📬 Telegram Notifications  
    Sends project summaries to Telegram with inline buttons to Bid or Cancel.

  ✅ Auto-Bid Submission  
    When you approve a project via Telegram, the bid is submitted with predefined values (amount, period, milestone).

  ⏱️ Manual or Scheduled Execution  
    Supports both on-demand and scheduled workflows (hourly, daily, etc.).

  📌 Requirements

  Freelancer.com API token (OAuth)
  Telegram Bot API token
  OpenAI API key (for proposal generation)

  📎 Use Cases

  Freelancers automating repetitive bidding tasks
  Agencies managing client profiles
  Developers experimenting with AI + API + chat integration

  🔗 Included Workflows

  freelancerMain – Kicks off execution with skill input
  freelancerAgent – Performs project search, bidding logic, Telegram prompts, and AI proposal generation

  &gt; 💡 Tip: You can easily customize the skill query list, bid amount logic, or prompt format in the workflow settings.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.aggregate","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.set","n8n-nodes-base.manualTrigger","n8n-nodes-base.executeWorkflow","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VY224byRH9FYLPbKfvFz1FdjaBgCQOdoPsw8JYVHdXU4ypIUMO1zYMAfsZye/tl6SGlsUW2bzB2BdBGnVXnzldderUfB4/YA/jm8/jWbfuoUt4l8c3Y5Fc5i5D0CboCLIEnWNJBb2OmqesMARIBkAFyZ3DYjIXQYEToGlPGk/GPT4s59DjmxXm9Q/Yb5ZvFvQEe6QD+tUGHyfjbpFxPb75iU4fTpVSO2O8YLqgYlpFwSIaYGC4Fxq0Dh4pcgcPSKvTCin8CEaRNtN5n5bD0853bBuWRVjjq/u+X36P/9nguqc1y8V61s8WHR1JsO3Eaf6OnsKKIva4IiifH79E+hf9tV2oX8nHyRM+I4vg2QYWnPBM5+xZdDkwKAhSYQaUYYfvrhxFNSsvwTDD+USIcBaNrNCEkqBI4ExHJZl2LjJvjGJBJmVCLEKKuENzeze6nWLX7zD9kUD9YQdsDt003cOsewVP6yqAwhFAe56tHTqvoiw5CJbBEzqImgVhC/PJeCOjIh79Dt3bJXaE8M099KO/EZz5BTDnD8Py7c7ZPlrvJ96eRSvqu82U6N4DExaJUvqLAcbItEHKbckxuorN7z72K0j9nygBj17yGvdIZNJfdsvqlX7GpayRSirBVPaUcwEKZd/wm6QC1VrlKNUOF9XZXbfc9OsrUAlhr4eFoKzyinDoYIkuLVlIyjEeeQATSlDS1qUgLq4FoYklf10pFAdKqCwZz1ozbY0jklJgRSmgbBNCKFGT1OXRD5uUNuvjPPU4xykdv6caMthJsIbAfcB4v1i838pljFT7USaGwQVSr5xZMEqRcOWkk5Yq+kGiLk5GG7OwtImBy4VpdJlF0hw2pIKXPlorbP0+sEr310sgC/qyi681kGTFpFKoRCRpDd1VYSBFYcWqorTwIhWzg/YX7P+xWvwb06mMXM5n/dvNPjgnLwMnnqFJM1BjChPgKDEVpSMEqugkQZhskrKJ76D9dbFYjt7+gqvRHbWqM/DuutfQp3tc74G8tHJ2MoNoUkLLpAQSF1mQRWMl807KZGwpEaubpRPT+9eznGfd9Pr7Her6gkKqbxeTdKQpmdpJiINqKxYTUlmnIILYegJZJd5AzejL1V1zt+qyCq9ulmfUiTumUgaqBy2YlyGxUDTPSaUYUVfinAnVn2c4z1fIoOUXYao1MHlSvKITE5nnwQ7QNYIEho5IpJqVhVd25XY6XeH0VMOAakWFzMsr2SpeyWi5oqQa1CinSDYqW5aC5d5EcinZ19osL9dmrq/W5oTeAHUwZmMk1QgZWeDcMkFGMkTrcwH3QjBul8vV4heYXynNQj6ney3NHjT3KAQrPBIZKtHxMUlG5s17aqQqGH6VNFO2lRI8CV4iac4SGVj6gdIDWG29hbR7nTeDo55jHl37Ms75ycD27/w2VNfeRS6YC5Qg1Dg1NRrLGXqHHBNZ8Fi5nh/vsRt99xHThkz8KH4a3XaL/p4U9MfF6n2ZLz4cfUv8sunrun+uZtMprvaNiB76keQX+DZR+bacYyYTTi2RGIFAdpxyikkXEgqgOnCVYt3OaWjIn16fmBgOlGGbWPa8m6ylQZO79Slmcm12cJOSUzEGcr8hIi88B1KMPV7TfJbek86Pfvv1v08cjz488fXbr/87ivcBug3Mm4zqYaow8grpCN4KqYtkxiXKB3Jyg2FXTFBhgYghUUeoXfAXmNde/76oDF3UXgCzSlwVMQCXjsVYDE1A3jDP/TA0Kl2gmGRi3aiokebNHEc7mo5c/tPC43S663AKR0YdkdKTsnIwy+TkChBimjegaDKtKTc713HDfNi65GX8vUhQHbmRJpNhdzSecZEZUHNnjgZcgYrSNNYO82ujP4Gq2em9vvBqd4SRVaaZC5gdDC8N/YYUSVLzQlFA+0wCWF9sT0XzafT3xak5bLvmaclLvSEfQql9gG6cFl0/zMA34/EhUlpN/+/I09KD7XKa9OnnAw2lFPanz9vPGseGxO2qyXjWZfw4vuGP797RCcN81IpwOLQfbJ/sVjeazZHTZPu0hjieOq/Zq5snPk0orUObE0IzyDMZrTDtj0HtOM82qxXohR1q7t/R3Np/dKw4QszXeb0Va3+wa4d4NuHNHGx54dNx2ql4XOub0epzm7l26Ibbcaoa+na664xtX744H+E5XdsRLiemTXRLa4/kTvUZ49u5eTFrngR2LlBdiu20bn1/acbaf4UqXK1E7Tm5zdq+FThTNedu4fDLJQWE2c/Dd8oNTPHp2UlRP1i+f8h5493m+eBjYPMVLrKf30TT4+P/Ad1BlThoGAAA


name: Automate Post to Multiple Facebook Groups with Airtop, Google Sheets & Telegram
author_name: Khairul Muhtadin
author_username: khmuhtadin
categories: []
created_at: 2025-07-16T07:16:54.726Z
updated_at: 2025-07-16T07:16:54.726Z
url: https://n8n.io/workflows/6049
scraped_at: 2025-12-24 13:02:46
description:
  The Airtop Facebook Automations workflow solves the challenge of managing and posting content across multiple Facebook groups effortlessly. Leveraging Airtop for browser automation, Google Sheets for group management, and Telegram for notifications, this workflow automates posting repetitive updates without manual intervention. 

  Watch it on work on Youtube

  Why Use Airtop Facebook Automations?

  💡 Key Benefits:
  Save Time & Effort:** Automate posting to dozens of Facebook groups with a single trigger
  Consistent Messaging:** Avoid errors by automating precise posting steps, ensuring your message appears correctly every time
  Scalable Engagement:** Easily maintain active presence on multiple groups simultaneously, boosting your social reach and brand awareness
  Integrated Notifications:** Receive instant Telegram confirmation for each successful post, keeping you informed without checking Facebook manually

  Who Is This For?

  ⚡ Perfect for:
  Social media managers looking to scale Facebook group engagement without adding workload
  Marketing teams aiming to streamline content distribution across communities
  Small business owners managing Facebook groups for promotional updates
  Community moderators who post recurring announcements to multiple groups

  What Problem Does It Solve?

  Posting the same message to many Facebook groups manually is time-consuming, error-prone, and inefficient. Navigating the UI repeatedly can lead to fatigue and missed deadlines. This workflow automates browser interactions linking Telegram-triggered content creation with dynamic group lists from Google Sheets, eliminating manual browser clicking and typing—saving you hours while maintaining consistency and control.

  How It Works

  🔧 Workflow Steps:

  ⏱ Trigger: Listens for new messages in a Telegram chat to capture the post content
  📎 Browser Setup: Initializes the Airtop browser session with a Facebook profile
  🔍 Data Retrieval: Retrieves your list of Facebook groups dynamically from Google Sheets
  🤖 Group Processing: For each group, opens the Facebook group page, scrolls down, and interacts with the post input field
  💌 Publishing: Types and publishes the post, then sends a success message back to Telegram with group details
  🗂 Loop Management: Waits 5 seconds before looping to the next group and closes the browser when done

  Setup Instructions

  🔐 Getting Started:

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

  2. Set Up Credentials
  Configure the following credentials:
  Airtop API:** Requires your API key from airtop.ai
  Google Sheets OAuth2:** To access your Google Sheet with the Facebook group list
  Telegram API:** For message triggers and notifications

  3. Customize Workflow Elements
  Update the Google Sheet URL and sheet name with your group data
  Adjust the Telegram chat ID or bot to suit your notification preferences
  Modify post message content as needed via Telegram input

  4. Update Required Elements
  Facebook profile login embedded within Airtop credentials
  URLs for targeted Facebook group pages must match your groups

  5. Test Thoroughly
  Test your workflow using realistic group URLs and Telegram messages.

  Pre-Requirements

  🧩 What You Need:
  Active n8n instance (Cloud or Self-hosted)
  Airtop account API key
  Google account with access to the group list spreadsheet
  Telegram bot and chat set up for sending and receiving messages

  Customization Options

  🛠️ Extend the Workflow:
  Integrate scheduling nodes to automate posts at specific times of day
  Add error handling to skip groups if the post fails and log results
  Extend support to Facebook pages or event posting for broader social media management

  Technical Details

  🧠 Nodes Used:
  Telegram Trigger:** Captures incoming messages
  Set:** Prepares post content
  Airtop:** Handles browser automation (Start Browser, Load URL, Interactions like scroll, click, type, publish)
  Google Sheets:** Fetches group list
  SplitInBatches:** Iterates over each group
  Telegram:** Sends success messages
  Wait:** Manages pacing between posts

  Support

  📞 Get Help:
  Made by:* *Khmuhtadin**
  Tags:** Automation, Facebook, Social Media, Airtop, Telegram, Google Sheets
  Category:** Social Media Automation
  Custom Solutions:* *Contact Me**

nodes_used:
  ["n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.set","n8n-nodes-base.telegramTrigger","n8n-nodes-base.set","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.airtop","n8n-nodes-base.telegram","n8n-nodes-base.wait","n8n-nodes-base.airtop","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Y2W7bShL9FULAvKmD3he/xVmMAPdOAuTODGYu8tBLtUxcWRREegkM//sU5UWU1JTNzLwYskhVn66uc+pU38/qNDubLeR//vjt31d3Fx8WF/ofFxez+ewKOj87u5/Vq7bzqwhf+vci14oaJ7KWkjqWoqU5OEozaCGl9YllGYyRlNoETlNLtUzacCezFdREjNvB1XrpO/iwgdR+h+56/aHBb6ADXKDbXMPDfLbyV4Crva83XbOuPvsIoWn+qt5fd82V7+pm1faB/KKdnf35A19vEvQf7x83YyW4HCUlDpIlUglBgrCKaA8OMs9Zgpy9LNKsYVUtNs31uo/5c91/t7Irsg1Kgm/hnd/iwMfrpq375XEtgVuccy5x+bXfYKgONojh/uExyD/xv+2L7GH+BEsyqTP3mSQtA5GYGuKFk4Rz4YI3ipnkd7C+x02zXGr6t2mouODTUDngSgIzxHsdiQwqEK+tJDYHkQxPgULcoYrLOv5V4YJdFZq7adC0pdOgZW2TAZGJU4kSyTMj1lOFJ+oD48wAluIO2gV01bK+geqmhttJyLjRds7024El7Q0kCAQrH3NmqCcICEiwFAxFZDId5SwumxaqOlfdJWygxRyur9fVVZP88nWwqW59WD4TBLnp7/7Y1H3N8/2dOMfLO9lAt/n5dfXZ18vnICObY8pDYhbL1HnMtaTIHkMDiSEqG5DPQabd5j5sN9c1VXtbd/GyWm+aXC9h+pb2ipjpSecRktAeRYn4HDiRMWUSaERmuRy00jIKP4B87h8RXzZXb8A5zC7TWMHWvh2YUcB7bMRYLQlWhSNBQs81FEVBFbUyHlK+ala/AA3ZNQ2a9BaAYtHKwJFcICjxPKEk6Qwh8iBCHuQMdbq6grb1C6j8KlXx0ndf0ijEFrp9fMywkcLcgyfeyZ0w5eQtM4IgHjxUoYC4aDWxijMXheNRDeWy85tuFE8HS1jgukiaxQI2B9gUlY/YbiFcYp/ZdjoGSlmFyztrkOPaKRIgWCwslKWYKDeOzV7L9ju+o1Xg2I50IEplTLoQhqDWGtyO9CYDc0bL/Xy3mG8M8yVtM35br1JzOyXnXKjJOU+CS4uZxlLFzpmzRu21lIBFvYvGW2PlUb1+bG5Xla/O6/H8F0tWmWksdyj4OihNYsauKUUIxDIfCVLMeRcZFsagIL72bf0jtDXajOrbW1XpsGQnUcoZoylDIikVNEHhxIr1rCcXd5QxJ1R0g+w9CiYK0f+E0gk9UZMiBTRsibDA8Iw1/kGUiUTtmQOhEpeDM+676kVvjqrf6nb8gBdNs1jC90uArj085reJpnynd9qETVSrBETwgNwTKOUWDSXRItHoTADH9Q7it96NYBo/eUznxUkj166Xdfdlde4x83AIFGt7Ljh9lS8vMFFA0bi5QIxBIksOKKEgEgkhWBaV8uiNh52yNwDnm+a23SrQRKspp1BFZCsDKhWxQJHMhivijOpNHZphbOKUWX6gnb+EbFt9kzjsYjRKeJQVh8UnHcOuIxWaC6oMzTZ7zw84/Oz+p7fqKcBU8hAVcwSPMhPJMHchU4aWTohMnWRsKC7/2tQdVH3hTTtIayfODAEk99YLzJJCIbEaj5QmtJtGJxysgjJMDZhwHZZ1e/kLwFD151JPAKaFYhknFwIseKSowbJnShHlrcO6jxab9g7YZ2xeW1TV+dSpQSo9LWXKeTzK3sngXIWzAnC0WywTRoWjCmcdHP+Oetj7jHG3COvVYjrASanLLATXO2oXsb/K4BFg38zwPCUDR7MXdugEMHXfr2NEN1D9/mjBXvU5hcnrEeLQ4UjmgzRIPjQ0KBIyozlNEmes7A0DMM7ySQ7HAEtG9TVAoR/SgBGXkVHcSo0TBApSEgMK+bqrVPUdYrNK7eiObn19YGvwFGVhNyzIiGRhxDiJPQPtFPGMZwI0O5sEugNmXt/NcPjUyWrUgoz+DK1Q7zxZxlkIJ3UuDWPMDIfPpu9A3/BsxrfyltFn60UntfNsPCYXEkE+Yg1JHOItx+nNWhGEx3AxsaHU47j2s/p7040XUbt95+mVITbsI3PpjkR1hifYwarDSLNjnPi2jx3O5bOz7JctbheNas+y7U/hDuJ1H//rJmHvOZvd9GBbfwO/+9W1X356ft4+J6t/9vItOqYFDtN7Dz/6zn/abJrNy1sY1i+Xs93jJzodvoDgbx6BbyuKMzAZGzkRAgVYUqkxP6graJ+YVBTJq3oXgrtfQXzCeP80iOCHK1/3Wfvzfns99YYZavuD+QylEu5mZ/Thxw8EtLsGKoUc0dVipEHPKoUq945ipMGNWXGfxzdXxTBDzpTinHbwxZB7o/04tuMRuxhtLyUnoo00j2LM/RMrBR27YivncO/Sazzcm26fiivse7Cxun5tVi3X9p7vHC2BYwM4morBpFKs8ROTwgn2vZRLKebYgFTm4H7T+79gPKiXUsySXT2138FEP7blwk1rmUPH2ymFHBmOjkLOdz8p3duPV/ChjhQL+fWJ/FTW9mWgzJRTXq4cu/ST4hmP+KmRqMVWVMRcHg6LYccug4tFVHJMZbCjx1KKW77dHc3CiHCdUPvSddcJYp5S3jITXrlQL6z18PBf9wj8XccbAAA=


name: Auto-Generate SEO Blog Posts with Perplexity, GPT, Leonardo & WordPress
author_name: Cristian Tala Sánchez
author_username: cristiantala
categories: []
created_at: 2025-07-16T19:30:27.640Z
updated_at: 2025-07-16T19:30:27.640Z
url: https://n8n.io/workflows/6067
scraped_at: 2025-12-24 13:02:41
description:
  ✨ SEO Blog Post Automation with Perplexity, GPT, Leonardo AI & WordPress

  This workflow automates the creation and publishing of weekly SEO-optimized blog posts using AI and publishes them directly to WordPress — with featured images and tracking in Google Sheets.

  🧠 Who is this for

  This automation is ideal for:

  Startup platforms and tech blogs  
  Content creators and marketers  
  Solopreneurs who want consistent blog output  
  Spanish-speaking audiences focused on startup trends  

  ⚙️ What it does

  ⏰ Runs every Monday at 6:00 AM via CRON  
  📡 Uses Perplexity AI to research trending startup topics  
  📝 Generates a 1000–1500 word article with GPT in structured HTML  
  🎨 Creates a cinematic blog image using Leonardo AI  
  🖼️ Uploads the image to WordPress with alt text and SEO-friendly filename  
  📰 Publishes the post in a pre-defined category  
  📊 Logs the post in Google Sheets for tracking  

  🚀 How to set it up

  Connect your credentials:
     Perplexity API  
     OpenAI (GPT-4.1 Mini or similar)  
     Leonardo AI (Bearer token)  
     WordPress (Basic Auth)  
     Google Sheets (OAuth2)

  Customize your content:
     Adjust the prompt inside the HTTP node to fit your tone or focus  
     Change the WordPress category ID  
     Update scheduling if you want a different publishing day  

  Test the workflow manually to ensure all steps function correctly

  💡 Pro tips

  Add Slack or email nodes to get notified when a post goes live  
  Use multiple categories or RSS feeds for content diversification  
  Adjust GPT prompt to support different languages or tones  
  Add post-validation rules if needed before publishing  

  🎯 Why this matters

  This workflow gives you a full editorial process on autopilot: research, writing, design, publishing, and tracking — all powered by AI. No more blank pages or manual posting.

  Use it to scale your content strategy, boost your SEO, and stay relevant — 100% hands-free.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","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"]

workflow_json_compressed:
  [encoded data, 6848 characters]


name: Generate and Auto-Evaluate Facebook Ad Headlines using GPT-4o-mini
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-17T07:59:55.065Z
updated_at: 2025-07-17T07:59:55.065Z
url: https://n8n.io/workflows/6081
scraped_at: 2025-12-24 13:02:45
description:
  Generate and Auto-Evaluate Facebook Ad Headlines using GPT-4o-mini

  Built with n8n + OpenAI

  This workflow captures a product description, generates ad headlines, evaluates them with custom criteria, decides whether another draft is needed, and finally sends the best version via Gmail.

  ⚡ Section 1: Capture the Brief & Build the Prompt

  📝 FormTrigger\_CopywritingBrief* → A simple form asks: *“What is your product about?”
  ⚙️ Set\_PromptForHeadline** → Prepares the input by appending the instruction:
    “Write a Facebook ad headline for this product:”

  Benefit: Ensures consistent, structured prompts so the AI receives clear context every time.

  ✍️ Section 2: Draft the Headline

  💬 LLM\_HeadlineWriterModel** → GPT-4o-mini model provides the intelligence.
  ✍️ Agent\_HeadlineWriter** → Generates a first-pass Facebook ad headline.

  Benefit: Produces creative copy instantly without waiting on a human writer.

  📋 Section 3: Define Scoring Criteria

  💬 LLM\_EvalCriteriaModel** → Calls GPT-4o-mini again.
  📑 Agent\_EvalCriteriaBuilder** → Suggests 5 scoring parameters (scale 1-10).
    Example: Clarity, Relevance, Hook Strength, Brand Voice, Scroll-Stoppage.

  Benefit: Builds an objective, repeatable evaluation rubric automatically.

  🔍 Section 4: Evaluate the Headline

  💬 LLM\_HeadlineEvaluatorModel** → Supplies reasoning power.
  🔍 Agent\_HeadlineEvaluator** → Applies the 5 criteria to the generated headline and outputs:

    JSON with scores per parameter
    An average score
    A plain-language bottom-line

  Benefit: Turns subjective copy quality into measurable numbers.

  🔄 Section 5: Decide & Iterate (if needed)

  💬 LLM\_BottomLineModel** → Interprets the evaluation results.
  🤔 Agent\_IterationDecision** → Decides:

    Return NO → headline is acceptable.
    Return YES + feedback → headline should be rewritten.
  🔀 If\_NeedMoreIterations** → Branches:

    If NO → continue workflow.
    If YES → (loop wiring possible) headline can be regenerated with feedback.

  Benefit: Keeps iterating until the AI headline meets your standards.

  📩 Section 6: Deliver the Result

  📧 Send a message (Gmail node)** → Sends the accepted headline via email.

  Benefit: Automates delivery of the polished, AI-approved headline to your inbox or team.

  📊 Workflow Overview

  | Section              | Purpose                            | Key Nodes                                             | Benefit                        |
  | -------------------- | ---------------------------------- | ----------------------------------------------------- | ------------------------------ |
  | ⚡ Capture Brief      | Collect product info & prep prompt | FormTrigger, Set                                      | Structured AI input            |
  | ✍️ Draft Headline    | Generate first headline            | LLM\_HeadlineWriterModel, Agent\_HeadlineWriter       | Instant creative draft         |
  | 📋 Define Criteria   | Build scoring rubric               | LLM\_EvalCriteriaModel, Agent\_EvalCriteriaBuilder    | Objective evaluation           |
  | 🔍 Evaluate Headline | Score headline & summarize         | LLM\_HeadlineEvaluatorModel, Agent\_HeadlineEvaluator | Transparent quality check      |
  | 🔄 Decide & Iterate  | Accept or refine headline          | LLM\_BottomLineModel, Agent\_IterationDecision, If    | Only good results move forward |
  | 📩 Deliver Result    | Share the final copy               | Gmail                                                 | Automates delivery             |

  ✅ Final Benefits

  🚀 One-click workflow: from product description to tested headline.
  📊 Automatic rubric: objective scoring each time.
  🔄 Self-improving: poor headlines can auto-iterate with feedback.
  📧 Direct integration: approved headlines land in Gmail instantly.
  🧩 Fully modular: easy to extend with Google Sheets, Slack, or CRM nodes.

nodes_used:
  ["n8n-nodes-base.gmail","n8n-nodes-base.formTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5056 characters]


name: Lead Outreach Automation with Google Sheets, Gmail, and n8n Workflow
author_name: Muhammad Qaisar Mehmood
author_username: qaisar
categories: []
created_at: 2025-07-17T09:05:11.461Z
updated_at: 2025-07-17T09:05:11.461Z
url: https://n8n.io/workflows/6083
scraped_at: 2025-12-24 13:02:41
description:
  🎯 Goal

  Every 60 minutes:

  Fetch only “New” leads from a Google Sheet  
  Send them a personalized email  
  Update their status to “Contacted” in the same sheet  

  🧩 Step-by-Step Explanation

  1️⃣ 🕒 Trigger: Run Every Day  
  Node Name: Schedule Trigger  
  What it does: Automatically starts the workflow every 60 minutes (or your chosen interval).  
  Why it's needed: You don’t need to run the workflow manually — it runs on a timer, like a robot doing your follow-up.

  2️⃣ 📄 Fetch Leads from Google Sheet  
  Node Name: Fetch Leads from Google Sheet  
  What it does: Connects to your Google Sheet and pulls all the rows of leads.  
  Expected columns:

  Name  
  Email  
  Status (should be "New" if not yet emailed)  

  3️⃣ 🔍 Filter Only New Leads  
  Node Name: Filter Only New Leads  
  What it does: Filters only rows where Status = New.  
  Why it's needed: Prevents emailing the same lead twice. Old leads are ignored.

  4️⃣ 🔁 Batch Process Leads  
  Node Name: Batch Process Leads  
  What it does: Splits filtered leads into individual batches (usually one-by-one).  
  Why it's useful: Helps avoid API rate limits or spam blocks by sending emails one at a time.

  5️⃣ ✉️ Send Email to Lead  
  Node Name: Send Email to Lead  
  What it does: Sends a personalized email to each lead using their name and email.  
  How personalization works: Use variables like {{ $json["Name"] }} in the subject/body.

  6️⃣ ✅ Mark Lead as Contacted  
  Node Name: Mark Lead as Contacted  
  What it does: Updates the row in Google Sheet, changing Status from New to Contacted.  
  Why it's important: Ensures this lead won't be processed again next time.

  🔁 Loop Back

  After updating the lead status, the flow loops back to process the next lead from the batch.

  ✨ Bonus Touch

  This automation is clean, efficient, and scalable. You can later enhance it by:

  Adding AI to write emails dynamically  
  Sending follow-up reminders  
  Tracking performance stats in another sheet  

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.splitInBatches","n8n-nodes-base.gmail","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  H4sIAAAAAAAAE62WwW7bRhCGX2XAiy9agaQoktaxbRIYaJOiSQsUhg/L3aG4ELUrcJdRVUNAAqSHHooCTXpIkSKnAn2EPo9foHmEzpKqLDuS47g9iSBn5p/5dmZW54E2Em0wOT0PlAwmQZiJQso8ZrEsI5ZEWLA8LEdMlJilscBIjjEYBJrPkayfNGo6xWYCX7Ua7j3FZgWf8RW8e/vrL2TkVgtvpHPNOhVWcItDKyqUbY0bXx/MOJ9C8O7tqxfwpFIWvDm43sCCqxCWppmVtVkCdippCHOlW/IbwremBcE1iIrrKYJy4AxIruoVmAaWiDN64hQUUaIckuDCWOWU0VT2KA0H4zA8o5e8oaIcCQaT8/UmqxN9n0SDiWta7Av6hgw612gYrwcbahyTvOBhwmQS5yzhfMSO4yhmZZEc8/I4FhnfoXYfnajgc+TSQtmYOTwwZlojPK4QHcF7+eIgvGln2RnaK+Re/rFDrulCS+54H39l2uaqyMWzVx6UrUxbSxBGO6401J3fUrkKfKoDwDlhHADXEqzjrrXX6KXhXeklw/GWnipZqWryZRqXO5i6d/BI0/E9xOUGGDXJTwfxqHIHysWbH3om1HBiZkGVXSf5Io/sph6gz0cU/GjY65CBxS2HuoYCewjUOPCIvlI78gbBztRi8V4z5XfGEW1hRGnKSxyHjPOsYAkmKcuxEKyQx2ki0yzEUXLJ6BPuW+nLxgi09pLQ88PTt6iVO9GdH+620MVvr//+6+ceWIX1wsJiE7WnYTSyYsXox08VNYudc+IjqlbPaAi/tli2NZT0reEOWa3myiG1DTZPFYWBWs0QHniU16BF4Z2pjbbUwjhP0iiRNIAjZEnMI5aPRcniNMswTEsRlTvUHiM19D2fi18VnhpcvPmRyj88d9746sD9uTNwlgISMMrLaF6r76nwrmsstFbp6abu7aZqqcfOzx9SMuv1gJ66VNZrT7UbVT+PqN11UHEcDpLYg1piURkzO+l2j8xFHiZIBWeSds9xwoosjlk6LsIsS8tIRmHw8Wzj4WVPpjHmo0jQLZBmgiVFKBgPC8nGmPC8FEU8KtNLul/wZtZDpaX7qV8twncCjeMd1trvPeV2QdsM+6vAkszVbUaHOPei/463Fz7aKh+BNX7ZLY2+ePba+ZHetDZlxae0+K6DJsj/Ya2RGx2gRuHDeb/DU0rf6Oi95unZgK5gj+R2/dm5DQKlJX4XTML12Rlld9hvR2ircptz2itzw2Lep/PhHfWeyuC0E7ohw/9JyKvc9Cdmn8zHXN/7+X04wF7dW9yHe/TW638A7MHc5eUJAAA=


name: Viral Video Generator: HeyGen to TikTok & Instagram Auto-Post + Any Content
author_name: Reddit Dev
author_username: harryhaz
categories: []
created_at: 2025-07-17T09:28:15.763Z
updated_at: 2025-07-17T09:28:15.763Z
url: https://n8n.io/workflows/6084
scraped_at: 2025-12-24 13:02:44
description:
  HeyGen AI Video Generation with Social Media Publishing

  Description

  This workflow automates the entire process of creating AI-generated videos from trending news content and publishing them to social media platforms (Instagram and TikTok). It runs daily at 6 AM, finds viral-worthy news, generates scripts, creates AI avatar videos using HeyGen, and automatically publishes to multiple social platforms.

  How it works

  Content Discovery & Script Generation
  Schedule Trigger: Runs daily at 6 AM or any time you choose. 
  Perplexity Search: Finds trending news articles that would make good viral content
  Write Video Script: Uses GPT-4.1 to create a 30-second video script with hook, main content, and CTA
  Extract URL: Parses the article URL and script data for further processing

  Video Creation Pipeline
  Get Screenshot: Uses ScreenshotOne API to create an animated scrolling video of the news article
  Upload to Cloudinary: Temporarily stores the background video
  Write Video Caption: Generates an engaging social media caption (150-200 characters)
  Prepare Avatar Data: Combines all data needed for HeyGen video generation
  Create Avatar Video: Sends request to HeyGen API to generate AI avatar video with:
     Talking photo avatar
     Text-to-speech voice
     Background video from the news article
     720x1280 dimensions (vertical format)

  Data Management
  Prepare Sheets Data: Formats video metadata
  Store to Google Sheets: Saves video_id, caption, timestamp, and status for tracking

  Webhook Processing (Asynchronous)
  HeyGen Webhook: Receives callback when video generation is complete
  Process HeyGen Callback: Extracts video URLs and status from webhook
  Get Caption from Sheets: Retrieves the associated caption using video_id
  Combine Data: Merges video data with caption

  Social Media Publishing
  Upload to Blotato: Uploads the completed video to Blotato media service
  Extract Blotato URL: Gets the media URL for social posting
  Assign Social Media IDs: Sets the account IDs for each platform
  INSTAGRAM: Posts video to Instagram with caption
  TIKTOK: Posts video to TikTok with caption and appropriate settings

  Setup

  Prerequisites
  API Keys Required:
     Perplexity API (for news search)
     OpenAI API (for script and caption generation)
     ScreenshotOne API (for article screenshots)
     HeyGen API (for AI video generation)
     Cloudinary account (for temporary video storage)
     Blotato API (for social media posting)
     Google Sheets API (for data tracking)

  HeyGen Setup:
     Create a talking photo avatar and get the talking_photo_id
     Select a voice and get the voice_id
     Set up a webhook endpoint in n8n for callbacks

  Google Sheets Setup:
     Create a new Google Sheet
     Add headers: video_id, caption, timestamp, status
     Get the sheet ID from the URL

  Social Media Setup:
     Connect Instagram and TikTok accounts to Blotato
     Get the account IDs for each platform

  Configuration Steps

  Replace all placeholder values:
     YOUR_TALKING_PHOTO_ID - HeyGen avatar ID
     YOUR_VOICE_ID - HeyGen voice ID
     YOUR_WEBHOOK_URL - Your n8n webhook URL
     YOUR_GOOGLE_SHEET_ID - Google Sheets document ID
     YOUR_INSTAGRAM_ACCOUNT_ID - Blotato Instagram account ID
     YOUR_TIKTOK_ACCOUNT_ID - Blotato TikTok account ID
     YOUR_CLOUD_NAME - Cloudinary cloud name
     YOUR_UPLOAD_PRESET - Cloudinary upload preset

  Add credentials in n8n:
     Perplexity API credentials
     OpenAI API credentials
     HeyGen API credentials (create custom API credentials with X-Api-Key)
     Blotato API credentials
     Google Sheets OAuth2
     ScreenshotOne API credentials

  Configure the webhook:
     Copy the webhook URL from the "HeyGen Webhook" node
     Use this URL in the "Create Avatar Video" node's callback_url

  Notes

  The workflow uses a two-part asynchronous process: initial video creation and webhook-based completion
  Videos are optimized for vertical format (720x1280) for mobile social media
  The Google Sheet acts as a database to link video IDs with captions
  All sensitive content (URLs, API keys) should be replaced with your own values
  Consider content moderation and copyright when selecting news sources
  Monitor API usage and costs, especially for HeyGen video generation

  Customization Options

  Content Sources**: Modify the Perplexity search query to target specific news sources or topics
  Video Style**: Adjust avatar position, scale, and background video settings
  Voice Settings**: Change voice_id, speed, and pitch for different narration styles
  Publishing Schedule**: Modify the Schedule Trigger for different times or frequencies
  Social Platforms**: Add more platforms by duplicating the Blotato posting nodes

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.perplexity","n8n-nodes-base.openAi","n8n-nodes-base.httpRequest","n8n-nodes-base.openAi","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.webhook","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code"]

workflow_json_compressed:
  H4sIAAAAAAAAE51Y227bOBD9FUFPu4AZkBRFUXnLJm1qtLsp4rRFsSkCXka2sLbkleQ02SD/vqPY8S2UL31JfKEPj8/MnJnxU5i78DQMe+EEGh2ePoUNTKZj3cB5Ba4eQDObnpf4CjSABzM9ruG5FxZ6AvixD/B4CUVw1g++5g7KAJ9ApZu8LIKfeTMKBqXN9Tj4E1yug88zM87rUV4M8bZGD+vw9O8fCFU6aB8+zZkwTpPEKEHSKNFERCwhmnFJFNXaxIZHjEG4JDCwI3CzMQQXOh8/BjdVPhxC1eI/Ttv3C1WQlwuI0TWc1Ivjq3PTss5bvkiAcKV6jCvkNNUV4jdQIbGn5znaV3z2cpCd8Ofegq0xANTFijDFLRHWWqKMYiTVMRWx0VoavWL7GSoU8iFvHoMB6MqOOolOlye3OEpxEMUlQcpsKjIrSZJKlFNqSVLnOGGJ1M7YSLHIrgh+q/IGFrEc2CqfNp0MyykUZ/kmOybpYQKu+DEdUSeFJDxWEREJY0QrnREW0QhslEECawJeQtPyAijqUdnNbdQ002v4dwZ1s0lQ0q4IV9BUj1fFe0yj8LSpZrDFWawFnavMmUjFRFMdY9AVJ6nNKNFWiUQwEwFN/Jqe6+kLk6NE5eLAtFypyiMnQQpKYsswLUWiiGEsJZYLG1mQNpNrqr57aCptm+DL9adOZhYfbvKK1EGpuJIt1kyBYIpQ0Va2FlgmxmFmOiox+hDTbC0VP1eAuBCc3etGV1jfjT6CHBOxPJKdzBQKlWAiJo4I7hxaDkiiEwZGS8c4W2OH5ogW+UpuHtzfrjC4k/w/cL8fn5lMqoNqZz0PE8eVdRQIUEqJYElKtARFHLWxkpxRa/maVTYlytmgSZflEB1zMAJo6k6mw5dTy0NF2bQuHX4vZ0EB4BDo9LZgJ8FCCb0Be1vwk+DMuWAE2iH10+C+legud73AzmugF6BYKIOeTHsB/mtm9W0RnQTXgN3HQvD96sv13eXV1eWnd3eDD+/e3dz1L+ZNBVN1hk2lf3FbCLy/LArA5H0sZ9UrB21tOSu2FOaobofCL1+uX7wflz87ij9eiW6kTgWLiTSRJMJpSlKacmIozYzIuMFkfpvFcx2PzuKUHlljOhOJ1coQ5vCPcAm6kjOCUKl1rCx6ql5jt2jf38CMyvKfTmI/l+9vd0uh6OHcVIJOmaZYYdwqtHrJ2qaeEUBeLkvAZiJaV660UNfBguO5Ho+Ntt0k36rX9srjCGL/MlmaEhpbrCcbORxCREqYjdKMZ5EEF232ooWfB1lVTn6xoG5GeR2MUd46mE2DZgTLUgnyYrNW2+Id4q3tIbvsJFv91/+Nj8nwjAuaiRjnLuApEUoCMXGUEQkJBi4yFg1xzQnLickLODa12+5xVHC4pVJpBejPFOsu1Rz5oeMJFplYOiNtylaszuo6Hxab82f/ojs4NWz7MeUHEYxOxJJixIAlmkUki7B7CJe1roD+QJWW1GYpy/RaC+n/Nbg5u7w++/MXmkU7EqCCxzQLybM00daQhAqO/Q3nasNphP0ttdRq2lrXitxN/+PN1cdfZBan/BhmxnIp2+nPxRyZMaNIGmcRYTjxU4etLWFrw8qX6bjUbfsJmsk0y8fQHdROlljox/ZaADQpbmJCmWFYFDQjKhaGGIgtNgHnkmxtLXmdqPZS9Hh+m3hHeT4zzmqBgmEEcdij3BBlcc6XEShwXAtnpU+/P8Yltt3yePkwvoeUxrp8sU1jniaYfTHF2S9t+5KAhCQGU8/FWSpt/Fa+BcMjB1NFu1xwS0A8gbfk97DYa3sh2kCD+2l7PIQHsLMW8qrCEQYvvmchYtzPP99fbM12Pn7gKy8fWh+l8elE5y0j3G1bxjsWmJeDvTAvHDyEp/T5xw+8asNafWg7YukF3Lp9N+Tb3PVibs0QPsy9rdwL/KaGfNA7lysv7PIXg9ffALyMuxd1L+jb8/vIbm/XXti38fXB7qyWPbg7xe12MS+q5+vtQt1P0/fFfIh7m70/Zp4F04d+8Kq385b1BcB3y77tbK/ir9nvL8Adu7QXuUtSH7pnkNnG7C0Pbw8WnT7lG6294fHOnx2x8PtQl1HvnO79jr0nV3YFx7siem55fv4fR7gZdrQVAAA=


name: Automate Cold Outreach with Email Personalization using Gemini and Google Sheets
author_name: Intuz
author_username: intuz
categories: []
created_at: 2025-07-17T11:29:30.596Z
updated_at: 2025-07-17T11:29:30.596Z
url: https://n8n.io/workflows/6089
scraped_at: 2025-12-24 13:02:43
description:
  This n8n template from Intuz provides a complete and automated solution for powerful cold outreach campaigns.

  It connects a Google Sheet of prospect data with Google Gemini to automatically generate highly personalized emails. By analyzing specific keywords and data points like company name, industry, or job title from your sheet, this automated workflow crafts unique, relevant messages that feel one-to-one, creating a complete system to dramatically improve your engagement and response rates.

  How it Works
  Manually writing personalized emails for a long list of leads is a significant bottleneck. This workflow eliminates that friction by creating an automated system that reads your lead list, understands the context, and writes compelling drafts for you.

  Scheduled Lead Processing:** On a schedule you define (e.g., daily), the workflow automatically activates to process your lead list.

  Fetches Your Lead List:** It connects to your designated Google Sheet and reads all the lead data you've prepared, such as names, companies, roles, and any custom notes or pain points.

  Intelligent Filtering:** The workflow is smart enough to know which leads have already been processed. Using an "If" node, it filters out any rows that already contain a generated email, ensuring it only works on new, untouched leads.

  AI-Driven Personalization (Google Gemini):** This is the core of the engine. For each new lead, it sends the relevant data to the Google Gemini Chat Model. The AI follows a custom prompt you define to draft a completely unique email, including a compelling subject line and a personalized body.

  Structured Data Output:** The workflow uses a Structured Output Parser to ensure the AI's response is always in a clean, predictable JSON format (e.g., {"subject": "...", "body": "..."}), making the data easy to handle in the next steps.

  Seamlessly Updates Your Spreadsheet:** Finally, the generated subject line and email body are written back into the correct row for that lead in your Google Sheet, ready for your team to copy, paste, and send.

  How to Use: Quick Start Guide

  1. Import Workflow Template:
  Download the template’s JSON file and import it into your n8n instance via “File” &gt; “Import from JSON.”

  2. Configure Credentials:
  Google Gemini: Create and apply your API key credentials to the “Google Gemini Chat Model” node.
  Google Sheets: Set up and apply OAuth credentials for the Google account that owns your lead spreadsheet. Apply this credential to both the "Read Leads from Sheet" and "Update Sheet with Email" nodes.

  3. Customize Nodes & Spreadsheet:
  Prepare Your Google Sheet:** Ensure your sheet has columns for lead data (e.g., FirstName, Company, Role) and empty columns to receive the output (e.g., GeneratedSubject, GeneratedEmail).
  Read Leads from Sheet:** Double-click this node and select your spreadsheet and sheet name from the list.
  If Node:** Update the condition to check your specific output column. For example, if your output column is named GeneratedEmail, the condition should check if {{$json.GeneratedEmail }} is empty.
  Basic LLM Chain Node:** This is the most important step.

  Edit the Template prompt to match your product, service, and desired tone.
  In the Template Variables section, make sure the values (e.g., {{ $('Read Leads from Sheet').item.json.FirstName }}) match the exact column names from your Google Sheet.

  Update Sheet with Email Node:** Select your spreadsheet and sheet name. Set the Lookup Column to a unique identifier for each lead (like their Email address). Then, map the output from the Prepare Data for Sheet node to the correct destination columns in your sheet.

  4. Test & Activate:
  Test Run:** Click “Execute Workflow” to perform a test run. Check your Google Sheet to see if the first unprocessed lead was updated correctly with a new subject and body.

  Activate:** Once satisfied, toggle the workflow “Active” switch to enable it to run on your defined schedule.

  Requirements

  To use this workflow template, you will need:

  1. n8n Instance: A running n8n instance (cloud or self-hosted).
  2. Google Gemini Account: For generating the email content (requires a Google Gemini API Key from Google AI Studio).
  3. Google Sheets Account: With a prepared spreadsheet containing your lead list and columns for the generated output.

  Connect with us

  Website: https://www.intuz.com/services
  Email: getstarted@intuz.com
  LinkedIn: https://www.linkedin.com/company/intuz
  Get Started: https://n8n.partnerlinks.io/intuz

  For Custom Worflow Automation
  Click here- Get Started

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.if"]

workflow_json_compressed:
  H4sIAAAAAAAAE9VaC2/bOBL+K4RwuLaB5cqSH3KAA85N3NTbPLx+dO9QFy4lUrYaidLqkcQb5L/fDCVZsuNcUtfB4YBtYJvkzMeZb4Yz5N4rgvpcOVaGPIoDQT035oxcUNdTaooIGI+V46/3istgim1QXW9QXWUGN9RmxzFUanY7artjwq9ds9WhTVyVCRxxysg5/ImJEwU+GS85T2A4WYU4LEyhSvmqRWNeXwTBwuNyTgyTwiB2EzcQoFxtalpN+wa/0QgkJ4BTOb5XghDH8eNDTYlx3aXUe6/M55GnHCdRymuKDxpAGewKVd9QL8Wv/w7SaC51zc8GpzBgU3vJ2YjHqZdMcXV1ynR0vjUl01SdI38BICywU5+LZMBeiORqOpqPh6N+73T8qd+fzAen80/9Uf+/YAojtOlLkFVmZvgAoB1xBvhc6kkrVs1+1UuTpd4LXRyQDpdiTsoVc9jW2r9ncmnm1phQ2w5SkUgd6OEv4Cbpv+ZDLZemG5ZumdxUud621WbLbKtdbjdUZlHToJamtbt2KX4YcXA4J6c0ocQJomf4E8uxCm12s0baXX6Kk8gVC0nuXGMaMppwNud+xv7CR/+4vyd/c0WYJnU34X79B8RJPeF3CXl4UB6+wYYrXNzevr7efod3jQ4zmGo0TYieps5Vy+zaaqtj83a329a6vGLdqQSTbZrcusmS9HNYPxs/bX2XIezAS31R2gQ/ZBryDb99szOA37yrGEEuQCtABKbWD24nuJrgcjkepAlaLR/LJkrrzq2ArQpN1anlqDQuyAVu+7TMQZLIayPkToS4c+PQo6si2CLuBzdgzvXXP1M3wu8OsJivp+fRkstk3KEQQhc0sZfrmTYVH/gUcuIkyAdQ5NqpEzfxDo6nELoPoJPAD6lYHRpSKXYfUOeBTSUbD4yqIncfWH2Wvg6uquC97OWKa84GYn4SCAGRI5PLoW23W8c+cAeCpQBqNf8Ip9/BgT6Svg/Ez3w179+FPEqgvjk0wm3hv+Ty7Ex/HVdnsvcKlc3D51lcudTn4iSX+guJbj5BRK+T7QrZ+8CTZJ33oAI7eEBsit4H3FkU3CbL+Tihi4Pbbkv2PvCG1BXzYeCK5OC22xT9K2fZ/CoMgyhJBdRZ/PDZ+SktewfvfMJ9UJAc3OGPpP9S+ju9eDWgT+j4leTzB7egzn61/FOK3wdkpdI+dOLeEL0PtqJdODSwUu4+qCB1zUXqWzzaw6OUXQlv9UIPb2j6GajQyPk0DAHSRXahAItdwT9wL7hVcAymwuBJ0d59zQ9ZWEcTaNzCZBJAxXcDxQqebnGpL/vxo8s9Fk+Ccd4ey9HNFhe/8Cirb4uuWfl/uoNxWbW7b4Ttm3T8Y+RM3PE0GlLjZNS8/b1n2t3LVTpumJ/16cVyOLf+uNPM//UVSreha3azSdWuTptq09HaqmnQlqo1Wxbr8EaHap1S/AcauzY5P78gJ0s490pO/1OY4n15geBRsbBxRl3+Pff87auUHRcIeAGC5oMNErynoYJwWQMTmRyIHYSr2wiyVyRvbwYiSf+qEQq/y9xGAsfhSDHSG5C+WACHs69UMPxpzKMb1+YkBiJL5tVnYibQmiSh8TVxY5IEZMEFMpGTZMml5ECAnWOpkZIY5Hm8BgPChsq8RsIocHiMRqVeTWrKWB9LMlMvhx6kCYSzvSRvG5qmgsnJbRCx+J2EoKrqTBwdnVxdTvr/mpC/k9PepHd0BL8RQoZREId41YFcPCYvvUfB2eThIZORJ/+fFFGsKqTk17nkPZG3CS8XJKeXYCY9gufmMfm6TJIwPn7/3qYeF8xb1cHe7+X95fng8vO3im0Gl+PJaHoyGVxdjgvLHB1h6UVk6XV8dERkEUsCAf9x4AI6MAaUMaQxdL/DaZICq6LA88AdcY0w13FcGwJ/RUAEX2ACkuypkRgg4WdgrwfYFhymAwFibqdAwJX0P48khTIoXzD20VkFyRHRJ3ex9OBfQpaAQfL1TbzNzjijZYy8vEHa0YSgx13ARkLcYYg7JG95fVGvkYiGLiOM30B6DjEnAVhOfQ9IWO4iENkWqAWGB6ZdO2AEybYMLaTi1EZrIMoJED1jqbwk86E1JnFCo/ySkJI/Ux6jTEIZi5DsgBqjowRXI1bkcsdbYcB6+DOOF4GWxQV4uBCIFMjiqdFSfVekEG6A1iNpKTsKblzGGQE3XK9xT8C1CPlkI8ZqAD+ksCpx7UxXNSrLTed3hkA+KeSsiHTIIHjGrWrrncoLUEaKW0bAwMnbVDDIPGYeuQSqZ4YJY9MSa23rx4+/aEEHOHqLvcmQBi4wvIpGIWB+MAiO+gAcGp21oJPRYDI46Z2Tj1eji95kMrg8Q2FrF8pF38vy6TvSICAG0Bv2IgA+ZlmgRbiM62sMPo2uWXAriOC3cnvA9IjamFu/zyDwZuI74orxxhxtJJPXWpD0nu1xyNBxSO0iyWLFQi3Xgwgp4UOiTSKK7RHC/sx5KAFIrm0kwzq5BIUQR4m0WEH4mfLJJZPAcmlcmynvZBi6C6FCti+nfAC/ydF4GaQeIxYHK9heigzK2VhSvJp0R/3fp4NR/5RcTSfD6QRzCx4/F9PxBDcJxQ9Z4QkBvIeTAIxH4VQlcNJDEP42vrokQUYRSAjgQyHpexuQa76KjwFXzqCZIu0zq1S5M6UOR6KVF1dZEQTEwGoqO1GzKgzmLGl8Ja+yhzSCZFEUmJsHeqPeWR/pRtNoWm3NUs0Wp2pT1xtqt2k3VYNaTrvpmI7T6DyqGM44BKKLx3pCsA70XnC2ez5OzwRk67feCbSarj/zzoYFlJdXXvJz/H4hRal6vaU6Ho2XylMV0pB6/qPKKAMy7w0H5R7lIb+5URx/VBY1yk6nrTttzbBUprUNKIu6mtplDUO1eavbtVpG26o+rayDkZHMVST31fM2DCquLcVs2rFh7jYknq5j+ZrRv6PQfaKi+5kgVeIhC3sYFhFk6RfkuZlSyyRUqYpC8JhwUs+rBFJtM4BrMr/DhgiWDZVIroRsfabMhHyG2aKvUdJXN6je1k2VGhrQ19I11aSttqqDKzodu223qFMxPdbvKfh1ErmLRdXk2895+cRyXvVFePeTVpR6svfAgzWCoJePRg72M8hWeXDhDUr+abCeZWgP3x6Tq16+3NmWTU3HZGq31WUqlNpdlZpaQ9U1wwTaNanZrLx7D5wnd+U6WxtBrjwTcpCrmFt8rwwpN+snxpricSf5kjc0sk+K+ZgL1HPDi+ZHbg9TYdG5YWcLrbLU4VuuoEkA+UqB3Kdsqi3e3rR2U7M6Laa22zpXm229pVIwATQjtgZx1uk6ekspukOUdf+oia52jtiM4v1BVqbn8PN0Wd1Q+Ui4+ToITTaWa+t9r/3VZoYGWVNTNcMBf3Gzq3aRk9QyO9y0O7bWoK+Kc+PBcwvkY6rpQDVsz+2qt2KeYH0rPc3voJJFMFcRwyNFuWlkXisfbmAW8A7++tjoHX/FV+2s2X2yCfSzby4USnfKMcQAvmRvz94l8bmX+Z2CH0X+LsnP/C8jOwXvXrNLejUwd4p6YmO7ZD37PL9TwVOrKhrkvCdPeZhI3TmeRylUnflvL3H2o1WP/PPUoZipDDZqmhdq3Fi0qfDh4T89PfSEeSQAAA==


name: Weekly Financial Markets Report: Generate with Gemini AI for Telegram & Discord
author_name: Malik Hashir
author_username: malikx
categories: []
created_at: 2025-07-17T11:35:22.109Z
updated_at: 2025-07-17T11:35:22.109Z
url: https://n8n.io/workflows/6090
scraped_at: 2025-12-24 13:02:46
description:
  Purpose & Overview
  This workflow is designed for market analysts, traders, and content creators who need a comprehensive, automated solution for generating weekly market intelligence reports. By aggregating and structuring news and forecasts across all major financial sectors, it streamlines the process of delivering actionable weekly insights for blogs, newsletters, and chat platforms.

  What the Workflow Does
  Aggregates news and analysis from trusted sources for nine key market sections, ensuring broad and deep coverage.
  Integrates economic calendar data for the upcoming week, providing a forward-looking preview of high-impact events.
  Applies date and currency filters to ensure all data is current and relevant.
  Compiles a structured Weekly Report ready for publication or distribution.

  Market Sections Covered
  Last Week Recap:
  Highlights and summarizes the most significant economic events and market moves from the previous week.
  Week Ahead Forecast:
  Outlines upcoming high-impact economic events and market expectations for the days ahead.
  General Market Forecast:
  Provides a broad outlook on global market sentiment and macroeconomic themes.
  Gold Weekly Outlook:
  Offers analysis and forecasts for the gold market, including technical and fundamental drivers.
  Oil Weekly Outlook:
  Delivers insights into oil price trends, supply/demand factors, and key geopolitical influences.
  BTC Weekly Outlook:
  Summarizes major developments and technical perspectives for Bitcoin.
  ETH Weekly Outlook:
  Covers Ethereum market trends, network updates, and technical analysis.
  Indices Weekly Outlook:
  Reviews and forecasts major stock indices, highlighting sector performance and risk sentiment.
  Currency Pairs Outlook:
  In-depth coverage of major FX pairs, including EURUSD, GBPUSD, AUDUSD and more.

  Key Features

  Sub-Workflow for Economic Calendar:
  Automatically fetches and integrates economic calendar updates for the next 4–5 days, enhancing the “Week Ahead” section with the latest data.

  Customizable Filters:
  Adjust date and currency parameters to tailor the report for any audience or market focus.

  Multi-Platform Output:
  The report is formatted for easy sharing as a blog post, newsletter, or direct updates to Telegram and Discord.

  Note: Platform-specific AI summarization nodes can be added to respect character limits (Telegram: 4000, Discord: 2000).

  Use Cases
  Weekly Blog or Newsletter Updates:
  Publish comprehensive market roundups and forecasts with minimal manual work.

  Telegram & Discord Alerts:
  Keep your trading community or team informed with structured, automated weekly updates.

  Market Research & Strategy:
  Use the report as a foundation for deeper analysis, trading plans, or client briefings.

  Setup & Delivery
  Automated aggregation: 
  Set your preferred schedule and let the workflow collect, filter, and compile all relevant data.

  Flexible output: 
  Adapt the workflow for different platforms and audiences as needed.

  How to Set Up
  A comprehensive step-by-step video and written guide is included with your subworkflow file.
  If you need further assistance, personalized setup support is also available.

  This workflow delivers a professional, all-in-one solution for staying ahead of the markets—saving you hours each week and ensuring your updates are always timely, comprehensive, and actionable.

nodes_used:
  ["n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.manualTrigger","n8n-nodes-base.limit","n8n-nodes-base.merge","n8n-nodes-base.stickyNote","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.limit","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.rssFeedRead","n8n-nodes-base.code","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.merge","n8n-nodes-base.rssFeedRead","n8n-nodes-base.set","n8n-nodes-base.limit","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.merge","n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.filter","n8n-nodes-base.rssFeedRead","n8n-nodes-base.rssFeedRead","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.limit","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.discord","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.convertToFile","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","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.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent"]

workflow_json_compressed:
  [encoded data, 9152 characters]


name: Automated Stripe to KlickTipp: Send Purchase Confirmation Emails via Tagging
author_name: KlickTipp
author_username: KlickTipp
categories: []
created_at: 2025-07-17T12:24:35.263Z
updated_at: 2025-07-17T12:24:35.263Z
url: https://n8n.io/workflows/6092
scraped_at: 2025-12-24 13:02:45
description:
  Community Node Disclaimer: This workflow uses KlickTipp community nodes.

  Introduction
  This workflow automates Stripe checkout confirmations by capturing transaction data and syncing it into KlickTipp. Upon successful checkout, the contact's data is enriched with purchase details and tagged to trigger a personalized confirmation campaign in KlickTipp. Perfect for digital product sellers, course creators, and service providers seeking an end-to-end automated sales confirmation process.
  Benefits
  Instant confirmation emails**: Automatically notify customers upon successful checkout—no manual processing needed.
  Structured contact data**: Order data (invoice link, amount, transaction ID, products) is stored in KlickTipp custom fields.
  Smart campaign triggering**: Assign dynamic tags to start automated confirmation or fulfillment sequences.
  Seamless digital delivery**: Ideal for pairing with tools like Memberspot or Mentortools to unlock digital products post-checkout.
  Key Features
  Stripe Webhook Trigger**:
    Triggers on Triggers on Checkout Session.completed events events.
    Captures checkout data including product names, order number, and total amount.
  KlickTipp Contact Sync**:
    Adds or updates contacts in KlickTipp.
    Maps Stripe data into custom fields
    Assigns a tag such as Stripe Checkout to initiate a confirmation campaign.
  Router Logic (optional)**:
    Branches logic based on product ID or Stripe payment link.
    Enables product-specific campaigns or follow-ups.
  Setup Instructions
  KlickTipp Preparation
     Create the following custom fields in your KlickTipp account:
     
  | Field Name          | Field Type   |
  |--------------------------|------------------|
  | Stripe \| Products       | Text             |
  | Stripe \| Total          | Decimal Number   |
  | Stripe \| Payment ID     | Text             |
  | Stripe \| Receipt URL    | URL              |

     Define a tag for each product or confirmation flow, e.g., Order: Course XYZ.
  Credential Configuration
       Connect your Stripe account using an API key from the Stripe Dashboard.
       Authenticate your KlickTipp connection with username/password credentials (API access required).
  Field Mapping and Workflow Alignment
     Map Stripe output fields to the KlickTipp custom fields.
     Assign the tag to trigger your post-purchase campaign.
     Ensure that required data like email and opt-in info are present for the contact to be valid.
  Testing and Deployment
  Click on Inactive to activate the scenario.
  Perform a test payment using a Stripe product link.
  Verify in KlickTipp:
     The contact appears with email and opt-in status.
     Custom fields for Stripe are filled.
     The campaign tag is correctly applied and confirmation email is sent.

  ⚠️ Note: Use real or test-mode API keys in Stripe depending on your testing environment. Stripe events may take a few seconds to propagate.
  Campaign Expansion Ideas
  Launch targeted upsell flows based on the product tag.
  Use confirmation placeholders like:
    [[Stripe | Products]]
    [[Stripe | Total]]
    [[Stripe | Payment ID]]
    [[Stripe | Products]]
  Route customers to different product access portals (e.g., Memberspot, Mentortools).
  Send follow-up content over multiple days using KlickTipp sequences.
  Customization
  You can extend the scenario using a switch node to:
  Assign different tags per used payment link
  Branch into upsell or membership activation flows  
  Chain additional automations like CRM entry, Slack notification, or invoice creation.


  Resources:  
  Use KlickTipp Community Node in n8n
  Automate Workflows: KlickTipp Integration in n8n

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","CUSTOM.klicktipp","n8n-nodes-base.stickyNote","n8n-nodes-base.stripe","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stripeTrigger"]

workflow_json_compressed:
  [encoded data, 4312 characters]


name: Auto-Enrich New CRM Companies with ChatGPT Web Research via Tavily
author_name: CentralStationCRM
author_username: centralstationcrm
categories: []
created_at: 2025-07-17T13:58:25.720Z
updated_at: 2025-07-17T13:58:25.720Z
url: https://n8n.io/workflows/6093
scraped_at: 2025-12-24 13:02:46
description:
  Overview
  This template benefits anyone who wants to:
  automate web research on a prospect company
  compile that research into an easily readable note and save the note into CentralStationCRM

  Tools in this workflow
  CentralStationCRM, the easy and intuitive CRM Software for small teams. Here is our API Documentation if you want to customize the workflow.
  ChatGPT, the well-known ai chatbot
  Tavily, a web search service for large language models

  Disclaimer
  Tavily Web Search is (as of yet) a community node. You have to activate the use of community nodes inside your n8n account to use this workflow.

  Workflow Screenshot

  Workflow Description

  The workflow consists of:
  a webhook trigger
  an ai agent node
  an http request node

  The Webhook Trigger
  The Webhook is set up in CentralStationCRM to trigger when a new company is created inside the CRM.

  The Webhook Trigger Node in n8n then fetches the company data from the CRM.

  The AI Agent Node
  The node uses ChatGPT as ai chat model and two Tavily Web Search operations ('search for information' and 'extract URLs') as tools. Additionally, it uses a simple prompt as tool, telling the ai model to re-iterate on the research data if applicable.

  The AI Agent Node takes the Company Name and prompts ChatGPT to "do a deep research" on this company on the web. "The research shall help sales people get a good overview about the company and allow to identify potential opportunities."

  The AI Agent then formats the results into  markdown format and passes them to the next node.

  The CentralStationCRM protocol node
  This is an HTTP Request to the CentralStationCRM API. It creates a 'protocol' (the API's name for notes in the CRM) with the markdown data it received from the previous node.

  This protocol is saved in CentralStationCRM, where it can easily be accessed as a note when clicking on the new company entry.

  Customization ideas
  Even though this workflow is pretty simple, it poses interesting possibilities for customization.

  For example, you can alter the Webhook trigger (in CentralstationCRM and n8n) to fire when a person is created. You have to alter the AI prompt as well and make sure the third node adds the research note to the person, not a company, via the CentralStationCRM API. 

  You could also swap the AI model used here for another one, comparing the resulting research data and get a deeper understanding of ai chat models.

  Then of course there is the prompt itself. You can definitely double down on the information you are most interested in and refine your prompt to make the ai bot focus on these areas of search. Start experimenting a bit!

  Preconditions
  For this workflow to work, you need
  a CentralStationCRM account with API Access
  an n8n account with API Access
  an Open AI account with API Access

  Have fun with our workflow!

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","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/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.toolThink","@tavily/n8n-nodes-tavily.tavilyTool","@tavily/n8n-nodes-tavily.tavilyTool","n8n-nodes-base.httpRequest","n8n-nodes-base.webhook"]

workflow_json_compressed:
  [encoded data, 5256 characters]


name: Salesforce Lead Capture with GPT-4 Personalized Email & SMS Follow-Up
author_name: Le Nguyen
author_username: leeseifer
categories: []
created_at: 2025-07-17T18:42:17.546Z
updated_at: 2025-07-17T18:42:17.546Z
url: https://n8n.io/workflows/6102
scraped_at: 2025-12-24 13:02:42
description:
  How It Works
  This workflow transforms n8n into a smart Web Lead Form alternative to Salesforce's traditional Web-to-Lead, capturing leads, creating Salesforce records, and sending AI-personalized responses via email or SMS.

  Capture Submission**: User submits form data (name, email, phone, description, preference) via n8n's hosted form.
  Create Lead**: Maps data to a new Salesforce Lead.
  Personalize Message**: Uses OpenAI to generate a tailored welcome based on description and preference (detailed for email, concise for SMS).
  Route Outreach**: Branches to send via Twilio SMS or SMTP email depending on preference.

  Set Up Steps
  Setup takes about 15-30 minutes if you have credentials ready. Focus on connecting services; detailed configs are in workflow sticky notes.

  Duplicate this template in n8n.
  Add your Salesforce, OpenAI, Twilio, and SMTP credentials (no hardcoding—use n8n's credential manager).
  Customize form fields if needed and test with sample data.
  Activate and share the form URL on your site.

  n8n Web to Lead Form.json

nodes_used:
  ["n8n-nodes-base.salesforce","n8n-nodes-base.formTrigger","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.switch","n8n-nodes-base.twilio","n8n-nodes-base.emailSend","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE81Ya2/bOBb9K4RmgCaApbFkPawMBthsH4v0kbRNtjNFEwwoirI5kUWNSCXjDfzf95CSbdlx2i72y3yzJfKS99xz7z1XD86Ca+qcPDiiUppWjJ/lzomT0igO2Dim8SQIQr+IY0rzPApomEY0T6c8ibMkHvMiYgXjKZv4KQ2TKGVhwvI05M7I0XxRl1Tz5w3P1SXXbf1c4gnXHAfopuWrkVPJnCvn5AtON6dy5ufjMJ6442nC3NDnoUtDlrrcj5OA+RnnsQ/LFV1wrIZhmCeXtOSqkA3j5C2nuTl5WZv31bRy7QFuRhX31GYdltRSCS1khbPdyXQ8coPx+AaPaQPbmjfKIMJwX1otYeqXX3lmrZOHB/LjH0pWX66dt1Rpco71184NWa1gtcST/nK/fHUhsLTH0/KV4GVuT+MLKsrhTu+ledJtKERz0PQr83zXNhxmjag773YWX/GyJP9W5DSTrSafZdsoXhbk6MV2x/HGzEJmouTv57LaP9M+I0eX7y7Xq1cIJUOYeaUFLa03W7QvTls9D05rYUlmwvzb/I/Zxw/s84fPH89mF8WLbUgHsaSMybbS1rYJ6CcExbrkr0a9nUmURnlYTNxswiZuSGmCSKepO0mnRZHQLC4sHXrbFxWB5QVRbbYQytp6iipm3VUjZjPe7HEl2nLlnmdzKW9tulA69qOQFm6BC7jhtMjcNA+4G4/zKEvHPJ1Mps4+vaRF3P7MWq1l9ZZm3DDg0twQniPs5iJCl5bustKUaQTQ6V5sqXNHy7bPo8I8XBvasgNbGv5nKxAku22dgXsbNkz9xvqrDraOsqNdG5a1ziPTA9Y4+3Y0/0tTZPO+qe8h7CNjeSPrXN5X+8bW+L1veMEbjkp3sl5ysY3EAEq5zqGtR5tHXV6sblZP4WRfmSi92EnHX/kzuDTjmmSU3RItyVK2REm83Od54AUbpoeTMC1C8DudUh/8GkcuTTLfLRgKbhQkIbfgrZle8+r0bMvuf4DeP20pXtJqxuZUVJ40C8Uexf34iXK4wO7S0P3B+f33puxcHdnHOKQUSsOSxQ9/Z7V2Q89Ua0bZnOcfuWpLfd5d8F/vr+xLuLxNAvxZcKXojO8HgiFyKC2mDPU1n5IalzL1U/yH5+Sel6jVnPT7TZ4TPReKlCjZJ9cVitfry4tzT+lGVDNRLI9+PHr2uB48O/YEupZn6tzxanVdXVdXiLw1tjWOmOGvaIjArRqOhBEVyVAJYJrQigDozjAzd4VZj7yjt5wITe4pHtMqJ3Ne1kVbepZUjbT5rZYKhxvANu6C8QR5AXeLRvAqL5cjUjey4Pa6tCS2yhKKv6Z3a+s4rkBbLRf2bHuakoW+N3ZyfsdLWS9gnSje3AnUWVVzJgyO5vqiu/69bG6LUt6r0bC7Gn9njTWLF8YwaxUOst4qz+YnmUlcC8gDJdbFilczOoPx0Vdjhh1zqgnwrCUs58gopstljzZpcd1nigx62wiG0SEaa9usWZi1QIdxY13o+SYoAKVChSHAt8Y9TVxPc1rrnbAaJ6hJS4XtAM68Y33JqLcl47pyyVkxeGKcve5KxLVzsgl1DlWF/pnDa5tbd7yDDOZweVeaeEIJkaO2ynlDkG8G9Vwde+SsYmWbm6jPGs61hS6T+bJzagsi7WBgtCxdLd3OMjni3swbAcga6MFzZbKvLflxdz5Y1NlZmmj1CocoMauobht+Al/+aTjd8BnFdUbkiw3r836hSeAbcsXp4tqx9qwxU50NXmhcfyBs3hMg7QiHE/KG89pAdcebpYGaCcXXeKAIEdSoBk7BX9x9mwB0Q48hVGouGz0A7JbD+wLHdxuUMNJzDyuPnMut6wasUlS36mdwAcw2JEBlR5W2DOYma35+wl0QqrynSzWkODjbM3PNXiviiCnSI2KkYv/TOrQltmegM7sGz4g53OTdkNNdfcFvhTxCucOvPviDKgToLAxdnheC2drTYdJC4OAWNTqRyUDP9LPHSq5rEkP9xsSbT68KtsgncSVfVm/3Oo/4inbzppuehr4wjYOIulkeJehpaGcZhJubjHNKwyj2WcIGyhDAs/nT4n79etDJkFOHG1mDdDjQYzpJvi/N7jb9GPqeF/pT3+BsZ1P8klddeq/bofUXBMhp3/JN02FWzSHbMgGyycZIxirvav3m2PUUhFEnCLIoQycuYjcMwgICl2cuVGQOYBKepIljOidvOlsPa1C6/rZ5150PeWIiudq9vhX032qCEPsHVNNmRIBCnm8M7ug7w6O/FabTPAx4Hk7d8TgOMSpEwDQNMF4maTylqc9SP93DtCdeIUrwxlu/8Xo4R38HzHthCrRvdqXUft5NBlpyjIkkzdLcpTHjbhhCUKZBnLrReJolFNP8OAoGeWcaBoL6ZObpe1EKaTZIbXJps6Ovf1fr94PMjAJk5uRAZmr5P8D0eA6F4m7kAiZq8+q8XWR2gOtb/MC0FchDc16/xuvFV2dtF9G9utg5PqyLd++C1y8/CvYmiWv6fPppi2IHwvfMtFE+SYOJ77vTaILo8DRxaTiJ3WkSMjZN/YzF2V50XvZT2OH42BnNrDsQgun+HBtHkyz3p9xNElSdMKKozgFq8jSacp8GWUYnwaM51kxv/xe2I0d1nbT70tLpwu8kwYEPIFq+HH5K+ZaRnc8soM96swXufUkZn8syt0Syj15ZodhPrc6BLx8LXW8o8fpcf4heSfXnb/TtGxFdDEL37ur904QIvC0l/HHuZ1kQuD6LQYkkDtx0klC3CHOfISRJEKUDuxqSBUIN2fh0t7Rr+iXD2S81s184fZyY9yLXc9QRsMbB8IMa5JyEWDwYVn74wYqOzZcygxM5NcUT5RnF3MjzwTSBdUaJmaXXFTT5lZnX1oMHhFptNFk3wSlyJ6gxbjSUsaq7bzOjfsRQQ7sQhtIK14EUU/1cofDLit+OpL00RG50J9jw/mRK12YK2EpYj5zeSYGVOFvkT3hCsiUx3/ZQ90o5E2xE1qeAK6arZagDeglbeQ45CEXa1qWk5rf5lmPnt9OzbopRaqDocihSO7ZReLTEuHds4GyrUkKf1lL3/IOAxfhhMIPul81aKPZ5J3ABRM4IvUf158aGsuJs06T7rwhm8KfCsAO9tOpm/X0xZheMHAHp/pdzMl7dmHbULzq4/1FTeWRhtLd6r8gdPPHAF75Dp3/ru/FB209sOmR///PLAXur1X8B2g7lA3gXAAA=


name: Shopify Review Aggregator: Trustpilot, Google, Facebook to Google Sheets
author_name: David Olusola
author_username: dae221
categories: []
created_at: 2025-07-18T04:05:19.162Z
updated_at: 2025-07-18T04:05:19.162Z
url: https://n8n.io/workflows/6112
scraped_at: 2025-12-24 13:02:44
description:
  Multi-Platform Review Collector for n8n: Trustpilot + Google + Facebook Automation

  How it works
  The schedule triggers daily review collection from configured platforms and connects to multiple review platform APIs to download latest reviews. The workflow normalizes review data into consistent format with rating, text, date, source, and customer name. It removes duplicates and stores centralized database in Google Sheets creating comprehensive review repository for analysis and response management.
  Trigger: Daily schedule (10 AM)
  Output: Updated review database
  Timing: Daily sync
  Frequency: Once per day
  Data Flow:
  Trustpilot → API call → Raw reviews
  Google Reviews → API call → Raw reviews
  Facebook → API call → Raw reviews
  ↓
  Normalize format → Remove duplicates
  ↓
  Google Sheets → Centralized database

  Set up instructions

  Set up Shopify credentials in n8n: API Key, Password, Shop Subdomain, and Shared Secret
  Obtain API credentials for each review platform you want to monitor (Trustpilot, Google Reviews, Facebook)
  Configure HTTP Request nodes with proper API endpoints and authentication headers for each platform
  Set up Google Sheets credentials and create a spreadsheet with columns: Source, Rating, Review Text, Customer Name, Date, Product ID, Review ID
  The schedule trigger runs daily at 10 AM but feel free to adjust frequency based on review volume
  Update the Code node with proper data mapping for each review platform's API response format

  Test API connections individually before running the full workflow to ensure all platforms return data correctly

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.shopify","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","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:
  H4sIAAAAAAAAE62W207jSBCGX8XyxV6lUZ8P3LEzgJCYAQELK6246EN1sAg2GzvMsIh333KYISHEnGYuIjmJ6++v/6qu6ruySuVmeer3xd9bZ81Ve3NmqhDKUXkFnS8378qqbjtfR9jr3+OU0qglNSxyaqXQVAenohbGqRCocSZKRvFnaahSXiurpbNglQpOQ47l/ais/RWg1Je/9k/2yOH+1snOwdGX4mj7dG/7rNja3T3a3t06OThChM6P23Lzn3OMaRL0j3cPuEZqn0JUxEOwRNKc8IlG4kVODnT2QfnycaXPvprcFkdwU8G34vi2jr307XX/V21rMtcmwbew0cYLSLMJnEyr8Rim+N5101Zd1dS4NrGWjoSkiHPtpyjdwRSZ7u4f1E7x2/xFtsHvRz9Ak4jKCwPEReGIDJYRrxHZGsUTInOIfAG6C11xOG3SLHbtMONFc13l2xU2rd/G9kjmmcuJCkaMc2ihTZJYJROJQYTEhTHa6gXZDnTxojiZztruupo03Q83hykvuu76CP6dQdutkEpJR/x1UrnkYjRKcSc4cRkzLZVNxNGUMCFGG6UjUMZXWXebZjyBX+R8g6PLnCkKsBYUoaAUkV454p0VJFomvBbcpuRXOXd8hNA0l79IKt9HKmUymSaK6aaBSG0o8ckJEhQIy6VOkcsF6ddmeuUn1X8/7Sw++84PgkZ8XCHk/E1eLvgY48Za2Z/oYIiMWKcuCMy95BAkOhYlLPg+XUC8LKr808Nip5nVaRCwyk/x3snmGBfSYlpltNCbT4ljUhPsfpFiZ8pZmwXbcddMH8twblzPMMg2npft8QXAvAUsUb7RQ7mhHkmNF4xmRkmyPamCQAI6S2hUjlkD0jO6ID1rppd50nwr9urcDLefroqXt1+bbjXHrAdk/BlgGZu6g7pDqXK4HQmqDI9CESEyogbJiA1aICpYSh0ErdLy0fHdbApt8UfxqalzNX43Lh19ENRbGnsigh9KZOYZT471xFLls0sqmrDUN/+ctVUNbVuc+slsOOtDlDhwFP0gqOt7eDLYJYNHRwXD5EsuSWZORCyIpJxYgB5OfJfxmPeW7mARvD//CtOvP8hqdUiZakY4Nk1snBwHpgBOlMTWH3EUcb7UOLcO94q+E1ZTuELpF0blAGtfqc9P0suo+LaPXXWDy2Q/aWFUttB1VT2eh8J3iLNe/WCa8N6wWd6wXuPmIX5+dRLKZIO7IpoKj/mwmViHG2WQFGeCR+v7wkGIGmIvNRd+ciXA71e+6neAF6F+n2+azPOQEd7jEnwvN2lv+pPYoUn5Wtzw5FqNPD9HL57fwtZtZ/0VaK3gWvp1mq+Mr7Xi62PWqb82fNbKDwSt039tgLzgzbMM/S53Bovu9yxwf/8/7yYdTZcMAAA=


name: End-to-End Blog Generation for WordPress with LLM Agents&Image - GPT-5 Optimized
author_name: Mohamed Abdelwahab
author_username: mohelwah
categories: []
created_at: 2025-07-18T05:21:23.096Z
updated_at: 2025-07-18T05:21:23.096Z
url: https://n8n.io/workflows/6117
scraped_at: 2025-12-24 13:02:41
description:
  🧠 n8n Blog Automation Workflow — GPT-5 Optimized

  This is a ready-to-use, single workflow — you can copy and paste it directly into n8n and start working.  
  It handles end-to-end SEO blog automation with triggers, orchestration, AI-powered writing, metadata, tags, excerpts, WordPress publishing, and Google Sheets updates.

  📌 Overview

  The system accepts blog parameters either from a form submission or from a Google Sheet row (via scheduled trigger), dynamically fetches WordPress categories, and produces a complete, publication-ready post through an orchestrated sequence of GPT-5 agents.  
  Each agent executes once in a strict order with clearly defined responsibilities.

  Core Capabilities
  Real-time search and fact retrieval (OpenRouter / Perplexity Sonar)  
  SEO-focused outline planning  
  Structured section creation  
  Expert-level section writing with inline HTML citations  
  Editorial refinement into cohesive, polished HTML  
  Metadata, excerpt, and featured-image prompt generation  
  Automated category, tag creation/update, and excerpt update  
  Draft publishing to WordPress  
  Updates the corresponding Google Sheet row with created = yes
  🔁 Triggers

  1. Form Trigger
  Collects:  
  Keywords  
  Word count  
  Number of sections  
  Writing style  
  Website URL  
  About Website (used for context)  
  Featured image toggle  

  2. Google Sheets + Schedule Trigger
  Automatically pulls rows on schedule from a Google Sheet with the following columns:  
  Keywords  
  wordCount  
  Number of sections  
  Generate a featured image  
  Writing Style  
  Website  
  About Website  
  created → initially set to no, automatically updated to yes once the blog post is created and uploaded to WordPress.  

  🧠 Orchestration Agent (GPT-5)

  Central Director agent optimized for GPT-5 that coordinates the pipeline:

  GetOnlineInfo — Current Q&A and search-driven insights  
  OutlinePlanner — SEO-structured Table of Contents  
  createSections — ToC → detailed section definitions  
  SectionsWriter — Expert, citation-rich content  
  Editor — Full HTML assembly, SEO and legal compliance  
  MetaInfo — Title, slug, excerpt, meta description, category selection  
  Tags Agent — Creates or updates SEO-friendly WordPress tags  
  ImagePrompt — Realistic cover image prompt + alt text (if enabled)  
  ✍️ Writing Flow

  Input parsing (from Form or Google Sheets row)  
  Real-time data retrieval  
  SEO-optimized outline creation  
  Section breakdown with clear descriptions  
  Detailed section drafting with verified sources  
  Editorial polishing into publish-ready HTML  
  Metadata and excerpt generation (title, slug, description, category)  
  Tag creation and update in WordPress  
  Optional image prompt creation and upload  
  Automatic WordPress draft publishing with excerpt and tags updated  
  Google Sheet row update — set created = yes  
  ✅ Output Format

  {
    "toc": "Table of Contents",
    "post_html": "&lt;final HTML content&gt;",
    "meta_data": {
      "title": "...",
      "slug": "...",
      "excerpt": "...",
      "category_id": 0
    },
    "image_data": {
      "image_prompt": "...",
      "alt_text": "..."
    },
    "tags": [
      {"name": "...", "description": "..."}
    ],
    "ready": true
  }

  🌐 WordPress Integration

  Authenticated API calls to /wp-json/wp/v2/posts, /wp-json/wp/v2/media, and /wp-json/wp/v2/tags  
  Draft mode publishing with category & author assignment  
  Featured image creation, resizing, and metadata linking (if enabled)  
  Automatic creation and update of tags  
  Automatic creation and update of excerpts  

  🧩 Setup Instructions

  1. Required Credentials
  WordPress API credentials  
  OpenAI API key  
  OpenRouter API key (optional)  
  Google Sheets API credentials (if using scheduled trigger)  

  2. Sub-Workflows Required
  OutlinePlanner  
  createSections  
  SectionsWriter  
  Editor  
  MetaInfo  
  Tags Agent  
  ImagePrompt (if enabled)  

  3. Dynamic Inputs
  Categories fetched via WP REST API and shown in the form  
  Tags generated and updated dynamically by Tags Agent  
  Excerpt automatically created and updated in WordPress  
  Image creation can be toggled (true / false)  

  📸 Optional Image Pipeline

  If enabled:  
  Generate image prompt and alt text  
  Create realistic cover image (1024x1024)  
  Resize and upload image to WordPress  
  Set image metadata and assign featured image  

  💡 Notes

  Workflow is production-ready — just copy-paste into n8n as a single workflow.  
  GPT-5 prompts embedded in each agent ensure high-quality, context-aware output  
  All HTML, JSON, excerpts, and tags are validated before publication  
  Modular sub-workflows allow isolated testing and debugging  
  Workflow supports legal accuracy, SEO performance, and dynamic web data responsiveness  

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.editImage","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.formTrigger","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.wordpress","n8n-nodes-base.wordpress","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.agentTool","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4240 characters]


name: Automate GitHub, JIRA Release Notes with Google Gemini & Notification Over Email
author_name: Intuz
author_username: intuz
categories: []
created_at: 2025-07-18T09:38:49.318Z
updated_at: 2025-07-18T09:38:49.318Z
url: https://n8n.io/workflows/6129
scraped_at: 2025-12-24 13:02:44
description:
  This n8n template from Intuz provides a complete and automated solution for creating and distributing sophisticated release notes. 

  It connects to GitHub and JIRA to gather data from recent commits and completed tickets, using specific keywords or labels to identify key features for inclusion. 

  This information is then processed by Google Gemini to automatically generate well-written, human-like release notes, which are then distributed via email to stakeholders, creating a complete, end-to-end communication pipeline for every new software release.

  This template is perfect for development teams looking to streamline their release process, ensure consistent communication, and eliminate the manual effort of writing release notes.

  How to use

  1. Set up Credentials:

  GitHub
  JIRA (Software Cloud API)
  Google Gemini (or another PaLM/LLM provider)
  Your SMTP email server.

  2. Configure the GitHub Trigger:

  Select the Github Trigger node.
  In the Repository Owner field, enter your GitHub username or organization name.
  In the Repository Name field, select the repository you want to monitor.

  3. Verify the JIRA Integration:

  Important:** This workflow assumes your commit messages contain a JIRA key (e.g., "PROJ-123: Fix login bug").
  Select the first Code node. It uses a regular expression ([A-Z]+-\\d+)/i to find JIRA keys. Adjust this expression if your team uses a different format.
  Select the Get an issue node and ensure your JIRA credentials are correctly configured.

  4. Customize the AI Prompt:

  Select the Basic LLM Chain node. You can edit the prompt to change the tone, style, or structure of the generated HTML release note to match your company's standards.


  5. Configure Email Notifications:

  Select the Send email node.
  Update the To Email field with the recipient's email address (e.g., a team distribution list or a stakeholder's email).
  Customize the From Email and Subject line as needed.

  6. Activate Workflow:

  Save your changes and activate the workflow. Now, every push to your configured repository will trigger the automated generation and sending of release notes.

  Required Tools

  GitHub: To trigger the workflow on code pushes.
  JIRA: To fetch details about the tasks and bugs included in the release.
  Google Gemini: To intelligently generate the release note content. (You can swap this for another LLM supported by n8n).
  SMTP Provider: To send the final release note via email.

  Connect with us

  Website: https://www.intuz.com/services
  Email: getstarted@intuz.com
  LinkedIn: https://www.linkedin.com/company/intuz
  Get Started: https://n8n.partnerlinks.io/intuz

  For Custom Worflow Automation
  Click here- Get Started

nodes_used:
  ["n8n-nodes-base.githubTrigger","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.emailSend","n8n-nodes-base.jira","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.outputParserStructured","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, 5012 characters]


name: 🤖 Build a Documentation Expert Chatbot with Gemini RAG Pipeline
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-18T11:49:47.778Z
updated_at: 2025-07-18T11:49:47.778Z
url: https://n8n.io/workflows/6137
scraped_at: 2025-12-24 13:02:41
description:
  How it works

  This template is a complete, hands-on tutorial for building a RAG (Retrieval-Augmented Generation) pipeline. In simple terms, you'll teach an AI to become an expert on a specific topic—in this case, the official n8n documentation—and then build a chatbot to ask it questions.

  Think of it like this: instead of a general-knowledge AI, you're building an expert librarian.

  The workflow is split into two main parts:

  Part 1: Indexing the Knowledge (Building the Library)
      This is a one-time process you run manually. The workflow automatically scrapes all pages of the n8n documentation, breaks them down into small, digestible chunks, and uses an AI model to create a special numerical representation (an "embedding") for each chunk. These embeddings are then stored in n8n's built-in Simple Vector Store. This is like a librarian reading every book and creating a hyper-detailed index card for every paragraph.

      Important: This in-memory knowledge base is temporary. It will be erased if you restart your n8n instance, and you will need to run the indexing process again.

  Part 2: The AI Agent (The Expert Librarian)
      This is the chat interface. When you ask a question, the AI agent doesn't guess the answer. Instead, it uses your question to find the most relevant "index cards" (chunks) from the knowledge base it just built. It then feeds these specific, relevant chunks to a powerful language model (Gemini) with a strict instruction: "Answer the user's question using ONLY this information." This ensures the answers are accurate, factual, and grounded in your provided documents.

  Set up steps

  Setup time: 2 minutes (plus 15-20 minutes for indexing)

  This template uses n8n's built-in tools, removing the need for an external database. Follow these simple steps to get started.

  Configure Google AI Credentials:
      You will need a Google AI API key for the Gemini models.
      In your n8n workflow, go to any of the three Gemini nodes (e.g., Gemini 2.5 Flash).
      Click the Credential dropdown and select + Create New Credential.
      Enter your Gemini API key and save.

  Apply Credentials to All Nodes:
      Your new Google AI credential is now saved. Go to the other two Gemini nodes (Gemini Chunk Embedding and Gemini Query Embedding) and select your newly created credential from the dropdown list.

  Build the Knowledge Base:
      Find the Start Indexing manual trigger node at the top-left of the workflow.
      Click its "Execute workflow" button to start the indexing process.
      ⚠️ Be Patient: This will take 15-20 minutes as it scrapes and processes the entire n8n documentation. You only need to do this once per n8n session. If you restart n8n, you must run this step again.

  Chat with Your Expert Agent:
      Once the indexing is complete, Activate the entire workflow using the toggle at the top of the screen.
      Open the RAG Chatbot chat trigger node (bottom-left) and copy its Public URL.
      Open the URL in a new tab and start asking questions about n8n! For example: "How does the IF node work?" or "What is a sub-workflow?".

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.removeDuplicates","n8n-nodes-base.filter","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.httpRequest","n8n-nodes-base.html","n8n-nodes-base.splitOut","n8n-nodes-base.removeDuplicates","n8n-nodes-base.executeWorkflow","n8n-nodes-base.httpRequest","n8n-nodes-base.html","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.vectorStoreInMemory","@n8n/n8n-nodes-langchain.vectorStoreInMemory"]

workflow_json_compressed:
  [encoded data, 16120 characters]


name: Set DevOps Infrastructure with Docker, K3s, Jenkins & Grafana for Linux Servers
author_name: Oneclick AI Squad
author_username: oneclick-ai
categories: []
created_at: 2025-07-18T12:02:20.068Z
updated_at: 2025-07-18T12:02:20.068Z
url: https://n8n.io/workflows/6140
scraped_at: 2025-12-24 13:02:41
description:
  This automated n8n workflow delivers an instant DevOps toolkit by installing Docker, K3s, Jenkins, Grafana, and more on a Linux server within 10 seconds. It optimizes performance, enhances security, and provides ready-to-use templates for DevOps projects.

  Main Components
  Configure Parameters** - Defines server details, tool versions, and credentials
  System Preparation** - Updates the system and installs base packages
  Install Docker** - Deploys Docker Engine and Docker Compose
  Install Kubernetes** - Sets up K3s cluster with kubectl, Helm, and k9s
  Install Jenkins** - Configures Jenkins CI/CD server with Docker integration
  Install Monitoring** - Deploys Prometheus and Grafana using Helm charts
  Create DevOps User** - Establishes a dedicated user with appropriate permissions
  Security Configuration** - Implements firewall, VS Code, and Terraform
  Final Configuration** - Sets up sample projects and configuration files
  Setup Complete** - Provides a summary and access details

  Essential Prerequisites
  Linux server with SSH access
  Root-level administrative privileges

  Customization Guide
  Adjust tool versions or credentials in the Configure Parameters node
  Modify the number of nodes or security settings as needed

  Features
  🔧 Core DevOps Tools Installed:
    Docker - Container platform with Docker Compose
    Kubernetes - K3s (lightweight) with kubectl and Helm
    Jenkins - CI/CD automation server
    Prometheus - Monitoring and alerting
    Grafana - Visualization and dashboards
  ⚡ Optimizations Made:
    Streamlined Commands - Combined multiple operations into single bash scripts
    Reduced Nodes - 10 nodes vs 12 in original (more efficient)
    Better Error Handling - Each step includes verification
    Cloud-Ready - Includes AWS CLI, Azure CLI, and Google Cloud SDK
    Security First - Proper firewall configuration and user permissions

  Parameters to Configure
  server_host: Your Linux server IP address
  server_user: SSH username (typically 'root')
  server_password: SSH password
  docker_version: Docker version to install
  k3s_version: K3s version to install
  username: DevOps username
  user_password: Password for the DevOps user

  How to Use
  Copy the JSON code from the artifact
  Open your n8n workspace
  Select "Import from JSON" or "+" → "From JSON"
  Paste the JSON code
  Configure parameters in the "Configure Parameters" node with your server details
  Run the workflow

  Workflow Actions
  Install: Deploys Docker, K3s, Jenkins, Prometheus, and Grafana with optimizations
  Create User: Sets up a DevOps user with necessary permissions
  Configure: Applies security settings and provides templates

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.ssh","n8n-nodes-base.set","n8n-nodes-base.wait","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6700 characters]


name: Automate Income and Expense Tracking in Google Sheets via Telegram
author_name: Fahmi Oktafian
author_username: fahmi3322
categories: []
created_at: 2025-07-18T17:28:39.101Z
updated_at: 2025-07-18T17:28:39.101Z
url: https://n8n.io/workflows/6147
scraped_at: 2025-12-24 13:02:45
description:
  Who’s it for
  This template is perfect for freelancers, small business owners, or financial assistants who want to record and approve financial transactions like income and expenses directly from Telegram, without opening a spreadsheet manually.

  It’s also useful for teams that require a supervisor to approve expenses before they’re finalized.

  What it does
  This workflow allows users to:

  Start a conversation via Telegram using the /start command.
  Choose to record an income or expense.
  Submit transaction data using a structured format.
  Store the data into Google Sheets in real time.
  For expenses, automatically notify a supervisor for approval.
  The supervisor can Approve ✅, Reject ❌, or View Details 👁.
  Sends feedback to the user based on supervisor action.

  🔧 How it works

  Telegram Bot Trigger: Captures user input via message or inline button callback.
  Message Detection Logic: Differentiates between text input and button interactions.
  Switch Node: Routes the message type:
     /start: Displays income/expense buttons.
     Input text: Validates formatting and parses data.
     Callback: Handles approval/rejection process.

  Google Sheets Integration: Appends or updates entries in different sheets based on the data type.

  Notifications:

     User gets feedback (recorded, pending, approved, rejected).
     Supervisor receives inline button options for approval.

  Google Sheets Details
  You will need a Google Sheet with the following two worksheets:

  Sheet 1: income
  Sheet 2: Sheet1 (Default tab for expenses)

  📱 Telegram Setup Instructions

  Create a bot using @BotFather.
  Save the bot token.
  Go to n8n Credentials → Telegram API and add:
     Access Token = your bot token
  In Telegram, send /start to your bot.
  Make sure your bot has enabled privacy mode (or disabled, if used in a group).


  💡 For the approval flow, update the node Send Approval Request with the correct chatId of the supervisor's Telegram account. You can hardcode a static ID (e.g., "123456789") or pull from a variable if dynamic.

  🛠 Requirements

  | Tool                       | Description                         |
  | -------------------------- | ----------------------------------- |
  | n8n (Cloud or Self-hosted) | Use latest stable version           |
  | Telegram Bot               | For user input and notifications    |
  | Google Sheets              | To store income and expense records |
  | Google OAuth2 Credentials  | Required for Google Sheets node     |

  ⚙️ How to customize the workflow

  Change the chat ID for supervisors in the node Send Approval Request.
  Modify the text or add new buttons in the inline keyboard node.
  Update Google Sheet ID and tab names if you’re using different sheets.
  Customize the approval logic, for example, route to different teams.

  ✅ Setup Steps

  Import the workflow JSON into your n8n instance.
  Configure Telegram API credential with your bot token.
  Connect your Google Sheets OAuth2 credential.
  Replace Google Sheet document ID and tab names with your own (via UI or “Expression” mode).
  Deploy and activate the workflow.

nodes_used:
  ["n8n-nodes-base.telegramTrigger","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.switch","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VZyXIbORL9FQbPghv74tu0u3umDzPTYbs9hw4fEkBCZlhicciSl3Do3ztBLSyRKJIlXRQSVYV8SLzMfA/8Mb/GHuavf8wXy00Py4S/5/nreQSnvDLZOVmiEuBTUDmmDM6pJLAojVJI6WJIwkj6BG3JhSPEEEyRfn4x7/F6dQU9vllj3rzD/mb1pqNPsEcK0K9v8PZivuwybuav/6LoNaqStApFZNYby7QrngFXijnIMUrECopWXsI10tPv8Qov13A9Y7Pfl6m7XiwvZ//D+KnrPtfw31f1oaVfsm0UFmGDr/r7d96vF5eXuKbnVt1m0S+6JaFggvMLyfnHi/nXu3W2ucjKY9IWmEkamfZQGGhhmOZcBcmlKDrVhYDWpd2taUM/bu8AfKC/tmuLV/L24n6XxWcXKFOsUEKZtiiZlzKzaHWxKReptNrt8hdaMvWzf+NmA5c4e1+3Nba7RL8+3ZJ/2NBRdDtsKVtfskVmjQKmUxYsSNAMY0rOS5GUxR22t91Nj7P4nfK/uumPY9t8XfTp01N00p4FTw2Sp5EbjZQ3L3NiGlVgwRXBTEwSo0KJmu8A/guW+QpnPxGz1/2sWz+mcQt4ElZNqZyEVJkCULJnWqbAtE6ReSskywhgpONFeLtD+u5T9/WOxvjTr99WuNzg7L+rGntzksxPgToiMRN2n8VKJ+RZOiaRa4LDJYuIhaVYEo88yeTKFBZ7lRXaqFlSnA5C+Mhi4oEZ5R1VMdcOBiz+AFeLTM3gnim/detrGM//IY/dtjLP57GPJYoCiRE4qtlEZI6OClcmXwr1qihN2KH79Vu/BiqyX6CHqRUW9DRkhgtvYtAsqy0yQ3nzHqjCtHdCQkwi7lfYzxQ6z7rlGQBb1BXiLIxD8uYCHjFY5jNWlMWyKHRmxgPkmr5kB+T9A9YbvGfvFuOE/AmlK1+nNCkaTjbRoGHKGmqgUQfmgzIsgdYgnLUyDisLvjxi67vZu0+I48y77LrLK9w+s9nDac7EqV+ZR6QIhoOKgmZFKTQ6smLEl0SxcgpJO23kAOl/un5Rvs/+3OD6AfBbTN0608Sc1gOE24F90gRClAKlZi5qwpO8YlELzpB7qbMvgvswpQmE7FUIYFixnnqcoR/R0GST0ThlrFAg5D5NHrrbc3iiJ7CkChghFKcxS7Nbc82Z98YxKn0ruYrecLnHkgdoL6XJaZhDkhTgSQRAVrimzmxI8FBHMCzknKQ1kvSAbpPkAe8fuMykfp5DEr1PkQhFEUcsowwRRbQRDAAUAxoQ1lvShMZMUjvcgjdAraM40nTeJCqBVJjX1gAgryUyOAbayewfq9W6+wJXxP7/3+Bm/BhG9kWi7HBfiootBZp/GaWq9UgJFtQ5AveGFA8Nhu04PntfJD1ipTflSdCMj1kySFRZ0pAmQZGEG/bxO+q/gaurCOkzbWyzosk+Zc5U/aHsFP47g14CZ9yryHQWpDCVSCyh5TYYJ1HZ0UHziHTysKmTWk0bNtpQq/CeE/cDUS7SSAzUoBgvPPs6LVHmHdI/V1sh8UiSdz30N+MiabxUt5P7NNJhqYIJgSeqUq4osbqgoVKVVUmZQHQw0gxlxT+xv4dJSX3bfX1OOxHTQSYQWZRC1M5VmWkk4YmWOkuSjnxVkEmZdj/pyrD2NjdXk0tPPcId1p4HRf4pGJYDUK0odCxEh9X7FDI8YFSaNHbQCC0jnYDhVV/TjGUxklXRRntPWiWpobSux0DZnxXS/+SmYHE1+7DA55xGZYyedhgkNmUoBajtVKhIwi9mCOQgJTXGID3yAdQ7XbwbkXdo703LlGEpzkM6aNNZlaAImLWVKmT1WADlKnNUTORjss97bXoPZR2aNytcf1lsuvVzeKMPeMMT5y4KmtnEEOIvz+RGqeZKAFcMkInCSbNIW1EckInninqMxkxyBUCwRIbceJupJQ7c7cCSPde2VMIYP+EYoJApqw1QCpq5Gqqg8iRyU6IpVWxBEgp7CB+O4QUQ3RRdBQ7J3mVO6ltRt66WMjhqiV5Q9iLl0YHZY8p9Eu/ZfYrOIxQRj7kcUgRyCMRYxwRqURNGvEUlGOciJ0/NGiFPoYgTHFPOmeyZoQMQ1Kq8qzIBhEDjhbXcjdTBy7fnDlSLVdylkoE57akCHNhakZlR//PJBkRh3CTBrizlKTnmpKvr5ciAB8UShyx09LbwYQX0i/T5+4xGxBENsH3m/pEnl2na3nmQA27NU7fscdnTYvMDsDuekZ1zigBGHVV1eZ75GD0LRZKvKJ5IWJpQxTOwVtXS8HbnIfXcGhSxplKRxFXEHq9lpWTwOSgikgpNpPIZSPlLkDojpBaUSWUMTaMUgZCWzDDKTK0HvAXbRKqeef7+sLMcR0pP0/+XmO6uvujxAxVFn13Dosb468f2BnmCitm+eDFfLDN+m7/mtx8/EoTD659WiNNXMc3FD+9GWosfv6Q4svATNz268rixbS7dunMeT8nI/W9z5dYbrZXPvbg9CHKxW+Ok52oibJ7EKcqN3taMhzg4klMxRs1+O0bTSA9ibJ9qX8u2kBy5Im3GH3FpraXHbVJz5TE531r6TD19pL4O6XNGbxhxz0cqotFWWnGOXLSeroT2xVvjvTsCjanfZpM5Q+W1aTqqYEfDnJJbzTjHCmk00vg9VDPGse8jWzGOfrN3Dlee0qwV4tRdyTHSvOTdk5b72MunfdfJt497omZuj7eKk2w8boKbEU/MuGbIc74lPJadE9/DNXDe3v4NFbtKdyMgAAA=


name: Publish LinkedIn & X Posts with Telegram Bot, Gemini AI & Vector Memory
author_name: Gregory
author_username: gregory
categories: []
created_at: 2025-07-18T17:34:29.119Z
updated_at: 2025-07-18T17:34:29.119Z
url: https://n8n.io/workflows/6148
scraped_at: 2025-12-24 13:02:43
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Overview

  This is a Telegram Bot capable of receiving information from the user in the form of text messages, voice messages, images or documents (e.g., presentations, PDFs, HTML pages), and publishing posts to the user's social platforms.

  The bot always sends the user a draft of the post for verification before publishing it.

  The bot saves relevant information to its long-term memory (vector store), so you don't need to repeat it in every interaction (e.g., who you are, your company, product, etc.).

  This template supports creating posts in LinkedIn and X.

  Setup

  Requirements
  To use this template your will need:
  Google's AI Studio API key. Get one here: https://aistudio.google.com/app/apikey
  Telegram Bot API key. You receive one when you register a new Telegram Bot via @BotFather bot in Telegram.
  LinkedIn API key. Follow the instructions here to create one: https://docs.n8n.io/integrations/builtin/credentials/linkedin/
  X API key. Follow the instructions here to create one: https://docs.n8n.io/integrations/builtin/credentials/twitter/

  Step-by-step instruction
  Import this template
  Create a new Telegram Bot or get an API key for existing one.
  Configre Telegram nodes with Telegram API key.
  Obtain a Google's AI Studio API key. Set it in "Describe document", "Describe audio" and "Google Gemini Chat Model".
  Create an API key for LinkedIn.
  Create an API key for X.
  Set our LinkedIn key in "Create post in LinkedIn" nodes.
  Set your X key in "Create X (Twitter) post" node.

  Other
  Bright-colored notes in the template highlight information that needs to be set before launching the template.

nodes_used:
  ["n8n-nodes-base.telegramTrigger","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","n8n-nodes-base.telegram","n8n-nodes-base.twitterTool","@n8n/n8n-nodes-langchain.memoryManager","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.extractFromFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.linkedInTool","n8n-nodes-base.linkedInTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.vectorStoreInMemory","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.telegram","n8n-nodes-base.telegram"]

workflow_json_compressed:
  [encoded data, 9092 characters]


name: Auto Germany Apartment Search & Apply with Immobilienscout24 & Google Services
author_name: Abbas Ali
author_username: abbas12142
categories: []
created_at: 2025-07-18T19:28:42.194Z
updated_at: 2025-07-18T19:28:42.194Z
url: https://n8n.io/workflows/6150
scraped_at: 2025-12-24 13:02:41
description:
  This n8n workflow automatically finds apartments for rent in Germany, filters them by your city, rent budget, and number of rooms, and applies to them via email. Each application includes:
  A personalized German cover letter
  Schufa report (fetched dynamically from Google Drive)
  Recent salary slips (also fetched from Google Drive)

  The workflow runs daily at a scheduled time, emails landlords or agencies automatically, and logs every application into a Google Sheet for tracking.

  How It Works
  Scheduled Trigger – Runs every day at 9 AM (adjustable).
  Fetch Listings – Uses immobilienscout24 API (or similar) to pull rental listings for your selected city.
  Filter Listings – Keeps only listings matching your CITY, MAX_RENT, and ROOMS settings.
  Fetch Documents – Retrieves your Schufa report and salary slips from Google Drive (no need for local hosting).
  Generate Cover Letter – Creates a personalized German-language letter per apartment.
  Send Email Application – Sends the email to the landlord or agent with cover letter + documents attached.
  Log Applications – Saves each application (title, address, rent, date) in a Google Sheet.

  How to Use
  Import the workflow JSON into n8n.
  Set environment variables in n8n (for security):
  	immobilienscout24_TOKEN: Your immobilienscout24 API token
  	immobilienscout24_LISTING_ACTOR: Actor ID for your preferred rental listing scraper (or custom)
  	MY_EMAIL:  Your sender email address (SMTP configured in n8n)
  	SCHUFA_FILE_ID:  Google Drive File ID for your Schufa PDF
  	SALARY_FILE_ID: Google Drive File ID for your Salary Slips PDF
  	APPLICATION_SHEET_ID: Google Sheet ID to log applications
  Authenticate Google Drive and Google Sheets (OAuth2 in n8n).
  Customize search filters in the Set Config node:
  	CITY (e.g., Berlin)
  	MAX_RENT (e.g., 1200)
  	ROOMS (e.g., 2)
  Activate the workflow – It will run daily at the configured time and send applications automatically.
  Check your Google Sheet – Every application will be logged for tracking.

  Requirements
  An immobilienscout24 account (or another apartment listing API, can be substituted).
  A Google account (for Drive and Sheets integration).
  A Schufa report (PDF) uploaded to Google Drive.
  Recent salary slips (PDF) uploaded to Google Drive.
  An SMTP-configured email account for sending applications.
  n8n instance (self-hosted or cloud) with:
  	Google Drive and Google Sheets credentials configured
  	Environment variables set for tokens and file IDs
  	A working email SMTP setup

nodes_used:
  ["n8n-nodes-base.cron","n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.function","n8n-nodes-base.emailSend","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 4520 characters]


name: Make Every Product Photo Look Like a Luxury Ad Fully Automated AI + google drive
author_name: ARRE
author_username: arre
categories: []
created_at: 2025-07-18T19:58:18.885Z
updated_at: 2025-07-18T19:58:18.885Z
url: https://n8n.io/workflows/6151
scraped_at: 2025-12-24 13:02:43
description:
  Watch the video to better understand this workflow :
  ARRE-automation

  Good to know:
  This workflow automatically processes product images from Google Drive, generates AI-powered background prompts using multiple AI models (ChatGPT, Claude, or Groq), creates professional background scenes using Pixelcut.ai, and saves enhanced images back to your Google Drive. Perfect for e-commerce businesses and product photography workflows.

  Who is this for?

  ➖E-commerce store owners who need professional product backgrounds
  ➖Product photographers looking to automate background generation
  ➖Marketing teams creating consistent product imagery
  ➖Small businesses wanting to enhance their product photos without expensive studio setups
  ➖Anyone who needs to quickly transform transparent product images into commercial-ready photos

  What problem is this workflow solving?

  This workflow solves the challenge of creating professional product photography backgrounds at scale. Instead of manually editing each product image or setting up expensive photo shoots, it automatically generates contextually appropriate backgrounds for your products using AI technology. It eliminates the time-consuming process of background creation while maintaining professional quality and consistency across your product catalog.

  What this workflow does:

  ✅Automatically fetches product images from your Google Drive folder
  ✅Downloads transparent/background-free product images
  ✅Uses advanced AI models (ChatGPT, Claude, or Groq) to generate intelligent background prompts based on product analysis
  ✅Creates professional backgrounds using Pixelcut.ai API with AI-generated or custom prompts
  ✅Saves enhanced product images back to Google Drive with organized naming
  ✅Processes multiple images in batch automatically

  How it works:

  1️⃣Google Drive node searches for PNG product images in your specified folder
  2️⃣Binary download node retrieves the actual image files for processing
  3️⃣Optional AI agent analyzes products using your chosen AI model (OpenAI GPT-4, Claude, or Groq) and generates appropriate background prompts
  4️⃣Pixelcut.ai API processes images and adds professional backgrounds using AI-generated or manual prompts
  5️⃣Enhanced images are automatically saved back to Google Drive with "enhanced-" prefix

  How to use:

  Set up Google Drive OAuth2 credentials in n8n
  Create a Pixelcut.ai account and get your API key
  Configure your source folder ID in the Google Drive nodes
  Set up your output folder ID for enhanced images
  Choose and configure your preferred AI model credentials (OpenAI for ChatGPT, Anthropic for Claude, or Groq)
  Replace placeholder API keys with your actual credentials
  Execute the workflow to process your product images

  Requirements:

  ✅n8n instance (cloud or self-hosted)
  ✅Google Drive account with OAuth2 access
  ✅Pixelcut.ai API account and key
  ✅Product images in PNG format (transparent backgrounds recommended)
  ✅AI API credentials for automatic prompt generation (choose from):
     OpenAI API (for ChatGPT/GPT-4)
     Anthropic API (for Claude)
     Groq API (for fast inference)
  ✅Basic understanding of n8n workflows

  Customizing this workflow:

  🟢Modify the image format filter to support JPG, WEBP, or other formats
  🟢Switch between different AI models (ChatGPT, Claude, Groq) for prompt generation
  🟢Customize background prompts for different product categories
  🟢Add background removal step for products with existing backgrounds
  🟢Switch to different AI background services (Deep-Image.ai, Remove.bg, etc.)
  🟢Configure different AI model parameters for varied prompt creativity
  🟢Add image resizing or quality optimization steps
  🟢Create multiple output folders for different product categories
  🟢Add error handling and retry mechanisms for failed processes
  🟢Implement A/B testing with different AI models for prompt quality comparison

nodes_used:
  ["n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.lmChatOpenAi"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Z624bxxV+lcGmgC/gUHvjcikgQHW3EtskJDlOEBnC7OwsOfHeujsrmTH0BAXaHwXyIz/aBuiPPEKfJy/QPkLPmVmSS4qS5aD+Ia3mcs6Zc/nOxR+tTChm7X60ZF4rlnNxGlu7VuS4XmRzETsB922P+9EAfnA3HDqJCFk88IRjJywM7MAbMd8bCTHiA9ezR0MB95jVs5TIypQpcVCJuD4XqikPClgRSgADVTXitmflRSxqa/d74I5cHe4kg8R1qDtwhtQPfJ9GUQBf8SgMh4kXuTwAyjnLBJw+EYqcZmwqapJURUZOimKaCnJYyWuB/OclnsrDnGo2NGK16E/1ocWZsqilkkUOIgA7uweMXfsdrLMKeChR1aiZRKbwqb+KNBYVauijdXVVpeYhPSsDBsArlbUCqtcsbfDP78Zvzq5OxuOTl0dXh2en3xxdHY9fHh6dXZ0ewinO+EzEZ6JuUvUGSVkzpcp6d2cnRulaSfu8yMzCjmFe72iy91F6bXQzqYq44Qv9WLeg66LEl+KD4I9K1EVTcTwKrxPHmrSF66qp8r10+bI/NaKan6tK5lM42y/h163R7Tcgi1add9tr7Re5dhywyKNiZMfUZ3ZAQz4E+/lDPow8d+g73sp+e6cExMxKRU5ELiqmioo8HWspWfpsZcE/ggl3VmZMWT7lMybzPjwtV+tWdLQRffuuEZX4oJAp0J7/KIiayZqUrZYkaomwPCa8EuCyhOFWIupay0Iixt9Pq6KBA6WROAFZwTKZqLiEA+WsUMW0YuVs3ifHBW9qUuSkVvNU9EgqpzMF+utpDiK/llWRZyA6CMEUuSmaNEZiEBvt6kq0vrVhOMP/wmgmFonMxR2DuEuDMJFA5I5GlMf+gPohH9GQeQ78CBLPSfgwCO2VQc7ZtSBH+QxRIDau8/lx5Hj2fXHUshEtB/rxI/nD0ycPhfGTZ30JONL/oS7yPl4nt7fATsfDY6Pw1XwJCZ8dctmcxlvutkG2pLwZXb8DJsZvLiZvLv6PAPEJgu0TltZuAcNAxT3hDTnB9+wYwtsOE+q7iUdDEQwo567N7CFkBxavhfceBig5hcRSAW2tn/v8qVaSv5+/LtSmO/noTe6WgOZFWgAoD3rWjYzVDAQN7Z41ExhtsAz34EiuECJ2rS++IP/9x79+IkuhkFPdgZvL/DJ//nzSVMBbPH++u8AkOHQn+mvCGlVkDERmaTo3V18UN0QV5I2+fZk7fXKBcYxPJPB7PLk4Hb/ee0komRcN4Qzg4b0siVSACEpWAum4fXKakKbWYAHC5wLAiZFriZagnJUsgsiAN6AjpZe51yd7mJpyEOVa7JK3FUQL0q9IcZMvsCoG6lylcyJzwBZBJvKDSHmjtGxG+N9+/ud//v1XCMOyqKAIUOSlzKRi2mT6ORQfRsalyIH7yeSC+uQbLRUBIDxIWQOvbBewjhAsxjvjitQScG0OMtRadrXUCWJhAzQzljeIoEazRpx9oeBVxBhnIcA25pNKXEtxg9t7uZpVRSn5uji41SLKichkLjvrr7qsDfSj020GgLMMgEFgO2HgMpokWJ/EXNDITgSNA6xbnJELyW8VAEs9768caJnp7g0EjPEzAWm33khtw3vrk2YNHFgp+7G4FmlRiqpftkL0mdy5dnamrVfTlVMDFyA1K/CBk/H5xVrGsZTMRNFACAU2/APV1CKP94t4vsC0NsbajJQBtEiQTlHIkBmNmcJSEO+8AJ/Q8pprEZCYrL2i+6bvl8lCtlloudsyQvL7MmfV/NDwkHnZKPw+liKNX3du6wNow5aksXcHgCfdXF+rJpZFN+hvpJqRukhUJ5PzVGAEN1XCuKjbzJ6KKcYOU1lRlzNRiS5XFJh1uepS6t0tQhZq5jHK+JbuTU7p10ffbWaPyem3Ry8PAO5h/wr3gfCmG/v9VV0QB6MwCLyADmMb6gI/dmk45Jw6MdQLyZAFvs23OPJBkSdy2lQ6TshJI+P7C4T7AD3QgA6Nw6cBHcq4FaB77l1A/8uvSzAD/14XzyAJRhLAX0x0A7JAZiw5QFPkvZibmqMTJRqFzwS0LlyQrco1DqFRlnGFCAJ0NBgfNDXkBanLS7EsFdEfdcGor4CCtEArBzOSnjclgi/sHGtPWcDe5PUJeQoAjsVmHgtDqa0O62d44qsJnKgzSEWAmVjNA+j+KPTW26P9CXmK2aLKifFAWH8A4bwI27iBTUN/FFLfHgV0BKBGhcejJHSGgyj0V45xjMyMuOvK/2yvgAzfo569Bdw+kebveEWbyrqivWVVDlFr9HzQVJVYy3CY7S9zna1viup9kkImL3JIWqBlCO4aSgA0Amq2zU8XBWnNRcZg6WrNZOhfBZYClw92qJdWm3/B3Q6gCIMGpNNrmfNAjRCoGC6t/g/lFG6g7b+aHC2FWezeiKhst9+KaLLc/u3vv6AyQJhdPAaQA6fMG8aNAsBsJdeCt1Kg6162cAWnl9bA8mGtdNDueWkZopTsQ8aCJ7BUqnmPqIrlNdwVOZ8DTmplmfPmJZScb3qs2W6fAtm567U9AtWu6ZIqA9XmFa90vlmaGi1gKpUzgukPMy2IeWllkMYwc3z5RKeEHRD6CZYum+s/lGL65NJ6IEIc3wndyGOUDSOATj4I6WgUDSkLIscd+H6QuJ0iuJP6WyjCFu/zy2AznYDW6t4A8bbDJt7bhM2ffyVrcmUFJJP1KFlWgqjQ9dAQH0ooJ5cdak3enl68gG6jg2htmEAt+x1CXhsCL7C9XDFeRsteHEOR20m4VSsR1JEl2T86Hp8dmcJxIYMOGjTzwh+f1OZSt66BujouC5mrRRS9OXu5Sx5VJd2h1VI4xw50kTgw5deYVdqa9a5G1+vXbqa6KyxQxUP6quhH08XCoRAl1QrEe3eVpEvfuIgEOdD1K6j4/PDrBzFeuHYQjKD/Fk7EqO/xIR1hL+cMfNdOItuLA9EZCuATAaEEf9/2rZ/puSM9Dwgf1cENutC+xXP/9meyIc9GmsdhI/ZTLDVq/+2nX9ZQl4z3GjVzjXZxs2sVtOzXmMpxo+0wsGGE5aey7ctwoe1VnoELzPUBzgV2hRpCWt83E7X1rLiUaK282D4g3HJws6M3R45yqEJ1sVEimBq28JlJDZOtOOeCN9Aczk3fuxTkNUQA9GgzwOmFX0NgN1EqedrqAcOsO7O6ZpXEVq7W2QYqe7Q0KBZL/YXQ0yZlFSTQqlA4TVtQNtuvilziqA9Xm3o5eCvqRfd3AYkENX0O4b8ECVxsK3HYA3OamV0iK/QBgANwdJnMSWHSWpuHTFWGvmLSDPg0UgavukYvwSzi942Rqmyr8gb9NYGxd4I2AEqH+oEICx3OAs4jGg4GgvqR7dOR53MaOsEwEYKNEsFWEXYIvXpasJiYfsbApS5gavd3zLGd8IE59v1TMxl3moovcTSnh24yxpHb2oDLirScE+1xar6l1bJM7tUCWXH7vAfmxg4PgpCHAXUF96GvjmPKBpBdbe4NY8a9ER915sbtIOAAh6dYJKSPGBWnGR7XN+VmZkV1OVvUpYcsjxvhTUtF/b5DccCwMQ284yXQhr3TwIbTnYVK774JFpm8whc0oNh27XvsBY0Ej52e3yGCrXIsPli79u07bD8fdD9UA+hvjfMj5xr6XodZ77NF36SgxX3wf322ifu48NrK6+GXbmP24Ah9K49PKOP/aABgd3v7P/xt5A3wGwAA


name: Multi-Source News Curator with Mistral AI Analysis, Summaries & Custom Channels
author_name: Hybroht
author_username: hybroht
categories: []
created_at: 2025-07-18T22:44:28.618Z
updated_at: 2025-07-18T22:44:28.618Z
url: https://n8n.io/workflows/6157
scraped_at: 2025-12-24 13:02:44
description:
  Flexible News Curator - Multi-Sources, AI Analysis, Summaries, Translation, and Settable Channels

  🎬 Overview

  The Flexible News Curator workflow can automate the collection, filtering, AI-driven analysis, and summarization of news from diverse sources of your interest. Using customizable search themes, RSS feeds, and (optional) video descriptions, it delivers concise, quality news summaries via configurable channels. This workflow is designed to help reduce information overload and keep you updated effortlessly.

  Click the image below to watch the video guide:

  ✨ Features

  Multi-Source News Aggregation**: Collect news from customizable RSS feeds, SerpAPI, and Video Channel Feeds (if enabled).
  AI-Powered News Selection \& Summarization**: Uses advanced AI agents (Mistral Cloud Chat Model by default) to select, analyze, and summarize top news.
  Quality Assurance Step**: Optional AI-powered filtering to improve news selection quality before analysis.
  Multi-Language Translation \& Tone Customization**: Translate summaries and customize tone for localized or tailored consumption.
  Multi-Channel Delivery**: Send outputs via Email, Telegram, WhatsApp, Webhook, or save to disk.
  Advanced Filtering**: Regex-based filtering on URLs, titles, and content to exclude unwanted articles.
  Sub-Workflow Architecture**: Modular handling of video transcripts, content retrieval, multi-theme searching, and more.
  Flexible Scheduling \& Trigger Options**: Supports schedule-based triggering, email (IMAP) triggers, and webhook-based activation.
  (Optional) Video Search**: Video content descriptions via Video Channel Feeds.

  👤 Who is this for?

  This workflow benefits professionals, researchers, marketers, and anyone who needs to stay informed about specific news themes without wasting time on irrelevant information or reading too many news to select the most interesting ones.

  💡 What problem does this solve?

  The workflow tackles the challenge of information overload by automatically filtering, summarizing, and delivering the essential news tailored to your interests and preferences. It integrates various data sources and channels for comprehensive yet efficient news consumption. Ideal use-cases include:

  Monitoring breakthroughs in research fields
  Receiving daily business opportunity updates (e.g., real estate)
  Lower the cognitive load required to follow your favorite news
  Translating news summaries to your chosen language

  🔍 What this workflow does

  The workflow gathers news from RSS feeds, search engines, and social media, then:

  Filters duplicates and irrelevant content via custom regex filters and date ranges.
  Applies optional AI-powered Quality Assurance for headline evaluation.
  Selects top news articles with AI analysis focused on user-defined criteria and audience.
  Summarizes individual articles using AI summarization agents, ensuring structured, consistent outputs.
  Optionally translates and adjusts the tone of summaries.
  Distributes summaries through configured channels such as email, social media, messaging apps, or webhook calls.

  🔄 Workflow Steps

  1. News Gathering

  Fetch news using RSS feeds, SerpAPI search, and optionally video channel feeds.
  Standardize output structures for seamless merging.
  Employ sub-workflows for video transcript retrieval and looping over custom RSS feed lists.

  2. Filtering

  Remove duplicates and news outside the specified date range.
  Exclude articles matching user-defined keywords via regex filters in URLs, titles, and content.
  Limit the number of news articles for AI analysis.

  3. News Selection

  Optionally invoke an AI Quality Assurance agent to pre-filter headlines.
  Aggregate news for AI analysis.
  Select and summarize top news articles with AI agents using customizable criteria.
  Parse AI responses into defined JSON structures to ensure consistent data.

  4. News Summarization

  Prepare individual article content.
  Summarize content with AI agents and validate structured output.

  5. Sender Preparation

  Combine general summaries with selected top news summaries.
  Format final summaries as text and HTML suitable for delivery.
  Optionally apply translation and tone adjustment.

  6. Sending

  Deliver summaries through selected channels (Email, Telegram, WhatsApp, Webhook).
  Optionally save the output to disk as JSON.

  📌 Expected Input / Configuration

  The workflow is primarily configured via the Configure Workflow Args node or the Global Variables custom node, with these key parameters:

  | Parameter | Description | Type |
  | :-- | :-- | :-- |
  | search_themes | List of keywords/themes to search in SerpAPI | List of strings |
  | datetime_delta | Number of days back to include news from; e.g., 0 = today | Integer |
  | link_censor | Regex to exclude unwanted URLs | Regex string |
  | title_censor | Regex to exclude unwanted titles | Regex string |
  | content_censor | Regex to exclude unwanted content | Regex string |
  | use_qa | Flag to enable AI Quality Assurance for headline filtering | Boolean |
  | max_news_analysis | Max number of articles sent to News Analyzer | Integer |
  | qa_max_news | Number of headlines the QA Agent analyzes | Integer |
  | qa_max_top_news | Number of headlines selected by QA Agent | Integer |
  | qa_check_criteria | Criteria used by QA Agent to discard low-quality headlines | List of strings |
  | qa_select_criteria | Criteria used by QA Agent to rank/select the best headlines | List of strings |
  | news_focus | What the News Analyzer should focus on while selecting news | String |
  | news_target_audience | Target audience description for the News Analyzer | String |
  | news_criteria | Instructions for the News Analyzer to identify relevant news | List of strings |
  | language | Language for news summaries; triggers translation if not English | String |
  | translator_tone | Tone for translation (e.g., casual, professional) | String |
  | translator_notes | Additional instructions for the translator | String |
  | email_sender | Email address used for sending (via SMTP) | String |
  | email_recipients | Recipient email addresses (comma-separated) | String |
  | email_subject | Email subject line | String |
  | telegram_chat_id | Telegram chat ID for sending notifications | String |
  | phone_number | Phone number for WhatsApp messages | String |
  | rss_feeds | Custom list of RSS feeds (objects with link and needs_content_search properties) | JSON array of objects |
  | video_rss_feeds | Custom list of video RSS feeds | JSON array of objects |
  | enable_video_search | Enable/disable video search functionality | Boolean |
  | enabled_senders | List of enabled delivery channels (email, telegram, whatsapp, webhook, save-to-disk) | List of strings |

  Hint: To add or combine keywords in censors, use the pattern "keyword1|keyword2|keyword3".

  📦 Expected Output

  Structured JSON containing a general news summary, top news with summaries, and metadata, suitable for your preferred channel delivery.

  📌 Example



  An example that includes workflow parameters is provided in a note within the workflow.

  ⚙️ n8n Setup Used

  n8n version:** 1.100.1
  n8n-nodes-serpapi:** 0.1.6
  n8n-nodes-globals:** 1.1.0
  LLM Model:** mistral-small-latest (API)
  IMAP:** imap.gmail.com (Port 993)
  Platform:** Podman 4.3.1 on Linux
  Date:** 2025-07-15

  ⚡ Requirements to Use / Setup

  Self-hosted n8n instance.
  (This workflow contains community nodes that are only compatible with the self-hosted version of n8n.)
  Install necessary custom nodes:
      n8n-nodes-serpapi
      n8n-nodes-globals (or use Edit Field (Set) node instead)
  Configure all sub-workflows bundled within this template (see Sub-Workflows Guide).
  Provide valid credentials to nodes for SerpAPI, Telegram, WhatsApp, Mistral Cloud Chat API, and SMTP (for email).
  Custom RSS feed list must be set by you in the workflow args.
  You must either install the SerpAPI custom node or deactivate it.

  ⚠️ Notes, Assumptions \& Warnings

  The workflow timeout is set to 30 minutes by default; adjust depending on your setup and workload.
  Duplicate removal is applied, but occasional overlaps might still appear depending on feed sources.
  This workflow assumes familiarity with n8n, RSS feeds, API key management and regex expressions.
  Video search only works for configured video channels; remember to respect the rights of these channels.
  Using AI agents (Mistral or substitute LLMs) requires access to their API services and keys.
  Out-of-the-box customization is done via the Global Variables node or direct workflow argument edits.

  ℹ️ About Us

  This workflow was developed by the Hybroht team of AI enthusiasts and developers dedicated to enhancing the capabilities of AI through collaborative processes. Our goal is to create tools that harness the possibilities of AI technology and more. For questions, support, or feature requests, reach out via contact@hybroht.com.

  ❓ Questions & Issues

  We will answer any questions, provided they are related to this workflow.

  Please contact us if there is any bug/issue with this workflow. We will assist you.

  ⚖️ Warranty & Legal Notice

  You can view the full license terms here. Please review them before making your purchase.

  By purchasing this product, you agree to these terms.

nodes_used:
  ["n8n-nodes-base.merge","n8n-nodes-base.aggregate","n8n-nodes-base.filter","n8n-nodes-base.limit","@n8n/n8n-nodes-langchain.lmChatMistralCloud","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.markdown","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.executeWorkflow","n8n-nodes-base.splitInBatches","n8n-nodes-base.filter","n8n-nodes-base.if","n8n-nodes-base.executeWorkflow","n8n-nodes-base.rssFeedRead","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-globals.globalConstants","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.markdown","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.switch","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.splitOut","n8n-nodes-base.if","n8n-nodes-base.removeDuplicates","n8n-nodes-base.set","n8n-nodes-base.rssFeedRead","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.aggregate","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.manualTrigger","n8n-nodes-globals.globalConstants","n8n-nodes-base.code","n8n-nodes-base.emailReadImap","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.readWriteFile","n8n-nodes-base.function","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.emailSend","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.whatsApp","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.sort","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.xml","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-serpapi.serpApi","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow"]

workflow_json_compressed:
  [encoded data, 10512 characters]


