All templates

Automated GaijinPot Applicant Export

Every Monday, WebRun opens GaijinPot, checks your posted roles for applicants from the past week, exports each one's role, experience, and visa status as listed to a Google Sheet, and emails you a summary of who applied.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 GaijinPot pull new applicants
2 Google Sheets export their details
3 Gmail email you a summary
In short

How do I track new GaijinPot applicants in a spreadsheet?

WebRun checks your posted GaijinPot roles every Monday for applicants from the past week, reading each one's experience, location, and listed visa status. It exports every applicant to a Google Sheet organized by role, then emails you a summary, so you have a running record of who applied without checking GaijinPot yourself.

  • Every applicant is tracked in one running sheet
  • Roles with no applicants get flagged instead of going unnoticed
  • You get a weekly summary without a GaijinPot login

Built for HR teams in Japan · recruiters · international employers · language school hiring

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.gaijinpot.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    GaijinPot - pull new applicants
    gaijinpot.com
    WebRun in GaijinPot: pull new applicants
    WebRun opens GaijinPot to pull new applicants.
    • Open your posted roles and check applicants from the past week
    • Read each applicant's experience, location, and listed visa status
    • Skip applicants already exported from a previous run

    Done when Every applicant from the past week has been reviewed.

  3. 2
    Google Sheets - export their details
    google.com
    WebRun in Google Sheets: export their details
    WebRun opens Google Sheets to export their details.
    • Add a row for each applicant with role, experience, and visa status
    • Keep prior weeks in the sheet for an ongoing record
    • Sort the current week's rows by role

    Done when The sheet has a row for every applicant from the past week.

  4. 3
    Gmail - email you a summary
    gmail.com
    WebRun in Gmail: email you a summary
    WebRun opens Gmail to email you a summary.
    • Draft a summary email of the week's applicants by role
    • Send it to you with a link to the sheet
    • Note any role that received no applicants

    Done when You have this week's applicant summary in your inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.gaijinpot.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Applicant summary · Gmail
OutputWhat each run produces - A Google Sheet row for every new applicant with role, experience, and visa status, plus an email summary.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it contact applicants directly?

No. WebRun only reads and exports applications. Reaching out to a candidate stays something you do yourself on GaijinPot.

Does it export the same applicant twice?

No. It checks the sheet before adding a row, so an applicant already exported in a prior week won't be duplicated.

Can it track more than one open role?

Yes. Every posted role is checked each week, and the sheet keeps applicants sorted by which role they applied to.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.