Best answer

How do I assign promo codes on Google Sheets when a tag is added to a contact on Keap Max Classic?

  • 25 February 2023
  • 3 replies
  • 22 views

Userlevel 1

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:

  1. adding the contact’s email address in a cell next to the promo code (using the next blank cell available)
  2. then zap that promo code to custom field in Keap

 

I’m not seeing how to do #1. How do I update a row based on the first row in that column being empty?

icon

Best answer by Troy Tessalone 25 February 2023, 20:54

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.

3 replies

Userlevel 7
Badge +14

Hi @cineag

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.

Userlevel 1

Ohhh great idea, thanks @Troy Tessalone! I’ll try that.

Userlevel 1

That worked like a charm @Troy Tessalone Thanks again.