Step 2: Connect Google Sheets

Retrieve pricing URLs and write back updates to the same sheet.

1. Open Retrieve Pricing Links and select the spreadsheet by setting Document to [YOUR_ID] and Sheet to gid=0.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Pricing Links.
3. Open Modify Pricing Sheet and confirm Operation is set to update, with the same Document [YOUR_ID] and Sheet gid=0.
4. Set column mappings in Modify Pricing Sheet to:
   • Time → {{ $now }}
   • Pricing → {{ $json.pricing_summary }}
   • row_number → {{ $json.row_number }}
   • Pricing URL → =
5. Set Matching Columns to row_number so updates target the correct row.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Modify Pricing Sheet.

Step 3: Set Up AI Pricing Extraction and Data Merge

Analyze pricing pages, merge results, and normalize the response into structured fields.

1. In Assess Pricing Page, set URL to {{ $json["Pricing URL"] }}.
2. Set Prompt to the full instruction string: This is a pricing page. Please summarize it concisely by including every plan. For each plan, list the price and the top 3 features it includes. Compare the current plan to the previous plan described here: [{{ $json.Pricing }}]. RETURN ONLY 3 FIELDS: 1. `pricing_summary` - A textual description of the pricing, including the plan's name, price, and top 3 features. 2. `differences_summary` - If there are significant differences in the PRICES between the previous plan and the current one, summarize the differences concisely in a textual description, focusing only on the changes in prices. 3. `status` - In a status field, return [DIFF] if the new plan and pricing are substantially different from the previous one, [SIMILAR] if they are similar, or [NEW] if the previous pricing is empty. - important, do not guess or estimate, just report things that are clearly mentioned in pricing page.
3. Set Resource to extraction, Operation to query, and Session Mode to new.
4. Credential Required: Connect your airtopApi credentials in Assess Pricing Page.
5. In Combine Streams, set Mode to combine and Combine By to combineByPosition.
6. In Extract Response Data, set Mode to runOnceForEachItem and paste: const response = JSON.parse($json.data.modelResponse) return { json: { ...response, row_number: $json['row_number'], "Pricing URL": $json["Pricing URL"] }}

Parallel execution: Retrieve Pricing Links outputs to both Assess Pricing Page and Combine Streams in parallel.

Step 4: Configure Filtering and Alerts

Filter out similar pricing and send updates to Slack while updating the sheet.

1. In Exclude Similar Results, set the condition to:
   • Left Value → {{ $json.status }}
   • Operator → notContains
   • Right Value → SIMILAR
2. In Send Pricing Alert, set Text to {{ $json["Pricing URL"] + " - " + $json.differences_summary }} and select your Slack channel.
3. Credential Required: Connect your slackApi credentials in Send Pricing Alert.

Parallel execution: Exclude Similar Results outputs to both Modify Pricing Sheet and Send Pricing Alert in parallel.

Step 5: Test and Activate Your Workflow

Run a manual test to verify the end-to-end pricing updates and alerts.

1. Click Execute Workflow from Manual Execution Start to run the workflow.
2. Confirm that Assess Pricing Page produces pricing_summary, differences_summary, and status.
3. Verify that Modify Pricing Sheet writes a new Time and Pricing value for the correct row_number.
4. Check Slack to confirm Send Pricing Alert posts the message with Pricing URL - differences_summary.
5. When satisfied, toggle the workflow to Active for production use.