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.
Steps
- Trigger: Runs every weekday
- Reads leads from Google SheetsGoogle Sheets
- Filters leads with no contact for 5+ days
- Downloads last meeting transcript from Google DriveGoogle Drive
- Uses Google Gemini to write a personalized emailGoogle Gemini
- Output: Saves the email as a Gmail DraftGmail
For review. - 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
Tally B2B lead scoring with OpenAI
Also for sales and leads, 7 steps.
Typeform lead routing with OpenAI
Also for sales and leads, 11 steps.
Webflow lead scoring with Apollo
Also for sales and leads, 6 steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and Google Drive: 12 templates compared
Same two apps, different steps.
Google Drive and Google Sheets: 12 templates compared
Same two apps, different steps.
Gmail and Google Gemini: 11 templates compared
Same two apps, different steps.
Google Gemini and Google Sheets: 2 templates compared
Same two apps, different steps.
Follow-ups and reminders
Other templates that do this task.