Step 2: Connect Google Sheets

Store the aggregated AI analysis results in your Google Sheet for tracking and reporting.

1. Open Update Sheet Record.
2. Set Operation to appendOrUpdate.
3. Set Document to [YOUR_ID] and Sheet to gid=[YOUR_ID].
4. In Columns, map feedback_analysis to ={{ $json.output.toJsonString() }} and topics_keywords to ={{ $json.output[0].toJsonString() }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up Data Preparation

Convert the Jotform submission into a structured payload that the AI chains can consume.

1. Open Prepare Submission Payload.
2. Paste the JavaScript Code exactly as follows:
3. const outputString = JSON.stringify($input.first().json, null, 2);
return [
{
json: {
body: outputString
}
}
];
4. Confirm the execution flow is Jotform Intake Trigger → Prepare Submission Payload.

Step 4: Set Up the AI Sentiment and Topic Analysis

Configure two AI analysis streams that run in parallel: sentiment review and topic extraction.

1. Open Sentiment Review Chain and set Text to =Perform sentiment analysis of the following {{ $json.body }}.
2. Open Topic Keyword Extractor and set Text to =Perform sentiment analysis of the following {{ $json.body }}.
3. Confirm Prepare Submission Payload outputs to both Sentiment Review Chain and Topic Keyword Extractor in parallel.
4. Open Gemini Chat Engine and verify Model is models/gemini-2.0-flash-exp.
5. Open Gemini Topic Model and verify Model is models/gemini-2.0-flash-exp.
6. Credential Required: Connect your googlePalmApi credentials on Gemini Chat Engine and Gemini Topic Model.
7. Ensure Sentiment Output Parser and Topic Output Parser are connected as output parsers; add credentials to the parent nodes (the Gemini model nodes), not the parsers.

Step 5: Configure Aggregation and Final Output

Merge parallel AI outputs and aggregate them into a single payload before storing in Google Sheets.

1. Confirm Sentiment Review Chain and Topic Keyword Extractor both connect to Combine Analysis Streams.
2. Open Aggregate Results and ensure Fields to Aggregate includes output.
3. Verify the execution flow: Combine Analysis Streams → Aggregate Results → Update Sheet Record.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow and then enable it for production.

1. Click Test workflow and submit a sample Jotform entry to trigger Jotform Intake Trigger.
2. Check that Prepare Submission Payload produces a body field and that both AI branches execute in parallel.
3. Confirm Update Sheet Record appends or updates a row with feedback_analysis and topics_keywords values.
4. When successful, toggle the workflow to Active for continuous processing.