Automate Weekly Glassdoor Reviews to Google Sheets with Apify & n8n

Automatically collect fresh Glassdoor reviews every week and log them in Google Sheets

This 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.

What this workflow does

• Scheduled execution: Uses a schedule trigger to run every Monday morning.

• Fetch reviews from Glassdoor pages: Sends your list of company Glassdoor review URLs to Apify’s Glassdoor Reviews API actor.

• Pull recent activity: Retrieves up to 25 reviews per company from the last 7 days (configurable via “days” and “maxReviewsPerCompany”).

• Keep only actual review records: Filters the returned dataset to ensure only real review items are processed.

• Extract key review fields: Formats and captures company name, publish date, overall rating, review summary, pros, cons, category ratings, and the review URL.

• Append to Google Sheets: Adds each prepared review as a new row in the chosen spreadsheet document and sheet tab.

Use cases

• Talent & employer branding tracking: Monitor week-over-week changes in Glassdoor ratings and review themes for multiple companies.

• SaaS ops & competitive insights: Centralize review signals from specific Glassdoor company pages for reporting in Google Sheets.

• Automation engineers: Use a ready-made n8n pipeline pattern for scheduled web data collection + Google Sheets logging.

Technical details

• n8n nodes/integrations: Schedule Trigger, Apify (via apify node: n8n-nodes-apify), Google Sheets.

• Core logic nodes: set and filter to prepare and retain only valid review records.

• Credentials & configuration: Add your Apify API token 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.