ScrapeField

Blog · Guides ·

LinkedIn profiles into a Google Sheet, with Zapier

Paste a profile URL into a sheet; a minute later the row has the name, headline and employer. One Zap, three steps, no connector to install.

ScrapeField

The most common thing people build on LinkedIn data is a list that fills itself in: someone adds a profile URL to a spreadsheet, and the rest of the row appears. In Zapier that is one Zap with three steps. There is no connector to install, because Zapier’s own Webhooks by Zapier can call any API that takes a URL and a header, which is all ours takes.

You need a Zapier plan that includes Webhooks by Zapier (its paid plans do; the free plan does not) and an API key from us. The 2,000 free credits cover 200 profiles.

1. The trigger: a new row

Start with a sheet whose first column is LinkedIn URL, and add empty columns for what you want back: Name, Headline, Location. In Zapier, choose Google Sheets → New Spreadsheet Row and point it at the sheet.

2. The call: Webhooks by Zapier, GET

Add an action, Webhooks by Zapier → GET, and fill in:

FieldValue
URLhttps://api.scrapefield.com/v1/linkedin/profile
Query String Paramsurl → the LinkedIn URL column from step 1
HeadersAuthorizationBearer sf_live_… (your key)

Test the step. To try it before you have a key, leave the header out and add a second query parameter, demotrue: every endpoint answers demo calls with sample data in exactly the real shape, free. Remove it before you turn the Zap on.

3. The write: update the row

Add Google Sheets → Update Spreadsheet Row. For the row, pick the row id from step 1. For each column, pick from step 2’s result: Data Full Name, Data Headline, Data Location. Every field in the profile schema is there to map, from the current employer to the full work history.

What it costs, and what can go wrong

A profile is 10 credits: $7.80 per 1,000 on the smallest pack, $4.00 on the largest. A profile that doesn’t exist comes back as a 404 with an error that says so, costs nothing, and stops that run; the row stays as it was, so a bad URL is easy to spot. Answers are cached for up to 12 hours, so the same profile twice in a day comes from cache, and is charged the same.

The same three steps work for any endpoint: swap the URL for company pages, Google Maps places or Instagram profiles, and change the column you pass in.

More articles