Skip to main content
Best answer

The output array of objects from the line item returns with a length of 4, but in dynamic mapping, only two objects are available.


 

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!

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi ​@Nicole_summer 

Help links for using Code in Zaps that cover the limits: https://zapier.com/apps/code/integrations#help

 

It’s not the number of objects, rather the amount of data.

 

 

 

View original
Did this topic help you find an answer to your question?

7 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Nicole_summer 

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 ​@Troy Tessalone,

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!


Troy Tessalone
Forum|alt.badge.img+14

@Nicole_summer 
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!


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31340 replies
  • Answer
  • March 26, 2025

Hi ​@Nicole_summer 

Help links for using Code in Zaps that cover the limits: https://zapier.com/apps/code/integrations#help

 

It’s not the number of objects, rather the amount of data.

 

 

 


Hi ​@Troy Tessalone,
 

Thank you for your help and support! I appreciate the clarification. I'll review the provided link to better understand the data limits in Zaps.

Thanks again!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2566 replies
  • March 28, 2025

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.


Reply