Remote Job Applications, CVs and Interviews

How to Track Your Remote Job Applications Effectively

Track remote job applications with a free Google Sheet and Gmail filters: the columns, statuses and formulas Nigerian applicants need, plus a weekly review.

By Tolu Adebanjo, Job search writer

Updated 15 min read

To track your remote job applications well, keep one record of every role you apply for and update it the day anything changes. Give each application a status and a next action with a date, and look at the record once a week to see what is getting replies. A free Google Sheet and a Gmail label will do the job. Paid apps are optional.

This matters more for remote jobs than local ones. Within a month you can have 30 or more applications spread across Greenhouse forms, Lever pages, Workable, LinkedIn and email, with recruiters in London, Berlin and New York. When a recruiter calls and asks "which role was this?", you need the answer in ten seconds.

This guide covers what a tracker for remote applications from Nigeria should include, how to set one up in Google Sheets and Gmail, which apps are worth trying, and how to use your own numbers to fix your search.

Quick answer

Create one tracker (a Google Sheet works) with a row for each application. Columns should cover company, role, link, date applied, location eligibility, pay and currency, CV version sent, contact, status and next action date. Use a Gmail filter to label every application email. Log changes on the day they happen and review the sheet weekly to see your reply rate and decide on follow-ups.

Why remote job seekers in Nigeria need a tracker

Remote applications pile up quickly and go quiet for a long time. You might apply to a US startup on Monday, hear nothing for three weeks, then get an assessment link that expires in 72 hours. Without a record, you won't know which CV you sent or what pay range was in the ad.

A tracker solves three problems:

  • Memory. You'll know exactly what you applied for, when, and with which CV, even after the job ad is taken down.
  • Timing. Every application has a date for the next step, so follow-ups go out on time instead of in a panic or not at all.
  • Learning. After a few weeks the sheet shows which kinds of roles, job boards and CV versions get replies. That's the only reliable way to improve your search.

There's a Nigeria-specific reason too. Many "remote" roles aren't open to people living in Nigeria. A tracker that records the location rule for each role stops you wasting follow-ups on jobs you were never eligible for. Why some remote jobs are not available to Nigerians explains why those restrictions exist.

What to record for each remote job application

Most tracker templates online stop at company, role, date and status. For international remote roles you need a few more fields. The table lists each column and why it's there.

ColumnWhat to enterWhy it matters
CompanyName and websiteLets you check the recruiter's email domain later
RoleExact job titleRecruiters reuse titles across teams
LinkURL of the adYou can find it again before it closes
Saved copyLink to a PDF or screenshot of the adAds disappear after closing
Date appliedDay, month, yearSets your follow-up timing
Location ruleWorldwide, EMEA, Africa, Nigeria named, unclearFilters out roles you can't take
Hiring setupContractor, EOR employee, freelance, unknownChanges pay, tax and benefits
PayAmount, currency, periodLets you compare offers
Time zoneTeam's zone and required overlap hoursShows whether the hours suit you
CV versionFile name, e.g. CV-support-v3Tells you which version works
SourceWorkRemote, LinkedIn, referral, careers pageShows which channels pay off
ContactRecruiter name and emailYou know who to follow up with
StatusOne value from a fixed listLets you filter and count
Next actionWhat to do and the dateKeeps each application moving
NotesInterview questions, red flagsPrep for the next round

You don't need every column on day one. If you're short on time, start with company, role, link, date applied, location rule, status and next action date. Add the others once the habit sticks.

Location rule: the column most templates miss

Write down exactly what the ad says about where you can live. Use short, consistent labels:

  • Worldwide: the ad says anyone, anywhere can apply.
  • Region: EMEA, Africa, or "Europe and Africa time zones".
  • Nigeria named: Nigeria appears in the list of allowed countries.
  • Restricted: US-only, UK right to work, Canada-only and similar.
  • Unclear: the ad doesn't say.

Restricted roles shouldn't be in your tracker at all unless you hold the right to work there. If a role is marked unclear, put "confirm eligibility" as the next action, and do it before you spend an hour on a cover letter. How to verify whether a remote job accepts Nigerian residents shows how.

Hiring setup and pay currency

When an ad says "contractor via Deel" or "employed through an employer of record", record it. A $2,000 monthly contractor fee and a $2,000 salary paid through an employer of record (EOR) don't mean the same take-home pay or the same protections. Our guide to contractor versus EOR employee arrangements explains the difference. When an ad gives a pay range, copy it exactly, with the currency and whether it's hourly, monthly or yearly.

Time zone and overlap

Write down the team's time zone and any required overlap. As of October 2026, Lagos is on WAT (UTC+1) all year. London is one hour behind Lagos since UK clocks went back on 25 October 2026. From 1 November 2026, US Eastern is six hours behind Lagos. A role asking for "overlap with 9am to 1pm EST" means 3pm to 7pm in Lagos. That suits some people and clashes with others' commitments, and the tracker is where you notice before an interview, not after.

Choosing the right status list

A status column only works if you pick from a short, fixed list. Typing a new phrase every time ("waiting", "pending reply", "sent, no news") makes the sheet impossible to filter or count.

Here's a list that matches how most remote hiring works:

  1. Saved: you found the role but haven't applied.
  2. Applied: application submitted.
  3. Screening: a recruiter replied or booked a call.
  4. Assessment: you received a test, writing task or take-home project.
  5. Interview: hiring manager or panel interviews.
  6. Offer: you received a written offer.
  7. Rejected: the employer said no.
  8. No response: the role went quiet past your cut-off.
  9. Withdrawn: you pulled out.
  10. Not eligible: you found a location or work-authorisation restriction.

Set a cut-off for "No response". Many applicants use about four weeks after applying, or two weeks after a follow-up that got no reply. Choose a rule and stick to it, so dead applications stop cluttering the active list. The follow-up guide covers when and how to send that follow-up.

How to build a free tracker in Google Sheets

Google Sheets is free, works on a phone, saves as you type and is easy to share with a mentor. These steps give you a working tracker in about 20 minutes.

  1. Create a new sheet and type your column headings in row 1. Freeze row 1 so the headings stay visible when you scroll.
  2. Select the Status column below the heading and add a dropdown. According to Google's dropdown instructions, you can use Insert > Dropdown or Data > Data validation > Add rule, then enter your status values as items. Do the same for Location rule, Hiring setup and Source.
  3. Format the Date applied and Next action date columns as dates so you can sort by them.
  4. Add a conditional formatting rule that highlights overdue actions. Google's conditional formatting help page explains the "Custom formula is" option, which lets the rule look at other cells in the row.
  5. Add a second rule that flags duplicate companies, so you notice when you've already applied there.
  6. Create a second tab called "Weekly review" for your numbers (covered below).

Formulas you can copy

These examples assume the next action date is in column N, status in column M and company in column A, with headings in row 1. Change the letters to match your sheet.

To highlight rows where the next action is due or overdue, select the data range (for example A2:O500), open Format > Conditional formatting, choose "Custom formula is" and enter:

=AND($N2<>"",$N2<=TODAY(),$M2<>"Rejected",$M2<>"No response",$M2<>"Withdrawn")

To highlight companies you've applied to more than once, select A2:A500 and use:

=COUNTIF($A$2:$A$500,A2)>1

Google's help page uses the same pattern for finding duplicates. The dollar signs lock the range so the rule copies correctly down the column.

To count applications by status on your review tab, use:

=COUNTIF(Tracker!M:M,"Interview")

Replace "Tracker" with your tab's name and "Interview" with any status.

Keeping it light on data and power

The Sheets app on a phone opens a single tracker without using much data. Because Sheets saves to Google's servers as you type, an outage that kills your laptop won't lose the day's entries. Keep the sheet to one tab of applications, not dozens, and save copies of job ads as small PDFs in one Google Drive folder rather than large screenshots.

Capturing application emails automatically in Gmail

Most updates on remote applications come by email: confirmations, assessment links, interview invites and rejections. A Gmail label collects them in one place so nothing gets buried under bank alerts.

Use one email address for all applications

Pick one professional address and use it for every application. Applicant tracking systems tie your application to the email you entered. Greenhouse's MyGreenhouse candidate FAQ says applications submitted with a different email address won't show under your account, and that accounts can't be merged. Switching between addresses makes your records harder to keep complete.

Set up a filter

Google's help page on creating Gmail filters explains the steps: click "Show search options" in the search box, enter your criteria, click Create filter, then choose an action such as applying a label. You can also open an existing email, choose More > Filter messages like these, and build from there.

Gmail's search operators let you match several patterns at once. A starting point for job emails could be:

subject:("your application" OR "thank you for applying" OR "interview" OR "assessment" OR "next steps")

Set the filter to apply a label such as "Job search". Each time a confirmation email arrives from a hiring system the filter misses, add that sender with from:. Don't archive these messages automatically at first. Let them stay in your inbox with the label until you trust the filter.

To see everything that came in this week, search label:job-search newer_than:7d (Gmail turns spaces in label names into hyphens in search). That search is the first step of the weekly review below.

Using the employer's own portals

Some hiring systems give candidates a dashboard. MyGreenhouse is one. According to Greenhouse's candidate FAQ, you sign up at my.greenhouse.io with your email, and applications made through Greenhouse-hosted forms can appear there if the employer shares them. The same FAQ sets out the limits:

  • Employers choose what to share, so you may only see a high-level status, and "no change" might just mean no update.
  • Applications made through LinkedIn, Indeed or other third-party sites may not appear.
  • For withdrawals, corrections or status questions, you have to contact the company directly.

Treat portals like this as a cross-check, not your main record. They only cover employers that use that system, and they only show what each employer chooses to share. Your own sheet covers everything.

Job boards, including LinkedIn, also keep lists of jobs you saved or applied to through them. The problem is the same: each list covers only that site.

Should you use a job tracking app instead of a spreadsheet?

Dedicated apps make sense if you apply to a lot of roles and want a browser extension that saves job ads with one click. They aren't required.

Huntr is one example. As of October 2026, its pricing page lists a free plan that tracks up to 100 jobs and includes a Chrome job clipper. Pro costs $40 a month (about ₦54,500 at WorkRemote's house rate of ₦1,362 to $1, CBN NFEM weighted average, 23 October 2026), with cheaper rates for three- or six-month billing. Check the page before paying, because prices change.

OptionCostBest forDrawback
Google SheetsFreeFull control, custom columnsYou build it yourself
Notion or Trello boardFree plans existPeople who think in cardsHarder to count and filter
Huntr free planFree, up to 100 jobsOne-click saving from ChromeCap on tracked jobs
ATS portals like MyGreenhouseFreeChecking status at one employerOnly some employers

Our advice: start with a sheet. If after a month you're saving more than 20 roles a week and copying details by hand feels like the slow part, try an app's free plan. Paying in dollars for a tracker before you've got a single reply isn't a good use of money.

The weekly review: turning your tracker into better results

A tracker that you only add to is a diary. The value comes from reviewing it. Block 30 minutes on the same day each week, Sunday evening for example.

Five things to check each week

  1. Search your job-search label for the past seven days and update every status in the sheet.
  2. Sort by next action date and handle everything due: follow-ups, thank-you notes, assessment deadlines.
  3. Move anything past your cut-off to "No response".
  4. Count the week's new applications, replies, assessments and interviews on your review tab.
  5. Write one sentence on what you'll change next week.

Numbers worth calculating

  • Reply rate: replies of any kind (including rejections) divided by applications sent.
  • Screening rate: applications that reached a recruiter call or assessment divided by applications sent.
  • Rate by source: the same numbers split by where you found the job.
  • Rate by CV version: the same numbers split by the CV you sent.

Example (hypothetical): Amaka, a customer support applicant in Ibadan, sent 40 applications in a month. 22 used CV-support-v1 and 18 used CV-support-v2, which leads with her Zendesk ticket numbers and CSAT scores. v1 got one screening call, v2 got four. Twelve applications went to roles she later found were US-only. The tracker tells her three things: v2 works better, she should check location rules before applying, and her real screening rate on eligible roles is higher than it looked.

That's the point of tracking. Without the sheet, Amaka would have thought "remote jobs don't reply to Nigerians" and given up on a CV that was working.

What the numbers suggest

Don't over-read a small sample. Ten applications tell you very little. Once you have 30 or more, look for patterns:

  • Almost no replies at all. Check eligibility and whether your CV matches the ad's keywords. Why remote job applications get rejected goes through the usual causes.
  • Screening calls but no second interviews. Your CV is fine. Work on interviews, starting with our interview question guides by role.
  • Assessments but no interviews. Spend more time on take-home tasks, or apply to fewer roles so you can do each test properly.
  • One source far ahead of the others. Put more time into that source.

How many applications you should send each week is a separate question. How many remote jobs to apply for each week covers it.

Using your tracker to spot scams

A few extra notes in your tracker help you catch fake recruiters. When a "recruiter" contacts you, record the email domain and compare it with the company website you logged. Any request for money, whether a "training fee", "equipment deposit" or "visa processing", is a red flag. Write it in the notes and stop. Genuine employers don't charge applicants to be hired.

Watch also for a recruiter claiming to follow up on an application your tracker shows you never made. Our guide to spotting remote job scams in Nigeria lists the patterns to look for.

Keep the tracker itself private. It contains names, emails and sometimes salary details. Don't put your NIN, BVN or bank details in it, and don't share the edit link publicly.

Common tracking mistakes

  • Logging applications days later. You forget the CV version and the pay range. Log while the tab is still open.
  • Too many columns. A 25-column sheet you never update is worse than a seven-column sheet you keep current.
  • Free-text statuses. Use a dropdown so you can count.
  • No next action dates. Without them, follow-ups depend on memory.
  • Not saving the job ad. Ads disappear when a role closes, often right before the interview where you need them.
  • Tracking only "real" applications. Log referrals, cold emails to hiring managers and freelance proposals too, with source noted, so you can compare channels.
  • Never closing rows. Mark dead applications "No response" and move on. A long list of open applications makes the search feel worse than it is.

Frequently asked questions

What is the best free way to track remote job applications?

A Google Sheet with dropdown statuses, plus a Gmail label, is the simplest free setup. It works on a phone, saves automatically and lets you add Nigeria-relevant columns such as location rule and pay currency, which most ready-made trackers don't include.

What columns should a job application tracker have?

At minimum: company, role, job ad link, date applied, location rule, status and next action date. Once the habit sticks, add hiring setup (contractor or EOR), pay and currency, team time zone, CV version, source and recruiter contact.

How long should I wait before marking an application as no response?

Pick a fixed rule and apply it to every row. A common approach is about four weeks after applying, or two weeks after an unanswered follow-up. Some employers reply after you've closed a row. If that happens, reopen it and update the status.

Can I see the status of my application on the employer's system?

Sometimes. Greenhouse's MyGreenhouse portal can show applications made through Greenhouse-hosted forms, but employers decide what to share and may only show a high-level status. For anything else, ask the recruiter directly and log their reply in your own tracker.

Should I pay for a job tracking app?

Usually not at first. Huntr's free plan tracks up to 100 jobs as of October 2026, and a spreadsheet costs nothing. Consider paying only if you apply at high volume and the time saved on data entry clearly matters to you.

How do I stop job emails getting lost among other mail?

Create a Gmail filter that matches common application subject lines and applies a label like "Job search". Add new senders as they appear, and use the same email address for every application so all updates land in one inbox.

Should I track freelance proposals in the same sheet?

Yes, if you're pursuing both. Mark the source as Upwork, a cold pitch or similar, and the hiring setup as freelance. Keeping everything in one sheet lets you compare how freelance work and full-time applications are performing for you.

Key takeaways

  • Keep one tracker for every application, log entries the same day, and give every row a status and a dated next action.
  • Add the columns generic templates leave out: location rule, hiring setup, pay currency, time zone and CV version.
  • Use a short, fixed status list with dropdowns so you can filter and count.
  • A Gmail filter and label, plus the same email address for every application, means updates don't get lost.
  • Employer portals like MyGreenhouse are useful for cross-checking but only show what each employer chooses to share.
  • Review your numbers weekly, and change your CV, sources or eligibility checks based on what the data shows.

Next steps

Set up your sheet today, then fill it with roles you can actually take. Search remote jobs open to applicants in Nigeria, where each listing shows where applicants may live. After a search, use "Get email updates" to get new matches by email each day, then log the ones you apply to. If your tracker shows plenty of applications but few screening calls, start with your CV: how to write a CV for international remote jobs explains what to change. If you'd rather have someone do it, the WorkRemote team rewrites CVs and LinkedIn profiles as part of Premium CV and LinkedIn review.

Sources

Share or discuss this article

All posts