In this tutorial, you will learn how to find companies based off a certain tool a company uses, create a list of those companies, enrich that company data, and export it to Hubspot.
What you'll need
Estimated time to complete
- 20 minutes
Under Integrations in dashdash, search for BuiltWith and connect dashdash to BuiltWith. Now, click on My Spreadsheets and create a new spreadsheet by clicking on the green button in the top right corner.
Create the following columns: GET API URL, Tool, GET Request, Companies, URLs.
Hop into BuiltWith, click on Tools, and select API Access. Click on Lists API. Grab the 2nd URL under 'Get List.' Copy and paste it into A2 in your dashdash spreadsheet. Delete anything after TECH= in the URL.
Enter in the tool you want to source companies based off of in column B2.
In C2, enter =GET(A2&B2). Hit Enter.
In D2, enter =PARSE(C2, 'Results.[*].D') then press Enter.
In E2, enter =PARSE(D2)
Choose a place in the A column to start numbering, beginning with 0 (for this video, A4). Next to 0 in the B column, enter the following formula: =PARSE($E$2, "["&A4&"]") then hit enter. Drag this formula down the B column.
In your dashdash spreadsheet, create a new View in the left side panel. Create the following column header: URL. Skip two columns. Then create Name, Description, State.
In A2, enter the formula ='View1'!A4. Pull this formula down the column.
In B1, enter Get All. In B2 and onwards, enter the text Get Info. Select all of these cells, and click on the button option from the toolbar.
In C2, enter the formula =IF(OR(B2="GET INFO",$B$1="GET ALL"),GET_COMPANY_DETAIL_CRUNCHBASE(A2), "PRESS 'GET INFO'"). Drag this formula down the column.
In D2, enter the formula =IFERROR(PARSE(C2, "organizations.name"),""). Drag down the column.
In E2, enter the formula =IFERROR(PARSE(C2, "organizations.shortDescription"),""). Drag down the column.
In F2, enter the formula =IFERROR(PARSE(C2, "organizations.region"),""). Drag down the column.
Log in to Hubspot and connect Hubspot in the Integrations tab of dashdash.
In G1, name the column 'Send to Hubspot'. In G2, enter =ADD_COMPANY_HUBSPOT(D2, "domain", A2).
I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.
For access to this full tutorial please head over to https://www.makerpad.co