Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if i % len(sheet_names) == 0:
- import gspread
- from oauth2client.service_account import ServiceAccountCredentials
- credentials = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)
- gc = gspread.authorize(credentials)
- wks = gc.open('MLL').worksheet(sheet_names[0][0])
- wks.append_row(["19-May-2018", "123409871234",
- '=HYPERLINK("' + new_ads[key]['Url'] + '","' + new_ads[key]['Address'] + '")',
- 'kijiji.ca',
- new_ads[key]['phone'], 'N/A', new_ads[key]['Location'],
- new_ads[key]['Property Type'], 'Kijiji Scrapper', sheet_names[0][0], 'Open', '', '', '',
- ''])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement