Step 2: Connect Google Sheets

These nodes store and read review data in your spreadsheet.

1. Open Append Reviews to Sheet and set Operation to append.
2. Set Document ID to [YOUR_ID] and Sheet Name to gid=0 (Sheet1).
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Reviews to Sheet.
4. Open Retrieve Aggregated Reviews and set the same Document ID [YOUR_ID] and Sheet Name gid=0.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Aggregated Reviews.

Step 3: Set Up Review Intake and Validation

Define the review source URL and validate that it’s correctly formatted before scraping begins.

1. In Assign Review Source Link, set URL to https://www.trustpilot.com/review/football-mall.com.
2. In Validate Link Format, set the condition Left Value to ={{ $json.URL }}, Operation to contains, and Right Value to http.
3. Ensure Assign Review Source Link connects to Validate Link Format, and that the true path continues to Review Gathering Agent.

Step 4: Set Up Review Gathering Agent

This agent scrapes reviews via Decodo and parses structured review data.

1. In Review Gathering Agent, set Text to =Use Decodo to collect reviews and ratings from URL URL: {{ $('Assign Review Source Link').item.json.URL }}.
2. Confirm Review Gathering Agent has Has Output Parser enabled.
3. Open Decodo Scrape Tool and set URL to ={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}, Headless to false, and Markdown to true.
4. Credential Required: Connect your decodoApi credentials for Decodo Scrape Tool. This tool is attached to Review Gathering Agent, so manage credentials via the agent’s tool connection.
5. Open OpenAI Review Insights and set the model to gpt-4.1-mini.
6. Credential Required: Connect your openAiApi credentials in OpenAI Review Insights, which is the language model for Review Gathering Agent.
7. Open Review Data Extractor and confirm the JSON Schema Example matches your expected review structure.
8. Note: Review Data Extractor is an AI output parser for Review Gathering Agent; no credentials are added to the parser itself.

Step 5: Configure Review Field Augmentation and Storage

Normalize the extracted fields and append them to your sheet.

1. In Augment Review Fields, map fields using expressions:
   • output.overall_rating → ={{ $json.output.overall_rating }}
   • output.total_reviews → ={{ $json.output.total_reviews }}
   • output.review_summary → ={{ $json.output.review_summary }}
   • output.detailed_reviews → ={{ $json.output.detailed_reviews }}
2. In Append Reviews to Sheet, map columns to:
   • total_reviews → ={{ $json.output.total_reviews }}
   • overall_rating → ={{ $json.output.overall_rating }}
   • review_summary → ={{ $json.output.review_summary }}
   • detailed_reviews → ={{ $json.output.detailed_reviews }}
3. Ensure the flow follows Review Gathering Agent → Augment Review Fields → Append Reviews to Sheet.

Step 6: Configure Summary Insights and Email Delivery

Aggregate stored reviews, generate insights, and send a report.

1. Confirm Append Reviews to Sheet connects to Retrieve Aggregated Reviews, then to Insights Summary Agent.
2. In Insights Summary Agent, set Text to =Summarize the reviews and provide key insights. Data: {{ $json.reviews }} Average Rating: {{ $json.average_rating }}.
3. Open OpenAI Summary Engine and set the model to gpt-4o-mini.
4. Credential Required: Connect your openAiApi credentials in OpenAI Summary Engine, which is the language model for Insights Summary Agent.
5. Open Summary Output Parser and confirm the JSON Schema Example is: { "summary": "string", "key_insights": ["string"] }.
6. Note: Summary Output Parser is an AI output parser for Insights Summary Agent; no credentials are added to the parser itself.
7. In Email Summary Report, set Send To to [YOUR_EMAIL], Subject to Report, and Message to ={{ $json.output.summary }}.
8. Credential Required: Connect your gmailOAuth2 credentials in Email Summary Report.

Step 7: Add Error Handling

Invalid links trigger an email alert so you can intervene quickly.

1. In Validate Link Format, ensure the false output is connected to Dispatch Error Alert.
2. In Dispatch Error Alert, set Send To to [YOUR_EMAIL], Subject to Error in workflow, and Message to Your workflow has stopped working.
3. Credential Required: Connect your gmailOAuth2 credentials in Dispatch Error Alert.

Step 8: Test and Activate Your Workflow

Run a manual test to confirm the full execution flow works end-to-end.

1. Click Execute Workflow on Begin Review Intake to run a manual test.
2. Verify Append Reviews to Sheet writes a new row and Retrieve Aggregated Reviews returns data.
3. Check that Email Summary Report sends a message with ={{ $json.output.summary }} populated.
4. If the URL is invalid, confirm Dispatch Error Alert sends the error email.
5. When satisfied, toggle the workflow to Active for production use.