Scripting in Google Sheets gives you super power, and it’s very easy to use APIs to enrich your document.
In this article I’ll show you how-to:
Create custom functions in Google Sheets
Use Clearbit API to translate a company name into a company domain
Use Apollo API to get details about a company using a company domain
Bonus: Use Google CacheService to avoid API rate limits
We recently highlighted a Medium post on How to get Linkedin profiles in Google Sheets. Here is a similar example which combines data from the Clearbit and Apollo to return company information including other social media urls and more.
Image credit: Alexis Laporte
Some great tips in this post including using the Cache Service, find out more via the source link 👇.
