Skip to main content
Question

Looping with incorrect formatting

  • January 14, 2024
  • 4 replies
  • 53 views

We are experiencing an issue with the Looping step in our Zap.
We are using a formatting step to separate by line item, but when we select it in the loop stage, it’s coming in as comma delineated.

Here’s a video showing the zap and the issue: https://drive.google.com/file/d/1gJVlsVdVArtaJU1CDj7JeAFbQIVvhO0x/view?usp=sharing

Any help or advice is much appreciated.

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

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 14, 2024

Hi @sethferguson 

You may not need the Formatter steps.

The Formatter Input you have selected is an array of items.

By using the Formatter it’s creating an array of arrays. (see the 1 followed by the 1, 2, 3...)

That causes the GSheet step to not work as expected.

The Zap action for Looping Create Loop from Items already handles line items. (aka arrays).

 


  • Author
  • Beginner
  • January 15, 2024

Hey @Troy Tessalone,

Appreciate the tip!

However, we’re getting data in 1 of the spreadsheet cells, but it’s missing the other cells.

Quick video: https://drive.google.com/file/d/1GIS7E2RPzNxMqW9x8VeEWB6aFHBtsteT/view?usp=sharing


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 15, 2024

@sethferguson 

We would need to see screenshots with how your GSheet Zap step is configured with the variables mapped from the Looping step.

Looping help: https://zapier.com/apps/looping/help

 

You may want to try using Loom.com for the videos.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 15, 2024

@sethferguson 

Also, check your Zap Runs to see the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/