Rename sheets with 'SOLVED - ' prefix when /solved

[turbot] / turbot / sheets.py

diff --git a/turbot/sheets.py b/turbot/sheets.py
index 047f793b0c22c805615b215a5f803d81dec56e65..622e8c8793424215f3b976f87fc3953f8887b608 100644 (file)
--- 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