# How to iterate over a range of cells in a Google Sheet

**URL:** <https://community.make.com/t/how-to-iterate-over-a-range-of-cells-in-a-google-sheet/107790>\
**Category:** Questions\
**Tags:** iterator, google-sheets\
**Created:** [April 21, 2026, 4:56pm UTC](https://community.make.com/t/how-to-iterate-over-a-range-of-cells-in-a-google-sheet/107790 "2026-04-21T16:56:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pulkit\_Prakash](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/pulkit_prakash/32/90711_2.png) [@Pulkit\_Prakash](https://community.make.com/u/Pulkit_Prakash)\
**Post date:** [April 21, 2026, 4:56pm UTC](https://community.make.com/t/how-to-iterate-over-a-range-of-cells-in-a-google-sheet/107790/1 "2026-04-21T16:56:17Z")

</div>

### 🎯 What is your goal?

How can i iterate over a range of cells in a Google Sheet?

### 🤔 What is the problem & what have you tried?

I am building an automation that goes through data in a spreadsheet, use the cells available and then generate a Google document. There can be multiple spreadsheets so i use an iterator to go through them one by one

I am struggling to find a way to do this

1. The spreadsheet (source data) has a specific range which i want to iterate over. The range has fixed # of columns but can have different # of rows across the various spreadsheets.
2. For this specific range within each spreadsheet, i want to run a sub-iterator (while already within an iterator which runs across the spreadsheets) that goes through each row for the downstream modules.

I think the essence is that how do i load this “dynamic range” of cells as an Array, and then be able to run an iterator across each row in the range. I am not sure how to implement this. If you look at the screenshot attached - there can be 2 spreadsheets and the specific range that i want to iterate over can have different # of rows (while # of columns are same). While i have figured out how to iterate across the # of spreadsheets, i am struggling on how to iterate over this range within each Spreadsheet. Would appreciate some guidance!

### 📸 Screenshots (scenario flow, module settings, errors)

 ![Screenshot 2026-04-21 at 10.22.48 PM.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/5/f504a4a02db72e7d8b218f300be751e9c2ec458a.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [July 20, 2026, 5:03pm UTC](https://community.make.com/t/how-to-iterate-over-a-range-of-cells-in-a-google-sheet/107790/3 "2026-07-20T17:03:12Z")

</div>