by David Olusola
🚀 Auto-Save Instagram Leads to Google Sheets This workflow automatically captures leads submitted through an Instagram Form and saves the data directly to a Google Sheet. It ensures that every new lead is instantly logged, creating a centralized database for your marketing and sales teams. ⚙️ How It Works Receive Lead Data The workflow starts with an Instagram Lead Webhook that listens for new lead submissions from your Instagram account's lead form. Normalize Data A Code node processes the raw data received from Instagram. This node normalizes the lead information, such as name, email, and phone number, into a consistent format. It also adds a "Source" field to identify the lead as coming from Instagram and timestamps the entry. Save to Google Sheets Finally, the Save to Google Sheets node takes the normalized data and appends it as a new row in your designated Google Sheet. It uses the email field to check for existing entries and can either append a new row or update an existing one, preventing duplicate data. 🛠️ Setup Steps 1. Create Google Sheet Create a new Google Sheet with the following headers in the first row (A1): 2. Get Sheet ID Find your Sheet ID in the URL of your Google Sheet. It's the long string of characters between /d/ and /edit. Example: Replace YOUR_GOOGLE_SHEET_ID in the Save to Google Sheets node with your actual ID. 3. Connect Instagram Form Copy the Webhook URL from the "Instagram Lead Webhook" node. In your Instagram lead form settings, paste this URL as the webhook destination. Ensure your form fields are mapped correctly (e.g., name, email, phone, message). ✅ Once configured, every Instagram lead will instantly appear in your Google Sheet — organized, timestamped, and ready for follow-up.
by Alexander Schnabl
Audit external sharing in SharePoint to ensure compliance This workflow audits your SharePoint Online environment for external sharing risks by identifying files and folders that are shared with anonymous links or external/guest users. It is designed to traverse SharePoint recursively, giving you full visibility into sharing across all sites, document libraries, folders and files. What it does Scans all SharePoint sites in the tenant. Traverses SharePoint recursively** through every folder and file, starting at the root of each drive. Fetches permissions for every item (files and folders). Detects and flags: Anonymous sharing links (anyone links) External or guest users, identified by: SharePoint guest login markers (#ext#, urn:spo:guest) Email domains not matching your internal tenant domains Outputs only items that are externally shared, including detailed metadata and permission evidence. How it works In the Set Variables node you define your internal tenantDomains, used to distinguish internal users from external ones. Microsoft Graph** is used to: Fetch all SharePoint sites Retrieve drives (document libraries) per site Each drive triggers a recursive subworkflow that: Starts at the root level Determines whether an item is a folder or a file If a folder, drills down into its children Keeps both folders and files, since both can have unique permissions For every discovered item: Permissions are retrieved via Microsoft Graph Item metadata and permissions are merged A custom filtering step analyzes permissions and: Flags anonymous links and external principals Drops items with no external exposure The final output is a clean, normalized list of externally shared SharePoint items, enriched with: Item name, type, URL and last modified date Site, drive, and parent identifiers Detailed lists of anonymous links and external users found Setup Create a Microsoft Entra ID (Azure AD) App Registration. Grant Microsoft Graph – Application permissions: Sites.Read.All Configure an OAuth2 Client Credentials credential in n8n and assign it to all HTTP Request nodes. Update the Set Variables node: Add all internal tenant domains (e.g. yourDomain.onmicrosoft.com, yourDomain.com) Run the workflow manually or attach a Schedule Trigger for recurring audits. Notes The workflow traverses SharePoint recursively, ensuring no nested folder or file is missed. Both folders and files are included because permissions can be broken at any level. External users are detected defensively using both login-name patterns and email domain checks.
by Open Paws
Multi-Version Content Generator with AI Scoring & Advocacy Preference Ranking ✍️ Who’s it for 🐾 This workflow is ideal for animal advocates, campaign managers, and content creators who want to generate multiple versions of written content—such as blog posts, emails, or social media captions—and identify the most effective and persuasive options using advanced AI scoring models. How it works / What it does ⚙️ The flow takes user input specifying content type, tone, style, and topic. It calls a powerful research and content generation subworkflow to produce five fully written content variations. These are split and passed to a scoring subworkflow that uses Open Paws AI models trained on real-world social media and email marketing data, combined with evaluations from animal advocacy experts. Finally, it aggregates the content with their performance and prediction scores, outputting a ranked list of content options. How to set up 🛠️ Add the following subworkflows to your n8n instance before running this flow: Multi-Tool Research Agent for Animal Advocacy Evaluate Animal Advocacy Text with Hugging Face & Open Paws AI Models Requirements 📋 n8n instance API key for OpenRouter The linked research and scoring subworkflows installed and accessible How to customize the workflow 🎨 Modify the user input fields to change content type, tone, style, and topic. You can extend the scoring node or integrate this flow as a subworkflow within larger automation pipelines—for example, to schedule posting or feed an AI agent for content selection.
by Geoffroy
This n8n template saves you hours of manual SEO work by automatically parsing your sitemap and submitting updated URLs to Google and Bing (IndexNow). Who’s it for Site owners, SEOs, and marketers who want a single automation to notify Google (Indexing API) and Bing (via IndexNow) whenever site URLs are added or updated. No more need to update it manually. Hours saved What it does This workflow parses your sitemap.xml, and for each URLs that have been changed on the last X days (this is a setting from Config node), submit them to Google and Bing via IndexNow. Before submitting to Google it checks the status. For IndexNow it just submits based on the last updated date it can find on the sitemap. How it works Parses your sitemap(s)to generate a list of urls ordered by lastmod date. Create a batch of the urls updated in the last X days (settings DAYS_BACK from the "Config" node) For Google, it first aks the current indexing notification status of this exact URL. If the sitemap shows the page was modified after the last submission, the workflow sends a new "URL_UPDATED" notification to Google. If Google has no record (404), it means the URL was never submitted and the workflow treats it as new and submits it. For Bing through IndexNow, it only sends “recently changed URLs” based on the sitemap’s <lastmod> and the variable DAYS_BACK from the Config Node, by batches of 500 (current limit recommendation by Bing). IndexNow doesn't have an API to check the status of the url. Requirements Google Indexing API credentials (Service Account with https://www.googleapis.com/auth/indexing scope, added as Owner in Search Console). IndexNow API key: you can create it here https://www.bing.com/indexnow/getstarted. How to use Edit the "Config" node with your data & preferences (everything explain in the workflow). Edit the "Check status (Google)" and "URL updated (Google)" node with your Google service account credentials. Execute the workflow to test it Set up a cron with the "Schedule Trigger" node depending on your needs
by Muhammad Anas Farooq
n8n Self-Updater Workflow > An automated n8n workflow originally built for DigitalOcean-based n8n deployments, but fully compatible with any VPS or cloud hosting (e.g., AWS, Google Cloud, Hetzner, Linode, etc.) where n8n runs via Docker. This workflow checks for the latest Docker image of n8n, notifies you via email for approval, and securely updates your n8n instance via SSH once approved. How It Works Trigger: The workflow runs automatically every 3 days at 4 PM UTC (or manually if triggered). Check Version: It retrieves your current n8n Docker version and image digest via SSH. Compare: Fetches the remote digest from Docker Hub and compares it with the local one. Notify via Email: If a new update is available, an approval email is sent with details: Current version Local digest Remote digest What will happen after approval Approval Logic: Approve → Workflow connects via SSH and updates the n8n container automatically. Decline → Workflow ends; next check occurs in the next cycle. Auto Update Execution: Creates (if missing) a update_docker.sh script on the server. Runs it in the background (nohup) to: cd /opt/n8n-docker-caddy docker compose pull docker compose down docker compose up -d The delay ensures n8n restarts only after workflow completion. Requirements SSH Access** to your server (where n8n runs). Add your credentials in n8n under Credentials → SSH Password. SMTP Connection** for email notifications. Configure in Credentials → SMTP. Fill in: From Email → e.g., info@yourdomain.com To Email → your email for receiving approvals Docker-based n8n Deployment**, e.g., n8n-docker-caddy setup. Docker and docker-compose** installed on the server. How to Use Import the Workflow: Copy the provided JSON file. In your n8n instance → click Import Workflow → paste the JSON. Set Up Credentials: Create two credentials in n8n: SSH Password → Your server's SSH credentials. SMTP → Your email provider's SMTP credentials. Edit the Email Node: Replace: fromEmail: info@yourdomain.com → with your email. toEmail: youremail@yourdomain.com → with your desired recipient. Enable Auto Trigger (optional): Go to the Schedule Trigger node and set your desired interval/time. Run the Workflow: Test manually first. Once verified, activate it for automatic checks. Notes Originally designed for DigitalOcean VPS setups, but can run on any Docker-based n8n server. The workflow avoids duplicate updates by comparing digests instead of version tags. If the update_docker.sh file already exists, it reuses it safely. Approval emails include full details for transparency. Background execution ensures no interruptions during restart. Example Behavior Day 1**: Workflow checks → detects update → sends email → user approves. 30 seconds later**: Workflow runs update script → n8n restarts with latest Docker image. Day 4**: Workflow checks again → digests match → silently completes (no email sent). Author: Muhammad Anas Farooq
by WeblineIndia
Incident Reporting & Management Workflow (Form + Google Sheets + Email) This workflow automates incident reporting and management for operations teams by connecting a public reporting form with real-time logging in Google Sheets and instant alert emails to your support team. Whenever an incident is reported via the n8n form/webhook, all details are saved securely and immediately and the right people are notified the moment issues occur. It's a fast, scalable solution for reliable incident handling. Who’s It For Renewable energy operators (solar/wind/green energy). Facility and plant managers. Environmental, EHS and safety teams. Technical support and incident response crews. Maintenance & field operations teams. Anyone aiming for compliance-ready, audit-friendly digital issue reporting. How It Works Form Submission: An n8n-powered form (or webhook endpoint) receives incident reports, capturing all key details: reporter info, contact, location, date/time, type, severity, actions taken, photos and more. Log to Google Sheets: Each report is instantly appended as a new row in a secure Google Sheet, creating a searchable, timestamped audit trail. Email Alert (Gmail): An automatic email with incident summary and critical details lands in the support team’s inbox seconds after submission—ensuring your response is always prompt. Workflow Automation: These nodes are linked in n8n, enabling no-code/low-code back-end automation for complete visibility and control. How to Set Up Import Workflow: In n8n, use "Import from File" to upload the workflow JSON provided. Edit Configuration: Update form fields as needed (label, validations, options for severity/category). Enter your Google Sheet ID and sharing settings. Configure Gmail/SMTP credentials and recipient address (example: supportteam@mailinator.com or your own team). Deploy Webhook: Copy your n8n webhook URL and connect it to your reporting interface (form, app, device, etc.). Activate: Enable the workflow in n8n. Submissions are now handled in real time. Test: Submit a sample incident to make sure data logs in Google Sheets and the alert email arrives as expected. Requirements | Tool | Purpose | |-----------------|-----------------------------------| | n8n Instance | Orchestrates the workflow | | Google Account | To access/use Google Sheets | | Gmail/SMTP | For sending incident alerts | | Incident Source | n8n Form, webhook, app or device| How to Customize Form Fields**: Add/remove fields or validations in the n8n form for organization-specific needs (e.g., add photos, custom categories). Alert Routing**: Use IF nodes to send critical alerts via Slack, SMS or escalate to on-call teams based on severity/type. Backend**: Replace Google Sheets with Notion, Airtable, PostgreSQL or other databases. Reporting**: Add PDF nodes to auto-generate and send report summaries. Integrations**: Push incidents to ticketing, asset tracking or calendar scheduling workflows. Add‑Ons (Optional Extensions) | Feature | Description | |------------------|------------------------------------------------------| | Slack Alerts | Instantly notify Slack channels on critical issues | | Database Logging | Store reports in SQL/NoSQL systems | | PDF Generation | Email ready-to-use incident reports as PDFs | | Calendar Events | Schedule follow-ups or deadline reminders | | AI Categorization| Auto-classify incidents by severity/type | | Task Creation | Open tickets in Jira, Trello, ClickUp or Asana | Use Case Examples Field engineers report solar inverter faults with mobile forms. Security personnel log site intrusions, with photos and severity. IoT sensors auto-post equipment failures as incidents. Compliance or EHS teams capture safety observations in real time. Technicians submit maintenance or post-repair issues instantly. Common Troubleshooting | Issue | Possible Cause | Solution | |--------------------------|---------------------------------------|----------------------------------------------------------| | Form not triggering | Webhook URL incorrect | Double-check webhook endpoint and method (POST) | | Email not delivered | Wrong SMTP/Gmail credentials | Re-enter credentials or verify SMTP access | | Google Sheets not updated| Sheets ID wrong/missing permissions | Use correct ID, share sheet with service account or make accessible | | Missing report fields in log | Form field names or types mismatched| Align JSON/form data keys with workflow node mappings | | Attachments not saved | Field not set for file type | Review form field definitions and adjust as needed | Need Help? Want a tailored setup, advanced automations or powerful add-ons (AI, SLAs, PDF logs, ticketing integration)? Our n8n workflow experts at WeblineIndia are ready to help you engineer seamless incident management for any industry. 👉 Contact WeblineIndia — Your Automation partner for smart preventive maintenance and calendar-driven ops!
by Jitesh Dugar
Validated RSVP Confirmation with Automated Badge Generation Overview: This comprehensive workflow automates the entire event RSVP process from form submission to attendee confirmation, including real-time email validation and personalized digital badge generation. ✨ KEY FEATURES: • Real-time Email Validation - Verify attendee emails using VerifiEmail API to prevent fake registrations • Automated Badge Generation - Create beautiful, personalized event badges with attendee details • Smart Email Routing - Send confirmation emails with badges for valid emails, rejection notices for invalid ones • Comprehensive Logging - Track all RSVPs (both valid and invalid) in Google Sheets for analytics • Dual Path Logic - Handle valid and invalid submissions differently with conditional branching • Anti-Fraud Protection - Detect disposable emails and invalid domains automatically 🔧 WORKFLOW COMPONENTS: Webhook Trigger - Receives RSVP submissions Email Validation - Verifies email authenticity using VerifiEmail API Conditional Logic - Separates valid from invalid submissions Badge Creator - Generates HTML-based personalized event badges Image Converter - Converts HTML badges to shareable PNG images using HTMLCssToImage Email Sender - Delivers confirmation with badge or rejection notice via Gmail Data Logger - Records all attempts in Google Sheets for tracking and analytics 🎯 PERFECT FOR: • Conference organizers managing hundreds of RSVPs • Corporate event planners requiring verified attendee lists • Webinar hosts preventing fake registrations • Workshop coordinators issuing digital badges • Community event managers tracking attendance 💡 BENEFITS: • Reduces manual verification time by 95% • Eliminates fake email registrations • Creates professional branded badges automatically • Provides real-time RSVP tracking and analytics • Improves attendee experience with instant confirmations • Maintains clean, verified contact lists 🛠️ REQUIRED SERVICES: • n8n (cloud or self-hosted) • VerifiEmail API (https://verifi.email) • HTMLCssToImage API (https://htmlcsstoimg.com) • Gmail account (OAuth2) • Google Sheets 📈 USE CASE SCENARIO: When someone submits your event RSVP form, this workflow instantly validates their email, generates a personalized badge with their details, and emails them a confirmation—all within seconds. Invalid emails receive a helpful rejection notice, and every submission is logged for your records. No manual work required! 🎨 BADGE CUSTOMIZATION: The workflow includes a fully customizable HTML badge template featuring: • Gradient background with modern design • Attendee name, designation, and organization • Event name and date • Email address and validation timestamp • Google Fonts (Poppins) for professional typography 📊 ANALYTICS INCLUDED: Track metrics like: • Total RSVPs received • Valid vs invalid email ratio • Event-wise registration breakdown • Temporal patterns • Organization/company distribution ⚡ PERFORMANCE: • Processing time: ~3-5 seconds per RSVP • Scales to handle 100+ concurrent submissions • Email delivery within 10 seconds • Real-time Google Sheets updates 🔄 EASY SETUP: Import the workflow JSON Configure your credentials (detailed instructions included) Create your form with required fields (name, email, event, designation, organization) Connect the webhook Activate and start receiving validated RSVPs! 🎓 LEARNING VALUE: This workflow demonstrates: • Webhook integration patterns • API authentication methods • Conditional workflow branching • HTML-to-image conversion • Email automation best practices • Data logging strategies • Error handling techniques
by Davide
This workflow automates the process of monitoring Amazon product prices and sending alerts when a product’s price drops below a defined threshold. It integrates ScrapeGraphAI, Google Sheets, and Telegram to provide a complete end-to-end price tracking system. Key Advantages 💡 Intelligent Scraping Uses ScrapeGraphAI to extract structured data (product prices) from complex Amazon pages — even those with dynamic JavaScript rendering. 📊 Centralized Tracking All products and price history are managed in a Google Sheet, making it easy to review and update data. ⚡ Real-Time Alerts Sends instant Telegram notifications when a product’s price drops below its previous minimum — helping users take quick advantage of deals. 🔁 Fully Automated Once set up, it runs on a schedule with no manual input required, automatically updating and alerting users. 🧩 Modular & Extensible Built entirely with n8n nodes, making it easy to customize — for example, adding new alert channels (email, Slack) or additional data checks. 🕒 Time-Efficient Eliminates the need for manual price checking, saving significant time for users monitoring multiple products. How it Works This automated workflow tracks Amazon product prices and sends an alert via Telegram when a product hits a new lowest price. Here's the process: Trigger & Data Fetch: The workflow is initiated either on a scheduled basis (every 10 minutes) or manually. It first connects to a designated Google Sheet, which acts as a database, to fetch a list of products to monitor. Each product's details (Name, URL, and current "MIN PRICE") are read. Price Scraping & Comparison: The workflow loops through each product from the sheet. For each product, it uses ScrapeGraphAI to navigate to the Amazon product page, render JavaScript-heavy content, and extract the current price. This newly scraped price is then compared to the "MIN PRICE" value stored in the Google Sheet for that product. Conditional Alert & Update: If the new price is lower, two actions are triggered: a. Sheet Update: The Google Sheet is updated with the new, lower "MIN PRICE" and the current date. b. Telegram Notification: A message is sent to a specified Telegram chat, announcing that the product has hit a new lowest price, including the product name and a link. If the price is not lower, no action is taken for that product, and the workflow moves on to the next one in the loop. Set up Steps To implement this workflow yourself, follow these steps: Prepare the Google Sheet: Create a copy of the provided template spreadsheet. In the sheet, fill in the columns for PRODUCT (name), URL (the full Amazon product link), and MIN PRICE. When adding a new product, set the MIN PRICE to a very high value (e.g., 9999) to ensure the first real price triggers an alert. Configure n8n Credentials: Google Sheets: Set up a "Google Sheets account" credential in n8n using OAuth2 to grant the workflow access to your copied spreadsheet. ScrapeGraphAI: Configure the "ScrapegraphAI account" credential with your API key from the ScrapeGraphAI service. Telegram: Set up a "Telegram account" credential with a Bot Token obtained from the BotFather in Telegram. You will also need your specific chatId for the node. Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Oneclick AI Squad
This n8n workflow automates the prioritization and scheduling of sales orders based on customer SLAs, urgency, and profitability. It ensures that high-priority and SLA-critical orders are picked, packed, and dispatched first—improving fulfillment speed, customer satisfaction, and operational efficiency across warehouses and logistics. Key Features Automated Order Fetching:** Periodically retrieves all pending or confirmed sales orders from ERP systems. Dynamic SLA-Based Prioritization:** Calculates order priority scores using urgency, customer tier, order value, and profit margin. Intelligent SLA Monitoring:** Identifies SLA breaches and automatically flags them for immediate handling. Automated Task Creation:** Generates urgent picking tasks and alerts warehouse managers in real-time. Smart Scheduling:** Optimizes picking and dispatch timelines based on urgency and capacity. Seamless ERP & TMS Integration:** Updates order statuses and schedules dispatches automatically. Operational Transparency:** Sends end-of-cycle summary reports via email to operations teams. Workflow Process Schedule Trigger Runs every 15 minutes to ensure orders are frequently evaluated. Maintains real-time responsiveness without overloading systems. Fetch Pending Orders Retrieves all orders in pending or confirmed state from ERP API. Configurable limit (e.g., 100 orders per run) for controlled processing. Fetch Customer SLA Data Collects SLA tiers, delivery timeframes, and customer-specific priorities from ERP or CRM API. Supports dynamic customer segmentation (Gold, Silver, Bronze tiers). Calculate Priority Scores Assigns weighted priority scores based on multiple criteria: Urgency: 40% Tier: 30% Order Value: 20% Profit Margin: 10% Produces a composite score used for sorting and scheduling. Check if SLA Critical Detects if any order is close to or past SLA deadlines. Routes SLA-breached orders for immediate escalation. Create Urgent Picking Task Generates warehouse picking tasks for critical orders. Assigns to senior pickers or rapid response teams. Alert Warehouse Manager Sends instant SMS and email alerts for SLA-critical or high-priority orders. Ensures immediate managerial attention. Batch Normal Orders Groups non-critical orders into batches of 10 for optimized processing. Reduces load on WMS while maintaining steady throughput. Generate Picking Schedule Creates smart picking schedules based on urgency: High Priority: Same-day Normal: Within 1 day Low: Within 2–3 days Create Bulk Picking Tasks Pushes picking tasks into WMS (Warehouse Management System). Uses auto-assignment and route optimization logic. Generate Dispatch Schedule Builds dispatch timelines according to delivery method: Express, Priority, or Standard. Syncs with transport capacity data. Schedule Dispatches in TMS Sends dispatch requests to TMS (Transport Management System). Books carriers and reserves capacity for each batch. Update Order Statuses Updates ERP with new order statuses, schedules, and expected delivery dates. Maintains a unified view across systems. Generate Summary Report Creates a summary JSON report including: Total orders processed SLA-critical cases Dispatch breakdowns Next deadlines Send Summary Notification Emails the operations team with execution summary and performance metrics. Ensures team alignment and SLA visibility. Industries That Benefit This automation is especially valuable for: E-commerce & Retail:** To prioritize same-day or express deliveries for VIP customers. Logistics & 3PL Providers:** For meeting tight SLAs across multiple clients and delivery tiers. Manufacturing & B2B Distribution:** Ensures high-value or contractual orders are prioritized. Pharma & Healthcare:** Critical for time-sensitive and compliance-driven deliveries. Consumer Goods & FMCG:** Helps manage high-volume dispatch with smart scheduling. Prerequisites ERP system with API access (e.g., SAP, Odoo, NetSuite). WMS and TMS integrations with order/task APIs. SMTP and SMS gateway credentials for notifications. n8n instance with HTTP, Function, Email, and Scheduler nodes installed. Modification Options Customize priority scoring weights per business type. Integrate AI for predictive SLA breach forecasting. Add Slack/Teams channels for real-time operational alerts. Implement escalation routing for unassigned urgent tasks. Extend reports to include OTIF (On-Time-In-Full) metrics. Explore More AI-Powered Workflows: Contact us for customized supply chain and order management automation.
by Oneclick AI Squad
This n8n workflow automates email blasts with follow-ups and response tracking by reading contact data from a Google Sheet daily, looping through contacts to send personalized emails based on follow-up stages via Gmail, updating the sheet with status changes, and monitoring replies for logging. Why Use It This workflow streamlines email marketing campaigns by automating personalized email distribution, managing follow-up sequences, and tracking responses without manual intervention, saving time, improving engagement, and providing actionable insights into contact interactions. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up Gmail and Google Sheets credentials in n8n. Run the Workflow: Activate the scheduled trigger and test with a sample Google Sheet. System Architecture Email Blast Pipeline**: Daily Trigger - 9 AM: Initiates the workflow daily at 9 AM via Cron. Read Contact Data from Google Sheet: Fetches contact details from the sheet. Loop Through Contacts: Processes each contact individually. Determine Follow-Up Stage: Identifies the current stage for each contact. Send Main/Follow-Up Email: Delivers the appropriate email via Gmail. Update Sheet Status: Updates the Google Sheet with the latest status. Response Tracking Flow**: Check Gmail for Replies: Monitors Gmail for email responses. Log Responses: Records responses in the Google Sheet. Google Sheet File Structure Sheet Name**: EmailCampaign Range**: A1:F10 (or adjust based on needs) | A | B | C | D | E | F | |------------|------------|---------------|---------------|---------------|---------------| | name | email | stage | last_email_date | status | response | | John Doe | john@example.com | Initial | 2025-08-07 | Pending | | | Jane Smith | jane@example.com | Follow-Up 1 | 2025-08-06 | Sent | "Interested" | | Bob Jones | bob@example.com | Follow-Up 2 | 2025-08-05 | Replied | "Follow up later" | Columns**: name: Contact’s full name. email: Contact’s email address for sending emails. stage: Current follow-up stage (e.g., Initial, Follow-Up 1, Follow-Up 2). last_email_date: Date of the last email sent. status: Current status (e.g., Pending, Sent, Replied). response: Logged response from the contact (updated after reply detection). Customization Ideas Adjust Schedule**: Change the Cron trigger to hourly or weekly based on campaign needs. Add Email Templates**: Customize email content for different stages or audiences. Incorporate SMS**: Add WhatsApp or SMS follow-ups using additional nodes. Enhance Tracking**: Integrate a dashboard (e.g., Google Data Studio) for real-time campaign analytics. Automate Segmentation**: Add logic to segment contacts by industry or interest for targeted emails. Requirements to Run This Workflow Google Sheets Account**: For storing and managing contact data and responses. Gmail Account**: For sending emails and checking replies (requires IMAP enabled). n8n Instance**: With Google Sheets and Gmail connectors configured. Cron Service**: For scheduling the daily trigger. Internet Connection**: To access Google Sheets and Gmail APIs. API Credentials**: Gmail OAuth2 and Google Sheets API credentials set up in n8n. Notes Ensure the Google Sheet is shared with the n8n service account or has appropriate permissions. Test the workflow with a small contact list to verify email delivery and response logging. Adjust the stage logic in the "Determine Follow-Up Stage" node to match your campaign structure.
by AI/ML API | D1m7asis
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🌅 Daily AI Inspiration (n8n + AI/ML API + Telegram) This n8n workflow sends a short, original AI‑generated quote and a matching cinematic image to your Telegram chat every morning. It auto‑captures your chat ID from the first message you send to the bot, then runs on a daily schedule. 🚀 Key Features Zero‑Friction Delivery — Just send any message once; the chat ID is saved for daily drops. AI Quote Writer — GPT‑4o crafts concise, uplifting quotes (no author, no quotes). Cinematic Visuals — flux-pro turns each quote into a mood‑rich illustration. Hands‑Off Scheduling — Runs at a set time every day via Schedule Trigger. Telegram Ready — Sends the image + caption directly to your chat. 🛠 Setup Guide Create AI/ML API Credentials Get your API key in AI/ML API. In n8n → Credentials, add AI/ML API (Bearer token, Base URL https://api.aimlapi.com/v1). Create Telegram Credentials In Telegram, open @BotFather → /newbot → save the bot token. In n8n → Credentials → Telegram API, paste the token. Capture Chat ID Start the workflow, message your bot once (Telegram Trigger will store the chat ID automatically). Schedule & Test Set your preferred time in Schedule Trigger (e.g., 07:30). Execute once to confirm delivery, then enable the workflow. 💡 How It Works Trigger — Runs daily via Schedule Trigger (or manually after first chat message to capture chat ID). Quote Generation — AI/ML API (GPT‑4o) produces a short, original, uplifting line. Image Creation — AI/ML API (flux-pro) renders a cinematic image inspired by the quote. Telegram Delivery — Sends the image to your chat with the quote as the caption (🌅 prefix). Optional: tweak image size (1024×1024 by default), add logging (Google Sheets), or extend with moderation, model switching, or multi‑chat routing.
by CryptooChai
This workflow fetches the latest trending cryptocurrency searches from CoinGecko and automatically sends them to your Telegram group/channel. ✅ No account or API key required ✅ Uses CoinGecko’s free public API ✅ Sends formatted daily updates to Telegram ✅ Easy to customize schedule with a Cron node Perfect for community managers, traders, or anyone who wants to keep their Telegram group updated with the hottest crypto trends. How it works Manual Trigger (for testing) & Schedule Trigger (runs automatically at set times) Uses CoinGecko API https://api.coingecko.com/api/v3/search/trending Extracts coin name, symbol, price (if available), and market cap rank Formats into a readable Telegram message & sends the message to your configured group/channel How to use Import the workflow: Download the JSON file and import it into your n8n instance. Connect your Telegram account: Add Telegram credentials in n8n using your Bot Token. Replace the placeholder Telegram Chat ID (chatId) with your group/channel ID. Adjust schedule (optional): By default, the workflow runs at 8:30 AM and 8:30 PM IST. You can change this in the Schedule Trigger node. Activate the workflow: Once configured, activate it, and your Telegram group will start receiving daily trending coin updates. Requirements An n8n instance (self-hosted or cloud) A Telegram Bot Token (create via BotFather) Telegram Group or Channel ID where messages should be sent