Changing an answer from Typeform to a TRUE/FALSE in Google Sheet
Might be simple but I can’t figure it out :D
I have a Zap with answers from Typeform falling into a Google Sheet. One question has 5 possible fixed answers which I’d like to be set as a TRUE in the Google Sheet.
So Typeform: “What are you most interested in:
Female
Male
Kids
Animals
Electronics”
Should fall into GSheet if chosen, as:
Interest_female: TRUE
Interest_male: TRUE
Interest_kids: TRUE
Interest_animals: TRUE
Interest_electronics: TRUE
How do I change the answer to TRUE?
Page 1 / 1
Hey there @Annsophisticated
Welcome to the community!
Good question, there are a couple of ways to achieve what you described here.
I found this post about a similar problem with some great options in the comments especially this comment:
Does that look like something you could try?
Hi @Annsophisticated!
It looks like the answers from type form are coming in as ‘Im interested in animals’/’I am interested in electronics’/etc, is that correct? And in your Google Sheet, each column is one of the categories, yes? If so, then here is how you can change the text...
Add a Formatter by Zapier step before the Google Sheets step, choose Utilities > Lookup table. With a lookup table you can tell the Zap ‘if you see this, then use this text’. In this case, you’re saying ‘if you see “I am interested in animals”, write “TRUE”. You’ll need to have a line in the lookup table for each possible answer. If you haven’t used a Lookup table step before, I recommend reading this help guide to get you started.
Here’s a screenshot of what the table would look like:
In the Google Sheets step, you need to map the output of the Formatter step to the correct column in the sheet.
Will that work the way that you need it to? Let us know what you think!
Thank you Danvers!
I got it almost to the end – but I can’t seem to map the formatted answers to the Google Sheets action fields:
This I how I typed in the formatter:
But it doesn’t seem to fetch any data when mapped?
Thank you in advance!
Best regards, Ann Sophie
Hi @Annsophisticated ,
Are you typing the full sentence in the Lookup Table? Did you include the FALSE answers? If not, Did you include FALSE as the Fallback Value? After finishing this step, did you click on Test And Review to check the output?
Please let me know if you need more help with this
I found out – I just had to choose “Text” → “Replace” instead of “Utility” in the formatter and then everything worked out! :)
Thx for the help!
It looks like the answers from type form are coming in as ‘Im interested in animals’/’I am interested in electronics’/etc, is that correct? And in your Google Sheet, each column is one of the categories, yes? If so, then here is how you can change the text...
Add a Formatter by Zapier step before the Google Sheets step, choose Utilities > Lookup table. With a lookup table you can tell the Zap ‘if you see this, then use this text’. In this case, you’re saying ‘if you see “I am interested in animals”, write “TRUE”. You’ll need to have a line in the lookup table for each possible answer. If you haven’t used a Lookup table step before, I recommend reading this help guide to get you started.
Here’s a screenshot of what the table would look like:
In the Google Sheets step, you need to map the output of the Formatter step to the correct column in the sheet.
I just had to choose “Text” → “Replace” instead of “Utility” in the formatter and then everything worked out
Woohoo! So excited to hear you were able to get this sorted! Thanks for letting us know your end solution!