Confused about Google Sheets Intergration

[Ross_Kinkade]

Hello,

I was wondering if there were any templates I could look at/use for a simple Google Sheets integration.

I want to have the bot look at a country you are from (one column), and then return a value from another column via a look up. Is this something that is even possible?

[DanielBeckett]

Hi @Ross_Kinkade

A similar question has been asked before which I put an example together for:

Country Lookup Idea

I have a field that requires a country input, however this needs to be mapped to an actual values (correct spelling etc). Does anyone have a good way to validate a answer as a country from a list? I understand that there would be quite a high error rate in people typing in thier own country

You may also find the tutorial for Using Google Sheets in Flow XO useful:

Using Google Sheets in Flow XO – Flow XO – Medium