Daily applicant digest by role with Gemini AI extraction for hiring managers

Send daily applicant digest by role from Gmail to hiring managers with Google Gemini

This workflow automatically collects all new job application emails from your Gmail labeled as applicants in the last 24 hours. Every day at 6:00 PM (Asia/Kolkata), it extracts structured details (name, email, phone, role, experience, skills, location, notice, summary) from each applicant (using Gemini AI or OpenAI). It then groups applicants by role and manager, compiles a neat HTML table digest for each manager and emails them a single summary — so hiring managers get everything they need, at a glance, in one place.

Who’s It For

- Recruiters and hiring managers tired of digging through multiple application threads. - Small HR teams / agencies not yet on a full applicant tracking system. - Anyone wanting a consolidated, role-targeted applicant update each day. - Teams that want to automate candidate triage using Google Workspace and AI.

How It Works

1. Schedule Trigger (6PM IST): Runs automatically at 18:00 India time. 2. Fetch Applicant Emails: Reads Gmail for emails labeled 'applicants' from the past 24 hours. 3. Prepare Email Text: Converts email content to plain text for reliable AI extraction. 4. Extract Applicant Details: Gemini/OpenAI extracts applicant’s info in structured JSON. 5. Assign Manager Emails: Routes each applicant to the correct manager via role→email mapping or fallback. 6. Group & Build HTML Tables: Organizes applicants by manager and role, builds summary tables. 7. Send Digest to Managers: Sends each manager one HTML summary email for their new applicants.

How to Set Up

1. Create/verify Gmail label applicants and set up filters to route job emails there. 2. Import the workflow: Use your Google/Gmail and Gemini/OpenAI accounts as credentials. 3. Configure connections: - Gmail with OAuth2 (IMAP not required, uses Gmail API) - Gemini or OpenAI API key for extraction 4. Set role→manager mapping in the “Assign Manager Emails” node (just edit the map!). 5. Adjust time / defaults: Edit schedule and fallback email if you wish. 6. Test it: Send yourself a test application, label it, check workflow logs.