dashdash Setup Guide

by the dashdash team

dashdash_full_logo.png

dashdash is the spreadsheet with the best business data and APIs. It allows you to easily access online services and build automated applications using the spreadsheet skills you already have.

What does this mean?

  • A familiar user experience: We built dashdash to be a grid that builds on the spreadsheet skills that 1 billion people already have.
  • The best online services: Type Excel-like functions to get data from online services or talk to any API. We have integrations for Clearbit, FullContact, Slack, Google Maps, Google Custom Search, SendGrid, Alpha Vantage, and others. Generate leads, get data about people and companies, send emails, and more. All from inside a cell—no scripts needed anymore!
  • Automate workflows: Set up periodically running functions to automate your tasks.
  • Manage your data: Send data from a source into a target table. Your spreadsheet becomes a database!

 Once you add the Clearbit integration to dashdash, you can interact with Clearbit's Enrichment API by using the following functions:

  • GET_COMPANY_CLEARBIT
    This function enriches a URL with company data. Data includes company description, industry, employee count, annual revenue, address, social following, and more.
  • GET_PERSON_CLEARBIT
    This function enriches an email address with data about the person. Data includes full name, location, company, title, seniority level, social following, and more.
  • GET_PERSONCOMPANY_CLEARBIT
    This function enriches an email address with data of the person searched and the corresponding company. Data includes role, location, social following, company description, industry, employee count, and more.

You may also talk to any other Clearbit endpoint with the generic web requests GET and POST. Learn more about how to use generic web requests in dashdash here.

The great thing about dashdash is that you can mesh up your Clearbit data with any other online service, such as:

For more custom apps that you can build with dashdash, check out our forum or our blog.

How to integrate Clearbit with dashdash

You can integrate Clearbit with dashdash in 3 simple steps:

  1. Get your Clearbit API key
  2. Connect the Clearbit integration to your dashdash account
  3. Get data of companies and people by using our custom functions

 

  1. Get your Clearbit API key

 Log into your Clearbit account and find your secret API key here.

  1. Connect the Clearbit integration to your dashdash account

Now, head to your dashdash account and log in. Then, navigate to Integrations in our dashboard and select the Clearbit integration. Insert your API key, hit Connect, and voilà! Now you're able to pull Clearbit data into your dashdash spreadsheet. 

  1. Get data of companies and people by using our custom functions

On to the fun part! Let’s start by pulling powerful company data from the Clearbit API into your dashdash spreadsheet. Create an app in dashdash, insert the company's URL and use the next column to make your request:

A2 = uber.com
B2 = GET_COMPANY_CLEARBIT(A2)

Image_1_clearbit.png


The data explorer in B2 returns the search results from your request. If you click on the window toggle next to {data}, you can crawl the information directly from within the data explorer and parse any data points you need.

In this example, we'll parse for the Founding Year, Subindustry, Tags, Revenue, Employee Count, and Twitter Followers.

There's two ways to parse data from the data explorer ({data} in B2).

a) Simply look for the data you need in the data explorer, click copy next to it, and paste the copied formula into the desired cell (Tip: Use the Search function (Cmd + F) to look up variables).

Parse_Founding_Year_Clearbit.gif

 

b) By using the formula C2 = PARSE(B2, "['foundedYear']")
If you'd like to parse for other variables like Revenue or Employee Count, simply replace  "['foundedYear']" with the appropriate variable from the data explorer. Be sure to respect the nested structure where applicable, like so:
H2=PARSE(B2, "['twitter'].['followers']")

Image_2_clearbit.png

 

Similarly, you can also access data about a person. All you need is their email address:

A2 = alex@clearbit.com
B2 = GET_PERSON_CLEARBIT(A2)

 

Image_3_clearbit.png

Then, just follow the steps above and parse valuable data such as Name, Company, Title, Location, Personal Website, Twitter Handle, Twitter Followers, and more.

Image_4_clearbit.png

 

And that's it! We can't wait to see what you'll build with Clearbit in dashdash :)

Read more about what you can do with dashdash in our forum or on our blog and follow us on Twitter to stay on top of our latest updates.

 

***