Our company would like to bring in Hubspot data into either Redshift or Quicksight to analyze our email marketing data. If anyone has successfully done this integration then please share.
Hey @ronyb , welcome to the Quicksight community!
I recommend checking out AWS AppFlow! This is really cool way to be able to pull data from your CRM through AppFlow into Redshift or S3. If you send it to Redshift you can query it directly with Quicksight.
Here’s the documentation on using AppFlow and Hubspot:
Let me know if this helps!
1 Like
Hi @duncan : Thanks for sending the link. Our data engineering team tried using Appflow but we were not able to connect/get the data. Are there successful customers who were able to get the data from Appflow ?
Hello @ronyb !
When you tried to connect, did you receive any error messages, and did the connection just fail or did it
seem like it connected but the data wasn’t coming through?
HubSpot is a native/supported connector for AppFlow. I recommend attempting to troubleshoot directly with appflow support/documentation.
Please share error from Appflow for best support there please reach out to support.
If for any reason appflow wont get you the data you need there are various other options in the market that can assist with building data pipelines to hubspot and get your data in s3/redshift.
Thanks
Ramon
1 Like