X-Git-Url: https://git.cworth.org/git?a=blobdiff_plain;f=turbot%2Fsheets.py;h=622e8c8793424215f3b976f87fc3953f8887b608;hb=6af86db03f09d859c8cd6aca044b11c31d5c4adc;hp=047f793b0c22c805615b215a5f803d81dec56e65;hpb=3f2f348f32da5904e8c610c04f8e0f687e46ba56;p=turbot

diff --git a/turbot/sheets.py b/turbot/sheets.py
index 047f793..622e8c8 100644
--- a/turbot/sheets.py
+++ b/turbot/sheets.py
@@ -78,3 +78,21 @@ def sheets_create_for_puzzle(turb, puzzle):
                                         }).execute()
 
     return new_sheet
+
+def renameSheet(turb, url, newName):
+    id = extractIdFromSheetUrl(url)
+    turb.sheets.batchUpdate(id,
+                            body={
+                                "updateSheetProperties": {
+                                    "properties": {
+                                        "sheetId": id,
+                                        "title": newName
+                                    }
+                                }}).execute()
+
+def extractIdFromSheetUrl(url):
+    # Google sheet ids are between the /d/ and /edit in the url, like https://docs.google.com/spreadsheets/d/1dxHBzjenjhCAJQ8lM0skJO2mxlup8aWZm0-LaXeVPrg/edit#gid=0
+    startIndex = url.find('/d/') + 3
+    endIndex = url.find('/edit')
+    return url[startIndex : endIndex]
+    
\ No newline at end of file