How to Import HubSpot Data into Clay from Google Sheets

·

One more! One of my reps sent me a google sheet with the name and record ID of the companies he wants me to import to Clay - the company name and record ID are from hubspot but he hasn't created a hubspot list, he gave me this data in a spreadsheet. Is there a way I can easily import this data to Clay and then find contacts?

5 comments

Clay
APP
·
·
Export your Google Sheet as a CSV file, then import it into Clay by clicking + Add at the bottom of a workbook, selecting Import from CSV, and uploading your file. Once imported, you can use the HubSpot record IDs to enrich company data and find contacts by adding enrichments like "Find People" or other contact-finding tools in Clay.
Sources: Google Sheets [Clay 101] - Clay University Sources | Documentation | Clay University
Bo (.
·
·
You can use Google Apps Script to send the data to a Clay webhook. Here’s a guide that walks you through how to set it up. Once the data is in Clay, you can run a Find People search on those companies. Let me know if you need help setting that up.
[App: Article Inserter]
Estefania A.
·
·
Thanks! The link didn't get through in the message
Bo (.
·
·
Sorry about this, See it here: https://docs.clay.com/en/articles/9774034-send-data-from-google-sheets-to-clay-using-a-webhook?location=conversation Let me know if you have more questions
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.