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.
Tags
Google SheetsWHTTP RequestSlackRelated workflows
See all Google Sheets→WTrack YouTube Trends by Country and Language with RapidAPI & Google Sheets
📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video top
WTrack Website Traffic with Semrush API and Log Results to Google Sheets
Automated Seo Website Traffic Checker with Google Sheets Logging (Seo) Description: This workflow uses the Website Traffic Checker Semrush API to analyze website traffic and performance. It collects data through a user-submitted website URL and stores the results in Google Sheets for easy access and reporting. Ideal for SEO analysis and data tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. Triggers the workflow when a website URL is submitted via the form interface. 2. Check webTraffic Sends a request to the Website Traffic Checker Semrush API to gather traffic data for the submitted website. Uses the provided URL to fetch real-time traffic statistics using the Semrush API. 3. Re format output Extracts and reformats the raw traffic data from the API response. Cleans and structures the traffic data for easy readability and reporting. 4. Google Sheets Appends the formatted traffic data into a Google Sheet for storage and further analysis. Stores the data in a Google Sheets document for long-term tracking and analysis. Benefits of This Flow: Real-Time Data Collection:** Collects real-time website traffic data dire
WAnalyze Website Backlinks with Top Backlink Checker API and Google Sheets Logging
Backlink Checker with Google Sheets Logging (Seo) Description: This workflow helps you analyze top backlinks using Semrush API and logs the results directly into Google Sheets for easy SEO tracking and reporting. It integrates the Top Backlink Checker API from RapidAPI, providing in-depth backlink analysis, and combines that with Google Sheets for efficient data storage and tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. This node triggers the workflow when the form is filled with a website URL. The Top Backlink Checker API (via RapidAPI) is used to check backlinks after this step. 2. Check webTraffic Sends a request to the Top Backlink Checker API to gather traffic data for the submitted website. This includes important metrics like visits, bounce rate, and more, which will later be stored in Google Sheets for analysis. 3. Reformat output Extracts and re-formats the traffic data received from the Top Backlink Checker API. This node cleans and structures the raw data for easier processing, ensuring it is usable for later stages in the workflow. 4. Reformat Processes the backlink data received from the Top Back