Repository: burnash/gspread

Issue:
Add ability to batch add/remove comments and notes for cells 
**Is your feature request related to a problem? Please describe.**
We have an `insert_note` function, however, this happens at an individual cell level. I need to batch add comments and I always exceed the API limit. 

**Describe the solution you'd like**
Similar to Batch-add cells, we can have the `batch_insert_note` function. 

**Describe alternatives you've considered**
I currently run a loop and use a try-catch to handle for APIError. However, this is not a suitable way of doing things. 

**Additional context**


Discussion:

Patch:
diff --git a/gspread/worksheet.py b/gspread/worksheet.py
index 99caacb..1ba6c9a 100644
--- a/gspread/worksheet.py
+++ b/gspread/worksheet.py
@@ -2294,6 +2294,57 @@ class Worksheet:
 
         return note
 
+    def update_notes(self, notes):
+        """update multiple notes. The notes are attached to a certain cell.
+
+        :param notes dict: A dict of notes with their cells coordinates and respective content
+
+            dict format is:
+
+            * key: the cell coordinates as A1 range format
+            * value: the string content of the cell
+
+            Example::
+
+                {
+                    "D7": "Please read my notes",
+                    "GH42": "this one is too far",
+                }
+
+        .. versionadded:: 5.9
+        """
+
+        body = {"requests": []}
+
+        for range, content in notes.items():
+            if not isinstance(content, str):
+                raise TypeError(
+                    "Only string allowed as content for a note: '{} - {}'".format(
+                        range, content
+                    )
+                )
+
+            req = {
+                "updateCells": {
+                    "range": a1_range_to_grid_range(range, self.id),
+                    "fields": "note",
+                    "rows": [
+                        {
+                            "values": [
+                                {
+                                    "note": content,
+                                },
+                            ],
+                        },
+                    ],
+                },
+            }
+
+            body["requests"].append(req)
+
+        self.spreadsheet.batch_update(body)
+
+    @cast_to_a1_notation
     def update_note(self, cell, content):
         """Update the content of the note located at `cell`.
 
@@ -2303,24 +2354,7 @@ class Worksheet:
 
         .. versionadded:: 3.7
         """
-
-        if not isinstance(content, str):
-            raise TypeError("Only string allowed as content for a note.")
-
-        grid_range = a1_range_to_grid_range(cell, self.id)
-
-        body = {
-            "requests": [
-                {
-                    "updateCells": {
-                        "range": grid_range,
-                        "rows": [{"values": [{"note": content}]}],
-                        "fields": "note",
-                    }
-                }
-            ]
-        }
-        self.spreadsheet.batch_update(body)
+        self.update_notes({cell: content})
 
     @cast_to_a1_notation
     def insert_note(self, cell, content):
@@ -2340,7 +2374,38 @@ class Worksheet:
 
         .. versionadded:: 3.7
         """
-        self.update_note(cell, content)
+        self.update_notes({cell: content})
+
+    def insert_notes(self, notes):
+        """insert multiple notes. The notes are attached to a certain cell.
+
+        :param notes dict: A dict of notes with their cells coordinates and respective content
+
+            dict format is:
+
+            * key: the cell coordinates as A1 range format
+            * value: the string content of the cell
+
+            Example::
+
+                {
+                    "D7": "Please read my notes",
+                    "GH42": "this one is too far",
+                }
+
+        .. versionadded:: 5.9
+        """
+        self.update_notes(notes)
+
+    def clear_notes(self, ranges):
+        """Clear all notes located at the at the coordinates
+        pointed to by ``ranges``.
+
+        :param ranges list: List of A1 coordinates where to clear the notes.
+            e.g. ``["A1", "GH42", "D7"]``
+        """
+        notes = {range: "" for range in ranges}
+        self.update_notes(notes)
 
     @cast_to_a1_notation
     def clear_note(self, cell):
@@ -2360,7 +2425,7 @@ class Worksheet:
         .. versionadded:: 3.7
         """
         # set the note to <empty string> will clear it
-        self.update_note(cell, "")
+        self.update_notes({cell: ""})
 
     @cast_to_a1_notation
     def define_named_range(self, name, range_name):


Test patch:
diff --git a/tests/cassettes/WorksheetTest.test_worksheet_notes.json b/tests/cassettes/WorksheetTest.test_worksheet_notes.json
index a873d59..d46608c 100644
--- a/tests/cassettes/WorksheetTest.test_worksheet_notes.json
+++ b/tests/cassettes/WorksheetTest.test_worksheet_notes.json
@@ -8,7 +8,7 @@
                 "body": "{\"name\": \"Test WorksheetTest test_worksheet_notes\", \"mimeType\": \"application/vnd.google-apps.spreadsheet\"}",
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -36,24 +36,23 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Vary": [
-                        "Origin",
-                        "X-Origin"
+                    "Server": [
+                        "ESF"
                     ],
-                    "Cache-Control": [
-                        "no-cache, no-store, max-age=0, must-revalidate"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-Content-Type-Options": [
+                        "nosniff"
                     ],
                     "Pragma": [
                         "no-cache"
                     ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
+                    "Vary": [
+                        "Origin, X-Origin"
                     ],
-                    "Server": [
-                        "GSE"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
@@ -61,38 +60,35 @@
                     "Expires": [
                         "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:20 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "1; mode=block"
+                    "Cache-Control": [
+                        "no-cache, no-store, max-age=0, must-revalidate"
                     ],
-                    "Content-Security-Policy": [
-                        "frame-ancestors 'self'"
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:26 GMT"
                     ],
                     "content-length": [
-                        "189"
+                        "193"
                     ]
                 },
                 "body": {
-                    "string": "{\n \"kind\": \"drive#file\",\n \"id\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n \"name\": \"Test WorksheetTest test_worksheet_notes\",\n \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
+                    "string": "{\n  \"kind\": \"drive#file\",\n  \"id\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"name\": \"Test WorksheetTest test_worksheet_notes\",\n  \"mimeType\": \"application/vnd.google-apps.spreadsheet\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -114,55 +110,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:21 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:26 GMT"
                     ],
                     "content-length": [
                         "3337"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -184,55 +180,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:21 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:26 GMT"
                     ],
                     "content-length": [
                         "3337"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU/values/%27Sheet1%27:clear",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI/values/%27Sheet1%27:clear",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -257,55 +253,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:21 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
                     ],
                     "content-length": [
                         "107"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"clearedRange\": \"Sheet1!A1:Z1000\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"clearedRange\": \"Sheet1!A1:Z1000\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?includeGridData=false",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?includeGridData=false",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -327,55 +323,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:21 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
                     ],
                     "content-length": [
                         "3337"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU/edit\"\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"properties\": {\n    \"title\": \"Test WorksheetTest test_worksheet_notes\",\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/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI/edit\"\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -397,37 +393,37 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:22 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
                     ],
                     "content-length": [
                         "69"
@@ -441,11 +437,11 @@
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU:batchUpdate",
-                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"sheetId\": 0, \"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1}, \"rows\": [{\"values\": [{\"note\": \"This is a test note\"}]}], \"fields\": \"note\"}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"slim shaddy\"}]}]}}]}",
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -457,7 +453,7 @@
                         "keep-alive"
                     ],
                     "Content-Length": [
-                        "215"
+                        "207"
                     ],
                     "Content-Type": [
                         "application/json"
@@ -473,55 +469,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:22 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
                     ],
                     "content-length": [
                         "97"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -543,55 +539,55 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
-                    ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
-                    "Server": [
-                        "ESF"
-                    ],
-                    "X-Content-Type-Options": [
-                        "nosniff"
-                    ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:22 GMT"
-                    ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
                     ],
                     "content-length": [
-                        "267"
+                        "259"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"This is a test note\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"slim shaddy\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "POST",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU:batchUpdate",
-                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"sheetId\": 0, \"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1}, \"rows\": [{\"values\": [{\"note\": \"\"}]}], \"fields\": \"note\"}}]}",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"the real slim shaddy\"}]}]}}]}",
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -603,7 +599,7 @@
                         "keep-alive"
                     ],
                     "Content-Length": [
-                        "196"
+                        "216"
                     ],
                     "Content-Type": [
                         "application/json"
@@ -619,55 +615,563 @@
                     "message": "OK"
                 },
                 "headers": {
-                    "Vary": [
-                        "Origin",
-                        "X-Origin",
-                        "Referer"
-                    ],
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:27 GMT"
+                    ],
+                    "content-length": [
+                        "97"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:28 GMT"
+                    ],
+                    "content-length": [
+                        "268"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"the real slim shaddy\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"\"}]}]}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "196"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
                     "Cache-Control": [
                         "private"
                     ],
-                    "X-Frame-Options": [
-                        "SAMEORIGIN"
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:28 GMT"
+                    ],
+                    "content-length": [
+                        "97"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:28 GMT"
+                    ],
+                    "content-length": [
+                        "69"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {}\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"read my note\"}]}]}}, {\"updateCells\": {\"range\": {\"startRowIndex\": 1, \"endRowIndex\": 2, \"startColumnIndex\": 1, \"endColumnIndex\": 2, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"Or don't\"}]}]}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "398"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:28 GMT"
+                    ],
+                    "content-length": [
+                        "105"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {},\n    {}\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:28 GMT"
+                    ],
+                    "content-length": [
+                        "260"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"read my note\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21B2&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Transfer-Encoding": [
                         "chunked"
                     ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:29 GMT"
+                    ],
+                    "content-length": [
+                        "256"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"Or don't\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"remember to clean bedroom\"}]}]}}, {\"updateCells\": {\"range\": {\"startRowIndex\": 1, \"endRowIndex\": 2, \"startColumnIndex\": 1, \"endColumnIndex\": 2, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"do homeworks\"}]}]}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "415"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
                     "Server": [
                         "ESF"
                     ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:22 GMT"
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
-                    "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"
                     ],
-                    "X-XSS-Protection": [
-                        "0"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:29 GMT"
                     ],
                     "content-length": [
-                        "97"
+                        "105"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"spreadsheetId\": \"1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU\",\n  \"replies\": [\n    {}\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {},\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "GET",
-                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21A1&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -689,55 +1193,201 @@
                     "message": "OK"
                 },
                 "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
                     "Vary": [
                         "Origin",
                         "X-Origin",
                         "Referer"
                     ],
-                    "Cache-Control": [
-                        "private"
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
                     ],
                     "X-Frame-Options": [
                         "SAMEORIGIN"
                     ],
-                    "Transfer-Encoding": [
-                        "chunked"
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:29 GMT"
+                    ],
+                    "content-length": [
+                        "273"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"remember to clean bedroom\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "GET",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?ranges=%27Sheet1%27%21B2&fields=sheets%2Fdata%2FrowData%2Fvalues%2Fnote",
+                "body": null,
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
                     ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
                     "Server": [
                         "ESF"
                     ],
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
                     "X-Content-Type-Options": [
                         "nosniff"
                     ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:22 GMT"
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
+                    ],
+                    "Transfer-Encoding": [
+                        "chunked"
                     ],
                     "Content-Type": [
                         "application/json; charset=UTF-8"
                     ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:29 GMT"
+                    ],
+                    "content-length": [
+                        "260"
+                    ]
+                },
+                "body": {
+                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {\n          \"rowData\": [\n            {\n              \"values\": [\n                {\n                  \"note\": \"do homeworks\"\n                }\n              ]\n            }\n          ]\n        }\n      ]\n    }\n  ]\n}\n"
+                }
+            }
+        },
+        {
+            "request": {
+                "method": "POST",
+                "uri": "https://sheets.googleapis.com/v4/spreadsheets/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI:batchUpdate",
+                "body": "{\"requests\": [{\"updateCells\": {\"range\": {\"startRowIndex\": 0, \"endRowIndex\": 1, \"startColumnIndex\": 0, \"endColumnIndex\": 1, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"\"}]}]}}, {\"updateCells\": {\"range\": {\"startRowIndex\": 1, \"endRowIndex\": 2, \"startColumnIndex\": 1, \"endColumnIndex\": 2, \"sheetId\": 0}, \"fields\": \"note\", \"rows\": [{\"values\": [{\"note\": \"\"}]}]}}]}",
+                "headers": {
+                    "User-Agent": [
+                        "python-requests/2.30.0"
+                    ],
+                    "Accept-Encoding": [
+                        "gzip, deflate"
+                    ],
+                    "Accept": [
+                        "*/*"
+                    ],
+                    "Connection": [
+                        "keep-alive"
+                    ],
+                    "Content-Length": [
+                        "378"
+                    ],
+                    "Content-Type": [
+                        "application/json"
+                    ],
+                    "authorization": [
+                        "<ACCESS_TOKEN>"
+                    ]
+                }
+            },
+            "response": {
+                "status": {
+                    "code": 200,
+                    "message": "OK"
+                },
+                "headers": {
+                    "Server": [
+                        "ESF"
+                    ],
                     "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\""
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
+                    ],
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin",
+                        "X-Origin",
+                        "Referer"
                     ],
                     "X-XSS-Protection": [
                         "0"
                     ],
+                    "Transfer-Encoding": [
+                        "chunked"
+                    ],
+                    "Content-Type": [
+                        "application/json; charset=UTF-8"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "private"
+                    ],
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:29 GMT"
+                    ],
                     "content-length": [
-                        "69"
+                        "105"
                     ]
                 },
                 "body": {
-                    "string": "{\n  \"sheets\": [\n    {\n      \"data\": [\n        {}\n      ]\n    }\n  ]\n}\n"
+                    "string": "{\n  \"spreadsheetId\": \"1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI\",\n  \"replies\": [\n    {},\n    {}\n  ]\n}\n"
                 }
             }
         },
         {
             "request": {
                 "method": "DELETE",
-                "uri": "https://www.googleapis.com/drive/v3/files/1mU7mVXvfGkKYngNS1uGnyMxOpzFs7RrYV49bjyxFujU?supportsAllDrives=True",
+                "uri": "https://www.googleapis.com/drive/v3/files/1r88Eu8I7C_rCV3jW2NjpAPUyjax8-9K8hvKch5nTzBI?supportsAllDrives=True",
                 "body": null,
                 "headers": {
                     "User-Agent": [
-                        "python-requests/2.27.1"
+                        "python-requests/2.30.0"
                     ],
                     "Accept-Encoding": [
                         "gzip, deflate"
@@ -762,27 +1412,41 @@
                     "message": "No Content"
                 },
                 "headers": {
-                    "Vary": [
-                        "Origin",
-                        "X-Origin"
+                    "Server": [
+                        "ESF"
                     ],
-                    "Cache-Control": [
-                        "no-cache, no-store, max-age=0, must-revalidate"
+                    "Alt-Svc": [
+                        "h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000"
                     ],
-                    "Pragma": [
-                        "no-cache"
+                    "Date": [
+                        "Wed, 10 May 2023 21:55:30 GMT"
                     ],
-                    "Server": [
-                        "GSE"
+                    "X-Content-Type-Options": [
+                        "nosniff"
+                    ],
+                    "Vary": [
+                        "Origin, X-Origin"
+                    ],
+                    "X-XSS-Protection": [
+                        "0"
                     ],
                     "Expires": [
                         "Mon, 01 Jan 1990 00:00:00 GMT"
                     ],
-                    "Date": [
-                        "Sun, 27 Feb 2022 16:55:23 GMT"
+                    "Content-Length": [
+                        "0"
                     ],
-                    "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": [
+                        "text/html"
+                    ],
+                    "X-Frame-Options": [
+                        "SAMEORIGIN"
+                    ],
+                    "Cache-Control": [
+                        "no-cache, no-store, max-age=0, must-revalidate"
+                    ],
+                    "Pragma": [
+                        "no-cache"
                     ]
                 },
                 "body": {
diff --git a/tests/worksheet_test.py b/tests/worksheet_test.py
index 34a901d..b5d4483 100644
--- a/tests/worksheet_test.py
+++ b/tests/worksheet_test.py
@@ -915,12 +915,29 @@ class WorksheetTest(GspreadTest):
 
         # will trigger a Exception in case of any issue
         self.assertEqual(w.get_note("A1"), "")
-        test_note_string = "This is a test note"
+        test_note_string = "slim shaddy"
         w.insert_note("A1", test_note_string)
         self.assertEqual(w.get_note("A1"), test_note_string)
+        update_note = "the real " + test_note_string
+        w.update_note("A1", update_note)
+        self.assertEqual(w.get_note("A1"), update_note)
         w.clear_note("A1")
         self.assertEqual(w.get_note("A1"), "")
 
+        notes = {"A1": "read my note", "B2": "Or don't"}
+
+        w.insert_notes(notes)
+        self.assertEqual(w.get_note("A1"), notes["A1"])
+        self.assertEqual(w.get_note("B2"), notes["B2"])
+
+        notes["A1"] = "remember to clean bedroom"
+        notes["B2"] = "do homeworks"
+        w.update_notes(notes)
+        self.assertEqual(w.get_note("A1"), notes["A1"])
+        self.assertEqual(w.get_note("B2"), notes["B2"])
+
+        w.clear_notes(["A1", "B2"])
+
         with self.assertRaises(TypeError) as _:
             w.insert_note("A1", 42)
             w.insert_note("A1", ["asddf", "asdfqwebn"])