Skip to content

Job Application Tracker

Example prompt: "When I add a new row to my 'Applications' Google Sheet with a company name and role, research the company, add a summary to the sheet, and remind me to follow up by email if I haven't heard back in 10 days."

How to automate job application tracking with GloriaMundo

The Problem

Job hunting involves a lot of repetitive bookkeeping. You apply for a role, note it somewhere (or forget to), then lose track of which companies you have heard back from and which you should follow up with. Researching each company before an interview means opening a dozen tabs and scanning their about page, recent news, and Glassdoor reviews. Most people either keep a messy spreadsheet that falls out of date within a week, or rely on memory and miss follow-up windows entirely. The administrative overhead adds stress to an already stressful process.

How GloriaMundo Solves It

We build a workflow that triggers when you add a new row to a Google Sheet with the company name, role title, and application date. A web search step researches the company — pulling a brief description, recent news, size, and any notable information about the team or culture. An LLM step writes a concise company summary and suggests two or three questions worth asking in an interview. An integration step writes these back to your spreadsheet in the relevant columns. Separately, a scheduled workflow runs daily, checks your sheet for applications older than 10 days with no response logged, and drafts a polite follow-up email for each one in Gmail, saved as a draft for you to review before sending. Glass Box preview shows you exactly which follow-ups will be drafted and what the emails say, so nothing goes out without your approval.

Example Workflow Steps

  1. Trigger (webhook or scheduled): Fires when a new row is added to the Applications Google Sheet, or runs daily to check for pending follow-ups.
  2. Step 1 (web_search): Search for the company name to find their website, recent news, size, and basic information about culture and team.
  3. Step 2 (llm): Write a concise company summary and suggest 2-3 interview questions based on the research.
  4. Step 3 (integration): Update the Google Sheet row with the company summary, research notes, and suggested questions.
  5. Step 4 (integration): For applications older than 10 days with no response, read the original application details from the sheet.
  6. Step 5 (llm): Draft a polite, professional follow-up email referencing the specific role and application date.
  7. Step 6 (integration): Create the follow-up email as a Gmail draft for your review.

Integrations Used

  • Google Sheets — central tracker for all applications, statuses, and research notes
  • Gmail — drafts follow-up emails for review and sending

Who This Is For

Anyone actively job hunting who is applying to multiple roles and struggling to keep track of where they stand with each application. Particularly useful for people applying to 10+ roles who want to follow up professionally without letting any slip through the cracks.

Time & Cost Saved

Researching a company before an interview typically takes 15–20 minutes. Keeping a spreadsheet up to date and remembering to follow up adds another 30 minutes per week across active applications. This workflow saves roughly 2–3 hours per week during an active job search. The workflow uses web search, LLM, and integration steps, costing a few credits per run.