Stock info via google sheets

(Omar Morales) #1

Hello to all the community members.

I have a google sheet that has stock quotes with the ticker, name, price, pctg change, and trade date.

What I would like to do is to send the info to the user for the name or ticker he writes as a card.

Any ideas or help?,

Thank you

(Joe Hatch) #2

When you capture the item name, you’ll want to add a Google Sheet - Search Rows action.

The Column you’re searching for will be the ‘Name’ column and the value will be set to the output of your answer (item name).

Then you can return the items information and contain it within the card.

(Kellsey Shaw) #3

Hi Omar,

You’ll want to consider using a unique value to search Google Sheets unless you can be absolutely sure you won’t have two people with the same name.

If the value you search is not unique, you’ll end up with multiple results found.