Track competitor G2 reviews with Apify and Google Sheets
UnknownWhat this workflow does
This workflow has 6 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: On a schedule (every week at 08:00).
- Set the products to watch (Edit Fields (Set)): sets 2 fields: productUrls, maxReviewsPerProduct
- Fetch reviews for each product (Apify): run actor and get dataset (actors)
- Keep rows that are real reviews (Filter): keeps only the items that match a condition
- Shape review rows for the sheet (Code): runs custom JavaScript code
- Append this week's reviews (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Fetch reviews for each product).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview No ScrapingBee or Bright Data account and no AI model. This template pulls G2 reviews every week for the products you list and appends one row each to Google Sheets: the pros and cons in the reviewer's own words, their role, company size, and a…