A custom automation for a Shopify store selling electric breakers. This workflow monitored competitor pricing, allowed for in-house approval, and automatically updated product listings — keeping the store competitive with zero manual intervention.
Project Summary
Built an end-to-end automation that integrates incoming competitor price change emails, parses them into structured data, and syncs approved updates directly to Shopify. The process eliminated repetitive tasks, reduced human error, and kept the store consistently price-competitive.
The Problem
The client manually monitored competitor websites and adjusted Shopify product prices one-by-one. This slow process meant competitor price changes often went unnoticed for days, resulting in lost sales opportunities and reduced profit margins.
The Solution
Using Zapier, Google Sheets, and the Shopify API, I created a multi-step workflow:
- Zapier monitored incoming emails for competitor price updates.
- Parsed relevant data (product name, SKU, competitor price) into a Google Sheet.
- In-house team marked items as “approved” for update in the sheet.
- Zapier detected approved items and pushed updates to Shopify via API.
Results
- Reduced price update time from hours to minutes.
- Maintained competitive pricing 24/7.
- Freed up staff from repetitive administrative work.
Planned Improvements
- Automated competitor scraping to replace email triggers.
- Automated margin protection to prevent price drops below a set threshold.
- Custom dashboard for monitoring price changes and approvals.
