spreadsheet.id)
if product.spreadsheet_id:
drive_spreadsheet = drive.open_google_spreadsheet(
product.spreadsheet_id)
if drive_spreadsheet:
for site in product.sites_list:
worksheet = None
try:
worksheet = drive_spreadsheet.worksheet(
site.site_type.name)
except Exception:
worksheet = drive_spreadsheet.add_worksheet(
site.site_type.name, 50, 50)
available_row = drive.next_available_row(worksheet)
last_row = int(available_row) - 1
last_value_cell = None
if last_row > 0:
last_cell = 'A' + str(last_row)
last_value_cell = worksheet.acell(last_cell).value
scraper = Scraper()
preco = scraper.get_product_price(site.url, site.site_type)
preco_text = None
if preco is not None:
preco_text = PriceUtils.remove_currency_from_price(
preco.get_text().strip())
timestamp_cell_edit = 'C' + str(available_row)
