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.

Hi, We are new to zapier and trying to find a solution to a problem we have. We have generated a large amount of discount codes that we would like to send to cusotmers who make a specific item purchase on our website. The idea we have is that if the customer belongs to a hubspot list, they will eventually get a discount code which is unique sent to them.

I am trying to use google sheets to store the individual unique codes, where one must be applied to one customer. how can i use zapier, to assigned a unique code and the get zapier to pick it back up and store it in hubspot, so we can set an automation to send the code to the customer?


Would appreciate any help anyone can give, i know its possible but i am unable to work it out, many thanks


Chris


Hi @chrisb

So, in Google Sheets you'll want a two-column sheet - "Status" and "Code".

All your codes go in the "Code" column and the "Status" column should be set to 'Unused' for each row.

Your zap would trigger on a new person added to the Hubspot list and it would then search Google Sheets, looking for the row where "Status" = 'Unused'.

That way it will grab the first code.

Then there should be "Google Sheets->Update Row" step that changes the "Status" of that row to 'Used'. That way, next time the sheet is searched, the next row down is grabbed.

Finally, you can update the Hubspot contact saving their code in one of the contact fields.


this is great thank you, i have now managed to set it up!


Thanks for all the help


Chris


Terms & Conditions