Cong Nguyen This workflow corresponds to n8n.io template #8291 — we link there as the canonical source.
This workflow follows the Googlegemini → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "7b30536c-cfcb-4571-88e1-3ad6ba493496",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
208,
0
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2eed1a6d-8758-43f5-a02f-8771bc0eff16",
"name": "Analyze image",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
416,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6abd306b-2eb0-4cdc-aa6b-d285857a8019",
"name": "Send a photo message",
"type": "n8n-nodes-base.telegram",
"position": [
416,
-192
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "daf214ad-3b49-4b21-acc1-a9212c414efb",
"name": "Send a text message",
"type": "n8n-nodes-base.telegram",
"position": [
976,
480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f5613c28-0ab6-49f4-b7e8-d355e7e30a24",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-624,
192
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c5901a0-1d73-4931-8cf8-d2eefe2ff115",
"name": "Read entire Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1472,
0
],
"parameters": {},
"typeVersion": 4
},
{
"id": "740ade70-af43-4c5c-8cd9-9cc2e8eaed66",
"name": "AI Trend Report",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
656,
480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d74f5e6d-b1d5-4229-90ff-de65ba94ca96",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
624,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a9247b68-e3a4-4fa4-b9d2-44513b28a733",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
832,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "efd2abec-3d89-4fb9-9e33-c405cb0fa96a",
"name": "Append row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
0
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "f6b65a80-d2fa-4984-a206-83d04352dd09",
"name": "Aggregate",
"type": "n8n-nodes-base.aggregate",
"position": [
1248,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e5d4cb55-1864-4157-9606-e4c0aacd42fc",
"name": "Aggregate1",
"type": "n8n-nodes-base.aggregate",
"position": [
1360,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "129d1d6c-275d-406f-b0b2-b241565c0151",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
848,
240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "983032fd-7557-4a61-9000-ad8eeeed10bb",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
640,
240
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "323a76a0-6e78-4128-b971-1a3603bc092d",
"name": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
1056,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e131e3e2-180d-4c65-9580-444a43cf158d",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7054fa99-84e0-408e-8990-489b39de027a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
192
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "83769ea5-b9ba-4355-ae8f-6c72b1dcd858",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-624,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Code": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Aggregate1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Read entire Sheet",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Aggregate1": {
"main": [
[
{
"node": "AI Trend Report",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Analyze image",
"type": "main",
"index": 0
},
{
"node": "Send a photo message",
"type": "main",
"index": 0
}
]
]
},
"Analyze image": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"AI Trend Report": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Read entire Sheet": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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.
Source: https://n8n.io/workflows/8291/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
AI Institutional Stock Valuation Engine with Risk Scoring & Scenario Targets
Overview This is a production-grade, fully automated stock analysis system built entirely in n8n. It combines institutional-level financial analysis, dual AI model consensus, and a self-improving back
A professional AI equity analysis automation built on n8n that transforms structured financial data and real-time news into disciplined, risk-adjusted price targets and actionable BUY/HOLD/SELL signal
This workflow is a complete outbound automation system that discovers local businesses, extracts contact emails, generates personalized cold emails using AI, and runs a multi-step follow-up sequence —
Takes a product image from Google Sheets, adds frozen effect with Gemini, generates ASMR video with Veo3, writes captions with GPT-4o, and posts to 4 platforms automatically. Schedule trigger picks fi