---
title: "How to retrieve company info in Google Sheets with Clearbit and Apollo API"
author: "Martin Hawksey"
date: 2022-02-24T22:22:57+00:00
modified: 2022-02-24T22:23:27+00:00
canonical_url: https://pulse.appsscript.info/p/2022/02/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api/
markdown_url: https://pulse.appsscript.info/p/2022/02/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
tags:
  - "@AlexisLaporte"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2022/02/1T188N2pLl_Ru_2VK41ywtQ.png
description: "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.  Some great tips in this post including using the Cache Service, find out more via the source link."
---

# How to retrieve company info in Google Sheets with Clearbit and Apollo API

![How to retrieve company info in Google Sheets with Clearbit and Apollo API](https://pulse.appsscript.info/files/2022/02/1T188N2pLl_Ru_2VK41ywtQ.png)

> [https://medium.com/@alexislaporte/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api-cf25d1943fc3](https://medium.com/@alexislaporte/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api-cf25d1943fc3)Image credit: Alexis Laporte
> 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](https://clearbit.com/) API to translate a company name into a company domain
> Use [Apollo](https://apollo.io/) 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](https://pulse.appsscript.info/p/2022/02/how-to-get-linkedin-profiles-and-other-google-custom-search-results-in-google-sheets-with-a-formula/). Here is a similar example which combines data from the Clearbit and Apollo to return company information including other social media urls and more.

[![](https://pulse.appsscript.info/files/2022/02/1dxq6eo2KKB9ywTnTH-6wMg.png)](https://medium.com/@alexislaporte/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api-cf25d1943fc3)Image credit: Alexis Laporte

Some great tips in this post including using the Cache Service, find out more via the source link 👇.

Source: *[How to retrieve Company info in Google Sheets with Clearbit and Apollo API*](https://medium.com/@alexislaporte/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api-cf25d1943fc3)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/02/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api/](https://pulse.appsscript.info/p/2022/02/how-to-retrieve-company-info-in-google-sheets-with-clearbit-and-apollo-api/)*