{"product_id":"n8n-workflow-weekly-app-store-review-scorecards-in-google-sheets","title":"n8n Workflow: Weekly App Store Review Scorecards in Google Sheets","description":"\u003ch3\u003eWeekly App Store Review Scorecards — Automatically Logged to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday to pull the latest Apple App Store reviews for your tracked apps via \u003cstrong\u003eApify\u003c\/strong\u003e, then logs raw reviews into Google Sheets and generates a weekly per-app \u003cstrong\u003erating scorecard\u003c\/strong\u003e (average, count, min\/max, critical share, and versions seen).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules weekly:\u003c\/strong\u003e The workflow is set to run every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads what to track:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches reviews using Apify:\u003c\/strong\u003e It uses the \u003cstrong\u003eApify apple-app-store-reviews-api\u003c\/strong\u003e actor to retrieve the most recent App Store reviews for each configured app.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and structures review data:\u003c\/strong\u003e 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 \u003cstrong\u003ecritical\u003c\/strong\u003e flag for \u003cstrong\u003e1–2 star ratings\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends review history:\u003c\/strong\u003e The workflow appends the full review rows into Google Sheets (the “history” tab) to build an ongoing log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds weekly scorecards:\u003c\/strong\u003e 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).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack weekly sentiment trends for multiple iOS apps without manual scraping.\u003c\/li\u003e\n  \u003cli\u003eMonitor critical review share (1–2 stars) to spot potential release issues early.\u003c\/li\u003e\n  \u003cli\u003eReport app quality metrics to stakeholders using Google Sheets as the single source of truth.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e n8n schedule to run every Monday.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Credentials:\u003c\/strong\u003e \u003cstrong\u003eApify\u003c\/strong\u003e (API token) + \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (history + scorecard append steps).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e set, code, slack, filter, split out, summarize.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional:\u003c\/strong\u003e The workflow can use the \u003cstrong\u003eSlack\u003c\/strong\u003e node to post the weekly scorecard (if you connect a Slack credential and channel).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45822095655091,"sku":"N8N-18069","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CsF3FZWJj_HLg1DmML-ZB_BUVnqUEh.png?v=1786526011","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-weekly-app-store-review-scorecards-in-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}