Hi Janet and Liz,
I’m running into a similar issue, I explain my case to see if anyone can help me out here:
Our goal is to create a tag in Mailchimp based on a score the user obtains by completing a quizz in Typeform.
The current automation looks like this:
Typeform → Create row in Google Sheets → Lookup table → Update Sheet → Mailchimp Tag
We need to lookup the values in order to return a category or result, instead of a numeric value that Typeform provides in the calculator. Our categories are 3: “Suscriptor organizado, Suscriptor listillo, Suscriptor desastre”.
The Zap is working, but when doing the lookup action and return the value, the updated sheet step select a random row rather than the actual row I need. (See screenshots below)
Appreciate some help on this = )
Best answer by Javier VinasView original