n8n Workflow: Weekly App Store Review Scorecards in Google Sheets

Weekly App Store Review Scorecards — Automatically Logged to Google Sheets

This n8n workflow runs every Monday to pull the latest Apple App Store reviews for your tracked apps via Apify, then logs raw reviews into Google Sheets and generates a weekly per-app rating scorecard (average, count, min/max, critical share, and versions seen).

What this workflow does

• Schedules weekly: The workflow is set to run every Monday morning.
• Loads what to track: In the “Set the apps to watch” step, you configure App Store product IDs (and labels), the target country store, and how many recent reviews to fetch per app.
• Fetches reviews using Apify: It uses the Apify apple-app-store-reviews-api actor to retrieve the most recent App Store reviews for each configured app.
• Cleans and structures review data: It filters out any items that don’t contain a review ID, then formats the remaining results into one clean row per review, including a critical flag for 1–2 star ratings.
• Appends review history: The workflow appends the full review rows into Google Sheets (the “history” tab) to build an ongoing log.
• Builds weekly scorecards: It aggregates the same review rows by app to calculate weekly metrics and appends one scorecard row per app into a second Google Sheets tab (the “scorecard” tab).

Use cases

• Track weekly sentiment trends for multiple iOS apps without manual scraping.
• Monitor critical review share (1–2 stars) to spot potential release issues early.
• Report app quality metrics to stakeholders using Google Sheets as the single source of truth.

Technical details

• Scheduling: n8n schedule to run every Monday.
• Integrations/Credentials: Apify (API token) + Google Sheets (history + scorecard append steps).
• Nodes used: set, code, slack, filter, split out, summarize.
• Optional: The workflow can use the Slack node to post the weekly scorecard (if you connect a Slack credential and channel).