Best answer

Assign unique coupon code to buyer added to Google Sheet

  • 26 June 2021
  • 2 replies

Hi at all,

i have a list of coupons and get the data from new buyers via a webhook.

Now i want to fill a row in a google sheet with the new buyer so that he has a coupon code and tell it to him via E-Mail.

Problem: If a column is filled with data the new buyer is getting into the next full empty row instead of row no. 2 :/


Then i tried to do the coupons in another sheet and solve it with a search. But the search needs a specific value. I cannot search a row that only contains something and response this.


Do you have any idea how I can match existing coupon codes with new buyers so that I then send the buyer an email with the code?

Best regards



Best answer by Troy Tessalone 26 June 2021, 18:06

View original

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 @Fabian567 

Check out these related topics:


Hi Tresor,


thank you very much. The second topic you linked had the solution. So easy, when you know it.