LinkedIn Enrichment in Google Sheets

/**
 * Enrich a value with LinkFinder AI.
 * @param {string} input   The cell value (name, email, company, or LinkedIn URL)
 * @param {string} type    The request type, e.g. "company_name_to_website"
 * @customfunction
 */
function LINKFINDER(input, type) {
  var apiKey = "YOUR_API_KEY"; // or use PropertiesService for safety
  var res = UrlFetchApp.fetch("https://api.linkfinderai.com", {
    method: "post",
    contentType: "application/json",
    headers: { "Authorization": "Bearer " + apiKey },
    payload: JSON.stringify({ type: type, input_data: input }),
    muteHttpExceptions: true
  });
  var data = JSON.parse(res.getContentText());
  if (data.status !== "success" || !data.result) return "Not found";
  // Return a single field, or JSON.stringify(data.result) for everything
  return typeof data.result === "object"
    ? JSON.stringify(data.result)
    : data.result;
}

// In any cell, call it like a normal formula:

=LINKFINDER(A2, "company_name_to_website")     // company → website
=LINKFINDER(A2, "leads_finder_ai")             // describe leads in A2

// Tip: pull one field out of the JSON result
=INDEX(SPLIT(LINKFINDER(A2,"company_name_to_website"),","),1)

// Or keep the raw JSON in a helper column and parse with
// your preferred method.

/**
 * Bulk enrich column A → write result to column B.
 * Run from the Apps Script editor (Run ▸ enrichColumn).
 * Safer than per-cell formulas for large sheets.
 */
function enrichColumn() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange().getValues();
  var apiKey = PropertiesService.getScriptProperties().getProperty("LF_KEY");

  for (var i = 1; i < rows.length; i++) {      // skip header row
    var input = rows[i][0];                    // column A
    if (!input || sheet.getRange(i + 1, 2).getValue()) continue; // skip done
    var res = UrlFetchApp.fetch("https://api.linkfinderai.com", {
      method: "post",
      contentType: "application/json",
      headers: { "Authorization": "Bearer " + apiKey },
      payload: JSON.stringify({ type: "company_name_to_website", input_data: input }),
      muteHttpExceptions: true
    });
    var data = JSON.parse(res.getContentText());
    sheet.getRange(i + 1, 2).setValue(           // column B
      data.status === "success" ? JSON.stringify(data.result) : "Not found"
    );
    Utilities.sleep(300);                        // gentle on rate limits
  }
}

# Prefer no code? Use Make (Integromat):
# 1. Trigger: "Google Sheets ▸ Watch Rows"
# 2. Action:  "HTTP ▸ Make a request"
#       URL:    https://api.linkfinderai.com
#       Method: POST
#       Header: Authorization: Bearer YOUR_API_KEY
#       Body:   {"type":"company_name_to_website","input_data":"{{column_A}}"}
# 3. Action:  "Google Sheets ▸ Update a Row" with the result

# The same pattern works in Zapier (Webhooks by Zapier ▸ POST).