LinkedIn profiles in Airtable: enrich records with a Run a script action

• An Airtable plan with the Run a script action: Team or above. Airtable's Free plan and a Team plan trial don't have it.
• A Datacircle API key: Log in at datacircle.dev/login with your work email. Your API key is on the page once you're in. You get a $5 credit, enough for 2,105 profiles through Up2Data.
• A table with a LinkedIn URL field, holding URLs like https://www.linkedin.com/in/williamhgates.

Add these fields to your table. The script writes each one, whatever our API answers:

Other field names work too: change them on the script's FIELDS line. Our LinkedIn Profile API page shows the profile's other fields, such as jobs and schools.

Create an automation, and pick When record matches conditions as its trigger:

The automation runs on a new record as soon as you fill in its LinkedIn URL. The script then writes its Status, so the record no longer matches and the automation doesn't run on it again. To run a record again, clear its Status.

Add a Run a script action, and give it two input variables:

Then paste the code below. Put your key between the quotes on the KEY line and your table's name on the TABLE line.

// LinkedIn profiles in Airtable, through Datacircle: Up2Data, then Fetchin past Up2Data's daily limit.
// Input variables: recordId, the trigger's record ID, and linkedinUrl, its LinkedIn URL. Your key goes in KEY.
const KEY = "your Datacircle API key"
const TABLE = "People" // your table's name
// Your fields' names: single line text, and a number field for the cost
const FIELDS = { status: "Status", title: "Job title", company: "Company", location: "Location", headline: "Headline", cost: "Cost (USD)" }

const { recordId, linkedinUrl } = input.config()

async function call(method, path, provider, body) {
  const headers = { Authorization: "Token " + KEY, "X-Data-Provider": provider }
  if (body) headers["Content-Type"] = "application/json"
  let response
  try {
    response = await fetch("https://api.datacircle.dev" + path, { method, headers, body: body && JSON.stringify(body) })
  } catch (error) {
    return { status: "no answer", body: { error: error.message } } // Airtable stops a fetch after 30 seconds
  }
  const answer = await response.json().catch(() => ({})) // a gateway's error page isn't JSON: its status says enough
  return { status: response.status, body: answer }
}

function row(status, found = {}) {
  const all = { status, title: "", company: "", location: "", headline: "", cost: 0, ...found }
  for (const key in all) if (all[key] === undefined || all[key] === null) all[key] = key === "cost" ? 0 : ""
  return all
}

function failed(answer) {
  const reason = (answer.body.error && answer.body.error.message) || answer.body.error
  return row(reason ? "error " + answer.status + ": " + reason : "error " + answer.status)
}

async function profile(url) {
  const up2data = await call("POST", "/v1/profiles/enrich", "up2data", { url })
  if (up2data.status === 200) {
    const data = up2data.body.data
    const company = data.current_company || {}
    return row("found", {
      title: company.title, company: company.name, location: (data.location || {}).raw, headline: data.headline,
      cost: up2data.body.datacircle_meta.cost_usd,
    })
  }
  if (up2data.status === 422) return row("not found: private or deleted, free")
  if (up2data.status === 400) return row("not a profile URL, free")
  if (up2data.status !== 429) return failed(up2data)

  // Up2Data's daily limit: the same URL through Fetchin, with the same key
  const fetchin = await call("GET", "/api/v1/profile?profileUrlOrUrn=" + encodeURIComponent(url), "fetchin")
  const body = fetchin.body
  if (fetchin.status === 200) {
    return row("found (Fetchin)", {
      title: body.jobTitle, company: body.companyName, location: body.location, headline: body.title,
      cost: body.datacircle_meta.cost_usd,
    })
  }
  if (fetchin.status === 404 && body.code === "PROFILE_NOT_FOUND") {
    return row("not found (Fetchin): private or deleted, billed", { cost: body.datacircle_meta.cost_usd })
  }
  if (fetchin.status === 400) return row("not a profile URL, free")
  return failed(fetchin)
}

const found = await profile(linkedinUrl)
const update = {}
for (const key in FIELDS) update[FIELDS[key]] = found[key]
await base.getTable(TABLE).updateRecordAsync(recordId, update)
output.set("status", found.status)

Airtable's test button makes a real call, and we bill that call like any other.

Anyone who can edit the automation sees your key in the script. If your Datacircle key leaks, send a POST to https://api.datacircle.dev/me/api-key/reset/ with it, as our quickstart shows: you get a new key, and the old one stops working.

The script writes a Status for every answer, so a private profile can't stop the automation. For an error record, fix what its reason says, then clear its Status to run it again. A record with error no answer reads 0 in Cost (USD) even when we billed the call: your balance shows the charge. If you run it again, we bill the new call like any other. Airtable counts every run against your plan, failed or not.

Up2Data takes $1 a day per account (421 profiles), with a shared daily limit for all customers, then answers 429 until 00:00 UTC. HarvestAPI has no daily limit. Fetchin has no daily limit either. A call your balance can't cover answers 402. Add funds, from $5, on your dashboard.

Airtable runs the automation on a record when it starts to match the conditions. It skips records that already match when you turn it on. To fill the records you have:

1. Before you turn the automation on, type any word, like wait, in their Status.
2. Turn the automation on.
3. Clear their Status. Each record starts to match, and the automation runs on it.

Each record is one run. Airtable allows 25,000 runs a month per workspace on Team and 100,000 on Business, so a table with more records than that takes more than a month. Up2Data fills at most 421 records a day, and Fetchin fills the rest. If many records run at once, some may hit Fetchin's rate limit, which all our customers share: they get error 429, and you clear their Status to run them again.

We charge your balance these prices, with no markup, as our pricing page shows:

If 1,000 new records come in one day and the providers find every profile, you pay us $1.86 at most: $1.00 for 421 through Up2Data and $0.86 for the other 579 through Fetchin. Fetchin costs less per profile found but bills a profile it can't find, which Up2Data doesn't. Trying Up2Data first costs less only when more than about 37% of your URLs are private or deleted. The script tries it first because you may not know how many of your URLs are gone, and a profile Up2Data can't find costs nothing. If the providers find more than about 63% of yours, Fetchin alone costs less: delete the script's lines from const up2data to return failed(up2data), and the script sends each record to Fetchin.

The same call in n8n: LinkedIn profiles in n8n. In a Zap: LinkedIn profiles in Zapier. In a Make scenario: LinkedIn profiles in Make. In a Clay table: LinkedIn profiles in Clay. In a Google Sheet: LinkedIn profiles in Google Sheets. Other vendors' prices per 1,000: LinkedIn profile API pricing compared.