{"product_id":"n8n-g2-reviews-to-google-sheets-apify-weekly-tracker","title":"n8n G2 Reviews to Google Sheets (Apify) Weekly Tracker","description":"\u003ch3\u003eTurn fresh G2 reviews into a weekly Google Sheets tracker—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls new \u003cstrong\u003eG2 product reviews every week\u003c\/strong\u003e and appends them as rows in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including the reviewer’s \u003cem\u003epros\u003c\/em\u003e, \u003cem\u003econs\u003c\/em\u003e, role, company size, rating (when present), publish date, and a link to each review. No AI, no ScrapingBee, no Bright Data—just an Apify-powered review fetch.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your monitoring list\u003c\/strong\u003e: uses a \u003ccode\u003eproductUrls\u003c\/code\u003e array and a \u003ccode\u003emaxReviewsPerProduct\u003c\/code\u003e setting to determine which G2 review pages to track.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches reviews via Apify\u003c\/strong\u003e: calls the Apify actor \u003cstrong\u003ejohnvc~g2-reviews-api\u003c\/strong\u003e to retrieve recent reviews for each listed product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps only real review items\u003c\/strong\u003e: filters results so only entries that are actual reviews remain.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats for spreadsheet readability\u003c\/strong\u003e: converts each review into a \u003cstrong\u003esingle Google Sheets row\u003c\/strong\u003e, including:\n    \u003cul\u003e\n      \u003cli\u003eweek-of date\u003c\/li\u003e\n      \u003cli\u003eproduct and rating (when present)\u003c\/li\u003e\n      \u003cli\u003epros\/cons in the reviewer’s own words\u003c\/li\u003e\n      \u003cli\u003ereviewer role, company size, publish date\u003c\/li\u003e\n      \u003cli\u003ereview link and review ID\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows\u003c\/strong\u003e into your chosen spreadsheet document ID and sheet tab, truncating long text to fit cells.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams track what customers praise vs. criticize on G2 and monitor trends week over week.\u003c\/li\u003e\n  \u003cli\u003eProduct managers build a continuous “voice of customer” log directly in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers set up a repeatable \u003cstrong\u003en8n + Google Sheets\u003c\/strong\u003e reporting workflow for review intelligence.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled trigger\u003c\/strong\u003e: Monday 08:00\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: Apify node using an \u003cstrong\u003eApify API token\u003c\/strong\u003e credential\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used in the workflow\u003c\/strong\u003e: \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003ccode\u003eapify\u003c\/code\u003e (\u003ccode\u003en8n-nodes-apify\u003c\/code\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eRequirements:\u003c\/strong\u003e an \u003cstrong\u003eApify account\u003c\/strong\u003e (free tier supported), a \u003cstrong\u003eGoogle account\u003c\/strong\u003e for Sheets, and updating the \u003ccode\u003eproductUrls\u003c\/code\u003e list and \u003ccode\u003emaxReviewsPerProduct\u003c\/code\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748944175283,"sku":"N8N-17701","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/IWsVLfte-OmG1LCVFAYh2_ylPAhxQD.png?v=1785575153","url":"https:\/\/buyflowscripts.com\/products\/n8n-g2-reviews-to-google-sheets-apify-weekly-tracker","provider":"N8N Commerce","version":"1.0","type":"link"}