{"product_id":"n8n-telegram-to-notion-google-sheets-gemini-client-updates","title":"n8n Telegram to Notion \u0026 Google Sheets: Gemini Client Updates","description":"\u003ch3\u003eSend a project update in Telegram—get an accurate Notion timeline entry, a Google Sheets audit log, and a daily Gemini-powered brief\u003c\/h3\u003e\n\n\u003cp\u003eThis n8n workflow turns freelancer progress messages from \u003cstrong\u003eTelegram\u003c\/strong\u003e into structured updates using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, matches them to the right client in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e roster, and appends the result to a \u003cstrong\u003eNotion\u003c\/strong\u003e project timeline. If attachments are included, it can also archive them in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, then logs everything and confirms back in Telegram. Every day at \u003cstrong\u003e08:00\u003c\/strong\u003e, it sends a single-message digest to Telegram enriched with \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e context.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram trigger:\u003c\/strong\u003e When you send a message to the configured bot, the workflow starts automatically.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtract structured update with Gemini:\u003c\/strong\u003e Google Gemini parses the message text into a structured payload (client hint, status, blocker, deadline, and summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatch client from Google Sheets:\u003c\/strong\u003e The workflow reads the active client roster from Google Sheets and uses Gemini to match the client hint to a single client with a confidence score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSafe confirmation when uncertain:\u003c\/strong\u003e If confidence is below the threshold, it asks you to confirm the client \u003cem\u003eand does not log anything\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite to Notion:\u003c\/strong\u003e On confident matches, it appends a normalized timeline entry to the target Notion block.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional attachment archive:\u003c\/strong\u003e If the Telegram message includes a file or photo, it downloads it and uploads it to a Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudit + notifications:\u003c\/strong\u003e It appends an audit row to Google Sheets, sends a Telegram confirmation, and sends an error message to Telegram if the Notion write fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily digest at 08:00:\u003c\/strong\u003e Fetches upcoming Google Calendar events and recent Google Sheets log entries, has Gemini write a short morning brief, and sends it to Telegram as one message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFreelancers send weekly status notes via Telegram; updates land instantly in Notion.\u003c\/li\u003e\n  \u003cli\u003eOperations teams track blockers and deadlines with an audit trail in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAttach screenshots or files in Telegram and automatically archive them in Google Drive.\u003c\/li\u003e\n  \u003cli\u003eMorning team check-ins via a Telegram digest combining Calendar + recent activity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Telegram, Notion, Google Sheets, Google Drive, Google Calendar, Google Gemini.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow components\/nodes:\u003c\/strong\u003e if, code, merge, notion, telegram, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSet up\u003c\/strong\u003e: Configure Telegram Bot API credentials and connect the required Google + Notion credentials, then point the workflow at your Notion block, Google Sheets roster, and Drive folder for optional attachment storage.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876871037107,"sku":"N8N-18509","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/OCADKku5IuQQL4-zkZM4Y_w2xeY2aE.png?v=1787303498","url":"https:\/\/buyflowscripts.com\/products\/n8n-telegram-to-notion-google-sheets-gemini-client-updates","provider":"N8N Commerce","version":"1.0","type":"link"}