GoogleSheets Automate

GoogleSheets Automate streamlines product monitoring by automatically tracking price changes and notifying you via email when prices drop below your specified alert. This workflow integrates Google Sheets for data management, Gmail for alerts, and runs on a scheduled basis, ensuring you never miss a deal. Save time and stay informed on price reductions effortlessly.

7/8/2025
14 nodes
Medium
schedulemediumgooglesheetsschedule triggergmailformtriggersticky noteautomationadvancedlogicconditionalcronapiintegration
Categories:
Communication & MessagingSchedule TriggeredData Processing & AnalysisMedium Workflow
Integrations:
GoogleSheetsSchedule TriggerGmailFormTriggerSticky Note

Target Audience

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

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

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.

Customization Guide

Customization Guide


- Change Schedule: Adjust the schedule trigger settings to define how often the workflow checks for price updates.
- Update Google Sheets: Modify the Google Sheets document to include additional products or change the structure to suit your needs.
- Email Notifications: Customize the email message and subject in the Notify Price Reduction node to reflect your brand voice or specific details.
- Price Alert Threshold: Update the price_alert field in the Google Sheet to change the threshold for receiving notifications.