{"product_id":"automate-weekly-glassdoor-reviews-to-google-sheets-with-apify-n8n","title":"Automate Weekly Glassdoor Reviews to Google Sheets with Apify \u0026 n8n","description":"\u003ch3\u003eAutomatically collect fresh Glassdoor reviews every week and log them in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday morning to fetch recent Glassdoor reviews via Apify and append ratings, pros\/cons, and category scores into your selected Google Sheets tab—so you can track company sentiment without manual copy-paste.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eScheduled execution:\u003c\/strong\u003e Uses a schedule trigger to run every Monday morning.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eFetch reviews from Glassdoor pages:\u003c\/strong\u003e Sends your list of company Glassdoor review URLs to Apify’s \u003cem\u003eGlassdoor Reviews API\u003c\/em\u003e actor.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003ePull recent activity:\u003c\/strong\u003e Retrieves up to \u003cstrong\u003e25 reviews per company\u003c\/strong\u003e from the \u003cstrong\u003elast 7 days\u003c\/strong\u003e (configurable via “days” and “maxReviewsPerCompany”).\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eKeep only actual review records:\u003c\/strong\u003e Filters the returned dataset to ensure only real review items are processed.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eExtract key review fields:\u003c\/strong\u003e Formats and captures company name, publish date, overall rating, review summary, pros, cons, category ratings, and the review URL.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eAppend to Google Sheets:\u003c\/strong\u003e Adds each prepared review as a new row in the chosen spreadsheet document and sheet tab.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eTalent \u0026amp; employer branding tracking:\u003c\/strong\u003e Monitor week-over-week changes in Glassdoor ratings and review themes for multiple companies.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eSaaS ops \u0026amp; competitive insights:\u003c\/strong\u003e Centralize review signals from specific Glassdoor company pages for reporting in Google Sheets.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Use a ready-made n8n pipeline pattern for scheduled web data collection + Google Sheets logging.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003en8n nodes\/integrations:\u003c\/strong\u003e \u003cem\u003eSchedule Trigger\u003c\/em\u003e, \u003cem\u003eApify\u003c\/em\u003e (via \u003ccode\u003eapify\u003c\/code\u003e node: \u003ccode\u003en8n-nodes-apify\u003c\/code\u003e), \u003cem\u003eGoogle Sheets\u003c\/em\u003e.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eCore logic nodes:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e and \u003cem\u003efilter\u003c\/em\u003e to prepare and retain only valid review records.\u003c\/p\u003e\u003c\/li\u003e\n  \u003cli\u003e\u003cp\u003e\u003cstrong\u003eCredentials \u0026amp; configuration:\u003c\/strong\u003e Add your \u003cstrong\u003eApify API token\u003c\/strong\u003e as an Apify credential in n8n; set Google Sheets credentials and choose the spreadsheet + tab; replace the example Glassdoor URLs with the companies you want to monitor.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45726236180659,"sku":"N8N-17480","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9cTfTo9VAh6nOf3u6KkmR_HwIdxzII.png?v=1785056658","url":"https:\/\/buyflowscripts.com\/products\/automate-weekly-glassdoor-reviews-to-google-sheets-with-apify-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}