Skip to main content
Question

Looping by Zapier only creates 1 iteration with Get Many Spreadsheet Rows

  • July 30, 2026
  • 2 replies
  • 15 views

Hi everyone,

I’m trying to loop over every row returned by Google Sheets – Get Many Spreadsheet Rows using Looping by Zapier → Create Loop From Line Items.

What I expect: One loop iteration per spreadsheet row.

What actually happens: The loop only creates 1 iteration and puts all the row data into that single iteration.

I’ve tried these fields in “Values to Loop”:

  • Results Raw Rows
  • Results Formatted Rows Row
  • Results Formatted Rows ID
  • Various individual columns

Still only getting 1 iteration.

Question: What is the exact field I should select in “Values to Loop” so that Looping creates one iteration for each row returned by Get Many Spreadsheet Rows?

Thanks in advance.

2 replies

Forum|alt.badge.img+1
  • New
  • July 30, 2026

That symptom almost always means the field you mapped is a single value that happens to contain everything, rather than a line-item array. Looping creates one iteration per line item, so when it sees one item it runs once and stuffs the rest into that iteration.

Two things worth checking.

First, in Values to Loop, map an individual column from inside the Rows line-item group rather than the parent Rows object or a Formatted Rows blob. In the dropdown those show up nested under Rows with the line-item indicator, and picking the parent gives you exactly the behavior you are seeing. Map two or three columns you actually need, one per Values to Loop row, and they iterate together in lockstep.

Second, confirm the Sheets step really returned multiple rows. Get Many Spreadsheet Rows will return a single result if the row range or a filter narrowed it, and then the loop is behaving correctly. Open the raw output of that step in the editor and count the entries before blaming the loop.

One quick tell: if the mapped value arrives as a long comma separated string, it collapsed to text instead of line items. Reselecting it from the dropdown rather than pasting or typing the mapping usually clears that up.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • July 30, 2026

Hi ​@Bubba52 

For us to have more info about what you described, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

 

Also, include context about the data used in the Looping step, by showing the DATA OUT so we can see the structure of the data.

Help links for using Looping in Zaps: https://zapier.com/apps/looping/integrations#help