Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

We are currently using HubSpot for all marketing emails, including internal marketing emails.

We consistently run into issues with keeping an updated internal contact list. We will able to generate an excel file that will stay updated based off our HR database, so we are looking to use Zapier to create contacts in HubSpot from and excel spreadsheet.

I have tested this and it does work, but I am just wondering if anyone else has done this before and can share any best practices? Additionally, how do you handle when a row is removed from a spreadsheet? Thanks!

Best,

Emily

Hi & welcome @edemarco ! 

Tagging in a couple of our Certified Experts who specialize in HubSpot and may be able to share some best practices. @Tristan @kriszielinski would love your take here! TIA!

Hey everyone

Thanks @Liz_Roberts for tagging me!

@edemarco regarding your query 

I am just wondering if anyone else has done this before and can share any best practices? Additionally, how do you handle when a row is removed from a spreadsheet?


For best practices, they are also related to a specific case scenario, so I’m not sure if I am able to just share an accurate one, but for the second part - when a row is removed from a spreadsheet I guess you’d like to get rid of that person from the system as well right?

Because if not then I don’t think there anything to worry about?

 

Let me know if I have properly understood your question.

I’m happy to help you further in here as soon as you’ll provide more details

 

Cheers,
Kris

Hey there @edemarco! How are you? Just wanted to pop in and see if Kris understood your question properly and if you needed any further assistance? 

@kriszielinski Hey Kris! Sorry I was out at the end of last week. 

For the second half of your question, yes, if an individual is removed from the spreadsheet then should be deleted as a contact in HubSpot. When I tried doing this myself, I did it based off if the excel row was updated, and it was finicky.

 

 

Hey

We’ve implemented a solution like this already for one of our clients and it works for him pretty well.

 

Please get in touch with us through

https://zapier.com/experts/seamless-automation

 

 

We’ll show you how it works and you’ll tell us if that’s something you would be interested in

 

Thanks and hoping to get in touch soon

Kris

Hi @edemarco ! Checking back in to see if you were able to get this workflow up and running. Let us know!

@Liz_Roberts Hey Liz - I reached out to Kris for more information and to see if he could offer different options. I’m currently waiting to hear back from my leadership about what route they would like to take. 

@edemarco thanks for keeping us posted! I’d be curious to hear more about why you’re needing to utilize an excel sheet in this workflow. What purpose is it serving? I’d really love to hear more about the desired outcome so we can do a bit of brainstorming here!

Hi @edemarco,

Sorry for the late reply. Just adding on to the great support that the others have already provided there might also be some other options:

  1. Integrate directly with your HR software and plug it into Hubspot (via Zapier or another way)
  2. Simply import the spreadsheet straight into Hubspot and with a workflow automatically add/remove staff from the appropriate Hubspot list

Happy to explain in more detail and discuss Hubspot & Zapier workflows if you’re still looking for a solution.

Cheers,
Tristan

Terms & Conditions