Score incoming resumes automatically and log them to Sheets

Reads resume emails, scores each candidate against your open roles, and logs everything to a spreadsheet.

How the work actually flows

A straight line.

Pattern: Sequence (1)

flowchart TD trig>"resume email arrives"]:::trig s0["match job title to opening"]:::task s1[("save resume to drive")]:::store s2["ai scores candidate"]:::svc s3[("log candidate to sheet")]:::store trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"scored candidate logged with resume link"/]:::out pay{{"screen applicants without manual review"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationSpreadsheet & Database OpsFile & Cloud StorageHR & Recruiting
Connects
GmailAirtableGoogle DriveGoogle SheetsGoogle Gemini

The problem it solves

You're getting resumes by email for multiple open roles, and matching each one to the right job, reading it, and scoring the candidate takes real time away from actually hiring. Good candidates can sit in your inbox for days before anyone gets to them.

Who it fits

Recruiters, HR teams, or startup founders who receive job applications by email and want candidates scored automatically.

How it works

  1. Gmail is monitored for new emails with resume attachments
  2. The job title is matched against your open positions in Airtable
  3. The resume is saved to Google Drive
  4. Gemini AI reads the resume and scores the candidate, pulling out their name, phone number, and a short explanation
  5. The candidate's info, score, and resume link are added as a new row in Google Sheets
What you get

Resumes ranked without you opening each one

Incoming resumes get scored against your open roles and logged in a spreadsheet with the candidate's details ready for you to review.

What you get

A running Google Sheet of scored candidates with contact details, AI feedback, and a link to their resume.

What you need

A Gmail account, an Airtable account, a Google Drive and Sheets account, and a Gemini API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

An AI assistant that sorts your inbox and processes invoices

Sorts your unread email, extracts data from invoices into a spreadsheet, and drafts replies for you.

Advanced

Ten ready-made automations for leads, invoices and alerts

A bundle of ready-to-run automations that handle leads, invoicing reminders, alerts, and reporting for you.

Advanced

Turn emailed timesheets into QuickBooks invoices automatically

Reads timesheet emails, extracts hours with AI, and creates ready-to-send invoices in QuickBooks.

Advanced

Match your resume to LinkedIn jobs and track them automatically

AI compares your resume to new LinkedIn job posts, scores each match, and logs everything to Google Sheets.

Advanced
Back to the AI Playbook