Connecting to overwritten Google Sheets

@Bulloko thanks for the quick response. I checked my URL/sheetkey before and after today's script run and they remained unchanged. Unfortunately, I still got the same error when trying to run the data.

As for workbench, that is something I had considered, but didn't clearly see an OS X-friendly version so I didn't go down that path. Do you know if there is a version I can run on my MBP? I only see a .exe available for download.

@Bulloko

I was hopeful too!

As for the script, I have included the download, convert and upload steps below. Disclaimer: I worked with someone else to have this written, so any detailed questions may be tough for me to answer, but I'll certainly do my best.

def download_file(target_file_url):
	# Prepare download request
	download_request = urllib2.Request(target_file_url, headers=headers)
	# Add cookies
	cookies.add_cookie_header(download_request)
	try:
		# And proceed
		response = opener.open(download_request)
		content = response.read()

		with open('temp.html', 'wb') as r:
			r.write(content)
		print '[+] Downloaded file'
	except:
		print '[-] Problem occured during download'
		print '[!] Closing...'
		sys.exit(-1)


def convert_html_to_xlsx(drive_filename):
	try:
		# Open both html and xlsx
		with open('temp.html') as f:
			with xlsxwriter.Workbook(drive_filename) as workbook:
				worksheet = workbook.add_worksheet()
				tree = etree.HTML(f.read())
				# Get all rows
				trs = tree.xpath("//tr")
				for x in range(len(trs)):
					# And all cells
					tds = trs[x].xpath(".//td")
					for y in range(len(tds)):
						# And fill worksheet accordingly
						worksheet.write(x, y, tds[y].text)
	except:
		print '[-] Failed to convert files'
		print '[!] Closing...'
		sys.exit(-1)


def upload_to_drive(drive_filename,drive):
	try:
		file_list = drive.ListFile({'q': "'root' in parents and trashed=false"}).GetList()
		for result_file in file_list:
			if result_file['title'] == drive_filename:
				result_file.SetContentFile(drive_filename)
				result_file.Upload()
				print '[+] File updated successfully'
				return True

		result_file = drive.CreateFile()
		result_file.SetContentFile(drive_filename)
		result_file.Upload({'convert':True})
		print '[+] File uploaded successfully'
	except Exception as e:
		print e
		print '[-] Failed to upload the file'
		print '[!] Closing...'
		sys.exit(-1)