Formulas for
Job Search is a jobs API that searches the open positions at thousands of companies at once. Search by job title keywords, location, country, remote work, employment type, posting date or company, and get the newest matching jobs first, each with its title, company, location, country, workplace type, posting date and apply link. Paid plans add salary ranges, a minimum salary filter, larger pages and each job's full description.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 20 credits per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Fill =VERVE("jobsearch", "software engineer", "field", "page") down a column and Job Search returns a result for every row — a batch of live values in a single drag, no code.
Add Job Search beside a table you already have to append its output right where your data lives, then sort, filter, or chart on it.
Set the sheet to refresh on a schedule and the job search values keep themselves current without anyone re-typing.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Google SheetsAdd-onInstall from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("jobsearch", "software engineer", "field", "page")
Microsoft ExcelAdd-inSame source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("jobsearch", "software engineer", "field", "page")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
Return only jobs with a location containing this text, for example London, New York or Bavaria.
=VERVE("jobsearch", "software engineer", "location", "New York")Return only jobs in this country: an ISO 3166 code or a name, for example US, GB or Germany.
=VERVE("jobsearch", "software engineer", "country", "US")true returns only jobs open to remote work; false only jobs that are not.
=VERVE("jobsearch", "software engineer", "remote", "true")Return only jobs of this employment type. Jobs that give no employment type are kept, since many companies leave it blank; only jobs of another type are left out.
=VERVE("jobsearch", "software engineer", "employmentType", "full-time")Return only jobs first published at or after this date or date-time (ISO 8601, for example 2026-10-01), or within this age: a number followed by h, d or w, for example 12h, 7d or 2w.
=VERVE("jobsearch", "software engineer", "postedSince", "7d")Return only jobs at this company, by its career board name, usually the company name in lowercase, for example airbnb.
=VERVE("jobsearch", "software engineer", "company", "airbnb")Return only jobs whose salary range reaches at least this amount, in the job's own currency and pay period. Jobs that publish no salary are left out when this is set.
=VERVE("jobsearch", "software engineer", "minSalary", "100000")Page of results: 10 jobs per page up to page 5 on the free plan, 50 per page up to page 10 on paid plans.
=VERVE("jobsearch", "software engineer", "page", "1")Add a field name as the last argument to land just that value in the cell.
=VERVE("jobsearch", "software engineer", "field", "count")=VERVE("jobsearch", "software engineer", "field", "hasMore")=VERVE("jobsearch", "software engineer", "field", "jobs")=VERVE("jobsearch", "software engineer", "field", "jobs.0.id")=VERVE("jobsearch", "software engineer", "field", "jobs.0.title")=VERVE("jobsearch", "software engineer", "field", "jobs.0.company")=VERVE("jobsearch", "software engineer", "field", "jobs.0.location")=VERVE("jobsearch", "software engineer", "field", "jobs.0.locations")=VERVE("jobsearch", "software engineer", "field", "jobs.0.country")=VERVE("jobsearch", "software engineer", "field", "jobs.0.remote")=VERVE("jobsearch", "software engineer", "field", "jobs.0.workplaceType")=VERVE("jobsearch", "software engineer", "field", "jobs.0.employmentType")Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans
Everything you need to wire it into a sheet.
