How to use individual row data from “Lookup Spreadsheet Rows (output as Line Items)" in Google Sheets?

Hi @blueguy 

We need more context about how you are trying to use the returned GSheet row data in following Zap action steps. (screenshots)

Hello Troy

Thanks for the helping hand.

When you search by multiple rows that output really is the column of each row found.  So is column B in the spreadsheet that was searched is the First Name, then all the first names put in a single line item as the output. 

To answer your question specifically, I want to be able to use each individual value found in that row.  

I hope that is clear.

gml

@blueguy 

Try using the Looping app to iterate on each row: https://zapier.com/apps/looping/help

Thank you for the speedy response; I always learn something new from you

What goes in this field?

I am not sure I get the point of being able to look up multiple rows if you cannot use the data

gml

@blueguy 

Check the field description for guidance.

Set whatever value you want.

Action step:

the TEST

you only have 1 useable value on the next step

@blueguy 

Help article for using the Looping app: https://zapier.com/apps/looping/help

@blueguy 

It’s still unclear how you are trying to use the data from the GSheet in the Formatter and Code steps and any following Zap steps.

Outlined a specific example will provide more context along with screenshots showing how your Zap steps are configured in EDIT mode.

Okay...what you are seeing are just other steps I am trying to play but okay here are the specific steps/ I will do my best:

LOOKUP MULTIPLE ROWS in Google Sheets by 2 variables

These are the results or TEST

MY LOOP steps/ app & event

ACTION STEP

The results of the loop

My action step only has 1 CHOICE

Where are the other names?  How do I find the other names?

There were 6 loops made but I can only use 1 name for future steps….

Thanks

@blueguy 

If you want to process each ROW found from GSheets, then the Looping step will iterate thru each found ROW.

Per the Looping help docs, when testing a Zap step within (aka after) the Looping step it will only show you info from the first loop.

Turn the Zap ON and test live to have all the Loop iterations processed.

Help article for using the Looping app: https://zapier.com/apps/looping/help

My guess is running a loop to separate a string of data is not an appropriate use of a loop.

@blueguy

Let’s try a different approach…

Assume there are no other Zap steps yet after the GSheet step, in your own words explain what you are trying to do with the rows of data returned from GSheets.

e.g. For each GSheet row returned I want to do X, Y, Z.

###

The data from GSheets is returned as an array of items.

If you are trying to iterate thru each GSheet row, then Looping makes sense.

If you are trying to do something else, then we need more context about the purpose of your Zap.

Troy (meister) 

Thanks for the patience.

1. we have a Google sheet with with patient names , facilities and date of upcoming appointment
2. so I wanted to look up in the Google Sheet all patients who belong to Facility X and have an upcoming appointment on 6.10.2023
3. This query generated 6 Rows or results that met my query parameters
4. One of the rows had 6 first names in it and another row had 6 last names (each name is separated by a comma)
5. Initially, I thought splitting the string of 6 names (that are separated by a comma would work), but it does not
6. I want to be able to match first name with last name and have the list of 6 patients (who met the above criteria) appear in an email

Thank you again!

@blueguy
Which are you trying to do?

1. Send 1 email that contains info about all the data from the returned GSheet rows
   1. This would use Formatter
2. Send 1 email for each returned GSheet row
   1. This would used Looping

1 email

We will send a single email to one facility and inside that email, we would like to list the names of the patients who have upcoming appointments on a particular date.  So the email could have 3 names in it or 10

GML

@blueguy 

Try this: Formatter > Utilities > Line Items to Text

EXAMPLE

For the Input it shows 2 variables mapped

Each variable is an array, such as would be returned from GSheets.

Output Text variable shows the merged data that you can map into the email.

For your reference: Different options for handling line items in Zaps:

Great!! That worked; you are awesome.  Sir!!  

Next question if you want to take a crack at it is figuring out how many rows are found in Google Sheets because combining null values will likely stop the Zap process

Sometimes the query of the Google Sheet will find 8 matching rows and sometimes it will find 3; so I need to figure out a way to know how many names to put in the email.

@blueguy

Formatter steps will handle a varying amount of rows.

This 1 variable output from the Formatter step has all of the array items merged.

alright that is enough for today; my brain is fried!! 

Thank you so much;  you have been great; you have helped out many times before

gml