Context and role
A real estate client came to me with a problem in how leads were handled. I designed and built the n8n workflow that now handles them. The client is not named here.
What was messy
Every lead that came through the client's website had to be entered into their CRM by hand, followed up by email, logged in a spreadsheet and reported on weekly. That was four separate tasks for every lead, with no exceptions.
The approach
- A lead comes in through the website.
- A CRM entry is created automatically.
- A personalised email goes out.
- The spreadsheet updates.
- A weekly digest is compiled and sent every Monday at 7am.
Artefacts
New lead→CRM entry→Email→Sheet→Monday digest
An outline of the flow, not a screenshot. Client data stays private.
Result
Client result, self-reported
I built the workflow in about four hours. Four manual tasks per lead became one automated flow.
Built to hold up
Reporting without reminders. The weekly digest runs on a schedule, so the report does not depend on someone remembering to write it.