Overdue lead follow-ups with Gemini

Gemini drafts follow-up emails for leads with no recent contact. This n8n template runs every weekday and reads leads from Google Sheets. It keeps leads with no contact for five days or more, downloads the last meeting transcript for each from Google Drive, and asks Google Gemini to write a personalized follow-up email. The email is saved as a Gmail draft for review, not sent, and the lead status is updated in the sheet. Leads marked Draft Created, Sent or Closed are skipped. It suits small sales teams who keep their pipeline and meeting transcripts in Google Workspace.

n8nRead on 2026-11-167 steps

Steps

  1. Trigger: Runs every weekday
  2. Reads leads from Google SheetsGoogle Sheets
  3. Filters leads with no contact for 5+ days
  4. Downloads last meeting transcript from Google DriveGoogle Drive
  5. Uses Google Gemini to write a personalized emailGoogle Gemini
  6. Output: Saves the email as a Gmail DraftGmail
    For review.
  7. Output: Updates lead status in the SheetGoogle Sheets

Limits

  • Only leads with the status New are handled.
  • Meeting transcripts must be PDF or TXT files in Google Drive.

What it does well

  • Drafts are saved in Gmail and never sent automatically.
  • Updates each lead's status in the sheet.

Before you import

Needs a Google Sheet with the listed columns, Google Drive access for transcripts in PDF or TXT, a Google Gemini API key and a Gmail account.

Similar templates