ExploreEducationHow do IΒ build?MembersToolsWorkshopsJobs

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

Bring no-code skills to your work

From learning new skills for your projects to automating and shipping faster in your team
For BusinessFor individuals

Share

Tutorials
/
πŸ’Έ Create a targeted sales list in dashdash
Categories
Tools USEd
Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later

πŸ’Έ Create a targeted sales list in dashdash

Link to Demo

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

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

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

Tools

Tutorials

Stories

Ready to get started?

Join the community and start turning your ideas into solutions