Loop over several google sheets

Get Help General Question
1

Hey,

I have 3 sheets in one Google sheets file

Sheet 1 has item 1-10, sheet 2 has 11-20 and 3 has 21-30

I need a loop over these 3 sheets one by one untill all 30 items have been proccesed.

How do i structure a flow for that.

Thanks,

D

2

Hey @Donna! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

  1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

  2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
    GIF guide

  3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

3

Hey @Donna ,

Couple questions here:

  1. Is the sheet schema (i.e column names) constant across all the sheets?
  2. Are you planning to add more sheet tabs to this flow?

There’s a way to do this using the native Google Sheet Reader node as well as the Google Sheet MCP feature, learning more about the use-case would help me guide you appropriately.

4

@Wasay-Gumloop (good to hear back from you!)

My answers

  1. Yes they are the same.
  2. No the number of tabs will remain the same. It could be that one Google Sheet has 4 tabs, and one other 5 (or 3). But I will use them just “te read” and not to write

Curious (as always) for you ideas

D

5

@Wasay-Gumloop could I use the AI Router for this … ?

6

@Wasay-Gumloop can you share your wisdom?

7

Hey @Donna – Apologies for the late response. I made a Loom video to go over this: Efficiently Processing Multiple Google Sheets with a Unified Schema | Loom

Here’s the workflow for reference; Gumloop | Automation Builder

8

excellent!

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.