在添加数据之前使用Python gdata清除工作表中的行

pip install gspread google-auth google-auth-oauthlib google-auth-httplib2

import gspread
from google.oauth2 import service_account

# 设置Google Cloud Platform的凭证
credentials = service_account.Credentials.from_service_account_file('path/to/credentials.json')
scoped_credentials = credentials.with_scopes(['https://www.googleapis.com/auth/spreadsheets'])

# 连接到Google Sheets API
client = gspread.authorize(scoped_credentials)

# 打开工作表
sheet = client.open('My Spreadsheet').sheet1

# 清除工作表中的所有行
sheet.clear()

# 删除第2行
sheet.delete_row(2)