I need to be able send customers group of coupon codes. So the ideal workflow would be
Customer fills out form on Squarespace → Zapier searches in Google Sheets for a range of codes → Google Sheets exports codes in emails to customer → Google Sheets updates list of codes to make them ‘used’
I found a really helpful article for doing this for a single coupon code (linked below), but need to be able to do this for batches of 5-10 coupons codes. Any suggestions?
Thanks!