Daily industry news digest to Slack with a Google Sheets archive
Every weekday at 8am, post the day's top 10 industry headlines to Slack and log every story to a Google Sheet so you build a searchable archive.
Real-Time News Data
Slack Bot
Google SheetsPersonal ProductivityOperationsDaily DigestsResearch & MonitoringNotifications & AlertsBuild me a deterministic daily industry-news digest workflow. No AI summarization or judgement: it is a fixed pipeline with three known steps, and the value is the consistent daily snapshot plus a growing searchable archive.
Trigger: cron, every weekday (Monday through Friday) at 8:00 AM in my local timezone. Expose the cron expression and topic/country/channel/spreadsheet as configurable inputs so I can tweak them after the workflow is created.
Step 1 — fetch headlines. Call Real-Time News Data's Topic Headlines operation with a configured topic (default TECHNOLOGY, but allow any of the standard enums: WORLD, NATIONAL, BUSINESS, TECHNOLOGY, ENTERTAINMENT, SPORTS, SCIENCE, HEALTH), a configured country code (default us), language en, and limit 10. Keep the top 10 stories as the working list.
Step 2 — post to Slack. Use the Slack Bot integration's Send a Message operation to post one message to a configured channel. The message should be a single chunk of mrkdwn that starts with a date header (for example, *Daily TECHNOLOGY Headlines — Wed, Jun 24 2026*), then a bulleted list of the 10 stories formatted as `• <link|Headline> — Publisher`. Use Slack's `<url|text>` link syntax, not standard Markdown. If a publisher name is missing, fall back to the source domain.
Step 3 — append to Google Sheets. Use the Append Values operation to append one row per headline to a configured spreadsheet and sheet tab (default tab name: Headlines). Columns, in order: run_date (ISO date in my timezone), topic, rank (1 through 10), headline, publisher, url, published_at (ISO timestamp from the article). Use valueInputOption USER_ENTERED so dates and links render nicely. Append all 10 rows in a single call.
Error handling: if the news call returns fewer than 10 stories, post and log whatever we got and add a small note at the bottom of the Slack message saying how many were returned. If the Slack post fails, still try the Sheets append so the archive is never silently skipped. If the Sheets append fails, post a short follow-up Slack message saying the archive write failed so I notice. Do not retry the news call within a single run.
Integrations to use: real-time-news-data (Topic Headlines), slackbot (Send a Message), google-sheets (Append Values). Workflow type: code (discrete nodes, deterministic flow, no agent reasoning between steps).
What does this prompt do?
- Posts a clean, dated list of the top 10 industry headlines to your chosen Slack channel every weekday morning.
- Logs every single headline to a Google Sheet, one row per story, with date, topic, rank, publisher, link, and publish time.
- Builds a permanent searchable archive of your industry's news over weeks and months for trend lookups and recall.
- Runs on a fixed schedule with the same steps every day, so the digest looks the same on Monday as it does six months later.
What do I need to use this?
- A Slack workspace where the General Input bot can post to your chosen news channel.
- A Google account with edit access to the spreadsheet that will hold your headline archive.
- A Real-Time News Data account (free Basic plan is fine) to fetch the headlines.
- A topic to follow (Technology, Business, World, Sports, Science, Health, or another preset) and a country code.
How can I customize it?
- Change the time, days, or timezone the digest runs (for example, 7am ET Monday through Friday, or every day at 9am UK time).
- Swap the topic, country, or number of headlines (top 5 instead of top 10) to match what your team actually cares about.
- Pick a different Slack channel, post to multiple channels, or send it as a DM to yourself instead.
- Add extra spreadsheet columns (your own notes, a read or unread flag, a category tag) without breaking the daily append.
FAQs
Does this use AI to summarize the news?
What topics can I follow?
How do I change which Slack channel it posts to?
What happens to the spreadsheet over time?
Can I run it on weekends or change the time?
Related templates
When someone leaves, we check which shared passwords they used in their final months and post a ranked rotation list to your security channel.
Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.
Twice every weekday, the conversations from your social inbox land on the right HubSpot contact timelines, with a Slack recap for sales.
Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.
Every morning, find the addresses that hard bounced or filed a spam complaint, update the matching HubSpot contacts, and post a short Slack recap.
Every weekday at 4pm, spot the threads that went quiet, stage a ready-to-send nudge in your mailbox, and get a ranked Slack recap.
Never miss a beat in your industry.
Connect Slack, Google Sheets, and Real-Time News Data once, and Geni delivers a fresh top 10 digest every weekday morning while quietly building your archive.