Browse 13,012 Workflows

By Axiomlab.dev

HubSpot Lead Refinement 🚀 How it works Triggers: HubSpot Trigger: Fires when contacts are created/updated. Manual Trigger: Run on demand for testing or batch checks. Get Recently Created/Updated Contacts: Pulls fresh contacts from HubSpot. Edit Fields (Set): Maps key fields (First Name, Last Name, Email) for the Agent. AI Agent: First reads your Google Doc (via the Google Docs tool) to learn the research steps and output format. Then uses SerpAPI (Google engine) to locate the contact’s likely LinkedIn profile and produce a concise result. Code – Remove Think Part: Cleans the model output (removes hidden “think” blocks / formatting) so only the final answer remains. HubSpot Update: Writes the cleaned LinkedIn URL to the contact (via email match). 🔑 Required Credentials: HubSpot App Token (Private App) — for Get/Update contact nodes. HubSpot Developer OAuth (optional) — if you use the HubSpot * Trigger node for event-based runs. Google Service Account — for the Google Docs tool (share your * playbook doc with this service account). OpenRouter — for the OpenRouter Chat Model used by the AI Agent. SerpAPI — for targeted Google searches from within the Agent. 🛠️ Setup Instructions HubSpot Create a Private App and copy the Access Token. Add or confirm the contact property linkedinUrl (Text). Plug the token into the HubSpot nodes. If using HubSpot Trigger, connect your Developer OAuth app and subscribe to contact create/update events. Google Docs (Living Instructions) ➡️ Sample configuration doc file Copy the sample doc file and modify to your need. Share the doc with your Google Service Account (Viewer is fine). In the Read Google Docs node, paste the Document URL. OpenRouter & SerpAPI Add your OpenRouter key to the OpenRouter Chat Model credential. Add your SerpAPI key to the SerpAPI tool node. (Optional) In your Google Doc or Agent prompt, set sensible defaults for SerpAPI (engine=google, hl=en, gl=us, num=5, max 1–2 searches). ✨ What you get Auto-enriched contacts with a LinkedIn URL and profile insights (clean, validated output). A research process you can change anytime by editing the Google Doc—no workflow changes needed. Tight, low-noise searches via SerpAPI to keep costs down. And that’s it—publish and let the Agent enrich new leads automatically while you refine the rules in your doc. It allows handing off to a team who wouldn't necessarily tweak the automation nodes. An n8n automation workflow template by Axiomlab.dev.

By Toshiki Hirao

Managing invoices manually can be time-consuming and error-prone. This workflow automates the process by extracting key invoice details from PDFs shared in Slack, structuring the information with AI, saving it to Google Sheets, and sending a confirmation back to Slack. It’s a seamless way to keep your financial records organized without manual data entry. How it works Receive invoice in Slack – When a PDF invoice is uploaded to a designated Slack channel, the workflow is triggered. Fetch the PDF – The file is downloaded automatically for processing. Extract data from PDF – Basic text extraction is performed to capture invoice content. AI-powered invoice parsing – An AI model interprets the extracted text and structures essential fields such as company name, invoice number, total amount, invoice date, and due date. Save to Google Sheets – The structured invoice data is appended as a new row in a Google Sheet for easy tracking and reporting. Slack confirmation – A summary of the saved invoice details is sent back to Slack to notify the team. How to use Import the workflow into your n8n instance. Connect Slack – Authenticate your Slack account and set up the trigger channel where invoices will be uploaded. Connect Google Sheets – Authenticate with Google Sheets and specify the target spreadsheet and sheet name. Configure the AI extraction – Adjust the parsing prompt or output structure to fit your preferred data fields (e.g., vendor name, invoice ID, amount, dates). Test the workflow – Upload a sample invoice PDF in Slack and verify that the data is correctly extracted and saved to Google Sheets. Requirements An n8n instance (cloud) Slack account with permission to read uploaded files and post messages Google account with access to the spreadsheet you want to update AI integration (e.g., OpenAI GPT or another LLM with PDF parsing capabilities) A designated Slack channel for receiving invoice PDFs. An n8n automation workflow template by Toshiki Hirao.

By Stephan Koning

🌊 What it Does This workflow automatically classifies uploaded files (PDFs or images) as floorplans or non‑floorplans. It filters out junk files, then analyzes valid floorplans to extract room sizes and measurements. 👥 Who it’s For Built for real estate platforms, property managers, and automation builders who need a trustworthy way to detect invalid uploads while quickly turning true floorplans into structured, reusable data. ⚙️ How it Works User uploads a file (PDF, JPG, PNG, etc.). Workflow routes the file based on type for specialized processing. A two‑layer quality check is applied using heuristics and AI classification. A confidence score determines if the file is a valid floorplan. Valid floorplans are passed to a powerful OCR/AI for deep analysis. Results are returned as JSON and a user-friendly HTML table. 🧠 The Technology Behind the Demo This MVP is a glimpse into a more advanced commercial system. It runs on a custom n8n workflow that leverages Mistral AI's latest OCR technology. Here’s what makes it powerful: Structured Data Extraction: The AI is forced to return data in a clean, predictable JSON Schema. This isn't just text scraping; it’s a reliable data pipeline. Intelligent Data Enrichment: The workflow doesn't just extract data—it enriches it. A custom script automatically calculates crucial metrics like wall surface area from the floor dimensions, even using fallback estimates if needed. Automated Aggregation: It goes beyond individual rooms by automatically calculating totals per floor level and per room type, providing immediate, actionable insights. While this demo shows the core classification and measurement (Step 1), the full commercial version includes Step 2 & 3 (Automated Offer Generation), currently in use by a client in the construction industry. Test the Live MVP 📋 Requirements Jigsaw Stack API Key n8n Instance Webhook Endpoint 🎨 Customization Adjust thresholds, fine‑tune heuristics, or swap OCR providers to better match your business needs and downstream integrations. An n8n automation workflow template by Stephan Koning.

By Issam AGGOUR

Transform Your Telegram into a Smart Recipe Assistant! Tired of scrolling through messy notes and bookmarks to find your favorite recipes? Wish you had a personal chef's assistant to help you in the kitchen? Introducing the Culinary Companion for Telegram, an n8n workflow that turns your Telegram app into a powerful, AI-driven recipe management tool, using Google Sheets as your database. 🚀 Key Features Telegram Bot Interface:** Interact with your recipe book using simple text commands. Google Sheets Database:** Your single source of truth for recipes, easily viewable and editable outside of Telegram. AI-Powered Recipe Assistant:** Utilizes Google Gemini or OpenAI to understand natural language for creating, modifying, and searching for recipes. Full Recipe Management (CRUD):** Create: Add new recipes conversationally. Read: Fetch your full recipe list or view a single, detailed recipe card. Update: Modify existing recipes with AI assistance. Command-Driven & AI-Driven:** Use simple commands for direct actions (/list, /select) or have a conversation with the AI for more complex tasks (/search, /create, /modify). Formatted for Mobile:** All responses are sent in clean, readable Markdown, perfect for viewing on the go. ⚙️ How It Works The workflow is triggered by messages sent to your Telegram bot. A central Command Router (Switch node) determines the user's intent and directs the flow to the appropriate tool. 1. Command Routing A Telegram Trigger node listens for any new message. The Command Router (Switch node) immediately inspects the message text for keywords like /list, /select, /create, etc. Based on the command, the workflow branches into either a simple data fetch or a more complex AI-powered action. 2. Simple Recipe Lookups (/list & /select) /list:** The Read Recipe Names (Google Sheets node) fetches all values from column A of your sheet. A Format List Message (Code node) transforms the raw data into a clean, numbered list. The formatted list is sent to you via the Telegram Send Recipe List node. /select [recipe name]:** The Extract Select Param (Code node) isolates the recipe name from your command. The Lookup Recipe Row (Google Sheets node) searches for that specific recipe in your sheet and returns its full row of data. A Format Full Recipe (Code node) assembles the data into a beautifully formatted recipe card, complete with emojis and sections for ingredients, instructions, and notes. The final recipe card is sent via the Telegram Send Full Recipe node. 3. AI-Powered Recipe Management (/search, /create, /modify) For more complex tasks, the workflow leverages a powerful AI agent. The user's command (e.g., /search chicken and rice or /create a pasta dish) is passed to the Recipe AI Agent. This agent is powered by either Google Gemini or an OpenAI Model. It is given a specific system prompt to act as a helpful, food-focused assistant with access to a set of tools. Tools Available to the AI:** Read Recipes Sheet: Allows the AI to read the entire Google Sheet to answer broad questions or find recipes based on ingredients. Update Recipes Sheet: Gives the AI the power to add new rows (new recipes) or modify existing ones based on your conversation. Think: A tool that allows the agent to process complex requests step-by-step before acting. Conversation Memory:** The agent remembers the last few messages, allowing you to have a natural, back-and-forth conversation (e.g., "Create a new recipe" -> "What should it be called?" -> "Spicy Tacos"). The AI's final, formatted response is sent back to you via the Telegram Send AI Response node. 🛠️ Setup Steps & Credentials Telegram Bot: Create a bot with @BotFather on Telegram to get your API token. Add this token as a credential for the Telegram Trigger and all Telegram sender nodes. Google Sheets: Create a new Google Sheet. Set up the first row with headers: Recipe Name, Cooking Time, Ingredients, Instructions, Notes. Copy the Sheet ID from the URL (it's the long string of characters in the middle). Paste the Sheet ID into the relevant fields in the Read Recipe Names, Lookup Recipe Row, and the Google Sheets Tools (Read Recipes Sheet, Update Recipes Sheet). Create Google OAuth2 credentials and connect them to all Google Sheets and Google Sheets Tool nodes. AI Provider (Choose One): For Google Gemini: Get an API key from Google AI Studio, create a Google Gemini(PaLM) Api credential, and connect it to the Google Gemini Chat Model node. For OpenAI: Get an API key from OpenAI, create an OpenAI credential, and connect it to the OpenAI Chat Model node. Note: You only need to enable one of the two AI models. 💡 Customization & Learning Expand Your Database:* Add more columns to your Google Sheet like Cuisine, Difficulty, or Rating, and modify the *Format Full Recipe** node to display them. Enhance the AI:* Edit the system prompt in the *Recipe AI Agent** to change its personality or give it more specific instructions. Add New Tools:** Create new tools for the AI agent, such as a function to fetch nutritional information from an external API based on ingredients. Different Triggers:** Instead of a Telegram bot, you could trigger the /create function from a simple web form. An n8n automation workflow template by Issam AGGOUR.

By KlickTipp

Community Node Disclaimer: This workflow uses KlickTipp community nodes. How It Works Automate transactional emails from KlickTipp to Gmail This workflow receives contact data from a KlickTipp Outbound rule, generates a personalized HTML email, and sends it via Gmail. Key fields (e.g., first name, company, website, phone, or other custom fields) are dynamically mapped into the body. After sending, the workflow saves the email’s HTML content and writes back an Email delivery status (“Sent” or “Failed”) to the contact in KlickTipp for clear visibility. Key Features KlickTipp Outbound Trigger Starts when a KlickTipp Outbound rule calls the webhook (e.g., after a tag is applied). Accepts payload with recipient email and optional custom fields (first name, company, website, phone, etc.). Easy to adapt for confirmations, updates, welcomes, and announcements. HTML Email Composer Builds a clean, brandable HTML template with safe fallbacks. Supports per-contact personalization via mapped fields. Gmail Delivery Sends via Gmail (OAuth) with From/Reply-To, Subject, and HTML body. Supports CC/BCC and attachments if needed. Delivery Status Write-Back On success: updates a KlickTipp custom field (e.g., Email delivery status = Sent). On error: updates the same field to Failed (error details available in execution logs). Setup Instructions Install and Configure Nodes Add/enable KlickTipp community nodes and authenticate with valid API credentials. Create/authorize a Gmail credential (OAuth) and select it in the Send an email node. Paste/import your HTML into the Generate HTML template node. Activate the workflow. Workflow Logic Trigger from KlickTipp: Outbound sends contact data to the workflow. Generate HTML: Build personalized HTML (and optional plain-text). Send via Gmail: Deliver the message with the Gmail node. On Success: Update KlickTipp contact → Email delivery status: Sent. On Error: Update KlickTipp contact → Email delivery status: Failed (see logs for details). Benefits Immediate, personalized communication** without manual steps. Consistent branding** with reusable HTML templates. Clear observability** by writing back delivery status to KlickTipp. Flexible & extensible** for many message types beyond payments. Testing and Deployment Tag a test contact in KlickTipp to trigger the Outbound rule. Verify the Gmail email arrives with correct personalization. Confirm the Email delivery status field updates to Sent (or Failed for negative tests). Review execution logs and adjust field mappings if necessary. Notes Customization:** Swap templates, add CC/BCC, attachments, or a plain-text part for deliverability. An n8n automation workflow template by KlickTipp.

By Oriol Seguí

Optimize your WordPress titles and meta descriptions with AI (OpenAI), update them directly in Yoast SEO, log results in Google Sheets, and receive a styled report by email. All from your own n8n instance. ✨ Why this workflow? Forget spending hours editing metadata manually: this flow automates SEO generation and updates with the help of AI. Fully documented**: every block includes notes so you can easily understand how it works. Error-proof**: reinforced with alternatives and clear alerts if something fails (nested sitemaps, blocks, etc). Flexible and easy to modify**: change language, keywords, or domain in one single node (OPTIONS). Basic support included**: designed so anyone can set it up without being an expert. 🧠 What does the workflow do? Reads the sitemap or internal WordPress URLs (posts or pages). The website content is sent to ChatGPT (GPT-5-nano), which analyzes it and generates a personalized SEO title and meta description for higher precision. Updates the Yoast SEO fields in WordPress automatically. Logs each result (URL, TITLE, META) into Google Sheets. Sends a professional HTML email report with a summary of the updates. 🛠️ Technologies & APIs Used n8n** (cloud or self-hosted instance). OpenAI** (GPT-5-nano / GPT-4o-mini). Google Sheets API** (to store results). Gmail/SMTP** (for notifications). Yoast SEO plugin in WordPress** (required to update meta fields). ⚡ Who is it for? Agencies & SEOs** managing multiple sites. Freelancers** delivering extra value to clients. Businesses with WordPress** wanting to improve SEO without expensive SaaS. Webmasters & marketers** needing clear, automated reporting. Curious in the world of n8n 🎯 Problems solved No more manual editing of metadata for each post or page. Eliminates dependence on overpriced third-party tools. Creates an automatic SEO history of your site in Google Sheets. Sends clear, professional reports of every update. 📝 Quick Setup Import the .json into your n8n. Add your credentials: WordPress API (Yoast SEO installed required). OpenAI API Key. Google Sheets (optional). Email (SMTP or Gmail). Adjust language, keywords, and domain in the OPTIONS node. Run manually or via webhook. 💡 Tips Change the language in OPTIONS to adapt SEO outputs to your target market. If an error occurs (invalid sitemap, blocked URLs, etc.), the workflow catches it and gives you instructions. 100% customizable: extend it to Notion, Slack, or other outputs. 📦 What’s included? n8n workflow file (.json)**. Internal documentation notes inside the flow. Basic email support. 👉 This workflow is your SEO co-pilot: fast, automated, documented, and robust. An n8n automation workflow template by Oriol Seguí.

By KlickTipp

Community Node Disclaimer: This workflow uses KlickTipp community nodes. Introduction This workflow listens to Zoom webinar.ended events, validates the webhook (HMAC), fetches the past webinar details/participants, and tags each participant in KlickTipp based on attendance thresholds (e.g., ≥90%, ≥60%). It supports routing by webinar topic (Anfänger vs. Experten) so you can run differentiated follow-ups automatically. Benefits Hands-off segmentation** based on real attendance Accurate follow-ups** (full, partial, or no attendance) Scales to multiple webinars** with simple rule extensions Key Features Webhook validation** for Zoom URL registration (HMAC SHA256) Zoom API calls** to retrieve past webinar & participants by UUID Routing by webinar name** (Beginner/Expert) Attendance thresholds** via IF nodes (≥90% full, 60–89% partial) KlickTipp tagging** for engagement-driven campaigns Tags (KlickTipp Setup) Zoom webinar E-Mail Zustellung für Anfänger Zoom webinar E-Mail Zustellung für Anfänger attended Zoom webinar E-Mail Zustellung für Anfänger attended fully Zoom webinar E-Mail Zustellung für Anfänger not attended Zoom webinar E-Mail Zustellung für Experten Zoom webinar E-Mail Zustellung für Experten attended Zoom webinar E-Mail Zustellung für Experten attended fully Zoom webinar E-Mail Zustellung für Experten not attended Important Note This workflow is based on the companion workflow “Automate Webinar Registration with Zoom & KlickTipp Form Integration”. ➡️ Both workflows must be activated together for the automations to function correctly. In KlickTipp you should: Create a landing page for webinar registration. Set up an email campaign for invitations and follow-ups. Manually create the necessary tags based on list above** Testing & Deployment End a Zoom webinar tied to this flow. Confirm the webhook triggers and participants are fetched. Verify the correct attendance tags appear on contacts in KlickTipp. > 💡 Tip: Use test emails and tweak duration to simulate different attendance bands. Customization Adjust thresholds (e.g., 80% for “full”) in IF nodes. Duplicate routing/tag blocks to support more webinar topics. Add error handling (e.g., retries or alerts) for API edge cases. Resources: Use KlickTipp Community Node in n8n Automate Workflows: KlickTipp Integration in n8n. An n8n automation workflow template by KlickTipp.

By KlickTipp

Community Node Disclaimer: This workflow uses KlickTipp community nodes. Introduction This workflow automates Zoom recurring webinar registrations by capturing form submissions from a KlickTipp Landingpage and enriching contacts with webinar details. Depending on the registrant’s webinar choice (for example “E-Mail Zustellung für Anfänger” or “E-Mail Zustellung für Experten”), the system fetches the correct Zoom webinar info and writes it into KlickTipp. Ideal for running scalable webinar funnels without manual data entry. Benefits Instant contact enrichment**: Automatically populates KlickTipp with Zoom join links and session times. Dynamic segmentation**: Applies specific tags for “Beginner” or “Expert” webinar participants. Scalable structure**: Router logic allows easy extension for more webinar types. Key Features KlickTipp Trigger**: Starts the workflow when a landing-page form is submitted via outbound webhook. Switch Router**: Routes based on the webinar selection. Supports multiple webinar options. Zoom API Integration**: Retrieves recurring webinar data including join URL and future occurrences. webinar IDs are set per path (Beginner vs Expert). KlickTipp Contact Sync**: Updates or subscribes contacts in the correct list. Writes custom fields for join link and next session timestamp. Applies topic-specific tags for segmentation. Custom Fields (KlickTipp Setup) | Name | Field type | |---------------------------------|----------------| | Zoom \| webinar choice | Line Text | | Zoom \| webinar start timestamp | Date & Time | | Zoom \| Join URL | URL | | Zoom \| Registration ID | Line Text | | Zoom \| Duration webinar | Line Text | Tags (Segmentation) Zoom webinar E-Mail Zustellung für Anfänger Zoom webinar E-Mail Zustellung für Experten Setup Instructions KlickTipp Preparation Create the custom fields above. Add dropdown for webinar choice on landing page. Configure outbound webhook to n8n. Credential Configuration Authenticate KlickTipp API. Connect Zoom via OAuth2 (webinar:write:registrant scope). Insert correct Zoom webinar IDs in workflow nodes. Field Mapping Map the zoom data to the newly created KlickTipp custom fields. Ensure tags match campaign setup. Testing and Deployment Submit a registration form. Confirm workflow triggers and Zoom data is fetched. Verify KlickTipp contact is updated with: Join URL Start timestamp Correct segmentation tag ⚠️ Note: Zoom OAuth tokens may expire — refresh when needed. Zoom may also enforce API rate limits. Campaign Expansion Ideas Add more webinar types and extend router. Build reminder and follow-up campaigns in KlickTipp by tag. Track attendance tags for automated post-event actions. Customization Adapt Zoom nodes for webinars. Add fallback logic if Zoom data is missing. Trigger cross-tool automations (CRM, Slack, invoicing). Resources: Use KlickTipp Community Node in n8n Automate Workflows: KlickTipp Integration in n8n. An n8n automation workflow template by KlickTipp.

By Arkadiusz

📝 Workflow Description This workflow creates a conversational bridge between Telegram / n8n Chat and Home Assistant. It allows users to control smart home devices or request information using natural language (text or voice). ⸻ 🔑 Key Features Multi-channel input: Works with both Telegram and n8n’s chat interface. Voice support: Telegram voice messages are transcribed to text using OpenAI Whisper. AI-driven assistant: Google Gemini processes queries in natural language. Home Assistant integration: Uses MCP client tools to execute actions like turning devices on/off, adjusting lights, or broadcasting messages. Memory management: Short-term memory keeps context within conversations. Smart reply routing: Responses are automatically sent back to the correct channel (Telegram or chat). Message formatting: Telegram replies are beautified (bold, bullet points, inline code, links). ⸻ 📌 Node Overview Telegram Trigger: Captures incoming Telegram messages (text or voice). Bot Is Typing: Sends a “typing…” action to indicate the bot is working. Voice or Text: Separates voice and text inputs. Get Voice File → Speech to Text → Transcription to ChatInput: Handles Telegram voice notes by downloading the file, transcribing it, and preparing it for the chat pipeline. When Chat Message Received: Captures messages from n8n’s built-in chat interface. Process Messages: Normalizes incoming data (input text, source, session ID, voice flag). Home Agent: Main AI agent that processes queries. Google Gemini Chat Model: Language model for intent understanding and conversation. Simple Memory & Simple Memory1: Buffer memories to preserve conversation context. Home Assistant Connector: MCP client node that executes smart home actions (turn on/off devices, adjust lights, etc.). Reply Router: Routes the assistant’s response either to Telegram or to the n8n chat webhook. Telegram Message Beautifier → Telegram Send: Formats and sends responses back to Telegram. Respond to Webhook: Sends responses to n8n chat. ⸻ 🚀 Example Use Cases Send “Turn on the living room lights” via Telegram → Bot triggers Home Assistant action. Ask “What’s the temperature in the bedroom?” → Response comes back formatted in Telegram. Record a voice note “Goodnight mode” → Automatically transcribed and executed by Home Assistant. Use n8n chat to quickly trigger automations or check device statuses. ⸻ ⚡️ Benefits Unified chat & voice control for Home Assistant. AI-powered natural language understanding. Works seamlessly across platforms (Telegram & n8n chat). Extensible: new tools or intents can be added easily. An n8n automation workflow template by Arkadiusz.

By Max

N8N Automated Twitter Reply Bot Workflow For latest version, check: dziura.online/automation Latest documentation can be find here You must have Apify community node installed before pasting the JSON to your workflow.  Overview This n8n workflow creates an intelligent Twitter/X reply bot that automatically scrapes tweets based on keywords or communities, analyzes them using AI, generates contextually appropriate replies, and posts them while avoiding duplicates. The bot operates on a schedule with intelligent timing and retry mechanisms. Key Features Automated tweet scraping** from Twitter/X using Apify actors AI-powered reply generation** using LLM (Large Language Model) Duplicate prevention** via MongoDB storage Smart scheduling** with timezone awareness and natural posting patterns Retry mechanism** with failure tracking Telegram notifications** for status updates Manual trigger** option via Telegram command Required Credentials & Setup 1\. Telegram Bot Create a bot via @BotFather on Telegram Get your Telegram chat ID to receive status messages Credential needed**: Telegram account (Bot token) 2\. MongoDB Database Set up a MongoDB database to store replied tweets and prevent duplicates Create a collection (default name: collection\_name) Credential needed**: MongoDB account (Connection string) Tutorial**: MongoDB Connection Guide 3\. Apify Account Sign up at Apify.com Primary actors used**: Search Actor: api-ninja/x-twitter-advanced-search - For keyword-based tweet scraping (ID: 0oVSlMlAX47R2EyoP) Community Actor: api-ninja/x-twitter-community-search-post-scraper - For community-based tweet scraping (ID: upbwCMnBATzmzcaNu) Credential needed**: Apify account (API token) 4\. OpenRouter (LLM Provider) Sign up at OpenRouter.ai Used for AI-powered tweet analysis and reply generation Model used**: x-ai/grok-3 (configurable) Credential needed**: OpenRouter account (API key) 5\. Twitter/X API Set up developer account at developer.x.com Note**: Free tier limited to ~17 posts per day Credential needed**: X account (OAuth2 credentials) Workflow Components Trigger Nodes 1\. Schedule Trigger Purpose**: Runs automatically every 20 minutes Smart timing**: Only active between 7 AM - 11:59 PM (configurable timezone) Randomization**: Built-in probability control (~28% execution chance) to mimic natural posting patterns 2\. Manual Trigger Purpose**: Manual execution for testing 3\. Telegram Trigger Purpose**: Manual execution via /reply command in Telegram Usage**: Send /reply to your bot to trigger the workflow manually Data Processing Flow 1\. MongoDB Query (Find documents) Purpose**: Retrieves previously replied tweet IDs to avoid duplicates Collection**: collection\_name (configure to match your setup) Projection**: Only fetches tweet\_id field for efficiency 2\. Data Aggregation (Aggregate1) Purpose**: Consolidates tweet IDs into a single array for filtering 3\. Keyword/Community Selection (Keyword/Community List) Purpose**: Defines search terms and communities Configuration**: Edit the JSON to include your keywords and Twitter community IDs Format:{   "keyword\_community\_list": \[     "SaaS",     "Entrepreneur",      "1488663855127535616"  // Community ID (19-digit number)   \],   "failure": 0 } 4\. Random Selection (Randomized community, keyword) Purpose**: Randomly selects one item from the list to ensure variety 5\. Routing Logic (If4) Purpose**: Determines whether to use Community search or Keyword search Logic**: Uses regex to detect 19-digit community IDs vs keywords Tweet Scraping (Apify Actors) Community Search Actor Actor**: api-ninja/x-twitter-community-search-post-scraper Purpose**: Scrapes tweets from specific Twitter communities Configuration:{   "communityIds": \["COMMUNITY\_ID"\],   "numberOfTweets": 40 } Search Actor Actor**: api-ninja/x-twitter-advanced-search Purpose**: Scrapes tweets based on keywords Configuration:{   "contentLanguage": "en",   "engagementMinLikes": 10,   "engagementMinReplies": 5,   "numberOfTweets": 20,   "query": "KEYWORD",   "timeWithinTime": "2d",   "tweetTypes": \["original"\],   "usersBlueVerifiedOnly": true } Filtering System (Community filter) The workflow applies multiple filters to ensure high-quality replies: Text length**: >60 characters (substantial content) Follower count**: >100 followers (audience reach) Engagement**: >10 likes, >3 replies (proven engagement) Language**: English only Views**: >100 views (visibility) Duplicate check**: Not previously replied to Recency**: Within 2 days (configurable in actor settings) AI-Powered Reply Generation LLM Chain (Basic LLM Chain) Purpose**: Analyzes filtered tweets and generates contextually appropriate replies Model**: Grok-3 via OpenRouter (configurable) Features**: Engagement potential scoring User authority analysis Timing optimization Multiple reply styles (witty, informative, supportive, etc.) <100 character limit for optimal engagement Output Parser (Structured Output Parser) Purpose**: Ensures consistent JSON output format Schema:{   "selected\_tweet\_id": "tweet\_id\_here",   "screen\_name": "author\_screen\_name",    "reply": "generated\_reply\_here" } Posting & Notification System Twitter Posting (Create Tweet) Purpose**: Posts the generated reply as a Twitter response Error handling**: Catches API limitations and rate limits Status Notifications Success**: Notifies via Telegram with tweet link and reply text Failure**: Notifies about API limitations or errors Format**: HTML-formatted messages with clickable links Database Storage (Insert documents) Purpose**: Saves successful replies to prevent future duplicates Fields stored**: tweet\_id, screen\_name, reply, tweet\_url, timestamp Retry Mechanism The workflow includes intelligent retry logic: Failure Counter (If5, Increment Failure Counter1) Logic**: If no suitable tweets found, increment failure counter Retry limit**: Maximum 3 retries with different random keywords Wait time**: 3-second delay between retries Final Failure Notification Trigger**: After 4 failed attempts Action**: Sends Telegram notification about unsuccessful search Recovery**: Manual retry available via /reply command Configuration Guide Essential Settings to Modify MongoDB Collection Name: Update collection\_name in MongoDB nodes Telegram Chat ID: Replace 11111111111 with your actual chat ID Keywords/Communities: Edit the list in Keyword/Community List node Timezone: Update timezone in Code node (currently set to Europe/Kyiv) Actor Selection: Enable only one actor (Community OR Search) based on your needs Filter Customization Adjust filters in Community filter node based on your requirements: Minimum engagement thresholds Text length requirements Time windows Language preferences LLM Customization Modify the AI prompt in Basic LLM Chain to: Change reply style and tone Adjust engagement criteria Modify scoring algorithms Set different character limits Usage Tips Start small: Begin with a few high-quality keywords/communities Monitor performance: Use Telegram notifications to track success rates Adjust filters: Fine-tune based on the quality of generated replies Respect limits: Twitter's free tier allows ~17 posts/day Test manually: Use /reply command for testing before scheduling Troubleshooting Common Issues No tweets found: Adjust filter criteria or check keywords API rate limits: Reduce posting frequency or upgrade Twitter API plan MongoDB connection: Verify connection string and collection name Apify quota: Monitor Apify usage limits LLM failures: Check OpenRouter credits and model availability Best Practices Monitor your bot's replies for quality and appropriateness Regularly update keywords to stay relevant Keep an eye on engagement metrics Adjust timing based on your audience's activity patterns Maintain a balanced posting frequency to avoid appearing spammy Documentation Links Full Documentation**: Google Doc Guide Latest Version**: dziura.online/automation MongoDB Setup Tutorial**: YouTube Guide This workflow provides a comprehensive solution for automated, intelligent Twitter engagement while maintaining quality and avoiding spam-like behavior. An n8n automation workflow template by Max.

By FabioInTech

B2B Leads Gen - ANY (CITY / BUSINESS) IN THE WORLD 🤖 Generate B2B sales leads from Google Maps, enrich data (email) with AI Agent + Jina.ai and save to Airtable. This workflow generates comprehensive B2B leads, from a selected Business type in ANY CITY IN THE WORLD, including: Company name; Website; Email (enriched with AI Agent); Phone number; Address; Main Language; Google Maps location. More information can be added! It starts by searching for a specific business type in any city you define. First, it uses an AI agent to build an optimized query for the Official Google Places (GMaps) API. After finding businesses and their basic details, it employs a second, specialized AI web scraping agent to visit each company's website and find a contact email. Finally, all enriched lead data is neatly organized and saved to an Airtable base. 🤔 Who's it for This workflow is designed for: Sales and Business Development Teams** looking to automate lead generation and build targeted outreach lists. Marketing Professionals** who need to gather contact information for campaigns. Freelancers and Agencies** offering lead generation as a service. Anyone who wants to save time on manually searching for business information online. ⚙️ How it works This workflow automates the entire lead generation process from start to finish: Trigger with a Form: The workflow starts when you fill out a simple form, providing the Country, City, and Business Type you want to target. AI-Powered Search Query: An AI agent validates your input and constructs an optimized search query for the Google Places API to ensure the best possible results. Find Businesses on Google Maps: Using the generated query, the workflow makes an HTTP request to the Google Places API, fetching up to 20 businesses that match your criteria. Filter for Quality Leads: It processes the results and filters out any businesses that are not listed as "OPERATIONAL" or do not have a website, ensuring you only get relevant leads. AI Email Enrichment: For each valid business, a specialized web scraping AI agent (using Jina AI) visits the company's website. It intelligently navigates the site, following links like /contact or /about, to find a contact email address. Save to Airtable: Once a business's information is enriched with an email, the workflow saves the complete lead as a new record in your specified Airtable base. 🚀 How to set up Follow these steps to get your automated lead generation engine up and running. 1. Create your Airtable Base First, create a new Airtable base with a table to store your leads. The workflow is configured to map data to the following fields. It's recommended to use these exact names and types for a seamless setup. | Field Name | Field Type | Description | | ------------------------- | -------------------- | ------------------------------------------------- | | Company_name | Single line text | The name of the business. | | Company_website | URL | The business's website URL. | | Company_e-mail | Email | The contact email found by the AI scraper. | | Company_address | Long text | The full physical address of the business. | | Company_phone | Phone number | The business's international phone number. | | Primary_type | Single line text | The primary business category from Google Maps. | | Google_maps_location | URL | A direct link to the business on Google Maps. | | processed | Single select | A status field, set to "no" by default. | | create_date | Date ISO (24h) | Automatically records when the lead was added. | | Language_code | Single line text | The language code of the business name (e.g., en).| 2. Configure the Workflow Add Credentials: Airtable: Add your Airtable Personal Access Token in Credentials > New > Airtable. OpenAI: Add your OpenAI API key in Credentials > New > OpenAI. Jina AI: Add your Jina AI API key in Credentials > New > Jina AI. Set API Keys and Airtable Info: In the workflow, find the Places\_API\_Key node (a Set node) and paste your Google Places API key into the Value field for the google_places_api variable. Select the Create a record node (Airtable). In the parameters, select your Airtable credential. For the Base and Table parameters, select the base and table you created in the previous step. Activate and Launch: Save and activate the workflow. To run it, click "Execute Workflow" and use the form trigger that appears. ✅ Requirements An n8n instance. An Airtable (free) account. A Google Cloud Platform account with the Places API enabled. See manual (Google Places API Setup Guide) for full instructions. An OpenAI account and API key. A Jina AI account and API key. 🎨 How to customize the workflow Adjust the Number of Leads:* In the *Google Places Search** (HTTP Request) node, you can change the pageSize value in the JSON Body to fetch more or fewer than 20 results per execution. Be mindful of Google's API limits. Change the AI Model:* The workflow uses OpenAI by default. You can swap the *GPT-5-mini** nodes for other language models like Anthropic, Google Gemini, or a local AI model. Add Different Outputs:* The workflow includes disabled nodes to save leads to an Excel file (Convert to File) or send a notification to Slack (Finish message*). Enable and configure them to add more outputs. You can also replace Airtable with Google Sheets, a CRM, or a database. Modify the Scraping Agent:* You can edit the prompt in the *Web Scraping Agent** node to change its behavior. For example, you could instruct it to look for a specific job title's email, a phone number, or other information on the website. 🙋 Need Help? Need a Professional and Personalized automation Contact me DevQuick If you have any questions or get stuck, feel free to ask for help in our community. Join the Discord or ask in the Forum. An n8n automation workflow template by FabioInTech.

By Cong Nguyen

👀 Short Description Turn form submissions into AI-curated quotes with SKU selection straight from Qdrant, branded PDF generation, and automatic email—now streamlined for quoting only (FAQ removed). (Improved from the previous workflow: Automated Request-to-Quote System with OpenAI, Google Sheets & CraftMyPDF Email Delivery) 🎉What’s new vs. the old version Products now come directly from Qdrant (no Google Sheets catalog in the loop). Focused quote-only flow — removed FAQ/RAG nodes for a leaner, faster pipeline. Agent enforces a JSON-only contract, keeping pricing/stock grounded in Qdrant payloads. Easier to maintain; fewer moving parts and lower token usage. 📄 What this workflow does Captures lead details via Form: Request a Quote. Searches your Qdrant collection (products) for relevant SKUs by keyword, use-case, features, and budget hints. An AI Agent (OpenAI) selects in-stock SKUs, respects min_qty, and returns a strict JSON quote (optional discount ≤ 10%). A Code step computes line totals, discount, VAT, generates a unique invoice_number (e.g., Q-YYYYMMDD-ABCDE), and validates or falls back the due_date. CraftMyPDF renders a branded PDF; the file is fetched and SMTP emails the quote to the customer. 👤 Who this is for SMBs and sales teams needing instant, accurate quotes from website forms. Ops teams storing product data in Qdrant and wanting AI-assisted SKU selection. Agencies or shops that must generate consistent, branded PDFs and send them automatically. ✅ Requirements Self-hosted n8n instance. Qdrant collection (default: products) with payload fields: sku, name, uom, unit_price, currency, in_stock (true/false), min_qty, handle/url, features. Connected credentials: OpenAI (or compatible), Qdrant API, CraftMyPDF, SMTP. A CraftMyPDF template aligned with the Code node output (invoice_number, items[], gross_total, etc.). ⚙️ How to set up Import the workflow JSON into n8n. In Qdrant Vector Store (Products), set collection=products and your Qdrant API credentials. In Sales Quote Agent, keep or change the model (default gpt-4.1-mini) and the JSON-only system prompt. In Create a PDF, set your CraftMyPDF templateId. In Email: Send Quote, set fromEmail and SMTP credentials. Submit a test form; verify: Agent JSON → PDF render → email delivery. (Optional) Adjust defaults in the Code node: vat_pct (default 10), payment_terms, currency fallback, valid_days. 🔁 How it works (end-to-end) Trigger → Form captures: Full Name, Email, Company, Requirements, Budget Min/Max, Need By, Notes. Product Search → Agent calls PRODUCTS_QDRANT to retrieve relevant SKUs and payload fields from Qdrant. Agent Quote → Selects SKUs and qty, applies pricing and ≤10% discount. 💡 About Margin AI Margin AI is your AI Service Companion. We help organizations design intelligent, human-centric automation — from content pipelines and branding workflows to customer insights and sales enablement. Our tailored AI solutions scale marketing, operations, and creative processes with ease. An n8n automation workflow template by Cong Nguyen.

By Intuz

This n8n template from Intuz provides a complete solution to automate your accounting by instantly creating QuickBooks sales receipts for every new Stripe payment. This workflow automates the process of recording successful payments from Stripe into QuickBooks by creating corresponding Sales Receipts. It ensures payment data is captured accurately, checks whether the customer exists in QuickBooks, and creates a new customer if necessary before generating the receipt. This integration streamlines bookkeeping by eliminating manual data entry and ensuring all payment records are synchronized between systems. Who's this workflow for? Accountants & Bookkeepers Small Business Owners E-commerce Managers Finance Teams How it works 1. Trigger on Successful Payment: The workflow starts instantly when a payment_intent.succeeded event is received from Stripe via a webhook. This means it only runs after a payment is confirmed. 2. Get Customer Details: It uses the customer ID from the payment to fetch the customer's full details (name and email) from Stripe. 3. Check for Customer in QuickBooks: The workflow then searches your QuickBooks account to see if a customer with that name already exists. 4. Create Customer if New: If the customer is not found in QuickBooks, a new customer record is automatically created using the information from Stripe. 5. Generate Sales Receipt: Finally, using the correct customer record (either existing or newly created) and the payment amount, the workflow creates and saves a new sales receipt in QuickBooks, perfectly matching the Stripe transaction. Key Requirements to Use This Template 1. n8n Instance: An active n8n account (Cloud or self-hosted). 2. Stripe Account: An active Stripe account with API access. You must be able to create and manage webhooks. 3. QuickBooks Online Account: An active QuickBooks Online account with API access to manage customers and sales receipts. Setup Instructions 1. Configure the Webhook Trigger: Copy the webhook URL from the Capture Payment (Webhook) node in n8n. In your Stripe dashboard, go to Developers > Webhooks and add a new endpoint. Paste the n8n webhook URL and have it listen for the payment_intent.succeeded event. 2. Connect Stripe: In the Get a customer node, connect your Stripe account credentials. 3. Connect QuickBooks: In all three QuickBooks nodes (Find Customer, Create a customer, and Create a payment), connect your QuickBooks Online account using OAuth2 credentials. 4. Activate Workflow: Save the workflow and toggle the "Active" switch to ON. Your accounting automation is now live! Connect with us Website: https://www.intuz.com/n8n-workflow-automation-templates Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.

By Ninja - Abbas

Transform your email workflow with this intelligent automation that drafts professional emails through Telegram commands using AI and contact retrieval. Key Features 📱 Telegram Integration: Send email requests directly from Telegram 🤖 AI-Powered Email Generation: Uses OpenAI GPT-4 to create formal, professional emails 📧 Smart Contact Retrieval: Leverages Pinecone vector database with RAG to automatically find recipient email addresses ✉️ Gmail Draft Creation: Automatically creates email drafts in your Gmail account 📋 Google Docs Integration: Sync contact data from Google Docs to vector database 🎯 Structured Email Formatting: Ensures consistent professional email format with proper recipients and formal tone How It Works Send Message: Send a message via Telegram with your email request AI Processing: AI agent processes your request and queries the contact database to find recipient emails Email Generation: OpenAI generates a professionally formatted email based on your input Draft Creation: Gmail draft is automatically created with the formatted content Confirmation: Receive confirmation via Telegram with a completion sticker Perfect For Business professionals managing multiple contacts Academic professionals (professors, researchers) who frequently send formal emails Anyone wanting to streamline their email creation process with AI assistance Required Credentials Telegram Bot API OpenAI API google OAuth2 for(gmail&docs) Pinecone Vector Database Setup Instructions Load Contact Data: Add your contact information to the Google Docs document Configure Pinecone: Set up your Pinecone index with namespace "contacts" Connect Services: Add all required API credentials to their respective nodes Customize AI: Modify the AI system message and sender name in the AI Agent node Test Workflow: Run the manual trigger to populate your vector database first ** Ex. of the google docs data. An n8n automation workflow template by Ninja - Abbas.

By Didac Fernandez

Nova AI Content Marketing Agent - LinkedIn & Facebook Automation This n8n template demonstrates how to create a complete AI-powered social media content creation and scheduling system that generates platform-optimized posts for LinkedIn and Facebook with custom images and human approval workflows. Possible use cases: Generate a full week of social media content from a single brand brief Create platform-specific content that maintains brand voice consistency Automate image generation with AI while maintaining quality control Schedule approved content across multiple social platforms Track and organize all content in centralized spreadsheets How it works The automation starts with a form submission collecting 10 brand variables (name, industry, demographics, etc.) Nova AI Agent analyzes the brand information and generates 6 distinct social media posts (3 LinkedIn professional, 3 Facebook community-focused) Content is split by platform and routed to separate image generation workflows Google Imagen 4 Ultra creates custom visuals for each post with platform-specific aspect ratios Each generated image is sent to Slack for human approval via interactive forms If feedback is provided, NanoBanana AI edits the image based on natural language instructions Approved images are uploaded to Google Drive with organized naming conventions All content data is logged to Google Sheets with image URLs and scheduling information Final posts are scheduled via Late API to respective social platforms The workflow loops through each post individually for quality control Requirements OpenRouter API credentials for GPT-5 Mini access Replicate API key for Google Imagen 4 Ultra and NanoBanana Slack OAuth2 credentials with bot permissions Google Drive OAuth2 credentials Google Sheets API access GetLate API key connected to LinkedIn and Facebook accounts Perplexity API for research enhancement (optional) HOW TO USE STEP 1 - Setup Form and Brand Variables Configure the Form Trigger webhook URL for brand data collection Update the 10 form fields with your specific industry placeholders Test the form submission to ensure data flows correctly STEP 2 - Configure AI Services Add your OpenRouter API credentials to both Chat Model nodes Add your Replicate API key to the HTTP Header Auth credential Configure Perplexity API credentials for research functionality Set up custom session keys for memory management STEP 3 - Setup Approval Workflow Add Slack OAuth2 credentials to both "Send message and wait" nodes Update the Slack channel ID to your preferred approval channel Configure the custom form fields for approval/feedback collection STEP 4 - Configure Storage and Scheduling Add Google Drive OAuth2 credentials and update the target folder ID Add Google Sheets credentials and update the spreadsheet ID Get your Late API key from getlate.dev and add to HTTP Header Auth Update the Late accountId in both Schedule Post nodes with your platform IDs STEP 5 - Customize Content Strategy Modify the Nova system prompt to match your brand voice requirements Adjust the visual style requirements in the AI Agent configuration Update posting date logic and timezone settings as needed Test the complete workflow with sample brand data. An n8n automation workflow template by Didac Fernandez.

By BizThrive.ai

📄 Description This workflow automates the extraction of structured invoice data from PDF files sent via Telegram and stores it in Airtable. It leverages GPT-4o for intelligent parsing and includes conversational memory for a seamless user experience. Designed for businesses and freelancers who receive invoices digitally and want to streamline their record-keeping. ⚙️ How It Works Telegram Trigger – Listens for incoming messages and PDF attachments. Switch Node – Filters messages to ensure only PDFs are processed. Extract from File – Parses the PDF content for text extraction. Edit Fields – Prepares the extracted data for AI processing. AI Agent (GPT-4o) – Orchestrates the workflow, prompts the user for missing info, and extracts structured data. Simple Memory – Maintains conversational context across sessions. Create Invoice (Airtable Tool) – Creates a new invoice record in Airtable. Create Line Item (Airtable Tool) – Adds individual line items linked to the invoice. Telegram Response – Sends confirmation back to the user. 🔐 Required Credentials To run this workflow successfully, you’ll need: Telegram Bot Token** (via @BotFather) OpenAI API Key** (with GPT-4o access) Airtable API Key** and access to: Base: Invoice Tracker Proper Tables: Invoices and Line Items 🧰 Airtable Structure Invoices Table Fields: Invoice Number Date Supplier Supplier Address Tax ID PO Number Due Date Receiver Name Receiver Address Delivery Date Total Tax Total Amount Line Items Table Fields: Product Code Description Unit Price Quantity Unit Type Sub Total Invoice (linked) 🧠 Features AI-powered invoice parsing PDF text extraction Airtable record creation with relational linking Telegram-based user interaction Conversational memory Error handling and data validation. An n8n automation workflow template by BizThrive.ai.

By Simone

Overview This workflow automates the process of merging multiple .xlsx files from a designated folder into a single, well-organized Excel workbook. Each input file is converted into its own sheet within the output file. Additionally, a summary sheet is generated at the beginning, providing a convenient overview of all merged files, including their original names and the number of records in each. This is particularly useful for consolidating reports, combining data from different sources, or archiving multiple spreadsheets into one manageable file. How It Works The workflow follows these key steps: Trigger: The process begins when you manually execute the workflow. Read Files: It reads all files ending with the .xlsx extension from the /n8n_files/ directory (ensure your volume is mapped correctly). Process Each File: The workflow iterates through each file one by one. For each file, it extracts the data from the first sheet. Collect and Clean Data: A custom code node gathers the data from all files. It cleans the data by removing any completely empty rows and prepares it for the final Excel generation. The original filename is used to name the new sheet. Generate Multi-Sheet Excel: The core logic resides in a code node that uses the xlsx library. It creates a new Excel workbook in memory, adds a sheet for each processed file, and populates it with the corresponding data. It also creates a "Summary" sheet that lists all the source files and their record counts. Save the Result: The final workbook is saved as a new .xlsx file in the /n8n_files/output/ directory with a timestamped filename (e.g., 合并文件_20250908T123000.xlsx). Setup & Prerequisites To use this workflow, you need to configure your n8n instance to allow and use the external xlsx npm module. Place Your Files: Put all the Excel files you want to merge into the folder that is mapped to /n8n_files/ in your n8n container. Enable External Module: Set the following environment variable for your n8n service in your docker-compose.yml file: environment: NODE_FUNCTION_ALLOW_EXTERNAL=xlsx Install the Module: You must build a custom Docker image for n8n that includes the xlsx library. In the same directory as your docker-compose.yml, create a file named Dockerfile. Add the following content to the Dockerfile: FROM n8nio/n8n:latest USER root RUN npm install xlsx USER node In your docker-compose.yml, replace the image: n8nio/n8n... line with build: . for the n8n service. Rebuild and restart your n8n container using docker-compose up --build -d. Nodes Used Manual Trigger: To start the workflow. Read Write File: To read source files and save the final output file. Split In Batches: To process files one by one. Extract From File: To read the data from each .xlsx file. Code: For custom JavaScript logic to process data and generate the final multi-sheet Excel file using the xlsx library. An n8n automation workflow template by Simone.

By David Olusola

📊 Log BTC/ETH Prices and USD Exchange Rates to Notion (Hourly) 📌 Overview This workflow automatically logs live crypto prices (Bitcoin & Ethereum) and fiat exchange rates (USD→EUR / USD→NGN) into a Notion database every hour. Each entry becomes a new row in your Notion dashboard, letting you visualize currency and crypto trends side by side. It’s perfect for traders, analysts, and anyone who wants a single source of truth in Notion without needing multiple apps open. With hourly updates, you’ll have a clean data history for building rollups, trend graphs, or financial dashboards. ⚙️ How it works Schedule Trigger — runs every hour (adjustable via cron). HTTP Request (ExchangeRate-API) — fetches USD-base FX rates (no API key required). HTTP Request (CoinGecko) — fetches BTC & ETH prices + 24h % change (no API key required). Merge — combines both payloads. Code (v2) — formats a Notion-ready JSON payload with the correct fields. Notion Node — creates a new page in your database with mapped properties. Example Row in Notion: Title: Crypto+FX — 2025-09-08 09:00 BTC: 112,417 | BTC_24h: +1.22% ETH: 4,334.57 | ETH_24h: +1.33% USD→EUR: 0.854 | USD→NGN: ₦1,524.54 🛠 Setup Guide 1) Create the Notion database In Notion, create a new database (Table view). Add these columns with matching property types: | Column | Property Type | |------------|---------------| | Title | Title | | BTC | Number | | BTC_24h | Number | | ETH | Number | | ETH_24h | Number | | USD_EUR | Number | | USD_NGN | Number | 2) Connect Notion in n8n In the Notion “Create Page” node, connect with your Notion OAuth2 credentials. On first use, you’ll be redirected to authorize n8n with your Notion workspace. Copy your Database ID (from the Notion URL) and paste it into the node. 3) Map the Code output The Code node outputs JSON fields: BTC, BTC_24h, ETH, ETH_24h, USD_EUR, USD_NGN. In the Notion node, map each property: BTC → {{$json.BTC}} BTC_24h → {{$json.BTC_24h}} ETH → {{$json.ETH}} ETH_24h → {{$json.ETH_24h}} USD_EUR → {{$json.USD_EUR}} USD_NGN → {{$json.USD_NGN}} 4) Test Run the workflow once. Confirm that a new page is added to your Notion database with all values filled. 🎛 Customization Cadence:** change the schedule to 10 minutes, 4 hours, or daily depending on your needs. Extra coins:** add more IDs (e.g., solana, bnb) in the CoinGecko call and update the Code node. Extra FX pairs:** expand from ExchangeRate-API (e.g., USD→GBP, USD→ZAR). Notion dashboards:** use rollups, charts, and linked databases for trend visualization. Formatting:** add emojis, colors, or sections in your Notion view for clarity. 🧩 Troubleshooting Page not created:** verify Database ID and ensure the Notion API integration has access. Empty fields:** check that property names in Notion exactly match those used in the Code node. Wrong data type:* make sure properties are set as *Number**, not Text. Rate limits:** CoinGecko and ExchangeRate-API are free but may rate-limit if called too often; keep cadence reasonable (hourly recommended). An n8n automation workflow template by David Olusola.

By WeblineIndia

iOS Environment Config Sync Wizard: .env to Xcode This workflow automatically detects changes to .env.staging files, compares them against iOS Xcode configuration files, creates pull requests to sync values, and invalidates Xcode build caches when needed. It ensures consistency between environment files and iOS project configs while automating the propagation of changes across the codebase and notifying the team via email. Quick Implementation Steps Import the workflow JSON into your n8n instance Set up credentials for GitHub and email Configure the webhook URL in your Git repository Customize configuration parameters in the "Set Configuration" node Activate the workflow What It Does The Environment Config Sync for iOS Xcode Projects workflow is designed to maintain consistency between environment configuration files and iOS project configuration files. When changes are made to .env.staging, the workflow automatically detects these changes, determines which iOS configuration files need to be updated, creates a new branch with those updates, and opens a pull request for review. The workflow analyzes the differences between the environment file and iOS configs, identifies which values need to be synchronized, and applies these changes to the appropriate files. It also checks if any of the changed values require cache invalidation and handles this automatically. Finally, it sends a detailed email notification to the iOS team with information about the sync operation. This automation reduces manual work, ensures consistency between configuration files, and helps prevent issues caused by mismatched environment settings across different parts of the iOS build system. Who's It For This workflow is ideal for: iOS development teams managing environment-specific configurations DevOps engineers responsible for maintaining Xcode project configuration consistency Mobile app developers working with multiple environment configurations Teams implementing CI/CD best practices for iOS applications Organizations using environment files to manage build-time configurations for Xcode projects Requirements n8n instance (self-hosted or cloud) GitHub repository with iOS project files Email service (SMTP) for sending notifications .env.staging file or similar environment configuration file iOS configuration files (Info.plist, Config.xcconfig, etc.) How It Works Webhook Trigger: The workflow starts when a push event occurs in the GitHub repository Configuration Setup: Sets up configurable parameters for file paths, branches, and notification settings File Change Detection: Checks if the .env.staging file was modified in the push Config Diff Analysis: Compares the .env.staging file with iOS Xcode configurations to identify differences Branch Creation: Creates a unique branch name and creates a new branch in the repository File Update Preparation: Prepares the updated content for each configuration file File Updates: Updates each configuration file in the new branch with the synced values PR Creation: Creates a pull request with all the configuration changes Cache Invalidation: Invalidates Xcode build cache if necessary based on changed keys Email Notification: Sends a detailed email notification about the completed sync operation How To Set Up Steps to Configure and Use 1\. Import the Workflow Import the provided JSON file into your n8n instance 2\. Set Up Credentials GitHub**: Create a new credential with a GitHub personal access token with repo scope Email**: Create a new credential with your SMTP server details for sending emails 3\. Configure GitHub Webhook Go to your GitHub repository settings Navigate to Webhooks and click "Add webhook" Set the Payload URL to the webhook URL from your n8n workflow Select "application/json" as the content type Choose "Let me select individual events" and select "Push events" Click "Add webhook" 4\. Configure Parameters Modify the parameters in the "Set Configuration" node to match your project structure: envFilePath**: Path to your environment file (default: ".env.staging") configFiles**: Array of iOS config files to update (default: \["Info.plist", "Config.xcconfig"\]) targetBranch**: Branch to create PRs against (default: "main") cacheInvalidationKeys**: Keys that trigger cache invalidation (default: \["API\_KEY", "BUNDLE\_VERSION", "ENVIRONMENT"\]) prLabels**: Labels to apply to created PRs (default: \["config-sync", "automated", "ios"\]) emailTo**: Email address for notifications (default: "ios-team@example.com") 5\. Configure Email Settings In the "Send Email Notification" node, update the "fromEmail" parameter to match your sending email address Ensure your SMTP credentials are properly configured in n8n 6\. Activate the Workflow Once all configurations are complete, activate the workflow Test by making a change to your .env.staging file and pushing it to the repository How To Customize Add More Config Files**: Update the configFiles parameter in the "Set Configuration" node to include additional iOS configuration files like .xcconfig files or project.pbxproj Modify Cache Invalidation Logic**: Update the cacheInvalidationKeys parameter to change which keys trigger cache invalidation Customize PR Content**: Edit the "Create PR" node to modify the PR title, body, or labels Change Email Notifications**: Update the "Send Email Notification" node to modify the email format, subject, or add additional recipients Implement Actual Cache Invalidation**: Modify the "Invalidate Cache" node to implement actual Xcode cache invalidation logic for your CI/CD system Add More Environment Files**: Extend the workflow to monitor additional environment files beyond .env.staging Add‑ons Multi-Environment Support: Extend the workflow to handle multiple environment files (.env.development, .env.production) with different target branches and configurations Configuration Validation: Add validation steps to ensure that environment values match expected formats or patterns before creating PRs Automated PR Merging: Add logic to automatically merge PRs if all checks pass and no conflicts are detected Configuration History Dashboard: Integrate with a database to track configuration changes over time and provide analytics Team Approval Workflow: Add approval steps that require team members to review and approve configuration changes before PRs are created Use Case Examples API Key Rotation: When security policies require rotating API keys, the workflow automatically updates all iOS configuration files with the new keys and invalidates the Xcode build cache to ensure the changes take effect immediately. Environment Promotion: When promoting configurations from staging to production, the workflow ensures that all iOS project files are consistently updated across the codebase, preventing deployment issues caused by mismatched configurations. Bundle Version Updates: When updating bundle versions in .env.staging for a new App Store release, the workflow automatically updates version strings in Info.plist files, ensuring version consistency for App Store submission. Feature Flag Management: When feature flags are added or modified in .env.staging, the workflow propagates these changes to Config.xcconfig files, ensuring that feature flags are consistently available throughout the iOS application. Multi-Target Projects: In projects with multiple iOS targets (e.g., app, extension, watchOS), the workflow can be extended to update configuration files across all targets when environment variables change, ensuring consistency throughout the application ecosystem. Troubleshooting Guide | Issue | Possible Cause | Solution | | --- | --- | --- | | Webhook not triggering | Webhook URL not configured correctly in GitHub | Verify the webhook URL is correctly copied and configured in your GitHub repository settings | | Changes not detected | .env.staging file path doesn't match configuration | Check the envFilePath parameter in the "Set Configuration" node and ensure it matches your file structure | | Branch creation fails | GitHub token doesn't have sufficient permissions | Ensure the GitHub personal access token has the "repo" scope and access to the target repository | | File updates fail | Config file paths don't exist in the repository | Verify the configFiles parameter in the "Set Configuration" node matches actual file paths in your repository | | PR creation fails | Target branch doesn't exist or insufficient permissions | Verify the targetBranch parameter matches an existing branch and the GitHub token has appropriate permissions | | Email notifications not sent | Email credentials not configured or incorrect | Verify your SMTP credentials are correctly configured in n8n and the email address in the "Send Email Notification" node is valid | | Cache invalidation not working | Cache invalidation logic not implemented for your CI/CD system | Modify the "Invalidate Cache" node to implement the appropriate Xcode cache invalidation mechanism for your CI/CD system | | PRs created with no changes | Diff logic not properly detecting differences | Review the "Perform Config Diff" node and ensure it correctly identifies differences between environment and iOS config files | | Workflow stops after file change detection | Workflow logic error in code nodes | Check the JavaScript code in the "Perform Config Diff" node for syntax errors or logic issues | Want to Customize ? Need help setting up or customizing this Environment Config Sync for iOS Xcode Projects workflow? The n8n experts at WeblineIndia can assist you with: Customizing the workflow to fit your specific iOS project structure Integrating with additional tools and services in your CI/CD pipeline Implementing advanced configuration validation and management Setting up multi-environment support and promotion workflows Training your team on iOS configuration management best practices. An n8n automation workflow template by WeblineIndia.

By WeblineIndia

Customer Feedback Loop Analyzer (n8n Automated Workflow) This workflow automates the process of collecting customer feedback from forms and emails, analyzes it using AI, classifies it by category and sentiment, logs it into Google Sheets, and routes it to the right communication channels like Slack or email. It closes the feedback loop efficiently by ensuring every review is categorized, tracked, and acted upon. Who’s it for Product managers wanting structured customer insights Customer support teams needing fast issue routing Engineering teams who want to be alerted to bugs quickly Growth & UX teams tracking feature requests and usability feedback Any business managing customer feedback at scale How it works Form submission trigger captures reviews submitted via customer review forms. Gmail trigger listens for new feedback emails. Extract details (Code node) parses sender details and extracts the actual review text. AI node (LLM) summarizes the feedback, determines sentiment, and classifies it (Bug, Feature Request, UX Issue, Other). Google Gemini (optional) provides advanced classification/summarization. Google Sheets node logs all structured feedback for historical tracking. Switch node routes feedback into separate flows by category. Slack node instantly notifies the team of critical feedback (e.g., Bugs). Email node sends reports to relevant stakeholders (e.g., Feature Requests to product managers). How to set up Import the workflow JSON into your n8n instance. Connect credentials for: Gmail (for receiving/sending feedback) Google Sheets (for logging reviews) Slack (for real-time team alerts) Configure your Google Sheet (columns for Date, Reviewer, Sentiment, Category, Feedback). Adjust the AI node prompt to reflect your team’s preferred categories. Set Slack channels and email recipients for notifications. Activate workflow. Requirements n8n (cloud or self-hosted) Gmail API access (OAuth2 connected in n8n) Google Sheets API access Slack webhook or OAuth connection (Optional) Google Gemini or another LLM integration How to customize Modify the AI prompt to classify into different categories (e.g., “Support Issue”, “Billing Problem”). Extend the Google Sheet schema to include product version, tags, or priority scores. Add a translation step if feedback is multilingual. Replace Slack notifications with Teams/Discord if needed. Connect to Jira or Trello to auto-create tasks for certain categories. Add-ons Sentiment-based alerts**: Trigger Slack notifications only if sentiment is negative. Monthly report generator**: Compile all feedback into a PDF and email it automatically. CRM integration**: Sync categorized feedback into HubSpot or Salesforce. Auto-response emails**: Acknowledge receipt of customer feedback via Gmail. Use Case Examples SaaS product team routes all Bug feedback directly to engineering Slack channel. UX team receives only “UX Issue” categorized feedback for design improvements. Marketing team logs Feature Requests into Google Sheets for roadmap prioritization. Customer support automatically responds with a thank-you email for all submissions. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------ | ----------------------------------------- | ----------------------------------------------------- | | Workflow doesn’t trigger | Gmail/Form node not authenticated | Reconnect Gmail / check webhook form integration | | No data extracted | Code node parsing wrong field | Update regex/parsing logic to match email format | | AI classification fails | Invalid LLM credentials or quota exceeded | Reconnect LLM node / check usage limits | | Feedback not logged | Wrong Google Sheet ID or missing sharing | Verify Sheet ID and grant access to connected account | | Slack messages not sent | Invalid webhook or channel not found | Reconfigure Slack node with valid channel/webhook | | Email reports fail | Gmail OAuth token expired | Refresh Gmail credentials in n8n | Need Help? Our n8n automation experts at WeblineIndia can help you: Fine-tune the AI prompts for better categorization accuracy Build custom dashboards from your Google Sheet data Add multilingual feedback handling Connect to your ticketing system (Jira, Trello, Asana) for seamless issue tracking. An n8n automation workflow template by WeblineIndia.

By Guillaume Duvernay

This template introduces a revolutionary approach to automated web research. Instead of a rigid workflow that can only find one type of information, this system uses a "thinker" and "doer" AI architecture. It dynamically interprets your plain-English research request, designs a custom spreadsheet (CSV) with the perfect columns for your goal, and then deploys a web-scraping AI to fill it out. It's like having an expert research assistant who not only finds the data you need but also builds the perfect container for it on the fly. Whether you're looking for sales leads, competitor data, or market trends, this workflow adapts to your request and delivers a perfectly structured, ready-to-use dataset every time. Who is this for? Sales & marketing teams:** Generate targeted lead lists, compile competitor analysis, or gather market intelligence with a simple text prompt. Researchers & analysts:** Quickly gather and structure data from the web for any topic without needing to write custom scrapers. Entrepreneurs & business owners:** Perform rapid market research to validate ideas, find suppliers, or identify opportunities. Anyone who needs structured data:** Transform unstructured, natural language requests into clean, organized spreadsheets. What problem does this solve? Eliminates rigid, single-purpose workflows:** This workflow isn't hardcoded to find just one thing. It dynamically adapts its entire research plan and data structure based on your request. Automates the entire research process:** It handles everything from understanding the goal and planning the research to executing the web search and structuring the final data. Bridges the gap between questions and data:** It translates your high-level goal (e.g., "I need sales leads") into a concrete, structured spreadsheet with all the necessary columns (Company Name, Website, Key Contacts, etc.). Optimizes for cost and efficiency:* It intelligently uses a combination of deep-dive and standard web searches from *Linkup.so** to gather high-quality initial results and then enrich them cost-effectively. How it works (The "Thinker & Doer" Method) The process is cleverly split into two main phases: The "Thinker" (AI Planner): You submit a research request via the built-in form (e.g., "Find 50 US-based fashion companies for a sales outreach campaign"). The first AI node acts as the "thinker." It analyzes your request and determines the optimal structure for your final spreadsheet. It dynamically generates a plan, which includes a discoveryQuery to find the initial list, an enrichmentQuery to get details for each item, and the JSON schemas that define the exact columns for your CSV. The "Doer" (AI Researcher): The rest of the workflow is the "doer," which executes the plan. Discovery: It uses a powerful "deep search" with Linkup.so to execute the discoveryQuery and find the initial list of items (e.g., the 50 fashion companies). Enrichment: It then loops through each item in the list. For each one, it performs a fast and cost-effective "standard search" with Linkup to execute the enrichmentQuery, filling in all the detailed columns defined by the "thinker." Final Output: The workflow consolidates all the enriched data and converts it into a final CSV file, ready for download or further processing. Setup Connect your AI provider: In the OpenAI Chat Model node, add your AI provider's credentials. Connect your Linkup account: In the two Linkup (HTTP Request) nodes, add your Linkup API key (free account at linkup.so). We recommend creating a "Generic Credential" of type "Bearer Token" for this. Linkup offers €5 of free credits monthly, which is enough for 1k standard searches or 100 deep queries. Activate the workflow: Toggle the workflow to "Active." You can now use the form to submit your first research request! Taking it further Add a custom dashboard:** Replace the form trigger and final CSV output with a more polished user experience. For example, build a simple web app where users can submit requests and download their completed research files. Make it company-aware:** Modify the "thinker" AI's prompt to include context about your company. This will allow it to generate research plans that are automatically tailored to finding leads or data relevant to your specific products and services. Add an AI summary layer:** After the CSV is generated, add a final AI node to read the entire file and produce a high-level summary, such as "Here are the top 5 leads to contact first and why," turning the raw data into an instant, actionable report. An n8n automation workflow template by Guillaume Duvernay.

By Evoort Solutions

📥 Instagram to MP4 Converter with Google Drive Integration This n8n workflow enables users to convert Instagram video links into downloadable MP4 files, store them in Google Drive, and log the results (success or failure) in Google Sheets. 🔧 Node-by-Node Overview On form submission – Triggers when a user submits an Instagram video URL. Instagram Downloader API Request – Calls the Instagram Downloader API to retrieve a downloadable link for the video. If – Checks if the API response indicates success. MP4 Downloader – Downloads the video from the provided media URL. Upload To Google Drive – Uploads the MP4 video to a specified folder in Google Drive. Google Drive Set Permission – Sets the uploaded file to public with a sharable link. Google Sheets – Logs successful conversions, including the original URL and Drive link. Wait – Adds a pause before logging failure to avoid rapid writes to Google Sheets. Google Sheets Append Row – Logs failed attempts with Drive_URL marked as N/A. 🚀 Key Features 🔗 Uses the Instagram Downloader API to convert Instagram video URLs 🗂 Uploads MP4s directly to Google Drive 📊 Logs all actions in Google Sheets 🧠 Smart error handling using conditional and wait nodes 📌 Use Case & Benefits Convert Instagram videos to MP4 instantly from a simple form submission Automatically upload videos to Google Drive Log successful and failed conversions into Google Sheets Ideal for marketers, content managers, educators, and archivists No manual downloading, renaming, or organizing — it's fully automated 🌐 API Key Requirement To use this workflow, you’ll need an API key from the Instagram Downloader API. Follow these steps to obtain your API key: Go to the Instagram Downloader API Sign up or log in to RapidAPI Subscribe to a plan (either free or paid) Copy your x-rapidapi-key and paste it in the HTTP Request node where required 🛠 Full Setup Instructions 1. API Setup Create an account with RapidAPI. Subscribe to the Instagram Downloader API and copy your API key. Use this key in the HTTP Request node in n8n to call the Instagram Downloader API. 2. Google Services Setup Google Drive Integration: Go to the Google Developer Console. Create a new project. Enable the Google Drive API. Create OAuth 2.0 credentials and download the JSON credentials file. Upload this file to n8n under your Google Drive credentials setup. Google Sheets Integration: Enable the Google Sheets API in the Google Developer Console. Create OAuth 2.0 credentials for Sheets access. Download the credentials file and upload it to n8n for authentication. Make sure the Google Sheet you're using has columns for Original_URL, Drive_URL, and Status. 3. Customizing the Template Custom Folder for Google Drive: In the "Upload To Google Drive" node, change the folder ID to match your desired folder in Google Drive where videos should be stored. Custom Google Sheets Columns: By default, the template logs the Original_URL, Drive_URL, and Status (success/failure). To add more columns, simply update the "Google Sheets Append Row" node with new column headers and ensure the data from each step corresponds correctly. 4. Column Mapping for Google Sheets The default columns in your Google Sheet are: Original_URL: The original Instagram video URL submitted by the user. Drive_URL: The sharable link to the uploaded MP4 in Google Drive. Status: Whether the conversion was successful or failed. Important Note: Ensure your Google Sheet is properly formatted with these columns before running the workflow. 💡 Additional Tips Monitoring API Usage**: The Instagram Downloader API has rate limits. Check your API usage in the RapidAPI dashboard. Automating with Triggers**: You can trigger the workflow automatically when a user submits a form URL through tools like Google Forms or external services that integrate with n8n. Error Handling**: If you encounter frequent failures, check the API's response format and ensure that all your credentials are correctly set up. An n8n automation workflow template by Evoort Solutions.

By Aryan Shinde

AI-Powered Gmail Auto-Labeler Automatically organize your Gmail inbox with seamless, dynamic AI classification! This workflow leverages Google Gemini’s latest model to continually sort new emails into your own custom Gmail labels—no manual intervention or tedious setup required. 🚀 What This Workflow Does Watches for Unread Emails:** Continuously polls your Gmail inbox for new unread emails (polling interval can be changed as needed). Fetches All Available Labels:** Dynamically syncs every custom & system label from your Gmail account—no hardcoded lists. AI-Based Classification:** Each new email’s subject and snippet/body are sent to the Gemini 2.5 Pro AI, which analyzes content and recommends the best matching label(s) from your own label list (not made up!). Accurate Label Application:** The workflow maps Gemini’s label name suggestions to the correct label IDs in Gmail and auto-applies one or more labels directly to each email. Self-Updating / No Maintenance:** If you add/change Gmail labels, the workflow always uses the current label list. You don’t need to update any configuration or nodes (completely dynamic). Supports Multiple Simultaneous Labels:** Gemini can assign several labels at once—perfect for nuanced sorting (ex: “Receipts”, “Work”, "Travel"). 🔧 How to Set Up Connect Credentials: Google Gmail account (OAuth2) Gemini API key (for Google Gemini) (Optional) Adjust Gmail Labels: Add, rename, or customize labels in Gmail to suit your sorting preferences. You can continue to modify these at any time! Activate the Workflow: Turn on the workflow. It starts processing new emails immediately. No need to edit code or update nodes when labels change. (Optional) Customize Filtering or Post-Processing: The default trigger checks for unread messages, but you can adjust this (e.g., all messages, specific senders, etc.). Add extra workflow steps as desired for downstream automation. 📝 Key Features & Best Practices Dynamic Label Handling:** Workflow always references your live Gmail label list—ensuring AI only selects valid, current labels. Never Misses a Label:** Gemini never invents new labels; only suggests exact matches from your actual account. Highly Customizable:** Enhance/chain further automations—trigger from read emails, exclude newsletters, forward labeled messages, etc. No Manual Updates:** Completely plug-and-play. Adding/changing labels in Gmail immediately reflects in workflow. Includes In-Workflow Notes:** Clear sticky notes and documentation embedded for reference and troubleshooting. 🕰 Example Use Cases Automated Inbox Zero – Instantly sort incoming emails into actionable folders. Smart Multi-Labeling – Financial emails get “Receipts”, “Accounting” and “Work”, all at once. Personal & Work Split – Classify emails into "Personal", "Clients", "Leads", etc. Travel, Projects, Subscriptions – Transform your Gmail into a fully organized hub. This workflow is perfect for anyone who wants Gmail organization powered by leading-edge AI, with absolutely minimal maintenance. Just connect accounts and activate — let Gemini do the sorting!. An n8n automation workflow template by Aryan Shinde.

By Kalyxi Ai

🚀 Automate News Discovery & Publishing with GPT-4, Google Search API & Slack 🎯 Overview Automated content publishing system that discovers industry news, transforms it into original articles using GPT-4, and publishes across multiple channels with SEO optimization and intelligent duplicate prevention. ✨ Key Features 🤖 Smart Query Generation** - AI agent generates unique search queries while checking Google Sheets to avoid duplicates 🔍 News Discovery** - Uses Google Custom Search API to find recent articles (last 7 days) 🧠 Content Intelligence** - Processes search results and skips anti-bot protected sites automatically 📝 GPT-4 Article Generation** - Creates professional, SEO-optimized news articles in Reuters/Bloomberg style 📢 Multi-Channel Publishing** - Publishes to CMS with automatic Slack notifications 📊 Comprehensive Tracking** - Logs all activity to Google Sheets for analytics and duplicate prevention 🔄 How It Works ⏰ Scheduled Trigger runs every 8 hours to maintain consistent content flow 🤖 AI Agent generates targeted search queries for your niche while checking historical data 🔍 Google Search finds recent articles and extracts metadata (title, snippet, source) 🛡️ Smart Content Handler bypasses sites with anti-bot protection, using search snippets instead ⚡ GPT-4 Processing transforms snippets into comprehensive 2000+ word articles with proper formatting 🚀 Publishing Pipeline formats content for CMS with SEO metadata and publishes automatically 📱 Notification System sends detailed Slack updates with article metrics 📈 Activity Logging tracks all published content to prevent future duplicates 🔧 Setup Requirements 📋 Prerequisites Google Custom Search API key and Search Engine ID OpenAI GPT-4 API access Google account for tracking spreadsheet Slack workspace for notifications CMS or website with API endpoint for publishing 🛠️ Step-by-Step Setup Step 1: 🔎 Google Custom Search Configuration Go to Google Custom Search Engine Create a new search engine Configure to search the entire web Copy your Search Engine ID (cx parameter) Get your API key from Google Cloud Console Step 2: 📊 Google Sheets Template Setup Create a Google Sheet with these required columns: Column A:** timestamp - ISO date format (YYYY-MM-DD HH:MM:SS) Column B:** query - The search query used Column C:** title - Published article title Column D:** url - Published article URL Column E:** status - Publication status (success/failed) Column F:** word_count - Final article word count Template URL: Copy this Google Sheets template Step 3: 🔑 Credential Configuration Set up the following credentials in n8n: 📊 Google Sheets API - OAuth2 connection to your Google account 🤖 OpenAI API - Your GPT-4 API key 📱 Slack Webhook - Webhook URL for your notification channel 🔍 Custom Search API - Your Google Custom Search API key Step 4: ⚙️ Workflow Customization Modify these key parameters to fit your needs: 🎯 Search Topic:** Edit the AI agent prompt to focus on your industry ⏰ Publishing Schedule:** Adjust the cron trigger (default: every 8 hours) 📝 Article Length:** Modify GPT-4 prompt for different word counts 🌐 CMS Endpoint:** Update the publishing node with your website's API 🎨 Customization Options 🎯 Content Targeting Modify the AI agent's search query generation to focus on specific industries Adjust date restrictions (currently set to last 7 days) Change the number of search results processed per run ✍️ Article Style Customize GPT-4 prompts for different writing styles (formal, casual, technical) Adjust article length requirements Modify SEO optimization parameters 📡 Publishing Channels Add additional CMS endpoints for multi-site publishing Configure different notification channels (Discord, Teams, etc.) Set up social media auto-posting integration 💡 Use Cases 📰 Automated news websites 📝 Industry blog content generation 🔍 SEO content pipeline automation 📊 News aggregation and republishing 📈 Content marketing automation 🛠️ Technical Notes Workflow includes error handling for anti-bot protection Duplicate prevention through Google Sheets tracking Rate limiting considerations for API usage Automatic retry logic for failed requests 🆘 Support For setup assistance or customization help, refer to the workflow's internal documentation nodes or contact the template creator. An n8n automation workflow template by Kalyxi Ai.

By Jimmy Gay

AI-Powered LinkedIn Viral Content Generator & Telegram Bot Disclaimer: This workflow uses community-contributed nodes which are not officially maintained by n8n. Please test thoroughly before running in production. Do not use this template in production without your own independent validation. Overview This workflow empowers you to generate highly viral LinkedIn posts, including both compelling copy and AI-generated custom images, directly from a Telegram chat interface. Leveraging AI-powered research, GPT-based content creation, and community-based integrations, it creates a seamless automation: from prompt to trend analysis, viral copywriting, image generation, and message delivery—all in one flow. Node-by-Node Workflow Explanation Telegram Trigger:** Starts the workflow from a specified Telegram chat by capturing user prompts. Expert Algo (AI Analysis):** Uses OpenAI and Tavily to research current LinkedIn trends, analyzes top-performing content, and produces a content framework plus an AI image prompt. Structured Output Parser:** Validates and formats the AI's returned JSON output. CM Junior:** Generates three LinkedIn post drafts in your own style, based on the viral framework and rules. Structured Output Parser1:** Ensures correct JSON for the drafted posts. Community Manager:** Evaluates the draft posts using additional trend analysis via Tavily, selects the one most likely to go viral. Structured Output Parser2:** Validates the community manager's single post output. Generate Image:** Calls the AI image generator on RapidAPI to create a picture for your post, using the recommended prompt. Split Out/Download Image:** Prepares and downloads the generated image file. Send Telegram Photo and Message:** Sends the chosen LinkedIn post and the generated image to your Telegram bot. Setup Instructions Telegram: Create a bot using @BotFather and get your bot token and target chat ID. OpenAI: Register at OpenAI, obtain your API key. Tavily: Register at Tavily and get your API key. RapidAPI (AI Image Generator): Create an account, subscribe to the "ai-text-to-image-generator-flux-free-api", and copy your API key. Credentials: Use the n8n Credentials Manager to configure each key securely—never hardcode API keys into nodes. Workflow Personalization: Replace all placeholders like Telegram chat ID by referencing the credentials or environment variables. Testing: Run the workflow using your bot and ensure that no personal or sensitive data remains before publishing. Additional Recommendations Update the image generator, Telegram, OpenAI, and Tavily node credentials through the n8n Credentials panel. Custom tailor prompts and output formatting as needed for your LinkedIn content strategy. For security, do not share any personal API keys or chat IDs in your public template. An n8n automation workflow template by Jimmy Gay.

By Rahul Joshi

Description Never miss a lead again with this SLA Breach Alert automation powered by n8n! This workflow continuously monitors your Google Sheets for un-replied leads and automatically triggers instant Telegram alerts, ensuring your team takes immediate action. By running frequent SLA checks, enriching alerts with direct Google Sheet links, and sending real-time notifications, this automation helps prevent unattended leads, reduce response delays, and boost customer engagement. What This Template Does 📅 Runs every 5 minutes to monitor SLA breaches 📋 Fetches lead data (status, contact, timestamps) from Google Sheets 🕒 Identifies leads marked “Un-replied” beyond the 15-minute SLA 🔗 Enriches alerts with direct Google Sheet row links for quick action 📲 Sends Telegram alerts with lead details for immediate response Step-by-Step Setup Prepare Your Google Sheet Create a sheet with the following columns (minimum required): Lead Name Email Phone Status (values: Replied, Un-replied) Timestamp (time of last update/reply) Set Up Google Sheets in n8n Connect your Google account in n8n. Point the workflow to your sheet (remove any hardcoded document IDs before sharing). Configure SLA Check Use the IF node to filter leads where: Status = Un-replied Time since timestamp > 15 minutes Enrich Alerts with Links Add a Code node to generate direct row links to the sheet. Set Up Telegram Bot Create a Telegram bot via @BotFather. Add the bot to your team chat. Store the botToken securely (remove chatId before sharing templates). Send Alerts Configure the Telegram node in n8n to send lead details + direct Google Sheet link. Customization Guidance Adjust the SLA window (e.g., 30 minutes or 1 hour) by modifying the IF node condition. Add more fields from Google Sheets (e.g., Company, Owner) to enrich the alert. Replace Telegram with Slack or Email if your team prefers a different channel. Extend the workflow to auto-assign leads in your CRM once alerted. Perfect For Sales teams that need to respond to leads within strict SLAs Support teams ensuring no customer request is ignored Businesses aiming to keep lead response times sharp and consistent. An n8n automation workflow template by Rahul Joshi.

By Tegar karunia ilham

Overview Transform your receipt management with this comprehensive n8n workflow that automatically processes receipts through Telegram, extracts transaction data using AI, and stores it across multiple platforms for seamless expense tracking. Key Features 📱 Telegram Bot Integration**: Send receipts via photo or manual text entry 🔍 OCR Processing**: Automatic text extraction from receipt images using OCR.space API 🤖 AI Data Extraction**: OpenAI GPT-4 intelligently extracts vendor, amount, date, and category 📊 Multi-Platform Storage**: Automatically saves to Google Sheets, Notion, and custom APIs 💾 Receipt Archival**: Stores original receipt images in Google Drive ✅ Smart Validation**: Validates extracted data and handles errors gracefully 📲 Real-time Feedback**: Sends confirmation messages with transaction details How It Works Input Methods: Send receipt photos or text messages to your Telegram bot Image Processing: Downloads and processes receipt images using OCR technology AI Analysis: GPT-4 extracts structured transaction data from OCR text Data Validation: Ensures data quality and handles missing information Multi-Storage: Simultaneously saves to Google Sheets, Notion database, and external APIs Confirmation: Sends formatted confirmation with all transaction details Use Cases Personal expense tracking and budgeting Small business receipt management Travel expense documentation Tax preparation and record keeping Automated bookkeeping workflows Required Credentials Telegram Bot API (for bot functionality) OCR.space API (for receipt text extraction) OpenAI API (for AI data processing) Google Sheets OAuth2 (for spreadsheet storage) Google Drive OAuth2 (for image storage) Notion API (for database integration) Setup Notes Replace placeholder values in the workflow: YOUR_GOOGLE_SHEET_ID_HERE in Google Sheets node YOUR_NOTION_DATABASE_ID_HERE in Notion node YOUR_API_KEY_HERE and API endpoint in Website API node This workflow provides a complete solution for automated receipt processing, making expense tracking effortless through simple Telegram interactions while maintaining data across multiple platforms for maximum accessibility and backup. An n8n automation workflow template by Tegar karunia ilham.

By Paul

✍️ AI-Powered High-Quality Blog Automation Automate SEO-optimized blog creation, publishing, and internal linking — designed for Lovable.dev or seamless WordPress integration. Proven to boost impressions by +15% weekly on real websites. 📌 Example: AI Applications in Real Estate Playbook — fully generated, optimized, and published with this automation. 🚀 What This Workflow Does Bring Your Own Keywords** You provide the keyword list — the workflow applies a scoring formula to rank them by relevance and competition for maximum SEO impact. Keyword Scoring & Logging** Scores primary and secondary keywords, logs them in PostgreSQL, and prevents reuse until strategically relevant. Deep Research & Blog Planning** Uses Perplexity AI and other AI models to outline, plan, and enrich each article with authoritative external sources. SEO-Optimized Redaction** Writes multi-part, long-form blogs with integrated internal links (to your existing content) and external links to reputable sites. Image Generation & Selection** Creates or selects high-quality header and in-article images, optimized for your topic. Full Blog Infrastructure** Internal & external linking logic Blog card + metadata updates Sitemap updates & Google indexing submission Post logging for future reference Publishing Flexibility** Direct GitHub commits for Lovable.dev WordPress-ready export Optional Slack approval before publishing 🔗 Integrated Services PostgreSQL** – Keyword & content database Perplexity AI** – Research & planning OpenAI / OpenRouter Models** – Multi-part blog writing Lovable.dev / GitHub** – Direct publishing WordPress-ready JSON output** – Easy CMS import Slack** – Approval workflow before going live 💼 What You Get Detailed Setup Guide** Workflow Description** 📥 Perfect For Website owners wanting consistent SEO growth Agencies handling multiple client sites Marketers running content-heavy campaigns Lovable.dev or WordPress users who want hands-off publishing 💡 Why You’ll Love It This is more than a blog writer — it’s a complete content infrastructure. From keyword prioritization to publishing and indexing, it keeps your site growing in reach and authority while you focus on your business. An n8n automation workflow template by Paul.

By Rahul Joshi

Description: Never leave your leads waiting! This n8n workflow template ensures every inquiry gets a timely and professional response—whether it’s business hours or after hours. By checking submission times, the automation sends tailored email replies, updates your team instantly, and ensures no lead goes unnoticed. This workflow monitors a Google Sheet for new form responses, waits briefly to capture complete data, checks if the submission falls within business hours, and then sends either a standard business reply or a polite after-hours acknowledgment. Additionally, it alerts your team via Telegram with lead details for quick follow-up. Perfect for sales, support, and operations teams managing inbound leads. Features 🕒 Monitors Google Sheets for new or updated lead form responses ⌛ Adds a short delay to ensure clean, complete data capture ⏰ Detects whether submissions fall within business hours (9 AM–6 PM, Mon–Fri) 📧 Sends automated Gmail replies (business hours vs. after-hours messaging) 📲 Notifies your team instantly on Telegram with lead details 🌟 Fully automated: hands-free lead acknowledgment + team alerts How It Works Google Sheets Trigger – Watches for new form submissions in your lead sheet. Data Validation – Waits 5 minutes to ensure complete entry. Business Hours Check – Determines if the inquiry is within working hours. Email Response – Sends tailored Gmail reply (business hours or after-hours). Telegram Notification – Instantly notifies your team with lead details. Setup Instructions Google Sheets Setup Create a Google Sheet with these columns: Name Email Address Phone Number Message Submission Time (timestamp) Connect your sheet to n8n using Google Sheets credentials. Gmail Setup Connect your Gmail account in n8n credentials. Prepare two email templates: Business Hours Reply: “Hi {{Name}}, thank you for reaching out! Our team will get back to you shortly.” After-Hours Reply: “Hi {{Name}}, thank you for contacting us! Our team will get back to you tomorrow.” Telegram Setup Create a Telegram bot via @BotFather. Add your bot to the target group or chat. Store the bot token and chatId securely in n8n credentials. Workflow Configuration Import the workflow into your n8n instance. Replace hardcoded values with n8n credential references. Rename the “Edit Fields” node to “Format Lead Data for Notification” for clarity. Test by submitting a sample lead form entry. Customization ⏰ Business Hours: Adjust the time window (e.g., 8 AM–8 PM, Mon–Sat) in the workflow logic. 📧 Email Templates: Personalize subject lines, add signatures, or include links to resources. 📲 Notification Details: Choose which fields (e.g., phone number, notes) appear in the Telegram alert. ⏱ Delay Time: Change the default 5-minute buffer to suit your form’s response timing. Security Best Practices ❌ Do not hardcode Gmail or Telegram credentials. Always use n8n credentials. ✅ Remove private data (chatIds, sheet IDs) before sharing templates. ✅ Restrict credential access to authorized team members. Requirements Google Sheets (with structured form responses) Gmail account for automated replies Telegram bot & chat for notifications n8n instance (self-hosted or cloud) This workflow is perfect for: 🏢 Sales Teams handling high lead volume 💬 Support Teams ensuring fast first responses 🚀 Businesses offering 24/7 responsiveness without manual effort 📲 Operations Teams needing structured alerts and accountability. An n8n automation workflow template by Rahul Joshi.

By Shelly-Ann Davy

Voice Memo to Blog Post with Deepgram, GPT-3.5 & Softr for Creators Turn Voice Memos into Published Blog Posts Using AI and Automation Stop letting great ideas vanish in your Notes app. This workflow transforms your voice memos into polished blog posts, LinkedIn articles, or newsletters — automatically. Perfect for: Coaches and course creators who teach best by speaking Homemakers sharing wisdom without typing Solopreneurs building authority without burnout Anyone who thinks out loud but hates writing The workflow: 🎙️ Transcribes your voice memo using Deepgram (via n8n’s Voice to Text node) ✍️ Rewrites it into a publish-ready post using GPT-3.5 🖼️ Generates a featured image using HTML to Image 📊 Saves the post to Google Sheets as your content calendar 📨 Emails you a draft for review 🖥️ Syncs to your Softr dashboard for visual content planning No typing. No staring at a blank screen. Just speak — and publish. Prerequisites Before using this workflow, ensure you have the following accounts: | Service | Purpose | Free Tier Available? | |--------|--------|----------------------| | n8n | Orchestrate the automation | Yes | | Deepgram | Voice-to-text transcription | Yes (free tier) | | OpenAI | AI writing (GPT-3.5 or GPT-4) | Yes | | Google Sheets | Store blog drafts and metadata | Yes | | SMTP Email | Send draft emails (e.g., Gmail) | Yes (via app password) | | Softr | Build a visual content dashboard | Yes | 🔐 You’ll need API keys for: Deepgram, OpenAI, and SMTP ✅ All credentials should be stored securely in n8n Google Sheets Setup Your Google Sheet must have the following columns for the workflow to work correctly: | Column Name | Purpose | Example | |------------|--------|--------| | Date | When the post was created | 2025-09-05 | | Title | Blog post title (AI-generated or custom) | "What I Learned About Boundaries" | | Content | AI-generated post body | "Today, I realized..." | | Image_URL | Link to generated featured image | https://.../image.png | | Status | Publishing status | Draft, Published, Reviewed | | Audio_URL (optional) | Link to original voice memo | https://.../memo.mp3 | 📌 Tip: Name your sheet "Content Calendar" and share it with your n8n service account or use OAuth. Step-by-Step Setup Instructions 1. Import the Workflow into n8n Go to your n8n dashboard. Click Workflows > Create from JSON. Paste the provided JSON. Click Import. 2. Set Up Credentials For each service, go to Credentials > Add New: Deepgram**: Enter your API key OpenAI**: Use your GPT API key Google Sheets**: Connect via OAuth or service account SMTP**: Enter your email credentials (e.g., Gmail app password) 🔐 Never hardcode keys — always use n8n’s secure credential system. 3. Configure the AI Prompt In the HubGPT: Rewrite as Blog Post node: Edit the prompt to match your tone: Rewrite this raw voice memo into a warm, engaging blog post: {{ $json["text"] }} Use short paragraphs, friendly tone, and end with a question to engage readers. An n8n automation workflow template by Shelly-Ann Davy.

By Tegar karunia ilham

Description 🎯 Overview An advanced automated trading bot that implements ICT (Inner Circle Trader) methodology and Smart Money Concepts for cryptocurrency trading. This workflow combines AI-powered market analysis with automated trade execution through Coinbase Advanced Trading API. ⚡ Key Features 📊 ICT Trading Strategy Implementation Kill Zone Detection**: Automatically identifies optimal trading sessions (Asian, London, New York kill zones) Smart Money Concepts**: Analyzes market structure breaks, liquidity grabs, fair value gaps, and order blocks Session Validation**: Real-time GMT time tracking with session strength calculations Structure Analysis**: Detects BOS (Break of Structure) and CHOCH (Change of Character) patterns 🤖 AI-Powered Analysis GPT-4 Integration**: Advanced market analysis using OpenAI's latest model Confidence Scoring**: AI generates confidence scores (0-100) for each trading signal Risk Assessment**: Automated risk level evaluation (LOW/MEDIUM/HIGH) ICT-Specific Prompts**: Custom prompts designed for Inner Circle Trader methodology 🔄 Automated Trading Flow Signal Reception: Receives trading signals via Telegram webhook Data Extraction: Parses symbol, action, price, and technical indicators Session Validation: Verifies current kill zone and trading session strength Market Data: Fetches real-time data from Coinbase Advanced Trading API AI Analysis: Processes signals through GPT-4 with ICT-specific analysis Quality Filter: Multi-condition filtering based on confidence, session, and structure Trade Execution: Automated order placement through Coinbase API Documentation: Records all trades and rejections in Notion databases 📱 Multi-Platform Integration Telegram Bot**: Receives signals and sends formatted notifications Coinbase Advanced**: Real-time market data and trade execution Notion Database**: Comprehensive trade logging and analysis tracking Webhook Support**: External system integration capabilities 🛠️ Setup Requirements API Credentials Needed: Coinbase Advanced Trading API** (API Key, Secret, Passphrase) OpenAI API Key** (GPT-4 access) Telegram Bot Token** and Chat ID Notion Integration** (Database IDs for trade records) Environment Variables: TELEGRAM_CHAT_ID=your_chat_id NOTION_TRADING_DB_ID=your_trading_database_id NOTION_REJECTED_DB_ID=your_rejected_signals_database_id WEBHOOK_URL=your_external_webhook_url 📈 Trading Logic Kill Zone Priority System: London & New York Sessions**: HIGH priority (0.9 strength) Asian & London Close**: MEDIUM priority (0.6 strength) Off Hours**: LOW priority (0.1 strength) Signal Validation Criteria: Signal quality must not be "LOW" Confidence score ≥ 60% Active kill zone session required ICT structure alignment confirmed 🎛️ Workflow Components Extract ICT Signal Data: Parses incoming Telegram messages for trading signals ICT Session Validator: Determines current kill zone and session strength Get Coinbase Market Data: Fetches real-time cryptocurrency data ICT AI Analysis: GPT-4 powered analysis with ICT methodology Parse ICT AI Analysis: Processes AI response with fallback mechanisms ICT Quality & Session Filter: Multi-condition signal validation Execute ICT Trade: Automated trade execution via Coinbase API Create ICT Trading Record: Logs successful trades to Notion Generate ICT Notification: Creates formatted Telegram alerts Log ICT Rejected Signal: Records filtered signals for analysis 🚀 Use Cases Automated ICT-based cryptocurrency trading Smart Money Concepts implementation Kill zone session trading AI-enhanced market structure analysis Professional trading documentation and tracking ⚠️ Risk Management Built-in session validation prevents off-hours trading AI confidence scoring filters low-quality signals Comprehensive logging for performance analysis Automated stop-loss and take-profit calculations This workflow is perfect for traders familiar with ICT methodology who want to automate their Smart Money Concepts trading strategy with AI-enhanced decision making. An n8n automation workflow template by Tegar karunia ilham.

By Cong Nguyen

What this workflow does Every night at 22:00 (Asia/Ho_Chi_Minh), the workflow fetches the latest posts from multiple competitor WordPress RSS feeds, upserts them into Google Sheets, captures a dashboard screenshot (via ApiFlash), has Gemini Vision analyze the chart, and sends a concise insight report to Telegram. Details Schedule (22:00) → runs daily. Fetch RSS → HTTP Request (or RSS Read) pulls each competitor’s /feed/ (standard WordPress RSS). Normalize & limit → parse XML → JSON, keep the most recent 5 per site for the digest (you can raise/lower this). Upsert to Google Sheets → match on link to avoid duplicates; store fields like guid, site, link, title, excerpt/description, content (if available), pubDate, updated. Screenshot the dashboard → ApiFlash captures the Google Sheets dashboard (specific gid) with your line chart of monthly post counts. Vision analysis → Gemini 1.5-Flash analyzes the chart image and returns a short executive summary, a Markdown table of values (≈ when estimated), insights, and recommended next steps. Telegram push → posts the AI summary (and optionally the screenshot) to your channel/group. Who it’s for SEO/Content/Marketing teams tracking competitor publishing cadence. Founders/PMs who want a nightly snapshot. Competitive intelligence and analytics roles. Requirements n8n (cloud or self-hosted). Google Sheets OAuth2, Telegram Bot, ApiFlash (access key), Google Gemini access. A Google Sheet with columns similar to: id/guid, site, link, title, excerpt, content, pubDate, updated. Setup Import the workflow JSON into n8n. Switch to RSS: Option A (simple): replace HTTP nodes with RSS Read and paste each competitor’s https://{domain}/feed/. Option B (keep HTTP): keep HTTP Request nodes, set Response: XML, then parse with XML node. Mapping to Sheets: point to your documentId and sheetName; set matching column = link for upsert. ApiFlash: add access_key and the Sheet URL with the correct gid that shows your chart; set scale_factor=2 (or higher for clarity). Gemini Vision: use model gemini-1.5-flash-latest with the included prompt (English output; Markdown table + insights + recommendations). Telegram: set bot credentials and chatId. Schedule: confirm 22:00 Asia/Ho_Chi_Minh (adjust as needed). Test: run once → verify rows append/update → see dashboard render → receive AI summary in Telegram. Extending to more competitors Clone an HTTP/RSS node for each additional competitor, update the /feed/ URL, and connect it to the Merge node. No other changes are required—new data will be normalized, upserted, included in charts and in the AI summary automatically. Tips & gotchas WordPress RSS typically includes title, link, pubDate, guid, description, and sometimes content:encoded. If content:encoded is absent, fall back to description. Keep the Sheet chart source range dynamic (e.g., open-ended ranges) so new rows are reflected automatically. If a site’s RSS limits items, you can run multiple feeds (e.g., category feeds) or capture more history on the first run. 💡 About Margin AI Margin Ai is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development. An n8n automation workflow template by Cong Nguyen.

By Zakwan

Description This template automates the process of creating blog posts from YouTube videos using Mistral AI for text generation and Gemini for image generation. It provides a seamless workflow that transforms YouTube content into ready-to-publish articles complete with engaging visuals. ⚠️ Disclaimer: This template can only be used on self-hosted n8n instances. It also relies on community nodes, which must be installed before running the workflow. Workflow Overview YouTube Data Extraction – Retrieves video details (title, description, and transcript). Content Summarization – Mistral AI rewrites and structures the transcript into a blog-ready format. Image Generation – Gemini creates relevant, high-quality images to complement the article. Post Assembly – The workflow automatically combines the generated text and visuals into a structured blog post. Features Extract video details and transcripts directly from YouTube. Summarize and rewrite content into blog posts using Mistral AI. Generate relevant images with Gemini for engaging visuals. Automatically structure blog posts for publishing. Requirements Before using this template, ensure you have: An active self-hosted n8n instance. API keys for OpenRouter (Mistral AI) and Gemini. The required community nodes installed. Access to public or unlisted YouTube videos. Setup Instructions Import the template into your self-hosted n8n instance. Configure the API credentials: Add your OpenRouter API key. Add your Gemini API key. Replace placeholder domains or webhook URLs with your own. Run the workflow with a sample YouTube video URL. Review the generated blog post and images. Customization Content length: Adjust prompt settings in the Mistral AI node. Tone of voice: Modify prompts for formal, casual, or technical style. Image style: Update Gemini requests to change the look and feel. Publishing: Connect to your CMS (e.g., WordPress, Ghost) for direct publishing. How YouTube is Involved The workflow starts with a YouTube video URL, extracts metadata and transcripts, and then transforms this raw content into a complete blog post enriched with AI-generated images. WorkFlow:. An n8n automation workflow template by Zakwan.

By Evoort Solutions

🚀 Website Traffic Monitoring with SEMrush API and Google Sheets Integration Leverage the powerful SEMrush Website Traffic Checker API to automatically fetch detailed website traffic insights and log them into Google Sheets for real-time monitoring and reporting. This no-code n8n workflow simplifies traffic analysis for marketers, analysts, and website owners. ⚙️ Node-by-Node Workflow Breakdown 1. 🟢 On Form Submission Trigger:** The workflow is initiated when a user submits a website URL via a form. This serves as the input for further processing. Use Case:** When you want to track multiple websites and monitor their performance over time. 2. 🌐 Website Traffic Checker API Request:* The workflow makes a POST request to the *SEMrush Website Traffic Checker API** via RapidAPI using the website URL that was submitted. API Data:** The API returns detailed traffic insights, including: Visits Bounce rate Page views Sessions Traffic sources And more! 3. 🔄 Reformat Parsing:** The raw API response is parsed to extract the relevant data under trafficSummary. Data Structure:** The workflow creates a clean dataset of traffic data, making it easy to store in Google Sheets. 4. 📄 Google Sheets Logging Data:** The traffic data is appended as a new row in your Google Sheet. Google Sheet Setup:** The data is organized and updated in a structured format, allowing you to track website performance over time. 💡 Use Cases 📊 SEO & Digital Marketing Agencies:** Automate client website audits by pulling live traffic data into reports. 🌐 Website Owners & Bloggers:** Monitor traffic growth and analyze content performance automatically. 📈 Data Analysts & Reporting Teams:** Feed traffic data into dashboards and integrate with other KPIs for deeper analysis. 🕵️ Competitor Tracking:** Regularly log competitor site metrics for comparative benchmarking. 🎯 Key Benefits ✅ Automated Traffic Monitoring — Run reports automatically on-demand or on a scheduled basis. ✅ Real-Time Google Sheets Logging — Easily centralize and structure traffic data for easy sharing and visualization. ✅ Zero Code Required — Powered by n8n’s visual builder, set up workflows quickly without writing a single line of code. ✅ Scalable & Flexible — Extend the workflow to include alerts, additional API integrations, or other automated tasks. 🔐 How to Get Your SEMrush API Key via RapidAPI Visit the API Listing 👉 SEMrush Website Traffic Checker API Sign In or Create an Account Log in to RapidAPI or sign up for a free account. Subscribe to the API Choose the appropriate pricing plan and click Subscribe. Access Your API Key Go to the Endpoints tab. Your API key is located under the X-RapidAPI-Key header. Secure & Use the Key Add your API key to the request headers in your workflow. Never expose the key publicly. 🔧 Step-by-Step Setup Instructions 1. Creating the Form to Capture URL In n8n, create a new workflow and add a Webhook trigger node to capture website URLs. Configure the webhook to accept URL submissions from your form. Add a form to your website or app that triggers the webhook when a URL is submitted. 2. Configure SEMrush API Request Node Add an HTTP Request node after the webhook. Set the method to POST and the URL to the SEMrush API endpoint. Add the necessary headers: X-RapidAPI-Host: semrush-website-traffic-checker.p.rapidapi.com X-RapidAPI-Key: [Your API Key] Pass the captured website URL from the webhook as a parameter in the request body. 3. Reformat API Response Add a Set node to parse and structure the API response. Extract only the necessary data, such as: trafficSummary.visits trafficSummary.bounceRate trafficSummary.pageViews trafficSummary.sessions Format the response to be clean and suitable for Google Sheets. 4. Store Data in Google Sheets Add the Google Sheets node to your workflow. Authenticate with your Google account. Select the spreadsheet and worksheet where you want to store the traffic data. Configure the node to append new rows with the extracted traffic data. Google Sheets Columns Setup A**: Website URL B**: Visits C**: Bounce Rate D**: Page Views E**: Sessions F**: Date/Time (optional, you can use a timestamp) 5. Test and Deploy Run a test submission through your form to ensure the workflow works as expected. Check the Google Sheets document to verify that the data is being logged correctly. Set up scheduling or additional workflows as needed (e.g., periodic updates). 📈 Customizing the Template You can modify the workflow to suit your specific needs: Add more data points**: Customize the SEMrush API request to fetch additional metrics (e.g., traffic sources, keywords, etc.). Create separate sheets**: If you're tracking multiple websites, you can create a different sheet for each website or group websites by category. Add alerts**: Set up email or Slack notifications if specific traffic conditions (like sudden drops) are met. Visualize data**: Integrate Google Sheets with Google Data Studio or other tools for more advanced visualizations. 🚀 Start Automating in Minutes Build your automated website traffic dashboard with n8n today — no coding required. 👉 Start with n8n for Free Save time, improve accuracy, and supercharge your traffic insights workflow!. An n8n automation workflow template by Evoort Solutions.

By Muhammad Saqib

Automated Certificate Generator with Google Sheets, Slides, and Gmail Delivery 🎓 This workflow is designed for educators, trainers, and event organizers who want to automatically generate and send digital certificates. It takes participant data from Google Sheets, personalizes a Google Slides certificate template, converts it into PDF, saves it in Google Drive, and emails it directly to participants using Gmail. ✅ Setup Instructions Prepare Google Sheets Create a sheet with these required columns: Name → Participant’s full name Email → Recipient email address Score (optional) → For filtering or record keeping Add at least one row of test data. Create Google Slides Template Design your certificate (branding, colors, etc.). Add a placeholder [NAME] where the participant’s name should appear. Set up Google Drive Create a folder to store generated PDF certificates. Copy the folder URL for use in the workflow. Connect Google Services in n8n Add credentials for Google Sheets, Google Slides, Google Drive, and Gmail. Replace placeholders (Sheet ID, Slides template ID, Destination folder ID) in the workflow. Customize Gmail Delivery Update the subject and body of the Gmail node. The certificate PDF will be automatically attached to each email. 🎨 Customization Options Certificate Design**: Modify your Slides template (logos, colors, extra fields). Dynamic Fields**: Add placeholders like [COURSE] or [DATE] and map them from your sheet. Email Body**: Personalize with variables such as {{$json["Name"]}}. File Naming**: Adjust file naming in the "Copy File" and "Download File" nodes. This template streamlines certificate distribution, making it ideal for schools, universities, training programs, and webinars. An n8n automation workflow template by Muhammad Saqib.

By Tejas Ambalia

Scheduled Gmail Cleanup – Auto-Delete Spam, Promotions, Social & Trash to save the Gmail space and time Managing Gmail manually can be tedious and time-consuming. Spam, Promotions, Social, and Trash folders quickly fill up with unwanted emails, taking up valuable storage and creating clutter. This workflow provides a simple yet powerful Gmail automation for efficient email management, helping you maintain a cleaner inbox with zero daily effort. This workflow is triggered by a Schedule node that runs once per day (customizable). It then uses multiple Gmail nodes to: Fetch Spam Emails – Identify all emails in the Spam folder. Fetch Promotions Emails – Collect promotional messages from Gmail’s Promotions category. Fetch Social Emails – Pull emails from the Social tab. Fetch Trash Emails – Find all items already marked as trash. Delete Fetched Emails – Automatically delete the emails retrieved from these categories. By default, the workflow deletes the selected emails permanently. Once removed, they are not recoverable. Key Benefits Automatically deletes junk, spam, and promotional emails daily Keeps Gmail storage under control and prevents hitting Google’s limits Saves time by eliminating manual cleanup tasks Helps you achieve and maintain Inbox Zero Simple “set and forget” automation — once activated, it runs in the background How to Use Import this workflow into your n8n account. Connect your Gmail account using Gmail OAuth2 credentials. Open each Gmail node and select your Gmail credential. Adjust the Schedule Trigger if you want to run it more or less frequently (default: once per day). Save and activate the workflow. Once set up, your Gmail inbox will automatically stay clean and organized every day. Who Is This For? Professionals who want to focus only on important emails Productivity enthusiasts striving for Inbox Zero Users approaching Gmail’s 15GB storage limit Teams managing shared inboxes with heavy email flow Customising this workflow Schedule**: Adjust the Schedule Trigger to run hourly, daily, or weekly. Categories**: Remove nodes for folders you want to keep, or add filters to only delete emails older than a certain number of days. Deletion Settings**: Modify the Gmail Delete node to move emails to Trash instead of permanent deletion if you prefer a safer cleanup. An n8n automation workflow template by Tejas Ambalia.

By Evoort Solutions

🔎 Automated Keyword Research Workflow with Google sheet logging & Semrush API Description: Easily collect keywords and country input, run automated keyword research via the Semrush Keyword Research API on RapidAPI, and store results in Google Sheets for seamless tracking and analysis. ⚙️ Node-by-Node Explanation 🟢 On form submission (formTrigger) Collects keyword and country inputs from the user via a simple form to start the research process. Triggers the workflow execution upon submission. 🌐 Keyword Research (httpRequest) Sends a POST request with user inputs (keyword and country) to the Semrush Keyword Research. Retrieves keyword suggestions, search volume, and related data for comprehensive keyword insights. 📄 Append Data to Google Sheet (googleSheets) Automatically appends the keyword research results into a connected Google Sheets document. Enables easy tracking, sharing, and further analysis of keyword data. 📈 Example Spreadsheet Structure | Keyword | Country | Search Volume | CPC | Competition | Keyword Difficulty | Related Keywords | Date of Research | |---------------|---------|---------------|------|-------------|--------------------|-------------------------------------|------------------| | keyword1 | US | 10,000 | $2.50| 0.75 | 45 | keyword2, keyword3 | 2025-09-09 | | example term | UK | 15,000 | $1.80| 0.60 | 38 | term1, example keyword | 2025-09-09 | 🌟 Benefits 🚀 Powered by **Semrush Keyword Research API on RapidAPI:** Reliable, up-to-date keyword insights accessible via a simple API integration. 🔄 Fully Automated: From user input to data storage, the process is seamless and requires no manual handling. 📊 Centralized Data Storage: Storing results in Google Sheets ensures accessibility and easy collaboration. 📈 Scalable & Repeatable: Run keyword research on-demand for multiple keywords and countries effortlessly. 🚀 Use Cases 🏢 SEO Agencies: Quickly gather keyword data for clients in different markets using the Semrush Keyword Research. 📱 Digital Marketing Teams: Monitor and expand keyword strategies by collecting keyword ideas and volume regularly through the Semrush Keyword Research. 🔎 Content Creators: Identify trending and high-traffic keywords tailored by country to optimize content via the Semrush Keyword Research API. 📅 Automated Reporting: Generate scheduled keyword research reports by integrating this workflow into larger marketing automation pipelines. 🔑 How to Get Your API Key for Semrush Keyword Research Visit the API Page: Go to the Semrush Keyword Research on RapidAPI. Sign Up/Login: Create an account or log in if you already have one. Subscribe to the API: Click "Subscribe to Test" and choose a plan (free or paid). Copy Your API Key: After subscribing, your API Key will be available in the "X-RapidAPI-Key" section under "Endpoints". Use the Key: Include the key in your API requests like this: -H "X-RapidAPI-Key: YOUR_API_KEY" 🛠 Customizing the Workflow To modify the automated workflow and adapt it to your specific use case, follow these guidelines: Adjust the Data Retrieval Process: You can modify the data you want to receive from the Semrush API. For example, if you’re only interested in search volume and CPC, you can filter out the other results in the API request. Add More Countries: If you work with multiple regions, modify the workflow to accept multiple country inputs. You could either pass in a list of countries or have a dropdown on the form that lets users select their country of choice. Expand Keyword Types: The workflow can be expanded to collect data for different types of keywords, such as long-tail or LSI (Latent Semantic Indexing) keywords, depending on your SEO needs. Set Up Scheduled Keyword Reporting: To automate reporting, you can schedule keyword research reports to run at regular intervals, such as monthly, using Google Apps Script or another task scheduler. This way, you’ll always have fresh data on hand for analysis. ✅ Tips for Smooth Workflow Integration Test Your API Integration: Run a test to check if data is properly flowing into your Google Sheet before automating the process. Set Up Notifications: Use Google Sheets' built-in notifications or an external automation tool (e.g., Zapier, Integromat) to notify you when new data is added or if there’s an issue with the workflow. Handle Errors Gracefully: Add error handling in your automated process to prevent issues like missing data or API request failures from disrupting your workflow. An n8n automation workflow template by Evoort Solutions.

By Allan Vaccarizi

Quick overview 📺 Full walkthrough video: https://youtu.be/62QIMjT2u-E Automatically pulls monthly Google Ads campaign metrics for multiple clients via the API and appends the data into dedicated Google Sheets tabs — triggered on the 3rd of each month. How it works A Schedule Trigger fires on the 3rd of each month at 10 AM to kick off the reporting process. A Google Sheets node reads the full client list (with their Google Ads Customer IDs) from a source sheet. A SplitInBatches loop iterates over each client one by one, sending a POST request to the Google Ads searchStream API endpoint to fetch last month's campaign metrics (cost, clicks, impressions, conversions, conversion value). A JavaScript Code node flattens the raw API response, converts cost from micros to euros, rounds numeric values, and normalizes the month format. The processed rows are appended to a dedicated per-client tab (named Data {Client}) in the same Google Sheet. A Wait node pauses execution between each client to respect API rate limits before looping to the next. Setup Duplicate the template spreadsheet — Google Sheets Template — and save it to your Google Drive. Connect your Google Sheets OAuth2 credentials and point the "Read Clients from Sheets" node to your spreadsheet and the "Client" source sheet. Connect your Google Ads OAuth2 credentials in the HTTP Request node. Replace the developer-token and login-customer-id header values in the HTTP Request node with your own. Ensure each client tab in the spreadsheet is named Data {Client} to match the dynamic sheet name expression. Adjust the Wait node delay if needed to avoid hitting API rate limits. Requirements Google Ads account with API access and a valid developer token Google Sheets account with OAuth2 credentials A spreadsheet with a "Client" sheet listing client names and their Google Ads Customer IDs One tab per client named Data {Client} in the same spreadsheet Customization Modify the GAQL query in the HTTP Request node to pull different metrics or date ranges (e.g., LAST_7_DAYS, THIS_MONTH) Extend the JavaScript transformation to compute additional KPIs such as CPC or ROAS before appending to the sheet Add a Slack or email notification after each client iteration to alert stakeholders when the report is ready Additional info Template maintained by Growth AI — a Lyon-based automation agency specializing in n8n workflows. For custom enterprise reporting pipelines, reach out via LinkedIn. An n8n automation workflow template by Allan Vaccarizi.

By Allan Vaccarizi

Quick overview 📺 Full walkthrough video: https://youtu.be/62QIMjT2u-E Automatically captures Webflow form submissions, formats phone numbers with international dial codes, and creates or updates contacts, organizations, and leads in Pipedrive — then notifies the team via Discord and sends a confirmation email to the lead. How it works A Webflow form submission triggers the workflow, capturing lead fields: first name, last name, company, professional email, phone number, website URL, and message. Key fields are mapped via a Set node, and a custom JavaScript code node cleans and formats the phone number with the correct international dial code (France, Belgium, Switzerland, and 15+ other countries supported). The workflow searches Pipedrive for an existing organization matching the company name. If none is found, a new one is created. Both paths merge via an Aggregate node. It then searches for the contact person by full name. If found, their email and phone are updated; if not, a new person is created and linked to the organization. A new lead is created in Pipedrive associating the resolved person and organization, with a label and owner automatically assigned. In parallel: a Discord message notifies the team in the configured channel, a Gmail confirmation email is sent to the lead, and — if a website URL was provided — the organization's URL field in Pipedrive is updated. Setup Connect your Webflow OAuth2 credentials and configure the "When Webflow Form Submitted" trigger with the correct site. Add Pipedrive API credentials to all Pipedrive nodes (Search/Create Organization, Search/Update/Create Person, Create Lead, Update Organization URL). Add Discord Bot credentials and set the target server and channel in the "Notify Team on Discord" node. Add Gmail OAuth2 credentials and adjust the email subject and body in the "Send Confirmation Email" node. Review the "Format Phone Numbers" code node to confirm the country detection logic matches your audience (France is the default fallback). Ensure your Webflow form field names match the mapped keys in the "Set Contact Fields" node (Prénom, Nom, Entreprise, Mail professionnel, Téléphone pro, URL du site internet, Message). Requirements Webflow account with a published form and OAuth2 access Pipedrive CRM account with API credentials Discord server with a configured bot token Gmail account with OAuth2 access Customization Extend the "Set Contact Fields" node to map additional Webflow form fields into Pipedrive custom properties Replace the Gmail node with a SendGrid or SMTP node to use a transactional email service instead Add a Slack node alongside or in place of Discord if your team uses Slack for notifications Modify the "Format Phone Numbers" code node to add new country patterns or change the default fallback country Additional info Template maintained by Growth AI — a Lyon-based automation agency specializing in n8n workflows. For custom enterprise CRM integrations, reach out via LinkedIn. An n8n automation workflow template by Allan Vaccarizi.

By Chris Rudy

Who's it for Marketing teams, agencies, and businesses who regularly create tens or hundreds of Facebook ads and store their creative assets in Google Drive. Perfect for teams who want to stop doing manual work of uploading and setting up ads. What it does This workflow automates the entire Facebook ad creation process from a simple form submission. Users provide a Google Drive link to their media file, ad copy, and target URL through a form. The workflow then automatically fetches the media from Google Drive, creates a new Facebook ad with proper naming conventions (matching the Drive file name), applies tracking parameters, and publishes it to the specified ad set. It sends Slack notifications upon successful ad creation or if errors occur. How it works User submits a form with Google Drive media link, ad set name, ad text, and destination URL Workflow authenticates and fetches the image/video from Google Drive Creates a Facebook ad with the media, using the Drive filename as the ad name Applies UTM tracking parameters automatically Disables Facebook's automated rules to maintain manual control Sends status updates via Slack (success or failure notifications) Requirements Self-hosted n8n instance Google Drive account with API access Facebook Business Manager with active ad account(s) Slack workspace for notifications How to customize the workflow Connect multiple Facebook ad accounts for agency use Modify the form fields to include additional ad parameters Customize Slack notification messages and channels. An n8n automation workflow template by Chris Rudy.

By David Olusola

⚠️ Crypto Price Threshold Alerts (Email/SMS/Telegram) 📌 Overview This workflow monitors Bitcoin (BTC) and Ethereum (ETH) prices in real-time using CoinGecko’s public API. It sends you an instant alert when a price crosses a custom threshold or when the 24-hour change moves beyond your defined % range. Perfect for traders who want automated price pings without constantly checking charts. ⚙️ How it works Schedule Trigger — runs every 10–15 minutes (configurable cron). HTTP Request (CoinGecko) — fetches live BTC/ETH prices + 24h % changes. Code Node — compares values against your target thresholds. IF Node — checks if any condition is true (cross up/down or big move). Notification Node — sends alert via Email, SMS (Twilio), or Telegram. Example Output: > “BTC broke $110,000 (+2.1% 24h)” 🛠 Setup Guide Set your thresholds in the Code node: BTC_UP / BTC_DOWN ETH_UP / ETH_DOWN MOVE_ABS (absolute % change to trigger) Choose delivery channel: Email Node → SMTP (Gmail, Outlook, etc.) Twilio Node → SMS alerts Telegram Node → DM or channel alerts Test Run: Execute once from the Code node. If thresholds are crossed, you’ll see a formatted alert payload. 🎛 Customization Adjust interval in the Schedule Trigger (default: every 15m). Add more cryptos by editing the CoinGecko API call. Use Slack or Discord instead of Email/Telegram for team alerts. Store last triggered state in Google Sheets/DB to avoid repeated pings. 👤 Author David Olusola For traning automation & 1:1 consulting: sales@daexai.com. An n8n automation workflow template by David Olusola.

By Davide Boizza

This automated workflow generates a video featuring a talking AI avatar from a single image and automatically publishes it to TikTok with Postiz. The process involves two main AI services chained together: Elevenlabs v3 and Infinitalk. Key Benefits ✅ Full Automation – From text input to TikTok publication, the process is completely automated. ✅ Time-Saving – Eliminates manual video editing, voice-over recording, and social media posting. ✅ Scalable – Can generate multiple avatar videos daily with minimal effort. ✅ Customizable – Flexible inputs (image, voice, text, prompts) allow adaptation for different content types (weather forecasts, product promos, tutorials, etc.). ✅ Engagement-Oriented – Uses AI to optimize video titles for TikTok, increasing chances of visibility and audience interaction. ✅ Consistent Branding – Ensures uniform style and messaging across multiple video posts. How It Works Text-to-Speech (TTS) Generation: The workflow starts by sending a predefined text script and a selected voice (e.g., "Alice") to the Fal.ai service, which utilizes ElevenLabs' AI to generate a high-quality audio file. The workflow then polls the API until the audio generation is COMPLETED and retrieves the URL of the generated audio file. Talking Avatar Video Generation: The workflow takes a static image URL and the newly created audio URL and sends them to another Fal.ai service (Infinitalk). This AI model animates the avatar in the image to lip-sync and match the provided audio. A prompt guides the avatar's expression (e.g., "You are a girl giving a weather forecast and you must be expressive"). The workflow again polls for status until the video is COMPLETED. Title Generation & Publishing: Once the video is ready, its URL is fetched. Simultaneously, an OpenAI (GPT-4o-mini) node generates an optimized, engaging title (under 60 characters) for the TikTok post based on the original script and avatar prompt. The final video file is downloaded and uploaded to Postiz (a social media scheduling service), which finally posts it to a pre-configured TikTok account. Set Up Steps Before executing this workflow, you must configure the following third-party service credentials and node parameters within n8n: Fal.ai API Credentials: Create an account on Fal.ai and obtain an API key. Create a new credential of type "HTTP Header Auth" in n8n named "Fal.run API". The key should be placed in the Value field, and the Header Name must be set to Authorization. The value should be Key <YOUR_FAL_AI_API_KEY>. OpenAI API Credentials: You need an OpenAI API key. Create a credential in n8n of type "OpenAI API", name it (e.g., "OpenAi account"), and enter your API key. Postiz API Credentials: Create an account on Postiz, connect your TikTok account, and get your API key from the Postiz dashboard. In n8n, create an "HTTP Header Auth" credential named "Postiz". Set the Header Name to X-API-Key and the Value to your Postiz API key. Also, create a "Postiz API" credential in n8n and enter the same API key. Configure Postiz Node: In the "TikTok" (Postiz) node, you must replace "XXX" in the integrationId field with the actual ID of your connected TikTok account from your Postiz dashboard. (Optional) Customize Inputs: You can modify the default values in the "Set text input" node (the script and voice) and the "Set Video Params" node (the image_url and the prompt for the avatar's expression) to create different videos without changing the workflow's structure. Need help customizing? Contact me for consulting and support or add me on Linkedin. An n8n automation workflow template by Davide Boizza.

By WeblineIndia

Job post expiry & refresh reminders from Google Sheets using HTTP Last‑Modified checks This workflow checks each job URL in your Google Sheet and identifies listings that look stale based on the page’s Last‑Modified date. At 10:00 Asia/Kolkata every day, it requests each URL (HEAD, then GET if needed), calculates the age in days, and sends a polite email reminder to the recruiter when age ≥ a configurable threshold (default 30 days). It includes a DRY_RUN mode to preview who would be emailed, and conservative rate limits for both HTTP requests and email sends. Who’s it for Recruitment teams maintaining job links on external boards/career sites. Coordinators who want a daily, hands‑off nudge to refresh or unlist outdated posts. Teams using Google Sheets to store job URLs and owner contacts. How it works Cron (10:00 IST) triggers daily. Google Sheets reads the Job Posts tab (job_url, recruiter_name, recruiter_email). Validate rows (URL + email format, weekend rule via config). HTTP HEAD to fetch headers; if Last-Modified missing, HTTP GET and parse common meta tags (article:modified_time, og:updated_time, lastmod, dateModified). Compute age (days since last modified in your configured timezone). If age_days ≥ THRESHOLD_DAYS, prepare a personalized email using templates. DRY_RUN? If true, output a preview; if false, rate‑limit and send emails via SMTP. How to set up Create the Sheet Tab name: Job Posts Columns: job_url, recruiter_name, recruiter_email Credentials in n8n Google Sheets (OAuth) SMTP (Gmail) (use an app password if 2FA) Open “Set: Config” and set: SPREADSHEET_ID = your Sheet ID SOURCE_SHEET = Job Posts TIMEZONE = Asia/Kolkata THRESHOLD_DAYS = 30 (change if needed) USER_AGENT = n8n-job-checker/1.0 HTTP_TIMEOUT_SECONDS = 10 HTTP_RETRIES = 2 RATE_LIMIT_HTTP_SECONDS = 5 RATE_LIMIT_EMAIL_SECONDS = 2 SMTP_FROM = sender email (e.g., hiring-ops@company.com) SUBJECT_TEMPLATE, HTML_TEMPLATE, TEXT_TEMPLATE (placeholders: {{recruiter_name}}, {{job_url}}, {{age_days}}, {{last_modified}}) INCLUDE_WEEKENDS = true DRY_RUN = false (set true to preview) Activate the workflow. Requirements Google Sheet with Job Posts tab and required columns. SMTP (Gmail) account to send emails. n8n (cloud or self‑hosted) with Google Sheets + SMTP credentials. How to customize Threshold:** Change THRESHOLD_DAYS (e.g., 15, 45). Schedule:** Adjust the Cron time from 10:00 IST to your preferred hour. Templates:** Edit SUBJECT_TEMPLATE, HTML_TEMPLATE, and TEXT_TEMPLATE. Rate limits:** Tune RATE_LIMIT_HTTP_SECONDS and RATE_LIMIT_EMAIL_SECONDS for your environment. Weekend behavior:** Toggle INCLUDE_WEEKENDS. Preview runs:** Use DRY_RUN=true to check recipients before real sends. Add‑ons Helper columns:** Write back last_modified_http, age_days, reminder_sent_at, last_checked_at, notes to the sheet. Per‑row override:** Add threshold_days column to override the global threshold per job. Slack notifications:** DM the recruiter or a channel in addition to (or instead of) email. One‑time reminders:** Email only once until the page updates (track reminder_sent_at). Robots/backoff:** Respect robots.txt or add exponential backoff for high‑traffic sites. Use Case Examples Career site posts** that haven’t been updated in 30+ days. Remind owners to refresh copy or close the listing. Third‑party boards** (e.g., niche communities) where Last‑Modified is available — automate hygiene checks. Agency partnership links** — ensure outdated roles aren’t left live, protecting brand experience. Common troubleshooting | Issue | Possible Cause | Solution | | --- | --- | --- | | No emails sent | DRY_RUN is true | Set DRY_RUN=false to actually send. | | Rows skipped | Invalid/missing job_url or recruiter_email | Fix the row values; ensure valid URL and email. | | “Stale” not detected | Page has no Last-Modified header and no recognizable meta tags | Add manual review; consider the Helper columns add‑on to log missing dates, or track first_seen_at. | | Wrong time math | Timezone mismatch | Confirm TIMEZONE=Asia/Kolkata (or your TZ) in Set: Config. | | Too many requests | Sites rate‑limit frequent checks | Increase RATE_LIMIT_HTTP_SECONDS; consider running less frequently. | | Emails fail to send | SMTP auth or quota issues | Verify SMTP credentials, sender address, and provider limits; try a different sender or schedule. | Need Help? If you’d like help tailoring the templates, adding Slack notifications or writing back helper columns for audit, just message us at WeblineIndia and we will be happy to help you get this running smoothly. An n8n automation workflow template by WeblineIndia.

By David Olusola

🌐 Crypto + FX Micro-API (Webhook JSON) 📌 Overview Spin up a tiny, serverless-style API from n8n that returns BTC/ETH prices & 24h changes plus USD→EUR and USD→NGN from public, no-key data sources. Ideal for dashboards, low-code apps, or internal tools that just need a simple JSON feed. ⚙️ How it works Webhook (GET /crypto-fx) — entrypoint for your client/app. HTTP: ExchangeRate-API — USD-base FX rates (no API key). HTTP: CoinGecko — BTC/ETH prices + 24h % change (no API key). Merge — combines payloads. Code (v2) — shapes a clean JSON: btc.price, btc.change_24h eth.price, eth.change_24h usd_eur, usd_ngn, ts (ISO timestamp) Respond to Webhook — returns the JSON with HTTP 200. 🛠 Setup Guide 1) Webhook path & URL In the Webhook node, confirm HTTP Method = GET and Path = crypto-fx. Use the Test URL while building; switch to Production URL for live usage. 2) Test the endpoint Curl: curl -s https://<your-n8n-host>/webhook/crypto-fx Browser / fetch(): fetch('https://<your-n8n-host>/webhook/crypto-fx') .then(r => r.json()) .then(data => console.log(data)) 3) Response mapping (already wired) Respond to Webhook → Response Body is set to {{$json}}. The Code node outputs the exact JSON structure shown above, so no extra mapping is required. 🔐 Security (recommended) Add a Webhook Secret (query header check in Code node) or IP allowlist via your reverse proxy. If embedding in public sites, proxy through your backend and apply rate-limit/cache headers there. 🚀 Usage ideas Frontend dashboards (Chart.js, ECharts). HomeAssistant / Node-RED info panels. Google Apps Script to store the JSON into Sheets on a timer. 🎛 Customization More coins: extend CoinGecko ids= (e.g., bitcoin,ethereum,solana). More FX: read additional codes from fx.rates and add to the payload. Timestamps: convert ts to your preferred timezone on client side. CORS: if calling from browsers, add CORS headers in Respond (options → headers). 🧩 Troubleshooting Empty/partial JSON: run the two HTTP nodes once to verify responses. 429s / rate limiting: add a short Wait node or cache outputs. Wrong URL: ensure you’re using Production URL outside the n8n editor. Security errors: if you add a secret, return 401 when it’s missing/invalid. An n8n automation workflow template by David Olusola.

By JKingma

📄 PDF-to-Order Automation for Magento2 (Adobe commerce / open source) Description This n8n template demonstrates how to automatically process PDF purchase orders received via email and convert them into sales orders in Adobe Commerce (Magento 2) using Company Credit as the payment method. This is especially useful for B2B companies receiving structured orders from clients by email. Use cases include: Automating incoming B2B orders Reducing manual entry for sales teams Ensuring fast order creation in Adobe Commerce Reliable error handling and customer validation Good to know This workflow is tailored for Adobe Commerce, using the Company Credit payment method. It requires that the customer already has an account in Adobe Commerce and is authorized to use Company Credit. The same flow can be easily adapted for other payment methods (e.g. Purchase Order, Bank Transfer). No third-party services are required aside from n8n and access to Adobe Commerce with API credentials. How it works Trigger → Monitors an email inbox for incoming emails with PDF attachments. Extract PDF → Downloads the attached PDF and parses order data (e.g. SKU, quantity, customer reference). Validate Customer → Checks if the sender matches an existing customer in Adobe Commerce and verifies Company Credit eligibility. Create Order → Generates a new order in Magento using the extracted product data and Company Credit. Handle Errors → Logs issues and can notify a designated channel (email, Slack, etc.) if something goes wrong. Optional Enhancements → Add logging to Airtable, send confirmations to customers, or attach parsed order data to CRM entries. How to use A manual trigger is included as an example, but you can replace it with an IMAP Email Trigger, Gmail Trigger, or Webhook, depending on your setup. Customize the PDF parser node to fit your specific document layout and field structure. Configure Adobe Commerce API credentials in the HTTP nodes (or use environment variables). Optionally connect error steps to Slack, Email, or dashboards for monitoring. Requirements ✅ n8n instance (self-hosted or cloud) ✅ Adobe Commerce (Magento 2) instance with API access and Company Credit enabled ✅ Structured PDF templates used by your customers (Optional) Slack/Email/Airtable for notifications and logs Customising this workflow This workflow can be adapted for: Other payment methods (e.g. Purchase Orders, Online Payment) Magento open source ready. Just use your own payment method Alternate order sources (e.g. uploading PDFs via a portal instead of email) Parsing other document formats (e.g. CSV, Excel) Direct integration into ERP systems. An n8n automation workflow template by JKingma.

By David Olusola

📉 Buy the Dip Alert (Telegram/Slack/SMS) 📌 Overview This workflow automatically notifies you when Bitcoin or Ethereum drops more than a set percentage in the last 24 hours. It’s ideal for traders who want to stay ready for buy-the-dip opportunities without constantly refreshing charts. ⚙️ How it works Schedule Trigger — runs every 30 minutes (adjustable). HTTP Request (CoinGecko) — fetches BTC & ETH prices and 24h % change. Code Node (“Dip Check”) — compares changes against your dip threshold. IF Node — continues only if dip condition is true. Notification Node — sends alert via Telegram, Slack, or SMS (Twilio). Example Output: Dip Alert — BTC –3.2%, ETH –2.8% Not financial advice. 🛠 Setup Guide 1) Dip threshold Open the Code node. Change the line: const DIP = -2.5; // trigger if 24h drop <= -2.5% Set your preferred dip value (e.g., –5 for a 5% drop). 2) Choose your alert channel Telegram: add your bot token & chat ID. Slack: connect Slack API & set channel name. Twilio: configure SID, token, from/to numbers. 3) Test Temporarily set DIP to 0 to force an alert. Run once from the Code node → confirm alert message text. Execute the Notification node → confirm delivery to your channel. 🎛 Customization Cadence: change Schedule Trigger (every 5m, 15m, hourly, etc.). Coins: extend the CoinGecko call (add solana, bnb) and update Code node logic. Multiple alerts: duplicate IF → Notification branch for different thresholds (minor vs major dip). Combine with “Threshold Alerts” workflow to cover both upside breakouts and downside dips. Storage: log alerts into Google Sheets for tracking dip history. 🧩 Troubleshooting No alerts firing: check CoinGecko API response in Execution Data. Wrong %: CoinGecko returns usd_24h_change directly — no math needed. Duplicate alerts: add a debounce using a Sheet/DB to store last fired time. Telegram not posting: confirm bot has access to your channel/group. An n8n automation workflow template by David Olusola.

By Oussama

This n8n template creates an intelligent Ideation Agent 🤖 that captures your ideas from text and voice notes sent via Telegram. The assistant automatically transcribes your voice memos, analyzes the content with a powerful AI, and organizes it into a structured Google Sheet database. It's the perfect workflow for capturing inspiration whenever it strikes, just by talking or typing 💡. Use Cases: 🗣️ Text-Based Capture: Send any idea as a simple text message to your Telegram bot for instant processing. 🎙️ Voice-to-Idea: Record voice notes on the go. The workflow transcribes them into text and categorizes them automatically. 📂 Automated Organization: The AI agent intelligently structures each idea with a title, description, score, category, and priority level without any manual effort. 📊 Centralized Database: Build a comprehensive and well-organized library of all your ideas in Google Sheets, making it easy to search, review, and act upon them. How it works: Multi-Modal Input: The workflow starts with a Telegram Trigger that listens for incoming text messages and voice notes. Content-Based Routing: A Switch node detects the message type. Text messages are sent directly for processing, while audio files are routed for transcription. Voice Transcription: Voice messages are sent to the ElevenLabs API, which accurately converts the speech into text. Unified Input: Both the original text and the transcribed audio are passed to the AI Agent in a consistent format. AI Analysis & Structuring: An AI Agent, receives the text. It follows a detailed system prompt to analyze the idea and structure it into predefined fields: Idea, Idea Description, Idea Type, Score, Category, Priority, Status, and Complexity. Data Storage: The agent uses the Google Sheets Tool (add_row_tool) to seamlessly add the fully structured idea as a new row in your designated spreadsheet. Instant Confirmation: Once the idea is saved, the workflow sends a confirmation message back to you on Telegram, summarizing the captured idea. Requirements: 🌐 A Telegram Bot API token. 🤖 An AI provider with API access (the template uses Azure OpenAI, but can be adapted). 🗣️ An ElevenLabs API key for voice-to-text transcription. 📝 Google Sheets API credentials to connect to your database. Good to know: ⚠️ Before you start, make sure your Google Sheet has columns that exactly match the fields defined in the Agent's system prompt (e.g., "Idea ", "Idea Description ", "Idea Type", etc.). Note that some have a trailing space in the template. 🎤 The quality of the voice transcription is dependent on the clarity of your recorded audio. ✅ You can completely customize the AI's behavior, including all the categories, types, and scoring logic, by editing the system prompt in the Agent node. Customizing this workflow: ✏️ Modify Categories: To change the available Idea Type, Category/Domain, or Priority Level options, simply edit the list within the Agent node's system prompt. 🔄 Swap LLM: You can easily change the AI model by replacing the Azure OpenAI Chat Model node with another one, such as the standard OpenAI node or a local AI model. 🔗 Change Database: To save ideas to a different platform, just replace the add_row_tool1 (Google Sheets Tool) with a tool for another service like Notion, Airtable, or a database. An n8n automation workflow template by Oussama.

By Marth - Business Automation

How it Works This workflow automates customer support for SMEs in five simple steps: Capture requests via a Webhook connected to a contact form. Extract the message to make processing easier. Check categories (e.g., refund-related requests) using an IF node. Save all tickets to a Google Sheet for tracking. Send an acknowledgment email back to the customer automatically. This setup ensures all customer inquiries are logged, categorized, and acknowledged without manual effort. Setup Steps Webhook Add a Webhook node with the path customer-support. Configure your contact form or system to send name, email, and message to this webhook. Extract Message (Set Node) Add a Set node. Map the incoming message field to make it available for other nodes. Check Category (IF Node) Insert an IF node. Example: check if the message contains the word “refund”. This allows you to route refund-related requests differently if needed. Save Ticket (Google Sheets) Connect to Google Sheets with OAuth2 credentials. Operation: Append. Range: Tickets!A:C. Map the fields Name, Email, and Message. Send Acknowledgement (Email Send) Configure the Email Send node with your SMTP credentials. To: ={{$json.email}}. Subject: Support Ticket Received. Body: personalize with {{$json.name}} and include the {{$json.message}}. 👉 With this workflow, SMEs can handle incoming support tickets more efficiently, maintain a simple ticket log, and improve customer satisfaction through instant acknowledgment. An n8n automation workflow template by Marth - Business Automation.