Чтобы поместить номер листа в переменную с помощью библиотеки gspread, вы можете использовать следующие методы:

Метод 1: использование методаsheet_by_index

import gspread
# Open the spreadsheet
gc = gspread.service_account(filename='credentials.json')
spreadsheet = gc.open('Your Spreadsheet')
# Get the sheet by index
sheet_index = 0  # Replace with the desired sheet index
sheet = spreadsheet.get_worksheet(sheet_index)
# Store the sheet number in a variable
sheet_number = sheet_index + 1
print("Sheet Number:", sheet_number)

Метод 2: использование методаsheet1

import gspread
# Open the spreadsheet
gc = gspread.service_account(filename='credentials.json')
spreadsheet = gc.open('Your Spreadsheet')
# Get the first sheet
sheet = spreadsheet.sheet1
# Store the sheet number in a variable
sheet_number = 1
print("Sheet Number:", sheet_number)

Метод 3. Использование метода рабочего листа

import gspread
# Open the spreadsheet
gc = gspread.service_account(filename='credentials.json')
spreadsheet = gc.open('Your Spreadsheet')
# Get the sheet by title
sheet_title = 'Sheet Name'  # Replace with the desired sheet title
sheet = spreadsheet.worksheet(sheet_title)
# Store the sheet number in a variable
sheet_number = int(sheet.title.split()[-1])
print("Sheet Number:", sheet_number)