Google Sheets API创建空白表格性能缓慢问题咨询

我直接采用Google Sheets API文档「创建电子表格」中的Python示例代码，仅修改凭据信息，却遇到创建空白电子表格性能极差的问题，耗时约5秒。

代码示例（已隐去凭据） #

from googleapiclient.discovery import build
from googleapiclient.errors import HttpError
from google.oauth2.credentials import Credentials


def create(title):
    creds = Credentials(
        token="xxx",
        refresh_token="xxx",
        token_uri="https://oauth2.googleapis.com/token",
        client_id="xxx",
        client_secret="xxx",
    )

    try:
        service = build("sheets", "v4", credentials=creds)
        spreadsheet = {"properties": {"title": title}}
        import time

        start_time = time.time()
        spreadsheet = (
            service.spreadsheets()
            .create(body=spreadsheet, fields="spreadsheetId")
            .execute()
        )
        print(f"Time taken: {time.time() - start_time} seconds")
        print(f"Spreadsheet ID: {(spreadsheet.get('spreadsheetId'))}")
        return spreadsheet.get("spreadsheetId")
    except HttpError as error:
        print(f"An error occurred: {error}")
        return error


if __name__ == "__main__":
    # Pass: title
    import time

    start_time = time.time()
    create("mysheet1")
    print(f"Time taken: {time.time() - start_time} seconds")

输出结果 #

Time taken: 4.405630826950073 seconds
Spreadsheet ID: xxx
Time taken: 4.407716989517212 seconds

我查阅相关资料后仅找到针对大型表格的优化方案，现咨询：

• 该现象的原因是什么？
• 这属于预期情况吗？
• 是否可进行优化？

盼Google工作人员解答。

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