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