Cross referencing data in google sheet

(David Grünbaum) #1

Hi,

I have a flow where the users can search for a name. If the name already exists in the google sheet, the user will automatically skip the steps of adding further information (since it has already been added by a previous user). However, in the next step I want the user to be able to use the information related to the name that they have search (which is all stored in the same column).

How do I search for information related to the name? for example if search name = stored name, then age, height other data related to the name should be presented to the user.

(Daniel Beckett) #2

Hi @david1

I believe that we’ve discussed this over on the support helpdesk but just thought I’d share the answer here too in case anybody else runs into a similar issue :slight_smile:

When you need to use multiple columns from the same row then the Google Sheets ‘Get a Row’ action can be used. This lets you search for a specific row and then pulls out all of the columns so that they can be used as outputs in the bot.

(David Grünbaum) #3

No problem.

Btw, is there a way to not make the search an exact match?

[/uploads/default/original/2X/d/d9c1bb63e030f9a8ea08a7ff78fe01a53b9e9bed.png]

(Daniel Beckett) #4

That’s not possible at the moment, sorry. :disappointed: