insertDataOption='INSERT_ROWS',
body={
'range': 'A1:A2',
- 'values': [['=HYPERLINK("'+url_link+'","'+url_text+'")'], ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")']]
+ 'values': [
+ ['=HYPERLINK("'+url_link+'","'+url_text+'")'],
+ ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")']
+ ]
}).execute()
# Copy some sheets from the Template spreadsheet
).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
+ # Google sheet ids are between the /d/ and /edit in the url, like
+ # https://docs.google.com/spreadsheets/d/1dxHBzjen...-LaXeVPrg/edit#gid=0
startIndex = url.find('/d/') + 3
endIndex = url.find('/edit')
return url[startIndex : endIndex]
-
\ No newline at end of file