Using Zapier, find the new reviews on my Google Business Profile from the last 7 days. For each one, give me the star rating and one line on what the customer said. Show me the list, then wait for my OK before adding a row for each review to my Google Sheet called Reviews. Don't reply to any reviews.
This prompt finds your new Google Business Profile reviews from the last week, gives you the star rating and a one-line summary for each one and, once you approve, adds a row per review to a Google Sheet. It does not reply to any reviews.
Apps you need: Google Business Profile and Google Sheets, both connected to Zapier MCP
Good for: local businesses and anyone who tracks customer feedback
Make it yours
- Change
Reviewsto the name of your own sheet. - Ask for the sentiment as a column, like positive, neutral or negative.
- Run it weekly to build a running record of feedback.
Tried it on your own reviews? Share which columns you added, like sentiment or topic.
