Get a daily round-up of your press coverage in Slack

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.

Run every day.Run every day.

Set searchTerms to blank.Set searchTerms to blank.

Set slackChannelId to blank.Set slackChannelId to blank.

Set archiveUrl to blank.Set archiveUrl to blank.

Set archiveTab to Coverage.Set archiveTab to Coverage.

Set resultsPerTerm to 10.Set resultsPerTerm to 10.

Split searchTerms by a new line and save it as terms.Split searchTerms by a new line and save it as terms.

Set found to an empty list.Set found to an empty list.

For each term in terms:For each term in terms:

If a step below fails, save the error as searchErrorIf a step below fails, save the error as searchError

Try

Trim term and save it as cleanTerm.Trim term and save it as cleanTerm.

If cleanTerm isn't emptyIf cleanTerm isn't empty

Yes

SerperSearch Google News for cleanTerm. Save it as results.Search Google News for cleanTerm. Save it as results.

For each article in results.articles:For each article in results.articles:

If a step below fails, save the error as articleError If a step below fails, save the error as articleError

Try

Trim article.title and save it as headline.Trim article.title and save it as headline.

Trim article.link and save it as url.Trim article.link and save it as url.

If headline isn't empty and url isn't emptyIf headline isn't empty and url isn't empty

Yes

Set line to - headline (article.source) url.Set line to - headline (article.source) url.

Add line to the end of found and save it as found.Add line to the end of found and save it as found.

Google SheetsAdd a row to archiveTab in archiveUrl.Add a row to archiveTab in archiveUrl.

No

No steps

On error

Show in the output: Skipped an article for cleanTerm: articleError as text.Show in the output: Skipped an article for cleanTerm: articleError as text.

No

No steps

On error

Show in the output: Could not search for a term: searchError as text.Show in the output: Could not search for a term: searchError as text.

If found is emptyIf found is empty

Yes

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Coverage round-up* Nothing new in the last day.

No

Join found with a new line and save it as coverage.Join found with a new line and save it as coverage.

If a step below fails, save the error as summaryErrorIf a step below fails, save the error as summaryError

Try

ClaudeAsk Claude: 'Below is today's press coverage. Write two or three sentences for a team channel: what the story is, whether the tone is positive, negative or neutral, and anything that looks like it needs a response today. Use only what is in the list - do not characterise an article beyond its headline, and do not speculate about why something was written.Ask Claude: 'Below is today's press coverage. Write two or three sentences for a team channel: what the story is, whether the tone is positive, negative or neutral, and anything that looks like it needs a response today. Use only what is in the list - do not characterise an article beyond its headline, and do not speculate about why something was written. coverage'. Save it as written. Maximum response length: 400

Trim written.response_text and save it as summary.Trim written.response_text and save it as summary.

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Coverage round-up* (the length of found as text) summary coverage

On error

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Coverage round-up* (the length of found as text) _Summary unavailable today._ coverage