Workflow Templates

Lead Scoring Pipeline with Telegram and Box This workflow ingests incoming lead data from a form submission webhook, enriches each lead with external data sources, applies a custom scoring algorithm, and automatically stores the enriched record in Box while notifying your sales team in Telegram. It is designed to give you a real-time, end-to-end lead-qualification pipeline without writing any glue code. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n.cloud) ScrapeGraphAI community node installed (not directly used in this template but required by marketplace listing rules) Telegram Bot created via BotFather Box account (Developer App or User OAuth2) Publicly accessible URL (for the Webhook trigger) Optional: Enrichment API account (e.g., Clearbit, PDL) for richer scoring data Required Credentials | Credential | Scope | Purpose | |------------|-------|---------| | Telegram Bot Token | Bot | Send scored-lead alerts | | Box OAuth2 Credentials | App Level | Upload enriched lead JSON/CSV | | (Optional) Enrichment API Key | REST | Append firmographic & technographic data | Environment Variables (Recommended) | Variable | Example | Description | |---------|----------|-------------| | LEAD_SCORE_THRESHOLD | 75 | Minimum score that triggers a Telegram alert | | BOX_FOLDER_ID | 123456789 | Destination folder for lead files | How it works This workflow listens for new form submissions, enriches each contact with external data, calculates a lead score based on configurable criteria, and routes the lead through one of two branches: high-value leads trigger an instant Telegram alert and are archived to Box, while low-value leads are archived only. Errors are captured by an Error Trigger for post-mortem analysis. Key Steps: Webhook Trigger**: Receives raw form data (name, email, company, etc.). Set node – Normalization**: Renames fields and initializes default values. HTTP Request – Enrichment**: Calls an external enrichment API to augment data. Merge node**: Combines original and enriched data into a single object. Code node – Scoring**: Runs JavaScript to calculate a numeric lead score. If node – Qualification Gate**: Checks if score ≥ LEAD_SCORE_THRESHOLD. Telegram node**: Sends alert message to your sales channel for high-scoring leads. Box node**: Uploads the enriched JSON (or CSV) file into a specified folder. Error Trigger**: Captures any unhandled errors and notifies ops (optional). Sticky Notes**: Explain scoring logic and credential placement (documentation aids). Set up steps Setup Time: 15-25 minutes Create Telegram Bot & Get Token Talk to BotFather → /newbot → copy the provided token. Create a Box Developer App Enable OAuth2 → add https://api.n8n.cloud/oauth2-credential/callback (or your own) as redirect URI. Install Required Community Nodes From n8n editor → “Install” → search “ScrapeGraphAI” → install. Import the Workflow JSON Click “Import” → paste the workflow file → save. Configure the Webhook URL in Your Form Tool Copy the production URL generated by the Webhook node → add it as form action. Set Environment Variables In n8n (Settings → Environment) add LEAD_SCORE_THRESHOLD and BOX_FOLDER_ID. Fill in All Credentials Telegram: paste bot token. Box: complete OAuth2 flow. Enrichment API: paste key in the HTTP Request node headers. Activate Workflow Toggle “Activate”. Submit a test form to verify Telegram/Box outputs. Node Descriptions Core Workflow Nodes: Webhook** – Entry point; captures incoming JSON payload from the form. Set (Normalize Fields)** – Maps raw keys to standardized ones (firstName, email, etc.). HTTP Request (Enrichment)** – Queries external service for firmographic data. Merge (Combine Data)** – Merges the two JSON objects (form + enrichment). Code (Scoring)** – Calculates lead score using weighted attributes. If (Score Check)** – Branches flow based on the score threshold. Telegram** – Sends high-score alerts to a specified chat ID. Box** – Saves a JSON/CSV file of the enriched lead to cloud storage. Error Trigger** – Executes if any preceding node fails. Sticky Notes** – Inline documentation for quick reference. Data Flow: Webhook → Set → HTTP Request → Merge → Code → If If (true) → Telegram If (always) → Box Error (from any node) → Error Trigger Customization Examples Change Scoring Logic // Inside the Code node const { jobTitle, companySize, technologies } = items[0].json; let score = 0; if (jobTitle.match(/(CTO|CEO|Founder)/i)) score += 50; if (companySize > 500) score += 20; if (technologies.includes('AWS')) score += 10; // Bonus: subtract points if free email domain if (items[0].json.email.endsWith('@gmail.com')) score -= 30; return [{ json: { ...items[0].json, score } }]; Use a Different Storage Provider (e.g., Google Drive) // Replace Box node with Google Drive node { "node": "Google Drive", "operation": "upload", "fileName": "lead_{{$json.email}}.json", "folderId": "1A2B3C..." } Data Output Format The workflow outputs structured JSON data: { "firstName": "Ada", "lastName": "Lovelace", "email": "ada@example.com", "company": "Analytical Engines Inc.", "companySize": 250, "jobTitle": "CTO", "technologies": ["AWS", "Docker", "Node.js"], "score": 82, "qualified": true, "timestamp": "2024-04-07T12:34:56.000Z" } Troubleshooting Common Issues Telegram messages not received – Ensure the bot is added to the group and chat_id/token are correct. Box upload fails with 403 – Check folder permissions; verify OAuth2 tokens have not expired. Webhook shows 404 – The workflow is not activated or the URL was copied in “Test” mode instead of “Production”. Performance Tips Batch multiple form submissions using the “SplitInBatches” node to reduce API-call overhead. Cache enrichment responses (Redis, n8n Memory) to avoid repeated lookups for the same domain. Pro Tips: Add an n8n “Wait” node between enrichment calls to respect rate limits. Use Static Data to store domain-level enrichment results for even faster runs. Tag Telegram alerts with emojis based on score (🔥 Hot Lead for >90). This is a community-contributed n8n workflow template provided “as-is.” Always test thoroughly in a non-production environment before deploying to live systems.

Automated Solana News Tracker with AI-Powered Weekly Summaries Never miss important Solana ecosystem updates again. This production-ready workflow automatically scrapes crypto news daily, intelligently filters duplicates, stores everything in Google Sheets, and generates AI-powered weekly summaries every Monday—completely hands-free. 🎯 What It Does: This intelligent automation runs on autopilot to keep you informed about Solana developments without manual monitoring. Every day at 8 AM PT, it fetches the latest Solana news from CryptoPanic, checks for duplicates against your existing database, and stores only new articles in Google Sheets. On Mondays, it takes an extra step: reading all accumulated articles from the past week and using GPT-4.1-mini to generate a concise, factual summary of key developments and investor takeaways. Daily News Collection**: Automatically fetches latest Solana articles from CryptoPanic API Smart Duplicate Detection**: Compares incoming articles against existing database to prevent redundancy Data Validation**: Filters out incomplete articles to ensure data quality Organized Storage**: Maintains clean Google Sheets database with timestamps and descriptions Weekly AI Summaries**: Analyzes accumulated news every Monday and generates 2-3 sentence insights Historical Archive**: Builds searchable database of both raw articles and weekly summaries 💼 Perfect For: Crypto traders tracking market-moving news • SOL investors monitoring ecosystem growth • Blockchain researchers building historical datasets • Content creators sourcing newsletter material • Portfolio managers needing daily briefings • Anyone wanting Solana updates without information overload 🔧 How It Works: The workflow operates in two distinct modes based on the day of the week. During the daily collection phase (Tuesday-Sunday), it runs at 8 AM PT, fetches the latest Solana news from CryptoPanic, formats the data to extract titles, descriptions, and timestamps, checks each article against your Google Sheets database to identify duplicates, filters out any articles that already exist or have missing data, and appends only valid new articles to your "Raw Data" sheet. On Mondays, the workflow performs all daily tasks plus an additional summarization step. After storing new articles, it retrieves all accumulated news from the "Raw Data" sheet, aggregates all article descriptions into a single text block, sends this consolidated information to GPT-4.1-mini with instructions to create a factual, spartan-toned summary highlighting key investor takeaways, and saves the AI-generated summary with a timestamp to the "Weekly Summary" sheet for historical reference. ✨ Key Features: Schedule-based execution**: Runs automatically at 8 AM PT every day without manual intervention Intelligent deduplication**: Title-based matching prevents storing the same article multiple times Data quality control**: Validates required fields before storage to maintain clean dataset Dual-sheet architecture**: Separate sheets for raw articles and weekly summaries for easy access Cost-effective AI**: Uses GPT-4.1-mini (~$0.001 per summary) for extremely low operating costs Scalable storage**: Google Sheets handles thousands of articles with free tier Customizable cryptocurrency**: Easily adapt to track Bitcoin, Ethereum, or any supported coin Flexible scheduling**: Modify trigger time and summary frequency to match your needs 📋 Requirements: CryptoPanic account with free API key (register at cryptopanic.com) Google Sheets with two sheets: "Raw Data" (columns: date, title, descripton, summary) and "Weekly Summary" (columns: Date, Summary) OpenAI API key for GPT-4.1-mini access (~$0.05/month cost) n8n Cloud or self-hosted instance with schedule trigger enabled ⚡ Quick Setup: Register for a free CryptoPanic API key and replace [your token] in the "Get Solana News" HTTP Request node URL. Create a new Google Spreadsheet with two sheets: one named "Raw Data" with columns for date, title, descripton (note the typo in template), and summary; another named "Weekly Summary" with columns for Date and Summary. Connect your Google Sheets OAuth2 credential to all Google Sheets nodes in the workflow. Add your OpenAI API credential to the "Summarize News" node. Test the workflow manually to ensure it fetches news and stores it correctly. Activate the workflow to enable daily automatic execution. 🚨 Please note, that you're not able to get news in real-time with a FREE CryptoPanic API. Consider their pro plan or another platform for real-time news scraping You'll get new that's up to date as of yesterday. 🎁 What You Get: Complete end-to-end automation with concise sticky note documentation at each workflow stage, pre-configured duplicate detection logic, AI summarization with investor-focused prompts optimized for factual analysis without hype, dual-sheet Google Sheets structure for raw data and summaries, flexible schedule trigger you can adjust to any timezone, example data in pinned format showing expected API responses, customization guides for different cryptocurrencies and summary frequencies, and troubleshooting checklist for common setup issues. 💰 Expected Costs & Performance: CryptoPanic API is free with reasonable rate limits for personal use. OpenAI GPT-4.1-mini costs approximately $0.001 per summary, totaling about $0.05 per month for weekly summaries. The workflow typically processes 20-50 articles daily and generates one summary weekly from 140-350 accumulated articles. Daily executions complete in 5-10 seconds, while Monday runs with AI summarization take 15-20 seconds. Google Sheets provides free storage for up to 5 million cells, easily handling years of news data. 🔄 Customization Ideas: Track different cryptocurrencies by changing the currencies parameter (btc, eth, ada, doge, etc.). Adjust the schedule trigger to run at different times matching your timezone. Modify the Monday check condition to generate summaries on different days or multiple times per week. Connect Slack, Discord, or Email nodes to receive instant notifications when summaries are generated. Edit the AI prompt to change tone, detail level, or focus on specific aspects like price action, development updates, or partnerships. Add conditional logic to send alerts only when certain keywords appear in news (like "hack," "partnership," or "upgrade").

👔 Recruitment Office WhatsApp Automation Automate WhatsApp communication for recruitment agencies with an interactive, structured customer experience. This workflow handles pricing inquiries, request submissions, tracking, complaints, and human escalation while maintaining full session tracking and media support. Good to know Uses WhatsApp Interactive List Messages for user selection and navigation. Includes session-state logic and memory across messages. Includes a 5-minute cooldown to avoid spam and repeated triggers. Supports logging for all interaction types including media files. Includes both a global bot shutdown switch and per-user override. How it works A customer sends a message to the official WhatsApp number. The workflow replies with an interactive menu containing 8 service options: 💰 Pricing by nationality (8 supported countries) 📝 New recruitment request submission 🔍 Tracking existing applications via Google Sheets lookup 🔁 Worker transfer link distribution 🌍 Translation service information 📄 Required documents and instructions ⚠️ Complaint submission and routing 👤 Request a human agent The workflow retrieves or stores data based on the selection using Google Sheets and Data Tables. If the customer requests human help or the logic detects uncertainty, the workflow: Pauses automation for that user Notifies a designated staff member All interactions are logged including files, text, timestamps, and selections. Features 📋 Structured WhatsApp service menu 📄 CRM-style recruitment request logging ✨ Pricing logic with nationality mapping 🔍 Lookup-based status tracking 📎 Support for media uploads (PDF, images, audio, documents) 🧠 Session tracking with persistent user state 🤝 Human escalation workflow with internal notifications 🛑 Anti-spam and cooldown control 🎚 Bot master switch (global + per-user) Technology stack | Component | Usage | |----------|-------| | n8n | Automation engine | | WhatsApp Business API | Messaging and interactive UX | | Google Sheets | CRM and logs | | Data Tables | State management | | JavaScript | Custom logic and routing | Requirements WhatsApp Business API account with active credentials n8n Cloud or self-hosted instance Google Sheets for CRM storage Data Tables enabled for persistent session tracking How to use The workflow uses a Webhook trigger compatible with common WhatsApp API providers. Modify menu content, pricing, optional steps, and escalation flows as needed. Link your Google Sheets and replace test sheet IDs with production values. Configure human escalation to notify team members or departments. Customising this workflow Replace Google Sheets with Airtable, HubSpot, or SQL storage. Add expiration and reminder messages for missing documents. Add AI-powered response logic for common questions. Enable multi-country support (Saudi/UAE/Jordan/Qatar/Kuwait/etc.) Connect to dashboards for reporting and staff performance analytics.

🧾An intelligent automation system that turns WhatsApp into your personal receipt manager — integrating Meta WhatsApp Cloud API, Google Drive, Google Sheets, and OpenAI GPT-4o-mini via n8n. 🎥 Demo: Watch the Loom walkthrough ⚙️ What It Does The AI-Powered WhatsApp Receipt Bot automates the complete invoice handling process through a conversational interface. Workflow Summary: User sends a receipt image via WhatsApp. The bot automatically downloads the media using the WhatsApp Cloud API. The image is uploaded to a Google Drive “Invoices” folder. The file is shared publicly, generating a shareable URL. The receipt is analyzed using OpenAI GPT-4o-mini to extract structured data: Store name Items purchased Payment method Total amount The extracted details are appended to a Google Sheet for record-keeping. The bot sends a human-readable summary back to WhatsApp with emojis and the invoice link. Output Example: 🏬 Store: Big Bazaar 📝 Items: Rice, Detergent, Snacks 💳 Payment: Card 💰 Total: ₹1520.75 🔗 Link: https://drive.google.com/file/d/1abcXYZ/view This system eliminates manual expense tracking, improves accuracy through OCR, and provides a seamless way to manage receipts in real time. 💡 Use Cases | Scenario | Description | | ------------------------------------- | --------------------------------------------------------------------------------------------------------------------- | | Personal Expense Management | Automatically store and categorize receipts from daily purchases. | | Business Accounting | Collect employee expense receipts through WhatsApp and centralize them in Google Sheets. | | Freelancer or Consultant Tracking | Keep a digital record of client reimbursements or software purchase receipts. | | Family Budgeting | Family members send receipts to one shared WhatsApp number, all data gets logged centrally. | | E-commerce / Delivery Teams | Drivers or delivery agents send invoices from the field to WhatsApp; data automatically goes to the accounting sheet. | 🔧 Setup 1. Accounts and Tools Needed | Tool | Purpose | Link | | -------------------------- | ------------------------------------------- | -------------------------------------------------------------------------------------------- | | Meta Developer Account | To access WhatsApp Business Cloud API | https://developers.facebook.com/apps | | Google Cloud Account | For enabling Drive and Sheets APIs | https://console.cloud.google.com | | n8n Instance | Workflow automation engine (local or cloud) | https://app.n8n.cloud | | OpenAI API Key | For GPT-4o-mini model OCR + reasoning | https://platform.openai.com/account/api-keys | 2. Meta Developer Setup (WhatsApp Cloud API) Go to Meta Developer Dashboard → My Apps → Create App → Business type. Add WhatsApp product under your app. Retrieve the following from WhatsApp > Configuration: Permanent Access Token Phone Number ID WhatsApp Business Account ID Add these credentials in n8n → Credentials → WhatsApp API. Use the same credentials for WhatsApp Trigger and Send Message nodes. Verify webhook in Meta with your n8n webhook URL. Important: In your HTTP Node, set the header as: Authorization: Bearer <access_token> Replace <access_token> with your WhatsApp Cloud API permanent token. Without this, the workflow will fail to send or receive WhatsApp messages properly. 3. Google Drive Setup Create a folder named Invoices on your Google Drive. Copy the Folder ID (found in the Drive URL). In Google Cloud Console → APIs & Services → Enable APIs: Enable Google Drive API Enable Google Sheets API Go to Credentials → Create Credentials → OAuth 2.0 Client ID. Download the credentials.json file. Upload this to n8n → Credentials → Google Drive OAuth2 API. Authorize the connection on first workflow run. 4. Google Sheets Setup Create a new Google Sheet titled Invoices. Add the following headers in Row 1: store name | discription | image_url | payment | total Copy the Sheet ID (from the URL). Add the ID under the Google Sheets Append node in n8n. Map each field to its corresponding value extracted from the OCR result. 5. OpenAI Setup Generate an API key from https://platform.openai.com/account/api-keys. Add it to n8n → Credentials → OpenAI API. Use model gpt-4o-mini in the “Analyze Image” node. Can upgrade to gpt-4o for better OCR accuracy if account supports it. 6. n8n Workflow Setup Import the provided n8n workflow JSON. Configure credentials for: WhatsApp API Google Drive OAuth2 Google Sheets OAuth2 OpenAI API Activate workflow and set webhook in Meta Developer console. Send a test receipt image to your WhatsApp Business number. The bot will automatically: Download → Upload → Extract → Log → Summarize → Reply 📊 Example Google Sheet Record | store name | discription | image_url | payment | total | | ---------- | ----------------------- | -------------------------------------------------------------------------------------------- | ------- | ------- | | Big Bazaar | Rice, Detergent, Snacks | https://drive.google.com/file/d/1abcXYZ/view | Card | 1520.75 | 🧠 Result A fully automated AI pipeline that transforms WhatsApp into a smart expense-tracking interface — integrating vision, automation, and natural language processing for zero-manual financial documentation. Support & Contact: If you face any issues during setup or execution, contact: 📧 Email: atharvapj5@gmail.com 🔗 LinkedIn: Atharva Jaiswal

ETL Monitoring & Alert Automation: Jira & Slack Integration This workflow automatically processes ETL errors, extracts important details, generates a preview, creates a log URL, classifies the issue using AI and saves the processed data into Google Sheets. If the issue is important or needs attention, it also creates a Jira ticket automatically. The workflow reduces manual debugging effort, improves visibility and ensures high-severity issues are escalated instantly without human intervention. Quick Start – Implementation Steps Connect your webhook or ETL platform to trigger the workflow. Add your OpenAI, Google Sheets and Jira credentials. Enable the workflow. Send a sample error to verify Sheets logging and Jira ticket creation. Deploy and let the workflow monitor ETL pipelines automatically. What It Does This workflow handles ETL errors end-to-end by: Extracting key information from ETL error logs. Creating a short preview for quick understanding. Generating a URL to open the full context log. Asking AI to identify root cause and severity. Parsing the AI output into clean fields. Saving the processed error to Google Sheets. Creating a Jira ticket for medium/high-severity issues. This creates a complete automated system for error tracking, analysis and escalation. Who’s It For DevOps & engineering teams monitoring data pipelines. ETL developers who want automated error reporting. QA teams verifying daily pipeline jobs. Companies using Jira for issue tracking. Teams needing visibility into ETL failures without manual log inspection. Requirements to Use This Workflow n8n account or self-hosted instance. ETL platform capable of sending error payloads (via webhook). OpenAI API Key. Google Sheets credentials. Jira Cloud API credentials. Optional: log storage URL (S3, Supabase, server logs). How It Works & Setup Steps 1. Get ETL Error (Webhook Trigger) Receives ETL error payload and starts the workflow. 2. Prepare ETL Logs (Code Node) Extracts important fields and makes a clean version of the error.Generates a direct link to open the full ETL log. 3. AI Severity Classification (OpenAI / AI Agent) AI analyzes the issue, identifies cause and assigns severity. 4. Parse AI Output (Code Node) Formats AI results into clean fields: severity, cause, summary, recommended action. 5. Prepare Data for Logging (Set / Edit Fields) Combines all extracted info into one final structured record. 6. Save ETL Logs (Google Sheets Node) Logs each processed ETL error in a spreadsheet for tracking. 7. Create Jira Ticket (Jira Node) Automatically creates a Jira issue when severity is Medium, High or Critical. 8. ETL Failure Alert (Slack Node) Sends a Slack message to notify the team about the issue. 9. ETL Failure Notify (Gmail Node) Sends an email with full error details to the team. How to Customize Nodes ETL Log Extractor Add/remove fields based on your ETL log structure. AI Classification Modify the OpenAI prompt for custom severity levels or deep-dive analysis. Google Sheets Logging Adjust columns for environment, job name or log ID. Jira Fields Customize issue type, labels, priority and assignees. Add-Ons (Extend the Workflow) Send Slack or Teams alerts for high severity issues Store full logs in cloud storage (S3, Supabase, GCS) Add daily/weekly error summary reports Connect monitoring tools like Datadog or Grafana Trigger automated remediation workflows Use Case Examples Logging all ETL failures to Google Sheets Auto-creating Jira tickets with AI-driven severity Summarizing large logs with AI for quick analysis Centralized monitoring of multiple ETL pipelines Reducing manual debugging effort across teams Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | Sheets not updating | Wrong Sheet ID or missing permission | Reconnect and reselect the sheet | | Jira ticket fails | Missing required fields or invalid project key | Update Jira mapping | | AI output empty | Invalid OpenAI key or exceeded usage | Check API key or usage limits | | Severity always “low” | Prompt too broad | Adjust AI prompt with stronger rules | | Log preview empty | Incorrect error field mapping | Verify the structure of the ETL error JSON | Need Help? For assistance setting up this workflow, customizing nodes or adding additional features, feel free to contact our n8n developers at WeblineIndia. We can help configure, scale or build similar automation workflows tailored to your ETL and business requirements.

🚀 How It Works Turn your WhatsApp chats into an AI-powered meeting scheduler with Google Gemini, Google Calendar, and Google Sheets. This workflow understands natural language like “Book a meeting with Ali at 3 PM tomorrow”, checks your contacts, avoids overlaps, and updates your calendar automatically all from WhatsApp. It’s a complete AI scheduling system built for founders, teams, and service providers who manage clients over chat. 🔁 Workflow Overview WhatsApp Trigger** → Captures incoming messages in real time Intent Agent (Gemini)** → Detects scheduling intent (create / edit / cancel) Google Sheets** → Finds contact names, emails, and tags Get Events** → Checks existing meetings to prevent conflicts Correction Agent + Intent Check** → Confirms details with AI Calendar Agent (Gemini)** → Executes the calendar action intelligently Create / Update / Delete Event** → Syncs instantly to Google Calendar Response Node** → Sends WhatsApp and email confirmations ⚙️ Quick Setup (⏱ ~15 min) Connect WhatsApp Cloud API – link your WhatsApp Business account Authenticate Google Calendar & Sheets – use Sheets for contacts (Name | Email | Type) Add Google Gemini API Key – used by Intent, Correction, and Calendar agents Customize Prompts – adjust tone and language in the Gemini nodes Test Your Flow – e.g., message “Schedule meeting with Ali at 10 AM Friday” to verify calendar and confirmation replies 💡 All setup details are also documented inside the workflow sticky notes. 🧩 Integrations WhatsApp Cloud API Google Calendar API Google Sheets API Google Gemini (LLM) 💡 Benefits ✅ Automates scheduling directly from WhatsApp ✅ Understands natural language requests ✅ Prevents double-bookings automatically ✅ Sends instant confirmations ✅ Saves hours of manual coordination 👥 Ideal For Entrepreneurs & consultants managing clients on WhatsApp Sales or support teams booking demos and meetings Virtual assistants and AI service providers Anyone who wants a 24/7 AI calendar manager

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

Overview Use your voice or text to command a Telegram-based AI agent that scrapes leads or generates detailed research reports—instantly. This workflow turns your Telegram bot into a full-blown outbound machine. Just tell it what type of leads you need, and it’ll use Apollo to find and save them into a spreadsheet. Or drop in a LinkedIn profile, and it’ll generate a personalized research dossier with info like job title, company summary, industry insights, and more. It handles voice messages too—just speak your request and get the results sent back like magic. Who’s it for Cold emailers and growth marketers Solo founders running outbound SDRs doing daily prospecting Agencies building high-quality lead lists or custom research for clients How it works Triggered by a message (text or voice) in Telegram If it’s voice, it transcribes using OpenAI Whisper Uses an AI agent to interpret intent: scrape leads or research a person For lead scraping: Gathers criteria (e.g., location, job title) via Telegram Calls the Apollo API to return fresh leads Saves the leads to Google Sheets For research reports: Takes a LinkedIn profile link Uses AI and lead data tools to create a 1-page professional research report Sends it back to the user via email Example outputs Lead scraping**: Populates a spreadsheet with names, roles, LinkedIn links, company info, emails, and more Research report**: A formatted PDF-style brief with summary of the person, company, and key facts How to set up Connect your Telegram bot to n8n Add your OpenAI credentials (for Whisper + Chat agent) Plug in your Apollo API key or scraping tool Replace the example spreadsheet with your own Customize the prompts for tone or data depth (Optional) Add PDF generation or CRM sync Requirements Telegram Bot Token OpenAI API Key Apollo (or other scraping API) credentials LinkedIn URLs for research functionality How to customize Replace Apollo with Clay, People Data Labs, or another scraping tool Add a CRM push step (e.g. Airtable, HubSpot, Notion) Add scheduling to auto-scrape daily Reformat the research report as a downloadable PDF Change the agent’s tone or role (e.g. “Outreach Assistant,” “Investor Scout,” etc.)

This n8n workflow automatically captures LinkedIn leads from multiple sources (new connections, post engagements), enriches the data with AI-powered scoring, eliminates duplicates, syncs to Google Sheets and your CRM (HubSpot or Salesforce), and sends instant notifications to your sales team for high-quality leads. No more manual copy-pasting or lost opportunities—every LinkedIn interaction becomes a tracked, qualified lead ready for follow-up. Benefits Zero Manual Data Entry:** Eliminates tedious copy-paste work—saves 10+ hours per week for active LinkedIn users Smart Lead Scoring:** AI calculates quality scores (0-100) and assigns temperature labels (Hot/Warm/Cold) based on engagement patterns Multi-Source Capture:** Monitors new connections, post comments, likes, and shares to catch leads from all touchpoints Duplicate Prevention:** Tracks leads for 90 days to avoid database clutter and redundant outreach Instant Sales Alerts:** Notifies team via Slack/Email within seconds for Hot & Warm leads, enabling rapid follow-up CRM Integration:** Syncs directly to HubSpot or Salesforce with custom fields for lead temperature and quality metrics Built-in Analytics:** Tracks cumulative statistics (total leads, temperature distribution) for performance monitoring Always-On Automation:** Runs every 15 minutes 24/7, capturing leads even when you're sleeping or in meetings Useful for Which Industry B2B SaaS & Tech:** Sales teams prospecting decision-makers and capturing demo requests from LinkedIn content Consulting & Professional Services:** Agencies tracking client inquiries and partnership opportunities from thought leadership posts Recruiting & HR:** Talent acquisition teams building candidate pipelines from LinkedIn engagement Real Estate & Financial Services:** Agents capturing high-intent leads from market updates and educational content Marketing Agencies:** Business development teams converting social engagement into qualified opportunities E-Learning & Coaching:** Course creators and consultants tracking interested prospects from free content Manufacturing & B2B Sales:** Enterprise sales teams monitoring buying committee members engaging with product content How it works Monitor LinkedIn - Checks every 15 minutes for new connections and post engagements Extract data - Pulls profile information, company, position from multiple sources Score leads - Calculates quality score (0-100) and assigns temperature (Hot/Warm/Cold) Prevent duplicates - Tracks leads for 90 days to avoid duplicate entries Sync to platforms - Saves to Google Sheets and your CRM (HubSpot or Salesforce) Smart notifications - Alerts sales team via Slack/Email for Hot and Warm leads only Setup steps Connect LinkedIn - Add OAuth2 credentials to both LinkedIn nodes Setup Google Sheets - Create spreadsheet with these columns: leadId, fullName, firstName, lastName, email, phone, company, position, headline, location, profileUrl, leadSource, leadTemperature, qualityScore, engagementType, commentText, dateAdded, status, assignedTo, notes, lastUpdated Choose CRM - Enable either HubSpot OR Salesforce nodes (disable the other) Configure alerts - Add Slack webhook URL and/or email settings Test workflow - Run manually first to verify all connections Activate - Turn on for automatic lead capture Key features Smart scoring**: Quality score based on engagement level and profile completeness Temperature labels**: Hot (70+), Warm (50-69), Cold (<50) for prioritization No duplicates**: 90-day tracking prevents duplicate entries Multi-CRM support**: Works with HubSpot or Salesforce Analytics built-in**: Tracks total leads and temperature distribution

How it works: Get multi social platform data for loyalty program customers with their email and send personalized creator, partner and ambassador outreach. Step by step workflow to enrich loyalty program emails with multi social (Instagram, Tiktok, Youtube, Twitter, Onlyfans, Twitch and more) profiles, analytics and metrics using the influencers.club API and adding them to an email workflow via SendGrid. Set up: Salesforce (can be swapped for any CRM or loyalty programme software) Influencers.club API Sendgrid (can be swapped for any email marketing sending service like MailChimp, Drip, etc)

The Video Grok Agent is an AI-powered video generation and editing workflow that uses Grok 4.1 Fast (via OpenRouter) and Grok Imagine Video to create and modify videos through natural language. This workflow enables seamless AI-driven video creation and editing through a conversational interface, with built-in validation, async processing, and secure credential management. Key Advantages 1. ✅ Unified Video Creation Pipeline A single workflow supports text-to-video, image-to-video, and video editing, reducing complexity and avoiding duplicated logic across multiple automations. 2. ✅ AI-Guided User Interaction The conversational agent ensures: the correct tool is selected, all mandatory parameters are provided, errors due to missing inputs are minimized. This makes the workflow usable even by non-technical users. 3. ✅ Asynchronous & Scalable Execution The workflow is designed around queued, non-blocking requests: wait nodes + status polling no execution timeouts scalable for multiple concurrent video jobs 4. ✅ Automatic Media Handling Uploaded images are: detected automatically, uploaded to external storage, converted into usable URLs without manual steps. This enables smooth image-to-video generation directly from chat uploads. 5. ✅ Clear Separation of Responsibilities Each step is modular: orchestration (agent), decision routing (switch), media processing (Fal.run APIs), status monitoring (HTTP + wait loops). This makes the workflow easy to maintain, extend, or debug. 6. ✅ Strong Guardrails & Validation The agent enforces: correct tool usage (e.g. video-to-video only for editing), duration limits (1–15 seconds), mandatory URLs before execution. This prevents incorrect API calls and wasted compute. 7. ✅ Extensible Architecture New tools (e.g. different models, resolutions, aspect ratios, or providers) can be added without redesigning the whole system—just plug them into the existing agent + switch logic. How it works User Interaction The workflow starts with a chat trigger (When chat message received), where users can upload images and submit text prompts. If an image is uploaded, it is automatically stored via FTP (BunnyCDN) and its URL is passed to the AI agent. AI Agent Orchestration The Grok Imagine Video Agent processes the user’s request and determines which action to perform: Text-to-Video: Create a new video from a text prompt. See test result Image-to-Video: Animate an existing image. See test result Video-to-Video: Edit an existing video. See test result The agent follows strict rules to ensure all required parameters (e.g., duration, URLs, prompts) are collected before proceeding. Video Processing via Fal.run API Depending on the selected tool, the workflow calls the corresponding Fal.run endpoint: text-to-video image-to-video edit-video Each request returns a request_id used to poll for completion. Asynchronous Processing & Polling After submission, the workflow enters a polling loop: Waits 10–30 seconds. Checks the request status via Fal.run’s status endpoint. Once the status is COMPLETED, it retrieves the final video URL. Result Delivery The final video URL is returned to the user via the chat interface. The agent does not proceed further once the video is ready. Set Up Steps To deploy and use this workflow in n8n: Credentials Configuration Set up the following credentials in n8n: OpenRouter API (for Grok 4.1 Fast) Fal.run API (HTTP Header Auth) FTP/BunnyCDN (for image uploads) Workflow Activation Ensure all nodes are correctly connected as per the connections mapping. Activate the workflow via the Execute Workflow Trigger (Run Text-to-Video1). Chat Interface Setup The workflow is designed to be triggered via a chat message. Configure the When chat message received node to connect to your frontend or chat platform. Parameter Validation The AI agent includes validation rules to ensure: Duration is between 1–15 seconds. Required URLs (image/video) are provided where needed. The correct tool is invoked based on user intent. Testing & Monitoring Test each tool separately (text, image, video) to ensure Fal.run API responses are handled correctly. Monitor the polling loops to avoid timeouts and ensure video URLs are retrieved successfully. 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

Generate Sora videos, stitch clips, and post to Twitter Generate creative ASMR cutting video concepts with GPT-5.1, create high-quality video clips using Sora v2, stitch them together with Cloudinary, and automatically post to Twitter/X—transforming ideas into viral content without manual video editing. How it works Step 1: Generate Video Concepts Schedule Trigger activates the workflow automatically GPT-5.1 AI agent generates 3 unique ASMR cutting scene prompts with unusual objects Creates structured video prompts optimized for Sora v2 (frontal camera angle, cutting actions) Generates Twitter-ready captions with relevant hashtags Saves all concepts and scripts to Google Sheets for tracking Step 2: Create Video Clips with Sora v2 Generates 3 separate Sora v2 video clips in parallel (8-12 seconds each) Each clip uses unique prompts from GPT-5.1 output Videos render at 720x1280 resolution (vertical format for social media) System waits 30 seconds for rendering to complete Step 3: Monitor & Download Videos Loops through all 3 video generation requests Checks Sora API status every 30 seconds until rendering completes Automatically skips failed renders (continues workflow with successful videos) Downloads completed videos from Sora API Uploads each clip to Cloudinary for storage and processing Step 4: Stitch Videos Together Collects all uploaded Cloudinary video IDs Builds Cloudinary transformation URL to stitch 3 clips into one seamless video Applies Twitter-compatible encoding (H.264 baseline, AAC audio, MP4 format) Downloads the final stitched video Step 5: Upload to Twitter/X Prepares video file data and calculates total file size Uses Twitter's chunked upload API (INIT → APPEND → FINALIZE) Waits for Twitter's video processing to complete Checks processing status until video is ready Posts tweet with AI-generated caption and attached video Updates Google Sheets status to "Posted" What you'll get AI-Generated Concepts**: Creative ASMR cutting ideas with unusual objects (glass avocados, lava rocks, rainbow soap) Professional Video Clips**: Three 8-12 second Sora v2 videos per concept with 720x1280 resolution Seamless Stitching**: Single combined video optimized for Twitter/X specifications Engaging Captions**: GPT-5.1 generated tweets with hashtags designed for virality Automated Posting**: Direct upload to Twitter/X without manual intervention Cloud Backup**: All videos stored in Cloudinary with metadata Progress Tracking**: Google Sheets integration shows workflow status (In Progress → Posted) Error Handling**: Failed Sora renders are automatically skipped Why use this Save 4+ hours per video**: Eliminate scripting, shooting, editing, and posting time Consistent posting schedule**: Set it and forget it with the Schedule Trigger Scale content creation**: Generate multiple video variations in 20-30 minutes Professional quality**: Leverage Sora v2's AI video generation for realistic cutting scenes Optimize for virality**: GPT-5.1 creates concepts and captions designed for engagement Reduce creative burnout**: AI handles ideation, execution, and distribution No video editing skills needed**: Complete automation from concept to post Test multiple concepts**: Generate 3 variations per run to see what resonates Setup instructions Required accounts and credentials: OpenAI API Key (GPT-5.1 and Sora v2 access required) Sign up at https://platform.openai.com Ensure your account has Sora v2 API access enabled Generate API key from API Keys section Note: Sora v2 is currently in limited beta Google Sheets OAuth (for tracking video ideas and status) Free Google account required Create a spreadsheet with columns: Category, Scene 1, Scene 2, Scene 3, Status n8n will request OAuth permissions during setup Cloudinary Account (for video storage and stitching) Sign up at https://cloudinary.com (free tier available) Note your cloud name from the dashboard Create an upload preset named n8n_integration Enable unsigned uploads for the preset Twitter OAuth 1.0a Credentials (for automated posting) Apply for Twitter Developer access at https://developer.twitter.com Create a new app in the Developer Portal Generate: API Key, API Secret, Access Token, Access Token Secret Enable "Read and Write" permissions (not just Read) OAuth 1.0a is required for media uploads (OAuth 2.0 won't work) Configuration steps: Update OpenAI API Key: Add your OpenAI API key to these nodes: "OpenAI Chat Model" credentials "Create Sora Video Scene - 1" (Authorization header) "Create Sora Video Scene - 2" (Authorization header) "Create Sora Video Scene - 3" (Authorization header) "Check Video Status" (Authorization header) "Download Completed Video" (Authorization header) Replace Bearer API KEY with Bearer YOUR_ACTUAL_API_KEY Configure Google Sheets: Open "Save Category and Clip Scripts" and "Update Status" nodes Authenticate with your Google account (OAuth 2.0) Select your spreadsheet and sheet name Ensure columns match: Category, Scene 1, Scene 2, Scene 3, Status The workflow will update Status from "In Progress" to "Posted" Update Cloudinary Settings: In "Upload to Cloudinary" node: Replace {Cloud name here} in the URL with your Cloudinary cloud name Verify upload preset is set to n8n_integration In "Build Stitch URL" node: Open the Code node Replace dph9n4uei on line 1 with your cloud name This builds the video stitching transformation URL Add Twitter OAuth 1.0a Credentials: Configure OAuth 1.0a in these nodes: "Twitter Upload - INIT" "Twitter Upload - APPEND" "Finalize Upload" "Check Twitter Processing Status" "Post a Tweet" Use the same OAuth 1.0a credential for all nodes Ensure your Twitter app has "Read and Write" permissions Adjust Schedule Trigger (optional): Default: Runs on every interval Modify in "Schedule Trigger" node to set specific times Recommended: Once per day or every few hours to avoid rate limits Test the workflow: Click "Execute Workflow" to test manually first Verify GPT-5.1 generates 3 video concepts Check that Sora v2 creates all 3 videos Confirm Cloudinary stitches videos correctly Ensure Twitter post appears with video and caption Important notes: Sora API Rate Limits**: Sora v2 may have rendering quotas. Monitor your usage Video Rendering Time**: Each Sora clip takes 2-5 minutes. Total workflow: 15-25 minutes Failed Videos**: The workflow automatically skips failed renders and continues Twitter Video Limits**: Maximum 512MB per video, MP4 format required Cloudinary Free Tier**: 25 credits/month includes video transformations Cost Estimate**: ~$1-3 per run (Sora API pricing varies) Troubleshooting: "Sora API access required"**: Contact OpenAI to enable Sora v2 API on your account Twitter upload fails**: Verify OAuth 1.0a credentials have "Read and Write" permissions Cloudinary upload fails**: Check cloud name and ensure upload preset exists Videos don't stitch**: Verify all 3 videos uploaded successfully to Cloudinary Google Sheets not updating**: Confirm OAuth permissions and sheet column names match Next steps: Enable the Schedule Trigger to automate daily/weekly posts Monitor Google Sheets to track posted content Adjust GPT-5.1 prompts in "ASMR Cutting Ideas" for different content themes Experiment with different video durations (8 vs 12 seconds) Add error notifications using Email or Slack nodes