Calculate Shopify variant prices from Google Sheets with Slack approvals
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 18 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Fetch Product Dependencies (Google Sheets): uses Google Sheets
- Check Authorized User (If): checks a condition and branches into true / false
- Fetch Supplier Prices (Google Sheets): uses Google Sheets
- Fetch Slack Thread Replies (Slack): replies (channel)
- Merge Price Data (Aggregate): combines items into one
- Parse Price Data (Code): runs custom JavaScript code
- Set Pricing Constants (Edit Fields (Set)): sets 2 fields: hidden_cost_percentage, profit_margin_percentage
- Update Variant Price in Shopify (HTTP Request): calls an HTTP API (PUT)
- Calculate New Prices (Code): runs custom JavaScript code
- Post Update Status to Slack (Slack): uses Slack
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Slack Trigger requires a signing secret on the Slack API credential (When Slack Message Received).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Slack Trigger
n8n-nodes-base.slackTrigger - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview Video Explanation: https://youtu.be/geRatkc1kU?si=qALWnrPrNB4THuO This workflow runs daily to calculate Shopify variant prices from Google Sheets COGS inputs, automatically updates qualifying prices in Shopify, and posts Slack alerts for…