Demo

Code For Enrichment action (Snov.io)

// First, send an api request to get the token 

let tokenResponse = await remoteFetchAsync("https://api.snov.io/v1/oauth/access_token", {
  method: 'POST', 
  headers: {
    'Content-Type': 'application/json'
  },
  body: JSON.stringify({
    "grant_type": "client_credentials",
    "client_id": "YOUR_CLIENT_ID",
    "client_secret": "YOUR_CLIENT_SECRET"
  })
})

// create a variable from the response

var data = await tokenResponse.json();
let token = data.access_token;

// Get the url from the record

let table     = base.getTable('Leads');
let record    = await input.recordAsync('Select a record to use', table);
let url       = record.getCellValue('Linkedin URL');

var requestOptions = {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
    'Authorization': `Bearer ${token}`
  },
  body: JSON.stringify({
    url: `${url}`
  })
};

let addForSearch = await remoteFetchAsync("https://api.snov.io/v1/add-url-for-search", requestOptions)

let response = await remoteFetchAsync("https://api.snov.io/v1/get-emails-from-url", requestOptions)

// Get lead first name from response (stored in data["firstName"])

var data = await response.json();
let firstName = data["data"]["firstName"];
let lastName = data["data"]["lastName"];
let companyName = data["data"]["currentJob"][0]["companyName"]
var email = "" 

try {
  var email = data["data"]["emails"][0]["email"]
} catch (error) {
}

console.log(data["data"])

// Update the record with the new values
table.updateRecordAsync(record, {
  "First Name": firstName,
  "Last Name": lastName,
  "Email": email,
  "Company Name": companyName
});

Code For "Send to Instantly"

//Airtable script to send a contact to the instantly.ai API

let table = base.getTable('Leads');

// This is triggered when a button is pressed. Get the value of the record that was passed in
let record = await input.recordAsync('Select a record to use', table);

// Get the variables content from the "Message Sets" table belonging to the record 

let email                     = record.getCellValue('Email');
let firstName                 = record.getCellValue('First Name');
let lastName                  = record.getCellValue('Last Name');
let companyName               = record.getCellValue('Company Name');

// create a function which takes a string and replaces {{firstName}} and {{lastName}} with the first and last name of the contact

function replaceNames(text) {
  if (typeof text === 'string') {
    return text.replace("{{firstName}}", firstName)
               .replace("{{lastName}}", lastName)
               .replace("{{companyName}}", companyName);
  } else {
    // Handle the case where text is not a string
    // You might want to return an empty string, the original text, 
    // or log an error message, depending on your needs
    console.error( typeof text )
    console.error("Input to replaceNames is not a string:", text);
    return ""; // or return text;
  }
}

// Get the content of the emails from the "Message Sets" table belonging to the record
let firstEmailContent         = replaceNames(record.getCellValue('First Email Content')[0]);
let secondEmailContent        = replaceNames(record.getCellValue('Second Email Content')[0]);
let thirdEmailContent         = replaceNames(record.getCellValue('Third Email Content')[0]);

// Now, create the request to the API

var myHeaders = new Headers();

var raw = JSON.stringify({
  "api_key": "YOURKEY",
  "campaign_id": "YOURCAMPAIGNID",
  "skip_if_in_workspace": "true",
  "leads": [
    {
      "email": `${email}`,
      "first_name": `${firstName}`,
      "last_name": `${lastName}`,
      "company_name": `${companyName}`,
      "custom_variables": {
        "firstEmailContent": `${firstEmailContent}`,
        "secondEmailContent": `${secondEmailContent}`,
        "thirdEmailContent": `${thirdEmailContent}`
      }
    }
  ]
});

var requestOptions = {
  method: 'POST',
  headers: {
    'Content-Type': 'application/json',
  },
  body: raw,
  redirect: 'error'
};

let response = await remoteFetchAsync("https://api.instantly.ai/api/v1/lead/add", requestOptions)

console.log(await response.text());