Automate iPhone 17 Price Tracking with n8n & Gmail Alerts

Revolutionize Your iPhone 17 Price Tracking with Automated n8n & Gmail Alerts

Unlock the next level of price tracking for the iPhone 17 with our innovative n8n workflow that seamlessly integrates Google Sheets, Mrscraper, and Gmail. Get real-time price updates, detailed market statistics, and instant alerts — all automated for your convenience!

What This Workflow Does

• Initiates based on a pre-set schedule or when triggered by another workflow, accessing a list of marketplace URLs and Mrscraper ScraperIDs from Google Sheets.
• Efficiently processes these URLs in batches, engaging Mrscraper to extract listing data and update the initial Google Sheet with the status of each scraping session.
• Filters and parses the resulting data to focus on iPhone 17 product titles, normalizes the corresponding prices and currencies, and records this detailed information into a target Google Sheets results sheet.
• Calculates price statistics such as minimum, maximum, median, average, and standard deviation, alongside an ideal price suggestion for every marketplace listed.
• If the number of market sources is under the set threshold, employs Google Gemini to craft an HTML email with the results; otherwise, it generates a CSV and formats a plain email summary.
• Sends a formatted HTML email with the detailed CSV attachment via Gmail, while also clearing previous data from Google Sheets for the next cycle.

Use Cases

• Stay ahead in the competitive marketplace by keeping track of iPhone 17 price fluctuations across various platforms.
• Empower your procurement team with detailed price insights, helping to make informed buying decisions.
• Ideal for tech resellers and e-commerce strategists who need accurate and up-to-date market pricing statistics for effective pricing strategies.

Technical Details

• Integrates with: Google Sheets for data handling, Mrscraper for marketplace data extraction, Google Gemini for AI-driven summaries, and Gmail for communication.
• n8n Nodes Used: if, code, gmail, merge, sticky note, google sheets.

Leverage this potent automation to ensure you're always informed and strategically positioned in the dynamic world of iPhone resale and marketing.