Step 2: Connect Google Sheets

Prepare the output sheet where analyzed review data will be appended or updated.

1. Add and open Update Leads Sheet.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials.
3. Set Document to Updated product review.
4. Set Sheet to Sheet1.
5. Set Operation to appendOrUpdate.
6. Map the column values exactly as shown:
   • Name → ={{ $json.Name }}
   • Email → ={{ $json.Email }}
   • Score → ={{ $json.score }}
   • Intent → ={{ $json.intent }}
   • Summary → ={{ $json.summary }}
   • Sentiment → ={{ $json.sentiment }}
   • Timestamp → ={{ $json.Timestamp }}
   • Contact Number → ={{ $json["Contact Number"] }}
   • Review of the product → ={{ $json["Review of the product"] }}

Step 3: Set Up AI Review Analysis

Configure the AI agent to interpret each review’s intent, sentiment, score, and summary.

1. Add and open Review Analysis Agent.
2. Set Text to =Here is the customer review data: {{ $json["Review of the product"] }}.
3. Set Prompt Type to Define.
4. In System Message, paste the exact instruction block from the node, ending with: Do not add extra commentary outside the JSON.
5. Open Azure Chat Model Link and set Model to gpt-4o-mini.
6. Credential Required: Connect your azureOpenAiApi credentials in Azure Chat Model Link.

Step 4: Parse AI Output and Prepare Sheet Fields

Transform the AI output into clean JSON fields and merge the original sheet data.

1. Add and open Parse AI Output.
2. Paste the provided JavaScript into Code exactly as-is, including the JSON parsing and sheet field assignments.
3. Verify it references Sheets Intake Trigger with $('Sheets Intake Trigger').first().json to merge original values.
4. Confirm the script removes output and the temporary myNewField before returning items.

Step 5: Test and Activate Your Workflow

Validate the end-to-end process and turn on the automation.

1. Click Execute Workflow and add a new row to the source sheet to trigger Sheets Intake Trigger.
2. Confirm Review Analysis Agent returns JSON output and Parse AI Output creates fields like intent, sentiment, score, and summary.
3. Verify Update Leads Sheet appends or updates a row in Updated product review with all mapped columns.
4. When everything looks correct, toggle the workflow to Active for production use.