Write to Google Spreadsheet and Customize the format - Click here Get all the folders in Google Drive - Click here A Google spreadsheet to list your output.A Google Drive folder that you want to track.It's inconvenient to list the uploaded folders one by one. I personally use this script right after uploading hundreds of files to GDrive for monitoring purposes. Upload Excel files to Google Drive: Part 1 and Part 2īefore proceeding with this tutorial, make sure you have read and understood my previous posts.
Split a huge Excel workbook into multiple files: Click here.This post is part of the Project Pigeon, a series of tutorials that covers using Python to automate the following tasks: To keep track of all your folders and files in Google Drive, you can run a Python script that automatically scrapes information of all the content uploaded in your account. curlgoogle file1 file2.txt file3.jpg etc.List your folders in Google Drive using Python python, analytics, pigeon, automation, code, work, Google APIs, demo We then make it executable chmod a+x curlgoogle allowing us to use it in an executable manner. Dan Ellis 2020 ''' import os,sys,json if sys.version='3': raw_input = lambda(x): input(x) #Owner information goes here!# name = 'curldata' client_id= ' ' client_secret=' ' # cmd1 = json.loads(os.popen('curl -d "client_id=%s&scope= " '%client_id).read()) str(raw_input('\n Enter %(user_code)s\n\n at %(verification_url)s \n\n Then hit Enter to continue.'%cmd1)) str(raw_input('(twice)')) cmd2 = json.loads(os.popen(('curl -d client_id=%s -d client_secret=%s -d device_code=%s -d grant_type=urn~~3Aietf~~3Aparams~~3Aoauth~~3Agrant-type~~3Adevice_code '%(client_id,client_secret,cmd1)).replace('~~','%')).read()) print(cmd2) # zip files cmd3 = os.popen('zip -r %s.zip %s'%(name,' '.join(sys.argv))).read print(cmd3) cmd4 = os.popen(''' curl -X POST -L \ -H "Authorization: Bearer %s" \ -F "metadata= type=application/json charset=UTF-8" \ -F \ " " '''%(cmd2,name,name)).read() print(cmd4) print('end') #!/usr/bin/python ''' A quick python script to automate curl->googledrive interfacing This should require nothing more than the system python version and curl.
It should require no new dependencies provided curl already exists on the system. We start by creating a new file with nano curlgoogle and enter the following code - remember to add your own personal auth token! Python 2.7 has been chosen as this is still the default python version on older systems, however the script below should also run for python 3. Here we can provide a group of files, it zips them up and then sends them to google drive. Now we know our commands work we can create an executable script to do all the work for us.
0 kommentar(er)
