Bk Lim
Oct 20, 2022

Hi Joseph, thanks for reading!

When you said sheets, do you meant all the tabs within the same sheet or different spreadsheets?

For the former, if you use gspread, you can easily get all the sheets/tabs with .worksheets(), and from there you can loop through the sheet and get all the records, eg:

```

spreadsheet = gc.open_by_key(SHEET_ID)

all_tabs = spreadsheet.worksheets()

data = []

for tab in all_tabs:

data.extend(tab.get_all_records())

```

Bk Lim
Bk Lim

Written by Bk Lim

Software Engineer @ Meta. GCP PCA. Likes to write about tech, architecture, automation, JS and Python. :)

No responses yet