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)