Collect customer reviews from a public review site and store them in Google Sheets so your team can use them fast. It also prepares a second sheet in a ready to import format for product review tools. This is useful for stores, marketers, and agencies that need fresh social proof without manual copy and paste.

The flow can run on a schedule or by a quick test click. A Global step holds the company name and the number of pages to fetch. An HTTP Request pulls review pages by recency with built in pagination. A Code step parses the page data into clean fields like title, body, rating, author, location, date, replies, and links. The Split Out step handles one review at a time. Two mapping steps format the data for two outputs. One Google Sheets node writes a general log. The second Google Sheets node writes a sheet that matches a common import layout for review apps.

Setup is simple. Connect a Google Sheets account, choose your target spreadsheet, and update the company name and max pages. Pick a schedule that fits your monitoring needs and run a test to see rows appear. Expect less copy work, fewer errors, and faster publishing of social proof. Common uses include pulling store feedback for product pages and agency reporting across clients.

• Manual and schedule triggers let you test on demand and run on a timer.
• HTTP Request node fetches review pages sorted by recency with pagination.
• Code step parses page data into clean fields using an HTML parser.
• Split Out processes each review item separately for clear mapping.
• Two Set nodes map fields for a general log and an import ready layout.
• Two Google Sheets nodes append or update rows in separate sheets.
• Simple global settings for company name and max pages control the crawl.
• Append or update mode helps prevent duplicate rows as data grows.

• Reduce manual work from 2 hours to 5 minutes by automating review collection
• Streamline review consolidation by about 90 percent with scheduled runs
• Improve data quality by up to 95 percent by removing copy paste errors
• Handle 10 times more review volume with automatic pagination
• Connect online reviews to Google Sheets for fast sharing with teams

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 Google Sheets. See the Tools Required section above for links to create accounts with this service.
3. Open the Global Set node and update company_id to match the review site slug for your brand and set max_page to the number of pages you want to fetch.
4. Double click each Google Sheets node. In the Credential to connect with field, click Create new credential and follow the on screen steps to connect your Google account. Give the credential a clear name like Google Sheets Account Main.
5. Create or copy a spreadsheet with two tabs for outputs. In each Google Sheets node, select your spreadsheet in Document and pick the correct Sheet. Keep the operation as appendOrUpdate.
6. In the General sheet node, confirm column mappings for Body, Date, Author, Rating, Heading, Location, Reply, and Link. Adjust the Set node named General edits if your column names differ.
7. In the HelpfulCrowd Sheets node, review the mapped columns and match them to your import sheet headers. Update the HelpfulCrowd edits Set node if your import layout is different.
8. Open the HTTP Request node named Get reviews and confirm the URL pattern uses your company_id. Keep the query set to recency and leave pagination enabled to fetch multiple pages.
9. Click Test workflow to run a manual check. Open your target Google Sheet and confirm new rows appear in both tabs.
10. If no rows appear, check the company_id value matches the slug in the review site URL and increase max_page. If fields look off, adjust the mapping in the Set nodes.
11. Open the Schedule Trigger and set the interval that fits your needs, such as every day or every week. Activate the workflow to run on that schedule.
12. For deduplication, choose a unique column like Link and configure appendOrUpdate keys in the Google Sheets nodes so repeats are updated instead of added.
13. Make sure your Google account has edit access to the target spreadsheet. If permissions are missing, share the sheet with the connected account.