# templates

name: Clone Nested Folder Structures in Google Drive with Custom Naming
author_name: Jagged Frontiersman
author_username: jagged-frontiersman
categories: []
created_at: 2025-05-23T19:32:47.167Z
updated_at: 2025-05-23T19:32:47.167Z
url: https://n8n.io/workflows/4349
scraped_at: 2025-12-24 13:02:46
description:
  Google Drive Nested Folder Structure Cloner

  How it works
  Takes any Google Drive folder structure and creates an exact copy with custom naming
  Perfect for agencies, consultants, or anyone who needs identical folder structures for multiple projects
  Creates folder hierarchy only (no files are copied)
  Handles nested folders automatically with level-by-level processing

  Set up steps
  Get your source and destination folder IDs from Google Drive URLs
  Edit the 3 variables in the CONFIG node (takes 30 seconds)
  Connect your Google Drive credentials in n8n
  Run the workflow and watch it create your folder structure
  For deeply nested folders, run multiple times to process each level

  What you'll need
  Google Drive account with API access configured in n8n
  Read permissions on source folder, write permissions on destination folder

  Pro tips
  Create a "Templates" folder in Google Drive for your reusable structures
  The workflow intelligently skips folders that already exist
  Each run processes the next level down for nested structures
  Check the final report to see exactly what was created, skipped, or failed

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

workflow_json_compressed:
  H4sIAAAAAAAAE6WWzW7TQBCAX2W157hy3B9VvqDK/aEH2qqNQKLtYWtPnFXXu2Z3nbaKIoHEiQsHuICQuPIIPA8vAI/ArB3SpLHTuEi5ZHZ+vp3ZmfGIZmAZDUfUQpYLZiHSkJgzsEUeKZSAhYSGVhcw7lDJMqAhPVAqFUB2NR8C2VciAU3OUCW2hQYSCSVR4JGX3BRM0A61LDU0PKdpaeclzg7F/dLSy5hkKWQgLcpYYVXGLFeSXmI8lYCzHFGOENRqnqZo4cR0SvNqAJLEgsfXXKbkgvbAWHKj9HVfqJsL6uLf5U5RbsvS1HhXzMAaxkW8XuUTtXJleBk4PN/2O+u+jwA50xjEgkaK0bjy9BL/lWrdcWcCFivZ5+kDrl9fv/z++ZFEx0f7hweYjr2EW2IHQNbJkGnOrgQYwq5UmYt6xLhyOEMWrIYWTNFSsF6VaHOP9uf7p3fkACzZEWJSQNMIMbA2P4U3BaZ1nmVjNZaNtftEcdTB6g7By7WKwRilZ6k+vycnlfxRqsXUbLVNjRmoQiRerAGf/RzGW3JWnpGoPHvWSMH7Dx5OW4Yq+KRCM2/n249J7Eki2len6yNL0K48fS6Z8DTkStu51/KB7LsjcvrvaNWidIPVKO4zgrdOMkCvszU53dvZfbHXGNdY7P67o8pkvo+3F0K7brVu2oSUPtrSBuLS15QkKuXkOYi8NQ7mobMRPBFo0jA44xahTqZn5FD2VWuwrf8Bs1oVbpYNlLKObr5yvfnT1mjdJyUNtQ1YF7DUhVuIC+fwWLteCumw64yKPMEOS3ack8APNj1/0wvWe90g9H38rfm+/xpphpXfQ3fZboACY3GGxbvMLU5ZCNFxMLIqShlvsX1RmDHuLoTLrNwTS/uq1O1QLhO4paE/vrxE3LrBVOd3yfBo8FuzDeqBlw3oJuZFkwbfzVO31vVje782NU/YybXBWzhqKP2SBVwT0T3x6kslUoV79f74L7Sg0aW7CQAA


name: Check dependencies before completing Awork tasks (Workaround)
author_name: Gregor
author_username: gregorg
categories: []
created_at: 2025-05-23T22:05:16.247Z
updated_at: 2025-05-23T22:05:16.247Z
url: https://n8n.io/workflows/4350
scraped_at: 2025-12-24 13:02:46
description:
  Awork currently does not support a check for open subtasks or open dependencies when setting a task status to done. This workflow offers you a simple workaround to add this functionality to Awork and notifies users when triggered. Multiple configuration options available.

  How it works
  Triggered via Awork Webhook call on status change of tasks
  If task is marked as done, subtasks and/or dependent tasks are checked for their status
  If unfinished tasks are found, a status rollback to previous status is performed and user gets notified 

  Set up steps
  Add webhook call to Awork
  Configure Awork API credentials
  Set up workflow configuration via setup node, e.g. user notification text, restrict to subtasks/dependency checks etc.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.aggregate","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.aggregate","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7784 characters]


name: AI-Powered Multi-Social Media Post Automation: Google Trends & Perplexity AI
author_name: Gerald Denor
author_username: dominixai
categories: []
created_at: 2025-05-24T00:42:22.300Z
updated_at: 2025-05-24T00:42:22.300Z
url: https://n8n.io/workflows/4352
scraped_at: 2025-12-24 13:02:41
description:
  Overview
  This comprehensive n8n workflow automatically transforms trending Google search queries into engaging LinkedIn posts using AI. The system runs autonomously, discovering viral topics, researching content, and publishing professionally formatted posts to grow your social media presence.

  Workflow Description
  Automate your entire social media content pipeline - from trend discovery to publication. This workflow monitors Google Trends, selects high-potential topics, creates human-like content using advanced AI, and publishes across multiple social platforms with built-in tracking.

  Key Features
  Automated Trend Discovery**: Pulls trending topics from Google Trends API with customizable filters
  Intelligent Topic Selection**: AI chooses the most relevant trending topic for your niche
  Multi-AI Content Generation**: Combines Perplexity for research and OpenAI for content curation
  Human-Like Writing**: Advanced prompts eliminate AI detection markers
  LinkedIn Optimization**: Proper formatting with Unicode characters, emojis, and engagement hooks
  Multi-Platform Support**: Ready for LinkedIn, Twitter/X, and Facebook posting
  Automated Scheduling**: Configurable posting times (default: 6 AM & 6 PM daily)
  Performance Tracking**: Automatic logging to Google Sheets with timestamps and metrics
  Error Handling**: Built-in delays and retry mechanisms for API stability

  Technical Implementation

  Workflow Architecture
  Schedule Trigger: Automated execution at specified intervals
  Google Trends API: Fetches trending search queries with geographical filtering
  Data Processing: JavaScript code node filters high-volume keywords (30+ search volume)
  Topic Selection: OpenAI GPT-3.5 evaluates and selects optimal trending topic
  Content Research: Perplexity AI researches selected topic for current information
  Content Generation: Advanced prompt engineering creates LinkedIn-optimized posts
  Content Distribution: Multi-platform posting with platform-specific formatting
  Analytics Tracking: Google Sheets integration for performance monitoring

  Node Breakdown
  Schedule Trigger**: Configurable timing for automated execution
  HTTP Request (Google Trends)**: SerpAPI integration for trend data
  Set Node**: Structures trending data for processing
  Code Node**: JavaScript filtering for high-volume keywords
  OpenAI Node**: Intelligent topic selection based on relevance and trend strength
  HTTP Request (Perplexity)**: Advanced AI research with anti-detection prompts
  Wait Node**: Rate limiting and API respect
  Split Out**: Prepares content for multi-platform distribution
  LinkedIn Node**: Authenticated posting with community management
  Google Sheets Node**: Automated tracking and analytics
  Social Media Nodes**: Twitter/X, LinkedIn and Facebook ready for activation

  Use Cases
  Content Creators**: Maintain consistent posting schedules with trending content
  Marketing Agencies**: Scale content creation across multiple client accounts
  Business Development**: Build thought leadership with timely industry insights
  Personal Branding**: Establish authority by commenting on trending topics
  SEO Professionals**: Create content around high-search-volume keywords

  Configuration Requirements

  API Integrations
  SerpAPI**: Google Trends data access
  Perplexity AI**: Advanced content research capabilities
  OpenAI**: Content curation and topic selection
  LinkedIn Community Management API**: Professional posting access
  Google Sheets API**: Analytics and tracking

  Authentication Setup
  LinkedIn OAuth2 community management credentials
  Google Sheets OAuth2 integration
  HTTP header authentication for AI services

  Customization Options
  Industry Targeting**: Modify prompts for specific business verticals
  Posting Schedule**: Adjust timing based on audience activity
  Content Tone**: Customize voice and style through prompt engineering
  Platform Selection**: Enable/disable specific social media channels
  Trend Filtering**: Adjust search volume thresholds and geographic targeting
  Content Length**: Modify character limits for different platforms

  Advanced Features
  Anti-AI Detection**: Sophisticated prompts create human-like content
  Rate Limit Management**: Built-in delays prevent API throttling
  Error Recovery**: Robust error handling with retry mechanisms
  Content Deduplication**: Prevents posting duplicate content
  Engagement Optimization**: LinkedIn-specific formatting for maximum reach

  Performance Metrics
  Time Savings**: Eliminates 10+ hours of weekly content creation
  Consistency**: Maintains regular posting schedule without manual intervention
  Relevance**: Content always based on current trending topics
  Engagement**: Optimized formatting increases social media interaction
  Scalability**: Single workflow manages multiple platform posting

  Installation Notes
  Import JSON workflow file into n8n instance
  Configure all required API credentials
  Set up Google Sheets tracking document
  Test workflow execution with manual trigger
  Enable schedule trigger for automated operation

  Best Practices
  Monitor API usage to stay within rate limits
  Regularly update prompts based on content performance
  Review and adjust trending topic filters for your niche
  Maintain backup of workflow configuration
  Test content output before enabling automation

  Support & Updates
  Comprehensive setup documentation included
  Configuration troubleshooting guide provided
  Regular workflow updates for API changes
  Community support through n8n forums

  Tags
  social-media content-automation linkedin ai-generation google-trends perplexity openai marketing trend-analysis content-creation

  Compatibility
  n8n Version: 1.0+
  Node Requirements: Standard n8n installation
  External Dependencies: API access to listed services
  Hosting: Compatible with cloud and self-hosted n8n instances

nodes_used:
  ["n8n-nodes-base.twitter","n8n-nodes-base.facebookGraphApi","n8n-nodes-base.linkedIn","n8n-nodes-base.googleSheets","n8n-nodes-base.splitOut","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6400 characters]


name: Legal Case Research Extractor, Data Miner with Bright Data MCP & Google Gemini
author_name: Ranjan Dailata
author_username: ranjancse
categories: []
created_at: 2025-05-24T04:29:07.388Z
updated_at: 2025-05-24T04:29:07.388Z
url: https://n8n.io/workflows/4354
scraped_at: 2025-12-24 13:02:44
description:
  Notice
  Community nodes can only be installed on self-hosted instances of n8n.

  Who this is for
  The Legal Case Research Extractor is a powerful automated workflow designed for legal tech teams, researchers, law firms, and data scientists focused on transforming unstructured legal case data into actionable, structured insights.

  This workflow is tailored for:

  Legal Researchers automating case law data mining

  Litigation Support Teams handling large volumes of case records

  LawTech Startups building AI-powered legal research assistants

  Compliance Analysts extracting case-specific insights

  AI Developers working on legal NLP, summarization, and search engines

  What problem is this workflow solving?
  Legal case data is often locked in semi-structured or raw HTML formats, scattered across jurisdiction-specific websites. Manually extracting and processing this data is tedious and inefficient.

  This workflow automates:

  Extraction of legal case data via Bright Data's powerful MCP infrastructure

  Parsing of HTML into clean, readable text using Google Gemini LLM

  Structuring and delivering the output through webhook and file storage

  What this workflow does

  Input

  Set the Legal Case Research URL node is responsible for setting the legal case URL for the data extraction.

  Bright Data MCP Data Extractor

  Bright Data MCP Client For Legal Case Research node is responsible for the legal case extraction via the Bright Data MCP tool - scrape_as_html

  Case Extractor

  Google Gemini based Case Extractor is responsible for producing a paginated list of cases

  Loop through Legal Case URLs

  Receives a collection of legal case links to process

  Each URL represents a different case from a target legal website

  Bright Data MCP Scraping

  Utilizes Bright Data’s scrape_as_html MCP mode

  Retrieves raw HTML content of each legal case

  Google Gemini LLM Extraction

  Transforms raw HTML into clean, structured text

  Performs additional information extraction if required (e.g., case summary, court, jurisdiction etc.)

  Webhook Notification

  Sends extracted legal case content to a configurable webhook URL

  Enables downstream processing or storage in legal databases

  Binary Conversion & File Persistence

  Converts the structured text to binary format

  Saves the final response to disk for archival or further processing

  Pre-conditions

  Knowledge of Model Context Protocol (MCP) is highly essential. Please read this blog post - model-context-protocol
  You need to have the Bright Data account and do the necessary setup as mentioned in the Setup section below.
  You need to have the Google Gemini API Key. Visit Google AI Studio
  You need to install the Bright Data MCP Server @brightdata/mcp
  You need to install the n8n-nodes-mcp

  Setup
  Please make sure to setup n8n locally with MCP Servers by navigating to n8n-nodes-mcp
  Please make sure to install the Bright Data MCP Server @brightdata/mcp  on your local machine.
  Sign up at Bright Data.
  Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel.
  Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions.
  In n8n, configure the Google Gemini(PaLM) Api account with the Google Gemini API key (or access through Vertex AI or proxy).
  In n8n, configure the credentials to connect with MCP Client (STDIO) account with the Bright Data MCP Server as shown below.



  Make sure to copy the Bright Data API_TOKEN within the Environments textbox above as API_TOKEN=&lt;your-token&gt;

  How to customize this workflow to your needs

  Target New Legal Portals
  Modify the legal case input URLs to scrape from different state or federal case databases


  Customize LLM Extraction
  Modify the prompt to extract specific fields: case number, plaintiff, case summary, outcome, legal precedents etc.

  Add a summarization step if needed

  Enhance Loop Handling
  Integrate with a Google Sheet or API to dynamically fetch case URLs

  Add error handling logic to skip failed cases and log them

  Improve Security & Compliance
  Redact sensitive information before sending via webhook

  Store processed case data in encrypted cloud storage

  Output Formats
  Save as PDF, JSON, or Markdown

  Enable output to cloud storage (S3, Google Drive) or legal document management systems

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-mcp.mcpClient","n8n-nodes-base.function","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-mcp.mcpClient","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitInBatches","n8n-nodes-mcp.mcpClient","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.httpRequest","n8n-nodes-base.readWriteFile","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait"]

workflow_json_compressed:
  [encoded data, 4404 characters]


name: Automate Your LinkedIn Engagement with AI-Powered Comments! 💬✨
author_name: Rish
author_username: b2brish
categories: []
created_at: 2025-05-24T11:05:17.810Z
updated_at: 2025-05-24T11:05:17.810Z
url: https://n8n.io/workflows/4357
scraped_at: 2025-12-24 13:02:44
description:
  Tutorial Video

  This n8n workflow is your ultimate tool for smart LinkedIn interaction, leveraging the power of AI to generate witty comments and engage with posts via the Unipile API. Perfect for community managers, marketers, or anyone looking to scale their professional presence with intelligent automation!

  How It Works:
  Trigger by Chat Message: Simply send a chat message (e.g., from Telegram) containing a LinkedIn post ID. 📨

  Extract Post ID with LLM: An intelligent Large Language Model (LLM) precisely extracts the LinkedIn post ID from your message, ready for action. 🧠

  Get Post Details: The workflow fetches all the juicy details of the target LinkedIn post from Unipile. 📥

  AI-Crafted Comment: An OpenAI LLM, acting as your personal AI & startup expert, generates a unique, witty, and cheeky comment tailored to the post's content. No boring, generic replies here! ✒️🤖

  Publish & React: The generated comment is then published to the LinkedIn post via Unipile, and a reaction (like a 'like' or 'upvote') is automatically added to boost engagement. 👍💬

  Confirmation to Telegram: Get instant feedback! A confirmation message is sent back to your Telegram, showing the post URL and the exact comment that was shared. ✅

  Why You'll Love This Template:
  Intelligent Engagement: Move beyond simple replies with AI-powered comments that resonate on a professional platform.

  Time-Saving Automation: Automate repetitive LinkedIn tasks and free up your schedule for more strategic activities.

  Scalable: Easily adapt and expand this workflow for various professional engagement types.

  Customizable: Tweak the LLM prompts to match your professional brand's voice and desired tone.

  Get Started:
  Unipile API Key: Secure your UNIPILE_API_KEY and set it as an environment variable in n8n.

  Unipile Account ID: The account_id (e.g., PXAEQeyiS2iSkSJCRuNcvg) is currently hardcoded within the HTTP Request nodes. For a production setup, consider making this dynamic or using n8n credentials if Unipile offers them.

  OpenAI Credentials: Ensure your OpenAI API key is configured as an n8n credential.
  Telegram Integration: Configure the Trigger: Chat Message Received node and the Telegram: Send Confirmation node with your Telegram Bot Token and Chat ID. The confirmation node is currently disabled; enable it to receive notifications.

  Ready to supercharge your LinkedIn engagement? Give it a try! 🚀

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.toolThink","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:
  H4sIAAAAAAAAE6WX224bRwyGX0XYiyIFPO4cOCddNWiKIEDSBm7aXhRBMQeOvbC0cqVNkyDwu5e7lk+SVlqpNwIkzQw/kj85nG/VHNtQTb9VdbNqQ5PwTa6mFeoQrHcmROPBcPDOlWwEFGGyytmlKK1OiptsdTbBCYcCkufeCgVWper2rGoWGVfV9C86ujsyq8CtTIl5aQ2D4g3z4BIrMnnFPc+xyIp2hTnS6t+b+qae4XTyGtvJ+8Wqnbwiznq2oiXt15tuSeMa1ttgMazw/Kptby7wn0+4amnNzWJVt/WiIfvS8TOmgH+kX8OSjm9xSVzfbu9O+oO+9QvhXN6erWGF5YproViEFBjYmFhEDKzYLMBklCLoHbA/LeZzbNrJoumZj2cVHaw4jjWrAtoDMJmUY6C1ZgG9Y5oy5rP3RcXwyPrrDTYv3xDqVWgn7whpNnlxj/0aG1yGDuX7R/Qfif2HR/5ZaC7TVaib89m8O6M/r37uhSYnzEEfxBMfLDfRC+cJP0T6sI55U4BFGZN22kXtnvjwYVlfXuLy3glcrcIlTi4wYf0v5hHo9NmuD3lOzmwnFtnDf8Z4tVhc9/UAWmaEyBklXzLIkvQQsmMxZ15KTEp5qA76Kx78DR510QIpZ6UrhpyYE0HRVywQdVCCp/0562vizavJz1/aZUj/P2dMSlIePyprUIriHIGJYBIDSaILCIoFjd4GFzwHvqNKXuZ8V9IXeEd+Qp04oDwd1tjTOgEVhOTGMaccUA67mnYxM29NDMpyTWX+SPv27bvpfXAn62CPU1bdvJ3NN4Pby+pwXYtz88BbJPXFCIJZoF4JmIE5nzUTHC3nYGy0coN3XcB434hGAFPlNBvBtXJcwxTn/rFhkg6co+BKxTMDIFUHZ0jQYGQmQYMXTwsYZ3hJJ08nv2GTibYp9XIe9mqhXe/ZaO7KECzIzYKVoruuQqEUA1UtOGooPGmGKKi6YsLE8XDBPoonJBcCUvQ594qSEYGFEpGBUgoM6Yo83EjGBZa6eUjF5MWHq7q5rpvLMXXaLhazfv1zbz1lZkReHqipcypjAzIePbHyaFk0xjDlM11pBpTuo7Cm/mXRUnX+uVhel9niM124q7SsbzrTk+8oUe2nm8HkrNo6XX/tDtgQfncVqO2uUqVF03bCm1bVML7MAYOlNiscDQqAJTLqKZJxoUIUPoiSyyb+uq2fyuu6QtXyRGBINmZBsjCFZgcQIrModGYiBW1o/tEmbcV7u5EfT00RJuptZYyj9iFLLahsnetUAl0bd3TNJWkFRiR5Z75JPXosG2IWXd3aU5URjLbSa8uSytQbqVHSvECDjwZBnTFEm73cRh5qjiORTXfn2FO1YRNNEA4dMyr22hDMWWFZprZpRBQSi91EHjtPDga5j7JwJyInZbXGQl3cSktTGXU+inKhISgkGvajsD5vIo+/3Aeh7+6fk2tQqGIkBBY19Xu6OgXNIzIwa4TLdEuJBG4TevwtNAQtZS+OY0uQVtP/DfaR6pfvnDvo9zldC2SHXlMdzbgXUr/njF52Gb9UU3778SMR7B4U9loYlOFOA4Pb9trYo5v9Vrbc32XmwHS038I22i4To2aa4YwMTwtkLNR/dxPBMS7db9k0duDtNBi8wVF4p0tjX5l3vnVzzyfC6Bce6eTzvWM4dr2cRnEMhuAAxu3tf9Nox8lmEQAA


name: Auto-Delete SPAM, Social, and Promotions Emails in Gmail
author_name: Khairul Muhtadin
author_username: khmuhtadin
categories: []
created_at: 2025-05-24T11:22:05.573Z
updated_at: 2025-05-24T11:22:05.573Z
url: https://n8n.io/workflows/4358
scraped_at: 2025-12-24 13:02:44
description:
  Who is this for?
  This workflow is perfect for Gmail users who want a tidy inbox without manual effort. It’s especially great for those overwhelmed by SPAM, social media updates, or promotional emails and want them automatically removed regularly.

  What problem is this workflow solving?
  Unwanted emails like SPAM, social notifications, and promotions can clutter your Gmail inbox, making it hard to focus on what matters. Manually deleting them is repetitive and time-consuming. This workflow automates the cleanup, keeping your inbox streamlined.

  What this workflow does
  Every 3 days, this workflow deletes emails from Gmail’s SPAM, Social, and Promotions categories. It uses n8n’s Gmail node to fetch these emails, merges them into a single list, splits out individual email IDs, and deletes each one. The scheduled process ensures consistent inbox maintenance.

  Setup
  Set up valid Gmail OAuth2 credentials in n8n.
  Import the "Clean My Mail" workflow into your n8n instance.
  Confirm the Gmail nodes target SPAM, CATEGORY_SOCIAL, and CATEGORY_PROMOTIONS labels.
  Adjust the "Run Every 3 Days (Trigger)" node’s schedule if needed.
  Activate the workflow to begin automated cleaning.

  How to customize this workflow to your needs
  Change the Gmail node labels to target other categories or custom labels.
  Adjust the schedule frequency in the trigger node.
  Add filters to spare specific emails from deletion.
  Extend functionality with nodes for archiving or notifications.

  made by:* khmuhtadin
  Need a custom? contact me on LinkedIn or Web

nodes_used:
  ["n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.merge","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE9VY3W4jtxV+FWZSNLuA6Aw5nBmOgKJw7M1WSB0v1kaKxWpRcMhDaWJpRpgfO4IhIFe9DdqmaG+K3BTobS/7PPsCzSP0kCOvZUn2/jS9yJXlGfKcw+87Px/nOihMMAzMSJ4cjw6/ev7s+ejkMPsiGARzaFUwvA6KsmlVqWHk1mmexGGaRTYRIsyY0TK0eRaGFpJICKkMsyJPUxGG0kCWhDJMhElSngkrozDVaLeF+WKmWjiqwTRn0HaLowqfQAvooK07WA2CUs0BvR3NQJXkZElOVDFzW9WkCYYvX+GCyoD7ed2HL1XGmWAhZbEKqchDoBkLBWWZtYoZEzMTBm/MHoPzRg5nM2+4cZaXC/emlCX1pmmuGjiYzHu/i6op2qIq0WHEw0EchhjCFeTTqrrwsOQMEiVlQm2ogIo0U1TxWNMoVUlusjzRSezsqBojaKFuHLBzaBo16XH91fU1+cXXTVUeFIasVri2WkCteqeB8QEHCIxG0KBsCzXzJnyAp4ddO+WeKo/FgrGzVOVfv5BfGPNZdnvup241UVpXXdkGq1V/7K8wHO+GH7DVYG0kzJFSlnGagDJUhIzRXCQZTTOjpJVhFFl7a/jQfN017RwDux/Lpi30xfLLCs9xB1CKyTJg3CF6F56rwrTTYIhgD4IpFJNpGwzd2kBXZYuu0MXHH5Mff/jzP0l/MJ9L45IdIKsXQJquBqKQ4/6tD4V0DZBLNUOQVWkIWipBY+Kt1/RIkg2QD8YlPyDnFekpIKawFmp8ScDv0JjIk6ouoBkQ5VEg7RTITOUwa0hRElB6uhHBcFwSQij55Cm0PrizZ4cnva3mE/L6D3/qtw798521lcaY7iw7Ojx/8vT0+Yvfn50ejQ5/u73jWV3NKwd0s3/Xs+enJ6fno9Mvz8ZlsJ0Pt9mQC+BaiZBGMsbySqWleSoNzRPJRBRHKpHqNhvOPNNkTfV7ZgPjWGBRcm864KvbdOA76fD6u3+RMz0F082Q1fO6mEygHpeUnE+LhlxV9YWdVVek7sqGqK6t5lhiGpFaEriEekkiYtTSsU7Ji6pDekuip6qcgKe1QE81po8j1v0/DtYeyBO/+3xaA5BjtDAOPN2krTAPi5Ysq64mJWDHO3gQaR7nOU+w2iImpUM6p0onhvIITMJZLkwc7kWafQDU8kGkBX8Q6R9/+P5bcgI1QvNLzDNAG0BGx00PtsPGv7wBQlfzvCixAmtoulnbEIup6XO09aBtFukjl/yDdboPNpL4sSdmHJwtZojpadfeWG/cg6YvvQJrsKn6wuuLdHTsicyBLOpKY9fF1ChKU1wWpnPcP0wJi3DcWYENUFlshVGqqUxTrADIIOGahZneTwl/b0qi8H9j5K9//M+/vyPr8fbEN5VbOran3g12fWdr1k0IO2RRThySRU3WE8rR6pE/rrp8BhTrS1/s9Ll6VmAhNC0sGpf26rJyXVbrwvVSX2Lek7NezBdVjaJi3UXfUhM6zxF6JinPQFChspTKhAkaGQugwQiu0lsCnnfluhojX4nk0bpGH99Px7phrBdulQmqmPXEv0tKjTt6fdQ3Ba9GXPcYvXkQrV7tTFl2wN+cDLSOEpEaaiXTVCRhTKVNEsoVPuRhnhoDtyf7HFpMaT8wem7fR7fQGPMl4tvCReVxZpWNaWhyjsLJRNhvwoxCnOUx2DRVjO0IF1vMbn76BBgZJ8UCF1nwanVXukygxYxDEzVO57p0v29E3v9ZywwCNbtCOrBNLLr2WDk123teGxeKS2kYpyhhMa+EUjTTWOdc4LADYWNjkh30fU/6UPx3hSNTJkM9LWnOY8RfxglFNhiKIpEnIgae8l3heA/+W1rg50SFTWIbx8rSKEqRCo6NNpMWKNfWxAIvDqmKt6l4MxY+lI1EbrMRWi6MxmowOkYZH2UxVRloakLNUpNbnCnhe7Nxq7F+TozEObMhF7Frf9iadCSpinRGZSxim8pIymijOI766e6Hi2cHJ+xbWJk7dbCtSO5ptWU3z6EelRhq47rq1nmijYuLzVIWMstonHGkkCOFeYT/qiTiKlYsjmO2Ma29kHiyVgk4K07xEEgQKfCW+sDAcNsQurvhi/3BVwuvXfAnxm0LmJnz6uzGwNBFff/okyaKBYQK2zNn2KJEQmUeSxx9MoE8trmWZq/2iD5MDqZ74tfVrKrx6jV4Rxny+m9/Ib+B5QAFQuGUQIVy2f3tNYBFsffRuByXI+tEMZmqS7yllUuUyTh7Gw/VgOBgN7nSFwNS1cTfqq5UWSrSqCWZFuT1t9+7JTNvDU2/rL3aq7r21aNp2y6a4aefXkzn3bRVpigPUHs65Tguf9cb6RZOfpD5EmUhXudc4npp/mvy8rNuiaqHKNSr+AZuzeXdco5O/FNncMP+Y3fk13//B2ov5+Qc7wsXDYriqVoslm9uGeXko70qB/FWui0uoS/AQdBA61Z77OEb0J3D5LQ2KEyGwSVzJi777b5nRYJjOYqIohbiTkNwmoVW0iQ0QlsV5TpyN/X1VXedibufQNz3CFW4RHj5yrWpXbGxseLaf395x7r3mwYokwx8EwzD1ab5O9P0p3HANh3szIifxgfvfTywcZ+fd202ewF7QNbu8/WAVtw2P9jetF/ivG3b/eN473neAsa+M93/2W6Ph9XqvxVJpM7aFAAA


name: AI-Powered Post-Sales Call Automated Proposal Generator
author_name: Gerald Denor
author_username: dominixai
categories: []
created_at: 2025-05-24T13:32:44.312Z
updated_at: 2025-05-24T13:32:44.312Z
url: https://n8n.io/workflows/4359
scraped_at: 2025-12-24 13:02:42
description:
  AI-Powered Proposal Generator - Sales Automation Workflow

  Overview

  This n8n workflow automates the entire proposal generation process using AI, transforming client requirements into professional, customized proposals delivered via email in seconds.

  Use Case
  Perfect for agencies, consultants, and sales teams who need to generate high-quality proposals quickly. Instead of spending hours writing proposals manually, this workflow captures client information through a web form and uses GPT-4 to generate contextually relevant, professional proposals.

  How It Works
  Form Trigger - Captures client information through a customizable web form
  OpenAI Integration - Processes form data and generates structured proposal content
  Google Drive - Creates a copy of your proposal template
  Google Slides - Populates the template with AI-generated content
  Gmail - Automatically sends the completed proposal to the client

  Key Features
  AI Content Generation**: Uses GPT-4 to create personalized proposal content
  Professional Templates**: Integrates with Google Slides for polished presentations
  Automated Delivery**: Sends proposals directly to clients via email
  Form Integration**: Captures all necessary client data through web forms
  Customizable Output**: Generates structured proposals with multiple sections

  Template Sections Generated
  Proposal title and description
  Problem summary analysis
  Three-part solution breakdown
  Project scope details
  Milestone timeline with dates
  Cost integration

  Requirements
  n8n instance** (cloud or self-hosted)
  OpenAI API key** for content generation
  Google Workspace account** for Slides and Gmail
  Basic n8n knowledge** for setup and customization

  Setup Complexity
  Intermediate - Requires API credentials setup and basic workflow customization

  Benefits
  Time Savings**: Reduces proposal creation from hours to minutes
  Consistency**: Ensures all proposals follow the same professional structure
  Personalization**: AI analyzes client needs for relevant content
  Automation**: Eliminates manual copy-paste and formatting work
  Scalability**: Handle multiple proposal requests simultaneously

  Customization Options
  Modify AI prompts for different industries or services
  Customize Google Slides template design
  Adjust form fields for specific information needs
  Personalize email templates and signatures
  Configure milestone templates for different project types

  Error Handling
  Includes basic error handling for API failures and form validation to ensure reliable operation.

  Security Notes
  All credentials have been removed from this template. Users must configure their own:
  OpenAI API credentials
  Google OAuth2 connections for Slides, Drive, and Gmail
  Form webhook configuration

  This workflow demonstrates practical AI integration in business processes and showcases n8n's capabilities for complex automation scenarios.

nodes_used:
  ["n8n-nodes-base.googleSlides","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleDrive","n8n-nodes-base.gmail","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4688 characters]


name: Auto Update n8n to Latest Version with Coolify
author_name: Haqi Ramadhani
author_username: gemboran
categories: []
created_at: 2025-05-24T13:56:50.112Z
updated_at: 2025-05-24T13:56:50.112Z
url: https://n8n.io/workflows/4360
scraped_at: 2025-12-24 13:02:44
description:
  Automatically detect new n8n releases (stable or beta) from GitHub, update Coolify environment variables, and trigger deployments.

  Functionality  
  This workflow automates deployment of n8n releases to a Coolify instance. It supports two tracks:  
  Beta Releases: Checks GitHub every minute for prereleases, filters duplicates, updates the N8N_VERSION environment variable, and deploys.  
  Stable Releases (disabled by default): Checks the latest stable release hourly and deploys.  

  Key Features:  
  Deduplication**: Ensures no repeated deployments for the same release.  
  Version Parsing**: Extracts the semantic version (e.g., 1.34.0) from GitHub release names.  
  Coolify Integration**: Updates environment variables and triggers deployments via API.  

  Expected Outcomes  
  New n8n beta/stable releases detected via GitHub API.  
  Coolify environment variable N8N_VERSION updated to the latest version.  
  Automatic deployment triggered in Coolify.  

  Setup Guide  
  Replace Placeholders:  
     Update m8ccg8k44coogsk84swk8kgs in the Update ENV and Deploy nodes with your Coolify Application UUID.  

  Configure Credentials:  
     Add Coolify API credentials (httpHeaderAuth) with a valid API token in the headers.  

  Enable Triggers:  
     Toggle the Auto Update Latest Release node if stable releases are desired. Adjust schedule intervals as needed.  

  Test:  
     Run the workflow manually to validate API connections and version parsing.  

  SEO Keywords  
  Automated Deployment, n8n CI/CD, Coolify Integration, GitHub Release Monitoring, Environment Variable Management, Beta Release Automation.

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.filter","n8n-nodes-base.limit","n8n-nodes-base.removeDuplicates","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.scheduleTrigger"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1X227bRhD9FYEo6hTQSlxyeTNgtImTNEZTx3FcF0VhGHsZSltTXIUXJYahf+8sRVmUTMVO2oc+9En2cHhmztx55+RGQekc/nnnaOUcOn4AYULDhMhAeoQlMiYCICUh8FC5oGQoUmfo5HwGqP0zVINzyICXgMLqdm6FeZyTBpUIlI+mVTU/h481lBXqzE2pK21ytBh67pBQz71CKS8QsIICPblz6iJDGPteeTge87keTXQ1rcVImtm4AIQYWxva2B8UNPbLccarlQ0ztxYs1HLolJCr9zUUt85hVdQwdD7af862DHbNYyBacnMorud8YpkteFZbEXWd5dUSUXODtk7y15n5tMa17C8RoiHHRt5y2IbUdWUKLo+JioIIQxq7hPsqJDKliSsj5nIv2IT0t7lCHoNXp5dfH1HqhhhSb29Ij9YxlRgek8FI1Lzi+UgrG+XxguLPPNOSN/Eb390NDmaxlJP4hjFpzKS8iVn56Sa+mZQHg+VyDPmiRA/QzNRYpmfPL47f9CXghVH38ed1NYW8aq3gWxPIodDyuABl5Ty7sKyHjsCXnpKnG7jtpOg0Pr2+fHX+4eTdqWNT0CqtHm/UjpDcd3+VJh9ZhVGJtKtnBz8d/DDKeFk9+wHpdV/X5fW8gIWGTzsYKc9KeKgsap2p60rPdm3aGDxUR+NQ8Gwv9hXGsQ3TcwzfxaosbDbfAFdQWCFCOvI+hk28rMIL4EWrcNgW5O+//lHdHE9++fw2NCJ7/25TfMfGZDq9HZDBgwqx8DsG13hn5S1dXJw8Pzl9nS/OLukT8b6yjZgPioWhS1wqOWFBmBJBQ0pYFHBG00DicNpYfgnzzNx+Qwt58T9sIdVY/rGutTp6rIO+T00h4ahJ9G7fPLlP/i+MyIc0okSxKCUMNxiJqQyJnwhFcYF5KRcby691hhndWxjp+nGnJpiLJeH3lMRWvpCI0uv/O4+cxdppb+hkkFaXbYujEYkmP0BuLS1giyjPtFonvqwwvVWTRjMTOueVKVDMc+Vsm10vccqUZNgcJAwSXOK2X3DHeITHHuc+F5Jz1pQbDp0G624dDYF5AZ7fP1w5YP1CUanzSQat+1a23Ca0mak4K9u1bMfX0Cn0ZLrhvVqhW/n0OvkMeORHScBIAKAIY6kgiYSEqMD1wzCMBPM7lfRWz3S1N51Z+3T37OjJ5q5L9N6hOHQDyQErSkBMGEQJSbiISEq5ErjapVBs49A5zMwCBi/r1SaFcq9zRaO5pdjxM2Z7BtFW1XXTtMI7qWBWfgDIT/Izu7JMXb76DLJevTR0FKh6Dg9zZt1fbaad1NzHIeEeYywMCBUuTmDPlyT2WUDCJAAqooT7UScxndtwfwj2z+F4T89923H437sKAaI09GNKYrz/CHNlQrhKMZgqEdSTMmWis85wrJpBexq+be7cR+/uUk4x0xlcYPNNmpGmdMlFBmrt2+6I67vFC0Ro5nmOEiTchCLVkFkOU1Oj1tO40w732PMgARYTKexHhpu6RAQsJQkVceRTFuKg6uf+Air+Dcw7TAnbU1h9TJ9O7aqZxDnI+7G/Gkz4x4xra9iWEPr45QnR6A7RBwWfnUN3eWUvv/aW6UA14naT9VnYGYq9qJ0PjT6I3QOqF6P7/fdvMN2aGX2Au9u7F+Wh1T6ovg+tXri99deH2j/1HsXd6elHkL8IvFz+DWl9ngvVDwAA


name: Extract Details from Receipts via Telegram with Tesseract and Llama
author_name: Khairul Muhtadin
author_username: khmuhtadin
categories: []
created_at: 2025-05-24T14:19:39.715Z
updated_at: 2025-05-24T14:19:39.715Z
url: https://n8n.io/workflows/4361
scraped_at: 2025-12-24 13:02:44
description:
  Tesseract - Money Mate Workflow Description

  Disclaimer: This template requires the n8n-nodes-tesseractjs community node, which is only available on self-hosted n8n instances. You’ll need a self-hosted n8n setup to use this workflow.

  Who is this for?
  This workflow is designed for individuals, freelancers, or small business owners who want an easy way to track expenses using Telegram. It’s ideal for anyone looking to digitize receipts—whether from photos or text messages—using free tools, without needing advanced technical skills.

  What problem does this workflow solve?
  Manually entering receipt details into a spreadsheet or app is time-consuming and prone to mistakes. This workflow automates the process by extracting information from receipt images or text messages sent via Telegram, categorizing expenses, and sending back a clear, formatted summary. It saves time, reduces errors, and makes expense tracking effortless.

  What this workflow does
  The workflow listens for messages sent to a Telegram bot, which can be either text descriptions of expenses or photos of receipts. If a photo is sent, Tesseract (an open-source text recognition tool) extracts the text. If text is sent, it’s processed directly. An AI model (LLaMA via OpenRouter) analyzes the input, categorizes it into expense types (e.g., Food & Beverages, Household, Transport), and creates a structured summary including store name, date, items, total, and category. The summary is then sent back to the user’s Telegram chat.

  Setup Instructions
  Follow these step-by-step instructions to set up the workflow. No advanced technical knowledge is required, but you’ll need a self-hosted n8n instance.

  Set Up a Self-Hosted n8n Instance:
     If you don’t have n8n installed, follow the n8n self-hosting guide to set it up. You can use platforms like Docker or a cloud provider (e.g., DigitalOcean, AWS).
     Ensure your n8n instance is running and accessible via a web browser.

  Install the Tesseract Community Node:
     In your n8n instance, go to Settings &gt; Community Nodes in the sidebar.
     Click Install a Community Node, then enter n8n-nodes-tesseractjs in the search bar.
     Click Install and wait for confirmation. This node enables receipt image processing.
     If you encounter issues, check the n8n community nodes documentation for troubleshooting.

  Create a Telegram Bot:
     Open Telegram and search for @BotFather to start a new bot.
     Send /start to BotFather, then /newbot to create your bot.
     Follow the prompts to name your bot (e.g., “MoneyMateBot”).
     BotFather will provide a Bot Token (e.g., 23872837287:ExampleExampleExample). Copy this token.
     In n8n, go to Credentials &gt; Add Credential, select Telegram API, and paste the token. Name the credential (e.g., “MoneyMateBot”) and save.

  Set Up OpenRouter for AI Processing:
     Sign up for a free account at OpenRouter.
     In your OpenRouter dashboard, generate an API Key under the API section.
     In n8n, go to Credentials &gt; Add Credential, select OpenRouter API, and paste the API key. Name it (e.g., “OpenRouter Account”) and save.
     The free tier of OpenRouter’s LLaMA model is sufficient for this workflow.

  Import and Configure the Workflow:
     Download the workflow JSON file (provided separately or copy from the source).
     In n8n, go to Workflows &gt; Import Workflow and upload the JSON file.
     Open the imported workflow (“Tesseract - Money Mate”).
     Ensure the Telegram Trigger and Send Expense Summary nodes use the Telegram credential you created.
     Ensure the AI Analyzer node uses the OpenRouter credential.
     Save the workflow.

  Test the Workflow:
     Activate the workflow by toggling the Active switch in n8n.
     In Telegram, find your bot (e.g., @MoneyMateBot) and send /start.
     Test with a sample input (see “Example Inputs” below).
     Check the n8n workflow execution panel to ensure data flows correctly.
     If errors occur, double-check credentials and node connections.

  Activate for Continuous Use:
     Once tested, keep the workflow active in n8n.
     Your bot will now process any text or image sent to it via Telegram.

  Example Inputs/Formats
  To help the workflow process your data accurately, use clear and structured inputs. Below are examples of valid inputs:

  Text Input Example:
  Send a message to your Telegram bot like this:
  Bought coffee at Starbucks, Jalan Sudirman, yesterday. Total Rp 50,000. 2 lattes, each Rp 25,000.
  Expected Output:
  hello [Your Name]

  Ini Rekap Belanjamu
  📋 Store: Starbucks
  📍 Location: Jalan Sudirman
  📅 Date: 2025-05-26
  🛒 Items:
  Latte: Rp 25,000
  Latte: Rp 25,000
  💸 Total: Rp 50,000
  📌 Category: Food & Beverages

  Image Input Example:
  Upload a photo of a receipt to your Telegram bot. The receipt should contain:
  Store name (e.g., “Alfamart”)
  Address (e.g., “Jl. Gatot Subroto, Jakarta”)
  Date and time (e.g., “27/05/2025 14:00”)
  Items with prices (e.g., “Bread Rp 15,000”, “Milk Rp 20,000”)
  Total amount (e.g., “Total: Rp 35,000”)

  Expected Output:
  hello [Your Name]

  Ini Rekap Belanjamu
  📋 Store: Alfamart
  📍 Location: Jl. Gatot Subroto, Jakarta
  📅 Date: 2025-05-27 14:00
  🛒 Items:
  Bread: Rp 15,000
  Milk: Rp 20,000
  💸 Total: Rp 35,000
  📌 Category: Household

  Tips for Images:
  Ensure the receipt is well-lit and text is readable.
  Avoid blurry or angled photos for better Tesseract accuracy.

  How to Customize This Workflow
  Change Expense Categories: In the **AI Categorizer node, edit the prompt to include custom categories (e.g., add “Entertainment” or “Utilities” to the list: Food & Beverages, Household, Transport).
  Modify Response Format: In the **Format Summary Message node, adjust the JavaScript code to change how the summary looks (e.g., add emojis, reorder fields).
  Save to a Database: Add a node (e.g., Google Sheets or PostgreSQL) after the **Format Summary Message node to store summaries.
  Support Other Languages: In the **AI Categorizer node, update the prompt to handle additional languages (e.g., Spanish, Mandarin) by specifying them in the instructions.
  Add Error Handling: Enhance the **Check Invalid Input node to catch more edge cases, like invalid dates.

  All Free, End-to-End
  This workflow is 100% free! It leverages:
  Telegram Bot API**: Free via BotFather.
  Tesseract**: Open-source text recognition.
  LLaMA via OpenRouter**: Free tier available for AI processing.

  Enjoy automating your expense tracking without any cost!

  Made by: khmuhtadin
  Need a custom? contact me on LinkedIn or Web

nodes_used:
  ["n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.telegramTrigger","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-tesseractjs.tesseractNode","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5960 characters]


name: Generate and Publish SEO-Optimized Blog Posts to WordPress
author_name: Khairul Muhtadin
author_username: khmuhtadin
categories: []
created_at: 2025-05-24T15:15:09.681Z
updated_at: 2025-05-24T15:15:09.681Z
url: https://n8n.io/workflows/4362
scraped_at: 2025-12-24 13:02:45
description:
  BlogBlitz is a powerful n8n workflow that automates the creation and publishing of SEO-optimized blog posts to WordPress, saving you hours of manual content creation. Triggered on a schedule or via Telegram, it generates high-quality, 1,500–2,500-word articles complete with titles, slugs, meta descriptions, images, and more.

  🎯 Who is this for?

  Bloggers** who want fresh, consistent content.
  Content marketers** aiming for SEO efficiency.
  WordPress site owners** looking to automate blog publishing without sacrificing quality.

  🚨 Problem Solved

  Manually creating engaging, SEO-friendly content is time-consuming and requires writing expertise. BlogBlitz solves this by:

  Automating ideation, writing, formatting, and publishing.
  Generating images and SEO elements.
  Keeping your blog active and visible to search engines.

  ⚙️ What This Workflow Does

  | Feature               | Description                                                                                                                             |
  | --------------------- | --------------------------------------------------------------------------------------------------------------------------------------- |
  | Triggers          | - Runs every 3 hours via Schedule Trigger- Or on-demand via Telegram command: /generate                                   |
  | Generates Content | Uses OpenRouter to: - Select a category (Technology, AI, etc.)- Create a title, slug, focus keyphrase, and meta description |
  | Writes Articles   | OpenAI generates 1,500–2,500-word articles:- SEO-optimized- Structured with headings- Includes CTA                      |
  | Adds Visuals      | Generates realistic featured images with OpenAI and uploads them to WordPress                                                       |
  | SEO Features      | Generates:- Optimized slug- Focus keyphrase- Meta description                                                               |
  | Publishes         | Posts directly to WordPress:- With correct category- Featured image- Author ID                                          |
  | Notifies          | Sends publish alerts via Discord webhook and Telegram message                                                                   |

  🚀 Setup Instructions

  ✅ Requirements

  Self-hosted or cloud n8n instance
  Stable internet connection

  🔐 Credentials Needed

  WordPress API** (wp-json/wp/v2)
  OpenAI API** (text + image generation)
  OpenRouter API** (category & title generation)
  Telegram Bot API**
  Discord Webhook**

  🔧 WordPress Configuration

  Set up post categories:

    Technology [ID:3]
    AI [ID:4]
    Tech Fact [ID:7]
    Tech History [ID:8]
    Tech Tips [ID:9]
  Use admin user ID for publishing (default: 1)

  🧩 Node Setup

  Telegram Trigger** — Initiates workflow with /generate
  Schedule Trigger** — Runs workflow every 3 hours
  Edit Fields Node** — Centralizes variable setup (e.g., category IDs)
  OpenRouter Node** — Generates topic and meta info
  OpenAI Node** — Generates full article and image
  WordPress Node** — Publishes post
  Discord Node** — Sends publish alert
  HTTP Request Node** — Handles image upload or utility calls

  🛠️ Customization Tips

  | Feature           | How to Customize                                     |
  | ----------------- | ---------------------------------------------------- |
  | Categories    | Update category IDs in the WordPress Post Draft node |
  | Schedule      | Modify the interval in the Schedule Trigger      |
  | Tone & Style  | Adjust prompts in the LLM Chain node             |
  | Notifications | Add Slack, Email, or other channels                  |
  | Image Style   | Change OpenAI prompt for “vivid”, “natural”, etc.    |

  📦 Pre-Requirements

  n8n Instance** (Cloud/Self-hosted)
  Install: @n8n/n8n-nodes-langchain
  All required API credentials configured
  WordPress categories set
  Admin user ID available

  🔧 Nodes Used

  Telegram Trigger
  Schedule Trigger
  OpenRouter
  OpenAI
  WordPress
  Discord
  HTTP Request

  ✅ Test the Workflow

  Deploy and connect your n8n instance.
  Send /generate to your Telegram bot.
  Check your WordPress site for the newly published post!
  Made by: Khaisa Studio  
  Tag: youtube, summarizer, telegram, openai  
  Category: AI Automation, Video Tools
  Need a custom? contact me on LinkedIn or Web

nodes_used:
  ["@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.telegramTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.discord","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wordpress","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.telegram"]

workflow_json_compressed:
  H4sIAAAAAAAAE61XzXIbxxF+lS2c5CqMPP87w1MkypGVkkyVScdVTqlS89MDbHGxiywWlFgqPkPOySW++RXyPHkB+xHSC4rEElwASycHgiBrpvvr7q+7v/k8KeLkZFL+9IZ/uqzevp9/+4Oe/fRyMp0soHWTk8+Tolq1rgrwpjsXuFY0tyJpKallMRiavKU0gRZSGhdZkj7PJaUmgtXUUC2jzrmVyQiaB7TbwmJZuhZOG4irc2jXy9Ma/wMtoIO2WcPNdFK5BaC382/OstQUUMXyOiPZj3UTlw2sVtmyXrXZDCpoXFs3nVE3W01O/vIBr9YRuq+fbwNzOVAvUk5ybzSRYCXxKijCqAzecicET5N7hxf1sgjZ6byuV9BkrorZRdGWkL1zl7Bxc73sjv2hMtXX+EM2zkjpqlmYu6J6vvl8Wy7wKEIs2qKuEIrgdErwA9EtXYOeWmgQ4uebW4N/xr82B9lzfTP9gltCUlxJSZhSnkhmObEJBOFSKCqCwHRCDzeUMEPL2UVTzGZ9qFuU3q3gefvl4PZcDydhpgNqOqAfwWMWLjdFd9Zrm8dAlJeAWEwg6D0SJa3WAXJwQk6OxsbvY1OGgTBSEReoIcgPi994TkJOeUjAnFV2G9t//vmPX//992zDlOz1uoiwN7pVW4TL6+/qFnYCk1iBx/mfhLpqoWrR0OQR3nu0LNcmeeaIiI4jWqGJ07kjYLg3oBjzlG7R/vavX37Ozq6guSrgY8fZuWuzi3mx6th7mcr6Y/aqRoI+OYRNbbT5nUFwmzDNlBJshYBtkByW0CdiBbc5FzZIrrZBnM4hXGahXiy6FkhNvcjuiLMXeJEeAr5n0kFa8B4tQrIQqQUkg2MEueWJ8QK5wbilyTLufa9Vz8Mc4rqEmL1Yt/Ud8bNn32DurzORfVuvm9VXbH+iv9wf7oQu2UyO6NgtfCZdEIDEUDjpiEzIE2sCEJx+gUnJg3dmCx8rXKTr7FWxCjjVMhwcVQXlXrTx9txDlGzDCb7brjnniglviXEUa+0xmZ4CYHsxHpHK1CV9rF23YWlhnGLgSISYiMyFJAYYJ4GlQGOufW7lNqwXbevCPPsjuHbdQPZm4WaQYXne48DeG9y8bZffw9/WsDnTC9BKOtVHiyB7RXBG00C1It0ywo+kkecRi+ByYZGPIRdsi/aHZVm7uEV5v2CeDhVX3vQ43ftQk/IuAU9Id4kTnoMiNnBBFNWecsbwd2+u4LbEnZn9+D571bjUbhK6n9wfe4H0F9EokNupIZzWTIlueSYc1IkiRIPTOnBs1CSTxK3Qq/3bi5PsHaqG6FqXvb7bztmz17AoqqLfi3sXaLk4xYF5toTq+3rd7rZlh5+wEYu0F4EXXhhPqMYFIx2uUScCJ7nKcx2isTqEbQTvXbOC7GVZz7Zx/On87LsxyBHuct1uLDTnKGNC1wA7DavoSPw9mljHfDScEVAK+w95TTz2NHGG5zhtaM5lL4IXDe4PFCy97Luy/epJmX9RPERtxma9j9oqxY31ROQG886EI7hnZDeNgpbKemTVMdR8POzXdT0r4ZZnOzOSjs35dg+BFCwZ2TEFWU9xhqPEFURHjZTPbUxgDmD/n1muzZNZLlPwAUWu68YzCvBIrETKUJGzpHQErnp9+gUp3E3puwH4bFP8N2OyXg/QRI0bLs/NVgcqLXmucFlKTK802hDHNSYaqPFJJ++pGoB9l/GXdbz+3Zpcy6drcmOpMgCoxPF9g2kWnJiQJInMqdxqR6nwjzb8xTHh1FNWu7udP9rt3AbK8EFFhPIIgWO5LY8RdzsqvOB1QjU+RoqjWRfa4grxJFeuYDpZQdsW1WwjKeEThHUH5KyJyM6TyRXrtOXVrYVbkcECd6ApigyOQIIXxEFC2YYPQUExLTR1TYLitILQmdoYfvROwf8tsDwYMD7YuqSMVZ+bW1N8nEb4NDmhNx8+IMDHvYj2XfHXjgxrpPg7dFA+8HWEVI/u7nocXstDUY3vusHQhoEOpu+wUhi0vkeN9swP5/duTu9J8+bS/qV6e6u/OB8EMvIxvmtiN7b9Im8oe+ME7GASD/F2yNXI+IaZfgjmkLNj741dL9Pdm4/n2CCww0EdbIzhFjzcDfuaacjRCLU/nOujuvbYlBnP5MPTZuyb9//Ltpub/wLDEC3DJRQAAA==


name: 🤖💬 Conversational AI Chatbot with Google Gemini for Text & Image | Telegram
author_name: Alan Bajaña Granizo
author_username: thecrawlerzero
categories: []
created_at: 2025-05-24T20:40:13.992Z
updated_at: 2025-05-24T20:40:13.992Z
url: https://n8n.io/workflows/4365
scraped_at: 2025-12-24 13:02:41
description:
  🤖💬 Conversational AI Chatbot with Google Gemini for Text & Image | Telegram

  Overview 📋  
  Flexible and scalable chatbot template, designed mainly for Spanish conversations but capable of handling English and other languages. Integrates Google Gemini API for text and image generation, and Telegram for messaging. Supports multiple output types with potential for video, audio, and more.

  How It Works

  Modular Architecture & Extensibility ⚙️  
  Separate modules for data extraction, intent analysis, and adaptive response generation.  
  Easily extendable with additional tools, databases, or APIs.  

  Context & Memory Handling 🧠  
  Session-based volatile memory maintains conversation coherence.  
  Allows updates or modifications to previous images based on new requests (e.g., add a hat to a dog 🐶).  

  Intent Detection & Classification 🔍  
  Google Gemini accurately classifies user intent.  
  Two-step validation ensures context-aware, precise replies.

  Content Generation & Output ✍️🖼️  
  Generates text and images based on intent and context.  
  Designed for Telegram but adaptable to other platforms and media types (audio, video).

  Key Benefits ✅  
  Scalable, customizable, and production-ready architecture.  
  Supports multiple content formats: text, images, audio, and video.  
  Dynamic context and memory management for smooth, coherent conversations.  
  Native integration with Google Gemini and Telegram ensures reliable and seamless operation.  
  Suitable for diverse use cases and easy to extend with new tools or platforms.

  Use Cases 💼  
  Customer support virtual assistants.  
  On-demand multimedia content creation.  
  Marketing and user engagement bots.  
  AI conversational prototypes and pilots.

  Requirements 👨‍💻  
  n8n instance (self-hosted or cloud)  
  Google Gemini API credentials  
  Telegram bot setup (optional but recommended)

  Active member of the Polytechnic Artificial Intelligence Club (CIAP) at ESPOL.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.switch","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.memoryManager","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.telegramTrigger","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.set","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, 9952 characters]


name: Automate Email & Calendar Management with Gmail, Google Calendar & GPT-4o AI
author_name: AOE Agent Lab
author_username: aoepeople
categories: []
created_at: 2025-05-24T22:05:58.327Z
updated_at: 2025-05-24T22:05:58.327Z
url: https://n8n.io/workflows/4366
scraped_at: 2025-12-24 13:02:41
description:
  Boost your productivity with this AI-powered email and calendar assistant:

  This AI-powered template has 2 workflows. It manages your Gmail inbox and Google Calendar, classifies emails with custom labels, and suggests replies and meeting times — all fully automated with OpenAI and n8n.


  Automatically analyze your Gmail inbox

  Suggest replies, priorities, and meeting times

  Checks your Google Calendar for conflicts and free slots

  Maintain conversation context using Thread History Vector Store

  The agent proactively acts using a Tools Agent architecture, with integrated memory and real-time tool invocation. It's perfect for busy professionals who want a personal assistant for communication and scheduling.

  Included features:

  ✅ Do actions on incoming mails 8like Labeling etc)
  ✅ Summarize and Assist fot the latest emails
  ✅ Draft replies and schedule meetings contextually
  ✅ Handle time zone conversion and MessageID referencing
  ✅ Context retention of last conversation history - using VectorStore

  📦 Requirements:

  Gmail + Google Calendar credentials via n8n credentials

  OpenAI API key

  n8n VectorStore nodes (or external integration like Pinecone, Qdrant, or Chroma)

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.noOp","n8n-nodes-base.gmailTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.gmail","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterTokenSplitter","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.stickyNote","n8n-nodes-base.gmailTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.toolVectorStore","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.textClassifier","@n8n/n8n-nodes-langchain.vectorStoreInMemory","@n8n/n8n-nodes-langchain.vectorStoreInMemory","@n8n/n8n-nodes-langchain.vectorStoreInMemory","n8n-nodes-base.stickyNote","n8n-nodes-base.dateTimeTool"]

workflow_json_compressed:
  [encoded data, 8280 characters]


name: AI Real Estate Agent: End-to-End Ops Automation (Web, Data, Voice)
author_name: Sam Yassine
author_username: samyassine
categories: []
created_at: 2025-05-25T01:59:42.452Z
updated_at: 2025-05-25T01:59:42.452Z
url: https://n8n.io/workflows/4368
scraped_at: 2025-12-24 13:02:42
description:
  This suite automates distinct aspects of real estate operations: incoming web lead qualification, scheduled/manual data research and content generation, and automated voice call outreach with lead qualification. It leverages AI (primarily OpenAI GPT-4o Mini via Langchain), data processing nodes, and integrations with external APIs and Google Workspace.

  Workflow 1: Incoming Web Lead Qualification & Scoring
  This workflow captures leads from a web source, validates their input, uses AI to classify intent and urgency, checks against a property database, scores the lead, and prepares a structured lead object.

  Tools & Services Used:

  AI Core & Processing: OpenAI (GPT-4o Mini via Langchain Agent and Chat Model nodes)
  Data Processing: n8n Set, If, Code nodes
  External API: HTTP Request node (for PropertyCheckAPI)
  Workflow Overview:
  Trigger:
  Incoming Web Lead Webhook (/incoming-lead): Captures new leads submitted via a web form.
  Lead Data Ingestion & Validation:
  Set & Rename Incoming Lead Fields: Standardizes input field names from the webhook.
  IF User Message Valid: Checks if the userMessage field is present and meets a minimum length.
  Clean User Message Text (Code): Pre-processes the user's message (e.g., removes extra spaces).
  AI-Powered Lead Analysis:
  AI Classify Lead Intent & Urgency (Langchain Agent): Analyzes the cleaned user message to determine the lead's primary intent (e.g., buying, selling, inquiry) and the urgency of their request.
  Powered by: LLM for Lead Intent/Urgency Classification (OpenAI Chat Model - GPT-4o Mini).
  Extract Intent & Urgency from AI Output (Set): Structures the AI's classification into distinct fields.
  Data Standardization & Enrichment:
  Standardize All Lead Data Fields (Code): Further standardizes all collected data points for consistency.
  Call Property Check API (HTTP Request): Sends lead/property details to an external API (https://api.example.com/property-check) to verify listing status or gather more information.
  Lead Scoring & Finalization:
  IF Property is Known Listing: Checks the API response to see if a matchFound was "true".
  Calculate Web Lead Score (Code): If a known listing (or based on other criteria), this node assigns a numerical or categorical score to the lead.
  Set Final Structured Web Lead Data (Set): Consolidates all original, processed, classified, and scored data into a final, comprehensive lead object.
  Workflow 2: Scheduled/Manual AI-Powered Data Research & Content Generation (Red Background)
  This workflow fetches data from external URLs, extracts information using AI, allows a sophisticated AI agent to perform research and generate analysis using various tools, and outputs results to Google Sheets, Google Docs, and potentially other AI processing steps.

  Tools & Services Used:
  Orchestration & Automation: n8n
  AI Core & Processing: OpenAI (GPT-4o Mini via Langchain Information Extractor, Langchain Agent, and direct OpenAI nodes)
  AI Tools: Langchain Calculator, Langchain SerpAPI
  Data Storage & Output: Google Sheets, Google Docs
  Data Input: HTTP Request node

  Workflow Overview:
  Triggers:
  Manual Trigger for Data Analysis Flow: Allows on-demand execution.
  Scheduled Trigger for Data Analysis Flow: Automates execution on a defined schedule.
  Data Ingestion & Initial Extraction:
  Fetch External Data for AI Analysis (HTTP Request): Retrieves content from a specified URL.
  AI Extract Information from Fetched Data (Langchain Information Extractor): Uses an AI model to extract structured data from the fetched content.
  Powered by: LLM for Data Information Extractor (OpenAI Chat Model - GPT-4o Mini).
  Advanced AI Analysis & Tasking:
  AI Agent for Research & Content Generation (Langchain Agent): Processes the extracted information to perform in-depth research, analysis, or content creation.
  Powered by: LLM for Research & Content AI Agent (OpenAI Chat Model - GPT-4o Mini).
  Utilizes Tools:
  Calculator Tool for AI Agent: For numerical calculations.
  SerpAPI Web Search Tool for AI Agent: For performing real-time web searches to gather additional context or verify information.
  Output & Dissemination:
  The AI Agent's output is routed to multiple destinations:
  Update Google Doc with AI Agent Analysis (Google Docs): Inserts the generated analysis/content into a Google Document.
  Split AI Agent Output Items (Split Out) -&gt; Log AI Analysis Data to Google Sheets (Google Sheets): If the agent produces multiple data items, they are split and logged individually into a Google Sheet.
  OpenAI: Generate Text from Agent (Output 1) & OpenAI: Generate Text from Agent (Output 2): These nodes likely take the agent's output for further specialized AI processing (e.g., summarization for different purposes, reformatting).
  Workflow 3: Automated Lead Outreach & Voice Call Qualification (Green Background)
  This workflow automates the initial contact with new leads via a voice call, uses AI to understand the lead's responses during the call, qualifies them, and logs the detailed interaction and a summary.
  Tools & Services Used:
  Orchestration & Automation: n8n
  AI Core & Processing: OpenAI (GPT-4o Mini via Langchain Agent and Chat Model nodes)
  Voice Services: ElevenLabs (Text-to-Speech via HTTP Request), Twilio (Place Call via HTTP Request)
  Data Storage & Output: Google Sheets
  Error Handling: n8n Execute Workflow Trigger
  Workflow Overview:
  Trigger:
  Webhook for Voice Call Lead (/new-lead): Captures new leads designated for an automated voice call.
  Call Preparation & Initiation:
  Set Initial Voice Call Lead Details: Extracts basic lead info (name, phone, property ref, email) from the webhook.
  Generate Voice Call Introduction Script (Function): Creates a personalized script for the call.
  ElevenLabs: Convert Intro Script to Voice (HTTP Request): Sends the script to ElevenLabs API to generate natural-sounding audio.
  Twilio: Initiate Voice Call to Lead (HTTP Request): Uses Twilio API to place the call and play the generated audio.
  AI-Powered Call Interaction Analysis:
  AI Agent: Extract Info from Voice Call (Langchain Agent): Processes the interaction from the call (e.g., a transcript of the lead's responses, or DTMF inputs if designed to capture them) to extract key qualification data like budget, timeline, and interest level.
  Powered by: LLM for Voice Call Info Extraction Agent (OpenAI Chat Model - GPT-4o Mini).
  Structure Extracted Voice Call Info (Function): Organizes the AI-extracted data into a structured JSON object.
  Lead Qualification & Data Logging:
  Set Lead Status Based on Call Interest: Updates the lead's status (e.g., "Interested" or "Not Interested") based on the AI's interpretation of the call.
  IF Lead Interested (from Voice Call): Branches the workflow based on lead status.
  If Interested:
  Assign Score to Interested Voice Lead (Function): Calculates a lead score based on budget, timeline, etc.
  Format Current Timestamp for Logging (DateTime): Generates a timestamp.
  Log Qualified Voice Lead to Google Sheets: Appends the detailed, qualified lead information to a 'Leads' Google Sheet.
  AI Agent: Generate Voice Call Lead Summary (Langchain Agent): Creates a concise summary of the entire lead interaction and qualification.
  Powered by: LLM for Voice Call Lead Summary Agent (OpenAI Chat Model - GPT-4o Mini).
  Log Voice Call Lead Summary to Google Sheets: Appends this summary to a separate 'LeadsSummary' Google Sheet.
  Error Handling (for Sheets Logging):
  IF Voice Lead Logging to Sheets Failed: Checks if the Google Sheets logging operation was unsuccessful.
  Error Trigger: Notify Admin of Sheets Failure (Execute Workflow Trigger): If logging fails, triggers a separate workflow to alert an administrator.

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.manualTrigger","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.informationExtractor","n8n-nodes-base.splitOut","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.toolSerpApi","n8n-nodes-base.googleDocs","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.function","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.function","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.function","n8n-nodes-base.dateTime","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE6Va23IbxxH9FRSekiqOPPeLnqKSJYeJbKosWn5wqVJz6SE3ArEIsNDFKlX5M5Lf85ekB4SIJTELYKUXCSAGPWd7uk+f7sGnaZOmj6cf1UWjFtdOvfvhH0/XF+vp2fQGOj99/GnazFedn0c4L+tUgKAZjSwln2kAxkDqnCyUt8C1UppGJzLTwmaL/yTtrTc+ZSmzMoB2O7hZzHwHT5eQVq+gWy+etvgX6AA36JZr+Hw2nfsbwN2enE9+Bj+bPEMEHUyeXMG8ezx5Nk+kawn+N7lYrCZP1l1747umnU/+8iuEs8n3vvNnk9dtE+GvZT9/tZo+/u0NWm0TlJefbp/ZSp1ypJFQoTORVEoSAuUkemWtYlYKW/BusZzPY3vTzK9egE+4zXXbvi3GPy7Kh3M7JxvrJPgVPHp/9/miXTUFGu5KLD0jjFIEsv1841GWffbcaWKspkRGpwi6UpJkhOYpM3ScKYb8EnF0sMQH+PT5duPX+G5jm30+2z4TRC6y95HYIB2RQmniXQzEOKmcNFQFm3bP9DOUF+fzxbp73sAsrQafaAXd/adh/O5pToTmk40yobsBtMIHDYl4FiJJEiS4TLkQYgfttZ81CQ/9R1it/BU8+9CsumF4Tb6PToxGl7kWgnFNBAQ8BoVxEIQDwoT2TFCnhWQ7dE9n4Oe/rGB5CR+6QVQRX97HpUbjks4GH7wkLKe8PdCULYlRW+V0Zp7ZPi6/WjX54/m8w1T5ZYkJEz/u8P0NAX63Aznz86t47Zv5I18y6z5UMxqqzYw5DGBiMYOIzEISZy1D5J56aaUNtBd7zz50Sx+7LeImbjJ4RPwhtJH4kkkaslSEKYxC6YTHTIuGcBN0sMLp6HuufIWkl/wyNb/DkdzYP2YMmLHgkFIFAqGEx2SIDJITL4wmWrnETaIy6x4ZvVy2C1h2H59eQ3z75OX5ILbrrlv8DP9Zw+qh/6QdCxG8Zi6pRCTzGIo8AHFJMuQ1ZkREV0rVS+Dz1T/n7fv5C8xbZM2TM5dpPfpcnUvMYU74ICzi0h55nCFMLQ3mCHU0616K+Flcl/pTiPxVbJcw5mDtaHTUcM8yMl6WyCkSGRgPljESRRaJSWVy6GUFFkWE9grLYOzWWCALyIvwb4jDLLOXGnx8akCy2qWMCUEBXUg1EIu0TEBlm5QVwWWzA3mxgDmW5qfXvpv8iEBmJzDM7KYs33yz2ScafRzrI36H1gmszZFSErQLyNXWEIvag0QGyEHSsWx7aH+9hvkkzpr4FuNw8ucf/73EZJi8b5dv86x9/+cf/xv07I2fr/3sctlcXcHyQTHHOHByDDkKgf4FRhLVWJgtd8QZ6ojGmA2WeQUy9MgnXkNaz2Cy23zg8LcL6yAxxRk7AWXPtwmCFMwwAhn/kcYJrNKojJgKWHu4ZsL0fPv3y8uXkx2/jOQgUZzIj8KT/aPHVGKaZiIw4zFQjSBYmhMp4oFJRrFm575my+1yqw239aZdnhCsze57/a/1oGtMMTuKpKIKPjtHTPDoVyh+NTwSwb1IPKM2Sz2SerWYNd3kYn0g68uK2wV9flKIS43BxWICn4UiUVGkzMg0CYXei3xHge+V47IvGHdqvMjsQXhXbXs1g1fXABvVdo9CT4MoH6k7kBoLoJc6kGwZnrrHUw9JOKKipDQwAMg9DkVqerLVM1+hexjlpx3tI3eHL0gIimK1diGh8jEobV3kgLXcxiR4xnYIDtAn+yb+dCXL6fE0upflOVGepSc0So31HFGHYDyJkjvDhEvR9tLoS8k8KXe6tp3d+8JD0XYS1p3+ZQESUEEo5xif3nNiHb41VkQXE9PZxF7ewHJxTw4dhLlZvXjgTsb5WIwcEmMRq5ASCrldoiOt8oaA1TwLLPDOqB3GHzapMfm+jcOS8jZ9tkse5rc5Hpy8pyuxb8AukiQVMTQZ6sqABIrNDQotCBndt1fZT3BfWwlEtI18fkrm2F1TKLxA+Yg9AwN0ncYcDwILj1fYPnBNXU7iIbxT0mUQHztFF/UAquSpc8oTTg02DdliU6MhEspsdJKZyHM8kNr826TRqenyqH/gPjJnFXqUlglANqS0iUQZhbJJR/Ro7idMNykac/LaLxsfZjBiBIDe5HxUnggQMoIgVqTSY+OrAKV4uzIywk+58L08gTksS6HBZnbZTraDgEF4eT2P2xayj3E0SI1KxzIeCH4LxaXQCNIy7BKFFIARlCH1QD6bwTuYv/BhNSGTO8Sb2dN4PSTHg80GQGRJkjDIjtxZYjW+pTqFIJA2UXPuwF6+b2ZNi0BfznyECbL0bDxIPR6kL4M2AcQgSZYRRiQBWzKCctjYRK1SqkdBX6o3wtxqr9sALVru6yq6HY3YJuMZVZIYjAWCDUVAt2LmUwdAJU8p0H7RwToHX8BCSaXZ+kAe1QOVISmPRGmcLcMpTbgpflUqI22iiPMGy6LKgH1nTxX9VBTtrPkdJmVudVi97U9bxGh0PvmQrXWE+4jEmYomSqgznM8AOijvXH+6+vzLKaNhjDlIp08M1PiIFFTa0uRgacQcB4VsaTDRBcajcIyCVj3R+2S1aq7mt/gODwwGjtaMdl6CiHqCYq1RojiPIwlFCETQGJnB4hj6JP5806xMLpsb9Jy/WQziKwPVsuoBPjcaH4SoPXIh8cKVWS5STogxEJcltb44MdE9xXPbDWBev2ivNt78iu6BY/swNpm1i0Z6Srw1mw4H1VnGXOHJKgHY5Bhjq/Rze+Drmxu//MoZKh/P6JxLk1M0BHsKg0mNmW0pkhBFj3NU7SnHcNize4hPd25pzUZyENc+lgGM8BIDVWFdd6URCk7mmDSAYz2m3N6bINCf4P3Gv2wQZv0OpXf8/UsUpWII2P8TyBr7GQ3IMxws0R7Vk5Y5pw2hnJp91oUcsyUGWQIfypV2LqFOAezTnVcMFxzQfOKbNB8X5RHlKSp1J/qww9DBemQJjm2x5DYSDx49IZxDIhbURX8AsfwmxFYWwCPHTF5aHmQmFFUAEhz1xEuK52cdqgEHCj/rV9gmvv04+anthrl3tVmzXdIPmZKDGBJ78Kax3dySoKnpAfZA3ccVcgYPBWiIGbcrZIJdXrDOGt+/teoBHY7sg0il/UqgIjB0m88EIxdrmsfwDaVbZqA5UOqFDrQKlH8dUKbGIsXVKJCad7hT9rMVnE1RZ5TLgc1X4QPEddngYplgiRbesWLj3e33N1lOLUP1oDG2feR4FkYQn7H+KGY4VSZSlQo3Iog5bOrwxvCXmQC+9M2/St+Pj/Dbp81tcHVa9GXV2bSZJ/gwfUw/v3mDUO5WoqUbTIl7Zqpd/WZVz8zZ3fLKgG948cOu/NhKNrx08yC7zWtPMjzjqxrrzXq+2cN9J/agbT67N2qu4T4y7K2Dv3ePW7N65Ea1avXB1VfV7IFbqKrNPY13IAgPCK2q7b3bxKp7B+7z6hH28P6iZrF+eVC1ty/BawaHdXDV6P411m0Al5q3RjW3/dvpwbD33Yc77v/eovYYR376UHf43m11zfLwtfHB1O4FaTWWT7izrOfJftNXs3+g/zrtXNnRg61S1OGzrIz6ju1yhKHGbylOfrDBdmb8pnLMpgdGOEd3rswmq6R3ZE5YD73Kr7nqxXDwF1JVu7UpS5VND8w7qoZrs7tqspzk++oWte6stsWhmfFAla3RZs30kR8FVa3Xv1MFPvyTnoEgqeXrIa8fMVhn9rrsqP7ArGp1IAGq/j1lXD1QYKpDztomByeN9fI+wFKnapw9Vqv7aUgdHcmjOnHWY/GAf2u7HJzIH3PVfn7Xg/7wdLpOBUd/M/NNgu7z5/8Dz++wnHcsAAA=


name: Convert Venmo Statement CSV File to QuickBooks CSV Import
author_name: Jason Plaisted
author_username: jplaisted
categories: []
created_at: 2025-05-25T02:07:11.856Z
updated_at: 2025-05-25T02:07:11.856Z
url: https://n8n.io/workflows/4369
scraped_at: 2025-12-24 13:02:45
description:
  🧾 Say goodbye to manual Venmo-to-QuickBooks formatting!
  This automated workflow transforms raw Venmo CSV exports into QuickBooks-ready files and backs them up seamlessly to Google Drive or Dropbox.

  ⚙️ What This Workflow Does:

  📤 1. Accepts a Venmo CSV Upload
  — Triggers on form submission to upload a .csv Venmo transaction file.

  📂 2. Extracts Raw CSV Data
  — Reads the uploaded file and prepares it for processing.

  🛠️ 3. Generates a Smart File Name
  — Dynamically names the output file using the transaction month and timestamp:
  QB_Venmo_YYYY-MM_HHMM.csv.

  🔄 4. Converts Raw Venmo Data
  — Filters invalid rows and transforms valid transactions into QuickBooks-friendly format:
   • Standardizes field names (e.g., Amount (total) → Amount)
   • Builds descriptive transaction summaries based on context (e.g., transfers vs payments)

  📝 5. Creates a New CSV File
  — Structures the processed data into a new downloadable CSV.

  ☁️ 6. Saves to Google Drive
  — Automatically uploads the finalized file to your selected folder in Google Drive.

  📦 7. (Optional) Backs Up to Dropbox
  — Also configured to upload to Dropbox (currently disabled).

nodes_used:
  ["n8n-nodes-base.extractFromFile","n8n-nodes-base.convertToFile","n8n-nodes-base.dropbox","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.formTrigger","n8n-nodes-base.googleDrive"]

workflow_json_compressed:
  H4sIAAAAAAAAE5WVTW/bOBCG/4qgsxnwS/zwcZOm6KXBIkUuixz4MfRqa4uCJCfuGv7vS0qNYyeKt71J4vDlM69mhvuy9uWy/Hy7xv8+a/uwu2//qVxbLsoNDKZc7su66QfTOPiS44jgmHCrnLG6koxpzAkHHXAldaBcCs8xUBzAcYmNNthi6pTFgI3AjqukO8CmXZsBrjvw/T0M2/Y6pi8wQDpg6LZwWJSN2UA67To2T9ANxQM0m1hc3z8Ut/UaiiEWf25r993G+L0vbrrY2rjLymbVl8u/HtP+6CE/7qfsHFRCG+qQSzSIayKRcdSgSgoaKiMrT1h5PPXTbuiMG4rQxc14YJb+0ealRjVo1EbW9HAFU+RtCvwZ18a+HurYpLMZxQucWFrTJd0BugS0P0xSD+ltjCKL0qyfzY/+bju02+HGZM8nE36yEyatqYChoLlE3BCKTKUdClSJIEgQmJ2wvziWLLpI7qa4b/E9t1bz3E0coP/S3K7jc7kMZt3D21yuyJHacYcrazHyVjHEeaWRohqQMUQwwI55HF6pT37hLK0/rvu6N3b9Uiln3IR/YPgZ+LTtnPtIrSXhmGqDrAWS6kQl4OAI8pQGzggWWulX6s/QQJcKeSrKr/njx3b7Ny5X/Beqgx7JAqMCc2eRIEQgTiRHxkqHbAhBEUWkN+R9FUx9k9vlj99Ak+K30Khk2npWIa8zmgGHtDISeV4pSwgTHvgr2l1ThNhtin5rN3U/an1EluO+dfVqBd05IMET4DPYv9MIGAeT0cIwawVyMv86qiRSSmvkZWogo63Q2Jf/l9PVieEg0kTTFPnccVxJlWpXB2RkwMxWXIdKnZRCjKtUAzdd/fRxEazGoJeY03wo/gXH2SFFpGmTt7/0Xw/DUDd56u1L2IHbZsW7zifHluUTKZPG07R/NKnCVtLAGNKc2JQU5yi1p0CpgHRFwDnqMloaDg24LDUKnyWX3jemztRpuObk5tp3jFikm8PDrlziw+NjAnk7muaU5n2clXs/pWcFL/TorOzMhjndix02KzxT+HPCFy6fi66eglwCfncxzKgeDv8Bij+MbhYIAAA=


name: Auto Meeting Summarizer with Google Drive, OpenAI Whisper & GPT-4 to Sheets
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T05:37:57.429Z
updated_at: 2025-05-25T05:37:57.429Z
url: https://n8n.io/workflows/4370
scraped_at: 2025-12-24 13:02:42
description:
  🎤 Audio-to-Insights: Auto Meeting Summarizer

  Transform your meeting recordings into actionable insights automatically. This powerful n8n workflow monitors your Google Drive for new audio files, transcribes them using OpenAI's Whisper, generates intelligent summaries with ChatGPT, and logs everything in Google Sheets - all without lifting a finger.

  🔄 How It Works

  This workflow operates as a seamless 6-step automation pipeline:

  Step 1: Smart Detection
  The workflow continuously monitors a designated Google Drive folder (polls every minute) for newly uploaded audio files.

  Step 2: Secure Download
  When a new audio file is detected, the system automatically downloads it from Google Drive for processing.

  Step 3: AI Transcription
  OpenAI's Whisper technology converts your audio recording into accurate text transcription, supporting multiple audio formats.

  Step 4: Intelligent Summarization
  ChatGPT processes the transcript using a specialized prompt that extracts:
  Key discussion points and decisions
  Action items with assigned persons and deadlines
  Priority levels and follow-up tasks
  Clean, professional formatting

  Step 5: Timestamp Generation
  The system automatically adds the current date and formats it consistently for tracking purposes.

  Step 6: Automated Logging
  The final summary is appended to your Google Sheets document with the date, creating a searchable archive of all meeting insights.

  ⚙️ Setup Steps

  Prerequisites
  Before setting up the workflow, ensure you have:
  Active Google Drive account
  OpenAI API key with credits
  Google Sheets access
  n8n instance (cloud or self-hosted)

  Configuration Steps

  1. Credential Setup
  Google Drive OAuth2**: Required for folder monitoring and file downloads
  OpenAI API Key**: Needed for both transcription (Whisper) and summarization (ChatGPT)
  Google Sheets OAuth2**: Essential for writing summaries to your spreadsheet

  2. Google Drive Configuration
  Create a dedicated folder in Google Drive for meeting recordings
  Copy the folder ID from the URL (the long string after /folders/)
  Update the folderToWatch parameter in the workflow

  3. Google Sheets Preparation
  Create a new Google Sheet or use an existing one
  Ensure it has columns: Date and Meeting Summary
  Copy the spreadsheet ID from the URL
  Update the documentId parameter in the workflow

  4. Audio Requirements
  Supported Formats**: MP3, WAV, M4A, MP4
  Recommended Size**: Under 100MB for optimal processing
  Language**: Optimized for English (customizable for other languages)
  Quality**: Clear audio produces better transcriptions

  5. Workflow Activation
  Import the workflow JSON into your n8n instance
  Configure all credential connections
  Test with a sample audio file
  Activate the workflow trigger

  🚀 Use Cases

  Project Management
  Team Standup Summaries**: Convert daily standups into actionable task lists
  Sprint Retrospectives**: Extract improvement points and action items
  Stakeholder Updates**: Generate concise reports for leadership

  Sales & Customer Success
  Discovery Call Notes**: Capture prospect pain points and requirements
  Demo Follow-ups**: Track questions, objections, and next steps
  Customer Check-ins**: Monitor satisfaction and expansion opportunities

  Consulting & Professional Services
  Client Strategy Sessions**: Document recommendations and implementation plans
  Requirements Gathering**: Organize complex project specifications
  Progress Reviews**: Track deliverables and milestone achievements

  HR & Training
  Interview Debriefs**: Standardize candidate evaluation notes
  Training Sessions**: Create searchable knowledge bases
  Performance Reviews**: Document development plans and goals

  Research & Development
  Brainstorming Sessions**: Capture innovative ideas and concepts
  Technical Reviews**: Log decisions and architectural choices
  User Research**: Organize feedback and insights systematically

  💡 Advanced Customization Options

  Enhanced Summarization
  Modify the ChatGPT prompt to focus on specific elements:
  Add speaker identification for multi-person meetings
  Include sentiment analysis for customer calls
  Generate department-specific summaries (technical, sales, legal)
  Extract financial figures and metrics automatically

  Integration Expansions
  Slack Integration**: Auto-post summaries to relevant channels
  Email Notifications**: Send summaries to meeting participants
  CRM Updates**: Push action items directly to Salesforce/HubSpot
  Calendar Integration**: Schedule follow-up meetings based on action items

  Quality Improvements
  Audio Preprocessing**: Add noise reduction before transcription
  Multi-language Support**: Configure for international teams
  Custom Templates**: Create industry-specific summary formats
  Approval Workflows**: Add human review before final storage

  🛠️ Troubleshooting & Best Practices

  Common Issues
  Large File Processing**: Split recordings over 100MB into smaller segments
  Poor Audio Quality**: Use noise reduction tools before uploading
  API Rate Limits**: Implement delay nodes for high-volume usage
  Formatting Issues**: Adjust ChatGPT prompts for consistent output

  Optimization Tips
  Upload files in supported formats only
  Ensure stable internet connection for cloud processing
  Monitor OpenAI API usage and costs
  Regularly backup your Google Sheets data
  Test workflow changes with sample files first

  📊 Expected Outputs

  Sample Summary Format:
  Meeting Summary - March 15, 2024

  Key Discussion Points:
  Q1 budget review and allocation decisions
  New product launch timeline and milestones
  Team restructuring and role assignments

  Action Items:
  John: Finalize budget proposal by March 20th (High Priority)
  Sarah: Schedule product demo sessions for March 25th
  Team: Submit org chart feedback by March 18th

  Decisions Made:
  Approved additional marketing budget of $50K
  Delayed product launch to April 15th for quality assurance
  Promoted Lisa to Senior Developer role

  📞 Questions & Support

  For any questions, customizations, or technical support regarding this workflow:

  📧 Email Support
  Primary Contact**: Yaron@nofluff.online
  Response Time**: Within 24 hours on business days
  Best For**: Setup questions, customization requests, troubleshooting

  🎥 Learning Resources
  YouTube Channel**: https://www.youtube.com/@YaronBeen/videos
    Step-by-step setup tutorials
    Advanced customization guides  
    Workflow optimization tips

  🔗 Professional Network
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
    Connect for ongoing support
    Share your workflow success stories
    Get updates on new automation ideas

  💡 What to Include in Your Support Request
  Describe your specific use case
  Share any error messages or logs
  Mention your n8n version and setup type
  Include sample audio file characteristics (if relevant)

  Ready to transform your meeting chaos into organized insights? Download the workflow and start automating your meeting summaries today!

nodes_used:
  ["n8n-nodes-base.googleDriveTrigger","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.dateTime","n8n-nodes-base.dateTime","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4568 characters]


name: Automate Blog Content Creation with OpenAI, Google Sheets & Email Approval Flow
author_name: Billy Christi
author_username: billy
categories: []
created_at: 2025-05-25T05:40:26.527Z
updated_at: 2025-05-25T05:40:26.527Z
url: https://n8n.io/workflows/4371
scraped_at: 2025-12-24 13:02:41
description:
  Who is this for?
  This workflow is perfect for:
  Digital marketers who need to scale SEO-optimized content production
  Bloggers and content creators who want to maintain consistent publishing schedules
  Small business owners who need regular blog content but lack writing resources

  What problem is this workflow solving?
  Creating high-quality, SEO-optimized blog content consistently is time-consuming and resource-intensive. This workflow solves that by:
  Automating the content generation process from topic to final draft
  Ensuring quality control through human-in-the-loop approval
  Managing topic queues and preventing duplicate content creation
  Streamlining the revision process based on human feedback
  Organizing and archiving all generated content for future reference

  What this workflow does
  From topics stored in Google Sheets, this workflow:
  Automatically retrieves pending topics from your Google Sheets tracking document
  Generates SEO-optimized blog posts (800-1200 words) using OpenAI GPT-4 with structured prompts
  Sends content for human approval via email with custom approval forms
  Handles revision requests by incorporating feedback while maintaining SEO best practices
  Updates topic status to prevent duplicate processing
  Add approved generated content in Google Sheets for easy access and management
  Routes workflow based on approval decisions (approve, revise, or cancel)

  Setup
  Copy the Google Sheet template here:
  👉 Automate Blog Content Creation – Google Sheet Template
  Connect Google Sheets with your topic tracking document (requires "Topic List" and "Generated Content" sheets)
  Add your OpenAI API key to the AI agent nodes for content generation
  Configure Gmail for the approval notification system
  Set up your topic list in Google Sheets with "Topic" and "Status" columns
  Customize the schedule trigger to run at your preferred intervals
  Update email recipient in the approval node to your email address
  Test with a sample topic marked as "Pending" in your Google Sheet

  How to customize this workflow to your needs
  Adjust content length**: modify the word count requirements in the AI agent prompts
  Change writing style**: customize the copywriter prompts for different tones (formal, casual, technical)
  Add multiple reviewers**: extend the approval system to include additional stakeholders
  Integrate with CMS**: add nodes to automatically publish approved content to WordPress, Webflow, or other platforms
  Include keyword research**: add Ahrefs or SEMrush nodes to incorporate keyword data
  Add image generation**: integrate DALL-E or Midjourney for automatic featured image creation
  Customize approval criteria**: modify the approval form to include specific feedback categories
  Add content scoring**: integrate readability checkers or SEO analysis tools before approval

  Contact me for consulting and support:   
  📧 billychartanto@gmail.com

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","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.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7648 characters]


name: Generate Product Ad Copy & CTAs with GPT-4 for Slack and Airtable
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T05:42:40.330Z
updated_at: 2025-05-25T05:42:40.330Z
url: https://n8n.io/workflows/4372
scraped_at: 2025-12-24 13:02:44
description:
  ⚡ AI Copywriter Pro: Instant Ad Copy & CTA Generator

  Transform product details into compelling marketing copy in seconds. This intelligent n8n workflow takes basic product information and generates professional ad copy with powerful calls-to-action using GPT-4, then distributes the results to your team via Slack or stores them in Airtable for future use.

  🚀 How It Works

  This streamlined 4-step automation delivers professional marketing copy instantly:

  Step 1: Simple Form Input
  Users submit basic product information through a clean web form - just product name and key features required.

  Step 2: AI-Powered Generation
  The workflow sends product details to GPT-4 with a specialized copywriting prompt that creates:
  Compelling 2-sentence ad copy optimized for conversions
  3 powerful call-to-action phrases with different urgency levels
  Professional tone tailored for marketing campaigns

  Step 3: Structured Processing
  The AI response is automatically parsed into clean, labeled fields ready for immediate use across marketing channels.

  Step 4: Multi-Channel Distribution
  Generated content is simultaneously:
  Posted to your designated Slack channel for team review
  Logged in Airtable for campaign tracking and reuse

  ⚙️ Setup Steps

  Prerequisites
  Active OpenAI API account with GPT-4 access
  Slack workspace with admin permissions
  Airtable account for content storage
  n8n instance (cloud or self-hosted)

  Configuration Steps

  1. Credential Setup
  OpenAI API Key**: Required for GPT-4 content generation
  Slack OAuth2**: Needed for posting messages to channels
  Airtable Personal Access Token**: Essential for database operations

  2. Form Configuration
  The workflow automatically generates a web form at: your-n8n-instance.com/form/[webhook-id]
  Form fields are pre-configured for:
    Product Name (text input)
    Product Features (textarea for detailed descriptions)
  Form can be embedded on websites or shared as standalone link

  3. Slack Integration Setup
  Connect your Slack workspace to n8n
  Create or select target channel for ad copy notifications
  Update the channelId parameter with your channel's ID
  Test connection with sample message

  4. Airtable Database Preparation
  Create new base or use existing one
  Set up table with columns:
    Product Name (Single line text)
    Product Features (Long text)
    Ad Copy (Long text)
    CTAs (Long text)
  Copy base and table IDs from Airtable URLs
  Update workflow parameters accordingly

  5. AI Prompt Customization
  The default prompt generates versatile marketing copy, but you can customize for:
  Industry-specific terminology
  Brand voice and tone
  Target audience demographics
  Campaign objectives (awareness, conversion, retention)

  🎯 Use Cases

  E-commerce & Retail
  Product Launch Campaigns**: Generate copy for new product announcements
  Seasonal Promotions**: Create urgency-driven messaging for sales events
  Category Pages**: Develop compelling descriptions for product collections
  Social Media Ads**: Produce scroll-stopping copy for Facebook and Instagram

  SaaS & Technology
  Feature Announcements**: Craft clear, benefit-focused messaging
  Free Trial Campaigns**: Generate conversion-optimized trial signup copy
  Case Study Promotions**: Create compelling success story headlines
  Webinar Marketing**: Develop registration-driving event descriptions

  Agency & Freelance
  Client Presentations**: Rapidly prototype copy concepts for pitches
  A/B Testing**: Generate multiple copy variations for campaign testing
  Campaign Brainstorming**: Kickstart creative sessions with AI-generated ideas
  Content Calendar Filling**: Populate social media schedules efficiently

  Startup & Small Business
  MVP Marketing**: Create professional copy without hiring agencies
  Investor Pitches**: Generate compelling product descriptions
  Website Content**: Populate landing pages with conversion-focused copy
  Email Campaigns**: Develop subject lines and promotional content

  Content Marketing
  Blog Post Promotions**: Generate social media copy for article shares
  Newsletter CTAs**: Create compelling subscription and engagement prompts
  Video Descriptions**: Develop YouTube and social video copy
  Podcast Promotions**: Generate episode descriptions and listener CTAs

  🔧 Advanced Customization Options

  Multi-Tone Generation
  Modify the prompt to generate different copy styles:
  Professional & Corporate: "Generate formal, trust-building copy..."
  Casual & Friendly: "Create conversational, approachable messaging..."
  Urgent & Scarcity: "Develop time-sensitive, action-driving copy..."
  Luxury & Premium: "Craft sophisticated, high-end positioning..."

  Batch Processing Enhancement
  Add nodes for processing multiple products:
  Split in Batches**: Handle bulk product lists
  Merge**: Combine results for team review
  Item Lists**: Process CSV uploads of product catalogs

  Quality Control Integration
  Implement approval workflows:
  Human Review Step**: Add manual approval before publishing
  Sentiment Analysis**: Score copy for emotional impact
  Brand Guidelines Check**: Validate against company voice standards
  A/B Test Setup**: Generate multiple variations automatically

  Extended Distribution
  Connect additional platforms:
  Email Marketing**: Send to Mailchimp, ConvertKit, or HubSpot
  Social Media**: Post directly to Facebook, Twitter, LinkedIn
  CMS Integration**: Push to WordPress, Webflow, or custom sites
  Project Management**: Create tasks in Asana, Trello, or Monday.com

  📊 Output Examples

  Sample Input:
  Product Name: EcoSmart Water Bottle
  Product Features: Self-cleaning UV technology, 24-hour temperature retention, BPA-free stainless steel, leak-proof design, 500ml capacity

  Generated Ad Copy:
  Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable.

  CTAs:
  • Order Your EcoSmart Bottle Today
  • Join the Clean Hydration Revolution  
  • Get 24-Hour Freshness Now

  Slack Notification Format:
  🎯 NEW AD COPY GENERATED

  Product: EcoSmart Water Bottle

  📝 Ad Copy:
  Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable.

  🔥 Call-to-Actions:
  • Order Your EcoSmart Bottle Today
  • Join the Clean Hydration Revolution  
  • Get 24-Hour Freshness Now

  Ready to use in campaigns! 🚀

  🛠️ Troubleshooting & Best Practices

  Common Issues & Solutions

  API Rate Limits
  Monitor OpenAI usage dashboard
  Implement delay nodes for high-volume processing
  Consider upgrading to higher tier plans

  Inconsistent Output Quality
  Refine prompts with specific examples
  Add output validation rules
  Include brand guidelines in system prompt

  Integration Failures
  Verify all API credentials are current
  Test connections individually before full workflow
  Check service status pages for outages

  Optimization Strategies

  Cost Management
  Use GPT-4o-mini for routine copy generation
  Reserve GPT-4 for premium campaigns
  Cache common responses to reduce API calls

  Quality Enhancement
  A/B test different prompt variations
  Collect team feedback on generated copy
  Maintain library of high-performing examples

  Workflow Efficiency
  Set up monitoring alerts for failures
  Create backup workflows for critical campaigns
  Document customizations for team reference

  📈 Performance Tracking

  Key Metrics to Monitor
  Generation Speed**: Average time from input to output
  Approval Rate**: Percentage of AI copy used without edits
  Campaign Performance**: Click-through rates of AI-generated content
  Cost Per Copy**: API costs per generated piece

  Success Indicators
  Reduced copywriting turnaround time (target: under 30 seconds)
  Increased campaign launch frequency
  Higher team satisfaction with copy quality
  Measurable improvement in conversion rates

  📞 Questions & Support

  Need help setting up or customizing your AI Copywriter Pro workflow?

  📧 Direct Support
  Email**: Yaron@nofluff.online
  Response Time**: Within 24 hours on business days
  Specialties**: Custom prompt engineering, integration troubleshooting, workflow optimization

  🎥 Video Tutorials
  YouTube Channel**: https://www.youtube.com/@YaronBeen/videos
    Complete setup walkthrough
    Advanced customization techniques
    Integration with popular marketing tools
    Prompt engineering masterclass

  🤝 Professional Network
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
    Connect for ongoing automation support
    Share your copywriting success stories
    Get early access to new workflow templates

  💬 What to Include in Support Requests
  Your specific industry or use case
  Current marketing tools and platforms
  Sample products you want to test with
  Any custom requirements or brand guidelines
  Screenshots of any errors or unexpected outputs

  Ready to revolutionize your copywriting process? Deploy this workflow and watch your marketing team's productivity soar while maintaining professional, conversion-focused messaging!

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.slack","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.airtable","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5224 characters]


name: Automate Reddit Trend Analysis with GPT-4 and Slack/Gmail Distribution
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T05:45:03.463Z
updated_at: 2025-05-25T05:45:03.463Z
url: https://n8n.io/workflows/4373
scraped_at: 2025-12-24 13:02:42
description:
  🤖 AI Reddit Scout Agent: Auto Post Analysis & Insights
  Stay ahead of trends and conversations with this intelligent n8n workflow that automatically monitors Reddit, analyzes discussions using AI, and delivers actionable insights to your team via Slack and Gmail. Perfect for market research, content inspiration, and competitive intelligence.
  🔄 How It Works
  This automated 4-step intelligence gathering system runs daily to keep you informed:
  Step 1: Scheduled Monitoring
  The workflow automatically triggers daily (default: 9 AM) to scan Reddit for fresh discussions and trending topics.
  Step 2: Smart Content Retrieval
  The Reddit API integration searches specified subreddits using customizable filters:

  Target subreddits (e.g., r/ChatGPT, r/technology, r/startups)
  Keyword matching for specific topics
  Post ranking criteria (hot, top, new)
  Engagement thresholds (upvotes, comments)

  Step 3: AI-Powered Analysis
  Each retrieved post is processed by GPT-4 through a specialized agent that:

  Extracts key discussion points and themes
  Classifies topics in 3-5 word categories
  Generates concise one-sentence summaries
  Identifies sentiment and engagement patterns
  Highlights actionable insights and trends

  Step 4: Multi-Channel Distribution
  Analyzed insights are automatically delivered to:

  Slack channels for immediate team visibility
  Gmail inboxes for stakeholders and decision-makers
  Formatted with links back to original Reddit discussions

  ⚙️ Setup Steps
  Prerequisites

  Reddit account (for API access)
  OpenAI API key with GPT-4 access
  Slack workspace with posting permissions
  Gmail account for email distribution
  n8n instance (cloud or self-hosted)

  Configuration Steps
  Credential Setup

  Reddit API: Configure Reddit node with API credentials
  OpenAI API Key: Required for AI analysis and summarization
  Slack OAuth2: Connect workspace for channel posting
  Gmail OAuth2: Enable email distribution functionality

  Reddit Configuration

  Subreddit Selection: Define target communities to monitor

  Professional: r/entrepreneur, r/marketing, r/sales
  Technology: r/artificial, r/MachineLearning, r/programming
  Industry-specific: r/fintech, r/biotech, r/startups


  Search Parameters: Set keywords and filters

  Keywords: "AI trends", "market analysis", "customer feedback"
  Time ranges: past day, week, or month
  Minimum engagement thresholds



  AI Analysis Customization
  Default analysis prompt can be tailored for:

  Market Research Focus: Extract business insights and opportunities
  Competitive Intelligence: Identify competitor mentions and sentiment
  Content Ideas: Find trending topics for content creation
  Customer Research: Analyze user pain points and feedback

  Distribution Setup

  Slack Integration: Choose channels for different content types

  #market-intelligence for business insights
  #content-ideas for creative inspiration
  #competitive-intel for competitor discussions


  Email Configuration: Set recipient lists and formatting preferences

  Schedule Optimization

  Frequency: Daily, weekly, or custom intervals
  Timing: Optimize for team availability and time zones
  Volume Control: Limit posts per execution to avoid overwhelm

  🚀 Use Cases
  Market Research & Intelligence

  Trend Identification: Spot emerging technologies and methodologies
  Customer Sentiment: Monitor brand mentions and user feedback
  Competitive Analysis: Track competitor discussions and reputation
  Industry Insights: Stay updated on regulatory changes and news

  Content Marketing

  Topic Discovery: Find trending subjects for blog posts and videos
  Audience Research: Understand community questions and pain points
  Content Validation: Test ideas before creating full content pieces
  Engagement Strategies: Learn what resonates with target audiences

  Product Development

  Feature Requests: Identify commonly requested functionality
  User Experience Feedback: Discover usability issues and improvements
  Market Validation: Gauge interest in new product concepts
  Beta Testing Insights: Monitor feedback on product releases

  Sales & Business Development

  Lead Generation: Find potential customers discussing relevant problems
  Objection Handling: Understand common concerns and hesitations
  Partnership Opportunities: Identify potential collaboration prospects
  Market Education: Understand knowledge gaps in your target market

  Investment & Strategy

  Startup Monitoring: Track emerging companies and funding news
  Technology Assessment: Evaluate new tools and platforms
  Risk Assessment: Monitor potential threats and challenges
  Opportunity Identification: Spot underserved markets and niches

  🔧 Advanced Customization Options
  Multi-Subreddit Orchestration
  Configure different analysis approaches:
  Technical Communities: Focus on innovation and implementation details
  Business Communities: Extract market opportunities and strategies  
  User Communities: Emphasize pain points and solution requests
  News Communities: Highlight breaking developments and reactions
  Sentiment & Engagement Scoring
  Enhance analysis with quantitative metrics:

  Sentiment Analysis: Positive, negative, neutral classification
  Engagement Prediction: Likelihood of viral content
  Influence Scoring: Identify high-authority contributors
  Trend Momentum: Track discussion growth over time

  Content Filtering & Prioritization
  Implement smart content curation:

  Quality Thresholds: Minimum upvotes, comments, or awards
  Relevance Scoring: AI-based topic matching and ranking
  Duplicate Detection: Avoid repetitive content in summaries
  Language Processing: Handle multiple languages and slang

  Extended Integration Options
  Connect additional platforms and tools:

  CRM Integration: Push leads to Salesforce, HubSpot, or Pipedrive
  Documentation Tools: Save insights to Notion, Obsidian, or Confluence
  Analytics Platforms: Feed data to Google Analytics or Mixpanel
  Social Media: Cross-post insights to Twitter, LinkedIn, or Facebook

  📊 Output Examples
  Sample Slack Message:
  🔍 Reddit Intelligence Report - r/ChatGPT

  📊 Top Discussion: "Why I stopped using ChatGPT for coding"
  📝 Topic: AI Tool Limitations & Alternatives
  📋 Summary: Users discussing ChatGPT's declining code quality and exploring alternatives like Claude and GitHub Copilot for development work.

  📈 Engagement: 847 upvotes, 234 comments
  💭 Sentiment: Mixed (concerns about accuracy, praise for alternatives)
  🔗 View Discussion: [Reddit Link]

  Key Insights:
  Growing demand for specialized coding AI tools
  Quality consistency remains a major user concern  
  Opportunity for developer-focused AI solutions

  Generated at 9:15 AM • Next scan: Tomorrow 9:00 AM
  Gmail Report Format:
  Subject: Daily Reddit Intelligence - AI & Technology Trends

  📡 REDDIT SCOUT REPORT
  Date: March 15, 2024

  🎯 TOP INSIGHTS TODAY:

  AI Development Tools (r/programming)
     Discussion: "Best AI coding assistants in 2024"
     Insight: Developers increasingly comparing specialized tools vs general AI
     Engagement: High (500+ upvotes)

  Startup Funding (r/entrepreneur)  
     Discussion: "Raised $2M seed round - lessons learned"
     Insight: Current funding landscape and investor priorities
     Engagement: Moderate (150+ upvotes)

  Customer Feedback (r/SaaS)
     Discussion: "Why our churn rate dropped 40%"
     Insight: Onboarding and support strategy impacts
     Engagement: High (300+ upvotes)

  🔗 View all discussions: [Links included]

  Powered by AI Reddit Scout Agent
  Next report: Tomorrow at 9:00 AM
  🛠️ Troubleshooting & Best Practices
  Common Issues & Solutions
  API Rate Limiting

  Implement exponential backoff delays
  Distribute requests across multiple time periods
  Cache results to minimize redundant calls
  Monitor Reddit API status and limits

  Content Quality Control

  Set minimum engagement thresholds
  Filter out low-quality or spam posts
  Implement keyword blacklists for irrelevant content
  Regular prompt tuning for better AI analysis

  Information Overwhelm

  Limit posts per subreddit per day
  Prioritize by engagement and relevance scores
  Create digest formats for high-volume periods
  Allow team members to customize their alerts

  Optimization Strategies
  Performance Enhancement

  Use parallel processing for multiple subreddits
  Implement caching for repeated analysis
  Optimize OpenAI prompt length and complexity
  Monitor and optimize workflow execution time

  Cost Management

  Balance AI analysis depth with API costs
  Use different models for different content types
  Implement smart filtering before AI analysis
  Track ROI through engagement metrics

  Team Adoption

  Start with pilot programs in specific departments
  Provide training on interpreting AI insights
  Create feedback loops for continuous improvement
  Establish clear action protocols for different insight types

  📈 Success Metrics
  Intelligence Quality Indicators

  Relevance Score: Percentage of insights that lead to action
  Timeliness: How quickly trends are identified vs competitors
  Accuracy: Validation of AI predictions against actual outcomes
  Engagement: Team interaction with distributed insights

  Business Impact Measurements

  Content Performance: Improvement in content engagement rates
  Market Timing: Success rate of trend-based decisions
  Competitive Advantage: Early identification of opportunities/threats
  Time Savings: Reduction in manual research and monitoring time

  📞 Questions & Support
  Need assistance with your AI Reddit Scout Agent setup or customization?
  📧 Technical Support

  Email: Yaron@nofluff.online
  Response Time: Within 24 hours on business days
  Expertise: Reddit API integration, AI prompt optimization, workflow scaling

  🎥 Learning Resources

  YouTube Channel: https://www.youtube.com/@YaronBeen/videos

  Complete setup and configuration guides
  Advanced filtering and analysis techniques
  Integration tutorials for popular business tools
  Troubleshooting common issues



  🤝 Professional Networking

  LinkedIn: https://www.linkedin.com/in/yaronbeen/

  Connect for ongoing automation support
  Share your intelligence gathering success stories
  Access to exclusive workflow templates and updates



  💬 Support Request Guidelines
  Include in your message:

  Target subreddits and use cases
  Current team size and distribution needs
  Specific industries or topics of interest
  Integration requirements with existing tools
  Any error messages or unexpected behaviors

nodes_used:
  ["n8n-nodes-base.reddit","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.slack","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.scheduleTrigger"]

workflow_json_compressed:
  [encoded data, 5284 characters]


name: Auto-Generate & Distribute LinkedIn Posts with GPT-4 to Profile & Groups
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T05:54:50.291Z
updated_at: 2025-05-25T05:54:50.291Z
url: https://n8n.io/workflows/4374
scraped_at: 2025-12-24 13:02:44
description:
  LinkedIn AI Agent: Auto-Post Creator & Multi-Group Distributor
  Transform simple topic ideas into engaging LinkedIn posts and automatically distribute them across your profile and multiple LinkedIn groups. This powerful n8n workflow combines AI content generation with intelligent distribution, helping you maintain a consistent professional presence while maximizing your reach across relevant communities.
  🚀 How It Works
  This sophisticated 6-step automation turns content ideas into LinkedIn success:
  Step 1: Smart Content Monitoring
  The workflow continuously monitors your Google Sheets for new post topics marked as "Pending", checking every minute for fresh content to process.
  Step 2: AI-Powered Content Generation
  GPT-4 transforms your basic topic into a professionally crafted LinkedIn post featuring:

  Compelling opening hooks that grab attention
  3-4 informative paragraphs with valuable insights
  Strategic questions to encourage engagement
  4-6 relevant hashtags for discoverability
  Professional emoji placement for visual appeal
  Optimized formatting for LinkedIn's platform

  Step 3: Professional Formatting
  The workflow ensures your content meets LinkedIn's technical requirements with proper JSON formatting, character limits, and special character handling.
  Step 4: Personal Profile Publishing
  Your generated post is automatically published to your personal LinkedIn profile, maintaining your professional brand presence.
  Step 5: Multi-Group Distribution
  The same content is intelligently distributed across all your specified LinkedIn groups, amplifying your reach to targeted professional communities.
  Step 6: Status Management
  The workflow automatically updates your Google Sheets to mark posts as "Posted", providing clear tracking of your content pipeline.
  ⚙️ Setup Steps
  Prerequisites

  Active LinkedIn account with API access
  Google Sheets access for content management
  OpenAI API key with GPT-4 access
  LinkedIn group memberships with posting permissions
  n8n instance (cloud or self-hosted)

  Required Google Sheets Structure
  Sheet 1 - Main Content:
  | ID | LinkedIn Post Title | Status |
  |----|-------------------|--------|
  | 1  | AI Trends in 2024 | Pending |
  | 2  | Remote Work Tips  | Posted  |
  Sheet 2 - Groups:
  | GroupIds     |
  |-------------|
  | 123456789   |
  | 987654321   |
  | 456789123   |
  Note: Collect LinkedIn group IDs from groups where you have posting permissions. These can be found in the group URL or through LinkedIn's API.
  Configuration Steps
  Credential Setup

  Google Sheets OAuth2: Access your content spreadsheet
  OpenAI API Key: Required for AI content generation
  LinkedIn OAuth2: Enable profile and group posting
  HTTP Authentication: Configure LinkedIn API headers

  Google Sheets Preparation

  Create spreadsheet with the required two-sheet structure
  Populate group IDs from your joined LinkedIn groups
  Add initial post topics with "Pending" status
  Ensure proper column naming and data types

  LinkedIn Group Setup

  Join relevant professional LinkedIn groups
  Verify posting permissions in each group
  Collect group IDs using LinkedIn's interface or API
  Test posting permissions before full automation

  AI Content Customization
  The default prompt generates professional LinkedIn content, but can be customized for:

  Industry-specific terminology and trends
  Company voice and brand guidelines
  Target audience preferences
  Content style (educational, promotional, thought leadership)

  Workflow Activation

  Import the workflow JSON into your n8n instance
  Configure all credential connections
  Test with sample content before going live
  Activate the Google Sheets trigger

  🎯 Use Cases
  Content Creators & Influencers

  Consistent Posting: Maintain regular LinkedIn presence without daily manual work
  Audience Growth: Reach multiple professional communities simultaneously
  Content Scaling: Transform brief ideas into full-length engaging posts
  Brand Building: Establish thought leadership across industry groups

  Marketing Teams

  Lead Generation: Share valuable content across targeted professional groups
  Brand Awareness: Increase visibility in relevant industry communities
  Thought Leadership: Position company experts as industry authorities
  Content Distribution: Maximize reach of marketing messages and insights

  Sales Professionals

  Pipeline Building: Share insights that attract potential clients
  Network Expansion: Engage with prospects across multiple professional groups
  Authority Building: Establish credibility through valuable content sharing
  Relationship Nurturing: Maintain visibility with existing connections

  Consultants & Freelancers

  Client Acquisition: Demonstrate expertise to potential clients
  Professional Branding: Build reputation across industry-specific groups
  Service Promotion: Share case studies and success stories broadly
  Network Building: Connect with peers and potential collaborators

  Business Leaders & Executives

  Industry Influence: Share strategic insights across professional networks
  Talent Attraction: Showcase company culture and opportunities
  Partnership Development: Connect with potential business partners
  Market Education: Share expertise to influence industry conversations

  🔧 Advanced Customization Options
  Content Strategy Enhancement

  Multi-Tone Generation: Create different content styles for various audiences
  Industry Templates: Pre-built prompts for specific professional sectors
  Engagement Optimization: A/B testing different post formats and styles
  Content Calendar Integration: Schedule posts for optimal timing

  Distribution Intelligence

  Group Performance Tracking: Monitor engagement across different groups
  Selective Distribution: Choose specific groups based on content type
  Audience Segmentation: Tailor content for different professional communities
  Engagement Analysis: Track which groups provide best ROI

  Content Quality Control

  Approval Workflows: Add human review before automatic posting
  Content Scoring: Rate post quality before distribution
  Brand Compliance: Ensure posts meet company guidelines
  Duplicate Detection: Avoid posting similar content too frequently

  Extended Integration Options

  CRM Integration: Track leads generated from LinkedIn posts
  Analytics Platforms: Monitor engagement and conversion metrics
  Content Management: Connect to existing content planning tools
  Social Media Expansion: Extend to other professional platforms

  📊 Content Generation Features
  AI Writing Capabilities
  The workflow generates LinkedIn posts that include:
  Professional Structure:

  Attention-grabbing opening statements
  Well-organized multi-paragraph content
  Clear value propositions and insights
  Strategic calls-to-action for engagement

  LinkedIn Optimization:

  Platform-specific formatting and spacing
  Proper hashtag research and placement
  Emoji usage that enhances readability
  Character count optimization for maximum impact

  Engagement Drivers:

  Thought-provoking questions to encourage comments
  Industry insights that spark discussions
  Personal anecdotes that build connections
  Actionable tips that provide immediate value

  Sample Output
  Input Topic: "Remote Work Productivity Tips"
  Generated Post:
  🏠 Working from home has taught me that productivity isn't about being busy—it's about being intentional.

  After managing remote teams for 3 years, I've discovered that the most successful remote workers share three key habits that transform their daily performance.

  First, they create physical boundaries even in small spaces. A dedicated workspace signals to your brain that it's time to focus, even if it's just a corner of your kitchen table.

  Second, they batch similar tasks together. Instead of jumping between emails, calls, and deep work, they group activities to maintain mental flow and reduce cognitive switching costs.

  Third, they communicate proactively rather than reactively. They share progress updates before being asked and clarify expectations upfront to avoid confusion later.

  What's your most effective remote work strategy? I'd love to hear what's working for your team! 💪

  #RemoteWork #Productivity #WorkFromHome #Leadership #TeamManagement #ProfessionalDevelopment
  🛠️ Troubleshooting & Best Practices
  Common Issues & Solutions
  LinkedIn API Limitations

  Respect posting frequency limits to avoid account restrictions
  Monitor API usage and implement appropriate delays between posts
  Ensure compliance with LinkedIn's terms of service
  Maintain authentic engagement rather than purely automated interactions

  Group Posting Permissions

  Verify membership status and posting rights before adding group IDs
  Some groups require administrator approval for posts
  Monitor group rules and community guidelines
  Remove inactive or restricted groups from your list

  Content Quality Control

  Review AI-generated content periodically for brand consistency
  Adjust prompts based on engagement performance
  Maintain a balance between automation and personal touch
  Monitor comments and engage authentically with your audience

  Optimization Strategies
  Performance Enhancement

  Track engagement metrics across different groups
  A/B test posting times and content formats
  Refine prompts based on successful post patterns
  Gradually expand to new groups based on performance

  Content Strategy

  Develop content themes that resonate with your target audience
  Create series of related posts for deeper engagement
  Balance promotional content with value-driven insights
  Maintain consistency in voice and messaging

  Network Growth

  Engage with comments on your automated posts
  Connect with active commenters to expand your network
  Participate in group discussions beyond your own posts
  Build genuine relationships through authentic interactions

  📈 Success Metrics
  Engagement Indicators

  Post Reach: Total views across profile and groups
  Interaction Rate: Comments, likes, and shares per post
  Network Growth: New connections from content engagement
  Group Performance: Which communities provide best engagement

  Business Impact Measurements

  Lead Generation: Connections and inquiries from LinkedIn posts
  Brand Awareness: Mentions and sharing of your content
  Thought Leadership: Recognition as industry expert
  Professional Opportunities: Speaking, collaboration, or job opportunities

  📞 Questions & Support
  Need help setting up or optimizing your LinkedIn AI Agent workflow?
  📧 Direct Technical Support

  Email: Yaron@nofluff.online
  Response Time: Within 24 hours on business days
  Expertise: LinkedIn API integration, AI prompt optimization, workflow scaling

  🎥 Comprehensive Learning Resources

  YouTube Channel: https://www.youtube.com/@YaronBeen/videos

  Complete setup walkthrough and configuration
  Advanced customization techniques and strategies
  LinkedIn API best practices and limitations
  Content strategy optimization for maximum engagement
  Troubleshooting common integration issues



  🤝 Professional Networking & Updates

  LinkedIn: https://www.linkedin.com/in/yaronbeen/

  Connect for ongoing automation support and advice
  Share your LinkedIn growth success stories
  Get early access to new workflow templates and features
  Join discussions about LinkedIn marketing automation



  💬 Support Request Guidelines
  Include in your support message:

  Your current LinkedIn strategy and goals
  Target audience and industry focus
  Specific LinkedIn groups you want to target
  Any technical errors or integration issues
  Current content creation process and pain points

nodes_used:
  ["n8n-nodes-base.limit","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5504 characters]


name: Automatic News Summarization & Email Digest with GPT-4, NewsAPI and Gmail
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T05:58:27.949Z
updated_at: 2025-05-25T05:58:27.949Z
url: https://n8n.io/workflows/4375
scraped_at: 2025-12-24 13:02:43
description:
  📰 AI News Digest Agent: Auto News Summarizer & Email Newsletter
  Create an intelligent news curation system that automatically fetches breaking headlines, generates AI-powered summaries, and delivers personalized news digests to your subscriber list. Perfect for newsletter creators, team leaders, and content curators who want to keep their audience informed without the manual effort of news monitoring and summarization.
  🔄 How It Works
  This streamlined 5-step automation delivers fresh news insights around the clock:
  Step 1: Automated News Collection
  The workflow runs on a configurable schedule (default: every 10 minutes) to fetch the latest headlines from NewsAPI, ensuring your content stays current with breaking developments.
  Step 2: Intelligent Content Curation
  The system pulls top headlines from reliable news sources, filtering by country, category, and relevance to deliver the most important stories of the day.
  Step 3: AI-Powered Summarization
  GPT-4 processes the collected headlines and creates:

  Concise 5-bullet point summaries
  Key insights and implications
  Easy-to-digest news overviews
  Professional formatting for email distribution

  Step 4: Subscriber Management
  The workflow accesses your Google Sheets subscriber list, retrieving names and email addresses for personalized delivery.
  Step 5: Automated Email Distribution
  Personalized news digests are automatically sent to each subscriber via Gmail, with custom greetings and professionally formatted content.
  ⚙️ Setup Steps
  Prerequisites

  NewsAPI account (free tier available)
  OpenAI API access for content summarization
  Google Sheets for subscriber management
  Gmail account for email distribution
  n8n instance (cloud or self-hosted)

  Required Google Sheets Structure
  Create a simple subscriber database:
  | Name          | Email                    |
  |---------------|--------------------------|
  | John Smith    | john@example.com         |
  | Sarah Johnson | sarah@company.com        |
  | Mike Chen     | mike.chen@startup.co     |
  Configuration Steps
  Credential Setup

  NewsAPI Key: Sign up at newsapi.org for free headline access
  OpenAI API Key: Required for AI-powered news summarization
  Google Sheets OAuth2: Access your subscriber spreadsheet
  Gmail OAuth2: Enable automated email sending

  News Source Configuration

  Country Selection: Choose target region (US, UK, CA, AU, etc.)
  Category Filters: Focus on specific topics (technology, business, health)
  Source Selection: Prefer certain news outlets or avoid others
  Language Settings: Configure for international audiences

  AI Summarization Customization
  Default prompt creates 5-bullet summaries, but can be tailored for:

  Industry Focus: Technology, finance, healthcare, politics
  Audience Type: General public, professionals, executives
  Content Depth: Brief overviews vs detailed analysis
  Tone & Style: Formal, conversational, or technical

  Email Template Personalization

  Subject Line Formatting: Include date, breaking news indicators
  Greeting Customization: Use subscriber names for personal touch
  Content Layout: Professional formatting with clear sections
  Branding Elements: Add your organization's signature or logo

  Delivery Schedule Optimization

  Frequency Settings: Every 10 minutes, hourly, or daily
  Time Zone Considerations: Optimize for subscriber locations
  Breaking News Alerts: Immediate delivery for urgent stories
  Digest Compilation: Collect multiple stories for periodic summaries

  🚀 Use Cases
  Newsletter Publishers

  Content Automation: Generate newsletter content without manual curation
  Consistent Publishing: Maintain regular delivery schedules automatically
  Audience Growth: Provide value that encourages subscriptions and shares
  Time Savings: Eliminate hours of daily news monitoring and writing

  Corporate Communications

  Employee Updates: Keep teams informed about industry developments
  Executive Briefings: Deliver curated news summaries to leadership
  Client Communications: Share relevant industry insights with customers
  Stakeholder Relations: Maintain informed investor and partner networks

  Educational Institutions

  Student Resources: Provide current events for academic discussions
  Faculty Updates: Keep educators informed about relevant developments
  Research Support: Deliver news related to specific academic fields
  Parent Communications: Share educational policy and school-related news

  Professional Services

  Client Value Addition: Provide industry-specific news as a service benefit
  Thought Leadership: Position your firm as an informed industry expert
  Business Development: Share insights that demonstrate market knowledge
  Team Knowledge Sharing: Keep entire organization current on industry trends

  Community Organizations

  Member Engagement: Keep community members informed and engaged
  Local News Focus: Customize for regional or local news coverage
  Event Planning: Stay informed about developments affecting your community
  Advocacy Support: Monitor news relevant to your organization's mission

  🔧 Advanced Customization Options
  Multi-Source News Aggregation
  Expand beyond NewsAPI with additional sources:
  RSS Feed Integration: Add specialized industry publications
  Social Media Monitoring: Include trending topics from Twitter/LinkedIn
  Government Sources: Official announcements and policy updates
  International Coverage: Global perspectives on major stories
  Intelligent Content Filtering
  Implement smart curation features:

  Sentiment Analysis: Filter positive, negative, or neutral news
  Relevance Scoring: Prioritize stories based on subscriber interests
  Duplicate Detection: Avoid sending repetitive story coverage
  Quality Assessment: Ensure content meets editorial standards

  Subscriber Segmentation
  Create targeted news experiences:

  Interest Categories: Technology, business, sports, entertainment
  Geographic Preferences: Local, national, or international focus
  Delivery Preferences: Frequency and format customization
  Engagement Tracking: Monitor opens, clicks, and subscriber behavior

  Enhanced Email Features
  Professional newsletter capabilities:

  HTML Templates: Rich formatting with images and links
  Call-to-Action Buttons: Drive engagement with your content or services
  Social Sharing: Enable easy sharing of newsletter content
  Analytics Integration: Track email performance and subscriber engagement

  📊 Content Generation Examples
  Sample Email Output:
  Subject: 📰 Your Daily News Digest - March 15, 2024

  Hi John,

  Please find today's top news headlines summarized below:

  📈 BUSINESS & TECHNOLOGY
  Federal Reserve signals potential rate cuts following inflation data
  Major tech companies announce AI partnership for healthcare applications  
  Renewable energy sector sees record investment levels in Q1 2024
  Cryptocurrency markets stabilize after regulatory clarity announcement
  Supply chain disruptions ease as global shipping routes normalize

  💡 These developments suggest growing economic optimism and continued technology sector innovation. The healthcare AI partnership particularly signals significant advances in medical technology accessibility.

  Stay informed and have a great day!

  Powered by AI News Digest Agent
  Unsubscribe | Update Preferences
  Breaking News Alert Format:
  Subject: 🚨 Breaking News Alert - Major Development

  Hi Sarah,

  BREAKING: [Headline]

  Key Details:
  [Critical point 1]
  [Critical point 2]  
  [Impact analysis]

  Full coverage in your next scheduled digest.

  AI News Digest Agent
  🛠️ Troubleshooting & Best Practices
  Common Issues & Solutions
  API Rate Limiting

  Monitor NewsAPI quota usage and upgrade plan if needed
  Implement intelligent caching to reduce redundant requests
  Stagger requests during high-traffic periods
  Set up alerts for approaching rate limits

  Email Delivery Challenges

  Monitor Gmail sending limits and implement delays if needed
  Use professional email authentication (SPF, DKIM)
  Maintain clean subscriber lists to avoid spam flags
  Implement unsubscribe functionality for compliance

  Content Quality Control

  Review AI summaries periodically for accuracy and bias
  Implement feedback loops for continuous prompt improvement
  Create editorial guidelines for consistent tone and style
  Monitor subscriber feedback and engagement metrics

  Optimization Strategies
  Performance Enhancement

  Use parallel processing for multiple news sources
  Implement intelligent caching for repeated content
  Optimize AI prompts for faster processing and better results
  Monitor workflow execution time and resource usage

  Subscriber Growth

  Create compelling value propositions for newsletter signups
  Implement referral systems for organic growth
  Share sample newsletters on social media and websites
  Collect feedback to continuously improve content quality

  Content Strategy

  A/B test different summary formats and lengths
  Analyze which news categories generate most engagement
  Experiment with sending times for optimal open rates
  Create themed newsletters for special events or topics

  📈 Success Metrics
  Engagement Indicators

  Open Rates: Percentage of subscribers reading newsletters
  Click-Through Rates: Engagement with linked news sources
  Subscriber Growth: New signups and retention rates
  Forward/Share Rates: Viral coefficient of your content

  Content Quality Measurements

  Relevance Scores: Subscriber feedback on content usefulness
  Timeliness: How quickly breaking news reaches subscribers
  Accuracy: Verification of AI-summarized content
  Completeness: Coverage of important stories in your focus areas

  📞 Questions & Support
  Need assistance with your AI News Digest Agent setup or optimization?
  📧 Technical Support

  Email: Yaron@nofluff.online
  Response Time: Within 24 hours on business days
  Specialization: NewsAPI integration, AI content optimization, email deliverability

  🎥 Educational Resources

  YouTube Channel: https://www.youtube.com/@YaronBeen/videos

  Complete setup and configuration tutorials
  Advanced customization techniques for different industries
  Email marketing best practices for automated newsletters
  Troubleshooting common integration issues
  Scaling strategies for growing subscriber lists



  🤝 Professional Community

  LinkedIn: https://www.linkedin.com/in/yaronbeen/

  Connect for ongoing newsletter automation support
  Share your news curation success stories
  Access exclusive templates and workflow variations
  Join discussions about content automation trends



  💬 Support Request Best Practices
  Include in your support message:

  Your target audience and newsletter focus
  Current subscriber count and growth goals
  Specific news categories or geographic regions of interest
  Any technical errors or integration challenges
  Current content creation workflow and pain points

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

workflow_json_compressed:
  H4sIAAAAAAAAE71Y3W7byBV+lYFaNAkgyiRF6sdA0DrOnzeJ40ZOg8XaMIacQ2liitRyyDjawEBu2oveFN3sTbcFtn2DXvZ58gLdR+h3hpRFW0qa3hS+sDicOT/f+c7P8F1nTqXs7L7r6MyUMovpQHV2O6GUSeD3B/HQpX5A+JlEKvLjYTQMA+WN/bAvx/1+FHnBcKDCYJQMw1Ewkq5HwbAfJ51up6T5IpUl7RekzITKarGfY4VKgoKyqOiy28lyRaaz+w20s9Y4dMdeEnlOGMWhEwRR7EQjN3B811NhkpA7GPqQnMk5YfcknpGqUhLHhZ5OqWCdywW/yUaZY0U7kTTUM83G9b5FbnSp8wyqHd/z3a4TuKdYlgVEl1QYBqTAkRoYrLyRqbUz0ZSyqXOdVSVs765+HVzt8tzL08vL2pjfQZbV4/X8y27j5sAN/IDCgTMM/LETjODrqO/FjhsOaDwaBtFI9tdu7h2IvSll5dq938C/nbWPqcym8UzqrCebfW33vHCw3b2S3pYQdvfrvBKyICHjUkgjMrowgt4uqMBjpkScpynxqzSt381IqlRnZITQmYgozS/sRlPN57LQhng5FFGFc6XpnWT8J969E798bXLYWJQ6Tsl84532Sl0ifJeXMDlfsMFsGJBbFGBKeVx7qyiBts4moOMrQP1I+aOo7zsjNwGgcjB2xpEnHZeIhpT0VRS0ePN8QRlA3Z/JUjwDgukXIJvOebs9qbcB7G0BeG5l48fZWZHWlO/aRShKteFAgS8VP04XpRPkDqik2dEWGJ/j0XDs94egjNPvez54NPCdcSBdh/ojRT4NlJLh2u0jBEQcIoKfzJNZWS5e0LcVmQ0SjYLtJKrYsw4fNLs7O8wPudC9vJjuvPF3ynzhXLHlZowNZeq3FRXLFTLf8sPRNeltXci9xpE4r7IS59bwVabDoDTvYcETar8+fPBqcrZ3dHD25MHXnS25GbQwDceDeKRC5fRjt+8E/ZAcGcnIoWE07gPVUTD0WiUITohnUqefxHQ6r9+20RyPVmBeUDTL83NbcimMXT+JpDPguhcME9dBsfUdH1qjEQ0itx93buLPKB7nnMZXCfaANdZJNSdjUBP49WO9TsFDCMCG7kl2lBKMFEgwJcoZCUTsZpKjJNgc3+U0ZhG3b60q0q07PY0q37NC86pcVOWWZDZV9BoFhOPAkh+3CEFsapPmthzdjIzf864i4/lhNHC90El833VQQUOwnSLHHamBRzEFXtSqmjUKTZp9IjR5Pk1pMiOUqZt8993tfL/uGR89tPq+KMm1uuviOZbcj16QqdLy5bX8UXlsGrN6cT7fMYsCaFk1ZkfteE999fR5pC7OpI7vD5Jj5TxIH0/u3fvq4LUn782fHA8fUvysjJbLBzukdPmLbSoPG+qyVI8Rh9ZqjnAyC7/Ej//FjP+ru7+uzOKuKvQbMup8u9eWFqgWmyUgvCJaFHjBIAzHTqgGSEQV9R0pVQhSyGF/4HtSjt1WCUA7O1+Kw7ykTw8gdk+zpc2zvsuzR9/dJNqFVuWssztE3e3MSE9nSCDPR+FA+cOkkXE+/fzTh38KJKPNq/t6irpdJ+au2KvKvF6f1G35OyrEr4R1n4qTjN/PJcxCW1+KhMp4tiX5uwLSqMAQBzXOIr8gzHKrRs+vbd/nGohxAUVAptCjhLKmGAgUy7wqcCAycaEjmMBU6okjKhKeKZK8QFn5+LffW1MxLsB7EYMEZV4Y8fH9DwIdFOHEYsVWqNq+BgFBCQRggjAmXdZijknODfxEA5KZ/k7aZLWCzokWgiBqmWc8oeDkHPIudDkTBU2rVBaiWigoMbWo/UaJ1bwypyxkZvhobQgmw7zxVkcpizUcKcOl8uOPf/n3v/4kXmFsuGXES0PqJAMtQBTQAl7fnF7Fxz98X0cMnco+rMqsfdgYWuzqI5s8oq5h9QpH+CR78BZQIh7iOM9TY2s3y7ai338QD23AeToHZda1PsHcBTRSLdkbg9jFDEej+9HRsRPY449WrEAkYp74Qqce99bcOMlu2IZjz2SGbtSmA11VaT5gH3jjZINSFu6GV/VE+fNPP/xZ2GuFPcK3DGClZWqAIn6rts+YByw6DwviQddOEAJItgYWJuMVFLwHtLpy/ZoM7Gtlg7Wscbsm3E3XnyPZZn4dUiv2vyDQ2m+BkHWuNrqaLLHnrqD48McbVJiggMdlhbGeBzpdMBz7nFhwTRjN97C2Fa3KW3OFJ4Tb6w1gMJc7i9E6LtbbOyCbNft2QbFeaJuYdkEqVcBbMndWZv74XrzKi/OErwyTkhbW/lUiqJr9+/V9w+L4okL22qQVniuaixaXlaTN35eTmxRuwo4yd+AcNXGa3AjR0bHANSO2Bm7MPHzvsWiZz1J8skbwqebi27DmBZXYgDbUCm9t2fUoMZwK7yCiqs06apO+xvV+XQJR4ZgNMKgy4MNGVjAshIbXDqutbpjrdGHDtwrD9/8QR0UujnUdgP2VQDsCNtO1uGpH4vbLSVe8fNIV+3tdAeB7d6zhqJqaTbVWAGr1GnLE6q4Nd/kmkcVLwS1QiTyrm4GsFDgSE9CnBJHJbInZU0AceE9zqE50ym1Q3C4pnmV5mk+XXdwnDccGTccsUPVNbUSmoa+VFxD1LM80CnYDfdNAlqKw0awvquvsy6aoSDz8nGTHzCWLmJnzZfdG1+IxGBqRNuiZOpuiW6zw/OvfudKvYTwoeZ1dmmPy0JxrdZWoC6o1HPMOAJgROsYbBh02wpKT7CCL00ohFEBGsRp0ZR2bVactNRuLJ5kujYa3aFMZt1JEn+8h8Qy5jfYncsRyhQHoek4lC+MPMty+GsSRXisnRVJlNuvgXLm06ixr57Zm1wg1BUTpxAaubKjH/qA+IV4K2hCqC6Jz/h9h/zmrZe/vbN7gL0/tNJPV6W7HnquPHXx/xsUbQxJf/Oo5dNtMbzd1O7jA0NvOrnt5ego166vuNjGbH1S2Cmlp2yZly9Vvq5iNr1TbhG25m28VtvnpAtKkPuMPFRXi1Kx91tmN7deVXF7+B9ZQF0oTFAAA


name: Extract Invoice Data from Email to Google Sheets using GPT-4o AI Automation
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T06:03:38.031Z
updated_at: 2025-05-25T06:03:38.031Z
url: https://n8n.io/workflows/4376
scraped_at: 2025-12-24 13:02:41
description:
  Transform your invoice processing from manual data entry into an intelligent automation system. This powerful n8n workflow monitors Gmail for invoice attachments, extracts data using AI-powered analysis, and creates organized Google Sheets with all relevant financial information automatically structured and ready for your accounting workflows.

  🔄 How It Works

  This sophisticated 8-step automation eliminates manual invoice processing:

  Step 1: Intelligent Email Monitoring
  The workflow continuously monitors your Gmail account for emails with specific labels, checking every minute for new invoice attachments that need processing.

  Step 2: Attachment Verification
  Smart filtering ensures only emails with PDF attachments are processed, preventing unnecessary workflow triggers from text-only emails.

  Step 3: Advanced PDF Extraction
  The system automatically downloads and converts PDF invoices into readable text, handling various invoice formats and layouts with high accuracy.

  Step 4: AI-Powered Data Analysis
  GPT-4 processes the extracted text using specialized prompts designed for financial document analysis, identifying and extracting:
  Company information and contact details
  Invoice numbers, dates, and payment terms
  Detailed line items with quantities and pricing
  Tax calculations including CGST, SGST, and VAT
  Billing and shipping addresses
  Payment methods and transaction references

  Step 5: Structured Data Formatting
  The AI output is automatically formatted into clean, consistent JSON structure with 25+ standardized fields for comprehensive invoice tracking.

  Step 6: Dynamic Spreadsheet Creation
  Each processed invoice generates a new Google Sheets document with timestamp naming and organized data layout, ready for accounting review.

  Step 7: Automated File Organization
  Processed spreadsheets are automatically moved to designated Google Drive folders, maintaining organized file structure for easy retrieval and audit trails.

  Step 8: Data Population
  All extracted invoice data is populated into the spreadsheet with proper formatting, formulas, and structure for immediate use in accounting workflows.

  ⚙️ Setup Steps

  Prerequisites
  Gmail account with invoice-receiving capability
  Google Workspace access for Sheets and Drive
  OpenAI API account for data extraction
  n8n instance (cloud or self-hosted)
  PDF invoices (text-based, not scanned images)

  Gmail Configuration Requirements

  Label Setup:
  Create specific Gmail labels for invoice processing:
  📧 Labels to Create:
  "Invoice-Processing" (main processing label)
  "Invoice-Vendors" (supplier invoices)
  "Invoice-Clients" (customer invoices)  
  "Invoice-Processed" (completed items)

  Email Filter Configuration:
  Set up automatic labeling rules:
  Emails from known vendors → Auto-apply "Invoice-Processing"
  Emails with "Invoice" in subject → Auto-apply "Invoice-Processing"  
  Attachments with PDF extension → Auto-apply "Invoice-Processing"

  Configuration Steps

  1. Credential Setup
  Gmail OAuth2**: Full email access including attachments
  OpenAI API Key**: GPT-4 access for intelligent data extraction
  Google Sheets OAuth2**: Spreadsheet creation and editing permissions
  Google Drive OAuth2**: File organization and folder management

  2. Google Drive Folder Structure
  Create organized folder hierarchy:
  📁 Invoice Management/
  ├── 📁 Incoming Invoices/
  ├── 📁 Processed Invoices/
  │   ├── 📁 2024/
  │   │   ├── 📁 Q1/
  │   │   ├── 📁 Q2/
  │   │   └── 📁 Q3/
  ├── 📁 Vendor Invoices/
  └── 📁 Client Invoices/

  3. AI Extraction Customization
  The default AI prompt extracts standard invoice fields but can be customized for:
  Regional Tax Systems**: GST (India), VAT (EU), Sales Tax (US)
  Industry-Specific Fields**: Purchase orders, project codes, cost centers
  Company Standards**: Custom fields, approval workflows, coding requirements
  Multi-Currency**: Exchange rates, currency conversion, international invoices

  4. Data Validation Rules
  Implement quality control measures:
  Required Field Validation**: Ensure critical data is always extracted
  Format Standardization**: Consistent date formats, number formatting
  Duplicate Detection**: Identify potentially duplicate invoices
  Accuracy Scoring**: Confidence levels for extracted data

  5. Workflow Activation
  Import the workflow JSON into your n8n instance
  Configure all credential connections and test each step
  Process test invoices to verify accuracy
  Activate Gmail trigger for continuous monitoring

  🚀 Use Cases

  Accounting Firms & Bookkeepers
  Client Service Automation**: Process invoices for multiple clients efficiently
  Data Entry Elimination**: Convert hours of manual work into automated processing
  Accuracy Improvement**: Reduce human errors in financial data transcription
  Scalable Operations**: Handle increased client volume without proportional staff increase

  Small & Medium Businesses
  Accounts Payable Automation**: Streamline vendor invoice processing
  Cash Flow Management**: Quick access to payment due dates and amounts
  Expense Tracking**: Organized categorization of business expenses
  Audit Preparation**: Maintain organized, searchable invoice records

  Corporate Finance Teams
  Procurement Processing**: Handle purchase orders and vendor invoices at scale
  Multi-Location Operations**: Centralize invoice processing across offices
  Compliance Management**: Ensure consistent data capture for regulatory requirements
  Integration Readiness**: Prepare data for ERP and accounting system import

  Freelancers & Consultants
  Client Invoice Tracking**: Organize incoming payments and project billing
  Expense Management**: Categorize business expenses for tax preparation
  Cash Flow Monitoring**: Track outstanding invoices and payment schedules
  Professional Organization**: Maintain clean financial records for business growth

  E-commerce & Retail
  Supplier Invoice Processing**: Manage inventory purchasing and cost tracking
  Multi-Vendor Operations**: Handle invoices from numerous suppliers efficiently
  Cost Analysis**: Track product costs and supplier performance
  Inventory Reconciliation**: Match invoice data with purchase orders and receipts

  🔧 Advanced Customization Options

  Multi-Format Invoice Handling
  Extend processing capabilities:
  PDF Text-Based: Standard invoice PDFs with selectable text
  Scanned Documents: Add OCR processing for image-based invoices
  Email Body Invoices: Extract data from invoice details in email content  
  Excel Attachments: Process invoices sent as spreadsheet files
  Multi-Page Documents: Handle complex invoices with multiple pages

  Intelligent Data Validation
  Implement quality assurance features:
  Cross-Reference Validation**: Compare extracted data against purchase orders
  Vendor Database Matching**: Verify company details against known vendor lists
  Tax Calculation Verification**: Validate tax amounts and rates for accuracy
  Currency Conversion**: Handle multi-currency invoices with real-time exchange rates

  Workflow Integration Extensions
  Connect to existing business systems:
  ERP Integration**: Direct data export to SAP, Oracle, or Microsoft Dynamics
  Accounting Software**: Push data to QuickBooks, Xero, or FreshBooks
  Approval Workflows**: Add review and approval steps before final processing
  Payment Processing**: Connect to banking systems for automated payment scheduling

  Advanced Analytics & Reporting
  Generate business insights:
  Vendor Performance Analysis**: Track pricing trends and payment terms
  Expense Category Reporting**: Automated expense categorization and analysis
  Cash Flow Forecasting**: Predict payment obligations based on due dates
  Audit Trail Management**: Maintain comprehensive processing logs for compliance

  📊 Extracted Data Structure

  Standard Invoice Fields (25+ Data Points)
  The AI extraction captures comprehensive invoice information:

  Header Information:
  Billed To (Customer/Company Name)
  Invoice Number (Unique Identifier)
  Date of Issue (Invoice Creation Date)
  Due Date (Payment Deadline)

  Line Item Details:
  Item Description (Product/Service Details)
  Quantity (Number of Items/Hours)
  Rate (Unit Price)
  Amount (Line Total)

  Tax and Financial Calculations:
  CGST/SGST Rates and Amounts (Indian GST System)
  VAT Calculations (European Tax System)
  Subtotal (Pre-tax Amount)
  Total Amount (Final Invoice Value)

  Company and Contact Information:
  Vendor Company Name
  Contact Phone/Mobile
  Email Address
  Website URL
  GST Registration Number
  PAN Number (Indian Tax ID)

  Address Information:
  Billing Address
  Shipping Address  
  Place of Supply
  Place of Delivery

  Payment Details:
  Transaction IDs
  Payment Mode (Check, Bank Transfer, Card)
  Terms and Conditions
  Special Instructions

  Sample Extracted Data:
  {
    "billed_to": "Tech Solutions Inc.",
    "invoice_number": "INV-2024-0156",
    "date_of_issue": "2024-03-15",
    "due_date": "2024-04-15",
    "item_0_description": "Web Development Services",
    "item_0_quantity": 40,
    "item_0_rate": 75.00,
    "item_0_amount": 3000.00,
    "tax_0_cgst_rate": 9,
    "tax_0_cgst_amount": 270.00,
    "tax_0_sgst_rate": 9,
    "tax_0_sgst_amount": 270.00,
    "subtotal": 3000.00,
    "total": 3540.00,
    "company_name": "Digital Services LLC",
    "company_email": "billing@digitalservices.com",
    "payment_transaction_ids": "TXN123456789",
    "mode_of_payment": "Bank Transfer"
  }

  🛠️ Troubleshooting & Best Practices

  Common Issues & Solutions

  PDF Extraction Challenges
  Scanned Documents**: Original workflow handles text-based PDFs only
  Complex Layouts**: Some invoice formats may require prompt refinement
  Multi-Page Invoices**: Large invoices might need pagination handling
  Password Protection**: Encrypted PDFs require manual processing

  AI Extraction Accuracy
  Field Recognition**: Some custom invoice formats may need prompt tuning
  Currency Handling**: Multi-currency invoices may require specific configuration
  Date Formats**: International date formats might need standardization
  Vendor Variations**: Different vendor invoice styles may affect accuracy

  Gmail Integration Limitations
  Label Management**: Ensure consistent labeling for proper processing
  Attachment Size**: Large PDFs may hit Gmail API limits
  Email Volume**: High-volume processing may require rate limiting
  Security Settings**: Corporate Gmail may have additional restrictions

  Optimization Strategies

  Processing Efficiency
  Batch Processing**: Group similar invoices for more efficient processing
  Template Recognition**: Create vendor-specific extraction templates
  Quality Scoring**: Implement confidence ratings for extracted data
  Error Handling**: Add fallback processes for failed extractions

  Data Quality Assurance
  Validation Rules**: Implement business logic for data verification
  Duplicate Detection**: Prevent duplicate invoice processing
  Manual Review Queues**: Flag uncertain extractions for human review
  Audit Logging**: Maintain detailed processing logs for troubleshooting

  Business Process Integration
  Approval Workflows**: Add management approval steps for high-value invoices
  Exception Handling**: Create special processes for unusual invoice types
  Reporting Automation**: Generate regular summaries of processed invoices
  Archive Management**: Implement retention policies for processed documents

  📈 Success Metrics

  Efficiency Improvements
  Processing Time**: Reduce manual data entry from hours to minutes
  Accuracy Rates**: Achieve 95%+ data extraction accuracy
  Volume Capacity**: Process 10-50x more invoices with same resources
  Error Reduction**: Eliminate manual transcription errors

  Business Impact Measurements
  Cost Savings**: Calculate labor cost reduction from automation
  Cash Flow Management**: Faster invoice processing enables better payment scheduling
  Compliance**: Improved audit trails and data consistency
  Scalability**: Ability to handle business growth without proportional staff increase

  📞 Questions & Support

  Need help implementing or optimizing your AI Invoice Processor Agent?

  📧 Expert Technical Support
  Email**: Yaron@nofluff.online
  Response Time**: Within 24 hours on business days
  Specialization**: Invoice processing automation, AI data extraction, accounting workflow integration

  🎥 Comprehensive Training Resources
  YouTube Channel**: https://www.youtube.com/@YaronBeen/videos
    Complete setup and configuration walkthroughs
    Advanced customization for different invoice types
    Integration tutorials for popular accounting software
    Troubleshooting common extraction and processing issues
    Best practices for financial document automation

  🤝 Professional Community & Updates
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
    Connect for ongoing automation consulting and support
    Share your invoice processing success stories and ROI results
    Access exclusive workflow templates and advanced configurations
    Join discussions about financial automation trends and innovations

  💬 Support Request Guidelines
  Include in your support message:
  Your current invoice processing volume and types
  Specific vendor formats or invoice layouts you handle
  Target accounting software or systems for integration
  Any technical errors or extraction accuracy issues
  Current manual processing workflow and pain points



  Ready to eliminate manual invoice processing forever? Deploy this AI Invoice Processor Agent and transform your accounting workflow from tedious data entry into intelligent, automated financial management!

nodes_used:
  ["n8n-nodes-base.gmailTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.filter","n8n-nodes-base.extractFromFile","n8n-nodes-base.code","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5340 characters]


name: AI Client Onboarding Agent: Auto Welcome Email Generator
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T06:10:41.891Z
updated_at: 2025-05-25T06:10:41.891Z
url: https://n8n.io/workflows/4377
scraped_at: 2025-12-24 13:02:45
description:
  AI Client Onboarding Agent: Auto Welcome Email Generator

  This workflow automates welcoming new clients. When someone submits a form, their details are pulled from Google Sheets, a personalized onboarding checklist is generated using Google Gemini, and an email is sent directly to the client. It also includes error handling to ensure nothing is missed.

  🟢 Section 1 – Trigger & Client Data Capture

  Nodes:

  ⏰ Trigger on New Client Form Submission → Fires when a new row is added in Google Sheets (from the client’s form).
  🧍 Extract and Structure Client Data → Collects and formats client details: name, email, company, services, extra info.

  ✅ Beginner view: This is the doorway. When a client fills the form, their info is automatically pulled into the workflow.

  📑 Section 2 – Checklist & Personalization

  Nodes:

  📋 Client Checklist → Creates a default onboarding checklist (account setup, welcome call, docs, etc.).
  🧠 Personalize Using Gemini → Sends client details + checklist to Google Gemini AI → generates a tailored onboarding email body.

  ✅ Beginner view: This is where the magic happens. Instead of a boring generic email, each client gets a customized message that feels personal.

  📤 Section 3 – Delivery & Completion

  Nodes:

  📧 Send Email to Client → Sends the personalized onboarding email directly to the client’s inbox.
  ✅ Execution Completed → Marks the workflow as successfully finished.

  ✅ Beginner view: Think of this as the final handshake with the client — they get a warm, professional onboarding email without you lifting a finger.

  🚨 Section 4 – Error Handling

  Nodes:

  ⚠️ Error Handler → Captures any failure in the workflow.
  ❌ Execution Failure → Defines fallback/alert action if something breaks.

  ✅ Beginner view: This is your safety net. If an email fails or Gemini is unavailable, the workflow won’t just stop — you can set it up to alert you.

  📊 Summary Table

  | Section           | Key Nodes                           | Purpose                                | Beginner Benefit               |
  | ----------------- | ----------------------------------- | -------------------------------------- | ------------------------------ |
  | 🟢 Trigger & Data | Google Sheets Trigger, Data Extract | Capture client info                    | Auto-collects form submissions |
  | 📑 Checklist & AI | Checklist, Gemini                   | Generate personalized onboarding email | Each client feels special      |
  | 📤 Delivery       | Gmail, Execution Completed          | Send email & close flow                | Client gets email instantly    |
  | 🚨 Error Handling | Error Trigger, Failure Node         | Catch issues                           | Ensures nothing is missed      |

  🌟 Why This Workflow Rocks

  Saves hours** → no manual onboarding emails
  Personalized at scale** → Gemini tailors messages per client
  Error-proof** → built-in error handling keeps you safe
  Scalable** → works for 10 or 10,000 clients

  👉 Example Flow in Action:

  A client named Sarah fills the onboarding form.
  Workflow captures her details → “Sarah, MarketingPro Agency, Needs Analytics Setup.”
  Gemini creates a custom email:

     &gt; Hi Sarah, welcome aboard! Here’s your onboarding plan tailored for Analytics Setup…
  Gmail sends it instantly.
  You get notified only if something fails.

nodes_used:
  ["n8n-nodes-base.errorTrigger","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5536 characters]


name: Extract Marketing Testimonials from Feedback with Gemini AI and Google Sheets
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T06:17:26.200Z
updated_at: 2025-05-25T06:17:26.200Z
url: https://n8n.io/workflows/4378
scraped_at: 2025-12-24 13:02:46
description:
  Extract Marketing Testimonials from Feedback with Gemini AI and Google Sheets

  🌍 Overview

  This workflow automatically extracts short emotional testimonials from Google Form responses. It listens for new feedback in Google Sheets, processes it with AI (Google Gemini), writes back a refined testimonial, and sends an email notification.

  Think of it as your testimonial assistant—turning raw customer feedback into marketing-ready quotes.

  🟢 Section 1: Trigger – Listen for New Feedback

  🔗 Nodes:

  Google Sheets Trigger** → Watches for new rows (new form responses).

  💡 Beginner takeaway:
  Whenever a customer submits feedback via your form, this trigger wakes up the workflow.

  📈 Advantage:
  No manual checking — feedback is instantly processed.

  🟦 Section 2: Testimonial Extraction with AI

  🔗 Nodes:

  Basic LLM Chain* → Runs a custom prompt that tells the AI: *“Extract a short, emotional testimonial quote from the feedback.”
  Google Gemini Chat Model** → The AI brain that processes and rewrites the testimonial.

  💡 Beginner takeaway:
  This part filters out neutral or boring text and produces a catchy, emotional testimonial.

  📈 Advantage:
  Saves you time editing feedback → instantly produces marketing-ready quotes.

  🟣 Section 3: Store & Notify

  🔗 Nodes:

  Google Sheets (Write Back)** → Saves the extracted testimonial into the same Google Sheet.
  Gmail** → Sends an email with the new testimonial to your chosen inbox.

  💡 Beginner takeaway:
  The testimonial is both saved for records and shared with your team via email.

  📈 Advantage:
  You get real-time alerts and maintain a growing database of testimonials.

  📊 Final Overview Table

  | Section           | Nodes                 | Purpose                       | Benefit                    |
  | ----------------- | --------------------- | ----------------------------- | -------------------------- |
  | 🟢 Trigger        | Google Sheets Trigger | Detect new feedback           | Automated start            |
  | 🟦 AI Extraction  | LLM Chain + Gemini    | Extract emotional testimonial | Marketing-ready quotes     |
  | 🟣 Store & Notify | Google Sheets + Gmail | Save + send testimonial       | Organized + instant alerts |

  🚀 Why This Workflow is Useful

  Automates testimonial creation** → No manual copywriting needed
  Captures emotions** → AI filters for impactful quotes
  Centralized storage** → All testimonials logged in Google Sheets
  Instant notifications** → New testimonials delivered straight to email
  Beginner-friendly** → Just connect your sheet + Gmail and it runs on its own

nodes_used:
  ["n8n-nodes-base.googleSheetsTrigger","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1a627cxhV+lQFdFMlGXPF+WcCoZcdylNpSY8lWA9sIhpzDXVq8hTPUaisL8K+iKNo/cYACRYugDdAH8xPkEXpmSO5Fu1JkJ8iPwAvYWHFmzvU7t+GeaynTRlo2/vLstNk9bp5+/vTw6Wen2paWg6Da6FxLCy5oEcOe3OcZhuOFhhOZhpMYiW9FlmeFNGRBkECYeL4XgWPYru+FiZkYAaPMZMwOKC6ETmBoF1taQXNAUqY9JPfPRE1jQR7R+gREWozJEXCR5mWR0oyTpC5zsgvAIhqfkGkqJuQB5GmRkp09QgtGHpTlOANyOAEQHGUWdMy10bMXyKRkIL+et/pRP2FO5IBue46lOzaAHrLE122HWqGZJDYuanPRVsiSozodj6GW5GeVXC6CQlf09YhyGI7V7nbzYm9V8lSkZYEyuKa1ZfkWSlXRGjkIqLm0LJxCIZBeXU53GAOGp8pKnpGrF5JElh2lOajNqYBc6ZMjZzyEh+vZo7RoBGgXL3A3lwLsKwXOta++qjNtJOoGtvoDWcoFcjilWYN/2q5leq5j+1taTOMJsMfAm0w8kce0iRAVH21vszLmnXrDuMy3eVUDZYoR32bbplPkh39kD5483n9pU7P5gp/tx7xi++5n9csHWXC0Ewh9wr54smvxbWCpuDVO2e05Z22VdSu6tlvWOcEnFZoBODElYlCOJkdbSQjeQDftXQTTfkkD/K7h1W1Wp6fA2clm/ZcCQLu4aDH3FAGjoGRebHWADswgCBzKdDswQXdMGwHtUVP3qeWFgRWAo/DUAfou5WlMHj58RO5NaFosoHwHsby9wHNGi3EsdwzV/w+zfBXJfuBsRLKAMwnk2308U8InZS22COSlPEqzbEagGNOxjHGxUJF83ZQC2kAXE/yCkC+nclPDoSZJF/tDsjcuyhpIAQ1yyEhZk7SuIYNTWggi2Q/JQYFMahBNXShaivTwefFcOz8nv3nJy2I4zyUXF881XCn6ByOy2PXsudY/fq696LZKO6CQlThqDccgSQvQ1hw0dBcuMowIEifWAxr7uuOGVKdgR3roYs5M/NhLWLiWc7r8hm7CrIg+yW7gqyyX21sC7flLXvOCLdcK1ry2kmxkJGUdBtV3vj1WtHRraOhJRvlkXdu5rjQKEtuMA91zIdadwAp1/JfoAB7EtuuC4ftX5Ncb5dVVhUzLMDbiMC6zJlca9blAqsYxyHK6KAYqpwqaVwvWXNQIOvybpbzK6KzPLzV83aQ1htIowYIE8/U+WJcoISIohvEjKuLJfHtMi7vwhAM7KrsFSXduNkXmpwrREXkf/vdzmmY/WYCeyvtI0EfaTxZiidD7yNGn3dlNBMnL0yU5fgwjS5TfRzKVW39uoTqi7yIPBltOqwq5P2qLLm0Ebqj2iqoRn1JsFuUG3I877vVx+GxJfSRABXYxmEPLe2WB/YtKpnzBuH24m0LG+FF52Krarl5c6o3KCmrapgMNpYKCHdRPKkaFDIUPrdCvvxVyliotNXzTtsHRIXQi3WFWoIdW4OhGYge2F1Dbiq2l6rOa9C5XnW51udw4QdCVmylEk7I8UbMQjWMwIwh0O6TINbENPXCdUA/B8DzToVGU2NrlCsURqUelZIsRM8twhdM7iqe0qhq7OKdjKdjtedsioxX7kMvzAW+ilxDLxmsfpsuTUz9XYfhfNps1XBRtO0ocP8GOhOF4pjtebOsRTnSogB2wEIIEx7qF2Q5FGp/MyD42VeGV1uNqk9yzakLdNFxvSzfNjTW7rNGfaNyUCcw2po3VXZtAOp6gbrZlqMwg2lnp9s0+zwuy9Dk+ePz73YcHx2Tn8HDv8Ghn/97958WNKWEY4rA5w35SWhitL7tP3lSV6nCrDFBxIiVEi49axl/SuizuFGWSNUkyLIsMe0XZbt4/qzLZxubyP5FWXE2xAhNprQbeCdTQktDJl2Vz1EQwIn0ETqfT4axsBD5UEXhHcbkLUGyfpgxK3h18mBYnwPaK1ZOZeio7ezyaFtszeTiSh9/BFNd0gEaS+H5oxHrsO6buxNj8RaGf6EYMvpXQMLINdyOYnPcEk2U5N8CSFYQLLJm+5S2D6dbPewEhPXzr1i3yw3d/+zsZDA6wmJ2mMB0M5MLRJOVkWtYnCQ44RNZOLJZprCajwQBaOXg7Ny3GpuVZiQ8GrUAdU1Ue6r484IgkiEz+gABNEKEF5oR+fiJpsSoq4rYuY0w1WFdS0WqGKn20MoV8vEWmdYoSEEWDIjM59LBlobaUGWRWk1hGwTGTkQKlT1A3qcOwU744IWUieVFOEMU1Kr08B1LOU3nPJAaDt6+/lTOcdEZNpyRuONpqaRhEZURJ8t5juqxDs3ba44qbruutK9AT3/2XHGKOREGIOeqvcsjb128wTKStlKlk+pyPfHjyh+++/QfKty+hOGrdN8C/N14LoVPe/vkbciw7H1hYvi6nnHykfLDipo+HLYNv/oME7wLOwwXKI+gJ0CmdKWbHEyjk7Q4afK47pvo8RaZzG5ymtDWjJL+F8y6iS3TaDQZTpMdJU6k5uAfdYNDxfvMX3LLD5OiMlUbx3JcGLRp0BGoRn0jboxuWTI4wUfeAAuHaQ4etW/t/c2tbo00VSa50YLvG0JeuKzoTP24Q2b1NSDuNo4JUzv8ZBqvUdWdvRBBA/7r6IuLa24f+uuHt638PVny+NpZ3Mh0pniSqUcxWlkVcycCooYsgSX6J84+jQOULzG4CdyRpJjMcweS/fAMSlXV7nXKGUaPYIXPWxJI3noolJGdXqH4dGA4pNmUSXViiciCyW5N85mCQiq+goeV504j8fo4Re0QOhSyFv5WVIE1mNw6+j46lWcldFOfjzhWt1NLO0Hc/K75WWUMucywYK9lw2HGQuasntprQFGTlWRnQy0SRpIrCeFJiDkQeUXl2E9/CqmiYYUvkMBhwVIKpJFJDXNaMd47FlQnFca6VRLEUQHOVBqCV+2p/YidBxiCQJM105VKa4ZzVIhQP405ELyXjur16wymKygIsE/Zy/Vlz5Zu/kt1UAqsvdeSIRpnqdF7Nnbz4vCLKqeTy5xX5Q1NjfYe1lX79LmbEBGvHpkXJS7/8IRueXff8RustL1VT+kIyl3BjbcDnn2JvEovVYrys2U7bCKBnMZ5qsaaZyqmYYZbyJ56ap0bySZ+aFLU+7W3Odq8Wbc5KiK5w+/5SSK7phhxVTLxSEYd/yuK/wqfX7aAe0yL9E+r2SZ8veuS9ugylf74mx5MZUVnvuO+S8PsTDkmT9UmgtxZf4RejMlLdLnaXallZzWT+laAu0PrAWjL3aIUdBlLp7MS7k2jnPtXKEEzzCo2J7Ds7dYexd8QErPTCSlRjlPXHs9V+jWQlooCtNV8tnb3OIsvNUi/I/mqa4QQrDk7KtWKJtQa7WZl6VOR3JbNLNHpSp+iPbNZR+hyrpRxOColClTfUyD73okwBGFi1rK2ILdljlNNi7p3rGn7XCz3DkDMjjtoO9uR66Jg4dLuOazgmC1x/8/T4zv2+g/OgbvreVe2+PW/3bctZdPueu9rsf2gHf8F28BrguEniOsxL9BhsnBRZYuoBtQw9cj3fCMAxKIWNwDHfGTm+a23pV7wokMjxNiNHHltDzofW9kNre3Vrew3ewUhMSJJEN8MY8e6DrYexHepRDKZnW0Hoxf5GvFvvjHfTtL1rU6U7B7wT/Fiq/NCn/wr69A24lO9h0K+nMH/xwkFIcLc/SjmDuJFeP6gZIGK0U/Xe4bQ9ry6+wbds02Ouzlx51WfaiR4EnoX53E0sy42BxvK3B13X0d1XX3rpiw+kRojZZ+fqxzrrF/N5+0uFtGBwpo2MixfyVy6Xf8mwkc7m18sb6W3+qc8mqlf+huI6uuuv85E0Tb+SL+8b9Hv37CZs1k6tsry4+D+TW/bpyyUAAA==


name: Website Downtime Alert via LINE + Supabase Log
author_name: sayamol thiramonpaphakul
author_username: sayamol
categories: []
created_at: 2025-05-25T08:04:40.906Z
updated_at: 2025-05-25T08:04:40.906Z
url: https://n8n.io/workflows/4379
scraped_at: 2025-12-24 13:02:44
description:
  This workflow automatically checks the status of your websites using UptimeRobot API. If any site is down or unstable, it will:
  Generate a natural-language alert message using GPT-4o
  Push the message to a LINE group (with funny IT-style encouragement)
  Log all DOWN status entries into your Supabase database
  Wait 30 minutes before repeating

  🔧 How It Works
  Schedule Trigger – Runs on a fixed interval (every few minutes).
  UptimeRobot Node – Fetches website monitor data.
  Code Node (Filter) – Filters only websites with status 8 (may be down) or 9 (down).
  IF Node – If any site is down, proceed.
  LangChain LLM Node – Formats alert with a humorous message using GPT-4o.
  Line Notify (HTTP Request) – Sends the alert to your LINE group.
  Loop Over Items – Loops through all monitors.
  Filter Down (Status = 9) – Selects only “fully down” sites.
  Supabase Node – Logs these into synlora_uptime_down table.
  Wait Node – Delays next alert by 30 minutes to avoid spamming.

  ⚙️ Setup Steps

  Required:
  🔗 UptimeRobot API Key
  📲 LINE Channel Access Token and Group ID
  🧠 OpenAI Key (GPT-4o Mini)
  🗃️ Supabase Project & Table 

  Step-by-step:
  Go to UptimeRobot → Get API key and ensure monitors are set up.
  Create a Supabase table with fields: website, status, uptime_id.
  Create a LINE Messaging API bot, join it to your group, and get:
  	Access Token
  	Group ID (userId or groupId)
  Add your OpenAI API Key for GPT-4o Mini (or switch to your preferred LLM).
  Import the workflow JSON into n8n.
  Set credentials in all necessary nodes.
  Activate the workflow.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.uptimeRobot","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.splitInBatches","n8n-nodes-base.filter","n8n-nodes-base.supabase"]

workflow_json_compressed:
  H4sIAAAAAAAAE8VY227byBl+lSkTrG1UI/F8UJqiPmQToz4EsRMjjQ3tkBxas6aGXJKy1qsl0Ju93gJtb4qiWxR9hF7s8+QFuo/Qf4aUSEmUs71pgyQUZ+Y/ffMfOVd4EtJcGX6YKyxUhoptG04UaSE2jYBg0zIt7Ju6g03Tst2QGK4TeUpP4WRC4fRFMKbhNKboMmO3tzSDneIhFTvc5Viyxj7JaT+vDzbn0iRnBUs4iNZVtadpqnoDqyQDzgXNQKW5kgGFeDIOK/cklmpGjMZC0wnj0wJUL2/KshL7DsgkR62vl73aoMiyAzd0VKzrurDK9rFnBgb21EhVNZcYjqm3DCpYcPeAzpKCbrdFnqmPtMzAmqv2nA4zgiROMmVo9JQZC4uxMtQtsFgZU3Y7LpShq8NLkICNHN6UJ0/QacJZkWToivrAnaLDMQ3u0GxMOTpKZhw9eaJsmLw02HasQHMiG0euoWOTmAYmgW1jYoWUmLrmk9BtDH5Ji4W4fKvF07RgE/om8ZNi1WRT33JzEYvrn6BoRvNkmgWC8aQSJdQPMhqCxYzEkqIlYz9l8taFNXcTk1vmq3fFQ3jlTo6CRvO3kgBJCkSCIJnyAmF08cABbaJsOsUSIZ04RuCAe6uhb2GTahF2LQCMelRzfccPqeY3ck5OTtEpzXNyS9HnSTYhRYPTbwCoQQNWTPhtMCaM9+X/J/FkFS5NdbfgVdCvxd0/n8/R0y/zhPfFAipLdMJysC6OEYkiGhQ0RMIjckR4iEgI/1A+TrICRVPOH9CM5WMUgecUY4qOL1FByaQvdMiSSVpcVkqHNGKcbnpQ314iZBh6pKs6xYHrQNB4oYYJcQhEjm4bmmU6qtXyofOU8v1j9PL1JTYTdMo4+xkIxZPDMSkkKVtDScSRZuibKE2ARyx+jEYZPItsSntyEQTFABTwgSwxFa+3aQHK4IlQBixNUsFc+uOm6yVSibbXkffpxaX95so0uJo7d7M1W1nL32YQo+SBTJK4w+Vaecg2ieFpxMWmH0Yiu1LsQjLFJHKI5lDP8FSzEfMiD0hK0RmdxXBX2yMzEMavomfagJ7e4WNf5ocVVJBrwKkyMrsUTvYcPWU8nRb9iGV5sbvXb/zv22/Rzs6za14RBDElnIY1UU3ez2gak4DuDq6v+eC2h3au4Q/f2QOyjBbTjKMPcyRYDtEcCa7DFUYlKm+ebfhiA5vmaL6nhS72LVVkM9WFzG1BNgtUx4p0zfJco5W+KYRFkaCT47MXWzEbF0X6hn41pflaNtNsdwt0U+FuiiDMh4MBSVlfXEt/Qgf3+gDyz2BSJYhBOs3HwBQox4lQ//X5xaWy4n49RYBxkIQPMt6vOULXSpFcK0N4/ur9+ds3I6H96OWb87evR8dHv75WetWhWkYujn4QSwjNq4dkAbZWTATINVG9JRfE1np6uVaqU6V43FzzEoGyOYBY6VcFmCB4RUkosVBqjfenYGHGviHCsIr5ASUZzVDLhsNX+2dnL05Gl+e/fXHWGHJY1Tp8uVSZpGnMAslrIMQJvcpalaXoSps8pQGLHmoAxWFludhoKdfXvcpshaPv+qZPfRdTnXjQ54QOhKOvQYZTPUvzQtVRo8avPpflrCq+n6yWmzFpmz8vJPOCFNP8lKQQX3OkCmQ+fv/jv3/8Hr0m05yGgCDSxOpPP/z5D6JJqToDKArvqbhypEuSv36H3qbi1ZWvf/m74HBKHtABlSaILa9i86d/1SuoXMY5T2Ygn9MZOiIF3d1bbtReLJUTtfd3CadDtLOfMzI4gMR+l9zttPiEQH1RZIJXMusXyUkSkJgeVauM3+7uUI5fHuz0FowbSYL7JulltbpCOkdj6C1ACx2H7JYVsFQ1hitL4owG4ESQ8WnvEeWFCjG0RHWsgQJfXCTQZcyqTixHOaUTkWF8iiR6oXAJKLg1ylPQnvgx7UMO/OmHP34nIRyip/MajBIJI8RCbWKJxlkOh+HvF7XsHHpdmo0k5+dIhVVR0XcrZECJCUoi+cz3qgRQ74RwWixXCZyFz5o94cYru1HGILTih5HcgTzfbImVFmnlk8JNVxhUyxvn6uKwdOQPDfmNENO8SlIWod3dtoTnz5G7ek6ueXvos8+Ehb+AF8dzLcN0LG9vkf8Wt/VLuK6Pv/8HoCuMKNHHv/0TfjealTXKgmYVZU2uQhosu8pW62yvrmELkZ+qX9BHhV5gBtgKTYpN14iw76oqjrwgok6gU9tp9bTHkQzHramFRauJxd1W61cKDlxQyBbvrS3lfqlvT4lpVLyrmycQEoA4qKZC0j1d5F5pI4lZSCr5Sg7RGBSym08mPuNE9PbQPvFQWRX7QXZZWbU/X1iXy2CW9VHsVTyhMou+rFxVqemMW5cBmaHOB3tQzIBPJiaqBYnWNRrqrRpgmp4L45GOI9O3sSgH2HNcgi03CLwo9P3QbrVkV4QVyFBFf7v1fmZwZq2n8NRtPQWUkdYY21Ogh5yKCdBQN/vIZngJVN9WXWrB8EJsMbzAKGsYJjYsH3aoR3yNtIaXJEnROeD16bKVQwkujvkBKWBWzzcLmGd/ws18QXnBvlm9LghauJp1i4ylPSqMGYRoMGC4jgZ9setgL6AUO05guF4A9+ObG4X4QoY08rYaU82fHcGi/v+CJU6SnP6PY6XCaTM2vE/FBrF9E1KTje1IhbylkQC7oWZhJ3RU1zYi2/Ta34HIPRVV8WKaEoH/didrDqzdjNs1FYtSeizUyaupflR9JZDBDyzkp6D8Lau+OMBvaV7efCaStHXtXpzfRGm1GEpvbdNLEB8hb0Bepat1ZeF20jo4bjqG0gVS7bH0gr6739f9c3tGro7su6vWBdSnF4Pp6OgA119CRnAFXV9DbqTXcRosPXxRfcSkDSM6wAg48qpBfewriDzcUxgP6dfKUC1vbkDayoelLo6P99TrPHuNJo+ktE5NVobCLk06M3snq/WxvItb9wzayW49m3UC/1+bu/5Ntotr92e/Tn4dN9/FcesXi26mm1Z1Yrk1r2xw7W141maReOwSVv2wS5mN5qyDXVn+B02IZRtSFwAA


name: Automated Website Change Monitoring with Bright Data, GPT-4.1 & Google Workspace
author_name: Daniel Shashko
author_username: tomax
categories: []
created_at: 2025-05-25T11:58:15.627Z
updated_at: 2025-05-25T11:58:15.627Z
url: https://n8n.io/workflows/4382
scraped_at: 2025-12-24 13:02:45
description:
  Note: This template is for self-hosted n8n instances only

  You can use this workflow to fully automate website content monitoring and change detection on a weekly basis—even when there’s no native node for scraping or structured comparison. It uses an AI-powered scraper, structured data extraction, and integrates Google Sheets, Drive, Docs, and email for seamless tracking and reporting.

  Main Use Cases

  Monitor and report changes to websites (e.g., pricing, content, headings, FAQs) over time
  Automate web audits, compliance checks, or competitive benchmarking
  Generate detailed change logs and share them automatically with stakeholders

  How it works

  The workflow operates as a scheduled process, organized into these stages:

  1. Initialization & Configuration

  Triggers weekly (or manually) and initializes key variables: Google Drive folder, spreadsheet IDs, notification emails, and test mode.

  2. Input Retrieval

  Reads the list of URLs to be monitored from a Google Sheet.

  3. Web Scraping & Structuring

  For each URL, an AI agent uses Bright Data's scrape_as_markdown tool to extract the full web page content.
  The workflow then parses this content into a well-structured JSON, capturing elements like metadata, headings, pricing, navigation, calls to action, contacts, banners, and FAQs.

  4. Saving Current Week’s Results

  The structured JSON is saved to Google Drive as the current week’s snapshot for each monitored URL.
  The Google Sheet is updated with file references for traceability.

  5. Comparison with Previous Snapshot

  If a prior week’s file exists, it is downloaded and parsed.
  The workflow compares the current and previous JSON snapshots, detecting and categorizing all substantive content changes (e.g., new/updated plans, FAQ edits, contact info modifications).
  Optionally, in test mode, mock changes are introduced for demo and validation purposes.

  6. Change Report Generation & Delivery

  A rich Markdown-formatted changelog is generated, summarizing the detected changes, and then converted to HTML.
  The changelog is uploaded to Google Docs and linked back to the tracking sheet.
  An HTML email with the full report and relevant links is sent to recipients.

  Summary Flow:

  Schedule/workflow trigger → initialize variables
  Read URL list from spreadsheet
  For each URL:
      Scrape & structure as JSON
      Save to Drive, update tracking sheet
      If previous week exists:
          Download & parse previous
          Compare, generate changelog
          Convert to HTML, save to Docs, update Sheet
          Email results

  Benefits:

  Fully automated website change tracking with end-to-end reporting
  Adaptable and extensible for any set of monitored pages and content types
  Easy integration with Google Workspace tools for collaboration and storage
  Minimal manual intervention required after initial setup

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleDrive","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.googleDrive","n8n-nodes-base.extractFromFile","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.markdown","n8n-nodes-base.googleDocs","n8n-nodes-base.googleDocs","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.scheduleTrigger","n8n-nodes-mcp.mcpClientTool","@n8n/n8n-nodes-langchain.outputParserAutofixing","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.convertToFile","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 14556 characters]


name: Remote Job Updates Pipeline with RemoteOK, Airtable, and Telegram
author_name: Puspak
author_username: dpreddy
categories: []
created_at: 2025-05-25T15:04:37.907Z
updated_at: 2025-05-25T15:04:37.907Z
url: https://n8n.io/workflows/4383
scraped_at: 2025-12-24 13:02:45
description:
  🚀 Remote Job Automation Workflow
  Automatically fetch, clean, and broadcast the latest remote job listings — powered by RemoteOK, Airtable, and Telegram.

  🔧 Key Features
  Seamless Data Fetching:
  Pulls the latest job listings from the RemoteOK API using an HTTP Request node.

  Smart Data Processing (via Code Node):

  Filters out irrelevant metadata

  Cleans and sanitizes job descriptions (e.g., HTML tags, special characters)

  Handles malformed or encoded text gracefully

  Extracts and formats salary ranges for clarity

  Airtable Integration (Upsert):

  Stores each job as a unique record using job ID

  Avoids duplication through conditional upserts using Airtable's Personal Access Token

  Telegram Bot Broadcasting:

  Automatically formats and sends job posts to a Telegram group or channel

  Keeps your community or team updated in real-time

  📦 Tech Stack
  RemoteOK API – source of curated remote job listings

  Airtable – lightweight, accessible job database

  Telegram Bot API – for real-time job notifications

  n8n – workflow automation engine to tie everything together

  🔁 Workflow Overview
  Fetch Jobs from RemoteOK API

  Clean & Normalize job descriptions and metadata

  Extract Salary ranges and standardize them

  Upsert to Airtable (avoiding duplicates)

  Format Post for visual clarity

  Send to Telegram via bot integration

  🧠 Perfect For
  Remote job boards or aggregators

  Recruitment agencies/startups

  Developers building personal job feeds

  Communities or channels sharing curated remote opportunities

  Automating newsletters or job digests

  ✅ Benefits

  Near real-time updates

  Minimal maintenance

  Full control and extensibility with n8n

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

workflow_json_compressed:
  [encoded data, 5472 characters]


name: Shopify VIP Alerts: AI Summary & Slack Notification for Big Orders
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-25T15:45:32.862Z
updated_at: 2025-05-25T15:45:32.862Z
url: https://n8n.io/workflows/4384
scraped_at: 2025-12-24 13:02:44
description:
  🧨 VIP Radar: Instantly Spot & Summarize High-Value Shopify Orders with AI + Slack Alerts

  Automatically detect when a new Shopify order exceeds $200, fetch the customer’s purchase history, generate an AI-powered summary, and alert your team in Slack—so no VIP goes unnoticed.

  🛠️ Workflow Overview

  | Feature                | Description                                                                 |
  |------------------------|-----------------------------------------------------------------------------|
  | Trigger            | Shopify “New Order” webhook                                                 |
  | Conditional Check  | Filters for orders &gt; $200                                                   |
  | Data Enrichment    | Pulls full order history for the customer from Shopify                      |
  | AI Summary         | Uses OpenAI to summarize buying behavior                                    |
  | Notification       | Sends detailed alert to Slack with name, order total, and customer insights |
  | Fallback           | Ignores low-value orders and terminates flow                                |

  📘 What This Workflow Does

  This automation monitors your Shopify store and reacts to any high-value order (over $200). When triggered:

  It fetches all past orders of that customer,
  Summarizes the history using OpenAI,
  Sends a full alert with context to your Slack channel.

  No more guessing who’s worth a closer look. Your team gets instant insights, and your VIPs get the attention they deserve.

  🧩 Node-by-Node Breakdown

  🔔 1. Trigger: New Shopify Order
  Type**: Shopify Trigger
  Event**: orders/create
  Purpose**: Starts workflow on new order
  Pulls**: Order total, customer ID, name, etc.

  🔣 2. Set: Convert Order Total to Number
  Ensures the total_price is treated as a number for comparison.

  ❓ 3. If: Is Order &gt; $200?
  Condition**: $json.total_price &gt; 200
  Yes** → Continue
  No** → End workflow

  🔗 4. HTTP: Fetch Customer Order History
  Uses the Shopify Admin API to retrieve all orders from this customer.
  Requires your Shopify access token.

  🧾 5. Set: Convert Orders Array to String
  Formats the order data so it's prompt-friendly for OpenAI.

  🧠 6. LangChain Agent: Summarize Order History
  Prompt**: "Summarize the customer's order history for Slack. Here is their order data: {{ $json.orders }}"
  Model**: GPT-4o Mini (customizable)

  📨 7. Slack: Send VIP Alert
  Sends a rich message to a Slack channel.
  Includes:
    Customer name
    Order value
    Summary of past behavior

  🧱 8. No-Op (Optional)
  Used to safely end workflow if the order is not high-value.

  🔧 How to Customize

  | What                     | How                                                                 |
  |--------------------------|----------------------------------------------------------------------|
  | Order threshold          | Change 200 in the If node                                       |
  | Slack channel            | Update channelId in the Slack node                                |
  | AI prompt style          | Edit text in LangChain Agent node                                   |
  | Shopify auth token       | Replace shpat_abc123xyz... with your actual private token         |

  🚀 Setup Instructions

  Open n8n editor.
  Go to Workflows → Import → Paste JSON.
  Paste this workflow JSON.
  Replace your Shopify token and Slack credentials.
  Save and activate.
  Place a test order in Shopify to watch it work.

  💡 Real-World Use Cases

  🎯 Notify sales team when a potential VIP buys
  🛎️ Prep support reps with customer history
  📈 Detect repeat buyers and upsell opportunities

  🔗 Resources & Support

  👨‍💻 Creator: Yaron Been
  📺 YouTube: NoFluff with Yaron Been
  🌐 Website: https://nofluff.online
  📩 Contact: Yaron@nofluff.online

  🏷️ Tags

  #shopify, #openai, #slack, #vip-customers, #automation, #n8n, #workflow, #ecommerce, #customer-insights, #ai-summaries, #gpt4o

nodes_used:
  ["n8n-nodes-base.noOp","n8n-nodes-base.shopifyTrigger","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.slack","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5860 characters]


name: AI-Powered Calendar & Meeting Digest with Gmail and GPT-4o/Claude - Daily Brief
author_name: Nick Loui
author_username: nick
categories: []
created_at: 2025-05-25T19:43:04.061Z
updated_at: 2025-05-25T19:43:04.061Z
url: https://n8n.io/workflows/4385
scraped_at: 2025-12-24 13:02:44
description:
  🛠 How It Works

  The Daily Calendar Brief is an automated n8n workflow designed to prep you each morning with a rich, executive-style email summary of your day. It pulls data from your calendar, email, and external contact sources to deliver a contextualized, prioritized briefing.

  Daily Trigger

  Runs every weekday morning at 7:00 AM using a schedule node.

  Calendar Parsing

  Grabs all Google Calendar events for the day and extracts details like:
  	•	Event title, time, and duration
  	•	Full attendee list
  	•	Meeting description

  Attendee Intelligence

  Filters for external attendees and:
  	•	Scrapes recent email threads with them
  	•	Uses Hunter and LinkedIn to enrich attendee info with roles, bios, locations, and recent activity

  Brief Assembly

  Combines:
  	•	Event metadata
  	•	Attendee research
  	•	Recent conversations


  Email Delivery

  Renders the Markdown as HTML and sends a polished email to your inbox with:
  	•	Meeting timeline & attendees
  	•	Key takeaways & extra context
  	•	Conflicts & FYIs

  Setup Steps

  Prerequisites
  	•	n8n instance (self-hosted or cloud)
  	•	Google Calendar and Gmail OAuth credentials
  	•	OpenRouter key (for GPT-4o or Claude 3.7)

  Configuration
  	Authorize Credentials
  	•	Connect Google Calendar and Gmail nodes with OAuth2
  	•	Set up OpenRouter credentials for AI processing
  	Set Your Email
  Update the Send Email node with your preferred destination address (default is you@yourcompany.com).
  	Set Your Domain Filter
  In the “Identify External Attendees” node, adjust the filter value yourcompany.com to your actual domain.
  	Customize Prompts (Optional)
  You can fine-tune tone, formatting, or limits in the two language model nodes:
  	•	Research and Develop Brief (attendee context + email summary)
  	•	Summarize Schedule (overall Markdown brief formatting)
  	Activate Workflow

  Enable the workflow and test it manually once to validate your setup. Confirm that the email lands correctly.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.markdown","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.googleCalendar","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmail"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VX72/bNhD9VwR/DjOSovgjn7amAVagWbek2IANxXAkj45QWTJkOW0a5H/fyXYj25FjF/tgQ7JOx8f37h7Pj5MyTi4m9WXNv/39R1UoezN90+nJ2WSGHUwuHidlveigDviuj8Pgc+OlVUVKkLukjfKoouSy8EUBMbpgLepktEGJSXNh86hEwCQLmwdBeTuczSvo8LLFuLjFbjm/bOgX7JAW6NolPp1NapghrfYWyuohu4QK6wht9qYtMfUZYLqYXPzzieKaiP3l43oXmFvnIweWgnZMGUTmI2gGIXHMo7Be9DvbZP8wx/qmWXbYZpd30GXXlKzq0z/M+8c/17b+iT5stQiroJ6GOyjr82rWhw9v0yvzZlF2ZVMTFMftmbCcwM2hpYUogBA+Pq3z/kl3qzjxdLYBzXUSTitkNtfIlI6KWYiO8ciT5KjzwrgB9DW2U8yu7rHuFgPWAaaHBZ4HutxFJWShz5g6Cks+w4rOgUzOs+hEzhRyy5woLCs4N96bQHTCES7F/yZTFFr9GJvWQLBSGGYK4ZlS0TLgLtJtQOEt5FSjA+zb5WwGbfkNs9twh3FZ4QmQV9/vq9keVGVOYlic62ewykehXODMehmYysHRVfDMWcNFDBZSlFvSQ/s5Nl/qrGuyXz9evz8o/2wTuAfQFvIkgEMJWEmS68CkAEMlQF/eAzLHTfQp50HxsMVl2Xdxdo2zpn04gcbZKvDNMiVs/yprAryHl8vTOuk8f0ZMJmQLLzhLAhJTQnICqxKTusix8Lm1Jt9C3JXh80P2W9PhQS4Xq5hNyBY6Ssl7Nl/Am4Sm7qg7KdXkMLXS9XSSU3EliVowgoFzmiXqLC4NdT1uKX+zrLOVFx6GuSnfj205ne53EZOSn1aaQ/tLDj4UKmfCa0naS6rKPFd064BDLHTK0xZAhDj49BF3mjbNtMLv0btQT8Q5KO5iKLQuHIsyaqZCsMyjSyxHRwdBIcn4tmr0d2gXmP3SkUAR8TDExbwquw/LbhfcqTQ+g/O5AyV1zvIYydpl4swnMlJjqOtzmXySW+X4LhJtZXrIrr5S5hqqE4CmsnphmkqdBFNuqe0dHekhOJZior6R6BnkhsoxFs5JoZTSck/t93SEL7rsakZ1+YrW/WN62tRXbdu0FNC3R1kv8QanywpaInm+z7PW3zfwBf1d03xejR7BRRorwDOOnpQm0ZmlWiSgLhYKg9VYTI7ueRDH6cBBG6pwY6jCOV2BocwYo6eSMlTtsL3nBUIb7jKoY/YW77Fq5sNAcsTqYNobwg+yYO2JzeCG88Q6GyUERqL1808umVO8YJJGrxiVTghbMt5Sba31OyrfdhNwI0fUMUoSXwZorQhMWTIN671kXCIdPDbRSYanqENpIXTlPa5nwbPJAjtiarqyVvyKYdnj+NBG7Gm8F73H3q8TrAdUpS1I65hEZ3o/6MlQllmBUlgRyC36aYr4rzH0qVaJB4OlG9pzv1EaKnsmjrrbKvyMxuSIXycX/OnTJ4K0M6aN5Xxt8hjNuHu8Ukoo/51tbnawHq/T4c39Rfb9cQz5STY1Tsr+ADNKzEhVjmYbcaFx8Y4TMk74S4XG8h+eyg6j3q+lsbwHj6rRtOP/ZdZV0vvQkixo89uPF8tugpOWFkfXfq0Bjq75CvBRjUb/NI0S+Vp1H/SGA2fhyAJPT/8BVngG43EPAAA=


name: Notion Status-Based Alert Messages (Slack, Telegram, WhatsApp, Discord, Email)
author_name: Matty Reed
author_username: mattyreed1
categories: []
created_at: 2025-05-25T20:54:15.469Z
updated_at: 2025-05-25T20:54:15.469Z
url: https://n8n.io/workflows/4386
scraped_at: 2025-12-24 13:02:45
description:
  Notion Status-Based Alert Template

  Who is this for?
  Teams that live in Notion and want an instant ping to the right person when a task changes state.  
  Perfect for content creators, project managers, or any small team that tracks work in a Notion database and prefers Slack / Telegram / Discord / e-mail notifications over manually checking a board.

  What problem does this solve?
  Polling Notion or checking a kanban board is slow and error-prone.  
  This workflow watches a Notion database and routes an alert to specific people based on the item’s Status. One central map decides who gets pinged for “On Deck”, “In Progress”, “Ready for Review”, or “Ready to Publish”.

  How it works
  Trigger – choose either method  
     Polling (Notion Trigger) – fires every minute.  
     Push (Webhook) – register the production URL in a Notion automation and disable polling.
  Set Notion Page Info – copies Title, Status, URL, etc. into top-level fields.
  Switch (Status router) – routes the item down a branch that matches its Status.
  Set-Mention nodes – one per Status. Each node sets a single field mention (e.g. &lt;@U123456&gt;).  
     Add or edit these nodes to map new statuses or recipients.
  Build Message – assembles a rich text block:  
  Task title
  Status: 
  &lt;@UserIDs&gt;
  &lt;Notion URL|Open in Notion&gt;
  Send nodes – Slack (active) + optional Telegram / WhatsApp / Discord / Email (disabled by default). All reuse the same {{$json.message}}.

  Setup steps
  Import this template into n8n.
  Connect credentials  
  Notion API token  
  Slack OAuth (and any other channels you enable)  
  Edit the Status → Mention map  
  Open each Set-Mention node and replace the placeholder with the real Slack ID / chat ID / phone / email.  
  Copy a node for every extra Status you use, wire it to a new Switch output, and update the value.
  Set environment variables (recommended)  
  NOTION_DB_ID, SLACK_CHANNEL, EMAIL_FROM, etc.
  Pick your trigger style  
  Keep polling enabled or disable it and enable the Webhook, then register the webhook URL in Notion.
  Test – change a task’s Status in Notion → watch Slack for the ping.

  Example output
  &gt; Title: “Draft blog post – AI productivity”  
  &gt; Status: Ready for Review  
  &gt; Slack message:  
  &gt; &gt; Draft blog post – AI productivity
  &gt; Status: Ready for Review
  &gt; &lt;@U789012&gt;
  &gt; &lt;https://www.notion.so/…|Open in Notion&gt;
  &gt; 
  Extending the flow
  Wire additional channels after Build Message—they all consume the same {{$json.message}}.
  Add richer logic (e.g. due-date reminders) in the Set Notion Page Info node.
  Verify Notion webhook signatures in a Function node if you rely on push triggers.

  This template is the leanest possible setup: one table of statuses → direct pings to the right people. Swap the IDs, flip on your favourite channels, and ship.

nodes_used:
  ["n8n-nodes-base.emailSend","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.slack","n8n-nodes-base.telegram","n8n-nodes-base.whatsApp","n8n-nodes-base.discord","n8n-nodes-base.notionTrigger","n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62XyW4bRxBAf4WYUwKwjd4X3Rw7ThzAsWIbMZDAh+ruanogakiQI8mGoKs/IJ+YL0kNSUvcRiRj34ac6ppXe/VtVefqrJJvfvn1PP2hX4vLF7PfzF/VsLrEFqqz26pu5i00CV92cs6nbJTJPknPUygqiCySwALoRIwqcm6s5FkEJ0N2sQSSTxqF4QExStLb4uV0DC0+m2Gev8X2avpsQv9gi/SBdnaFd8OqgUukr/0+aetJM/j3yz+Dp2OctYNXOJ/DCDstMJpXZ39/INlJxu7xdmmJ8RlskJEBomc6AmchWs0M+BgQhJQiVvdfeItNHvx8CfW40/l52v3X+IYtlLIIc3yC3dtOjiRyPYc4/go6rKaTed0h0ueZ4nwotOWENIUZqW9xRly3d0vFf9KvhaS4G65QgyUXuUJsMRNq8J4F7jVzToH02mgLbh21Hawcck4+GLxsyqQXeo5ttYknjOdDJw/iyXs8r5T3DhwrxjumIUkGWVmmlC1cZqO9Fw94P13V47weoCO5rD0RS1uBjlvPok2JaVSZQfTAnHUxWK6MdmbNazd1mz7283x9veEq1THxg0zqyQNViNxpUZABWM40R2QePWc8qlzIkVnzuBnL183gOaaLU0LIKcXs4Qx7oFLJJR2jZFn5zleGM++NZwK8IWXRFYBNqpeUXbPJaEZxPJXMn0IWMDvA4hikEJkWQjBfcmSxuKwi5VYBvUn2BiF/HryYzOjpusabU/EEP4WPF1QqxsAo0wvTUioWpQtMa2USahFRxH187yaD86s4rueP5FwPnzyFzxQvuBOKFcyUb1lkFhELs9ykjK4UX/hWm3s7hnQxeDUf9ZN1EtVuW1vm3A3Gj5PJxWIOQOKc0loyFRUwrajBRiD3BB9KVAm7ll8dMuaJujfHYjGhWEmZIJFaoaXy0dEyx0PCUox1wm6Z8w7HOCL1j1rUroSO6N1+10gabigshT8ARV66wgJQMXGLDqRzPhp3yMiHbm+z9eQiy2IShlzmyVuy85sLFPpskUuzZeL7j9DOn06nj5p4sxI6ZjzxHRtz1iGAdYyyhjqEtIH6VuLUxpzhGsHKkI63UfuIPGNm3CXymA000bpZnDQoIRO31uGWjc/reZrM8qMm5qXMMRbKHQuN5BQ+l5hXXtBCQPMWpCo0PrIxqoAt4A+m6kMUDXUBriMrTimykJOrdLKM2pkUtBlxhLW+sJrX72b1aISzwQ/nk/G4bkY/9lraLA6s5Le7hJdUivqEBYMaqgRuAnNCUJUGSj7QGaloS9TSuyCV6od9v3RiP+zKywfCssD2cjss3iGxRcOk6Moh0cCESE8m25S584Xq/viw6OQUZZpjWWjSlo1gpKwwozUtohFiUevtuq3Txedum3pkU1nIrETW7ZFds1a7YajSpGmxaUlV9UgXSCJYVRIljKalKlqguVIESyk7zwEzbsy9B1BxOqnQ8htIpYACEmjpS1l0LdAxbynxTaD5XETICfheUnk6qfs/oCQNqa2v6UMFxnNKO5qsLZXX4ih+wnTV6X89y1RKZ9W16HRcL88vU9ACRO4zbbRUFNqQmZFrzmKIQrgsk9bd0CGIBlOnaqF4tVHSE10MOnq6eXQ29q11C6khXaMyfqrOOGFvHti7cR061L8MHXdy35qyc/ID+WvdpH0m96z9e3Vtyu534P49ZVvdcPPE/lXgwKH9w/XAoa2r4gHpvbOt183rifCtrt57Wdzr8a37Ua+2nYz7Hog7yfitSnsHbl+59t+oj9J/PyO/i/67u/8ADWdVMI8RAAA=


name: Smart Knowledge Base with Google Docs, Discord & GPT-4o-mini
author_name: David Ashby
author_username: cfomodz
categories: []
created_at: 2025-05-25T23:06:04.917Z
updated_at: 2025-05-25T23:06:04.917Z
url: https://n8n.io/workflows/4388
scraped_at: 2025-12-24 13:02:45
description:
  Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator?

  Join the community

  🧠 MCP Memory Core: AI-Powered Knowledge Base
  Store, retrieve, and act on organizational memories using Google Docs + Discord. Part of the MCP ecosystem.

  Advanced toolchain with multi-platform integration

  🔍 What It Does

      📚 Save Memories: Log conversations, decisions, or code snippets to a Google Doc (timestamped).

      🔍 Retrieve Memories: Fetch past context for AI agents or workflows.

      📤 Auto-Send Updates: Push memories to Discord channels/DMs via GPT-4o-mini formatting.

      🤖 MCP-Compatible: Works with your existing GitHub/Discord MCP workflows.

  🚀 Key Features

      🌐 Multi-Trigger: Use via:

          save_memory / retrieve_memory API routes.

          Discord mentions via MCP Server integration.

      🔐 Secure Storage: Memories live in your Google Docs (no third-party DB).

      🧩 Modular Design: Swap Google Docs for Notion/Airtable with minimal changes.

      🤖 AI Cleanup: GPT-4o-mini reformats raw data into Discord-friendly messages.

  ⚙️ Use Cases

      Team Knowledge Base: Archive meeting notes accessible via Discord commands.

      AI Context Window: Give bots long-term memory for better issue resolution.

      Audit Trail: Track project decisions with timestamps.

  🛠️ Setup Guide

      📝 Configure Google Docs:

          In "Edit Fields", set sheet_id to your Google Doc URL.

      🤖 Discord Permissions:

          Update discord_server_id, discord_channel_id, and discord_user_id.

      🔗 Link to MCP:

          Use the MCP Server Trigger node to connect to existing workflows.

      🧠 Customize AI:

          Tweak the AI Agent prompt for different formatting styles.

  Works great with the $1 GitHub MCP Server template!

nodes_used:
  ["n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.googleDocs","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleDocs","n8n-nodes-base.switch","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleDocs","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool"]

workflow_json_compressed:
  H4sIAAAAAAAAE7WXWW/bRhDHvwqhZ6+79+GnGnYKBKjRIk6ah8Io9piViEikQNFxDMPfvUO51klZtOO+CBKxmvntf04+jGbQ+tHZw6isFq2vInxMo7ORdYKBSUE5HrnTNAJXwlIGnjsaWYpag5TGCBlBJKetYFRopbWKkKOlo5NRC7P51Ldw0UBaXEN7O7+o8Qm0gA7a5hYeT0ZVnWAxOvsbvXdeNWOehyCJdY4RyaQkHr0RY72KAXJwWqPlys8AT3+dQFV8+AHxFk0W4b44r+p2Ak3xtW6+5Wl910Hcz7ujla3I0hcJfgGn8PSn53Ofm3I8hgaPz+tF2ZZ1hUjS0hMj6Q0+9A06bKFB0ofHJ5t/4a/lOXbKHk+e8QOjPstIZLCOyIT4TqpMjHPeqwyKBljjX/vvUPxeV+PiMzSz4gpmdVOiGoegx3U9nsJlHRfboIxxJKVHSfmKk4MDKhgjKHYm0gpADwy/0Sgks0zEZLc5U9HAYl5XCziIt4B2h0vQQVziVK7IBHNRZOpJ5EoTGWMkwSAoy0FFyjPYLNdkn5ZMqbgr20kx7ZRsOyVnx5TsR3WvQwXmDBjtSIIYEFUFREUlmfGdvimLtIXaItI7BnwA7TrgNjuIhmaSpONEciNJiJwRQaPm3irAil6zLsHui891PS0+1VgnzWElUfo42cazfFDhiNM1nzGUs+gzoTIDkYJaYqXVJLiUfUohJbnB9yGVbfFbCdP0ihBrOZBqHWHHFM1GAYlaCiIVtiRrqSI+iJyF5QyjvFPO+zH9FcF+WcNNfTWOE19Wpy3Ku9GodjoPY3ZA61krmDD/qJaBgNaJSIiZOOY0ottAvUIhU+jJxnfh1foNvFyCZRlRqfJESucxI4MhNPFsdMboh7ihLWCVP7MWbV1clotYN+mnsK18PTYESAJTknilDRYSA5Q5YIZEK7gF4E76NbasyaysygGU09nFxLd/zKE6L3eKnXfq4sdrMCPLOLSTJDRzS6SGrp6cIdHK5Hiwyrq8Ue8XfxbX0HzHybmehMeIZ3HeOzYV4rplnd1BmNT1t+U6waQ1xmA+WuxAOB4T6maxbfJAhUoOHAZ9dOyCq+sFa3DZ0Jgy0mPyKGmI07HLIA/dFpJY2rje+cfifAxVO+BS/r9zW/p31UiHpIlbASrunQWpSAaDe0xKioSEvEIGLSPFrEtq0GzYT/TXzIjuY/iQ8C5FAyqRpHE0SAqdql4SlSWl2lFltVhDX14VXxYvTIb0BN4NkR0yxVcJvZkiAbuqyYIT9INBNblbSkwgyVkbcPNjmqpjKbLRXyBybrjDDMMtTNpIifOaEm0c5YEL7D12p79gW8EirCqYvuFSKNH/dyk0GmsEi5237siqs+BXX/7TJfAt5u4Vkk6RBtfpDro39/eOn+Din+DH6Iw+3tyg7+fAPpnu2udxi+2TINuGNsc0GpthgW1ZemnNWB7eNbg9YQ/wvdTMDpHuhv+nr74/X9+Rtke3PnmPvl7saXyy/vOgdfWNBvZ72uFo97g/dNe+V5R+w4eWiXeM0Uv69V1g8JtM742Ovwj3+exdo3vtDwlmn4f9gukx//j4L72M4AeDEAAA


name: Collect Conference Feedback with Forms and Log to Excel OneDrive with Outlook Notifications
author_name: Akhil Varma Gadiraju
author_username: akhilv7
categories: []
created_at: 2025-05-26T03:43:21.953Z
updated_at: 2025-05-26T03:43:21.953Z
url: https://n8n.io/workflows/4389
scraped_at: 2025-12-24 13:02:44
description:
  Conference Feedback Collection and OneDrive Logging Workflow

  This n8n workflow is designed to collect feedback through a web form, log the responses into an Excel file stored in Microsoft OneDrive, and notify the support team via email.

  🧭 Overall Goal

  To collect user feedback from a web form, structure the data, log it into a OneDrive Excel file, and notify support via Outlook email.

  🔄 Workflow Breakdown

  1. Form Submission (On form submission)
  Node Type**: formTrigger
  Purpose**: Captures user feedback via a web form.
  Form Fields**:
    Full Name (Required)
    Email (Required)
    Company Name
    Job Title
    How did you hear about the conference? (Required)
    Overall experience rating (Required)
    Favorite sessions/speakers
    Relevance to interests/work (Required)
    Networking opportunities (Required)
    Suggestions for improvement
    Future topics/speakers
    Willingness to attend again (Required)
    Additional comments
    Contact permission (Required)
  Access URL**: /webhook/feedback (or /webhook-test/feedback during testing)

  2. Parse Data (Set)
  Purpose**: Renames form fields to snake_case.
  Output**: Structured JSON with renamed fields.

  3. Sample File (Convert to File)
  Purpose**: Generates a file name reference for search.
  Filename**: test-n8n-feedback-form-data.xlsx

  4. Search Document (Microsoft OneDrive)
  Purpose**: Searches OneDrive for the specified Excel file.
  Query**: test-n8n-feedback-form-data.xlsx

  5. Extract File ID (Code)
  Purpose**: Extracts the ID of the file from the search result.
  Output**: { "id": "someFileId" } or { "id": null }

  6. Check File Existence (If)
  Purpose**: Branch logic based on file existence.
  Condition**: If id exists.

  7. Build Sheet Data (Set)
  Purpose**: Prepares the data to match the Excel column headers.
  Only Runs If**: File was found.

  8. Append Data to Excel (Microsoft Excel)
  Purpose**: Appends the new feedback as a row.
  Workbook ID**: {{ $('Code').item.json.id }}
  Worksheet Name**: Sheet1
  Mode**: Auto-map from input fields

  9. Notify Support (Microsoft Outlook)
  Purpose**: Sends a notification email with key feedback details.
  To**: test@gmail.com
  Subject**: "New Feedback Submission Received"
  Body**: Includes key details from submission

  10. End Workflow (NoOp)
  Purpose**: Marks logical end of the workflow.

  📝 Sticky Notes

  ✅ Upload Target Excel File First: Ensure the Excel file exists in OneDrive.
  📝 Filename Consistency: Filename should match in "Sample File" and "Search Document" nodes.
  📧 Customize Email Content: Update "Notify Support" node with your desired message and recipient.

  🔧 Customization Guide

  🧾 Form Customization
  Change form title, description, fields, or path.

  🧪 Parsing Logic
  Update field mappings if form labels change.

  📁 Excel File Settings
  Filename must match your actual OneDrive file.
  Worksheet name and column headers must match in "Build Sheet Data".

  📬 Email Settings
  Update subject and body using variables like {{ $('Parse Data').item.json.full_name }}.

  ❗ Error Handling Tips
  Adjust email content based on file presence.
  Add an "Error Trigger" for advanced error management.

  🔁 Alternatives and Extensions
  Use Google Sheets, Airtable, or databases instead of OneDrive/Excel.
  Add Slack or SMS notifications.

  📌 Use Cases
  Post-event Feedback
  CSAT Surveys
  Employee Feedback
  Bug Reporting
  Lead Capture
  Contact Forms
  Webinar Registration

  🔐 Required Credentials

  1. Microsoft OneDrive (OAuth2)
  Used by**: "Search Document"
  Credential Name**: Microsoft Drive account

  2. Microsoft Excel (OAuth2)
  Used by**: "Append Data"
  Credential Name**: Microsoft Excel account

  3. Microsoft Outlook (OAuth2)
  Used by**: "Notify Support"
  Credential Name**: Outlook 0Auth2

  ❤️ Made with n8n by Akhil

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.set","n8n-nodes-base.microsoftOneDrive","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.microsoftExcel","n8n-nodes-base.noOp","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5592 characters]


name: Generate & Edit Images with OpenAI GPT-Image-1 and Share via Telegram
author_name: Alexey from Mingles.ai
author_username: alexx
categories: []
created_at: 2025-05-26T08:42:12.797Z
updated_at: 2025-05-26T08:42:12.797Z
url: https://n8n.io/workflows/4391
scraped_at: 2025-12-24 13:02:43
description:
  AI Image Generator & Editor with GPT-4 Vision - Complete Workflow

  Template Description

  Transform text prompts into stunning images or edit existing visuals using OpenAI's latest GPT-4 Vision model through an intuitive web form interface.

  This comprehensive n8n automation provides three powerful image generation modes:

  🎨 Text-to-Image Generation
  Simply enter a descriptive prompt and generate high-quality images from scratch using OpenAI's gpt-image-1 model. Perfect for creating original artwork, concepts, or visual content.

  🖼️ Image-to-Image Editing 
  Upload an existing image file and transform it based on your text prompt. The AI analyzes your input image and applies modifications while maintaining the original structure and context.

  🔗 URL-Based Image Editing
  Provide a direct URL to any online image and edit it with AI. Great for quick modifications of web images or collaborative workflows.

  Key Features

  Smart Input Processing
  Flexible Form Interface**: User-friendly web form with authentication
  Multiple Input Methods**: File upload, URL input, or text-only generation
  Quality Control**: Selectable quality levels (low, medium, high)
  Format Support**: Accepts PNG, JPG, and JPEG formats

  Advanced AI Integration
  Latest GPT-4 Vision Model**: Uses gpt-image-1 for superior results
  Intelligent Switching**: Automatically detects input type and routes accordingly
  Context-Aware Editing**: Maintains image coherence during modifications
  Customizable Parameters**: Control size (1024x1024), quality, and generation settings

  Dual Storage Options
  Google Drive Integration**: Automatic upload with public sharing permissions
  ImgBB Hosting**: Alternative cloud storage for instant public URLs
  File Management**: Organized storage with timestamp-based naming

  Instant Telegram Delivery
  Real-time Notifications**: Results sent directly to your Telegram chat
  Rich Media Messages**: Includes generated image with prompt details
  Quick Access Links**: Direct links to view and download results
  Markdown Formatting**: Clean, professional message presentation

  Technical Workflow

  Form Submission → User submits prompt and optional image
  Smart Routing → System detects input type (text/file/URL)
  AI Processing → OpenAI generates or edits image based on mode
  Binary Conversion → Converts base64 response to downloadable file
  Cloud Upload → Stores in Google Drive or ImgBB with public access
  Telegram Delivery → Sends result with viewing links and metadata

  Perfect For

  Content Creators**: Generate unique visuals for social media and marketing
  Designers**: Quick concept development and image variations
  Developers**: Automated image processing for applications
  Teams**: Collaborative image editing and sharing workflows
  Personal Use**: Transform ideas into visual content effortlessly

  Setup Requirements

  OpenAI API Key**: Access to GPT-4 Vision model
  Google Drive API** (optional): For Google Drive storage
  ImgBB API Key** (optional): For alternative image hosting
  Telegram Bot**: For result delivery
  Basic Auth Credentials**: For form security

  What You Get

  ✅ Complete image generation and editing pipeline  
  ✅ Secure web form with authentication  
  ✅ Dual cloud storage options  
  ✅ Instant Telegram notifications  
  ✅ Professional result formatting  
  ✅ Flexible input methods  
  ✅ Quality control settings  
  ✅ Automated file management  

  Start creating AI-powered images in minutes with this production-ready template!

  Tags: #AI #ImageGeneration #OpenAI #GPT4 #ImageEditing #Telegram #GoogleDrive #Automation #ComputerVision #ContentCreation

nodes_used:
  ["n8n-nodes-base.googleDrive","n8n-nodes-base.httpRequest","n8n-nodes-base.convertToFile","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.formTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.switch"]

workflow_json_compressed:
  [encoded data, 4228 characters]


name: Command-based Telegram Bot for Article Summarization & Image Prompts with OpenAI
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-26T08:42:40.893Z
updated_at: 2025-05-26T08:42:40.893Z
url: https://n8n.io/workflows/4392
scraped_at: 2025-12-24 13:02:44
description:
  Telegram AI Assistant: Summarize Links & Generate Images On Demand

  This workflow turns any Telegram chat into a smart assistant. By typing simple commands like /summary or /img, users can trigger powerful AI actions—directly from Telegram.

  ✨ What It Does

  This automation listens for specific commands in Telegram messages:

  /help: Sends a help menu explaining available commands.
  /summary &lt;link&gt;: Fetches a webpage, extracts its content, and summarizes it using OpenAI into 10–12 bullet points.
  /img &lt;prompt&gt;: Sends the image prompt to OpenAI and replies that the request has been received (designed for future integration with image APIs).

  📦 Features

  ✅ Works instantly in Telegram  
  🧠 Uses OpenAI for text summarization and image prompt processing  
  🌐 Scrapes and cleans raw article text before summarizing  
  📤 Replies directly to the same Telegram thread  
  🔧 Easily expandable to support more commands  

  🔧 Use Cases

  Research Summaries**: Quickly condense articles or reports shared in chat.  
  Content Review**: Get team-friendly TL;DRs of long blog posts or product pages.  
  Creative Brainstorming**: Share visual ideas via /img and get quick prompts logged.  
  Customer Support**: Offer instant answers in group chats (with further extension).  
  Daily Digest Bot**: Connect to news feeds and auto-summarize updates.  

  🚀 Getting Started

  Clone this workflow and connect your Telegram Bot.  
  Insert your OpenAI credentials.  
  Deploy and test by messaging /summary https://example.com in your Telegram group or DM.  
  Expand with new commands or connect Stability.ai or other services for real image generation.  

  🔗 Author & Resources

  Built by Yaron Been  
  Follow more automations at nofluff.online

nodes_used:
  ["n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegramTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.html","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VZy44bxxX9lQpjQLLAovr9IBwjE1mKBpASQSNbC48wqqquJkvT7Ka7umc0EgbIKtsACeBtNvmILPI1/oHkE3KquslpvkYjw14IIpvVdW+de++559Z8HC1kw0bTjyNV6oaVQh5no+koZCwPPD8SsSP9QOJjzjPuiZjHYZC5qRf6LPV9zt0gjrIwSPI4TIKEOa4MYl/ko/GokYtlwRr5qJaZPpFNu3xU4YlsJAw0dSuvx6OyyqQeTb+HdWPVz1jKpCdo4voBDfyY04RljGaCS5mKOBcsxM4lW0isflm1jZySR3Mpzkle1eSpLJYERhaszIwDV0uzrExKau1QzrScKONbWTXG7si+q4nKiSpFtVDljCyk1mwmCcCoG00uVTMnD+dmZ9HtTMy/2tjWhAlR1RleK66w67LSqlFViQNRN0qcsZs4b/CY1XC4kbU2MIuqzOwq+003Nd62CFywopUunPrdx49fvNNV+f3pqHfmdPQGXxr5vsGn62uYsos9LLau4UG1lDXrjI8611/D89E1lndIfAf79mf3etzDHTuR43EhaOqnIQ1yEVGec0lllOVh4qYykvEAbqmX8BqIn0ggYMF+Lsv2INKNLOQMRx/gbd7UJlYL1iAPiMV1hbiFml0wVTBeyBXc2uLd2hXyPTMZpLexDjxnTD3PgH0p+byqzm0SMx7GPpMJdUKJdHI5p1yKmCKNXM/3c+FwPtqOj0EZ7/7vn//6kTxYH/LBaXlafqsleftQt/CrviJfFao8//otaSrSPVIfJHwlwF6JQk5W69ViRr5a1sj9pls9k6WJlV2sFjjXxGx+9rg73PTstFzbmDfNUk8fPuwPPgEm+NXsyEjeNm2tNIwRoZorLRiCMB6JOWvs6Q+lkVnQfVLZKp1Y1uUkK54oWWQWCMCi5dkC8cRmz1l9nlWX5eiWdMpy33GdAEkk/YwGketRJrlPhev6SRolzPfkLdV70p/5swr4OJNlo3KFWlyDtpE4faE2c7kw2OP/VYDWUbNlQy6r+jwvqsud3HJQx86vX8e99z+zlH3h5I6f5TT0AqR6wh3K0jyiXpCGQcwDFjD3FuyPTRp+HvLfAAkBgrTZ+CnIbZqvEv8WtFOQph/8+mDD558JdO4mXs6YSx03dmkQpwFNYz+kvkiCNInQHXN+kDOP+sw7Wcf6M5nTYHl0TFcMkm3l8hXhDBHtQW+1rMmFYuTVzXZbqT2myTZpiih30yRNKI/8hJrWT7kfxzSLoyhwkphx5yBpDoIgkAkqg4/axMGxxFOVDaq1i8vSwL3+aRilIYGRL+7fW3lPXtVqNpP1vS8nCtpiYgxN+lhPzEsTlZFDbHZb6Tguc3wuaOhkArSVS8qhd6jjp3kgfcniLDsY0a5w/niT2H+qEBD5OZE1b1gCs/FqcJDdcqnlD63UDblkmqCVCJwawb8PfSXkvCoyvGjKmImmZcXO619uBR7d0tuJOw9zHoVeCt7wDIMkIU2ySFA3diDopJdy7hxulj/+57///tsKB7jWudB1PSQnXyjT73+DFRBZqv/Z9JaCZJXU5b0GZ0Q/6zuiJpmqQS/F1YSYLroDyNGLY00KdY5aahhXBRrgLgLfvnymJ79gS7wliRzPCTLT9kQOEg7CyKOpB/maR2Ecx4yhEQ74t8/k6boyyesuEp/Mm/7NQfo8gwSQpRVVOyIWTxGBGyu8aixDIwSNYj1JH+x8KfhhR1NFbu7JMMwoC1w0+RD8x5wgpG4YeFEg4iT2k500aZeWCbDrCvfRmzsiPPHWGAvGmevknMoEeRkkDqeMJy4VEQu8FPSU+APqfSIbMZ+SbyBaiordcO+jjoUOIm0k18uu3Ibdrt+mQ+zpq+fPSE9nHcTmKbL9QmVIfuRdJ2bxBC2mK2wcGovnkmUGlC2oHUPF3m7fa+tiRYQbdGek59mylhdKXp5VS9sZJ1jc8V//wOA5HmnQ1NPeqh27xqPOiRcbloZ20Vd7EFF7NT2adXjZ9mm0YPVBFQV7GE6cfb0yGISMRa7weJbQmEfIlth1wK0huDWJUgczpoyDQVm8MIpzSh6/b2rUMdL2fY+uwfuWgC2KQaT6tzVBsCGwDUNthspsNsYoIYrWTG6kZBdq1rEK6mSBdZ2M6YhoK1KJtz9QG5APdYXs3HkKJ28yr3+IFd8ZTO0OF/0ngH8ur/Cm5VaQl8bwXIALq9qwdJUZ2aDP1XL11BxaX8zGhO1VLoNo+G4iOGcx9b3AoUGQo8nLKKW+j6LNuCvSeNDpjo6na0I/rFx+j2g8vIlIwcoZ2FSVE4BQHqlBYJBLmvzZPD02CkXU0s5AGLTrFqxdo3BWKsYWD3LF9Qhvi0I2ZFkpE5d1rfUIDhRQD9cwWJGzP1i27xg2+zg6OzMV1pVFP+oUSg+zfXS9VVArbt0KWp9jplxP1uOgdRUDSi3XObhmCS7BuaBiYOE6P/3lHzgs1giFdrdx6Al5XGrAQyQT8+4ZwaxnEEOikrZUIKs+Y5dV3TD8zvQSuUGqvFPfZTdx4wxj2LiQRj7bX0SFfeEN02OCrCO5qZwxWbB36Ca5Kk2B4LvZ3EgOnATNtWHnkl2yK3h2dFFBdNVyKRuLej+rS1t89dgcNseLluSJyY3WXq20qrEjvulZP7QKkrUtDUE1zFok/AoHyySwwJt0AXu1nZH7CpqelmRNibbAQXtd7iOrss7NvixNEh4tlb3gsnce2fPHbr54Xpw/ufrw5N0PN/luU1PZK50WEHp7Rt1JcjPsMqhFc2MSORHkUpr4kNJuTvMsCFno+AGLvM1aetHptl3JeNNtPrum+j2RCAclY6sNon3d3RdtXQOf4qqXW7ojyLpXtcRcAqI7mMwZSqltBRlHkAZ75rSNQsGmVVsLcyK7yeg2PEOH5UHOEpqJhGHswOyaeDyhuR8LN07dlHuD5n6Cmj+/gnI+rLT1cMmG+o0NLfjRrveXKsP4NzW0gR6pZnNUc4KJdFDbvyX2YmitqJ63RaPok7a0bE7+AIH1updTJmEfPHjR1jAupw8ekFdzpddiq+c/U8Eb8szq/znqoMBvC7P7cngXZjXu3vuLdcsaJMGk8+GkXRpiAOf0E76GO6clJW/t7eFbQsnJvLrUd7t8615c34JB7HxtdrB6S3YvrO/D9MrZnrqhJInRLv0mm1djlHw6nfUwhQfjz5fdSZ8YZJ9VMyXsCd3JDbi9iMVGQqoL41lRrHXyaelNVuDY+wtTM6K7HF5dT64I3CzpphNt+hhbGpVXGzndx60+Lf3JumNuRGlqteFPf/07VMirFyQ3mPVfoSjNjZsxbB6gWFcQm6+rsfO0DCY9g9yAY7nFDFr9aDjYw3q0+r7ahJR25BT25Q44UycmR7e3JgcIA2Dkqu8ph0hDG0hLrcx0iqZlwmBxtd39ZmyDl0hqrRZIPfwv6wsM0F2mo0R2p9nJLo9cv7E1WkqxviM6eFtt+j+4FExgZG7X8u/4lwT73niEtijfj6bO9Zs38OTwLPdLW7pVkO01dsfbp73Wbhfj+8zdTTDuNXY7LHc4256/RuwYGt8ShoOXz3dzd/P+9BA4d1cAe61+aqLdZ/aOI9XdTrkN0j6Ddx67Pys8B+6nD5bJJ5G+Q0p98mpvj/Xr6/8Da8GfClAdAAA=


name: Track Expenses by Parsing Telegram Transaction Messages to Google Sheets
author_name: Mujtaba
author_username: mujtaba
categories: []
created_at: 2025-05-26T09:38:42.548Z
updated_at: 2025-05-26T09:38:42.548Z
url: https://n8n.io/workflows/4395
scraped_at: 2025-12-24 13:02:44
description:
  Overview

  This n8n workflow template automatically parses incoming Telegram transaction messages and logs structured data into a Google Sheet. It’s designed to help individuals and small businesses track and record transactions shared via Telegram without manual data entry.

  Target Audience

  This template is ideal for:

  Individuals, freelancers, and small businesses who receive transaction or payment notifications through Telegram and want to organize them in Google Sheets.

  Anyone using self-hosted n8n (required due to custom community nodes).

  Problem Solved

  Manually copying transaction details from Telegram to Google Sheets is error-prone and time-consuming.
  This workflow automates the process by:

  Monitoring a Telegram bot/chat for new messages.

  Parsing transaction details (amount, sender, date, etc.).

  Logging them in real-time into a Google Sheet for easy tracking.

  Setup Instructions

  Telegram Bot Setup
  Create a Telegram bot using BotFather.

  Add the bot to the desired group/channel and grant admin permissions if needed.

  Note down the bot token.

  Google Sheets Setup
  Create a Google Sheet with relevant columns (e.g., Date, Amount, Sender, Transaction ID).

  Set up Google Sheets credentials in n8n for access.

  n8n Workflow Configuration
  Import this template into your self-hosted n8n instance.

  Update the Telegram node: Add your bot token and specify the chat/group ID.

  Update the Google Sheets node: Link it to your created sheet and ensure column mapping matches your sheet structure.

  Adjust parsing logic if your message format varies (see next section for examples).

  Community Nodes
  This workflow uses custom community nodes. Ensure these are installed via the n8n settings or CLI:

  [List your required community nodes here, e.g., n8n-nodes-telegram, n8n-nodes-gsheet, etc.]

  Activate the Workflow
  Save and activate your workflow. Send a test transaction message to your Telegram group/chat and verify data appears in your Google Sheet.

  Troubleshooting
  If messages are not being picked up, check bot permissions and the chat ID.

  Ensure Google Sheets credentials are correct and the sheet is accessible.

  Double-check that custom nodes are properly installed and up-to-date.

  Example Telegram Message Formats

  Received: $75 from @john_doe on 2024-05-29. Transaction ID: 12345XYZ.
  Paid $120 to @vendor on 2024-05-28. Ref: 67890ABC.
  You received ₹5,000 from @amit. ID: 54321PQR. Date: 29/05/2024
  The workflow parses messages in the above formats and logs the following columns:

  Date

  Amount

  Sender/Receiver

  Transaction/Reference ID

  If your message format differs, update the regex in the parsing node.

  Disclaimer

  This n8n workflow template uses custom community nodes and is only compatible with the self-hosted version of n8n.

  Workflow Changes (For n8n Canvas)
  Rename the Nodes:

  'If' node → “Is Transaction Message?”

  'Google Sheets' node → “Log to Google Sheet”

  (Rename other generic nodes for clarity, e.g., 'Telegram' → “Listen for Telegram Messages”, 'Function' → “Parse Transaction Details”)

  Sticky Note Improvement:
  (Edit the sticky note or add one if missing)

  Workflow Steps:

  Listen for Telegram Messages: This node receives new messages from the Telegram bot.

  Is Transaction Message? Checks if the message matches known transaction patterns.

  Parse Transaction Details: Extracts amount, sender, date, and transaction ID using regex.

  Log to Google Sheet: Records the parsed transaction in the linked Google Sheet for easy tracking.

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

workflow_json_compressed:
  H4sIAAAAAAAAE71Ya3PbthL9Kxi2M01ikeL7oU4mozhu447tOLaS3I7l6YDE0mJMkQoJ+nF19d+7ACiJejhtkpmrDzaJXezjAIs9xFzLmDbQ/pxkntPczuLJTXh68jnXetoUONUGcy0rak6LBI6FXhz64DtpHMRuYgZxEIaWZUc+pE4a2b7pRbEPSeAwB/zU993ACoCC7wdhELDAcwDtcpjOcsrhsAJWXwJvZocljgAHdMCrBhY9raBTQG+jihY1TXhWFrWYSW9qbXB1jfKSgXicq+iZyzzbC0w9SMDVXfAtnbo01s2QRkkSmokZmdrK6nEqbD3OxHMRFro0pse0BiMTollZZ8Il2seUejr+QZczWuF0DlUtQClnKqjBHKNNyoJly/eOSLtDbWnI7mk5pPwjzRvhFZ0k6O4SCuHpDlTeKijUyRhV/rWaV1nCNeljGmcF5WWFw7Rg2qbbJRJWlDi+Z8e644Otu07C9AgSWzcjK2GRGQUQOTi1nEGlbM2XSAhXxc1KpvyjC05xA4gIugm8nM9//lyXhTGFuqY3YHB44IsFzq6ym8laTVtcLxZtXissDHvRa8P1E/DdxHX11LVC3WW2qUepaekmhu+5oelCEK0X7veyvMmBXE4AeP3kGt5IrZVSZzUD84nVTMq8mbZLpkKfa29wi6pMiUpVDBCZ4yibborEgBINp2VT8A2hGlLiU6iSCd1SWA4qlUNaMXKEK4uL0dG6+qUj+OW69XZHs5zGiMlJNs34pv6WUM3BxaiTCUzpest0HfZ2dgPLaqzWx+UOreBLk1WiUlOa17CSn6kV2rTFIKVNzk8pTyarCQktXsOHGtiobAWq5ttoVgj9aCgdQ98TR7uQPxrFysz3xCC34I9G0Br5Hv9yn/+o/9bId63B1vb+4cXYsfctUeGpMaWzGTo+xcNGdB1IswJeQ17ei3YpVFF4uDxLRJ+iXHQ7PioPywKbAR9h/PXakRr8LYOc1aPyUmWlpIveZo/pnsoYBcgOUItDTiU31/76q8qXQExVhHlWiyzbM027ydhLU/YePALYBdSY+gcxSZtwPqsH/T4rk7o9QA3sOP16VgFl0k3dZ32L5967jw93ZzpcHJ/f0+by/qObBdPJ+2rmBzxPPl2EJ4n/+vf3/zX7gM3pp30u29WQJ7QlTiT02kyh4IJh/Js8viWM/2u6r5p69pJV2NFrdrs/a96lNKI3JrhfMfcMF11k3+1e74YNn9jDWSZpmKiI808Pb9+NaB09fnHOj51PT/RGQpNEnjs7zdc1/FV5WRaSOcp83WZRoLu+mepxZFI9Da3IDtMgidNk7WAEOdxg0yQjbPE3UD3Zf3mruNbrtGB31YHvIZ6U5a1kleCFUZBGjk4tP0L+Zvt6mNBQD2zTiiOgNPWott20mxnSJMkCtZaFaKLimOJENFdlJapnF+VljF1s3yfJdOjU3l3RfJlYfwR7Un8SVqvDaRLmukGUUj1GIowUzI/1KLBS3feoF/sMzDhK17b5FsXdC2kiymATx/AJKvO5PlQ1g4dLzYngZeQl+TkrZg03MjyNjB3eZuC5M332/NdxMS76ffJbWeFZRqwBGWtvIc9Lg/xZNqTGM4eT4dEbYkWGaRJUORxeHB2dkvOTD5ekLMhj2VREsPoMRYIIEA8jdKIX+EPq5QgdK+ybnkEOJZsFRtZH8muai6+MgXSB+8ExLNcYa+NCJZLKqCzMpb8RzXhcv3h2NR6znnF98Fy8US7HjINX8nVPYDh8IOe8+M+DmnRQFitDfTlkiPd/CHPTdz/bQtBGBMXrWOuCct4IXlID6XClATEjNyBDPiAnw4/Dy7fk4uhyNPxwMTwbEXzqkTcfXg+PiWITCiIrDMUyiPY+ILaHsPZt0/Z6xPIGnkW2el0Lay/wbCP0t2G1BazdeGRmmJhCFOPagLQNQz7uWwEZ0waevaXBub0YqH/K0laUe03uAOusgD2nj6JxiDTI0dm7Q3J5PDoilun7pEwVTLbcrYg4iQEKMqUMSFNjkhtbFWTe5D7jE7kWRgfAXITW4uegKAx29qUjAOwEs7kD093NYhy0Hp+9Ggin/8uK5ysNtS2Ngz0h7EUGv52JpB+/queyETU/X0hhlpJnbfFgtdf8mSj558/JfFwQ/Ml5qC0PAvmy1BYHgtBorakX8Ru3rHasDdT0K+u61xUvqfdawd5UkJCfNdMYqrWOs6kjNtFa6G4Kd+pxreldK0WR/YIAUimyhsD+Jgjsr0DQqZbvx2Ebx2+BQPDqbtZP4CPraq3nfw0d55vQcb6Czm7m1tcz37dBttF1/mWO7m6O841ICVRVWYn+dlaS26K8L0inDbclrYwBw1rvqTYq7YmSqoA3VUGu5kT00oE0u7hGqbZz17FiBY6Z+pGD7IpSQFaQRp4eWZavO6bDWAhmYPr2mhVc8iy5fSRnZfcDcIsU1FKnVelQAyQG7h5icJ8xjp8ykW32tAmIWxpkg+JF3PGAvJL4iRw9YF9FvEYVTW6hIkhAy6n87BB576RniY8igdr6CqsGznHVpEt4gKQRk99VDMS91Z2k++2tmGR+Qeo6MaOebkV+iMwvQYAgYDqzI2BW4vk2BOqqq4Bkda92nIq/U5qJfK/m8jrwSS4l1XpaVjB40AYmhnx1fS0y6WrvM/fEddOOPWFshx3vM9i9eNxjZbH4G9rQFGmNFQAA


name: Smart Shopify Agent: AI-Powered Abandoned Cart Recovery
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-05-26T11:59:22.062Z
updated_at: 2025-05-26T11:59:22.062Z
url: https://n8n.io/workflows/4396
scraped_at: 2025-12-24 13:02:44
description:
  🤖 AI Cart Recovery Agent: Smart Abandoned Checkout Assistant

  Transform abandoned carts into recovered sales with intelligent automation. This sophisticated n8n workflow monitors checkout abandonment, implements smart waiting periods, and sends AI-generated personalized recovery emails only when needed - maximizing conversions while respecting customer experience.

  🔄 How It Works

  This intelligent 7-step recovery system recovers lost sales automatically:

  Step 1: Initial Abandonment Detection
  The workflow fetches current abandoned checkout data from your e-commerce platform (Shopify, WooCommerce, etc.), identifying customers who added items but didn't complete their purchase.

  Step 2: Strategic Grace Period
  Instead of immediately sending recovery emails, the system waits 1 hour (customizable), giving customers natural time to complete their purchase without pressure or interruption.

  Step 3: Smart Re-verification
  After the waiting period, the workflow rechecks the abandonment status by fetching updated checkout data, ensuring accuracy before taking action.

  Step 4: Intelligent Decision Logic
  Advanced conditional logic compares initial and updated abandonment lists, determining if customers are still abandoned or have completed their purchase during the grace period.

  Step 5: AI-Powered Email Generation
  For customers still showing abandonment, GPT generates personalized recovery emails featuring:
  Customer's actual name for personal connection
  Specific products left in their cart
  Friendly, non-pushy messaging tone
  Optional discount incentives
  Compelling call-to-action to complete purchase

  Step 6: Automated Email Delivery
  Personalized recovery emails are sent directly to abandoned customers via Gmail or your preferred email service, maintaining professional branding and deliverability.

  Step 7: Comprehensive Activity Logging
  All recovery attempts are logged in Google Sheets for tracking, including customer details, email content, and campaign performance analytics.

  ⚙️ Setup Steps

  Prerequisites
  E-commerce platform with API access (Shopify, WooCommerce, BigCommerce)
  OpenAI API key for personalized email generation
  Gmail or SMTP email service for delivery
  Google Sheets for activity tracking and analytics
  n8n instance (cloud or self-hosted)

  E-commerce Platform Configuration

  Shopify Setup:
  API Endpoint: https://your-store.myshopify.com/admin/api/2023-10/checkouts.json
  Authentication: X-Shopify-Access-Token header
  Required Permissions: Read checkouts, Read customers
  Parameters: status=abandoned

  WooCommerce Setup:
  API Endpoint: https://your-site.com/wp-json/wc/v3/orders
  Authentication: Consumer Key/Secret or JWT
  Parameters: status=pending, status=failed
  Required Plugins: WooCommerce REST API

  Configuration Steps

  1. Credential Setup
  E-commerce API**: Store admin API access tokens or keys
  OpenAI API Key**: GPT-4 access for intelligent email generation
  Gmail OAuth2**: Professional email delivery service
  Google Sheets OAuth2**: Activity logging and performance tracking

  2. Abandonment Detection Configuration
  Monitoring Frequency**: Set workflow trigger schedule (hourly, daily)
  Grace Period Duration**: Customize wait time (default: 1 hour)
  Platform Integration**: Configure API endpoints for your specific platform
  Data Filtering**: Set criteria for what constitutes abandonment

  3. AI Email Customization
  Default email generation includes:
  Personalization Level**: Customer name, product specifics, cart value
  Tone Customization**: Friendly, urgent, helpful, or premium
  Discount Integration**: Optional percentage or fixed amount offers
  Brand Voice**: Maintain consistent company messaging and style

  4. Recovery Campaign Settings
  Email Timing**: Optimal sending times based on customer time zones
  Frequency Limits**: Prevent over-emailing with cooldown periods
  Segmentation Rules**: Different approaches for high-value vs standard carts
  Follow-up Sequences**: Multi-email recovery campaigns with escalating incentives

  5. Performance Tracking Setup
  Analytics Dashboard**: Google Sheets with recovery metrics and ROI
  Success Tracking**: Monitor completion rates and revenue recovered
  A/B Testing**: Compare different email approaches and timing
  Customer Journey**: Track from abandonment through recovery completion

  🚀 Use Cases

  E-commerce Retailers
  Fashion & Apparel**: Recover high-value clothing and accessory purchases
  Electronics**: Target abandoned tech purchases with technical support offers
  Home & Garden**: Remind customers about seasonal or home improvement items
  Beauty & Cosmetics**: Recover abandoned skincare and makeup purchases

  Subscription & SaaS Businesses
  Software Trials**: Convert abandoned trial signups into paid subscriptions
  Membership Sites**: Recover incomplete membership purchases
  Online Courses**: Re-engage learners who abandoned course purchases
  Digital Services**: Follow up on abandoned service bookings or consultations

  B2B E-commerce
  Office Supplies**: Recover bulk order abandonments with volume discounts
  Industrial Equipment**: Follow up on high-value equipment quote requests
  Professional Services**: Re-engage businesses that abandoned service bookings
  Software Licenses**: Recover enterprise software purchase abandonments

  Specialty Retailers
  Luxury Goods**: Provide white-glove service for high-value abandoned purchases
  Custom Products**: Follow up on personalized or custom order abandonments
  Seasonal Items**: Time-sensitive recovery for holiday or event-specific products
  Limited Edition**: Create urgency for exclusive or limited availability items

  Service-Based Businesses
  Travel & Hospitality**: Recover abandoned hotel, flight, or package bookings
  Event Tickets**: Re-engage customers who abandoned concert or event purchases
  Professional Services**: Follow up on abandoned consultation or service bookings
  Fitness & Wellness**: Recover abandoned membership or class package purchases

  🔧 Advanced Customization Options

  Multi-Platform Integration
  Extend beyond single platform monitoring:
  Shopify Plus: Advanced checkout analytics and customer segmentation
  WooCommerce: Custom post-purchase and abandonment tracking
  Magento: Enterprise-level cart recovery with customer journey mapping
  BigCommerce: API-driven recovery with advanced personalization
  Custom Platforms: Webhook-based abandonment detection and recovery

  Intelligent Email Sequencing
  Create sophisticated recovery campaigns:
  Progressive Incentives**: Escalating discounts over multiple touchpoints
  Behavioral Triggers**: Different emails based on cart value, customer history
  Seasonal Campaigns**: Holiday-specific recovery messaging and offers
  Win-Back Sequences**: Long-term customer re-engagement beyond immediate recovery

  Advanced Personalization
  Enhance AI-generated content with:
  Purchase History Analysis**: Reference previous purchases and preferences
  Browsing Behavior**: Include recently viewed items and categories
  Geographic Personalization**: Local offers, shipping options, or store locations
  Demographic Targeting**: Age, gender, or interest-based messaging customization

  Performance Optimization
  Implement advanced tracking and optimization:
  Revenue Attribution**: Track exact recovery amounts and ROI calculations
  Customer Lifetime Value**: Prioritize high-value customer recovery efforts
  Conversion Funnel Analysis**: Identify optimal timing and messaging strategies
  Predictive Analytics**: Use ML to predict recovery likelihood and optimize approaches

  📊 Recovery Email Examples

  Fashion Retailer Example:
  Subject: You left something stylish behind, Sarah!

  Hi Sarah,

  I noticed you were checking out those gorgeous items in your cart earlier - the Bohemian Summer Dress and Classic Leather Handbag have been waiting for you!

  I completely understand if you got busy or needed time to think it over. These pieces are still available and ready to ship to you today.

  Since you showed such great taste in selecting these items, I'd love to offer you 10% off your order to make the decision easier. Just use code WELCOME10 at checkout.

  Your cart includes:
  • Bohemian Summer Dress (Size M) - $89.99
  • Classic Leather Handbag (Brown) - $156.99

  Complete your purchase now and get free shipping to your door!

  [Complete My Purchase] 

  Best regards,
  The StyleHub Team

  P.S. These items are popular and inventory is limited - don't wait too long!

  Software/SaaS Example:
  Subject: Your ProductivityPro trial is waiting, Mike

  Hi Mike,

  You were just one step away from unlocking the full power of ProductivityPro for your team at TechStartup Inc.

  I noticed you explored our Premium Plan features - the advanced reporting and team collaboration tools that could streamline your workflow and boost productivity by up to 40%.

  Since you invested time exploring our platform, I'd like to offer you an exclusive 25% discount on your first year. This offer is valid for the next 48 hours.

  Your selected plan:
  • ProductivityPro Premium (5 users) - $99/month
  • With 25% discount: $74/month (Save $300/year!)

  Ready to transform your team's productivity?

  [Activate My Account]

  Questions? Reply to this email or schedule a quick 15-minute demo call.

  Best regards,
  David Chen
  Customer Success Manager, ProductivityPro

  High-Value B2B Example:
  Subject: Your equipment quote is ready for approval, Jennifer

  Hi Jennifer,

  Thank you for your interest in our Industrial Packaging System for ManuCorp's new facility expansion.

  I understand that equipment investments of this scale require careful consideration and stakeholder alignment. Your configured system includes:

  • Model X5000 Packaging Line - $45,000
  • Installation & Training Package - $8,000  
  • Extended 3-Year Warranty - $3,500
  Total Investment: $56,500

  Given the scope of your project, I'd like to extend our Q1 promotion pricing, which provides:
  15% discount on equipment ($6,750 savings)
  Free installation supervision ($2,000 value)
  Expedited 6-week delivery

  This brings your total to $48,750 - a savings of $7,750.

  I'm available for a brief call to address any technical questions or help facilitate internal approvals. 

  [Accept Quote & Proceed]

  Best regards,
  Robert Martinez
  Senior Sales Engineer
  Industrial Solutions Inc.
  Direct: (555) 123-4567

  🛠️ Troubleshooting & Best Practices

  Common Issues & Solutions

  API Rate Limiting
  Implement exponential backoff for API requests
  Stagger workflow execution times across different stores
  Monitor API usage and upgrade plans as needed
  Cache frequently accessed data to reduce API calls

  Email Deliverability Challenges
  Use authenticated SMTP services with proper SPF/DKIM setup
  Monitor sender reputation and email engagement metrics
  Implement opt-out mechanisms and respect unsubscribe requests
  Segment email lists and avoid over-emailing customers

  False Positive Recoveries
  Extend grace periods for complex checkout processes
  Implement more sophisticated abandonment detection logic
  Add customer behavior analysis before triggering recovery
  Create exception rules for technical checkout failures

  Optimization Strategies

  Recovery Timing Optimization
  A/B test different grace period durations (30 min, 1 hour, 3 hours)
  Analyze customer behavior patterns to optimize sending times
  Consider time zone differences for global customer bases
  Implement seasonal timing adjustments for holidays and events

  Content Personalization Enhancement
  Continuously refine AI prompts based on successful recoveries
  Implement dynamic discount strategies based on cart value
  Create customer segment-specific messaging approaches
  Add urgency elements for time-sensitive or limited inventory items

  Performance Measurement
  Track recovery rates, revenue impact, and customer satisfaction
  Implement cohort analysis for long-term customer value impact
  Monitor email engagement metrics and optimize accordingly
  Calculate true ROI including customer acquisition costs and lifetime value

  📈 Success Metrics

  Recovery Performance Indicators
  Recovery Rate**: Percentage of abandoned carts successfully recovered
  Revenue Recovery**: Total dollar amount recovered from abandoned purchases
  Email Engagement**: Open rates, click rates, and conversion rates
  Time to Recovery**: Average time from abandonment to completed purchase

  Business Impact Measurements
  ROI Calculation**: Revenue recovered vs workflow operational costs
  Customer Retention**: Impact on long-term customer relationships
  Average Order Value**: Effect on overall purchase values post-recovery
  Operational Efficiency**: Automation savings vs manual recovery efforts

  📞 Questions & Support

  Need help implementing your AI Cart Recovery Agent?

  📧 E-commerce Automation Expert Support
  Email**: Yaron@nofluff.online
  Response Time**: Within 24 hours on business days
  Specialization**: E-commerce automation, cart recovery optimization, AI email personalization

  🎥 Comprehensive Implementation Resources
  YouTube Channel**: https://www.youtube.com/@YaronBeen/videos
    Complete setup guides for major e-commerce platforms
    Advanced AI email personalization techniques
    Recovery campaign optimization strategies
    Integration tutorials for Shopify, WooCommerce, and custom platforms
    Performance tracking and analytics implementation

  🤝 E-commerce Automation Community
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
    Connect for ongoing e-commerce automation support and consulting
    Share your cart recovery success stories and ROI achievements
    Access exclusive templates for different industry verticals
    Join discussions about e-commerce automation trends and innovations

  💬 Support Request Guidelines
  Include in your support message:
  Your e-commerce platform and current cart abandonment rates
  Average order values and customer segments you serve
  Current recovery processes and conversion challenges
  Integration requirements with existing marketing tools
  Specific technical errors or workflow execution issues

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.manualTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6556 characters]


name: Boost posts/statuses from a specific FediVerse account on your mastodon profile
author_name: Suleman Hasib
author_username: sulemanhasib43
categories: []
created_at: 2025-05-26T12:17:56.625Z
updated_at: 2025-05-26T12:17:56.625Z
url: https://n8n.io/workflows/4397
scraped_at: 2025-12-24 13:02:46
description:
  Template Overview

  This template is designed for individuals and businesses who want to maintain a consistent presence on the Fediverse while also posting on Threads or managing multiple Fediverse profiles. By automating the process of resharing statuses or posts, this workflow saves time and ensures regular engagement across accounts.

  Use Case

  The template addresses the challenge of managing activity across Fediverse accounts by automatically boosting or resharing posts from a specific account to your own. It is especially helpful for users who want to consolidate engagement without manually reposting content across multiple platforms or profiles.

  How It Works

  The workflow runs on a scheduled trigger and retrieves recent posts from a specified Fediverse account, such as your Threads.net account. It uses a JavaScript filter to identify posts from the current day and then automatically boosts or reshares them to your selected Mastodon profile.

  Preconditions

  You need a Mastodon account with developer access.
  Identify a Threads.net or other Fediverse account which you want to boost.
  Basic familiarity with APIs and setting up credentials in n8n.

  Setup Steps

  Step 1: Create a Developer Application on Mastodon

  Log in to your Mastodon account and navigate to Preferences &gt; Development &gt; New Application.
  Fill out the required information and create your application.
  Set Scopes to atleast read, profile, write:statuses.
  Click Submit.
  Note down the access token generated for this application.

  Step 2: Get the Account ID

  Use the following command to retrieve the account ID for the profile you want to boost:

        curl -s "https://mastodon.social/api/v1/accounts/lookup?acct=&lt;ACCOUNTNAME&gt;"
     
     Alternatively, paste the URL into a GET node on n8n.
  From the returned JSON, copy the "id" field value (e.g., {"id":"110564198672505618", ...}).

  Step 3: Update the "Get Statuses" Node

  Replace &lt;ACCOUNTID&gt; in the URL field with the ID you retrieved in Step 2:

        https://mastodon.social/api/v1/accounts/&lt;ACCOUNTID&gt;/statuses
  Step 4: Configure the "Boost Statuses" Node

  Authentication type will already be set to Header Auth.

  Grab the access token from Step 1.
  In the Credential for Header Auth field, create a new credential.
  Click the pencil icon in the top-left corner to name your credential.
  In the Name field, enter Authorization.
  In the Value field, enter Bearer &lt;YOUR_MASTODON_ACCESS_TOKEN&gt;. (Note: there is a space after "Bearer.")
  Save the credential, and it should automatically be selected as your Header Auth.

  Step 5: Test the Workflow

  Run the workflow to ensure everything is set up correctly.
  Adjust filters or parameters as needed for your specific use case.

  Customization Guidance

  Replace mastodon.social with your own Mastodon domain if you're using a self-hosted instance.
  Adjust the JavaScript filter logic to meet your specific needs (e.g., filtering by hashtags or keywords).
  For enhanced security, store the access token as an n8n credential. Embedding it directly in the URL is ++not recommended++.

  Notes

  This workflow is designed to work with any Mastodon domain.
  Ensure your Mastodon account has appropriate permissions for boosting posts.

  By following these steps, you can automate your Fediverse engagement and focus on creating meaningful content while the workflow handles the rest!

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

workflow_json_compressed:
  H4sIAAAAAAAAE5VUbW/TOhT+K5GFBEh189o0qcak3q1AxboiGkBoVNOJ7ay5Su0SOwNU5b9zkra01boBnyLbx+d5OU+8JhKWggzIe6WNlSxKAVxbRlkT0EZxJUmHSMWFJoObNck5VvpO1vN6ok9d13dpwLKMRiGPqB9EPafHIc7SXnNr03fGFoJXhbCSMr+7EyWemJ+r5kRGkrataQpadPW2cF+3Ujo3OVIY3Dgd6kbOHPegxL5GlEhoTUqsb765xJ17KFqSZtNgaN6qqiQDz+/stya5rAxe6cX1vK43VD5hsxbF7Xp1Zysyjvt9nzkp9bnv0SByYxrH3KOOL3wehn4Uuf5e5BthLG3AVFpoKyvV0jIbJ7tSmEcVL4xZfRDfKqHNsVrPe0RvVaJE0tzTA9tebkfU1YrlUNiwyu171wbGVCWNts+GFxfTj9fJ7fjy3N7RQyS1anCahg8sCA4sYFHgpdDDEXtpRoMwTGnkehEFiJxeyJzIgwMLXucFssTkcPj5qOKsLToWGwSPiD2g2SFMSZ7v1gdH5H5H3euQQmTmExRVg4wgDCFnQjZI97hlykps5UKRc9jgE43hYIa0GMs0l2AUpoaA5OQYdpd/T2Rp0A8dGntxQIMYfQEGfRqIENI04izzg9ZlUW56rXduIKZIcrRrd7phABlKnpajbxUUuiFyqOPVem09+1/jlBkmygh+C8aqa2yBmV4clUnx3brEkhcvu0aNZ9MZKpN3uNKrIjcvnifPX944c7z8VZIT8fcOZx+KCOeMeRcxwwCAT1M/ACrA9R2ecgDe38/+P9U8HgcJ+8e8h+GTeX/1h8DvgO3fVuUcVdqlSAt1dxx4tG3DYCLMQjVS309nCdZAZRZCmpztprLA/xefDNxus1EK3hw3E0JiDaO3+4LB1raz8aX1eXx1ZQ0/JtPJMBlfDK+uvlhvRtejD8NkdL637GwynCXTy+n1Lf6ko9nsNpm+G12fk4ePUj1vYygF+535o38N10vIGxsxoI3bTwykLezgc8nFDzJw6vkc4R680Kc6/uULdxLg6bun0E4/Jiea1/UvD0D4EMEGAAA=


name: 📸 Automate Photo Background Removal with Photoroom API and Google Drive
author_name: Samir Saci
author_username: samirsaci
categories: []
created_at: 2025-05-26T12:22:17.704Z
updated_at: 2025-05-26T12:22:17.704Z
url: https://n8n.io/workflows/4398
scraped_at: 2025-12-24 13:02:46
description:
  Tags: Marketing, Image Processing, Automation

  Context

  Hey! I’m Samir, a Data Scientist from Paris and the founder of LogiGreen Consulting.

  We use AI, automation, and data to support sustainable business practices for small, medium and large companies.

  I implemented this workflow to support an event agency to automate image processing like background removal using Photoroom API.




  &gt; Automate your photos processing with n8n!

  This n8n workflow collects all images in a Google Drive folder shared with multiple photographers.

  For each image, it calls the Photoroom API:
  A processed image w/o a background is saved in a subfolder Remove Background
  The original pictures are saved in the subfolder Original

  This workflow, triggered every morning, will process the backlog of images.




  📬 For business inquiries, feel free to connect with me on LinkedIn

  Who is this template for?

  This workflow is useful for:
  Digital Marketing** teams that use images for content creation
  Photographs* or *Event Organisers** that collect large amounts of photos that need processing
  What does it do?

  This n8n workflow:
  ⏰ Triggers automatically every morning  
  🖼️ Collects the names and IDs of all images in the folder
  🧹 HTTP POST request to Photoroom API to remove the background
  📄 Stores the processed image and the original image in two separate sub-folders  

  What do I need to get started?

  You’ll need:
  A Google Drive Account connected to your n8n instance with credentials
  A Photoroom API key that you can get for free (trial) here: Photoroom API

  Follow the Guide!

  Follow the sticky notes inside the workflow or check out my step-by-step tutorial on how to configure and deploy it.



  🎥 Watch My Tutorial



  This workflow was built using n8n version 1.93.0  
  Submitted: May 26, 2025

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

workflow_json_compressed:
  H4sIAAAAAAAAE+1Ye27bRhq/yiyzWGwNjcS3SAFFYSdw46JpDNtdbGEbxZAzlNhQHJYztCwYOsUeYO/RU/UI+82MHrREJnKC3fyzMRBQ5Pf8fc+ZJ2vOJLEmT1ZeCknKlF1Qa2JZA0uyeVUQyV7XjIprJpvqNYc3TDIgkHXDVgOr5JQJa3IL3IorcX3fIX6IE+rY2E/tFJPI9rGXMMeLqJvRiIHkkswZUP/IeYXeP7AaXYAuoVQuK/WhjEqsJeOECDYUVZHLi/KMyHTGFFnFRS5zXoJi7If2wHXte3hLapArWS2UN7xSFOpxtTKC/wFfNJO3GqztTeMIDHUdHDmZg32PxTiybfg5tiPihGmQ0bTXXuczDfbtQRR+psE0TPzE8WLsjAMwmAUejhLqYRaF1E58d+zZzs7gd/yBIcnR+zqf5iUpeg2ecj4t2Js6f2DPrXUB3Sg6NDbLC50nT9avv9aFSYeBNQeJIBwsHVgPpGjUj2+fntBffxO8HOYUrVYW+EaVnl7uIheyxf9uiYxdwJjxgrL6WE54TAkEgF4x0RTyZ0W///InA9QWIFDCK1YT4z4INop7omEnbMxIFOPMjxLsR76PCXUJduNkzFyP2Rl1d9G4JiYaV0yJRWck/TCteVPSzwiLaw88+zAsa007zNULhfoXgN7Ky/9iBA5BAW15WTXyDZHkPGcFXVPWmg0LUtKEP2KleViVU0t3I8nERXle8MXGsJ7IjT0vjL0oxMxLY+wHLoVGFWc4TLIwtMcute1W5N7wRVlwQtHFnEzZy8OF++L1RWX0LDDtrKVrc18GSeK44zRyPBwT5kEyUxdHASXYC6lLEycNWejtIPmeSUSKAikP+jt3PyLQZjvbNsiDR/30olRzfnMWhW0v/atTcXXF0p/H/j8fr8Lrqkx/eXz3Oz19QS4q3BYzIm/4NSN1OoNXxs190CEVeVOnbE1wri3+SL9IvcAPaeJhl7gR9rM4gkmTUOwEQZhGjHksao2ba5mnH5boJ4jgR0aNJlI0ewA7qnXD/4cQp7zggPAYnMypBO9CiIU1Y/l0Jq1JAGxAUkpWwi/r1atXyBmi17woWGpCztfNEuWqGoROAaRsFnflDXybwoCUM4YWvP6QQd6pnpeu+dV7TYp4poWpF2s5S96gBSmloq9qnjIh4DMBpTVDQnJYQ1BeIoJExdI8y1NkUmR4V96Vys63RpeA1Gyq7+5KjE5OTAR3qar17iR8rxPUNDtk4ndyMrkrEVJen1KqrKqfk51eXqAUjAGAclIIpZKka2tZl0Sh5blDdM22IBjTjX8KbQLb1xYQY2kHHnfl7Y/gUInmgAYiCW/koVKw7/7vMykrMRmNKE/FEHJmmPNRDkGdmi4hRkkDlZaXI1JVJp9GnbWrx8boGwPmZc0qFQylUjSJ8UFsAMMINkXYFxW+TYI3HnITu40LKogm3ioP6ATEHvT+k5NjBCortrloICMZJPlGU15OtQ6lYjPgjWSVMAdl6mzL1Ingj/pjHMdMLVlpiOMMVlmf+Wol9F3PCTrL9OVVGrjHFqljt6s0dA+qFPJrDWSyBVKgRS5n6HLGATHO5zp3/4aE3kQAPjNLhSqrdUw3KPdE5ZzXiEHHNDEc6BxthBGmZENwasOn3uwMGaKbrTqUC20BPVbtRwt8O5t1G8pqcLJdDf+bam55UPBUV9hXLtUDGDsyoQub56nygS1RnyPPKPe8qDbfhimfK5PuypNfIFVSAhFnQm7zRRulW17NAEaz0yE14k1rZCVJVGE7A0h/YC8gQrDpAEUpZ8OTTxRy7GRZ4hCGPRIE6qSYYFhrYhxmbgRLjpdGHt0V8nPXj9/SledX7PeG6YWkVd3dO1+jN48NXLqOMKnyPcwe3BGjuRIInDOuvLl8f31jtTcQtX9U8Mj6nqFa50SutxPF2khYqC9rtSzK5af2aXUMFaykZ5wuN8vXuuXcGCDmwJiDdxKSv55jCpu6ZXjeMkK1v4YtARGXz1BoY3K7PbiIGYHldahXvN1uR/Kh4Jm0VFzXhK3OYjrljvpc/2sTV4RSGAYtGnvotAl0EM4NRlvD1j4qz85gdNTLN8a9zkOJdn11v1IdWnl+jLOn0Gaq9g6rzRgB9gMEpV7kppGM1NbftvZRpQuG0lQK95PfH7rb9A/SOCZe4GGH2GPs2zaDiRYSnCU08tKxF9CUdc4x9/MGWeC/eI51bJveEOl7i8vtvnBh9oW78nRvvA/a66NaTFTJUtXCD8bKbgH46DTRmvUkgdn0VefI/+fH158fHhkzO0kpZklA1PyIcewFMY7gKOzCwZGFtHUkfkPyYolAqR1NQBmZ91eROnI2BVuflvZPbrbbfTaugcVc1MIbaBq6mUgj41S+BfitSdTRE5xWT4jcyPH9IMFxqm48me/hiDjgF/MSN0wiGo67e4L34p4Q2D277ebYGbYagX/YCG7//Pe//thcOaObBjICKmuXKYvFYgg5J5uE6TRZqOvW7x6+nZ6V8YLa2Q+BD5nzl9ubWTNPSgjOc1ZB5nktSJpr5rVqM4/FyLXdYGQH6/Hsq4H4TWeq3GurSyjgzVB+fjMCL+ZwtgM4VOM3Vxe9996aUk0Yyh6tia17fieL089zr4bQ3oVVlxFHbzudCvZdaGm4H+yU9F2cHSPT6RPaf6vdKfaA/IiQfBLfg1LvEtpzR9Ypsf9y+IsySMv+VKi7NBxxWd2ha7X6D5eVlG9PGgAA


name: Anthropic AI Agent: Claude Sonnet 4 and Opus 4 with Think and Web Search tool
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-05-26T12:27:34.726Z
updated_at: 2025-05-26T12:27:34.726Z
url: https://n8n.io/workflows/4399
scraped_at: 2025-12-24 13:02:41
description:
  This workflow dynamically chooses between two new powerful Anthropic models — Claude Opus 4 and Claude Sonnet 4 — to handle user queries, based on their complexity and nature, maintaining scalability and context awareness with Anthropic web search function and Think tool.

  Key Advantages

  🔁 Dynamic Model Selection

     Automatically routes each user query to either Claude Sonnet 4 (for routine tasks) or Claude Opus 4 (for complex reasoning), ensuring optimal performance and cost-efficiency.

  🧠 AI Agent with Tool Use

     The AI agent can utilize a web search tool to retrieve up-to-date information and a Think tool for complex reasoning processes — improving response quality.

  📎 Memory Integration

     Uses session-based memory to maintain conversational context, making interactions more coherent and human-like.

  🧮 Built-in Calculation Tool

     Handles numeric queries using an integrated calculator tool, reducing the need for external processing.

  📤 Structured Output Parser

     Ensures outputs are always well-structured and formatted in JSON, which improves consistency and downstream integrations.

  🌐 Web Search Capability

     Supports real-time information retrieval for current events, statistics, or details not available in the AI’s base knowledge.

  Components Overview

  Trigger**: Listens for new chat messages.
  Routing Agent**: Analyzes the message and returns the best model to use.
  AI Agent**: Handles the conversation, decides when to use tools.
  Tools**:

    web_search for internet queries
    Think for reasoning
    Calculator for math tasks
  Models Used**:

    claude-sonnet-4-20250514: Optimized for general and business logic tasks.
    claude-opus-4-20250514: Best for deep, strategic, and analytical queries.

  How It Works
  Dynamic Model Selection  
     The workflow begins when a chat message is received. The Anthropic Routing Agent analyzes the user's query to determine the most suitable model (either Claude Sonnet 4 or Claude Opus 4) based on the query's complexity and requirements.  
     The routing agent uses predefined criteria to decide:  
       Claude Sonnet 4: Best for standard tasks like real-time workflow routing, data validation, and routine business logic.  
       Claude Opus 4: Reserved for complex scenarios requiring deep reasoning, advanced analysis, or high-impact decisions.  

  Query Processing and Response Generation  
     The selected model processes the query, leveraging tools like web_search for real-time information retrieval, Think for internal reasoning, and Calculator for numerical tasks.  
     The AI Agent coordinates these tools, ensuring the response is accurate and context-aware. A Simple Memory node retains session context for coherent multi-turn conversations.  
     The final response is formatted and returned to the user without intermediate steps or metadata.  

  Set Up Steps
  Node Configuration  
     Trigger: Configure the "When chat message received" node to handle incoming user queries.  
     Routing Agent: Set up the "Anthropic Routing Agent" with the system message defining model selection logic. Ensure it outputs a JSON object with prompt and model fields.  
     AI Model Nodes: Link the "Sonnet 4 or Opus 4" node to dynamically use the selected model. The "Sonnet 3.7" node powers the routing agent itself.  

  Tool Integration  
     Attach the "web_search" HTTP tool to enable internet searches, ensuring the API endpoint and headers (e.g., anthropic-version) are correctly configured.  
     Connect auxiliary tools (Think, Calculator) to the "AI Agent" for extended functionality.  
     Add the "Simple Memory" node to maintain conversation history.  

  Credentials  
     Provide an Anthropic API key to all nodes requiring authentication (e.g., model nodes, web search).  

  Testing  
     Activate the workflow and test with sample queries to verify:  
       Correct model selection (e.g., Sonnet for simple queries, Opus for complex ones).  
       Proper tool usage (e.g., web searches trigger when needed).  
       Memory retention across chat turns.  

  Deployment  
     Once validated, set the workflow to active for live interactions.  

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

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.lmChatAnthropic","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.httpRequestTool"]

workflow_json_compressed:
  [encoded data, 4592 characters]


name: Build a PDF Document RAG System with Mistral OCR, Qdrant and Gemini AI
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-05-26T12:28:14.350Z
updated_at: 2025-05-26T12:28:14.350Z
url: https://n8n.io/workflows/4400
scraped_at: 2025-12-24 13:02:41
description:
  This workflow is designed to process PDF documents using Mistral's OCR capabilities, store the extracted text in a Qdrant vector database, and enable Retrieval-Augmented Generation (RAG) for answering questions. Here’s how it functions:  

  Once configured, the workflow automates document ingestion, vectorization, and intelligent querying, enabling powerful RAG applications.

  Benefits

  End-to-End Automation**
    No manual interaction is needed: documents are read, processed, and made queryable with minimal setup.

  Scalable and Modular**
    The workflow uses subflows and batching, making it easy to scale and customize.

  Multi-Model Support**
    Combines Mistral for OCR, OpenAI for embeddings, and Gemini for intelligent answering—taking advantage of the strengths of each.

  Real-Time Q\&A**
    With RAG integration, users can query document content through natural language and receive accurate responses grounded in the PDF data.

  Light or Full Mode**
    Users can choose to index full page content or only summarized text, optimizing for either performance or richness.

  How It Works 

  PDF Processing with Mistral OCR:  
     The workflow starts by uploading a PDF file to Mistral's API, which performs OCR to extract text and metadata.  
     The extracted content is split into manageable chunks (e.g., pages or sections) for further processing.  

  Vector Storage in Qdrant:  
     The extracted text is converted into embeddings using OpenAI's embedding model.  
     These embeddings are stored in a Qdrant vector database, enabling efficient similarity searches for RAG.  

  Question-Answering with RAG:  
     When a user submits a question via a chat interface, the workflow retrieves relevant text chunks from Qdrant using vector similarity.  
     A language model (Google Gemini) generates answers based on the retrieved context, providing accurate and context-aware responses.  

  Optional Summarization:  
     The workflow includes an optional summarization step using Google Gemini to condense the extracted text for faster processing or lighter RAG usage.  

  Set Up Steps  
  To deploy this workflow in n8n, follow these steps:  

  Configure Qdrant Database:  
     Replace QDRANTURL and COLLECTION in the "Create collection" and "Refresh collection" nodes with your Qdrant instance details.  
     Ensure the Qdrant collection is configured with the correct vector size (e.g., 1536 for OpenAI embeddings) and distance metric (e.g., Cosine).  

  Set Up Credentials:  
     Add credentials for:  
       Mistral Cloud API (for OCR processing).  
       OpenAI API (for embeddings).  
       Google Gemini API (for chat and summarization).  
       Google Drive (if sourcing PDFs from Drive).  
       Qdrant API (for vector storage).  

  PDF Source Configuration:  
     If using Google Drive, specify the folder ID in the "Search PDFs" node.  
     Alternatively, modify the workflow to accept PDFs from other sources (e.g., direct uploads or external APIs).  

  Customize Text Processing:  
     Adjust chunk size and overlap in the "Token Splitter" node to optimize for your document type.  
     Choose between raw text or summarized content for RAG by toggling between the "Set page" and "Summarization Chain" nodes.  

  Test the RAG:  
     Trigger the workflow manually or via a chat message to verify OCR, embedding, and Qdrant storage.  
     Use the "Question and Answer Chain" node to test query responses.  

  Optional Sub-Workflows:  
     The workflow supports execution as a sub-workflow for batch processing (e.g., handling multiple PDFs).  

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

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.manualTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterTokenSplitter","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.chainRetrievalQa","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.retrieverVectorStore","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.embeddingsOpenAi","n8n-nodes-base.code","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.vectorStoreQdrant","n8n-nodes-base.splitInBatches","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chainSummarization","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDrive","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5668 characters]


name: AI Chatbot Agent with a Panel of Experts using InfraNodus GraphRAG Knowledge
author_name: InfraNodus
author_username: infranodus
categories: []
created_at: 2025-05-26T12:34:52.632Z
updated_at: 2025-05-26T12:34:52.632Z
url: https://n8n.io/workflows/4402
scraped_at: 2025-12-24 13:02:41
description:
  Using the knowledge graphs instead of RAG vector stores

  This workflow creates an AI chatbot agent that has access to several knowledge bases at the same time (used as "experts"). 

  These knowledge bases are provided using the InfraNodus GraphRAG using the knowledge graphs and providing high-quality responses without the need to set up complex RAG vector store workflows.

  The advantages of using GraphRAG instead of the standard vector stores for knowledge are:

  Easy and quick to set up (no complex data import workflows needed)
  A knowledge graph has a holistic view of your knowledge base
  Better retrieval of relations between the document chunks = higher quality responses

  How it works
  This template uses the n8n AI agent node as an orchestrating agent that decides which tool (knowledge graph) to use based on the user's prompt. 

  Here's a description step by step:

  The user submits a question using the AI chatbot (n8n interface, in this case, which can be accessed via a URL or embedded to any website)
  The AI agent node checks a list of tools it has access to. Each tool has a description of the knowledge it has auto-generated by InfraNodus. 
  The AI agent decides which tool should be used to generate a response. It may reformulate user's query to be more suitable for the expert. 
  The query is then sent to the InfraNodus HTTP node endpoint, which will query the graph that corresponds to that expert. 
  Each InfraNodus GraphRAG expert provides a rich response that takes the whole context into account and provides a response from each expert (graph) along with a list of relevant statements retrieved using a combination or RAG and GraphRAG. 
  The n8n AI Agent node integrates the responses received from the experts to produce the final answer.
  The final answer is sent back to the user's chat (or a webhook endpoint)

  How to use

  You need an InfraNodus GraphRAG API account and key to use this workflow. 

  Create an InfraNodus account
  Get the API key at https://infranodus.com/api-access and create a Bearer authorization key for the InfraNodus HTTP nodes.
  Create a separate knowledge graph for each expert (using PDF / content import options) in InfraNodus
  For each graph, go to the workflow, paste the name of the graph into the body name field.
  Keep other settings intact or learn more about them at the InfraNodus access points page. 
  Once you add one or more graphs as experts to your flow, add the LLM key to the OpenAI node and launch the workflow

  Requirements

  An InfraNodus account and API key
  An OpenAI (or any other LLM) API key

  Customizing this workflow

  You can use this same workflow with a Telegram bot, so you can interact with it using Telegram. There are many more customizations available. 

  Check out the complete guide at https://support.noduslabs.com/hc/en-us/articles/20174217658396-Using-InfraNodus-Knowledge-Graphs-as-Experts-for-AI-Chatbot-Agents-in-n8n

  Also check out the video tutorial with a demo:

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@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/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequestTool","n8n-nodes-base.httpRequestTool"]

workflow_json_compressed:
  [encoded data, 5388 characters]


name: Find Content Gaps in Competitors' Websites with InfraNodus GraphRAG for SEO
author_name: InfraNodus
author_username: infranodus
categories: []
created_at: 2025-05-26T12:58:02.888Z
updated_at: 2025-05-26T12:58:02.888Z
url: https://n8n.io/workflows/4403
scraped_at: 2025-12-24 13:02:41
description:
  This template can be used to find the content gaps in your competitors' discourse: identifying the topics they are not yet connecting and giving you an opportunity to fill in this gap with your content and product ideas. It will also generate research questions that will help bridge the gaps and generate new ideas.

  The template showcases the use of multiple n8n nodes and processes:
  enriching Google sheets file with the new data
  data extraction
  content enhancement using GraphRAG approach
  content gap / research question generation

  This approach can be very useful for research, marketing, and SEO applications as you can quickly get an overview of the main topics that are available online for a certain niche and understand what is missing. 

  What are Content Gaps in Marketing and SEO?

  In the context of SEO, content gaps are usually understood as the topics that your competitors rank for but you do not. 

  However, it's hard to rank for these topics because there's very high competition. So a much more effective way is to identify the gaps between the topics your competitors are talking about that are not yet bridged in their discourse.

  If you address these gaps in your content, you will increase the informational gain that your content offers and also offer a novel perspective while touching upon the topics that are relevant in your field.

  For example, if we analyze the top websites for "body and physical practices, fitness, etc." we will see that most of them are talking about the health and fitness aspects and another big topic is the community aspect. 

  However, there is a gap between the two topics: which means that most of the websites (companies) that talk about this topic don't mention the two in the same context. This might be an opportunity: bridging the gap between health, fitness but also emphasizing the community aspect that comes with a collective practice. 

  How it works
  This template consists of the two stages:

  1) Data enrichment of a Google sheet file with a list of your competitors using InfraNodus' GraphRAG to generate topical summaries and graph summaries for every URL you're analyzing. 

  2) Insight generation (using InfraNodus to identify the main topical clusters and gaps in those summaries, these insights are then added to the Google sheet file.

  Additionally, it contains a sub workflow that you can activate and launch to ask Perplexity model to conduct a market research and find the companies that operate in your field and populate the original Google sheet file.

  Here's a description step by step:

  Step 0: Populate the Google sheets file with the company data (either manually or using the sub-workflow provided or Manus AI / Deep Research)
  Steps 1-2: Triggering and Launching the workflow, extracting the company URL from the Google sheet row
  Step 3: Scraping the url content from the companies' websites and cleaning the data
  Steps 5-7: Use InfraNodus GraphRAG Content Enhancer to get a topical summary and graph summary. This is what you're going to get:



  Steps 8-10: Use InfraNodus AI to generate insight advice and research questions based on the content gaps

  How to use

  You need an InfraNodus GraphRAG API account and key to use this workflow. 

  Create an InfraNodus account
  Get the API key at https://infranodus.com/api-access and create a Bearer authorization key for the InfraNodus HTTP nodes.
  Create a separate knowledge graph for each expert (using PDF / content import options) in InfraNodus
  For each graph, go to the workflow, paste the name of the graph into the body name field.
  Keep other settings intact or learn more about them at the InfraNodus access points page. 
  Once you add one or more graphs as experts to your flow, add the LLM key to the OpenAI node and launch the workflow

  Requirements

  An InfraNodus account and API key
  A Google Sheet account and an authorization key

  Note: OpenAI key is not required. But you might want to get a Perplexity AI key if you'd like to use the sub-workflow that populates the Google sheet with your competitors' website addresses (if you don't have this list yet).

  Customizing this workflow

  You can use this same workflow with a Telegram bot or Slack (to be notified of the summaries and ideas). 

  You can also hook up automated social media content creation workflows in the end of this template, so you can generate posts that are relevant (covering the important topics in your niche) but also novel (because they connect them in a new way). 

  Check out our n8n templates for ideas at https://n8n.io/creators/infranodus/

  Check out the complete guide at https://support.noduslabs.com/hc/en-us/articles/20234254556828-Find-Content-Gaps-in-Websites-Market-Research-and-SEO-n8n-Workflow

  Also check the full tutorial with a conceptual explanation at https://support.noduslabs.com/hc/en-us/articles/20454382597916-Beat-Your-Competition-Target-Their-Content-Gaps-with-this-n8n-Automation-Workflow 

  Also check out the video tutorial with a demo:



  For support and help with this workflow, please, contact us at https://support.noduslabs.com

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.htmlExtract","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDocs","n8n-nodes-base.aggregate","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.formTrigger","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8668 characters]


