Multiple Cards from Google Sheet

(David Levy) #1

How can I have multiple cards based on the amount of rows from a google sheets search function.

If i return 2 rows, i would want 2 cards with the data of those rows.

Is this possible at all?

(John Jackson) #2

You can reference individual cells in the search results using the collection outputs format.

For example, if your Google Sheets column is called colname and you want row number 1, you would use this:

{{google_sheets.results_+_gsx:colname 1}}

So then if you wanted to fill up to 3 cards, use results from rows 1 in the first, 2 in the second, etc… If the row is empty it won’t send a card.

It is a little tricky but easy once you get the hang of it.

There’s also this tutorial that might help you understand working with Google Sheets:

Good luck with it, and contact support if you get stuck.

(David Levy) #3

wow that was insanely fast response!

Actually tho, when i make it load one card, it works fine, when i make it load more than one, it gets stuck…

Is it because I should be using “Search” or “List” rows… Currently am using search because I can filter by the users answer

(David Levy) #4

So it’s solved, and for anyone reading this, becareful where you set your outputs.

I had a string where the card was expecting a URL and I’m sure it made it go a little crazy.

Thanks John!

1 Like