Developer & DevOps
Automatically Transfer Reviews to Google Sheets
13 nodes
193
114
Automatic trigger
Workflow Description
Automation that collects reviews from external sources and inserts them into Google Sheets in an organized format, with manual or scheduled triggering to ensure regular data updates without manual intervention.
How it works
- 1.Trigger the automation manually or via a scheduled time interval
- 2.Fetch review data by calling an external API endpoint
- 3.Process and transform the data into the required format using JavaScript functions
- 4.Split reviews into individual records for parallel processing
- 5.Append each review as a new row in the designated Google Sheets table
Use cases
- Centralize customer reviews from multiple platforms into a single spreadsheet
- Build a historical database of reviews for performance analysis and trend detection
- Eliminate manual data transfer efforts between systems and save operational time
Requirements
- Google account with write access to Google Sheets
- External data source with an API endpoint providing review data
- Pre-configured Google Sheets table with appropriate column headers
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Google Sheets
Details
Trigger
Automatic trigger
Nodes
13
Apps
1
Views
193
Downloads
114
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (13)
/
When clicking ‘Test workflow’
Manual Trigger
Sticky Note
Sticky Note
Get reviews
HTTP Request
Global
Set
Parse reviews
Code
HelpfulCrowd edits
Set
Split Out
Split Out
General edits
Set
General sheet
Google Sheets
HelpfulCrowd Sheets
Google Sheets
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Schedule Trigger
Schedule Trigger