Automating Your Job Search: Track Applications Without Losing Your Mind

Sending dozens of applications across BrighterMonday, LinkedIn, MyJobMag, and company websites without a tracking system is how applications fall through cracks and interviews get missed. You can automate your job search tracking with a free Google Sheets system, email alerts for new postings, and follow-up reminders that keep every application visible.

Why Job Seekers Need a System

The Kenyan job market is competitive. If you are actively searching, you might send out 10-20 applications in a week across multiple platforms. After a few weeks, the numbers add up and your memory fails you.

Common problems without a tracking system:

Duplicate applications. You apply to the same company twice because you forgot you already submitted. This looks careless to recruiters.

Missed follow-ups. You applied to a company that asked for a follow-up email after two weeks. Two weeks passed, and you forgot.

Lost interview details. A recruiter calls with an interview invitation and you cannot remember which role or company they are calling about. You fumble through the conversation.

No sense of progress. Without data, the job search feels endless. You do not know if you are applying enough, targeting the right roles, or getting reasonable response rates.

A spreadsheet solves all of this. Combined with a few automated alerts, it turns an overwhelming process into something you can manage in 15 minutes a day.

Step 1: Build Your Application Tracker

Open Google Sheets and create a spreadsheet called "Job Search Tracker."

Set up these columns:

#	Company	Role	Source	Date Applied	Application Method	Status	Follow-Up Date	Response Date	Interview Date	Notes	Salary Range

Column details:

• Source: Where you found the posting (BrighterMonday, LinkedIn, company website, referral, newspaper, WhatsApp group)
• Application Method: How you applied (online form, email, walk-in, referral)
• Status: Use data validation with these options: Applied, Acknowledged, Phone Screen, Interview Scheduled, Interviewed, Second Interview, Offer, Rejected, No Response, Withdrawn
• Follow-Up Date: The date you should follow up if you have not heard back (usually 10-14 days after applying)
• Salary Range: If listed. Helps you compare offers later

Add conditional formatting:

• Green for Offer
• Blue for Interview Scheduled / Interviewed
• Yellow for Applied (waiting)
• Red for Rejected / No Response
• Grey for Withdrawn

Step 2: Set Up Job Alerts (Automated New Posting Notifications)

Instead of manually checking job boards every day, set up alerts that notify you when new relevant postings appear.

Google Alerts: Go to google.com/alerts. Create alerts for specific job titles and locations. Examples:

• "marketing manager" Nairobi
• "software developer" Kenya
• "accountant" Mombasa

Google will email you when new pages matching these terms appear. This catches postings on company websites and smaller job boards that you might miss.

BrighterMonday job alerts: On BrighterMonday, search for your target roles and click "Create Alert" or "Save Search." You will receive email notifications when new matching jobs are posted.

LinkedIn job alerts: On LinkedIn, search for a job title and location, then toggle on "Set Alert." LinkedIn sends email and in-app notifications for new postings matching your criteria.

MyJobMag alerts: Similar setup. Search for your target roles and enable notifications.

Career websites of target companies: Many Kenyan companies (Safaricom, Equity Bank, KCB, NCBA, nation media, and others) have career pages with email subscription options. Sign up for notifications from the specific companies you want to work for.

Set all alerts to deliver to one email address. This creates a central inbox for job opportunities that you review once a day.

Step 3: Create a Daily Job Search Routine

With alerts set up and a tracker ready, here is a 30-minute daily routine.

Morning (15 minutes):

1. Check your job alert emails. Open any promising postings.
2. For each posting you decide to apply to, add a row to your tracker with the company, role, source, and today's date.
3. Apply to 1-3 jobs (prioritize quality over quantity).
4. After submitting each application, update the tracker: change Status to "Applied" and set the Follow-Up Date (today + 14 days).

Evening (15 minutes):

1. Open your tracker and check if any follow-up dates match today.
2. Send follow-up emails for those applications.
3. Update any statuses (if you received a rejection, acknowledgment, or interview invitation during the day).

This routine keeps your search active and organized without consuming your entire day.

Step 4: Automate Follow-Up Reminders

The follow-up is where most job seekers drop the ball. Automation fixes this.

Option 1: Google Sheets + Apps Script.

Write a simple script that checks the Follow-Up Date column every morning. If any date matches today and the Status is still "Applied" (meaning you have not heard back), the script sends you an email: "Reminder: Follow up on your application to [Company] for [Role]. Applied on [date]."

Set this as a daily trigger in Apps Script.

Option 2: Google Calendar events.

Each time you apply, create a Google Calendar event 14 days out: "Follow up: [Company] - [Role]." When the notification fires, you send the follow-up email. This is simpler than Apps Script if you are not comfortable with code.

Option 3: Task manager reminders.

If you use Google Tasks, Todoist, or any task app, create a task for each follow-up. Set the due date to 14 days after application.

All three options achieve the same result: you never forget to follow up.

Step 5: Craft Follow-Up Email Templates

Having templates ready means you can send a follow-up in under two minutes.

Standard follow-up (14 days after applying):

Subject: Following up on [Role] application - [Your Name]

"Dear [Hiring Manager / HR Team],

I submitted my application for the [Role] position on [date] and wanted to follow up on its status. I remain very interested in the opportunity and believe my experience in [relevant skill/area] aligns well with what you are looking for.

I am happy to provide any additional information you may need. Thank you for your time and consideration.

Best regards, [Your Name] [Phone Number]"

Follow-up after an interview (within 24 hours):

Subject: Thank you for the interview - [Role] - [Your Name]

"Dear [Interviewer Name],

Thank you for taking the time to meet with me today regarding the [Role] position. I enjoyed learning about [specific topic discussed] and am excited about the possibility of contributing to [Company Name].

As we discussed, my experience with [relevant topic] would allow me to [specific value you can add]. Please let me know if you need any additional information.

Looking forward to the next steps.

Best regards, [Your Name]"

Save these templates in a Google Doc for quick access. Customise the bracketed parts for each application.

Tracking What Works

After a month of tracking, your spreadsheet reveals patterns.

Response rate by source. Which platforms generate the most responses? If BrighterMonday applications get a a small fraction response rate and LinkedIn applications get a notable share, shift your effort to LinkedIn.

Response rate by application method. Referrals almost always outperform cold applications. If your data confirms this, invest more time in networking.

Time to response. How long do companies typically take to respond? This helps you set realistic expectations and appropriate follow-up timing.

Stage conversion rates. Of your applications, what percentage get an acknowledgment? An interview? A second interview? An offer? If you are getting interviews but not offers, the issue is interview performance, not your CV.

This data turns the job search from an emotional rollercoaster into an evidence-based process.

Kenya-Specific Job Search Tips

Referrals matter enormously. Many positions in Kenya are filled through networks before they are publicly advertised. For every formal application you submit, try to find a connection at the company (check LinkedIn, ask friends, contact alumni networks) who can mention your name internally.

Government and parastatal jobs. These often have strict application procedures (specific forms, certified copies of documents, physical submission). Track deadlines carefully in your spreadsheet because late applications are automatically disqualified.

WhatsApp job groups. Many industries in Kenya have WhatsApp groups where jobs are shared. Be cautious (verify postings before applying) but do not ignore them. Add "WhatsApp Group" as a source in your tracker when you apply through these channels.

Phone calls from recruiters. Kenyan recruiters often call instead of emailing. Keep your tracker accessible on your phone so you can quickly reference which role they are calling about.

FAQ

How many applications should I send per week?

Quality matters more than quantity. For professional roles in Kenya, 5-10 well-targeted applications per week (with customised cover letters) typically outperform 30 generic ones. If you are applying for entry-level positions where the application process is simpler, you can reasonably handle 10-15 per week.

Should I follow up by email, phone, or WhatsApp?

For corporate and professional roles, email is the standard follow-up channel. For smaller companies, especially SMEs, a polite phone call can be effective because your application might be sitting in an inbox nobody checks regularly. WhatsApp is rarely appropriate for follow-ups unless the job posting specifically used WhatsApp as a contact method.

How long should I wait before following up?

Two weeks (14 days) is the standard window for most applications. If the job posting specifies a closing date, wait until after that date plus one week. For government and parastatal positions, the process is slower, so three to four weeks is more appropriate.

What do I do when a company never responds?

After two follow-ups (at 14 days and 28 days) with no response, mark the application as "No Response" in your tracker and move on. Some companies in Kenya simply do not respond to unsuccessful applicants. It is not a reflection on you. Focus your energy on active opportunities.