Programatically Send Email With New Data Daily

[dar_dev]

Hi. I am a developer new to the hubspot system.

My goal is to send a daily internal email that contains a table.

Each day this table's data will need to be updated with the most up-to-date data from our API.

What tools/recommendations do you have for me to fully automate this process?

For example is there a way to programatically update email templates?

[himanshurauthan]

Hello @dar_dev

If your requirement is to only change the data ( a table ) in the email, then you can make use of HubSpot Transactional Email addon. This helps to use a single email template but allows to send data into emails through token and then the email can be send instantly. In short, all you need is :

1. Create a email on HubSpot using your tokens.
2. Use transactional email API to send data for tokens and the email to which it has to be sent.

https://developers.hubspot.com/docs/methods/email/transactional_email/single-send-overview


Thanks