{"product_id":"log-dummyjson-product-checks-to-google-sheets-gmail-alerts","title":"Log DummyJSON Product Checks to Google Sheets + Gmail Alerts","description":"\u003ch3\u003eAutomatically monitor DummyJSON product responses and log results in Google Sheets—or alert your inbox via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks the DummyJSON products endpoint on a schedule. If the first product includes a non-empty \u003cstrong\u003etitle\u003c\/strong\u003e, it appends a row to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. If the title is missing, it immediately sends a \u003cstrong\u003eGmail\u003c\/strong\u003e email alert—so you can spot endpoint issues or unexpected API changes fast.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a scheduled trigger\u003c\/strong\u003e to perform periodic health-style checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls DummyJSON Products API\u003c\/strong\u003e using an \u003cstrong\u003eHTTP Request\u003c\/strong\u003e node: \u003ccode\u003ehttps:\/\/dummyjson.com\/products\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the response\u003c\/strong\u003e by checking whether the \u003cem\u003efirst returned product\u003c\/em\u003e contains a \u003cstrong\u003enon-empty title\u003c\/strong\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIf the title is present:\u003c\/strong\u003e appends a record to your selected \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIf the title is missing:\u003c\/strong\u003e sends an email using \u003cstrong\u003eGmail\u003c\/strong\u003e with the configured recipient, subject, and message content.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e verifying that an upstream dummy data feed still matches expected structure.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e testing conditional flows: log to Google Sheets when valid, notify via Gmail when invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQA \/ data validation tasks\u003c\/strong\u003e that need quick visibility when a third-party API response changes or becomes incomplete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNear-real-time monitoring\u003c\/strong\u003e by running every few minutes, or \u003cstrong\u003eroutine checks\u003c\/strong\u003e by running hourly\/daily.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e for timed execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to fetch product data from \u003ccode\u003ehttps:\/\/dummyjson.com\/products\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIF\u003c\/strong\u003e node to check whether the first product’s \u003cstrong\u003etitle\u003c\/strong\u003e is non-empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e node to append rows to the specified spreadsheet and worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node to send alerts when the title is missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e included for workflow clarity\/documentation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet it up with your Google Sheets OAuth2 and Gmail credentials, configure the sheet and email details, and choose the schedule interval that matches your monitoring needs.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029358465203,"sku":"N8N-19604","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/LBGCz-oTo3cQ1-lrZD21M_hrlO0EYm.png?v=1789463322","url":"https:\/\/buyflowscripts.com\/products\/log-dummyjson-product-checks-to-google-sheets-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}