Weekly employee feedback digest
Every Monday, the week's feedback form responses summarized for HR and emailed, then cleared from 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 the waiting form responses from your feedback tab, then rereads it before deleting so rows are matched by content.
- 2AnthropicGenerate model responseAsks the AI to write the digest from the allowed columns only, escalations first and no totals of its own.
- 3GmailSendEmails the digest to HR with the date in the subject and the counts computed from the sheet underneath.
If
deleteAfterSendingFor each
rowNumber- 4Google SheetsDelete rowDeletes each row the digest covered, bottom up, only after the email has gone and the row still matches.
- 4
How it works
What happens on each run, in plain English.
Every Monday at 10:00, the feedback your form has collected in a Google Sheet is read, summarised by AI into a digest HR and managers can act on, and emailed to the people you choose. Only then are the rows it covered cleared from the sheet, so the next week starts empty.
You get one email with the week's themes, and anything that reads like harassment, discrimination, a safety problem or a person in real distress goes into a 'Needs attention now' section at the top instead of being averaged into a theme. The counts come from the sheet, not the AI, and only the feedback columns you name are ever sent to it, so a name or email column is never read. Rows are deleted only after the email has gone, and only the rows the digest covered: a row edited or moved in the meantime is left alone and turns up next week.
Clearing the sheet can be switched off if you must retain responses; the digest still goes out.
You May Also Be Interested In
Monthly P&L report for each cost centerOn the 3rd of each month, turns last month's transactions in your sheet into a P&L for each cost center, with AI commentary.
Parse emailed CVs into a talent sheetReads each job application that lands in Gmail, adds the candidate's details as a row in your Google Sheet and tells your team in Slack.Weekly revenue up-or-down emailEvery Monday, totals last week's revenue from your sheet, says if it is up or down on the week before, and explains a rise.
Weekly chart of how a metric has movedEvery Monday, charts the recent history of one metric from your sheet and emails you the chart with a note on what changed.
Start from a workflow that already works.
Add "Weekly employee feedback digest" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required