⭠ all tutorials

Create a targeted sales list in dashdash

Available for Unlimited All Access members only

Get access

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

  • Dashdash
  • BuiltWith
  • Crunchbase
  • Hubspot

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[0].name"),""). Drag down the column.

In E2, enter the formula =IFERROR(PARSE(C2, "organizations[0].shortDescription"),""). Drag down the column.

In F2, enter the formula =IFERROR(PARSE(C2, "organizations[0].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

The full tutorial is available for pro members only

Request access

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

  • Dashdash
  • BuiltWith
  • Crunchbase
  • Hubspot

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[0].name"),""). Drag down the column.

In E2, enter the formula =IFERROR(PARSE(C2, "organizations[0].shortDescription"),""). Drag down the column.

In F2, enter the formula =IFERROR(PARSE(C2, "organizations[0].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

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

  • Dashdash
  • BuiltWith
  • Crunchbase
  • Hubspot

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[0].name"),""). Drag down the column.

In E2, enter the formula =IFERROR(PARSE(C2, "organizations[0].shortDescription"),""). Drag down the column.

In F2, enter the formula =IFERROR(PARSE(C2, "organizations[0].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

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Tools used

Tags

Get help and discuss

Open community forum

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.