Repository: burnash/gspread

Issue:
Feature request: set file Properties as "timeZone"
I would like to change the timeZone of spreadsheet file, presents in file Properties as listed in
https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets#SpreadsheetProperties

Setting it during create or after with set operation
Because I discovered that it influences the cells valued with dates.



Discussion:

Patch:
diff --git a/gspread/spreadsheet.py b/gspread/spreadsheet.py
index b291607..e2f07d4 100644
--- a/gspread/spreadsheet.py
+++ b/gspread/spreadsheet.py
@@ -93,6 +93,16 @@ class Spreadsheet:
             stacklevel=2,
         )
 
+    @property
+    def timezone(self):
+        """Spreadsheet timeZone"""
+        return self._properties["timeZone"]
+
+    @property
+    def locale(self):
+        """Spreadsheet locale"""
+        return self._properties["locale"]
+
     @property
     def sheet1(self):
         """Shortcut property for getting the first worksheet."""
@@ -562,3 +572,46 @@ class Spreadsheet:
         return self.fetch_sheet_metadata(params={"fields": "namedRanges"}).get(
             "namedRanges", []
         )
+
+    def update_timezone(self, timezone):
+        """Updates the current spreadsheet timezone.
+        Can be any timezone in CLDR format such as "America/New_York"
+        or a custom time zone such as GMT-07:00.
+        """
+
+        body = {
+            "requests": [
+                {
+                    "updateSpreadsheetProperties": {
+                        "properties": {"timeZone": timezone},
+                        "fields": "timeZone",
+                    },
+                },
+            ]
+        }
+
+        return self.batch_update(body)
+
+    def update_locale(self, locale):
+        """Update the locale of the spreaddsheet.
+        Can be any of the ISO 639-1 language codes, such as: de, fr, en, ...
+        Or an ISO 639-2 if no ISO 639-1 exists.
+        Or a combination of the ISO language code and country code,
+        such as en_US, de_CH, fr_FR, ...
+
+        .. note::
+            Note: when updating this field, not all locales/languages are supported.
+        """
+
+        body = {
+            "requests": [
+                {
+                    "updateSpreadsheetProperties": {
+                        "properties": {"locale": locale},
+                        "fields": "locale",
+                    },
+                },
+            ]
+        }
+
+        return self.batch_update(body)
diff --git a/tox.ini b/tox.ini
index 6e91018..28f0509 100644
--- a/tox.ini
+++ b/tox.ini
@@ -13,7 +13,7 @@ commands = pytest {posargs} tests/
 [testenv:lint]
 description = Run code linters
 deps = -r lint-requirements.txt
-commands = black --check .
+commands = black --check --diff .
         codespell --skip=".tox,.git,./docs/build" .
         flake8 --ignore=E203 --max-complexity=10 --max-line-length=255 \
             --show-source --statistics .


Test patch:
diff --git a/tests/cassettes/SpreadsheetTest.json b/tests/cassettes/SpreadsheetTest.json
index c8145de..8c891ff 100644
--- a/tests/cassettes/SpreadsheetTest.json
+++ b/tests/cassettes/SpreadsheetTest.json
@@ -36,59 +36,59 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Server": [
-                        "GSE"
+                    "Pragma": [
+                        "no-cache"
                     ],
                     "Expires": [
                         "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Server": [
+                        "GSE"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:22 GMT"
+                    ],
+                    "X-XSS-Protection": [
+                        "1; mode=block"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
-                    ],
-                    "Cache-Control": [
-                        "no-cache, no-store, max-age=0, must-revalidate"
+                    "Content-Security-Policy": [
+                        "frame-ancestors 'self'"
                     ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:29 GMT"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
                     ],
-                    "Pragma": [
-                        "no-cache"
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
-                    "Content-Security-Policy": [
-                        "frame-ancestors 'self'"
+                    "Cache-Control": [
+                        "no-cache, no-store, max-age=0, must-revalidate"
                     ],
-                    "X-XSS-Protection": [
-                        "1; mode=block"
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "170"
                     ]
                 },
                 "body": {
-                    "string": "{\n \"kind\": \"drive#file\",\n \"id\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n \"name\": \"Test SpreadsheetTest\",\n \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
+                    "string": "{\n \"kind\": \"drive#file\",\n \"id\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n \"name\": \"Test SpreadsheetTest\",\n \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -117,48 +117,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:22 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:30 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "DELETE",
-                "uri": "https://www.googleapis.com/drive/v3/files/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?supportsAllDrives=True",
+                "uri": "https://www.googleapis.com/drive/v3/files/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?supportsAllDrives=True",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -187,27 +187,27 @@
                     "message": "No Content"
                 },
                 "headers": {
-                    "Server": [
-                        "GSE"
+                    "Pragma": [
+                        "no-cache"
                     ],
                     "Expires": [
                         "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
+                    "Server": [
+                        "GSE"
+                    ],
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:44 GMT"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin"
                     ],
-                    "Cache-Control": [
-                        "no-cache, no-store, max-age=0, must-revalidate"
-                    ],
                     "Alt-Svc": [
                         "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:36 GMT"
-                    ],
-                    "Pragma": [
-                        "no-cache"
+                    "Cache-Control": [
+                        "no-cache, no-store, max-age=0, must-revalidate"
                     ]
                 },
                 "body": {
diff --git a/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json b/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
index 3721d27..ecdf328 100644
--- a/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
+++ b/tests/cassettes/SpreadsheetTest.test_add_del_worksheet.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,48 +33,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:23 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:30 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"test_add_del_worksheet 1\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 1, \"columnCount\": 1}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -109,48 +109,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:25 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:30 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "394"
+                        "395"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 556032722,\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\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1523702613,\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"test_add_del_worksheet 2\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 1, \"columnCount\": 1}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -185,48 +185,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:26 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:31 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "395"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1722900095,\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\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1072339341,\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": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -255,49 +255,49 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:27 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:31 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "3833"
+                        "3834"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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\": 556032722,\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\": 1722900095,\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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\": 1523702613,\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\": 1072339341,\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 556032722}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1523702613}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.27.1"
@@ -312,7 +312,7 @@
                         "keep-alive"
                     ],
                     "Content-Length": [
-                        "55"
+                        "56"
                     ],
                     "Content-Type": [
                         "application/json"
@@ -331,49 +331,49 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:27 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:31 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1722900095}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1072339341}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.27.1"
@@ -407,48 +407,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:29 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:31 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -477,41 +477,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:29 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:32 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_get_worksheet.json b/tests/cassettes/SpreadsheetTest.test_get_worksheet.json
index 39581b0..ad5381b 100644
--- a/tests/cassettes/SpreadsheetTest.test_get_worksheet.json
+++ b/tests/cassettes/SpreadsheetTest.test_get_worksheet.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,41 +33,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:30 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:32 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json b/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
index 39581b0..ae005ca 100644
--- a/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
+++ b/tests/cassettes/SpreadsheetTest.test_get_worksheet_by_id.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,41 +33,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:31 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:32 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_sheet1.json b/tests/cassettes/SpreadsheetTest.test_sheet1.json
index 39581b0..ae005ca 100644
--- a/tests/cassettes/SpreadsheetTest.test_sheet1.json
+++ b/tests/cassettes/SpreadsheetTest.test_sheet1.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,41 +33,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:31 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:32 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "3318"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_timezone_and_locale.json b/tests/cassettes/SpreadsheetTest.test_timezone_and_locale.json
new file mode 100644
index 0000000..b035a73
--- /dev/null
+++ b/tests/cassettes/SpreadsheetTest.test_timezone_and_locale.json
@@ -0,0 +1,227 @@
+{
+    "version": 1,
+    "interactions": [
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"updateSpreadsheetProperties\": {\"properties\": {\"timeZone\": \"Europe/Paris\"}, \"fields\": \"timeZone\"}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.27.1"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "115"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:32 GMT"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "content-length": [
+                        "97"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"updateSpreadsheetProperties\": {\"properties\": {\"locale\": \"fr_FR\"}, \"fields\": \"locale\"}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.27.1"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "104"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:34 GMT"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "content-length": [
+                        "97"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.27.1"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:34 GMT"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "content-length": [
+                        "3323"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\n    \"locale\": \"fr_FR\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Europe/Paris\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
+                }
+            }
+        }
+    ]
+}
diff --git a/tests/cassettes/SpreadsheetTest.test_values_batch_get.json b/tests/cassettes/SpreadsheetTest.test_values_batch_get.json
index 99a89ff..5901cef 100644
--- a/tests/cassettes/SpreadsheetTest.test_values_batch_get.json
+++ b/tests/cassettes/SpreadsheetTest.test_values_batch_get.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"\\ud83c\\udf35 test_values_batch_get 1\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 10, \"columnCount\": 10}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -39,48 +39,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:35 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:33 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "400"
+                        "401"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 300841368,\n          \"title\": \"\ud83c\udf35 test_values_batch_get 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 10,\n            \"columnCount\": 10\n          }\n        }\n      }\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1510703462,\n          \"title\": \"\ud83c\udf35 test_values_batch_get 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 10,\n            \"columnCount\": 10\n          }\n        }\n      }\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "PUT",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/values/%F0%9F%8C%B5%20test_values_batch_get%201%21A1?valueInputOption=RAW",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/values/%F0%9F%8C%B5%20test_values_batch_get%201%21A1?valueInputOption=RAW",
                 "body": "{\"values\": [[\"\\ud83c\\udf47\", \"\\ud83c\\udf49\", \"\\ud83c\\udf4b\"], [\"\\ud83c\\udf50\", \"\\ud83c\\udf4e\", \"\\ud83c\\udf53\"]]}",
                 "headers": {
                     "User-Agent": [
@@ -115,48 +115,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:36 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:33 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "192"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"updatedRange\": \"'\ud83c\udf35 test_values_batch_get 1'!A1:C2\",\n  \"updatedRows\": 2,\n  \"updatedColumns\": 3,\n  \"updatedCells\": 6\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"updatedRange\": \"'\ud83c\udf35 test_values_batch_get 1'!A1:C2\",\n  \"updatedRows\": 2,\n  \"updatedColumns\": 3,\n  \"updatedCells\": 6\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/values:batchGet?ranges=%F0%9F%8C%B5+test_values_batch_get+1%21A%3AA&ranges=%F0%9F%8C%B5+test_values_batch_get+1%21B%3AB&ranges=%F0%9F%8C%B5+test_values_batch_get+1%21C%3AC",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/values:batchGet?ranges=%F0%9F%8C%B5+test_values_batch_get+1%21A%3AA&ranges=%F0%9F%8C%B5+test_values_batch_get+1%21B%3AB&ranges=%F0%9F%8C%B5+test_values_batch_get+1%21C%3AC",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -185,49 +185,49 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:37 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:33 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "699"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"valueRanges\": [\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!A1:A10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf47\"\n        ],\n        [\n          \"\ud83c\udf50\"\n        ]\n      ]\n    },\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!B1:B10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf49\"\n        ],\n        [\n          \"\ud83c\udf4e\"\n        ]\n      ]\n    },\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!C1:C10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf4b\"\n        ],\n        [\n          \"\ud83c\udf53\"\n        ]\n      ]\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"valueRanges\": [\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!A1:A10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf47\"\n        ],\n        [\n          \"\ud83c\udf50\"\n        ]\n      ]\n    },\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!B1:B10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf49\"\n        ],\n        [\n          \"\ud83c\udf4e\"\n        ]\n      ]\n    },\n    {\n      \"range\": \"'\ud83c\udf35 test_values_batch_get 1'!C1:C10\",\n      \"majorDimension\": \"ROWS\",\n      \"values\": [\n        [\n          \"\ud83c\udf4b\"\n        ],\n        [\n          \"\ud83c\udf53\"\n        ]\n      ]\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 300841368}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1510703462}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.27.1"
@@ -242,7 +242,7 @@
                         "keep-alive"
                     ],
                     "Content-Length": [
-                        "55"
+                        "56"
                     ],
                     "Content-Type": [
                         "application/json"
@@ -261,41 +261,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:38 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:33 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_values_get.json b/tests/cassettes/SpreadsheetTest.test_values_get.json
index a5f1ac4..6e88a55 100644
--- a/tests/cassettes/SpreadsheetTest.test_values_get.json
+++ b/tests/cassettes/SpreadsheetTest.test_values_get.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
                 "body": "{\"requests\": [{\"addSheet\": {\"properties\": {\"title\": \"\\ud83c\\udf35 test_values_get 1\", \"sheetType\": \"GRID\", \"gridProperties\": {\"rowCount\": 10, \"columnCount\": 10}}}}]}",
                 "headers": {
                     "User-Agent": [
@@ -39,48 +39,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:38 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:34 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "395"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1514991820,\n          \"title\": \"\ud83c\udf35 test_values_get 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 10,\n            \"columnCount\": 10\n          }\n        }\n      }\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {\n      \"addSheet\": {\n        \"properties\": {\n          \"sheetId\": 1081401547,\n          \"title\": \"\ud83c\udf35 test_values_get 1\",\n          \"index\": 1,\n          \"sheetType\": \"GRID\",\n          \"gridProperties\": {\n            \"rowCount\": 10,\n            \"columnCount\": 10\n          }\n        }\n      }\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "PUT",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/values/%F0%9F%8C%B5%20test_values_get%201%21A1?valueInputOption=RAW",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/values/%F0%9F%8C%B5%20test_values_get%201%21A1?valueInputOption=RAW",
                 "body": "{\"values\": [[\"\\ud83c\\udf47\", \"\\ud83c\\udf49\", \"\\ud83c\\udf4b\"], [\"\\ud83c\\udf50\", \"\\ud83c\\udf4e\", \"\\ud83c\\udf53\"]]}",
                 "headers": {
                     "User-Agent": [
@@ -115,48 +115,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:40 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:34 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "186"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"updatedRange\": \"'\ud83c\udf35 test_values_get 1'!A1:C2\",\n  \"updatedRows\": 2,\n  \"updatedColumns\": 3,\n  \"updatedCells\": 6\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"updatedRange\": \"'\ud83c\udf35 test_values_get 1'!A1:C2\",\n  \"updatedRows\": 2,\n  \"updatedColumns\": 3,\n  \"updatedCells\": 6\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/values/%F0%9F%8C%B5%20test_values_get%201",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/values/%F0%9F%8C%B5%20test_values_get%201",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -185,34 +185,34 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:40 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:34 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "203"
@@ -226,8 +226,8 @@
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M:batchUpdate",
-                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1514991820}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA:batchUpdate",
+                "body": "{\"requests\": [{\"deleteSheet\": {\"sheetId\": 1081401547}}]}",
                 "headers": {
                     "User-Agent": [
                         "python-requests/2.27.1"
@@ -261,41 +261,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:42 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:35 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_worksheet.json b/tests/cassettes/SpreadsheetTest.test_worksheet.json
index e0e3da0..3946515 100644
--- a/tests/cassettes/SpreadsheetTest.test_worksheet.json
+++ b/tests/cassettes/SpreadsheetTest.test_worksheet.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,41 +33,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:42 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:35 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "3318"
+                        "3323"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\n    \"locale\": \"fr_FR\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Europe/Paris\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/cassettes/SpreadsheetTest.test_worksheet_iteration.json b/tests/cassettes/SpreadsheetTest.test_worksheet_iteration.json
index 0805b0a..9380b56 100644
--- a/tests/cassettes/SpreadsheetTest.test_worksheet_iteration.json
+++ b/tests/cassettes/SpreadsheetTest.test_worksheet_iteration.json
@@ -4,7 +4,7 @@
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -33,48 +33,48 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:43 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:35 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "3318"
+                        "3323"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\n    \"locale\": \"fr_FR\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Europe/Paris\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
@@ -103,41 +103,41 @@
                     "Server": [
                         "ESF"
                     ],
-                    "Content-Type": [
-                        "application/json; charset=UTF-8"
+                    "Date": [
+                        "Wed, 09 Feb 2022 19:35:43 GMT"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "Alt-Svc": [
-                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\""
-                    ],
-                    "Date": [
-                        "Sat, 15 Jan 2022 17:13:35 GMT"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
                     ],
                     "content-length": [
-                        "3318"
+                        "3323"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\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/1_DoyK5wgRtAl5CdNgUjROBjdGdQGqi16teUrJmmE07M/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA\",\n  \"properties\": {\n    \"title\": \"Test SpreadsheetTest\",\n    \"locale\": \"fr_FR\",\n    \"autoRecalc\": \"ON_CHANGE\",\n    \"timeZone\": \"Europe/Paris\",\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/1tSpNArwLLuzgx-9RGWCD7vosT9enRK8cOxpqcSj3fPA/edit\"\n}\n"
                 }
             }
         }
diff --git a/tests/spreadsheet_test.py b/tests/spreadsheet_test.py
index dbc4d9c..6040864 100644
--- a/tests/spreadsheet_test.py
+++ b/tests/spreadsheet_test.py
@@ -129,3 +129,22 @@ class SpreadsheetTest(GspreadTest):
             for rowix, ele in enumerate(rng["values"]):
                 self.assertEqual(values[rowix][colix], ele[0])
         self.spreadsheet.del_worksheet(worksheet)
+
+    @pytest.mark.vcr()
+    def test_timezone_and_locale(self):
+        prev_timezone = self.spreadsheet.timezone
+        prev_locale = self.spreadsheet.locale
+        new_timezone = "Europe/Paris"
+        new_locale = "fr_FR"
+
+        self.spreadsheet.update_timezone(new_timezone)
+        self.spreadsheet.update_locale(new_locale)
+
+        # must fect metadata
+        properties = self.spreadsheet.fetch_sheet_metadata()["properties"]
+
+        self.assertNotEqual(prev_timezone, properties["timeZone"])
+        self.assertNotEqual(prev_locale, properties["locale"])
+
+        self.assertEqual(new_timezone, properties["timeZone"])
+        self.assertEqual(new_locale, properties["locale"])