{"product_id":"detect-new-orders-due-date-changes-from-google-drive","title":"Detect New Orders \u0026 Due Date Changes from Google Drive","description":"\u003ch3\u003eDetect New Orders \u0026amp; Due Date Changes from Google Drive (Excel\/Sheets)\u003c\/h3\u003e\n\u003cp\u003eKeep your order pipeline up to date automatically: this n8n workflow scans a Google Drive folder for the latest “Order_List” spreadsheet, validates order rows, and compares them to an n8n Data Table baseline to identify \u003cstrong\u003enew orders\u003c\/strong\u003e and \u003cstrong\u003edelivery due date changes\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for reliability and clear change detection, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e to start the check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Drive\u003c\/strong\u003e using a configurable query (default: \u003cem\u003e“Order_List”\u003c\/em\u003e) and selects the latest matching Excel\/Sheets file.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and reads the workbook\u003c\/strong\u003e as an \u003ccode\u003e.xlsx\u003c\/code\u003e file (converting Google Sheets when needed) and extracts rows from the first sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates orders\u003c\/strong\u003e by mapping required columns: \u003cem\u003eOrder No.\u003c\/em\u003e, \u003cem\u003eCustomer\u003c\/em\u003e, \u003cem\u003eProduct\u003c\/em\u003e, and \u003cem\u003eDue Date\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts due dates\u003c\/strong\u003e to \u003ccode\u003eYYYY-MM-DD\u003c\/code\u003e, and \u003cstrong\u003estops on missing\/invalid or duplicate order numbers\u003c\/strong\u003e to prevent corrupt comparisons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads a baseline\u003c\/strong\u003e from an n8n Data Table (named \u003ccode\u003eorder_baseline\u003c\/code\u003e). If the baseline is empty, it saves the current orders as the initial baseline.\u003c\/li\u003e\n  \u003cli\u003eIf a baseline exists, \u003cstrong\u003ecompares current vs. baseline\u003c\/strong\u003e and outputs a \u003cstrong\u003epreview\u003c\/strong\u003e of:\n    \u003cul\u003e\n      \u003cli\u003enew orders\u003c\/li\u003e\n      \u003cli\u003edue date changes\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDoes not update the baseline\u003c\/strong\u003e after comparisons (so you control when\/if the baseline should be refreshed).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAn operations team monitors weekly\/daily order exports from Google Drive and needs instant visibility into new orders and shifting delivery dates.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators use an n8n Data Table baseline to audit order list changes before triggering downstream processes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/steps used:\u003c\/strong\u003e Manual Trigger, Google Drive, If, Code, Data Table, Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBaseline schema:\u003c\/strong\u003e create Data Table \u003ccode\u003eorder_baseline\u003c\/code\u003e with string columns \u003ccode\u003eorder_number\u003c\/code\u003e, \u003ccode\u003ecustomer_name\u003c\/code\u003e, \u003ccode\u003eproduct_name\u003c\/code\u003e, \u003ccode\u003edelivery_date\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add Google Drive credentials and update the Drive search query to match your file naming convention.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248890728627,"sku":"N8N-21211","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8TyXl8jOHYVKaOoePWYnb_oHKBdeeW.png?v=1792487246","url":"https:\/\/buyflowscripts.com\/products\/detect-new-orders-due-date-changes-from-google-drive","provider":"N8N Commerce","version":"1.0","type":"link"}