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."""
"mimeType": "application/vnd.google-apps.folder"
}
+ if parents:
+ body["parents"] = parents
+
folder = turb.files.create(body=body, fields='id').execute()
return folder.get('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))
'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': [