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.

  • March 21, 2025
  • 7 replies
  • 71 views

 

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 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.

 

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 replies
  • March 23, 2025

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.

 


  • Author
  • Beginner
  • 3 replies
  • March 26, 2025

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 replies
  • March 26, 2025

@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.


  • Author
  • Beginner
  • 3 replies
  • March 26, 2025

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 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.

 

 

 


  • Author
  • Beginner
  • 3 replies
  • March 27, 2025

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
  • 3527 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.