Workflow Templates

AI Personal Assistant Telegram Bot Template Description Transform your Telegram into a powerful AI-powered personal assistant that manages your calendar, sends daily schedules, searches the web, and accesses your contacts - all through simple text messages. What This Template Does This workflow creates an intelligent Telegram bot that serves as your personal assistant, capable of: Daily Schedule Management**: Automatically checks your Google Calendar and emails you a formatted daily schedule summary Intelligent Conversations**: Uses OpenAI GPT-4o-mini with conversation memory for natural interactions Web Research**: Searches Wikipedia and the web using SerpAPI for any questions you have Contact Management**: Accesses your Google Sheets contact database to find email addresses and information Email Automation**: Sends emails on your behalf using Gmail integration Calendar Integration**: Reads and manages your Google Calendar events Target Users Busy Professionals** who need quick access to their schedule and want to automate daily planning Small Business Owners** who want an AI assistant for managing contacts and communications Personal Productivity Enthusiasts** who want to streamline their daily workflow Anyone** who prefers text-based interaction over switching between multiple apps Key Features ✅ Multi-Tool AI Agent: Combines Wikipedia, web search, calendar, email, and contacts in one interface ✅ Conversation Memory: Remembers context across multiple interactions ✅ Automatic Daily Scheduling: Proactive daily schedule emails ✅ Contact Intelligence: Automatically finds contact information before sending emails ✅ Telegram Integration: Works through the familiar Telegram interface Use Cases "What's on my schedule today?" → Receives formatted email with daily agenda "Send an email to John about the meeting" → Finds John's email and sends message "What's the weather in Paris?" → Gets current weather information via web search "Tell me about quantum computing" → Provides Wikipedia information "Schedule a meeting with Sarah tomorrow at 2 PM" → Creates calendar event Prerequisites Before setting up this template, you'll need accounts and API access for: Telegram Bot** (free via @BotFather) OpenAI API** (paid service) Google Calendar API** (free) Gmail API** (free) Google Sheets API** (free) SerpAPI** (freemium web search) Setup Instructions 1. Create Telegram Bot Message @BotFather on Telegram Use /newbot command and follow instructions Save your bot token for later 2. Set Up Google APIs Go to Google Cloud Console Create a new project or select existing Enable Google Calendar, Gmail, and Sheets APIs Create OAuth2 credentials Download credentials JSON file 3. Get API Keys OpenAI: Visit platform.openai.com, create API key SerpAPI: Sign up at serpapi.com, get API key 4. Configure Credentials in n8n Add Telegram Bot credentials using your bot token Set up Google OAuth2 for Calendar, Gmail, and Sheets Add OpenAI API credentials Add SerpAPI credentials 5. Customize the Workflow Update Calendar ID: Replace a________@gmail.com with your calendar Set Google Sheets ID: Replace the sheet ID with your contacts spreadsheet Modify System Message: Update the AI agent's instructions to match your preferences Adjust Memory Settings: Configure conversation memory window as needed 6. Test the Setup Activate the workflow Message your Telegram bot Verify all integrations are working Customization Options Change AI Model**: Switch between OpenAI models (GPT-3.5, GPT-4, etc.) Adjust Memory**: Modify conversation memory window length Add More Tools**: Integrate additional services like Notion, Slack, or weather APIs Modify Schedule**: Change when daily schedule emails are sent Customize Responses**: Update the system message to change assistant personality Important Notes Privacy**: This bot has access to your calendar, contacts, and email - ensure proper security API Costs**: OpenAI and SerpAPI usage will incur costs based on usage Rate Limits**: Be aware of API rate limits for each service Security**: Use environment variables for sensitive credentials Troubleshooting Bot not responding**: Check Telegram credentials and webhook configuration Calendar access issues**: Verify Google Calendar API permissions Email not sending**: Confirm Gmail API scopes include send permissions Memory not working**: Check that session keys are properly configured Support For issues with this template, check: n8n Community Forum Individual API service documentation Google Cloud Console for API errors OpenAI usage dashboard for model issues

Creates an AI-powered sales and support agent connected to live store data from Shopify/WooCommerce. MCP ensures controlled access to inventory and order systems. Automatically handles customer queries, stock alerts, and refund logic to reduce manual workload. How it works Trigger — Listens for incoming customer support requests via Webhook (chat, email, or API) Fetch context — Retrieves live order status and inventory data from Shopify in parallel AI reasoning — Claude AI analyzes the query with full store context and decides action Route intent — Classifies into: Order Inquiry, Inventory Check, Refund Request, or General Support Act — Processes refunds, sends stock alerts, or responds to customer automatically Log & notify — Saves interaction to PostgreSQL and notifies team via Slack for escalations Setup steps Shopify / WooCommerce — Add your store API credentials to the HTTP Request nodes Claude AI — Set your Anthropic API key in the AI node credentials PostgreSQL — Create a support_interactions table to log all AI-handled tickets Slack — Add your incoming webhook URL to the Slack notification node Email — Configure SMTP credentials for customer-facing response emails Test — Send a test webhook payload, verify all branches, then activate Intent branches the AI handles: ORDER_INQUIRY → Tracks shipment, shows order details REFUND_REQUEST → Auto-processes eligible refunds via Shopify API INVENTORY_CHECK → Detects low-stock (≤5 units) and fires Slack alert PRICING_INQUIRY / GENERAL_SUPPORT → Smart contextual response Before activating, update these placeholders: YOUR-STORE.myshopify.com + YOUR_SHOPIFY_ACCESS_TOKEN YOUR_SLACK_WEBHOOK_URL (appears in 3 nodes) SMTP credentials + support@yourstore.com PostgreSQL credentials (create a support_interactions table) Explore More LinkedIn & Social Automation: Contact us to design AI-powered lead nurturing, content engagement, and multi-platform reply workflows tailored to your growth strategy.

How It Works This workflow automates tax compliance monitoring and revenue analysis for accounting teams and finance managers handling multi-source income data. It solves the critical problem of manually tracking revenue streams, identifying tax anomalies, and ensuring regulatory compliance across multiple data sources. The system fetches revenue data from accounting software via MagicCSV, processes it through three specialized AI models for categorization, anomaly detection, and compliance verification, then automatically syncs validated results to accounting systems and sends tax summary reports via email and WhatsApp. This eliminates hours of manual review, reduces compliance errors, and provides real-time tax insights. Setup Steps Configure MagicCSV integration with your accounting software API credentials Add Anthropic API key for categorization, anomaly detection, and compliance models Connect accounting software webhook/API for bidirectional sync Set up Gmail authentication for automated report distribution Configure WhatsApp Business API credentials for instant alerts Prerequisites Anthropic API access, MagicCSV account, accounting software with API capabilities Use Cases Multi-entity corporations tracking cross-border revenue, e-commerce businesses with diverse income streams Customization Modify AI prompts for industry-specific tax rules, add custom anomaly thresholds Benefits Reduces manual tax review time by 80%, minimizes compliance errors through triple AI validation

How It Works This workflow automates customer feedback processing by analyzing sentiment, identifying key issues, generating personalized responses, and escalating critical cases to support teams when required. Designed for customer success managers, support teams, and product managers, it enables scalable feedback handling without compromising response quality or urgency. The workflow eliminates manual triage and response drafting by normalizing incoming feedback, performing sentiment and topic analysis, generating context-aware AI responses, validating tone and intent, escalating high-risk or negative feedback, logging all interactions for traceability, and delivering automated replies via email. Setup Steps Configure webhook trigger URL for feedback form integration or email parsing Add OpenAI API key for sentiment analysis and response generation Connect Anthropic Claude API for alternative response generation and validation Set up Google Sheets integration for feedback logging and analytics tracking Configure Gmail OAuth2 credentials for automated customer response delivery Integrate support ticket system (Zendesk, Freshdesk) for escalation routing Prerequisites OpenAI API key, Anthropic Claude API key (optional), Google Workspace account (Sheets, Gmail) Use Cases Product feedback management, customer support automation Customization Adjust sentiment scoring thresholds per industry standards, modify response templates Benefits Responds to feedback 95% faster, maintains consistent response quality across all interactions

📖 Description 🔹 How it works This workflow turns a Google Form submission into a polished, SEO-optimized technical blog with a human approval step before publishing. Google Form Submission (Trigger) The process begins when a Google Form is filled. Responses are stored in Google Sheets, which acts as the trigger for the workflow. AI Blog Draft Generation Takes the form inputs (problem statement, options tried, solution, learnings, references, etc.). AI generates a structured draft JSON blog post containing: Title & metadata Problem explanation Solution breakdown Implementation methods with realistic code snippets Troubleshooting, performance tips, security notes, advanced use cases Clear developer-focused conclusion Template Fitting Reformats the draft into a professional long-form blog structure with consistent headings (H1, H2, H3), code blocks, and clear formatting. Optimization Layer Applies multi-layer optimization to make the blog: SEO-friendly (keywords, meta description, structured headings). GEO-ready (Generative Engine Optimization for visibility in ChatGPT, Claude, Gemini, etc.). Human-like in tone (reads naturally, avoids AI-detector flags). Human-in-the-Loop Review Sends the draft via Gmail (Send + Wait for Response) to an editor or approver. Approver options: ✅ Approve → Blog is stored & marked completed. ❌ Reject → Feedback is sent for revision. 🚫 Cancel → Workflow ends save status in sheets. Publishing / Storage Approved blogs are stored in a separate Google Sheet for publication tracking. Status in the original sheet is updated to Completed. ⚙️ Set up steps Connect Google Sheets & Gmail in n8n. Link your Google Form to the trigger sheet. Add AI provider credentials (Groq, Mistral, or OpenRouter). Customize blog structure (problem, solution, code, references, etc.). Set reviewer email(s) in Gmail node. Test the workflow by submitting a sample Google Form response. google form sample: ⚡ Result: A fully automated pipeline where filling a Google Form kicks off AI-powered blog generation, optimization, and a human-in-the-loop approval process, making technical content creation faster and more reliable.

🌍 Auto-Translate Incoming Emails to English This workflow automatically detects the language of every new Gmail email and translates non-English messages into English. The translated email is forwarded to your inbox with a clear "[TRANSLATED]" subject tag, and a label is added for easy filtering. ⚙️ How It Works Gmail New Email Trigger Listens for new unread emails in your Gmail inbox. Captures subject, sender, body text, and metadata. Normalize Email Data A Code node extracts the raw content from the email. Strips HTML, normalizes plain text, and prepares data for language detection. Detect Language (OpenAI) Uses OpenAI GPT-3.5-turbo to detect the email’s language. If the language is English, workflow ends. If not, continues to translation. Translate to English OpenAI translates the email body into clear English. Prepare Translated Email Builds a forwarded email containing: Original sender & subject Received date Message ID Translated content (with formatting) Send Translated Email A Gmail node sends the translated message to your inbox. Subject is prefixed with [TRANSLATED] for easy recognition. Add "Translated Emails" Label Automatically tags the original message in Gmail with "Translated Emails". Helps you filter all auto-translated emails later. 🛠️ Setup Steps 1. Gmail Label In Gmail, create a new label: Translated Emails Or update the label in the final Gmail node. 2. OpenAI API Key Get your key from platform.openai.com. Add credentials in n8n. Uses GPT-3.5-turbo (low cost, reliable). 3. Gmail OAuth In n8n, connect your Gmail account. Requires read/modify permissions. 📧 Example Output Subject: [TRANSLATED] Meeting Proposal Body: 🌍 AUTO-TRANSLATED EMAIL (Original Language: ES) 📧 Original From: juan@example.com 📅 Received: 2025-08-29 🔗 Message ID: 123456abcdef ═══════════════════════════════════════ TRANSLATED CONTENT: Hello, I wanted to ask if we can schedule the meeting for next week. ═══════════════════════════════════════ ✨ This email was automatically translated by n8n workflow. ⚡ With this workflow, every foreign-language email is instantly translated and delivered to you in English — no manual copy-pasting into Google Translate again.

Automatically extract sales insights from call transcripts and update your CRM. Every time Scoot finishes transcribing a sales call, this workflow pulls out the key details—budget, competitors, objections, next steps—and sends a formatted summary to the rep. How It Works Scoot webhook triggers when transcription completes Fetches the full transcript via Scoot API AI Agent (Gemini) extracts structured data: budget, competitors, objections, timeline, decision maker, pain points, buying signals Updates your CRM with extracted fields Emails a formatted summary to the sales rep If the transcript is still processing, it retries automatically (up to 6 times, 1 hour apart). Setup Import the workflow JSON Add credentials: Scoot API → Header Auth with your API key Google Gemini → API key from aistudio.google.com Gmail → OAuth2 Copy webhook URL to Scoot Dashboard → Webhooks → Transcription Complete Replace the mock CRM node with HubSpot, Salesforce, or Pipedrive Test with the manual trigger (uses sample data) Activate ---

Personalized Cold Email System with Google Gemini AI and Telegram Approval An AI-powered cold email automation that uses Google Gemini to generate personalized outreach and a Telegram workflow for manual approval, ensuring high-quality, human-in-the-loop campaigns. Features Smart Lead Selection**: Fetches leads with an "Available" status from a designated Google Sheet. AI Email Generation**: Google Gemini creates a personalized subject line and email body based on lead data. Telegram Approval**: Sends each generated email to a Telegram chat for a one-click "Approve" or "Reject" decision. Edit & Regenerate**: Allows users to provide feedback on rejected emails, which the AI uses to regenerate a new version for re-approval. Auto-Send**: Approved emails are automatically dispatched via a configured SMTP server, including a professional signature. Complete Tracking**: Updates three separate Google Sheets (Filtered Leads, Sent Leads, Emails Sent) to maintain a clear audit trail. Rate Limiting**: A one-second delay between email sends helps avoid spam filters and protects sender reputation. Batch Processing**: Handles three leads per execution by default, which is configurable to scale up or down. How It Works A manual trigger initiates the workflow and captures the current date and time for logging. The system fetches a set number of leads (default is three) from the Filtered Leads sheet where the status is "Available". It loops through each lead individually to generate and send a unique email. The AI generates a personalized email (Subject + Body) using the lead's data. A preview of the email is sent to a specified Telegram chat with "Approve" and "Reject" buttons. If approved: The email is sent via SMTP. The lead's status is updated, and logs are written to the Sent Leads and Emails Sent sheets. The system waits one second before processing the next lead. If rejected: The system prompts the user for feedback in Telegram. The feedback is combined with the original prompt to generate a new email draft, which is sent for re-approval. A final notification is sent to Telegram when the batch is complete. Requirements Google Sheets with three tabs (see structure below). Telegram Bot Token and user/group Chat ID. Google Gemini API Key. SMTP Email Account credentials (server, port, username, password). Setup Instructions Google Sheets Setup: Create a new Google Sheet. Rename three tabs to exactly Filtered Leads, Sent Leads, and Emails Sent. Populate the Filtered Leads sheet with your lead data according to the structure specified below. API Credentials: Google Gemini: Generate an API key from your Google AI Studio account. Telegram Bot: Create a new bot by messaging @BotFather on Telegram and follow the prompts to get your API token. Get your Chat ID by messaging @userinfobot. SMTP Configuration: Obtain the SMTP server address, port, username, and password from your email provider (e.g., Google Workspace, Outlook). Automation Platform: In your automation platform (e.g., n8n, Make), create a new workflow. Connect your Google Sheets account using OAuth2. Add the Gemini API Key, Telegram Bot Token, Chat ID, and SMTP credentials into the respective modules or credential stores. Map the sheet columns to the variables in the workflow modules. Google Sheets Structure The automation requires the following column headers in each sheet. The names must be exact. Filtered Leads (Input Sheet)** FirstName: Lead's first name. LastName: Lead's last name. Email: Lead's email address. CompanyName: Name of the lead's company. JobTitle: Lead's current job title. Website: Company website (for AI context). LinkedIn: URL of the lead's LinkedIn profile. Notes: Any specific details or pain points for personalization. Status: Workflow status. Set to Available for leads ready to be processed. Sent Leads (Tracking Sheet)** Email: Email address of the contacted lead. CompanyName: Name of the company. TimestampSent: Date and time the email was sent. Emails Sent (Archive Sheet)** RecipientEmail: The lead's email address. Subject: The exact subject line that was sent. Body: The full email body that was sent. TimestampSent: Date and time the email was sent. Customization Guide This template can be adapted to fit specific campaign needs. Batch Size**: The number of leads processed per execution is controlled by the initial "Get Leads" module. Change the Limit parameter from 3 to your desired number. AI Prompt**: The core of the personalization is the prompt sent to the Gemini API. Modify this prompt to change the email's tone, structure, or call-to-action. You can instruct the AI to focus on specific data from the Notes column or reference a different value proposition. Lead Filtering**: The trigger condition is set to pull leads where Status = "Available". This can be changed to any other logic, such as Priority = "High" or Campaign = "Q4-Push", by adjusting the filter in the Google Sheets module. Email Signature**: The signature is typically configured within the SMTP "Send Email" module. Update the HTML or plain text here to change the signature across all sends. Telegram Notifications**: The text and buttons sent to Telegram for approval can be modified. You can add more lead data to the approval message (e.g., Job Title, Company Name) to give the approver more context.

How it works This workflow automates end-to-end contract analysis when a new file is uploaded to Google Drive. It downloads the contract, extracts its content, and uses AI to analyze legal terms, obligations, and risks. Based on the assessed risk level, it notifies stakeholders and logs structured results into Google Sheets for audit and compliance. Step-by-step Step 1: Contract ingestion and AI analysis** Google Drive Trigger – Monitors a specific folder for newly uploaded contract files. Download file – Downloads the uploaded contract from Google Drive. Extract Text From Downloaded File – Extracts readable text or prepares raw content for complex files. AI Contract Analysis – Analyzes legal, commercial, and financial clauses using AI. Format AI Output – Parses and structures the AI response into clean, usable fields. Step 2: Risk alerts and audit logging** Alert Teams Automatically – Evaluates risk level and checks for significant risks. Send a message (Risk Alert) – Sends a detailed alert email for medium-risk contracts. Send a message (Info Only) – Sends an informational email when no action is required. Get The Data To Save In Google Sheet (Alert Path) – Prepares alert-related contract data. Get The Data To Save In Google Sheet (Info Path) – Prepares non-alert contract data. Append row in sheet – Stores contract details, risks, and timestamps in Google Sheets. Why use this? Eliminates manual contract screening and repetitive reviews. Detects explicit and inferred risks consistently using AI. Automatically alerts teams only when attention is required. Creates a centralized audit log for compliance and reporting. Scales contract analysis without increasing legal workload.

Get top Binance Earn yields sent to Email This workflow automates the tracking of passive income opportunities on Binance by fetching real-time Flexible Earn APY rates, calculating potential returns, and delivering a daily summary to your inbox. Manually checking crypto savings rates is tedious. This template handles the complex authentication required by Binance (HMAC-SHA256 signing), filters through hundreds of assets to find the highest yields, and calculates exactly how much you would earn daily on a simulated capital amount. 👥 Who is this for? Crypto Investors** looking to maximize passive income on idle assets. DeFi/CeFi Analysts** monitoring market rate fluctuations. Hodlers** who want to ensure their assets are generating the best possible yield without daily manual checks. ⚙️ How it works Schedule Trigger: Initiates the workflow every 24 hours (customizable). Authentication Handler: Generates a timestamp and creates a secure HMAC-SHA256 signature required by the Binance API. Data Fetching: specific HTTP Request retrieves the full list of "Flexible Earn" products. Processing: The workflow splits the data, standardizes field names, and sorts all assets by Annual Percentage Rate (APR) in descending order. Analysis: It limits the list to the top 15 assets and calculates estimated daily earnings based on a $10,000 reference capital (customizable via code). Reporting: A formatted HTML email is sent via Gmail with the top opportunities. 🛠️ Setup Guide Binance API: Log in to Binance and create a Read-Only API Key. Configure Nodes: Open the Set Credentials 1 node: Paste your API_KEY and SECRET_KEY in each field. Email Setup: Open the Send Email node. Select or connect your Gmail credentials. Update the "To" address to your email. 🔌 Requirements An active Binance account. Binance API Key & Secret (Read-Only permissions are sufficient). A Gmail account (or you can swap the Gmail node for Outlook/Slack/Telegram). 🎨 How to customize Change Capital Calculation:** Open the "Filter & Analyze" Code node and change const capital = 10000; to your actual portfolio size to see real projected earnings. Filter Assets:** Add an If node after the "Split Out" node to only filter for specific assets (e.g., USDT, BTC, ETH) if you don't want to see altcoins. Change Frequency:** Open the "Daily Trigger" node to run this hourly or weekly.

Create GitHub issues from webhook input and send alerts to Telegram This workflow streamlines bug tracking by using a webhook to collect issue reports, automatically classifying and summarizing them with Gemini AI, then sending critical issues to GitHub and real-time notifications to Telegram. Optional manager approval is built in for low-priority reports. 🧑‍💻 Who’s it for This workflow is ideal for: Engineering teams needing automated issue tracking from multiple systems QA testers or customer support agents who log bugs via custom tools DevOps teams monitoring logs or error reports in real time Teams using GitHub for issue tracking and Telegram (or any messenger) for notifications ⚙️ How it works Webhook Trigger – Listens for incoming POST requests containing bug or task data. AI-Powered Classification – Uses the Gemini model to classify bugs as High or Low severity. Optional Approval – If severity is Low, it waits for a manager’s approval before proceeding. Bug Summary Generation – Passes through a filter and sends the input to Gemini to generate a clean summary. Create GitHub Issue – Submits the summarized issue to your GitHub repository. Telegram Notification – Sends a formatted message to a Telegram group or manager, depending on the path. 🛠️ How to set up Replace the GitHub node with your repo credentials and target repo. Set up the Telegram bot token and chat ID in the Telegram node. Customize the Gemini prompts for your preferred classification and summary logic. Define the conditions for “High” vs “Low” severity based on your data. 📋 Requirements A GitHub account with a personal access token (with repo access) A Telegram bot token and group chat ID Google Gemini API credentials (or your preferred AI model integration) 🔧 How to customize the workflow Swap Telegram with another messaging platform like Slack, Discord, or Microsoft Teams. Adjust classification rules to match your business logic. Change approval flow to notify a different person or add additional logic before sending to GitHub. Extend the webhook input format to support richer data, such as user info or system metadata.

This n8n template demonstrates how to leverage AI to analyze trending short-form video content and automatically generate original, high-engagement video scripts inspired by proven viral formats. Use cases are many: Create consistent content calendars for beauty salons and aestheticians, maintain a steady stream of reels without creative burnout, or study viral patterns to understand what drives engagement across Instagram's trending hashtags! Good to know The workflow scrapes real trending reels from Instagram based on your chosen hashtag, ensuring you're always learning from current viral patterns Video transcription happens automatically, extracting the core messaging and pacing strategies from successful content Generated scripts use proven engagement structures—hook, value delivery, and call-to-action timing—without copying original content All data is organized in Google Sheets for easy review, editing, and tracking of script performance The AI model intelligently mirrors the emotional tone and narrative structure while creating entirely new storylines How it works A form trigger collects your hashtag and desired number of reels to analyze The Apify API scrapes trending Instagram reels matching your hashtag, filtering for high engagement (1000+ likes from the last 7 days) Filtered reels are added to your Google Sheet with metadata: captions, engagement metrics, video links, and music information Each reel is automatically transcribed using video-to-text technology, capturing the exact dialogue and timing The AI Agent analyzes each transcript to understand its underlying structure—pacing, tone, curiosity hooks, and CTA placement Using this analysis, Claude generates a completely original script that follows the same proven engagement formula but with a fresh topic or angle Generated scripts are saved back to your Google Sheet alongside the source materials for comparison and refinement A summary email is sent confirming the number of scripts created and ready for production How to use Start by entering a beauty or lifestyle hashtag (e.g., #aiautomation, #beautysalon, #haircare) and specify how many trending reels to analyze Review the scraped content in your Google Sheet to understand what's currently resonating Check the generated scripts and use them as jumping-off points for your own video production Iterate on the process with different hashtags to discover emerging trends in your niche Requirements Apify account and API key for Instagram scraping (free tier available) Google Sheets document set up to store reel data and generated scripts OpenAI API key for the AI script generation Gmail account for the completion notification (optional but recommended) Customising this workflow Adjust the engagement filter thresholds (currently 1000+ likes, 7 days old) to capture micro-trends or evergreen content Modify the AI prompt in the "AI Agent" node to enforce specific brand voice, tone, or content guidelines Add additional Google Sheet columns to track metrics like script-to-video conversion rates or audience response Connect to additional distribution channels—automatically post scripts to team Slack, create video production briefs, or trigger video editing templates Experiment with different video categories by creating multiple instances of this workflow for different hashtags or niches