📸 What this workflow does
📸 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. An n8n automation workflow template by Cong Nguyen.
Cong Nguyen
web
paid
Others in the same category, ranked by how often they are opened.
