Match LinkedIn jobs and tailor ATS resumes using Gemini, Apify, Google Docs, Sheets, and Gmail

Quick overview

This daily workflow scrapes recent LinkedIn job postings via Apify, scores each role against your master resume using Google Gemini, generates an ATS-tailored resume in Google Docs for the top matches, logs results to Google Sheets, and emails you a summary via Gmail.

How it works

1. Runs every day at 7:00 AM on a schedule.
2. Loads your configuration values and fetches your master resume content from Google Docs.
3. Builds a LinkedIn job search URL and uses Apify’s LinkedIn Jobs Scraper actor to retrieve recent postings.
4. Normalizes job fields, skips jobs already processed in previous runs, and scores each remaining job against your resume using Google Gemini.
5. Keeps jobs at or above your minimum fit score, sorts them by score, and selects the top matches to tailor.
6. Uses Google Gemini to rewrite your resume for each selected job, creates a new Google Doc, and inserts the tailored resume text.
7. Appends each match (including job and resume links, fit score, and skills) to Google Sheets and sends a single HTML summary email via Gmail.

Setup

1. Connect credentials for Apify (API token), Google Gemini (PaLM/Gemini API key), Google Docs OAuth2, Google Sheets OAuth2, and Gmail OAuth2.
2. Copy your master resume into a Google Doc and set its document URL in the workflow configuration.
3. Update the workflow configuration values for job keywords, location, jobs to fetch, minimum fit score, max tailored resumes, and the recipient email address.
4. Set the Google Sheets spreadsheet and target tab used for logging, and ensure the sheet has columns that match the fields being appended.
5. Set the Google Docs destination folder ID for saving tailored resumes, then run the workflow once to verify permissions and output before activating the schedule.