LeadOcean + Google Sheets: enrich rows automatically

You can enrich a Google Sheet with LeadOcean using Apps Script and no add-on. The script reads an email or LinkedIn URL from each row, calls POST /v1/people/enrich, and writes job title, company and phone back to the same row. Google Sheets has no native HTTP block, so Apps Script's UrlFetchApp is the integration.

This is a recipe, not a marketplace app. LeadOcean has no Sheets add-on, and you do not need one.

How it works

1. Create an API key. Sign up at app.leadocean.io, open API keys, and copy a key. The Free plan gives both scopes (search and enrich) inside 1,000 records.
2. Lay out the sheet. Put emails in column A or LinkedIn URLs in column B. Leave columns C to G empty for the output, and add a status column in H.
3. Store the key. In Extensions, Apps Script, open Project Settings and add a script property named LEADOCEAN_API_KEY. Never paste the key into a cell or the code.
4. Paste the script from the Configuration section and save.
5. Run enrichRows once by hand. Google asks you to authorize external requests. Accept it for your own script.
6. Watch the rows fill. Rows with a result get done in column H. A person LeadOcean holds nothing for gets no match.
7. Schedule it. In Triggers, add a time-driven trigger for enrichRows, every hour or every day.

Dedupe is built in. The script skips any row where column H is already filled, and it skips an email it has already seen in the same run. A re-run never spends a second record on the same row.

Configuration

This script uses the canonical endpoint and the x-api-key header. It processes 200 rows per run so it stays inside Apps Script's 6-minute execution limit. RATE sends that many calls at once, then waits a second, to stay under your plan's requests a second.

const BASE = "https://api.leadocean.io";
const BATCH = 200;
const RATE = 5;   // requests a second: 5 on Free, 50 on Solo, 200 on Agency

function enrichRows() {
  const key = PropertiesService.getScriptProperties().getProperty("LEADOCEAN_API_KEY");
  const sheet = SpreadsheetApp.getActiveSheet();
  const last = sheet.getLastRow();
  if (last < 2) return;
  const rows = sheet.getRange(2, 1, last - 1, 8).getValues(); // A..H
  const seen = {};
  const todo = [];

  rows.forEach((r, i) => {
    const email = String(r[0]).trim().toLowerCase();
    const linkedin = String(r[1]).trim();
    const id = email || linkedin;
    if (!id || r[7] || seen[id]) return;       // skip done and duplicate rows
    seen[id] = true;
    if (todo.length < BATCH) todo.push({ row: i + 2, email, linkedin });
  });

  const requests = todo.map(t => ({
    url: BASE + "/v1/people/enrich",
    method: "post",
    contentType: "application/json",
    headers: { "x-api-key": key },
    payload: JSON.stringify(t.email
      ? { email: t.email, reveal_email: true }
      : { linkedin_url: t.linkedin, reveal_email: true }),
    muteHttpExceptions: true
  }));

  for (let s = 0; s < requests.length; s += RATE) {
    const responses = UrlFetchApp.fetchAll(requests.slice(s, s + RATE));
    responses.forEach((res, k) => {
      const row = todo[s + k].row;
      const code = res.getResponseCode();
      if (code === 404) { sheet.getRange(row, 8).setValue("no match"); return; }
      if (code !== 200) { sheet.getRange(row, 8).setValue("error " + code); return; }
      const d = JSON.parse(res.getContentText()).data;
      const prof = d.profile_data || {};
      const c = d.contact_data || {};
      const job = (c.contact_current_experiences || [])[0] || {};
      const phone = (c.contact_phones || [])[0] || {};
      sheet.getRange(row, 3, 1, 5).setValues([[
        prof.profile_full_name || "", job.job_title || "", job.company_name || "",
        phone.phone || "", prof.profile_url || ""
      ]]);
      sheet.getRange(row, 8).setValue("done");
    });
    Utilities.sleep(1000);
  }
}

The same request from a terminal, to test a key before you touch the sheet:

curl -X POST https://api.leadocean.io/v1/people/enrich \
  -H "x-api-key: $LEADOCEAN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"email": "jane.doe@acme.com", "reveal_email": true}'

Send exactly one of linkedin_url, email, phone or person_id. There is no name plus domain lookup. To start from a company domain, search first with /v1/people/search, then enrich by person_id.

The Free plan allows 5 requests a second, Solo 50 and Agency 200. fetchAll sends its list in parallel, so set RATE to your plan's figure or you will see 429 responses with a Retry-After header.

Field mapping

Paths are under data in the response, from the enrich docs, October 2026.

The script sends reveal_email: true, which also returns contact_data.contact_emails[] with a status per address. It costs no extra record.

Cost at 10,000 rows

Ten thousand rows cost 10,000 records at most, and fewer if some do not match. A person LeadOcean holds nothing for returns 404 and costs nothing.

The Apps Script limit is the one to watch. At one call per row, a 10,000-row sheet uses half of a Gmail account's daily URL Fetch quota. Each execution is also capped at 6 minutes, which is why the script batches 200 rows and runs on a trigger.

Paid plans have a fair-use pace, not credits. Reaching it slows the key until the window resets. Nothing to top up. See pricing.

Troubleshooting

FAQ