def import_to_googlesheets(records, search_term, credentials): ss = Spreadsheet(credentials, debug_mode=False) try: f = open('temp.txt', 'x') email = input('Email: ') ss.create('Amazon', search_term) ss.share_with_email_for_writing(email) f.write(ss.spreadsheet_id) f.close() except FileExistsError: f = open('temp.txt', 'r') ss.set_spreadsheet_by_id(f.read()) try: ss.add_sheet(search_term) except googleapiclient.errors.HttpError: ss.set_sheet_by_title(search_term) ss.clear_sheet() f.close() finally: ss.prepare_set_values('A1:E1', [['Name', 'Price', 'Rating', 'Reviews', 'Url']]) ss.prepare_set_values('A2:E%d' % (len(records) + 1), records) ss.run_prepared()