{"product_id":"rakuten-price-drop-alerts-with-n8n-google-sheets-gmail","title":"Rakuten Price Drop Alerts with n8n, Google Sheets \u0026 Gmail","description":"\u003ch3\u003eNever miss a Rakuten price drop—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors your saved items on \u003cstrong\u003eRakuten Ichiba\u003c\/strong\u003e every day and sends you an \u003cstrong\u003ealert email via Gmail\u003c\/strong\u003e only when the price is truly worth buying—using the official free Rakuten Web Service API (no paid scraping).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e: it executes daily at \u003cstrong\u003e9:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your watchlist from Google Sheets\u003c\/strong\u003e: it loads configuration values and pulls each row containing the product details (including \u003ccode\u003eitemCode\u003c\/code\u003e, reference price, and previously saved values).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks current Rakuten pricing\u003c\/strong\u003e: for every watchlist entry, it calls the \u003cstrong\u003eRakuten Ichiba Item Search API\u003c\/strong\u003e to fetch the latest \u003cem\u003eitem price\u003c\/em\u003e and \u003cem\u003epoint rate\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects meaningful changes\u003c\/strong\u003e by comparing:\n    \u003cul\u003e\n      \u003cli\u003ecurrent price vs. \u003cstrong\u003ereference price\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ecurrent price vs. the \u003cstrong\u003epreviously saved price\u003c\/strong\u003e to confirm it dropped enough or dropped since the last check\u003c\/li\u003e\n      \u003cli\u003ecurrent point rate vs. \u003cstrong\u003eprevious point rate\u003c\/strong\u003e to catch \u003cstrong\u003epoint multiplier increases\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail message only when an alert condition is met\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePersists today’s values back to Google Sheets\u003c\/strong\u003e (today’s price and point rate), then waits \u003cstrong\u003eone second\u003c\/strong\u003e before continuing to the next product.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeal tracking for repeat purchases\u003c\/strong\u003e: watch staples you buy often and get emailed only when Rakuten drops the price.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePoints-aware shopping\u003c\/strong\u003e: alert when the \u003cstrong\u003eRakuten point multiplier increases\u003c\/strong\u003e, not just when price falls.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS\/operator-friendly automation\u003c\/strong\u003e: keep a centralized watchlist in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and let n8n handle the rest.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRakuten Web Service\u003c\/strong\u003e: uses the official free API with your \u003cstrong\u003eApplication ID\u003c\/strong\u003e and \u003cstrong\u003eAccess Key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth2 integration for reading\/writing watchlist rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: OAuth2 integration to send alerts to a configured recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/workflow tools\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, and \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45949974184115,"sku":"N8N-19182","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cHdCUjqZ9YQLKywY2ipCf_VQllvndI.png?v=1788512661","url":"https:\/\/buyflowscripts.com\/products\/rakuten-price-drop-alerts-with-n8n-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}