Hi,
It looks like Google Sheets returns multiple rows in the lookup, and I used Code by Zapier to create objects from the line items. For example, the sheet returns 4 rows, and Code by Zapier correctly returns 4 objects. However, when trying to map them dynamically, only two objects are appearing.
Here’s the returned data from Code by Zapier:
While mapping, only these two objects are available:
Can anyone please help with this?
Thanks!
+14Hi
How are you trying to use the data in the following Zap step?
Post screenshots showing which Zap step 6 you are trying to use.
NOTE: The Code step is returning an array of objects.
Try using the search to find the desired variable by name.
Hi
Thank you so much for your response and solution—it really helped resolve the issue. I truly appreciate your support!
I'm using this data in a step Gmail to send an email, which might not have been visible in the screenshot. Additionally, I’ve set up a path condition—once the condition is met, the data is passed to Gmail for email processing.
I do have a couple of follow-up questions. Currently, we’re working with a limited number of records, but I’d like to understand how many records Zapier can handle in this scenario. Also, while searching for data, I noticed that the records don’t appear in a specific order. Is there a way to ensure they are retrieved in an organized format?
Thanks again for your help and guidance!
+14
I’d like to understand how many records Zapier can handle in this scenario.
Provide more details and screenshots about what specifically you are referring to in the Zap steps.
While searching for data, I noticed that the records don’t appear in a specific order.
Is there a way to ensure they are retrieved in an organized format?
Provide more details and screenshots about what specifically you are referring to in the Zap steps.
Thank you for your quick response!
“I’d like to understand how many records Zapier can handle in this scenario”
Regarding the record limit in Zapier. I'm retrieving records from Google Sheets using Zapier’s Lookup Spreadsheet Rows (Advanced), which returns up to 500 rows. I’m then converting these line items into JavaScript objects. I’d like to understand the object storage limit in Zapier’s code step—how many objects can be stored and processed within this step?
As for data order.
Understood! We can locate the desired variable by searching for it by name.
Appreciate your help and insights!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
