Monitor G2 competitors reviews [Google Sheets, ScrapingBee, Slack]
Needs changesWhat this workflow does
This workflow has 11 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets and Slack. It also calls app.scrapingbee.com over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00).
- Get all past reviews (Google Sheets): uses Google Sheets
- Add your competitors here (Code): runs custom JavaScript code
- Continue only if review is new (Merge): merges the data from its input branches
- Get G2 data with ScrapingBee (HTTP Request): calls app.scrapingbee.com
- Add new review to Google Sheets (Google Sheets): append
- Send new review to Slack (Slack): uses Slack
- Get review section HTML (HTML): parses or builds HTML
- Iterate on reviews (Item Lists): reshapes item lists (legacy Item Lists node)
- Extract structured data (HTML): parses or builds HTML
- Convert Review HTML to Markdown (Markdown): converts between Markdown and HTML
Services it uses
HTTP calls to: app.scrapingbee.com
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Iterate on reviews: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Iterate on reviews | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (9)
- Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Item Lists
n8n-nodes-base.itemLists - Markdown
n8n-nodes-base.markdown - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Slack
n8n-nodes-base.slack
From the author
This workflow monitor G2 reviews URLS. When a new review is published, it will: - trigger a Slack notification - record the review in Google Sheets To install it, you'll need: - access to Slack, Google Sheets and ScrapingBee Full guide here:…