Back to Templates

Automated Tech News Report by ApiFlash, Gemini Vision & Sheets to Telegram

Created by

Created by: Cong Nguyen || cong-nguyen

Cong Nguyen

Last update

Last update 21 days ago

Share


📸 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 cropped full-page screenshot of technewsworld.com (configurable).
  • Gemini Vision analyzes the image and returns one strict JSON object (captured_at, source, sentiment, items[]).
  • Code node cleans and parses JSON (removes code fences).
  • Google Sheets stores each headline (headline, topic, highlight, sentiment).
  • Last 3 days of entries (max 30) are aggregated.
  • Gemini writes a concise Trend Report.
  • Telegram sends both the screenshot and the summary.

👤 Who it’s for

  • Editors and creators wanting automated daily news briefs.
  • Marketing/analyst teams logging tech trends.
  • Founders/PMs who want quick morning updates via Telegram.

✅ Requirements

  • n8n (self-hosted or cloud).
  • Accounts/credentials: ApiFlash (API key), Google Gemini, Google Sheets OAuth2, Telegram Bot.
  • A Google Sheet with columns: captured_at, source, sentiment, main_headlines, topics, highlights.

⚙️ Setup

  • Import the workflow JSON into n8n.
  • Configure ApiFlash node with your access key and target URL.
  • Set Telegram Bot credentials and chatId.
  • Connect Google Sheets OAuth2 and specify documentId/sheetName.
  • Use Gemini (gemini-1.5-flash) for JSON extraction and trend reporting.
  • Adjust schedule (default 07:00).
  • Test: verify JSON parse → Sheet row → trend report → Telegram message.

💡 About Margin AI

Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development.