{"product_id":"n8n-mechanics-lien-deadline-tracker-google-sheets-gmail","title":"n8n Mechanics Lien Deadline Tracker: Google Sheets + Gmail","description":"\u003ch3\u003eNever miss a mechanics lien deadline—automated with n8n, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow tracks mechanics lien notice and filing deadlines per job. It calculates due dates from your configurable \u003cstrong\u003eRules\u003c\/strong\u003e in Google Sheets, keeps a live \u003cstrong\u003eDeadlines\u003c\/strong\u003e tab updated, and emails you new-job deadline lists plus daily and weekly alerts via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eBuilt around n8n Forms and your spreadsheet data\u003c\/strong\u003e, it works like this:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdd a job:\u003c\/strong\u003e When you submit the “Add a job” form, the workflow generates a unique job ID, saves the job to Google Sheets (including an initial work-log entry), calculates applicable deadlines from the \u003cstrong\u003eRules\u003c\/strong\u003e tab, writes them to the \u003cstrong\u003eDeadlines\u003c\/strong\u003e tab, and emails you a deadline table for that job.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate a job:\u003c\/strong\u003e When you submit the “Update a job” form, it finds the matching job in Google Sheets, logs work\/completion\/recorded notices\/lien\/payment (or marks steps as done\/skip), recalculates deadlines while preserving done\/skip statuses, updates Google Sheets, and emails what remains open.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily schedule:\u003c\/strong\u003e Each morning, it recalculates deadlines for every open job, refreshes the \u003cstrong\u003eDeadlines\u003c\/strong\u003e tab, and compiles alerts for deadlines that match configured warning-day offsets, are due today, or are marked as missed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail reporting:\u003c\/strong\u003e It sends the compiled alert email(s) via Gmail and also emails a 60-day summary on your configured weekday.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack mechanics lien \u003cstrong\u003enotice\u003c\/strong\u003e and \u003cstrong\u003efiling\u003c\/strong\u003e timelines for multiple ongoing projects in one place.\u003c\/li\u003e\n  \u003cli\u003eReduce missed deadlines by getting automated daily alerts and “what’s left” updates after job status changes.\u003c\/li\u003e\n  \u003cli\u003eMaintain audit-friendly records in Google Sheets, including a work log and a continuously updated deadlines table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e set, code, gmail, switch, sticky note, and \u003cstrong\u003eform trigger\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets tabs for \u003cstrong\u003eJobs\u003c\/strong\u003e, \u003cstrong\u003eRules\u003c\/strong\u003e, \u003cstrong\u003eWork log\u003c\/strong\u003e, and \u003cstrong\u003eDeadlines\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfigurable inputs:\u003c\/strong\u003e email settings, spreadsheet ID, warning-day offsets, timezone, and the n8n base URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326545219763,"sku":"N8N-21290","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Pw_LV7tnzvLUVGwq8389N_FHwEkB20.png?v=1793352313","url":"https:\/\/buyflowscripts.com\/products\/n8n-mechanics-lien-deadline-tracker-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}