I have a google sheet with several rows of unique promo codes listed. When a tag is applied in Keap Max Classic, I want to assign one of those promo codes to that new contact by:
I’m not seeing how to do #1. How do I update a row based on the first row in that column being empty?
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Good question.
Try this…
Add another column called “USED” and set all the values to FALSE
Then in the Zap action GSheet - Lookup Row, search based on USED = FALSE.
Then in the following Zap action GSheet - Update Row (map the row ID from the previous step), you would set USED = TRUE, and add the email address to the Email column.
+14Hi
Good question.
Try this…
Add another column called “USED” and set all the values to FALSE
Then in the Zap action GSheet - Lookup Row, search based on USED = FALSE.
Then in the following Zap action GSheet - Update Row (map the row ID from the previous step), you would set USED = TRUE, and add the email address to the Email column.
Ohhh great idea, thanks
That worked like a charm
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
