Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

How to Import HubSpot Data into Clay from Google Sheets | Clay

How to Import HubSpot Data into Clay from Google Sheets

Estefania Alonso

·

·

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

· Sorted by Oldest

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 (Clay)
·
·
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 Alonso
·
·
Thanks! The link didn't get through in the message
Bo (Clay)
·
·
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.