Get a daily round-up of your press coverage in Slack
Searches the last day's news for your brand and people, archives what it finds and posts a round-up to Slack.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
For each
termIf
cleanTermis not empty- 1SerperSearch newsSearches the past day's news for each term you list, so the same article is not reported again tomorrow.
For each
articleIf
headlineis not empty andurlis not empty- 2Google SheetsAppend rowArchives each article to the 'Coverage' tab as it is found, recording the time, search term, headline, source and link.
- 2
- 1
If
foundis empty- 3SlackSend messagePosts the day's headlines and links with the AI summary above them, or says plainly that nothing new appeared.
Otherwise
Try
- 4AnthropicGenerate model responseAsks the AI for two or three sentences on what the story is, the tone, and anything needing a response today.
- 5SlackSend message
If a step fails
- 6SlackSend message
- 4
- 3
How it works
What happens on each run, in plain English.
Every day, the workflow searches the last twenty-four hours of news for each term you watch: your brand, your products, the people who speak for you. Each article is archived to the 'Coverage' tab of your spreadsheet the moment it is found, then a round-up goes to Slack with a short read on the tone and anything that needs a response today.
The Slack post lists every headline with its source and link, topped by two or three AI-written sentences that work only from those headlines. Archiving happens before summarising, so a failure late in the run can cost you the commentary but never the record. If the summary cannot be written the links still go out with a note saying so, one failing search term does not cost the others their coverage, and on a quiet day you still get a post saying nothing new was found, so silence never looks like a breakage.
Before the first run you need a Slack channel and a spreadsheet with a 'Coverage' tab to archive into.
You may also be interested in
Get LinkedIn post ideas from the news in your sheetEvery morning, turns the news logged in your sheet into LinkedIn post ideas for your area of interest, emails them, and clears the sheet.
What your YouTube viewers are sayingSorts the comments on your latest videos into asks, praise and complaints, and emails the counts with real quotes.
Turn a list of image briefs into on-brand imagesGenerates an image for every brief in your sheet against your brand guidelines, files it in Box and links it back to the row.
Post a daily marketing meme to DiscordEvery day, AI picks a popular meme template, captions it on your topic and posts the finished meme to your Discord channel.Start from a workflow that already works.
Add "Get a daily round-up of your press coverage in Slack" to your workspace, connect its apps, and make it yours.
Free plan, no credit card