GoogleSheets Automate

Target Audience

• E-commerce Managers: Individuals overseeing online stores who want to monitor product prices.
• Deal Hunters: Consumers looking for price drops on specific products.
• Marketing Professionals: Those interested in tracking pricing trends for competitive analysis.
• Developers: People wanting to automate tasks related to Google Sheets and Gmail notifications.

Problem Solved

This workflow addresses the challenge of continuously monitoring product prices on Zalando. It automatically alerts users via Gmail when a product's price drops below a specified threshold, ensuring that users never miss a deal. By integrating with Google Sheets, it maintains a record of product prices and updates, facilitating easy tracking and management.

Workflow Steps

1. Schedule Trigger: The workflow is initiated on a schedule, automatically running at user-defined intervals.
2. List Products: It retrieves a list of products from a Google Sheets document, which includes links and price alert thresholds.
3. Scrap Product: For each product, it fetches the current price by sending an HTTP request to the product link.
4. Format Product: The scraped data is formatted to extract relevant details like the product name, current price, link, and the last update date.
5. Add Log in History: The workflow logs each price check in a dedicated Google Sheet to maintain a history of price changes.
6. Update Products Infos: It updates the original Google Sheet with the latest product information.
7. If Price Below Price Alert: A conditional check is performed to see if the current price is below the user-defined alert price.
8. Notify Price Reduction: If the condition is met, a notification email is sent via Gmail, informing the user of the price drop and providing a link to the product.