Skip to content
Hud Jamalul
Back to sample work

AI Follow-up Assistant (Google Sheets + Gmail + AI)

ResultDrafted 4 personalized follow-ups in under a minute, with every lead tracked and none missed

An automation that reminds me who needs a follow-up each morning and uses AI to draft a personal email for each lead.

The task: Following up is where most leads are lost. I built this for my own client outreach, and it's the same system I can set up for any business that follows up with clients, patients or leads.

What I built:

  • A lead tracker, dashboard and activity log in Google Sheets
  • A daily 8 AM email listing every follow-up that is due
  • One-click AI drafting: each follow-up uses the lead's name, business type and one detail I noticed about them
  • Every email is saved as a Gmail draft, so nothing is sent without review
  • A quality check on every AI email, automatic retries when the AI is busy, and a backup template so a draft is always ready

The result: A whole list of personalized follow-ups is drafted in under a minute, and no lead is forgotten.

Built with Google Apps Script. If a client prefers n8n, Zapier or Make, I can build the same workflow on their paid plan.

The work

  1. AI Follow-up Assistant (Google Sheets + Gmail + AI), file 1 Full size

    1 of 2

  2. 2 of 2

    Demo: I click "Check follow-ups due" and overdue leads turn yellow. Then "Draft follow-ups with AI" writes a personal follow-up for each lead and saves it as a Gmail draft, ready to review and send.