LinkedIn Jobs to Google Sheets

Turn a column of LinkedIn job URLs into title, company, location, seniority, salary, applicant count and description with one formula. No login, no IMPORTXML.

=LINKEDIN_JOB(A2)

Install from Google Workspace Marketplace, choosing Individual install for your account. Open a spreadsheet, then Extensions → FalconScrape → Activate / Account → Activate with Google. Enter the formula in an empty area; results expand down and right with a header row. Cell references such as A2 must contain a valid input.

Formula parse error? Check your spreadsheet locale.

Examples use commas between arguments. For locales such as Poland, use semicolons instead:

=OLX_SEARCH("iphone 15"; "pl"; 1; "limit=5")

Change separators only outside quoted text; keep options such as "limit=5;sort=price_asc" unchanged. Check File → Settings → Locale. Your Google account language is a separate setting.

LinkedIn Jobs to Google Sheets — example result — Select the screenshot to view it at full size.

More examples

=LINKEDIN_JOB(A2:A5)

Columns

idtitlecompanylocationpostedemploymentTypeseniorityLeveljobFunctionindustriessalaryTextsalaryMinsalaryMaxsalaryCurrencysalaryPeriodapplicantCountapplyTypeurlcompanyUrlcompanyLogodescriptionscrapedAt

2 credits per job. A range returns one row per URL in input order; a bad URL shows its error in column A and costs nothing. See plans and credits.

Refresh results

Run Extensions → FalconScrape → Refresh all once to create the FALCON_REFRESH named range. Then use this version of the formula:

=LINKEDIN_JOB(A2, FALCON_REFRESH)

Refresh all updates the marker. Formulas referencing a marker less than 60 seconds old request fresh results, which consume credits when successful. Formulas without the reference are unaffected. Normal cache hits cost nothing; there is no scheduled refresh or automatic price-history log.

FAQ

Why doesn't IMPORTXML work on LinkedIn?: LinkedIn answers Google's fetcher with a login wall, so IMPORTXML gets an empty page. FalconScrape reads the public job page the way a logged-out visitor sees it.
Do I need a LinkedIn account?: No. Only public job postings are read; nothing is done on your behalf and no LinkedIn credentials are ever asked for.
Can I paste a whole column of URLs?: Yes — =LINKEDIN_JOB(A2:A50) fetches them in parallel and returns one row per URL, keeping your order.
How do I start?: Paste a current public job URL into A2, then enter =LINKEDIN_JOB(A2) in B1. Keep B1:V2 empty before entering it. For a range of URLs, allow one result row per non-blank input plus the header.
Which URL formats are accepted?: Any linkedin.com/jobs/view/… link, links with currentJobId=…, or the numeric job id on its own.

Free trial: 200 credits, 30 days, no card.

Install the approved add-on and activate from Extensions → FalconScrape → Activate / Account. Your trial starts at activation. Paid checkout is currently unavailable. All sites and pricing.