Repository: burnash/gspread

Issue:
Worksheet ID Type Inconsistencies
**Describe the bug**
On a `Spreadsheet` instance when operating on the underlying worksheet objects sometimes a the worksheet id can be a string (`del_worksheet_by_id`), other times it must be an int (`get_worksheet_by_id`).

**Expected behavior**
Ability to get a worksheet off a spreadsheet with any valid integer or integer-like string.  I frequently store Worksheet indexes in environment variables so if I forget to wrap them in `int()` I get a needless error.

**Code example**
```python
sht = client.open('My fancy spreadsheet')
worksheet = sht.get_worksheet(1234) # this works

worksheet = sht.get_worksheet("1234") # throws gspread.exceptions.WorksheetNotFound
```

**Environment info:**
- Operating System: macOS
- Python: 3.11.4
- gspread: 5.10.0

**Proposed Solution**
https://github.com/burnash/gspread/blob/739b8fca7e91d798d71a446e8849f42b950c2840/gspread/spreadsheet.py#L271
```python
def get_worksheet_by_id(self, id):
        # ...
        sheet_data = self.fetch_sheet_metadata()

        try:
            item = finditem(
                lambda x: x["properties"]["sheetId"] == int(id), # wrap id argument with int converter
                sheet_data["sheets"],
            )
            return Worksheet(self, item["properties"])
        except (StopIteration, KeyError, ValueError): # add Value Error in case int conversion fails
            raise WorksheetNotFound("id {} not found".format(id))
```
It might be clearer to break out the ValueError into it's own exception handler but I don't know what the ideal error to raise would be.  Happy to open a PR for this, just looking for some guidance first.

Discussion:

Patch:
diff --git a/gspread/spreadsheet.py b/gspread/spreadsheet.py
index 4d95967..ad3ceb7 100644
--- a/gspread/spreadsheet.py
+++ b/gspread/spreadsheet.py
@@ -7,6 +7,7 @@ This module contains common spreadsheets' models.
 """
 
 import warnings
+from typing import Union
 
 from .exceptions import WorksheetNotFound
 from .urls import (
@@ -270,11 +271,11 @@ class Spreadsheet:
         except (KeyError, IndexError):
             raise WorksheetNotFound("index {} not found".format(index))
 
-    def get_worksheet_by_id(self, id):
+    def get_worksheet_by_id(self, id: Union[str, int]):
         """Returns a worksheet with specified `worksheet id`.
 
         :param id: The id of a worksheet. it can be seen in the url as the value of the parameter 'gid'.
-        :type id: int
+        :type id: str | int
 
         :returns: an instance of :class:`gspread.worksheet.Worksheet`.
         :raises:
@@ -287,14 +288,19 @@ class Spreadsheet:
         """
         sheet_data = self.fetch_sheet_metadata()
 
+        try:
+            worksheet_id_int = int(id)
+        except ValueError as ex:
+            raise ValueError("id should be int") from ex
+
         try:
             item = finditem(
-                lambda x: x["properties"]["sheetId"] == id,
+                lambda x: x["properties"]["sheetId"] == worksheet_id_int,
                 sheet_data["sheets"],
             )
             return Worksheet(self, item["properties"])
         except (StopIteration, KeyError):
-            raise WorksheetNotFound("id {} not found".format(id))
+            raise WorksheetNotFound("id {} not found".format(worksheet_id_int))
 
     def worksheets(self, exclude_hidden: bool = False):
         """Returns a list of all :class:`worksheets <gspread.worksheet.Worksheet>`
@@ -439,12 +445,16 @@ class Spreadsheet:
 
         return self.batch_update(body)
 
-    def del_worksheet_by_id(self, worksheet_id: str):
+    def del_worksheet_by_id(self, worksheet_id: Union[str, int]):
         """
         Deletes a Worksheet by id
         """
+        try:
+            worksheet_id_int = int(worksheet_id)
+        except ValueError as ex:
+            raise ValueError("id should be int") from ex
 
-        body = {"requests": [{"deleteSheet": {"sheetId": worksheet_id}}]}
+        body = {"requests": [{"deleteSheet": {"sheetId": worksheet_id_int}}]}
 
         return self.batch_update(body)
 


Test patch:
diff --git a/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json b/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
index 9923d10..16287c2 100644
--- a/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
+++ b/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
@@ -42,17 +42,17 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:37 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:56 GMT"
+                    ],
+                    "Vary": [
+                        "Origin, X-Origin"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -60,37 +60,37 @@
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
                     ],
-                    "Vary": [
-                        "Origin, X-Origin"
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "197"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"kind\": \"drive#file\",\n  \"id\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"name\": \"Test SpreadsheetTest test_add_del_worksheet\",\n  \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
+                    "string": "{\n  \"kind\": \"drive#file\",\n  \"id\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"name\": \"Test SpreadsheetTest test_add_del_worksheet\",\n  \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -122,17 +122,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:38 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:57 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -140,6 +137,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -151,22 +151,22 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "3341"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://www.googleapis.com/drive/v3/files/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?supportsAllDrives=True&includeItemsFromAllDrives=True&fields=id%2Cname%2CcreatedTime%2CmodifiedTime",
+                "uri": "https://www.googleapis.com/drive/v3/files/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?supportsAllDrives=True&includeItemsFromAllDrives=True&fields=id%2Cname%2CcreatedTime%2CmodifiedTime",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -198,17 +198,17 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:38 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:57 GMT"
+                    ],
+                    "Vary": [
+                        "Origin, X-Origin"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -216,37 +216,37 @@
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
                     ],
-                    "Vary": [
-                        "Origin, X-Origin"
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "207"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"id\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"name\": \"Test SpreadsheetTest test_add_del_worksheet\",\n  \"createdTime\": \"2023-07-25T15:38:34.842Z\",\n  \"modifiedTime\": \"2023-07-25T15:38:36.246Z\"\n}\n"
+                    "string": "{\n  \"id\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"name\": \"Test SpreadsheetTest test_add_del_worksheet\",\n  \"createdTime\": \"2023-08-09T19:33:54.965Z\",\n  \"modifiedTime\": \"2023-08-09T19:33:54.983Z\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -278,17 +278,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:39 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:57 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -296,6 +293,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -307,22 +307,22 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "3341"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"test_add_del_worksheet 1\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 1, \"columnCount\": 1}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -360,17 +360,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:39 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:58 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -378,6 +375,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -389,22 +389,22 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
-                        "394"
+                        "395"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 654035640,\n          \"title\": \"test_add_del_worksheet 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 1,\n            \"columnCount\": 1\n          }\n        }\n      }\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1877059582,\n          \"title\": \"test_add_del_worksheet 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 1,\n            \"columnCount\": 1\n          }\n        }\n      }\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"test_add_del_worksheet 2\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 1, \"columnCount\": 1}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -442,17 +442,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:40 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:58 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -460,6 +457,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -471,22 +471,104 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
+                    "Server": [
+                        "ESF"
+                    ],
+                    "content-length": [
+                        "394"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 580173816,\n          \"title\": \"test_add_del_worksheet 2\",\n          \"index\": 2,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 1,\n            \"columnCount\": 1\n          }\n        }\n      }\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
+                "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"test_add_del_worksheet 3\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 1, \"columnCount\": 1}}}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.31.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "x-goog-api-client": [
+                        "cred-type/sa"
+                    ],
+                    "x-identity-trust-boundary": [
+                        "0"
+                    ],
+                    "Content-Length": [
+                        "157"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:58 GMT"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
                     "X-Frame-Options": [
                         "SAMEORIGIN"
                     ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Server": [
+                        "ESF"
+                    ],
                     "content-length": [
-                        "394"
+                        "395"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 591499596,\n          \"title\": \"test_add_del_worksheet 2\",\n          \"index\": 2,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 1,\n            \"columnCount\": 1\n          }\n        }\n      }\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1396229743,\n          \"title\": \"test_add_del_worksheet 3\",\n          \"index\": 3,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 1,\n            \"columnCount\": 1\n          }\n        }\n      }\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -518,17 +600,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:40 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:59 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -536,6 +615,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -547,23 +629,23 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
-                        "3855"
+                        "4114"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    },\n    {\n      \"properties\": {\n        \"sheetId\": 654035640,\n        \"title\": \"test_add_del_worksheet 1\",\n        \"index\": 1,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1,\n          \"columnCount\": 1\n        }\n      }\n    },\n    {\n      \"properties\": {\n        \"sheetId\": 591499596,\n        \"title\": \"test_add_del_worksheet 2\",\n        \"index\": 2,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1,\n          \"columnCount\": 1\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    },\n    {\n      \"properties\": {\n        \"sheetId\": 1877059582,\n        \"title\": \"test_add_del_worksheet 1\",\n        \"index\": 1,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1,\n          \"columnCount\": 1\n        }\n      }\n    },\n    {\n      \"properties\": {\n        \"sheetId\": 580173816,\n        \"title\": \"test_add_del_worksheet 2\",\n        \"index\": 2,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1,\n          \"columnCount\": 1\n        }\n      }\n    },\n    {\n      \"properties\": {\n        \"sheetId\": 1396229743,\n        \"title\": \"test_add_del_worksheet 3\",\n        \"index\": 3,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1,\n          \"columnCount\": 1\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 654035640}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1877059582}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.31.0"
@@ -584,7 +666,7 @@
                         "0"
                     ],
                     "Content-Length": [
-                        "55"
+                        "56"
                     ],
                     "Content-Type": [
                         "application/json"
@@ -600,17 +682,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:40 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:59 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -618,6 +697,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -629,23 +711,23 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 591499596}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 580173816}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.31.0"
@@ -682,17 +764,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:41 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:59 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -700,6 +779,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -711,22 +793,104 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
+                    "Server": [
+                        "ESF"
+                    ],
+                    "content-length": [
+                        "97"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1396229743}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.31.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "x-goog-api-client": [
+                        "cred-type/sa"
+                    ],
+                    "x-identity-trust-boundary": [
+                        "0"
+                    ],
+                    "Content-Length": [
+                        "56"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:33:59 GMT"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
                     "X-Frame-Options": [
                         "SAMEORIGIN"
                     ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Server": [
+                        "ESF"
+                    ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -758,17 +922,14 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:41 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:34:00 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
@@ -776,6 +937,9 @@
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
@@ -787,22 +951,22 @@
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ],
                     "content-length": [
                         "3341"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_add_del_worksheet\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "DELETE",
-                "uri": "https://www.googleapis.com/drive/v3/files/1Z7dkiMbI24eSuhI-lxEOaO7gNY_S4dePDV0EtBKrsi8?supportsAllDrives=True",
+                "uri": "https://www.googleapis.com/drive/v3/files/18q2vbKBaujo2mlHN6mzGFyKkOI4k03FUxpKj2retQJI?supportsAllDrives=True",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -837,8 +1001,8 @@
                     "message": "No Content"
                 },
                 "headers": {
-                    "Date": [
-                        "Tue, 25 Jul 2023 15:38:42 GMT"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
                     "Content-Type": [
                         "text/html"
@@ -846,32 +1010,32 @@
                     "X-XSS-Protection": [
                         "0"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "Content-Length": [
-                        "0"
-                    ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:34:00 GMT"
                     ],
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
+                    ],
+                    "Content-Length": [
+                        "0"
+                    ],
                     "Pragma": [
                         "no-cache"
                     ],
                     "Vary": [
                         "Origin, X-Origin"
                     ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Server": [
+                        "ESF"
                     ]
                 },
                 "body": {
diff --git a/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json b/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
index 9b4c4ee..d1f5cfa 100644
--- a/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
+++ b/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
@@ -42,55 +42,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Date": [
-                        "Tue, 25 Jul 2023 15:38:56 GMT"
+                        "Wed, 09 Aug 2023 19:17:57 GMT"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
-                    ],
                     "Server": [
                         "ESF"
                     ],
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
+                    ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Vary": [
+                        "Origin, X-Origin"
+                    ],
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
                     ],
-                    "Vary": [
-                        "Origin, X-Origin"
-                    ],
-                    "Transfer-Encoding": [
-                        "chunked"
-                    ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
-                    ],
                     "content-length": [
                         "199"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"kind\": \"drive#file\",\n  \"id\": \"1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA\",\n  \"name\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n  \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
+                    "string": "{\n  \"kind\": \"drive#file\",\n  \"id\": \"1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I\",\n  \"name\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n  \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -122,51 +122,51 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Date": [
-                        "Tue, 25 Jul 2023 15:38:57 GMT"
+                        "Wed, 09 Aug 2023 19:17:58 GMT"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
-                    ],
                     "Server": [
                         "ESF"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "Cache-Control": [
+                        "private"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
                     "content-length": [
                         "3343"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://www.googleapis.com/drive/v3/files/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA?supportsAllDrives=True&includeItemsFromAllDrives=True&fields=id%2Cname%2CcreatedTime%2CmodifiedTime",
+                "uri": "https://www.googleapis.com/drive/v3/files/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I?supportsAllDrives=True&includeItemsFromAllDrives=True&fields=id%2Cname%2CcreatedTime%2CmodifiedTime",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -198,55 +198,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Date": [
-                        "Tue, 25 Jul 2023 15:38:57 GMT"
+                        "Wed, 09 Aug 2023 19:17:58 GMT"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
-                    ],
                     "Server": [
                         "ESF"
                     ],
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
+                    ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Vary": [
+                        "Origin, X-Origin"
+                    ],
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
                     ],
-                    "Vary": [
-                        "Origin, X-Origin"
-                    ],
-                    "Transfer-Encoding": [
-                        "chunked"
-                    ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
-                    ],
                     "content-length": [
                         "209"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"id\": \"1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA\",\n  \"name\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n  \"createdTime\": \"2023-07-25T15:38:54.531Z\",\n  \"modifiedTime\": \"2023-07-25T15:38:55.718Z\"\n}\n"
+                    "string": "{\n  \"id\": \"1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I\",\n  \"name\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n  \"createdTime\": \"2023-08-09T19:17:55.684Z\",\n  \"modifiedTime\": \"2023-08-09T19:17:55.702Z\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -278,51 +278,127 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Date": [
-                        "Tue, 25 Jul 2023 15:38:58 GMT"
+                        "Wed, 09 Aug 2023 19:17:59 GMT"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
-                    ],
                     "Server": [
                         "ESF"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
                     "Cache-Control": [
                         "private"
                     ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
+                    "content-length": [
+                        "3343"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I/edit\"\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I?includeGridData=false",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.31.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "x-goog-api-client": [
+                        "cred-type/sa"
+                    ],
+                    "x-identity-trust-boundary": [
+                        "0"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Date": [
+                        "Wed, 09 Aug 2023 19:17:59 GMT"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "Cache-Control": [
+                        "private"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
                     "content-length": [
                         "3343"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest test_get_worksheet_by_id\",\n    \"locale\": \"en_US\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Etc/GMT\",\n    \"defaultFormat\": {\n      \"backgroundColor\": {\n        \"red\": 1,\n        \"green\": 1,\n        \"blue\": 1\n      },\n      \"padding\": {\n        \"top\": 2,\n        \"right\": 3,\n        \"bottom\": 2,\n        \"left\": 3\n      },\n      \"verticalAlignment\": \"BOTTOM\",\n      \"wrapStrategy\": \"OVERFLOW_CELL\",\n      \"textFormat\": {\n        \"foregroundColor\": {},\n        \"fontFamily\": \"arial,sans,sans-serif\",\n        \"fontSize\": 10,\n        \"bold\": false,\n        \"italic\": false,\n        \"strikethrough\": false,\n        \"underline\": false,\n        \"foregroundColorStyle\": {\n          \"rgbColor\": {}\n        }\n      },\n      \"backgroundColorStyle\": {\n        \"rgbColor\": {\n          \"red\": 1,\n          \"green\": 1,\n          \"blue\": 1\n        }\n      }\n    },\n    \"spreadsheetTheme\": {\n      \"primaryFontFamily\": \"Arial\",\n      \"themeColors\": [\n        {\n          \"colorType\": \"TEXT\",\n          \"color\": {\n            \"rgbColor\": {}\n          }\n        },\n        {\n          \"colorType\": \"BACKGROUND\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 1,\n              \"blue\": 1\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT1\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.25882354,\n              \"green\": 0.52156866,\n              \"blue\": 0.95686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT2\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.91764706,\n              \"green\": 0.2627451,\n              \"blue\": 0.20784314\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT3\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.9843137,\n              \"green\": 0.7372549,\n              \"blue\": 0.015686275\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT4\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.20392157,\n              \"green\": 0.65882355,\n              \"blue\": 0.3254902\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT5\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 1,\n              \"green\": 0.42745098,\n              \"blue\": 0.003921569\n            }\n          }\n        },\n        {\n          \"colorType\": \"ACCENT6\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.27450982,\n              \"green\": 0.7411765,\n              \"blue\": 0.7764706\n            }\n          }\n        },\n        {\n          \"colorType\": \"LINK\",\n          \"color\": {\n            \"rgbColor\": {\n              \"red\": 0.06666667,\n              \"green\": 0.33333334,\n              \"blue\": 0.8\n            }\n          }\n        }\n      ]\n    }\n  },\n  \"sheets\": [\n    {\n      \"properties\": {\n        \"sheetId\": 0,\n        \"title\": \"Sheet1\",\n        \"index\": 0,\n        \"sheetType\": \"GRID\",\n        \"gridProperties\": {\n          \"rowCount\": 1000,\n          \"columnCount\": 26\n        }\n      }\n    }\n  ],\n  \"spreadsheetUrl\": \"https://docs.google.com/spreadsheets/d/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "DELETE",
-                "uri": "https://www.googleapis.com/drive/v3/files/1cROVEPJhE09q88eO9Q87lizhMG1qnn4d9ExVZC1OnFA?supportsAllDrives=True",
+                "uri": "https://www.googleapis.com/drive/v3/files/1jpzjRnRdwSfOpaEZl154V2bXuY28qze0YREG6qCJZ_I?supportsAllDrives=True",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -357,41 +433,41 @@
                     "message": "No Content"
                 },
                 "headers": {
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Date": [
-                        "Tue, 25 Jul 2023 15:38:59 GMT"
+                        "Wed, 09 Aug 2023 19:18:00 GMT"
                     ],
                     "Content-Type": [
                         "text/html"
                     ],
-                    "X-XSS-Protection": [
+                    "Content-Length": [
                         "0"
                     ],
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Length": [
-                        "0"
+                    "Expires": [
+                        "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
+                    "Vary": [
+                        "Origin, X-Origin"
+                    ],
                     "Cache-Control": [
                         "no-cache, no-store, max-age=0, must-revalidate"
                     ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
-                    ],
-                    "Vary": [
-                        "Origin, X-Origin"
-                    ],
-                    "Expires": [
-                        "Mon, 01 Jan 1990 00:00:00 GMT"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
                     ]
                 },
                 "body": {
diff --git a/tests/spreadsheet_test.py b/tests/spreadsheet_test.py
index beedf75..0dadf37 100644
--- a/tests/spreadsheet_test.py
+++ b/tests/spreadsheet_test.py
@@ -38,8 +38,10 @@ class SpreadsheetTest(GspreadTest):
 
     @pytest.mark.vcr()
     def test_get_worksheet_by_id(self):
-        sheet1 = self.spreadsheet.get_worksheet_by_id(0)
-        self.assertTrue(isinstance(sheet1, gspread.Worksheet))
+        sheet1_by_int = self.spreadsheet.get_worksheet_by_id(0)
+        sheet1_by_str = self.spreadsheet.get_worksheet_by_id("0")
+        self.assertTrue(isinstance(sheet1_by_int, gspread.Worksheet))
+        self.assertTrue(isinstance(sheet1_by_str, gspread.Worksheet))
 
     @pytest.mark.vcr()
     def test_worksheet(self):
@@ -103,6 +105,7 @@ class SpreadsheetTest(GspreadTest):
         sg = self._sequence_generator()
         worksheet1_name = next(sg)
         worksheet2_name = next(sg)
+        worksheet3_name = next(sg)
 
         worksheet_list = self.spreadsheet.worksheets()
         self.assertEqual(len(worksheet_list), 1)
@@ -111,14 +114,16 @@ class SpreadsheetTest(GspreadTest):
         # Add
         worksheet1 = self.spreadsheet.add_worksheet(worksheet1_name, 1, 1)
         worksheet2 = self.spreadsheet.add_worksheet(worksheet2_name, 1, 1)
+        worksheet3 = self.spreadsheet.add_worksheet(worksheet3_name, 1, 1)
 
         # Re-read, check again
         worksheet_list = self.spreadsheet.worksheets()
-        self.assertEqual(len(worksheet_list), 3)
+        self.assertEqual(len(worksheet_list), 4)
 
         # Delete
         self.spreadsheet.del_worksheet(worksheet1)
-        self.spreadsheet.del_worksheet(worksheet2)
+        self.spreadsheet.del_worksheet_by_id(int(worksheet2.id))
+        self.spreadsheet.del_worksheet_by_id(str(worksheet3.id))
 
         worksheet_list = self.spreadsheet.worksheets()
         self.assertEqual(len(worksheet_list), 1)