Hi everyone,
I have a simple question: my Google Sheets node is set to read: sheet, but it’s returning 5 items (see image below). This is affecting the expected behavior of my workflow, since the previous node (Stripe Trigger) only passes 1 item.
Why is the Google Sheets node returning multiple items? How can I make it return only 1 item or just the specific row I need?
Thanks in advance for any help!
“read: sheet” operation is for “reading all rows for a given sheet”. You must have 5 rows on the specified sheet and this is how many you are getting back.
Yes how many items is from how many rows it read from Google Sheet.
If you only to execute once.
Try
Aggregate node. Then you need to deal with the data in an array after.
I don’t know why this happens 
@darrell_tw @jabbson as you can see he returns me all time 5 times
you can choose this to aggregate. But make sure what the data need to be transformed when you use it
