如何创建无默认Sheet1的pygsheets工作表？该操作是否可行？

Great question! I’ve run into this exact scenario before—pygsheets (and the underlying Google Sheets API it wraps) does automatically create a default Sheet1 when you make a new spreadsheet, and there’s no direct parameter in the create() method to skip this step. But just like with Excel, you can work around this easily with a couple of straightforward approaches.

Here are two reliable ways to handle this:

1. Replace the Default Sheet1 with Your Custom Worksheet #

Keep in mind: Google Sheets requires every spreadsheet to have at least one worksheet, so you can’t delete Sheet1 outright without first adding another sheet. Here’s how to swap them out:

import pygsheets

# Authenticate with your Google account (adjust this to your auth method)
gc = pygsheets.authorize(service_file="your_service_account.json")

# Create the base spreadsheet
new_spreadsheet = gc.create("My Custom Project Spreadsheet")

# Add your preferred worksheet first
custom_sheet = new_spreadsheet.add_worksheet("Main Data Sheet")

# Delete the default Sheet1
default_sheet = new_spreadsheet.sheet1
new_spreadsheet.del_worksheet(default_sheet)

2. Rename the Default Sheet1 (Simpler Alternative) #

If you don’t need to fully remove the initial sheet and just want to ditch the generic "Sheet1" name, renaming it is a faster option:

import pygsheets

gc = pygsheets.authorize()
new_spreadsheet = gc.create("My Spreadsheet")

# Rename the default sheet to your preferred title
new_spreadsheet.sheet1.title = "My Preferred Sheet Name"

Why There’s No "Skip Default Sheet" Option in the Docs #

The reason you won’t find this setting in pygsheets’ official docs is because the Google Sheets API itself automatically generates a default sheet when a new spreadsheet is created. Pygsheets just mirrors this API behavior, so there’s no way to bypass the default sheet during creation directly. The workarounds above are the standard way to adjust this after the fact.

Quick note: If you try to delete Sheet1 without adding another sheet first, you’ll hit an error—Google Sheets doesn’t allow empty spreadsheets.

内容的提问来源于stack exchange，提问作者boardrider