{"product_id":"n8n-workflow-collect-conditional-unconditional-lien-waivers","title":"n8n Workflow: Collect Conditional \u0026 Unconditional Lien Waivers","description":"\u003ch3\u003eCollect Conditional \u0026amp; Unconditional Lien Waivers Automatically—On Schedule\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow streamlines the full lien waiver lifecycle: it receives payment requests, creates payment IDs in Google Sheets, emails payees to upload the correct \u003cstrong\u003econditional\u003c\/strong\u003e or \u003cstrong\u003eunconditional lien waivers\u003c\/strong\u003e, validates uploads, stores waiver files in Google Drive, and sends reminder emails until every required waiver is received.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts from an n8n Form payment request:\u003c\/strong\u003e it reads existing payment records from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a new payment entry:\u003c\/strong\u003e generates a unique \u003cstrong\u003ePayment ID\u003c\/strong\u003e in Google Sheets and sends \u003cstrong\u003eGmail\u003c\/strong\u003e requests to the payee and owner for the matching \u003cstrong\u003econditional waiver\u003c\/strong\u003e, including an upload link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives the signed waiver upload:\u003c\/strong\u003e an n8n Form collects the file, then the workflow validates waiver type and amount, and for \u003cem\u003eprogress payments\u003c\/em\u003e it checks the through-date against the payment details in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves files + logs status:\u003c\/strong\u003e uploads the waiver to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, records details in a Google Sheets \u003cstrong\u003e“Waivers”\u003c\/strong\u003e tab, updates payment status when applicable, and emails the owner (and payee if corrections are needed) via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles “marked paid” submissions:\u003c\/strong\u003e updates the payment as paid in Google Sheets (optionally requiring a conditional waiver first), then requests the \u003cstrong\u003eunconditional waiver\u003c\/strong\u003e from the payee via Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily to chase missing\/overdue waivers:\u003c\/strong\u003e every morning it emails payees for missing conditional or overdue unconditional waivers, increments reminder counters in Google Sheets, and emails the owner a summary of payments on hold.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSubcontractor payment workflows where owners need complete lien documentation before releasing funds.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying waiver tracking with consistent validation (type, amount, and progress through-date).\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing multi-step compliance workflows using n8n Forms and Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e n8n Forms, Google Sheets, Gmail, Google Drive\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic \u0026amp; nodes:\u003c\/strong\u003e if, set, code, switch, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e connect Google Sheets, Gmail, and Google Drive credentials\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326544236723,"sku":"N8N-21299","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9_Fb8Cq7DCGmLJ8d-8vht_gKTp0a3J.png?v=1793352284","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-collect-conditional-unconditional-lien-waivers","provider":"N8N Commerce","version":"1.0","type":"link"}