Log App Store reviews and build weekly scorecards with Apify and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets, Slack and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set the apps to watch (Edit Fields (Set)): sets 3 fields: apps, country, reviewsPerApp
- One lookup per app (Split Out): splits a list into separate items
- Fetch the latest reviews (Apify): run actor and get dataset (actors)
- Keep rows that are real reviews (Filter): keeps only the items that match a condition
- One row per review (Code): runs custom JavaScript code
- Summarize: summarizes / groups the items
- Append every review to the history (Google Sheets): append
- Shape the scorecard (Code): runs custom JavaScript code
- Append the weekly scorecard (Google Sheets): append
- Optional: only the critical reviews (Filter): keeps only the items that match a condition
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Fetch the latest reviews).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Summarize
n8n-nodes-base.summarize - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow runs every Monday, pulls the latest Apple App Store reviews for a list of apps using Apify, and logs them to Google Sheets while also generating a per-app weekly rating scorecard (average, count, min/max, critical share, and…