# Send scheduled real estate lead follow-up emails with Google Sheets and Gmail

> Quick Overview This workflow runs every weekday at 9am to read real estate leads from Google Sheets, send the next scheduled follow-up email via Gmail based on each lead’s intent and status, and then updates the lead row with the new follow-up step and next due date. How it works 1. Runs every weekday at 9am on a schedule. 2. Reads lead rows from the “Leads” sheet in Google Sheets. 3. Checks each lead’s status, last contact date, and follow-up step against the configured follow-up day sequence and skips leads in stop statuses (for example replied or unsubscribed). 4. Builds a personalized HTML follow-up email (buy/sell/rent) with your booking link and unsubscribe text for leads that are due, up to the maximum emails per run. 5. Sends each follow-up email through Gmail. 6. Updates the matching lead in Google Sheets with the new status, incremented follow-up step, last contact timestamp, and next follow-up date. Setup 1. Connect Google Sheets credentials with access to the spreadsheet th

- **Domain**: `n8n-workflow-20380.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20380
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20380.n8n.io
- Documentation: https://n8n.io/workflows/20380