{"product_id":"n8n-layaway-tracker-webhook-to-google-sheets-email-reminders","title":"n8n Layaway Tracker: Webhook to Google Sheets + Email Reminders","description":"\u003ch3\u003eStop Layaway from “Vanishing”—Automatically Track Plans, Email Schedules, and Chase Due Payments\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n layaway tracker workflow\u003c\/strong\u003e logs every new layaway plan to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, emails the customer their payment schedule, sends daily reminders for due and overdue payments, and delivers a monthly owner review of what’s still owed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures new layaway plans via webhook:\u003c\/strong\u003e “When Layaway Plan Created” receives each new plan through a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e at path \u003cstrong\u003elayaway-intake-0927\u003c\/strong\u003e (ideal for your POS or a form submission).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and structures the record:\u003c\/strong\u003e “Normalize Plan” generates a consistent \u003cstrong\u003eplan_id\u003c\/strong\u003e (e.g., \u003cem\u003eLAY-YYYYMMDD-1234\u003c\/em\u003e) and stores key fields such as customer details, item, total price, deposit_paid, installment_amount, installments_total, interval_days, payments_made, status, office_email, created_at, \u003cstrong\u003ebalance_due\u003c\/strong\u003e, and \u003cstrong\u003enext_due_date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required data:\u003c\/strong\u003e “Validate Plan” checks \u003cstrong\u003ecustomer_name\u003c\/strong\u003e, \u003cstrong\u003eitem\u003c\/strong\u003e, and \u003cstrong\u003enext_due_date\u003c\/strong\u003e. If missing, “Email Reject Notice” informs the store office.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves to Google Sheets + emails schedule:\u003c\/strong\u003e Valid plans are appended to the \u003cstrong\u003e“Plans”\u003c\/strong\u003e tab and the customer receives their schedule email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily payment chasing at 08:00:\u003c\/strong\u003e Every morning at \u003cstrong\u003e08:00\u003c\/strong\u003e it reads open plans, finds payments due within \u003cstrong\u003ethree days\u003c\/strong\u003e and overdue payments, reminds customers, and logs alerts to the \u003cstrong\u003e“Alerts”\u003c\/strong\u003e tab. Overdue plans roll into one escalation email to the store.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonthly owner review:\u003c\/strong\u003e On the \u003cstrong\u003e1st at 09:00\u003c\/strong\u003e, \u003cstrong\u003egpt-6-luna\u003c\/strong\u003e drafts a monthly review of what is still owed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent “forgotten” layaway payments by automating customer reminders.\u003c\/li\u003e\n  \u003cli\u003eCentralize plan tracking for multiple staff using a single Google Sheets tracker.\u003c\/li\u003e\n  \u003cli\u003eGet consistent monthly visibility on outstanding balances with gpt-6-luna summaries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e: \u003cem\u003elayaway-intake-0927\u003c\/em\u003e (POST)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends to \u003cstrong\u003ePlans\u003c\/strong\u003e and logs to \u003cstrong\u003eAlerts\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail\u003c\/strong\u003e: Gmail-based notifications via \u003cstrong\u003egmail\u003c\/strong\u003e node (customer schedule, reject notices, daily reminders, and escalation email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogic \u0026amp; data shaping\u003c\/strong\u003e: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cem\u003eLast updated: October 2026.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192878354611,"sku":"N8N-20445","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/L4yOsCnuKVHaDUAuXYvaJ_DzoWtryj.png?v=1791538171","url":"https:\/\/buyflowscripts.com\/products\/n8n-layaway-tracker-webhook-to-google-sheets-email-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}