Genesis Web Digital Genesis Web DigitalThe Foundation of Your Digital Presence
Free n8n Build · #8 — the finale

The finished template.

Eight weeks of builds, packaged as one import-and-go workflow. Every contact-form lead gets caught, junk gets filtered, real leads land in your Google Sheet and get an AI-drafted personal reply with your calendar link — in seconds. You get notified the moment it happens, quiet leads get an automatic follow-up three days later, and if anything ever breaks, an alert lands in your inbox before a single lead slips through. This is the complete lead-handling assistant.

⬇ Download the complete template (.json)
Free. No email required. Import straight into any n8n instance (cloud or self-hosted).

What it does

Contact form submitted → Junk filter → Log to Google Sheet → AI drafts the reply → Email sent w/ 📅 calendar link → 🔔 You get notified → Wait 3 days → Friendly follow-up
🛑 Any node fails → ⚠️ Error alert to your inbox

The full assistant, start to finish: a POST webhook catches the submission, a junk filter screens out bots and empty submissions before anything else runs, real leads land in your Google Sheet (name, email, phone, message, source), AI drafts a warm personal first reply — under 90 words, nothing made up — and it goes out with your calendar link so hot leads can book themselves. The moment that happens, a notification email hits your inbox with the lead's full details. Anyone who goes quiet gets exactly one friendly follow-up three days later. And if any node ever fails — bad address, API timeout, rate limit — the error branch emails you the workflow name, the failed node, and the error message, with a link straight into n8n. Nothing slips through silently.

Set it up in ~5 minutes

  1. Import it. In n8n: Workflows → Import from File → pick the downloaded .json. There's a setup-notes sticky right on the canvas with this same checklist.
  2. Connect Google Sheets. Open Log Lead to Sheets → add a Google Sheets credential and replace YOUR_GOOGLE_SHEET_ID with your spreadsheet's ID. Give the first tab these columns: Timestamp, Name, Email, Phone, Message, Source, Status.
  3. Connect the AI. Open Draft Reply with AI → add your OpenAI API key. It runs gpt-4o-mini — fast and costs pennies; swap the model anytime.
  4. Connect Gmail. Four nodes send email — Send Reply + Calendar Link, Notify Owner, Send Follow-up, and Alert on Error. Add one Gmail credential and pick it in all four.
  5. Drop in your calendar link. Replace YOUR_CALENDAR_LINK in Send Reply + Calendar Link and Send Follow-up with your Calendly / Cal.com / booking URL.
  6. Your email + n8n URL. Replace YOUR_EMAIL in Notify Owner and Alert on Error with the inbox you actually check, and YOUR_N8N_URL in Alert on Error with your n8n address — error alerts link you straight to the failed run.
  7. Arm the error branch. Open Workflow Settings → Error Workflow and select this same workflow — that's what tells n8n to fire the alert when any node fails. Want proof? Break something on purpose (typo the Sheet ID), submit a test, watch the alert land.
  8. Copy the webhook URL. Open Form Submission → copy the production URL. Point your contact form (Tally, Typeform, a plain HTML form) to POST name, email, message to it — phone and source are optional and get logged too.
  9. Activate. Toggle it on and submit a test — a row lands in your sheet, the tester gets an AI-written reply with your calendar link, and your inbox gets the new-lead notification. Tip: to test the follow-up without waiting, temporarily set Wait 3 Days to 3 minutes.