Telegram and Google Sheets integration

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and must be run on a self-hosted instance of n8n. Who is this for? This template is perfect for social media managers, content creators, AI enthusiasts, and automation pros who want to generate short-form videos (Reels) from a simple Telegram message, then publish them across multiple platforms—all without video editing or manual uploads. What problem is this workflow solving? Creating content is only half the job. The real bottleneck comes in: Rendering the video, Adding voice or music, Writing captions and titles, Publishing to multiple platforms. This workflow automates all of that using AI. It saves hours every week and guarantees consistent output. What this workflow does This end-to-end automation handles everything from AI video generation to social publishing: Starts with a Telegram message (text or image prompt) Generates video using Kling or Blotato, based on the input Creates music with Piapi and merges it with the video Generates text overlays and captions with GPT-4 Builds a stylized video using JSON2Video Logs results to Google Sheets Sends final output back to Telegram Auto-posts the video to 9 platforms via Blotato (Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter/X, Pinterest, Bluesky) Setup Connect your Telegram bot to the trigger node. Add your OpenAI API key for all GPT nodes. Set up Kling and Piapi API access (for video and music generation). Connect your Cloudinary account to upload images. Link a Google Sheet with columns: Title, Caption, URL. Set your Blotato API key and fill in the platform-specific account IDs. How to customize this workflow to your needs Change prompt formatting** to control GPT responses and video tone. Edit text styling** in JSON2Video to match your brand. Add a Telegram approval step** before publishing, if needed. Disable platforms** you don’t use by deleting their HTTP Request nodes. Use a Google Sheet filter** to only process new rows or drafts. 📄 Documentation: Notion Guide

AI-Powered Social Video Generator with Auto-Posting to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Pinterest, Twitter (X), and Bluesky Who is this workflow for? This workflow is ideal for content creators, marketers, social media managers, and automation enthusiasts who want to generate, customize, and publish short-form videos across multiple platforms without manual editing or posting. If you use tools like ChatGPT, Kling, or Blotato and want to streamline your content creation process, this workflow is made for you. What problem does this workflow solve? Publishing regular video content on multiple platforms is time-consuming—especially when adding voice-overs, captions, and managing distribution. This workflow solves that by: Automating video generation using AI (Kling + GPT-4) Adding realistic voice narration Styling subtitles for social media Creating titles and social captions Auto-posting to Instagram, TikTok, YouTube, Facebook, Threads, Twitter (X), LinkedIn, Pinterest, and Bluesky All of this is triggered by a simple message sent via Telegram. How the workflow works This end-to-end automation transforms a short Telegram message into a fully produced and published social video: Receives a text prompt from Telegram Transforms it into a detailed video scene using GPT-4 Generates a cinematic video with Kling Creates a voice-over script and converts it to audio Merges the video and the audio Adds styled captions Writes a social caption and an SEO-optimized title Saves metadata to Google Sheets Sends a preview via Telegram Publishes the video to 9 social platforms using Blotato Setup Connect your Telegram bot to the "Telegram Trigger" node Add your OpenAI API key to all GPT-related nodes Configure Kling API access in the "Generate Video" node Link your Cloudinary account for audio upload Connect JSON2Video to handle video merging and captioning Set up Google Sheets with your preferred spreadsheet ID Connect your Blotato API key and fill in the platform IDs (Instagram, TikTok, etc.) Test by sending a Telegram message like: generate video A robot exploring Mars, Why AI will reshape humanity > Disclaimer: This workflow uses Community Nodes, which are only available on self-hosted instances of n8n. How to customize this workflow to your needs Change the visual style**: Adjust the GPT-4 prompt formatting to reflect your brand tone Edit voice style**: Replace the TTS provider or tweak OpenAI's voice settings Revise captions or titles**: Fine-tune the system prompts in the "Create Description" or "Create Title" nodes Target fewer platforms**: Disable or remove nodes for platforms you don’t use Add approval steps**: Insert a Telegram confirmation step before auto-publishing 📄 Documentation: Notion Guide Demo Video 🎥 Watch the full tutorial here: YouTube Demo

The Best Invoice & Receipt OCR Automation - FREE (for a limited time) Automatically process invoices and receipts using Gemini OCR, extracting data directly into Google Sheets from multiple sources including Google Drive, Gmail, and Telegram. This powerful workflow ensures your bookkeeping is always accurate, organized, and efficient, significantly reducing manual effort and potential errors. Who is this for? This workflow is ideal for busy entrepreneurs, startup founders, freelancers, small business owners, bookkeepers, and accountants who aim to eliminate manual, repetitive, and error-prone bookkeeping tasks. Whether you regularly manage expenses from physical paper receipts, digital invoices, or email attachments, this workflow will dramatically streamline your bookkeeping processes and save you significant time and effort each month. What problem is this workflow solving? Manual data entry of invoices and receipts is notoriously tedious, incredibly time-consuming, and highly susceptible to human error. Mistakes in bookkeeping can lead to financial inaccuracies, compliance issues, and wasted resources. By automating the extraction of invoice data, this workflow streamlines your financial management process, significantly improves accuracy, reduces operational overhead, and allows you to redirect valuable resources and attention toward strategic, revenue-generating business activities. What this workflow does This template provides a powerful, automated solution for invoice and receipt data extraction using Google's Gemini API for OCR (Optical Character Recognition) via direct HTTP requests. Main Flow (Google Drive Trigger): The main workflow triggers (Google Drive Trigger New Files) whenever a new file (PDF or image) is added to a designated Google Drive folder. It uses a SplitInBatches node (Loop Over Items) to process incoming files one by one. For each file, it: Downloads the file (Google Drive Get Receipt). Converts it to base64 (Move file to base64 string). Sends the file data and a detailed prompt to the Gemini API (gemini-2.0-flash model specified in the Prompt node, sent via the Gemini API HTTP Request node). The prompt requests structured JSON output with specific fields and formatting (like comma decimal separators, no currency symbols, and a dedicated currency field). Parses the JSON response (JSON to string, Parse string nodes). Appends the extracted data (Invoice Date, Category, Sender, Currency, etc.), along with the original filename and a link to the file, to a specified Google Sheet (Add to Google Sheets). Includes Wait nodes to help manage potential rate limits. Supplementary flow 1 (Gmail Trigger): An additional trigger (Gmail Trigger) monitors your Gmail account for emails with a specific label. When a matching email with attachments arrives: It loops through emails and attachments. It renames the attachment using the format YYYY-MM-DD_SenderUsername (e.g., 2025-04-19_some.sender) using the Create File Name node. It saves the renamed attachment to the designated Google Drive folder (Google Drive Save Files), which then triggers the core OCR process above. Supplementary Trigger 2 (Telegram Trigger): Another optional trigger (Telegram Trigger Image) allows you to forward photos of physical receipts to your configured Telegram bot: It renames the image file using the format YYYY-MM-DD_Telegram (e.g., 2025-04-19_Telegram) via the Create File Name For Telegram node. It saves the renamed image to the designated Google Drive folder (Google Save Files 2), also triggering the core OCR process. Setup Credentials: Add the following credentials in n8n, using the names specified in the template or your own: Google OAuth2: For Google Drive, Google Sheets, Gmail. Telegram: For the Telegram bot trigger Gemini API Key: Obtain a free API key from Google AI Studio. You will need to paste this key directly into the Query Parameters of the Gemini API (HTTP Request) node in the workflow. Google Drive: Create a specific folder in your Google Drive where all invoices/receipts will be stored and processed from. Update the target Folder in the Google Drive Trigger New Files, Google Drive Save Files, and Google Save Files 2 nodes to use your designated folder. Google Sheets: Create a new Google Sheet, or clone this Sheet template. Ensure it has columns matching the desired output fields (see default list below, including Currency). Update the target Spreadsheet and Sheet Name in the Add to Google Sheets node to point to your sheet. Gmail (Optional): Create a label in Gmail (e.g., "receipts"). Update the Label filter in the Gmail Trigger node to use the label you created. Consider setting up filters in Gmail to automatically apply this label to relevant emails. Telegram (Optional): Configure the Telegram Trigger Image node with your bot credentials. Gemini API Node: Open the Gemini API (HTTP Request) node. In the "Query Parameters" section, replace the placeholder API key with your actual Gemini API Key. Verify the URL uses the correct model name by referencing the Prompt node's model value (gemini-2.0-flash by default). Customize Prompt: Open the Prompt (Set) node. Crucially, change the first line "My company is Sisu Digital..." to reflect your company or remove it if not needed. Review the list of categories and the specific formatting instructions (e.g., comma for decimals, no currency symbols, date format, "N/A" for notes) to ensure they match your requirements. You can adjust these details here. Activate Workflow: Test each trigger path (Drive upload, labeled Gmail, Telegram photo) with sample files/emails/messages, then activate the workflow. How to customize this workflow to your needs Gemini Prompt/Model:* Modify the prompt text, the list of categories, or the detailed formatting instructions within the *Prompt (Set) node. You can also change the model value in the Prompt node to use a different Gemini model (ensure the model supports the API endpoint used in the HTTP Request node). Extracted Fields:* Modify the prompt in the *Prompt node to extract different fields or change formatting. Update the parsing logic in the Parse string node if needed, and ensure your Google Sheet columns match in the Add to Google Sheets node. The default extracted fields (based on the updated prompt) are: Invoice Date: (DD/MM/YYYY) Category: (From predefined list) Sender: (Issuing company) Description: (Brief details) Amount (0% VAT): (Net amount, comma decimal, no currency symbol) VAT %: (Rate number, comma decimal, no % sign, "0,0" if none) Total: (Gross amount, comma decimal, no currency symbol) Currency: (Uppercase abbreviation, e.g., "EUR", "USD") Note: (Relevant notes, or "N/A") (Added by workflow): File Name, File URL Triggers & Targets:* Enable/disable or modify the *Gmail and Telegram triggers. Select your desired Google Drive folder, Google Sheet, and Gmail label directly within the respective nodes. File Naming:* Adjust the Javascript code in the *Create File Name (for Gmail) or Create File Name For Telegram nodes to change the renaming pattern. Current formats: YYYY-MM-DD_SenderUsername (Gmail), YYYY-MM-DD_Telegram (Telegram). Configuration Method:** Update configuration like folders, sheets, and labels directly within the relevant nodes. For easier management of multiple settings, consider adding a central 'Set' node at the beginning of the workflow to define these values and use expressions to reference them in other nodes. Important Considerations AI Accuracy:** AI models can make mistakes. Always review the data extracted into Google Sheets for accuracy, especially with specific formatting like decimal separators. This workflow automates heavily but requires final verification. Gemini API Usage:* This template uses the *Gemini API via HTTP Request. Be mindful of Google's API rate limits, usage policies, and potential costs associated with the model used (gemini-2.0-flash by default), especially if you change it. Monitor Google's terms. Loops and Waits:* The workflow uses *SplitInBatches and Wait nodes to process items individually and pause execution, which helps prevent hitting API rate limits but processes files sequentially rather than in parallel. Support Disclaimer This workflow is provided as-is for your convenience. Use it responsibly, and feel free to build upon it for your unique needs\! This workflow has been thoroughly tested and is confirmed to be working flawlessly at the time of release. However, setup complexity or unexpected errors may occur depending on your environment, customizations, or API changes. Please note that I cannot offer personalized support or troubleshooting for this template (without a fee\!). If you encounter an issue, feel free to send me a message describing the problem. If the issue is determined to be a genuine bug within the shared template, I will do my best to fix it and update the workflow. Otherwise, the issue is likely due to a setup misconfiguration or modification on your side. In those cases, I recommend using ChatGPT or referring to n8n documentation to debug the problem.

Automated Research Report Generation with OpenAI, Wikipedia, Google Search, Gmail/Telegram and PDF Output Description What Problem Does This Solve? 🛠️ This workflow automates the process of generating professional research reports for researchers, students, and professionals. It eliminates manual research and report formatting by aggregating data, generating content with AI, and delivering the report as a PDF via Gmail or Telegram. Target audience: Researchers, students, educators, and professionals needing quick, formatted research reports. What Does It Do? 🌟 Aggregates research data from Wikipedia, Google Search, and SerpApi. Refines user queries and generates structured content using OpenAI. Converts the content into a professional HTML report, then to PDF. Sends the PDF report via Gmail or Telegram. Key Features 📋 Real-time data aggregation from multiple sources. AI-driven content generation with OpenAI. Automated HTML-to-PDF conversion for professional reports. Flexible delivery via Gmail or Telegram. Error handling for robust execution. Setup Instructions Prerequisites ⚙️ n8n Instance**: Self-hosted or cloud n8n instance. API Credentials**: OpenAI API: API key with GPT model access, stored in n8n credentials. SerpApi (Google Search): API key from SerpApi, stored in n8n credentials (do not hardcode in nodes). Gmail API: Credentials from Google Cloud Console with Gmail scope. Telegram API: Bot token from BotFather on Telegram. Installation Steps 📦 Import the Workflow: Copy the workflow JSON from the "Template Code" section below. Import it into n8n via "Import from File" or "Import from URL". Configure Credentials: Add API credentials in n8n’s Credentials section for OpenAI, SerpApi, Gmail, and Telegram. Assign credentials to respective nodes. For example: In the SerpApi Google Search node, use n8n credentials for SerpApi: api_key={{ $credentials.SerpApiKey }}. In the Send Research PDF on Gmail node, use Gmail credentials. In the Send PDF to Telegram node, use Telegram bot credentials. Set Up Nodes: OpenAI Nodes (Research AI Agent, OpenAI Chat Model, OpenAI Chat Middle Memory): Update the model (e.g., gpt-4o) and prompt as needed. Input Validation (Input Validation node): Ensure your input query format matches the expected structure (e.g., topic: "AI ethics"). Delivery Options (Send Research PDF on Gmail, Send PDF to Telegram): Configure recipient email or Telegram chat ID. Test the Workflow: Run the workflow by clicking the "Test Workflow" node. Verify that the research report PDF is generated and sent via Gmail or Telegram. How It Works High-Level Steps 🔍 Query Refinement**: Refines the input query for better research. Aggregate Data**: Fetches data from Wikipedia, Google Search, and SerpApi. Generate Report**: Uses OpenAI to create a structured report. Convert to PDF**: Converts the report to HTML, then PDF. Deliver Report**: Sends the PDF via Gmail or Telegram. Detailed descriptions are available in the sticky notes within the workflow screenshot above. Node Names and Actions Research and Report Generation Test Workflow: Triggers the workflow for testing. Input Validation: Validates the input query. Query Refiner: Refines the query for better results. Research AI Agent: Coordinates research using OpenAI. OpenAI Chat Model: Generates content for the report. Structured Output Parser: Parses OpenAI output into structured data. OpenAI Chat Middle Memory: Retains context during research. Wikipedia Google Search: Fetches data from Wikipedia. SerpApi Google Search: Fetches data via SerpApi. Merge Split Items: Merges data from multiple sources. Aggregate: Aggregates all research data. Generate PDF HTML: Creates an HTML report. Convert HTML to PDF: Converts HTML to PDF. Download PDF: Downloads the PDF file. Send PDF to Telegram: Sends the PDF via Telegram. Send Research PDF on Gmail: Sends the PDF via Gmail. Customization Tips Expand Data Sources** 📡: Add more sources (e.g., academic databases) by adding nodes to Merge Split Items. Change Report Style** ✍️: Update the Generate PDF HTML node to modify the HTML template (e.g., adjust styling or sections). Alternative Delivery** 📧: Add nodes to send the PDF via other platforms (e.g., Slack). Adjust AI Model** 🧠: Modify the OpenAI Chat Model node to use a different model (e.g., gpt-3.5-turbo).

Who is this for? This workflow is ideal for individuals focused on nutrition tracking, meal planning, or diet optimization—whether you’re a health-conscious individual, fitness coach, or developer working on a healthtech app. It also fits well for anyone who wants to capture their meal data via voice or text, without manually entering everything into a spreadsheet. What problem is this workflow solving? Manually logging meals and breaking down their nutritional content is time-consuming and often skipped. This workflow automates that process using Telegram for input, OpenAI for natural language understanding, and Google Sheets for structured tracking. It enables users to record meals by typing or sending voice messages, which are transcribed, analyzed for nutrients, and automatically stored for tracking and review. What this workflow does This n8n automation lets users send either a text or voice message to a Telegram bot describing their meal. The workflow then: Receives the Telegram message Checks if it’s a voice message • If yes: Downloads the audio file and transcribes it using OpenAI • If no: Uses the text input directly Sends the meal description to OpenAI to extract a structured list of ingredients and nutritional details Parses and stores the results in Google Sheets Responds via Telegram with a personalized confirmation message A testing interface also allows you to simulate prompts and view structured outputs for development or debugging. Setup Create a Telegram bot via BotFather and note the API token. Create an empty Google Sheet and store the sheet ID in the environment. Set up your OpenAI credentials in the n8n credential manager. Customize the “List of Ingredients and Nutrients” node with your prompt if needed. (Optional) Use the “Testing” section to simulate messages and refine outputs before going live. How to customize this workflow to your needs • Enhance prompts in the OpenAI node to improve the structure and accuracy of responses. • Add new fields in the Google Sheet and corresponding logic in the parser if you want more detail. • Adjust the Telegram response to provide motivational feedback, dietary tips, or summaries. • Upgrade to the “Pro” version mentioned in the contact section for USDA database integration and complete nutrient breakdowns. This is a lightweight, AI-powered meal logging automation that transforms voice or text into actionable nutrition data—perfect for making healthy eating easier and more data-driven.

Who is this for? This template is ideal for B2B founders, solopreneurs, growth marketers, SDRs, or anyone looking to scale their lead generation and enrichment with no-code tools to low-code tools. Whether you're building your first lead pipeline or upgrading a manual spreadsheet, LeadAIgen automates the entire discovery → enrichment → logging process using AI and verified email data. What problem does this solve? Lead sourcing and enrichment are time-consuming, inconsistent, and often require multiple tools or manual scraping. This workflow solves that by chaining AI + contact discovery, validating everything, and storing clean, structured data in Google Sheets — ready for outreach or CRM sync. What this workflow does: ✅ Accepts an industry/topic prompt via chat trigger or Telegram, 🤖 Uses OpenRouter (Perplexity) to find 15 relevant companies with domains, 📤 Parses the results, filters duplicates based on your Google Sheet, 📩 Enriches each domain with up to 3 real personal emails using Hunter.io, 💡 If no emails found → Fallback AI tries to locate general email info, 📊 Updates your Google Sheet with all valid enriched leads (status: “Enriched”), 🔁 Runs in safe batches of 10 to protect your API limits, 🛠️ Includes logic to clean data, validate JSON, and slice leads. Setup: Create Google Sheets, Hunter.io, and OpenRouter credentials in your n8n instance Import the JSON workflow Set your OpenRouter model (default = Perplexity Sonar Large) Connect your Google Sheet (must contain a header row with Domain, Status, etc.) Paste your Hunter API key into the Hunter.io node (Optional) Add Telegram Bot trigger to chat with your lead generator 🗒 Color-coded workflow notes: To make customization easier, this template includes Innovatio's signature visual sticky note system inside the n8n canvas. You’ll find: 🟩 Green Notes → Main Steps The core logic blocks — from company generation to AI fallback and Google Sheets update. 🟦 Blue Notes → Personalization Tips How to adapt filters, prompts, and data mappings for your business needs. 🟨 Yellow Notes → Optional / Advanced Expand with Telegram chat triggers, Airtable integration, CRM push, or lead scoring logic. 🟫 Gray Notes → Welcome, Outro & Upgrade Suggestions Clear guidance and CTAs if you want help scaling this further. 👉 Each node includes comments or setup notes so you can learn the system as you use it. How to customize this workflow? 🎯 Swap Google Sheets for Airtable for relational views and tagging, 🤖 Replace Perplexity with GPT-4, Claude, or Mixtral inside OpenRouter, 📬 Auto-send enriched leads to Gmail, Slack, or your CRM, 🗣️ Connect this to Telegram for on-the-go company generation, 🔁 Want dynamic lead scoring or auto-categorization? We can help — [email protected] Final notes This template was designed by Velebit from Innovatio. External links (e.g. documentation or support email) lead only to official sources with no affiliate tracking or paid placements. A separate license applies to the paid version on Gumroad, which includes commercial use rights, extended fallback logic, and advanced upgrade tips.