Reprice tour packages dynamically with Claude, Google Sheets and Slack
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Generate Yield Repricing Decision (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Slack
n8n-nodes-base.slack - Wait
n8n-nodes-base.wait
What it does
Quick overview This workflow runs on a schedule to fetch live tour-package demand signals and competitor prices via HTTP APIs, calculates repricing recommendations, uses Anthropic Claude to finalize capped and rounded price changes, then logs each update to Google Sheets and notifies a Slack channel. How it works 1. Runs on a scheduled trigger to poll your booking/demand API and your competitor pricing API in parallel. 2. Merges both API responses and calculates per-package demand score, seasonality/urgency, competitor positioning, and a recommended price adjustment. 3. Splits the results into one item per package and filters to only those needing a repricing change of 3% or more. 4. Sends each candidate package to Anthropic Claude (claude-sonnet-4) to apply rounding, enforce a 15% per-cycle cap, and return a final price with confidence and reasoning. 5. Parses the AI’s JSON output (falling back to the calculated recommendation if parsing fails) and formats an audit row with pricing and scoring details. 6. Appends the repricing row to a Google Sheets PriceUpdates tab via the Google Sheets API and posts a summary alert to Slack. Setup 1. Provide API access for your booking/demand endpoint and competitor pricing endpoint, and replace the placeholder URLs and Bearer tokens in both HTTP requests. 2. Add an Anthropic API credential and ensure the model setting uses your preferred Claude model (default: claude-sonnet-4-20250514). 3. Connect Google Sheets via OAuth2, replace YOURSHEETID, and ensure a PriceUpdates sheet exists with the expected columns. 4. Add Slack credentials and set YOURSLACKCHANNELID to the channel that should receive repricing alerts. 5. Adjust the schedule interval and, if needed, tune the 3% repricing threshold and scoring logic in the JavaScript calculation step.