Advertisement
Guest User

scrapper

a guest
May 23rd, 2018
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1.         if i % len(sheet_names) == 0:
  2.             import gspread
  3.             from oauth2client.service_account import ServiceAccountCredentials
  4.  
  5.             credentials = ServiceAccountCredentials.from_json_keyfile_name('client_secret.json', scope)
  6.             gc = gspread.authorize(credentials)
  7.             wks = gc.open('MLL').worksheet(sheet_names[0][0])
  8.             wks.append_row(["19-May-2018", "123409871234",
  9.                             '=HYPERLINK("' + new_ads[key]['Url'] + '","' + new_ads[key]['Address'] + '")',
  10.                             'kijiji.ca',
  11.                             new_ads[key]['phone'], 'N/A', new_ads[key]['Location'],
  12.                             new_ads[key]['Property Type'], 'Kijiji Scrapper', sheet_names[0][0], 'Open', '', '', '',
  13.                             ''])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement