n8n

How to Automate Slack and Sheets Review Tracking?

Stay on top of new product reviews without checking sites by hand. When a fresh review appears on selected pages, your team gets a Slack message and the record is saved to Google Sheets. Ideal for marketing and product teams that watch brand and competitor feedback.

A daily schedule starts the run at a set hour. A code step holds the list of competitor slugs to monitor. The HTTP Request step uses ScrapingBee to fetch each review page, and HTML steps extract the review cards and pull fields like date, rating, user profile link, and the review URL. The review body is converted from HTML to clean Markdown so messages are easy to read. Past entries are loaded from Google Sheets, and a merge step filters out anything already stored by matching the reviewUrl. Only unseen items continue to Slack and get added to the sheet.

Setup needs Slack, Google Sheets, and a ScrapingBee API key. Expect faster response to new feedback, fewer copy paste errors, and one place to keep history. Use it for competitor tracking, reputation monitoring, and collecting real quotes for marketing content.

What are the key features?

  • Daily schedule runs at a set time to keep updates regular
  • Competitor list is managed in a simple code node you can edit
  • Fetches review pages through ScrapingBee with a batch size of three
  • Parses review cards using CSS selectors to capture date, rating, body, profile link, and the review URL
  • Converts review HTML to Markdown for clean Slack messages
  • Loads past entries from Google Sheets and de duplicates by reviewUrl
  • Sends a Slack alert with rating, user profile link, and direct review link
  • Adds new reviews to Google Sheets for history and reporting

What are the benefits?

  • Reduce weekly review checks from 3 hours to 10 minutes
  • Automate about 80 percent of review monitoring work
  • Cut copy paste mistakes by 90 percent with one source of truth
  • Handle three competitor pages in parallel for faster runs
  • Connect Slack, Google Sheets, and ScrapingBee in one flow
  • Stop duplicates by matching reviewUrl before posting

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Slack, Google Sheets and ScrapingBee. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager or by double clicking the Slack node, create a new Slack credential. Use OAuth2, sign in to the correct workspace, and allow channel access. Name the credential clearly, for example Slack G2 Reviews.
  4. In the n8n credentials manager or by double clicking the Google Sheets nodes, create a new Google Sheets credential. Use OAuth2, sign in to the right Google account, and allow Sheets access. Name it clearly, for example Sheets Reviews Log.
  5. Get your ScrapingBee API key from your ScrapingBee dashboard. Open the HTTP Request node named Get G2 data with ScrapingBee and replace the api_key query parameter value YOUR_API_KEY with your real key.
  6. Open the Code node named Add your competitors here and update the list with the exact slugs used in each product review URL. Each item should match the path in the review page link.
  7. Prepare a Google Sheet with columns such as reviewUrl, rating, date, user_profile, and review. In the Get all past reviews node, point to this document and the correct sheet. In the Add new review to Google Sheets node, map each field to the right column.
  8. Open the Slack node and choose the target channel where alerts should post. Confirm the message preview shows rating, user profile link, and review link as expected.
  9. Check the HTML extraction nodes. The selectors are set to pull the review cards and fields. If the site layout changes later, update these selectors to match the new structure.
  10. Run the workflow once by clicking Execute Workflow. Confirm that at least one review is posted to Slack and that the same record appears in your Google Sheet.
  11. Verify de duplication by running again. If no new items are posted, the merge by reviewUrl is working. If duplicates appear, confirm the Sheet has the reviewUrl column filled and that the Merge node is set to keep non matches based on reviewUrl.
  12. Open the Schedule Trigger and set the hour and time zone that fit your team. Save and activate the workflow so it runs every day.
  13. Troubleshooting: If no data appears, check the ScrapingBee API key and remaining credits. If Slack fails, reauthorize the Slack credential. If the Sheets node errors, ensure the account has edit permission on the document.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

ScrapingBee

Sign up

Freelance: $49 / mo, 250,000 API credits

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

Credits:
Setup guide

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.