Track tenant reference requests with forms, Gmail, and Google Sheets
Ready for 3.0What this workflow does
This workflow has 19 nodes and runs when someone submits an n8n form (“Tenant Reference Request”) (plus 2 other triggers). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Tenant Reference Request”) (plus 2 other triggers).
- Append to Tenant Tracker (Google Sheets): append
- Append Landlord Response (Google Sheets): append or update
- Fetch Overdue Entries (Google Sheets): uses Google Sheets
- Email Reference Request (Send Email): sends an email over SMTP
- Notify Sheet Write Failure (Gmail): uses Gmail
- Log Raw Landlord Feedback (Google Sheets): append
- Check If Overdue 49 Hours (If): checks a condition and branches into true / false
- Wait: waits 48 hours
- Notify Email Failure (Gmail): uses Gmail
- Email Escalation to Agent (Send Email): sends an email over SMTP
…plus 6 more steps. See the full node list below.
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 (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow collects tenant reference requests via an n8n Form, logs them in Google Sheets, emails the previous landlord a feedback form link, and automatically sends reminders and escalations via email (SMTP/Gmail) when responses are…