Hi,
I want to know if there is a way to do the following:
when line added in sheets
then send email
and in that email I want to pull a coupon from another sheet and add it as a field.
The coupons will be unique and I want it to be pulled from the next line
For example
customer 1 gets line 1
customer 2 gets line 2
etc
Three integrations
google sheet 1
google sheet 2
outlook
Thanks
+14Hi
Yes, that's possible.
You’ll need to either add a Status column to mark which Codes are used/unused, or delete the row after doing the lookup.
Try these GSheet actions in your Zap.
+11Hey there
There’s an article in Community that discusses how to send out unique coupon codes (stored in Google Sheets) to customers which you may find useful:
Hope that helps! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
