Quick overview
Quick overview Video Explanation: https://youtu.be/_geRatkc1kU?si=qALW_nrPrNB4THuO 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 changes that need manual approval; it also supports Slack-based approvals to apply a proposed price from a Slack thread. How it works Runs every day on a scheduled trigger. Reads product dependency/recipe data from Google Sheets and looks up the latest supplier prices in a second Google Sheets sheet. Calculates raw COGS, landed COGS (with hidden cost percentage), and a target-margin retail price for each Shopify variant. Checks the calculated price against thresholds and either updates the Shopify variant price via the Shopify Admin API or posts an approval-required alert to Slack. Posts a Slack confirmation message when a scheduled Shopify price update succeeds. Triggers on Slack reaction events, verifies an authorized Slack user approved the change, then fetches the Slack thread replies and extracts the variant ID and approved price. Updates the Shopify variant price with the extracted value and posts a final status message to Slack. Setup Connect Google Sheets with a Service Account and set the spreadsheet/document IDs and sheet names for both the product dependencies sheet and supplier prices sheet. Connect a Slack OAuth credential, set the channel to monitor for reactions, and set the channel where approval alerts and confirmations are posted. Connect Shopify OAuth2 credentials (Admin API access) and update the myshopify domain in the Shopify Admin API request URLs. Replace the placeholder authorized Slack user ID and adjust the approval reaction name if you want a different approver or reaction. Set your hidden cost percentage and profit margin percentage values used in the COGS and price calculation. An n8n automation workflow template by iamvaar.
iamvaar
web
free
Others in the same category, ranked by how often they are opened.
