Best answer

Assign unique coupon code to buyer added to Google Sheet

  • 26 June 2021
  • 2 replies
  • 178 views

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

Fabian

icon

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.

Thanks!!