Add notes on how to update the Google sheets credentials

[turbot] / turbot / sheets.py

diff --git a/turbot/sheets.py b/turbot/sheets.py
index 56adef6cf8a7433ef6614b99b1fb285ba06e15af..76515ca09547c660a94466fd6d223259211b7f44 100644 (file)
--- a/turbot/sheets.py
+++ b/turbot/sheets.py
@@ -2,7 +2,7 @@ PUZZLE_TEMPLATE_ID = "1drSoyrE4gM3JaGweDkOybwXWdKPIDTfUmB1gQCYS3Uw"
 PUZZLE_TEMPLATE_SHEETS = ["Text", "Square grid", "Hex Grid",
                           "Formula reference: indexing"]
 
-def sheets_create_folder(turb, folder_name):
+def sheets_create_folder(turb, folder_name, parents = None):
     """Create a new folder within Google Drive
 
     Returns the id of the created folder."""
@@ -12,6 +12,9 @@ def sheets_create_folder(turb, folder_name):
         "mimeType": "application/vnd.google-apps.folder"
     }
 
+    if parents:
+        body["parents"] = parents
+
     folder = turb.files.create(body=body, fields='id').execute()
 
     return folder.get('id')
@@ -92,14 +95,14 @@ def sheets_create_for_puzzle(turb, puzzle, folder_id):
     if 'url' in puzzle:
         url_link = puzzle['url']
         url_text = "Original puzzle link"
-        spreadsheet_insert_data(
+        spreadsheet_update_data(
             turb, spreadsheet_id, "B1:B1",
             '=HYPERLINK("{}","{}")'.format(url_link, url_text))
 
     if 'channel_url' in puzzle:
         url_link = puzzle['channel_url']
         url_text = "Slack channel link"
-        spreadsheet_insert_data(
+        spreadsheet_update_data(
             turb, spreadsheet_id, "B2:B2",
             '=HYPERLINK("{}","{}")'.format(url_link, url_text))
 
@@ -108,13 +111,12 @@ def sheets_create_for_puzzle(turb, puzzle, folder_id):
         'url': spreadsheet_url
     }
 
-def spreadsheet_insert_data(turb, spreadsheet_id, range, text):
+def spreadsheet_update_data(turb, spreadsheet_id, range, text):
 
-    turb.sheets.values().append(
+    turb.sheets.values().update(
         spreadsheetId=spreadsheet_id,
         range=range,
         valueInputOption='USER_ENTERED',
-        insertDataOption='INSERT_ROWS',
         body={
             'range': range,
             'values': [