Automate Google Price Alerts: n8n, Airtable & Gmail Workflow

Automatically Receive Google Price Alerts with n8n, Airtable & Gmail Workflow

Transform how you track product prices with our "Automate Google Price Alerts" workflow on the n8n marketplace. Seamlessly integrating Airtable, ScraperAPI, and Gmail, this efficient automation workflow collects, analyzes, and alerts you about Google Shopping deals that meet your targeted price points every day. Say goodbye to manual price-checking and make informed purchasing decisions effortlessly.

What this workflow does

• Initiates every day at 8:00 AM to ensure you're always updated with the freshest offers.
• Retrieves watchlist data from Airtable to track items you're interested in purchasing.
• Utilizes ScraperAPI to scan Google Shopping for each product on your list, organizing offers by price, merchant, and more.
• Logs detailed offer snapshots, including pricing and metadata, back into Airtable for historical analysis.
• Checks for offers meeting or dropping below your target price, and highlights these in an HTML digest.
• Sends you an email through Gmail, containing a carefully curated alert digest for all products with matching prices.

Use cases

• Price monitoring for competitive e-commerce pricing strategies, allowing businesses to dynamically adjust their sales tactics.
• Bargain hunting for personal shopping, ensuring you never miss a deal on gadgets, household items, or clothing.
• Market trend analysis by tracking fluctuations in product pricing over time, aiding in smart financial and stock investments.

Technical details

• Integrations/nodes used: n8n, Airtable, ScraperAPI, Gmail, and essential workflow nodes like "if," "code," "sticky note," and "split in batches."
• Setup requirements include Airtable and ScraperAPI credentials, plus enabling Google Shopping scraping on your ScraperAPI account.
• Ensure correct Airtable field structures for both watchlist and results tables to maximize data mapping efficiency.