Daily news digest from your sheet
Every morning, has Claude pick the ten best stories logged in your news sheet, emails them to you with links, and clears the sheet.
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.
- 1Google SheetsRead rowsReads every story logged in the news tab since the last digest, one row per story.
- 2AnthropicGenerate model responseAsks the AI to pick the stories most worth reading by number, then to write the plain text email that delivers them.
- 3GmailSendSends the finished digest to your inbox, or a short note when the news tab held nothing since the last digest.
- 4Google SheetsGet row valuesReads the header row of the news tab before clearing, so it can be written back afterwards.
- 5Google SheetsClear tabClears the news tab once the digest has been sent, so tomorrow's digest starts from fresh stories.
- 6Google SheetsWrite rowWrites the saved header row back into row one of the cleared tab so logging can carry on.
How it works
What happens on each run, in plain English.
Every morning at 08:00, the stories another workflow has been logging into your news sheet are read, the ones most worth your time are chosen by AI against the interests you describe, and one plain text email with a summary and link for each lands in your inbox. Once it has gone, the tab is cleared so tomorrow's digest starts from tomorrow's stories.
Every headline and link in the email is looked up in the sheet itself, so nothing in your inbox is invented. If the tab is empty you still get an email saying so, because that usually means whatever fills it has stopped. If the sheet cannot be read, the ranking cannot be understood or the email cannot be sent, the run stops and the sheet is left untouched, so nothing is lost. The tab is cleared only after the email has been sent, and its header row is put back so logging can carry on.
Any columns will do in the news tab, though a title, a link and a summary make for a better digest.
You May Also Be Interested In
Send a topic to Telegram, get an illustrated bedtime storyMessage a topic to your Telegram chat and get back a gentle bedtime story written for your child, with a picture to go with it.Message a description, get a picture back in TelegramSend your Telegram bot a description and it draws that picture and sends it back to the same chat.LinkedIn content idea generatorEvery 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.
Start from a workflow that already works.
Add "Daily news digest from your sheet" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required