FAQ Database Discussion Community

python + google drive: upload xlsx, convert to google sheet, get sharable link

The flow of my desired program is: Upload an xlsx spreadsheet to drive (it was created using pandas to_excel) Convert it to Google Sheets format Specify that it is editable by anyone with the link Get the link and share it with someone who will enter information Download the completed...

Create a folder (if not exists) on google drive and upload a file to it using Python script

So far I can upload file to the folder if it exists. I can't figure out a way to create one though. So if the folder does not exist, my script dies. import sys from pydrive.auth import GoogleAuth from pydrive.drive import GoogleDrive gpath = '2015' fname = 'Open Drive Replacements...