Use Proxycurl's APIs Within Google Sheets: Introducing Sapiengraph!

Have you ever wanted to integrate Proxycurl's APIs into your spreadsheet data? Or maybe you don't code - you prefer working within Google Sheets using familiar formulas rather than writing Python scripts.

Introducing Sapiengraph: Proxycurl's new offering for B2B data directly inside Google Sheets!

Examples

To fill a Stripe's description into a cell, you can enter the following with the Company Profile Enrichment formula:

=SG_COMPANY("https://www.professionalsocialnetwork.com/company/stripe/","description")

Individual formulas are provided for accessing attributes of children; for example, to fill the city of Stripe's first location, you can use the Company Locations formula:

=SG_COMPANY_LOCATIONS("https://www.professionalsocialnetwork.com/company/stripe/","city")

To access their second location, you can add an index:

=SG_COMPANY_LOCATIONS("https://www.professionalsocialnetwork.com/company/stripe/","city", 1)

Compare to the following code with Proxycurl:

import os, requests

api_key = os.environ['PROXYCURL_API_KEY']
headers = {'Authorization': 'Bearer ' + api_key}

person_endpoint = 'https://nubela.co/proxycurl/api/Professional Social Network/company'
params = {
    'url': 'https://www.professionalsocialnetwork.com/company/stripe/',
}
response = requests.get(person_endpoint, params=params, headers=headers)
print(response.json()['locations'][1]['city'])

With Sapiengraph, you can only fetch one single data point at a time, but in exchange, the "code" to do so is significantly more concise, and you can integrate directly into Google Sheets. Take advantage of the autofill function and some formulas, and then you can retrieve all the data you might need.

This solution makes it possible for you to use the power of Proxycurl's API without any development experience at all. As a developer, you can empower non-technical people on your team to create reports without relying on you every time they need something changed. As a business leader, you yourself will be empowered to enrich data without needing to block your dev team from more production-critical features.

Pricing

Sapiengraph is priced on a no-commitment, no-contract monthly subscription basis.

*Depending on the complexity of the formula, different formulas have different credit costs, starting at 1 credit per formula.

Need more credits than this? We also offer enterprise pricing - contact us at [email protected] for more information. We also offer a limited free trial offer of 100 credits. Log in now to get started.

Get started with Sapiengraph

Excited to start using Sapiengraph? Or maybe you want to see for yourself how it works? Sign up for an account now - you'll start with 100 credits for free. Enjoy!