We have a list of 5000 unique codes (in a Google Sheet). When someone submits a specific HubSpot form, we want to automatically send them an email from HubSpot containing one of the unique codes from the Google Sheet. Once a code has been sent once, we do not want to send the same code again. Is this possible?
Send automated Hubspot email containing Unique codes from a Google Sheet
Hi
Good question.
Yes, that’s possible.
You’ll need another column in the GSheet to use to search/update.
For example, STATUS with values of TRUE/FALSE.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/92a5311c-f831-44ca-8904-3cc14a0bd7e0.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8a6df83f-8162-4e12-b432-19188d69adce.png)
Hi
Good question.
Yes, that’s possible.
You’ll need another column in the GSheet to use to search/update.
For example, STATUS with values of TRUE/FALSE.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/92a5311c-f831-44ca-8904-3cc14a0bd7e0.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8a6df83f-8162-4e12-b432-19188d69adce.png)
Hi Troy,
Thanks for the response. This makes sense and I have an idea on how this would be done using Zapier and Google Sheets. My main problem is with HubSpot and how Zapier could be used to automate an email containing a unique code.
You’d have to send the code to a custom field in HubSpot to then be used in a dynamic variable within the email template.
You’ll need another column in the GSheet to use to search/update.
For example, STATUS with values of TRUE/FALSE.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/92a5311c-f831-44ca-8904-3cc14a0bd7e0.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/8a6df83f-8162-4e12-b432-19188d69adce.png)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.