How to distribute unique coupons stored in Google Sheets to different customers?

  • 27 February 2022
  • 2 replies



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



Three integrations 

google sheet 1

google sheet 2



This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @beeds 

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.



Userlevel 7
Badge +11

Hey there @beeds, welcome to the Community!

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! :relaxed: