Searches the last day's news for your brand and people, archives what it finds and posts a round-up to Slack.
Uses
Claude
Google Sheets
Serper
Slack
Get a daily round-up of your press coverage in Slack
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 searchErrorTry
Trim term and save it as cleanTerm.Trim term and save it as cleanTerm.
If cleanTerm isn't emptyIf cleanTerm isn't emptyYes
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 articleErrorTry
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 emptyYes
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 emptyYes
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 summaryErrorTry
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: 400Trim 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
coverageOn error
SlackSend a message to slackChannelId.Send a message to slackChannelId.*Coverage round-up* (the length of found as text)
_Summary unavailable today._
coverage