Dynamic links in automated emails

When someone signs up for my tool, we onboard them by sending an email with the access link. However, when someone signs up outside of business hours, we can’t send them the email immediately.

I want to automate the email sent by HubSpot to anyone who signs up for my product. And that I can do.

But I can’t embed the dynamic link into the email. I want to automate the email sending. The email contains a dynamic link that changes for each signed-up user. How can I automate emails that have a new link every time?

Hi @Shrey101,

Where exactly does the dynamic link come from, how is it generated, where is stored?

If it’s stored within a contact property, you can place a personalization token for that property in the email: Use personalization tokens

Best regards

Hi @karstenkoehler,

We generate the dynamic link from our own system. Currently, we send it by email manually. I don’t know where to store it so that HubSpot can send it different links to different users in a timely manner.

@Shrey101 you would have to integrate your system via the HubSpot API then for an automated process. If it’s currently manual, HubSpot cannot access that information. 2026-03 API reference - HubSpot docs

@karstenkoehler Okay. Is there a way that I can do this via Excel/Google Sheet? I have the links ready in Excel that I sent to my signed-up users. Some sort of integration?

@Shrey101 which HubSpot subscription do you have?

@karstenkoehler I have Sales Hub Professional and Marketing Hub Professional

@Shrey101 you could look into Zapier and create a Zap that updates new eligible contacts based on information from your Google Sheet: Use HubSpot's integration with Zapier

@karstenkoehler, will that help me with my original challenge? That is to insert dynamic links in automated emails each time.

@Shrey101 once you update a contact (property) via Zapier, that property can be used as a personalisation token in an automated marketing email.