Google Sheets: Read metadata (sheet names), loop across sheets, and create docs with named sheets

Feature Requests
1

Hi n8n team :waving_hand:

I’d love better support for multi-sheet workflows in Google Sheets. Right now it’s hard to automate when a spreadsheet has many tabs (one per customer, for example).

What I’m asking for

  1. Read / Get metadata from a google sheet document

    • New operation (next to Create/Delete): Get metadata

    • Returns an array of sheets with { sheetname, sheetId, index }

    • Makes it easy to loop over all tabs

  2. Use metadata in Read (Get Rows)

    • Now when I want to get rows from a sheet I can use {{$json.sheetName}} inside a loop and pull rows from each tab automatically.

  3. Create spreadsheet with multiple, named sheets

    • In Create, accept an array of sheet names (e.g., from {{$json.sheetNames}})

Why this matters

  • Scales sheets without manual tab selection

  • End-to-end automation: read all tabs → process → create a result doc with the same tab structure

  • Less brittle: avoids hardcoding a single sheet name

Example flow (high level):
Get metadata → Loop over sheets[] → Get Rows with {{$json.sheetnames}} → Aggregate → Create Spreadsheet with sheetNames[] → (optional) Write results into corresponding tabs.

Thanks for considering—this would unlock a ton of multi-sheet use cases and reduce manual setup. :folded_hands:

—Baris