n8n G2 Reviews to Google Sheets (Apify) Weekly Tracker

Turn fresh G2 reviews into a weekly Google Sheets tracker—automatically

This n8n workflow pulls new G2 product reviews every week and appends them as rows in Google Sheets—including the reviewer’s pros, cons, 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.

What this workflow does

• Runs on a schedule: every Monday at 08:00.
• Loads your monitoring list: uses a productUrls array and a maxReviewsPerProduct setting to determine which G2 review pages to track.
• Fetches reviews via Apify: calls the Apify actor johnvc~g2-reviews-api to retrieve recent reviews for each listed product.
• Keeps only real review items: filters results so only entries that are actual reviews remain.
• Formats for spreadsheet readability: converts each review into a single Google Sheets row, including:
  • week-of date
  • product and rating (when present)
  • pros/cons in the reviewer’s own words
  • reviewer role, company size, publish date
  • review link and review ID
• Appends rows into your chosen spreadsheet document ID and sheet tab, truncating long text to fit cells.

Use cases

• SaaS marketing teams track what customers praise vs. criticize on G2 and monitor trends week over week.
• Product managers build a continuous “voice of customer” log directly in Google Sheets.
• Automation engineers set up a repeatable n8n + Google Sheets reporting workflow for review intelligence.

Technical details

• Scheduled trigger: Monday 08:00
• Apify integration: Apify node using an Apify API token credential
• Nodes used in the workflow: set, code, filter, sticky note, Google Sheets, and apify (n8n-nodes-apify)

Requirements: an Apify account (free tier supported), a Google account for Sheets, and updating the productUrls list and maxReviewsPerProduct.