Calculate litigation deadlines from intake forms with Google Calendar, Sheets, Slack and Gmail
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs when someone submits an n8n form (“Litigation matter intake”). Along the way it connects Google Sheets, Google Calendar, Slack and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Litigation matter intake”).
- Set the Rules Table (Edit Fields (Set)): sets 12 fields: limitationRules, proceduralRules, holidays…
- Calculate Matter Deadlines (Code): runs custom JavaScript code
- Append Deadline to Matter Log (Google Sheets): append
- Only Dated Deadlines (Filter): keeps only the items that match a condition
- Split Reminders Into Rows (Split Out): splits a list into separate items
- Build Deadline Summary (Code): runs custom JavaScript code
- Create Deadline Event in Calendar (Google Calendar): create (event)
- Create Reminder Event in Calendar (Google Calendar): create (event)
- Post Deadline Summary to Channel (Slack): post (message)
- Email Deadline Summary to Lawyer (Gmail): send (message)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Google Calendar
n8n-nodes-base.googleCalendar - Split Out
n8n-nodes-base.splitOut - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow collects litigation matter intake details via an n8n form, calculates limitation and procedural deadlines using a built-in rules table, then creates deadline and reminder events in Google Calendar, logs each deadline to Google…