Log Telegram client updates to Notion and Google Sheets with Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 27 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Telegram, Google Gemini Chat Model, Google Sheets and Notion and 2 more.
How it runs
Trigger: On Telegram events (message) (plus 1 other trigger).
- Extract Client Update (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Model for Extraction; output parser: Parse Extracted Data
- Fetch Next 7 Days from Calendar (Google Calendar): get many
- Read Log Data from Sheets (Google Sheets): uses Google Sheets
- Read Active Clients from Sheets (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- Compile Client Roster (Code): runs custom JavaScript code
- Construct Brief Context (Code): runs custom JavaScript code
- Match Client with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Model for Matching; output parser: Parse Matching Results
- Generate Brief with Gemini (Basic LLM Chain): sends a prompt to an LLM, with model: Gemini Model for Briefing
- Check Confidence Level (If): checks a condition and branches into true / false
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram - Notion
n8n-nodes-base.notion - Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Calendar
n8n-nodes-base.googleCalendar - Merge
n8n-nodes-base.merge
From the author
Quick overview Youtube Video: https://youtu.be/kEumCSBunnM?si=AxpoxP8KLF2haz1X This workflow captures freelancer project updates from Telegram, uses Gemini to extract and match the client from a Sheets roster, appends the update to a Notion project timeline,…