HumationHuman + Automation
Back to Catalog

One-way sync between Telegram, Notion, Google Drive, and Google Sheets

Lakshit UkaniLakshit Ukani
9740 views
2/3/2026
Exchange RatesExternal ServiceData FetchingHTTP RequestAPI Integration
Official Page

One-way sync between Telegram, Notion, Google Drive, and Google Sheets

Who is this for?

This workflow is perfect for productivity-focused teams, remote workers, virtual assistants, and digital knowledge managers who receive documents, images, or notes through Telegram and want to automatically organize and store them in Notion, Google Drive, and Google Sheets—without any manual work.

What problem is this workflow solving?

Managing Telegram messages and media manually across different tools like Notion, Drive, and Sheets can be tedious. This workflow automates the classification and storage of incoming Telegram content, whether it’s a text note, an image, or a document. It saves time, reduces human error, and ensures that media is stored in the right place with metadata tracking.

What this workflow does

  • Triggers on a new Telegram message using the Telegram Trigger node.
  • Classifies the message type using a Switch node:
    • Text messages are appended to a Notion block.
    • Images are converted to base64, uploaded to imgbb, and then added to Notion as toggle-image blocks.
    • Documents are downloaded, uploaded to Google Drive, and the metadata is logged in Google Sheets.
  • Sends a completion confirmation back to the original Telegram chat.

Setup

  1. Telegram Bot: Set up a bot and get the API token.
  2. Notion Integration:
    • Share access to your target Notion page/block.
    • Use the Notion API credentials and block ID where content should be appended.
  3. Google Drive & Sheets:
    • Connect the relevant accounts.
    • Select the destination folder and spreadsheet.
  4. imgbb API: Obtain a free API key from imgbb.

Replace placeholder credential IDs and asset URLs as needed in the imported workflow.

How to customize this workflow to your needs

  • Change Storage Locations:
    • Update the Notion block ID or Google Drive folder ID.
    • Switch Google Sheet to log in a different file or sheet.
  • Add More Filters:
    • Use additional Switch rules to handle other Telegram message types (like videos or voice messages).
  • Modify Response Message:
    • Personalize the Telegram confirmation text based on the file type or sender.
  • Use a different image hosting service if you don’t want to use imgbb.

n8n Telegram to Google Sheets and Google Drive Workflow

This n8n workflow automates the process of receiving messages via Telegram, extracting any attached files, uploading them to Google Drive, and logging the message details to Google Sheets. It also includes a Notion integration, though its specific function isn't detailed in the provided JSON.

What it does

This workflow streamlines the handling of incoming Telegram messages, particularly those with attachments, by:

  1. Listening for Telegram Messages: It acts as a trigger, starting the workflow whenever a new message is received in a configured Telegram bot.
  2. Extracting File Data (if any): If the Telegram message contains a file, it attempts to extract the file's binary data.
  3. Uploading to Google Drive: Any extracted files are then uploaded to a specified folder in Google Drive.
  4. Logging to Google Sheets: The details of the Telegram message (and potentially file information) are appended as a new row to a Google Sheet.
  5. Notion Integration: The workflow includes a Notion node, indicating a potential integration with a Notion database or page, though the specific operation is not defined in the provided JSON.
  6. HTTP Request: An HTTP Request node is present, suggesting a call to an external API or service, but its configuration is not specified.
  7. Conditional Logic (Switch): A Switch node is included, which allows for branching logic based on conditions, but no connections are defined for it in the provided JSON.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running instance of n8n.
  • Telegram Bot Token: A Telegram bot configured with a token to receive messages.
  • Google Account: A Google account with access to Google Drive and Google Sheets.
  • Notion Integration: A Notion integration token and access to a Notion database/page (if the Notion node is to be used).
  • Credentials: Configured n8n credentials for Telegram, Google (OAuth for Drive and Sheets), and Notion.

Setup/Usage

  1. Import the Workflow:
    • Copy the provided JSON code.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the "Import from JSON" button and paste the workflow JSON.
  2. Configure Credentials:
    • Telegram Trigger: Configure your Telegram Bot credentials.
    • Google Drive: Configure your Google OAuth credentials for Google Drive.
    • Google Sheets: Configure your Google OAuth credentials for Google Sheets.
    • Notion: Configure your Notion API credentials.
  3. Customize Nodes:
    • Telegram Trigger: Ensure the trigger is set up to listen to the correct bot and events.
    • Google Drive: Specify the Google Drive folder ID where files should be uploaded.
    • Google Sheets: Specify the Spreadsheet ID and sheet name where data should be appended. Map the incoming Telegram message data to the columns in your Google Sheet.
    • Notion: Configure the specific Notion database or page you wish to interact with and the action to perform.
    • HTTP Request: If intended for use, configure the URL, method, headers, and body for your external API call.
    • Switch: If you intend to use conditional logic, connect the Switch node and define its conditions and output branches.
  4. Activate the Workflow: Once all credentials and node configurations are complete, activate the workflow to start processing Telegram messages.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619

Competitor intelligence agent: SERP monitoring + summary with Thordata + OpenAI

Who this is for? This workflow is designed for: Marketing analysts, SEO specialists, and content strategists who want automated intelligence on their online competitors. Growth teams that need quick insights from SERP (Search Engine Results Pages) without manual data scraping. Agencies managing multiple clients’ SEO presence and tracking competitive positioning in real-time. What problem is this workflow solving? Manual competitor research is time-consuming, fragmented, and often lacks actionable insights. This workflow automates the entire process by: Fetching SERP results from multiple search engines (Google, Bing, Yandex, DuckDuckGo) using Thordata’s Scraper API. Using OpenAI GPT-4.1-mini to analyze, summarize, and extract keyword opportunities, topic clusters, and competitor weaknesses. Producing structured, JSON-based insights ready for dashboards or reports. Essentially, it transforms raw SERP data into strategic marketing intelligence — saving hours of research time. What this workflow does Here’s a step-by-step overview of how the workflow operates: Step 1: Manual Trigger Initiates the process on demand when you click “Execute Workflow.” Step 2: Set the Input Query The “Set Input Fields” node defines your search query, such as: > “Top SEO strategies for e-commerce in 2025” Step 3: Multi-Engine SERP Fetching Four HTTP request tools send the query to Thordata Scraper API to retrieve results from: Google Bing Yandex DuckDuckGo Each uses Bearer Authentication configured via “Thordata SERP Bearer Auth Account.” Step 4: AI Agent Processing The LangChain AI Agent orchestrates the data flow, combining inputs and preparing them for structured analysis. Step 5: SEO Analysis The SEO Analyst node (powered by GPT-4.1-mini) parses SERP results into a structured schema, extracting: Competitor domains Page titles & content types Ranking positions Keyword overlaps Traffic share estimations Strengths and weaknesses Step 6: Summarization The Summarize the content node distills complex data into a concise executive summary using GPT-4.1-mini. Step 7: Keyword & Topic Extraction The Keyword and Topic Analysis node extracts: Primary and secondary keywords Topic clusters and content gaps SEO strength scores Competitor insights Step 8: Output Formatting The Structured Output Parser ensures results are clean, validated JSON objects for further integration (e.g., Google Sheets, Notion, or dashboards). Setup Prerequisites n8n Cloud or Self-Hosted instance Thordata Scraper API Key (for SERP data retrieval) OpenAI API Key (for GPT-based reasoning) Setup Steps Add Credentials Go to Credentials → Add New → HTTP Bearer Auth* → Paste your Thordata API token. Add OpenAI API Credentials* for the GPT model. Import the Workflow Copy the provided JSON or upload it into your n8n instance. Set Input In the “Set the Input Fields” node, replace the example query with your desired topic, e.g.: “Google Search for Top SEO strategies for e-commerce in 2025” Execute Click “Execute Workflow” to run the analysis. How to customize this workflow to your needs Modify Search Query Change the search_query variable in the Set Node to any target keyword or topic. Change AI Model In the OpenAI Chat Model nodes, you can switch from gpt-4.1-mini to another model for better quality or lower cost. Extend Analysis Edit the JSON schema in the “Information Extractor” nodes to include: Sentiment analysis of top pages SERP volatility metrics Content freshness indicators Export Results Connect the output to: Google Sheets / Airtable for analytics Notion / Slack for team reporting Webhook / Database for automated storage Summary This workflow creates an AI-powered Competitor Intelligence System inside n8n by blending: Real-time SERP scraping (Thordata) Automated AI reasoning (OpenAI GPT-4.1-mini) Structured data extraction (LangChain Information Extractors)

Ranjan DailataBy Ranjan Dailata
632