HR & Recruitingfree

Google Sheets, Google Gemini & Email (SMTP) Automation

by Nirav GajeraUpdated Aug 2026

Requires

Google SheetsGoogle Gemini

Email (SMTP)

1/5

STEPS · 13

Starts on a Google Sheets event

On a Google Sheets row change, a Gemini agent analyzes the data and conditionally sends an email via SMTP.

Resume JD Matching

On a new Gmail email, matches resumes to job descriptions with Google Gemini, then records results in Notion and Google Sheets.

When a Google Sheets row is added, an Azure OpenAI agent analyzes the candidate questionnaire and writes results back to Google Sheets.

On a new Gmail email, saves resume attachments to Google Drive, extracts details with an Azure OpenAI agent, and logs to Google Sheets.