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

Question

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:

adding the contact’s email address in a cell next to the promo code (using the next blank cell available)
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?

Troy Tessalone · Accepted Answer

Hi @cineagGood question.Try this…Add another column called “USED” and set all the values to FALSEThen 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.

cineag · Answer

That worked like a charm @Troy TessaloneThanks again.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded