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': [