Use Enrich Layer's APIs Within Google Sheets: Introducing Sapiengraph!
July 18, 2023
3 min read
Have you ever wanted to integrate Enrich Layer's APIs into your spreadsheet data? Or maybe you don't code - you prefer working within Google Sheets using...
Have you ever wanted to integrate Enrich Layer'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](https://sapiengraph.com/?utm_ Enrich Layer'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](https://sapiengraph.com/docs?utm_
=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](https://sapiengraph.com/docs?utm_
=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 Enrich Layer:
`import os, requests
api_ 'url': 'https://www.professionalsocialnetwork.com/company/stripe/', } 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 Enrich Layer'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.
Lite Pro Pro+ Business
Pricing $49/mo $299/mo $899/mo $1899/mo
Credits 12,500/mo 125,000/mo 449,500/mo 1,055,000/mo
Formula Uses
Up to 12,500/mo* Up to 125,000/mo* Up to 449,500/mo* Up to 1,055,000/moDepending on the complexity of the formula, [different formulas have different credit costs](https://sapiengraph.com/docs?utm_ 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](https://sapiengraph.com/login?utm_ 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](https://sapiengraph.com/?utm_ - you'll start with 100 credits for free. Enjoy