
You need to use the Python client library for the code to work. Whether to convert this file to the corresponding Google Docs format. There is an Optional query parameter of "convert", for both the "INSERT" and "COPY" method convert=true, Test_file.SetContentFile('testfile.xlsx') I am still seeking a way to set the sharing settings of my new file to "anyone with the link can edit". UPDATE: conversion from xlsx to google sheets is easy with a convert=True flag. How can I set the file to be editable by anyone with the link? Once that is set, I can get the sharing link easily enough with PyDrive.

How can I convert to google sheets format? I tried to just specify the mimeType as 'application/' when I created the file to upload with PyDrive, but that gave me an error.


I am currently using PyDrive, which solves steps 1 and 5, but there are a few unsolved problems. Get the link and share it with someone who will enter information.Specify that it is editable by anyone with the link.Upload an xlsx spreadsheet to drive (it was created using pandas to_excel).
