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.