by Cheng Siong Chin
Overview Automate AI content creation from request to approval. While AI writes quickly, human review often delays deliveryโand multiple tools create workflow gaps and version confusion. This unified solution streamlines the entire process, enabling teams to produce quality content at scale with transparent tracking. How it works Submit a form with your topic, tone, and keywords. GPT-4o generates the content and assigns a quality score (0โ100). The reviewer receives an email to approve, edit, or reject the draftโall actions are automatically logged in Google Sheets for tracking and audit purposes. Setup steps Import the workflow JSON file into n8n Connect your OpenAI and Google account credentials Update three variables in the workflow: SHEET_ID (your Google Sheets document ID), REVIEWER_EMAIL (recipient for review notifications), and WEBHOOK_URL (for form submissions) Test the workflow with a sample submission Workflow Stages Submit a form with topic, tone, and keywords. GPT-4o generates content and assigns a quality score (0โ100). Reviewer receives an email to approve, edit, or reject the draft. All review actions are automatically logged in Google Sheets with timestamps and approval status. Requirements n8n v1.0+ instance, OpenAI API key with GPT-4o access, and Google Workspace with OAuth2 credentials. Custom options Choose model: gpt-4o, 4o-mini, or 3.5-turbo. Adjust score weights: Readability 40%, Keywords 30%, Length 30%. Key benefits Generate drafts 99% faster and approve content 95% quicker. Centralized tracking ensures clarity and accountability.
by Rully Saputra
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.
by Fabian Herhold
Whoโs it for Recruiting agencies, executive search firms, and in-house talent teams that want to automate candidate sourcing and prequalification. Instead of spending hours searching, scoring, and writing outreach, this workflow turns any job description into a ready-to-use shortlist with personalized messages. Youtube Walkthrough What it does (How it works) This workflow takes a job description (title, description, and location) and runs a complete recruiting automation pipeline: Normalize job titles** and generate variations to widen search coverage. Search candidates** in Apollo (or your CRM / database of choice). Remove duplicates** to keep clean lists. Score candidates** with AI (0โ5) and provide concise reasoning across experience, industry, and seniority. Enrich LinkedIn profiles** (name, title, image, location, experience). Create structured candidate assessments** (summary, alignment, red flags, positives). Generate outreach messages** (email + LinkedIn DM) tailored to the candidate. Write to Airtable** for job/candidate tracking and downstream automation. Everything is plug-and-play, with no manual searching or copy-pasting required. Requirements n8n (Cloud or self-hosted) Airtable account + API access Apollo API or your preferred candidate source LLM provider: OpenAI or Anthropic LinkedIn enrichment API (RapidAPI, Apify, etc.) > โ ๏ธ Do not hardcode API keys in HTTP nodes. Always use Credentials in n8n. Airtable table specifications Create one base (e.g., Candidate Search โ From Job Description) with two tables: Jobs Table Job Title (text) Job Description (long text) Job Location (text) Candidates (linked to Candidates table) Candidates Table Core fields: Name, LinkedIn URL, Job Title, Location, Image URL, Job Searches (linked) Assessment fields: Summary Fit Score, Executive Summary, Title Alignment, Skill Alignment, Industry Alignment, Seniority Alignment, Company Type Alignment, Educational Alignment, Potential Red Flags, Positive Signals, Final Recommendation, Next Steps Suggestion Outreach fields: Email Subject, Email Body, LinkedIn Message How to set up Connect credentials Add Airtable, Apollo/CRM, and OpenAI/Anthropic credentials under n8n Credentials. Create Airtable base/tables Follow the above spec for Jobs and Candidates. Match field names exactly to avoid mapping errors. Configure the trigger The workflow starts from a Form/Webhook node. It captures: Job Title (required) Job Description (required) Location (required) Target Companies (optional, comma-separated domains) Job title mutation The workflow uses an AI node to normalize the job title and generate up to 5 variations for broader candidate searches. Candidate search Apollo (or your CRM API) is queried with the generated titles and location filters. Results are deduped. AI scoring & structuring Candidates are scored 0โ5 with clear reasoning (experience, industry, seniority, general fit). Profiles are formatted into structured JSON for Airtable. LinkedIn enrichment Enrichment API fetches missing data (geo, image, job history). Candidate assessment An AI model produces a full recruiter-ready evaluation (fit summary, strengths, red flags). Outreach generation The workflow drafts a concise cold email (<75 words) and LinkedIn DM (<60 words), consultative in tone. Write to Airtable All jobs and candidates (with assessments and outreach messages) are logged for review and integration. How to customize Swap Apollo with your CRM** (Greenhouse, Bullhorn, etc.). Adjust scoring prompts** to match your niche (sales, engineering, healthcare). Add custom filters** for target companies or industries. Change outreach tone** to align with your brand voice. Limit by score** (e.g., only push candidates with score โฅ4). Security & best practices Store all keys in n8n Credentials (never in nodes). Use Set nodes to centralize editable variables (title, location, filters). Always add sticky notes in your workflow explaining steps. Rename nodes clearly for readability. Troubleshooting No candidates found?** Loosen title variations or broaden location. Low fit scores?** Refine keywords and required skills in scoring prompts. Airtable errors?** Double-check Base ID, Table ID, and field names. API rate limits?** Enable batching/pagination and increase intervals. SEO title: Build candidate shortlists from a job description to Airtable with Apollo, AI scoring, and personalized outreach Keywords: recruiting automation, Apollo people search, candidate enrichment, AI scoring, Airtable recruiting CRM, LinkedIn outreach, n8n workflow template
by Ahmed Sherif
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.
by David Olusola
๐ 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.
by Parth Pansuriya
AI Meeting Summary Generator with Google Docs Integration Whoโs it for Teams that record meetings and want fast, clear summaries without manual note-taking. Managers who need action items extracted automatically. Anyone using Google Drive + Google Docs as their central workspace. How it works / What it does This workflow automates meeting documentation: Watches a Google Drive folder for new audio/video meeting files. Downloads the file and transcribes speech into text using Gemini AI. Summarizes transcripts into Key Discussions and Action Items. Creates or updates a Google Doc with the formatted summary (title, bullets, checkmarks, styling). Sends final output to Docs with bold headings, bullets, and spacing for readability. How to set up Add your Google Drive Trigger to monitor a folder. Connect Gemini AI to handle transcription + summarization. Configure the Google Docs Tool to create/update your summary documents. (Optional) Use the Code Node + Docs API to apply bullet/checkmark formatting. Requirements Google Drive OAuth2 โ for monitoring & downloading files Google Docs OAuth2 โ for creating and updating documents Google Gemini API โ for transcription + AI-powered summarization How to customize the workflow Change the Google Drive folder to monitor a different workspace. Edit the system prompt in the Summarizer to tweak summary style (e.g., more detail, decisions only, etc.). Modify the Code Node formatting rules (bullets, checkmarks, bold text). Add integrations (e.g., Slack, Email, Notion) to send summaries beyond Google Docs.
by Oneclick AI Squad
This automated n8n workflow monitors real-time cryptocurrency prices using CoinGecko API and sends smart alerts when price conditions are met. It supports multi-coin tracking, dynamic conditions, and instant notifications via Email, Telegram, and Discord. Good to Know Reads crypto watchlist data from Google Sheets. Monitors prices at defined intervals (24/7 monitoring). Handles upper and lower price limits with direction-based alerts (above, below, both). Implements cooldown logic to avoid duplicate alerts. Updates last alert price and timestamp in Google Sheets. Supports multiple alert channels: Email, Telegram, Discord. Uses CoinGecko API for price data (Free tier supported). How It Works 24/7 Crypto Trigger โ Runs every minute (or custom interval) to check latest prices. Read Crypto Watchlist โ Fetches symbols and conditions from Google Sheets. Parse Crypto Data โ Converts Google Sheet data into structured JSON. Fetch Live Crypto Price โ Uses CoinGecko API to get latest market price for each coin. Smart Crypto Alert Logic โ Compares live price with upper/lower limits and evaluates conditions: Above โ Trigger alert if price > upper\_limit. Below โ Trigger alert if price < lower\_limit. Both โ Trigger alert if either condition is met. Implements cooldown\_minutes to prevent repeated alerts. Check Crypto Alert Conditions โ Validates alerts before sending notifications. Send Crypto Email Alert โ Sends email alert if condition is true. Send Telegram Crypto Alert โ Sends Telegram alert. Send Discord Crypto Alert โ Sends Discord alert. Update Crypto Alert History โ Updates last_alert_price and last_alert_time in Google Sheet. Crypto Alert Status Check โ Ensures alert process completed successfully. Success Notification โ Sends confirmation message on success. Error Notification โ Sends an error alert if something fails. Google Sheet Columns (A-G) | Column | Description | | ------ | ---------------------------------- | | A | symbol (BTC, ETH, SOL, etc.) | | B | upper_limit (e.g., 45000) | | C | lower_limit (e.g., 40000) | | D | direction (both / above / below) | | E | cooldown_minutes (e.g., 10) | | F | last_alert_price (auto-updated) | | G | last_alert_time (auto-updated) | How to Use Import the workflow into n8n. Configure Google Sheets credentials and link your watchlist sheet. Add your CoinGecko API endpoint in the Fetch Price node (Free tier). Set up Email, Telegram, and Discord credentials for notifications. Test with sample data: Example: BTC, upper\_limit=45000, lower\_limit=40000, direction=both. Execute the workflow and monitor alerts. Requirements n8n environment with execution permissions. Google Sheets integration (with API credentials). CoinGecko API (Free tier supported). Notification channels: Email (SMTP settings in n8n). Telegram Bot Token. Discord Webhook URL. Customizing This Workflow Add more coins in Google Sheet. Modify alert conditions (e.g., percentage change, moving averages). Add SMS or WhatsApp notifications. Integrate with Slack or Microsoft Teams. Use AI-based price predictions for smarter alerts.
by Mariรกn Danaลก
Why Creating and sending invoices manually is a major administrative bottleneck. It's not only slow but also prone to human error, such as creating duplicate invoice numbers or sending sensitive financial data in an unsecured format. This workflow solves these problems by creating a robust, end-to-end automation. It ensures every invoice has a unique ID, is professionally generated, is password-protected, and is delivered to your customer automatically. What This workflow provides a complete, secure solution for automated invoicing. It is designed to be triggered by a Webhook (e.g., from your e-commerce store, CRM, or billing platform) that provides customer and order details. The workflow then executes the following steps: Generate & Verify ID: It first generates a new invoice ID. It then performs a critical check by reading your master Google Sheet to ensure this ID is unique, preventing duplicate invoices. Generate PDF: Once the ID is verified, it passes the data to the PDF Generator API. This service dynamically populates your custom invoice template. (PDF Generator API makes it incredibly easy to build and manage your document templates via their web-based editor). Encrypt Document: For enhanced security, the workflow uses a PDF Generator API operation to encrypt the newly generated invoice with a password, protecting your client's sensitive data. Store & Deliver: Finally, it uploads the secure PDF to a specified Google Drive folder for your records and then automatically sends it to the customer as an attachment using Gmail. How Prerequisites: You will need active accounts for: PDF Generator API (for both generation and encryption) Google Suite (for Sheets, Drive, and Gmail) PDF Generator API Setup: Log in to your PDF Generator API account and use their template builder to create your invoice design. Note your Template ID, API Key, and API Secret. In the n8n PDFGeneratorAPI node (Generate a PDF document), create new credentials using your Key and Secret. In the node's parameters, select your Template ID from the list. Google Sheets Setup: Create a Google Sheet to act as your master list of invoices. In the Check If ID Already Exists node, authenticate your Google Sheets account. Set the Spreadsheet ID and Sheet Name. In the "Columns to Return" field, enter the name of the column where you store your invoice IDs. Security & Delivery Setup: Encrypt Node: In the Encrypt PDF document node, authenticate your PDF Generator API credentials (the same ones from Step 2). You can set a static password, or for better security, use an expression to set a dynamic password from the webhook data (e.g., the customer's postal code or order ID). Google Drive Node: Authenticate the Upload file node and specify the Drive and Folder ID where invoices should be stored. Gmail Node: Authenticate the Send a message + file node. Use an expression to map the customer's email from the trigger data into the "To" field. Test & Activate: The Webhook node has pinned test data. You can click "Test workflow" to run the entire process with this sample data. Once you confirm the file is generated, encrypted, and sent, connect your live app (e.g., Shopify, Stripe, etc.) to the production Webhook URL. Activate the workflow.
by Paul
Workflow Description and Setup Guide This workflow provides comprehensive AI-driven stock analysis, generating detailed deep reports by leveraging advanced vector-based data retrieval and API integrations for precise financial analytics using Danelfin scoring and strategy. Overview This workflow automates stock analysis utilizing: AI-driven scoring and sector insights** (Danelfin configuration) Vector-based data retrieval** (Supabase) Deep analytical reports** Key Components and API Integrations 1. Danelfin AI Stock Analysis API Provides advanced stock scores, rankings, and sector insights. Endpoints:** /ranking: Stock rankings and scores /sectors: Sector information /industries: Industry details 2. Supabase Vector Store Vector embedding storage and quick data retrieval. Workflow Steps Initialization Chat Trigger: Activates when a message requesting stock analysis is received. Stock Analysis and Deep Reporting Main AI Agent: Processes the query, retrieves relevant data from Danelfin, and generates deep analytical reports. Supabase Vector Store: Facilitates efficient data retrieval using embeddings. Reporting Markdown Conversion: Transforms analysis into a readable HTML format. Email Reporting: Sends detailed reports via Gmail. Setup Instructions Prerequisites Obtain API Keys for Supabase and Danelfin. Configuration Steps Set API Keys: Supabase API credentials for vector storage. Danelfin API credentials for stock analysis. Gmail API Credentials: Configure Gmail node for sending reports. Running the Workflow Triggered automatically by chat messages requesting analysis. Reports sent directly via email. This setup ensures precise, AI-driven stock analysis delivered clearly through automated deep reporting.
by Martijn Kerver
Description Transform training prescriptions into perfectly formatted Intervals.icu workouts using AI. This workflow automatically converts free-text workout descriptions into structured interval training sessions with proper heart rate zones, pace calculations, and exercise formatting. What this workflow does Collects workout details via a web form (date, title, and workout description) Fetches athlete data from Intervals.icu (FTP, max HR, threshold pace, LTHR) Processes with AI using Claude Opus 4.1 to intelligently parse and format the workout Auto-detects workout type (Run, Ride, Strength, HYROX, CrossFit, etc.) Converts training zones - RPE โ HR%, pace calculations, power zones Formats workout structure with proper transitions, rest periods, circuit formatting Creates the workout in Intervals.icu via API Use cases Coaches**: Convert training plans from documents/spreadsheets into Intervals.icu format Athletes**: Quickly add structured workouts from coaching apps or training programs Hybrid training**: Handle complex HYROX, CrossFit, or multi-sport sessions with circuit formatting Time savings**: Eliminate manual workout entry and zone calculations Supported workout types Running, cycling, swimming, strength training, HYROX, CrossFit, indoor rowing, virtual training (Zwift), triathlon, and more. Key features โ Intelligent workout type detection โ Automatic RPE to HR zone conversion using athlete-specific data โ Proper formatting for intervals, circuits, supersets, and progressions โ Adds transitions between exercises/machines โ Calculates exercise durations and pacing โ Handles warmup/cooldown sections โ Generates unique workout IDs Setup requirements Intervals.icu account** with API access (API key required) Anthropic API key** for Claude AI Athlete must have training zones configured in Intervals.icu (FTP, max HR, LTHR, threshold pace) Setup instructions Getting your Intervals.icu API key Log in to Intervals.icu Go to Settings (gear icon) โ Developer Settings Click Generate API Key (or copy your existing key) Save the API key securely Configuring credentials in n8n For Intervals.icu (HTTP Basic Auth): In n8n, open the GetAthleteInfo or CreateWorkoutAPI node Click on Credentials โ Create New Credential Select HTTP Basic Auth Enter: Username: API_KEY (literally type "API_KEY") Password: Your actual API key from Intervals.icu Click Save Apply this credential to both HTTP Request nodes For Anthropic: Open the Anthropic Chat Model node Click on Credentials โ Create New Credential Enter your Anthropic API key Click Save Important: The Intervals.icu API uses HTTP Basic Authentication where the username is always the literal string "API_KEY" and the password is your actual API key. How it works The workflow uses a sophisticated AI agent with a detailed system prompt that understands training terminology, zones, and Intervals.icu formatting requirements. It applies sport-specific rules to ensure workouts are properly structured for tracking during training sessions.
by Ronnie Craig
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
by AureusR
Live Demo Booking Form with Outlook Calendar and Zoom link Whoโs it for This workflow is designed for SaaS companies, consultants, or sales teams that regularly run live demos. It helps automate demo scheduling, ensuring clients can only book from available time slots while instantly generating Zoom links and calendar invitations. How it works / What it does Client fills demo request form โ Collects company, contact details, and a preferred date. Check Outlook calendar availability โ Searches for pre-created โOnline Meeting Slotโ events. Time slot selection โ If the date has slots, the client chooses from up to 3 nearest available times. If not, theyโre asked to pick another date. Create Zoom meeting โ Once a date & time are confirmed, a Zoom link is automatically generated. Update Outlook calendar โ The chosen slot is updated with the clientโs details and Zoom link, marked as โBooked Live Demoโ so it canโt be double-booked. Send confirmation โ The client receives a styled confirmation screen, and both parties get the calendar invite. How to set up Import the workflow JSON into your n8n instance. Configure the following credentials: Microsoft Outlook OAuth2 API (for calendar access). Zoom OAuth2 API (for automatic meeting creation). Pre-create โOnline Meeting Slotโ events in your Outlook calendar to define available demo times. Publish the form via n8nโs webhook URL (embed it in your website or share the link). Test by submitting a request to ensure slots update correctly and Zoom links are created. Requirements n8n self-hosted or cloud account. Microsoft Outlook account with calendar access. Zoom account with OAuth2 credentials. Pre-created calendar slots named โOnline Meeting Slotโ. How to customize the workflow Form fields**: Adjust the client details form to capture additional data (e.g., industry, product interest). Email/notification**: Add an Email or Slack node to notify your sales team of new demo bookings. Custom branding**: Update the CSS in the form nodes to match your companyโs style. Capacity rules**: Modify the IF nodes to limit the number of bookings per day or adjust the slot-checking logic.