Getting started with Sapiengraph
Sign up for Sapiengraph
First, sign up for Sapiengraph using your email address. Go to sapiengraph.com and click "Set up new account" at the top.
Follow the prompts in the signup process
After you click "Set up new account," you'll be prompted to sign in with Google.
Then you'll be prompted to install/enable two things:
If you're wondering why we need a browser extension, see: Why Do I Need a Browser Extension?
Enable Sapiengraph in your first spreadsheet
Now it's time to create your first spreadsheet!
- Go to https://drive.google.com and click New -> Google Sheets in the upper-right corner.
- Sapiengraph will explain what to do in a quick tutorial there. Read the tutorial instructions.
- After closing the tutorial, go to Extensions -> Sapiengraph -> Launch Sapiengraph
- At this point, you may be required to grant permissions to Sapiengraph in Google Sheets
- Make sure to check your pop-up blocker!
Make your first formulas!
Now it's time to make your first formula! Let's try a couple together.
Company enrichment
First, we'll use the Company Profile Enrichment formula.
Let's use Apple as our example company. We'll get their website for this example, but you can choose to fetch any piece of data from the key column in the Company data specification section.
Here's the code to copy:
=SG_COMPANY("https://www.linkedin.com/company/apple/","website")
Play around with a couple different companies and a couple different keys!
Other company formulas
Some pieces of data about companies require you to use different formulas. For example, if you want to know the office locations of a company, the correct formula is SG_COMPANY_LOCATION.
- This is a different formula because a location isn't a single value, like "name."
- Instead, each location has multiple values belonging to itself: city, state, street address, etc.
- So to let you pick each of these, you have to be requesting a "CompanyLocation" object, and not a Company object.
Here's an example formula:
=SG_COMPANY_LOCATIONS("https://www.linkedin.com/company/google/", "city")
Person enrichment
Now, let's take a look at the Person Profile Enrichment formula. Let's look up information about Satya Nadella.
In particular, we'll ask for his number of LinkedIn followers:
=SG_PERSON("https://www.linkedin.com/in/satyanadella", "follower_count")
We figured out that follower_count was the correct parameter by looking at available keys in the Person data specification.
Try a couple other keys, and some other profiles!
Other person formulas
Just like with companies, some values are present in "child" objects. You can try out the following formulas:
SG_PERSON_WORK- a work history / "experience" item. See: Person Work History formula which supports attributes from the PersonWorkHistory objectSG_PERSON_EDUCATION- an education history item. See: Person Education History formula, which supports attributes from the PersonEducation objectSG_PERSON_ACTIVITIES- an activity item. See: Person Activities formula, which supports attributes from the PersonActivity objectSG_PERSON_ARTICLES- an article that the person published. See: Person Articles formula, which supports getting articles from the PersonArticle object
More formula examples
For more formula examples, see our formula documentation. Here's a list of them all, as of launch:
Every available formula shows at least one example use.
Seeing more info about formulas
There are a couple ways to see more info about formulas. As we just saw, you can look in our documentation.
You can also look directly in the spreadsheet. Start typing a formula name, and then click on it from the drop-down menu:
It'll look something like this, depending on which formula you chose:
Next, click anywhere inside the green formula area. You'll immediately see more information about the formula you want to learn about!
From here, you have two choices:
- Proceed to use the formula!
- Delete the cell. You got what you came here for, which was the formula docs 💪
Choose a no-commitment subscription plan
Now that you know how to use Sapiengraph, it's time to choose a no-commitment subscription plan. We have no contracts and no hidden fees. You can see the credit cost for every formula you run on the documentation page.
To guarantee you don't get charged when Google refreshes your spreadsheet, we've provided a "Convert all formulas to text" option directly within your spreadsheet. It'll show up when you have "live" formulas (i.e. formulas that aren't converted to text yet):
For more information on converting to text, see: Why Should I Convert My Formulas to Text?
Learn more about Sapiengraph
To learn more about Sapiengraph, check out our launch announcement. You can also read our complete formula documentation.
How to read formula documentation
Here are a couple tips:
- Using ctrl+F can be your best friend.
- Make use of the table of contents on the left-hand side.
- If a formula argument is shown in
[], then it's optional. - Feel free to copy-paste examples directly into your spreadsheet! Even if they aren't exactly what you want to do, they can still help you learn how to use a formula. Then, you can edit them later & learn how to use the formulas even better.
- If you get stuck, ask! We recommend asking ChatGPT for help, it's great at debugging. If that doesn't work, feel free to reach out. If our documentation is confusing, we need to know so that we can clarify it.
