What it does
Drafts a polite, specific reply to each customer review in your sheet (columns: platform, review_id, reviewer, rating, review_text, optional product) and queues it for your approval: the results sheet has draft_reply, sentiment, a follow-up flag and approval = pending, and it can also post each draft to Slack for review. Nothing is posted to the review site. Rows drafted in an earlier run are skipped. Needs a plan with AI included.
How it works
- Decides what to do next
- Asks AI
- Sends a chat message
All 10 steps (as they appear in the app)
- If review_text empty
- Drop row: no review text
- _key = {{platform}}|{{review_id}}|{{reviewer}}|{{review_text}}
- If _key seen in past runs
- Stop row: already drafted in an earlier run
- Ask AI → draft_reply, sentiment, needs_follow_up, follow_up_reason
- approval = pending
- drafted_at = {{now}}
- If slack_preview equals yes
- Slack: Draft reply for {{reviewer}} ({{rating}}★ on {{pla
Sample data included
The template comes with sample rows like these, so you can see it work before using your own list.
| platform | review_id | reviewer | rating | product | review_text |
|---|---|---|---|---|---|
| g-1 | Priya | 5 | Best flat white in town and the staff remembered my name! | ||
| Yelp | y-7 | Tom | 2 | Delivery | Order arrived 40 minutes late and the pastry was squashed. |
Get this template
1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.
Download Develofly Autopilot2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).
Open in AutopilotWhat you need
- AI: a plan with AI included, or your own AI key
- A spreadsheet (CSV or Excel) — a sample is included
You fill in: Business name, Tone, Sign-off, Where unhappy customers can reach you, Longest reply (words), Also post each draft to Slack.
Make it yours
Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.