Automate resume screening with Gmail, Gemini AI, and Airtable to Google Sheets
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs on Gmail events. Along the way it connects Gmail, Airtable, Google Drive and Google Sheets. It also calls generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: On Gmail events.
- Airtable: search
- Merge: merges the data from its input branches
- EmailMatcher (Code): runs custom JavaScript code
- ReadyAttachment (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- FileUpload (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Google Drive: uses Google Drive
- CombineData (Merge): merges the data from its input branches
- PromptBuilder (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: generativelanguage.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Gmail Trigger).
Nodes used (8)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Airtable
n8n-nodes-base.airtable - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets
From the author
Who’s it for This workflow is perfect for recruiters, HR professionals, and startup founders who receive job applications by email and want to automate the process of parsing, matching, and evaluating resumes. If you want to save time by having candidate data…