Automated tech news report by ApiFlash, Gemini Vision & Sheets to Telegram
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 15 nodes and runs on a schedule (every day). Along the way it connects Google Gemini, Telegram and Google Sheets.
How it runs
Trigger: On a schedule (every day).
- HTTP Request: calls an HTTP API
- Analyze image (Google Gemini): uses Google Gemini
- Send a photo message (Telegram): uses Telegram
- Code: runs custom JavaScript code
- Split Out: splits a list into separate items
- Append row in sheet (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Read entire Sheet (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Edit Fields (Edit Fields (Set)): sets or maps fields
…plus 4 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 (11)
- HTTP Request
n8n-nodes-base.httpRequest - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Telegram
n8n-nodes-base.telegram - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
📸 What this workflow does Automatically captures a screenshot of a tech news homepage, extracts headlines into structured JSON, logs them in Google Sheets, and posts a daily trend report (7–10 bullet points) to Telegram at 07:00. Details: - ApiFlash takes a…