Create a targeted sales list in dashdash

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

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

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

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

Get help and discuss

Open community forum

More lessons

How to Build a Functional & Responsive Pricing Page like Notion's in Webflow
How to Build a No-code Pricing Page like Dropbox in Webflow
How to Build a Functional & Responsive Pricing Page
Develop a custom CRM using Retool and 8base
Generate a task list for projects in Airtable
Generate pre-filled contracts in Hubspot using PandaDoc
Sync files across Airtable, Hubspot, and Google Drive
Pre-Fill Airtable forms and link forms to existing records
Automate recurring interactions in your deal & project cycle
Connect Hubspot Deals to Airtable
Automate scheduling meetings, calendar invites, and CRM admin work
Sales automation workflow using Typeform / Airtable / Callingly
Capture email metadata and save as an image with Zapier
Find & save competitor info and emails with Hunter
Email outreach & sequencing with Reply.io & Gmail
Source Leads from a Spreadsheet with Dashdash
Send a personalized download link with YAMM
Auto-accept LinkedIn invites
Automate + qualify your lead generation with Standard Library
Generate and send contracts automatically with PandaDoc
Automated Airtable sales notifications in Zapier
Create a sales pipeline in Airtable
Automated sales reporting for Shopify with Integromat
Pull LinkedIn Company info & create a new record in Webflow
Build a Mail Merge with Airtable, Gmail, and Standard Library.
Build a Slack / Airtable / Stripe CRM
Update salesforce opportunities with computed data
Automatically get data from Mailchimp to your CRM
Sales CRM - build a sales pipeline
Fundraising CRM - Startups seeking to raise funding
👨‍👩‍👧‍👦Personal CRM - keep track of people in your life
Segmenting prospects for sales funnels
Browse all →

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