How to Upload CSV into Google Spreadsheet on Google Drive ?

Libraries Required:

PyDrive is a wrapper library of google-api-python-client that simplifies many common Google Drive API tasks.

How do I use PyDrive ?

Step1:- Go to Google Developer Console.

Step2:-Click on Enable API and Services and Search for Google Drive API

Step3:-Click on Google Drive API and Enable it.

Step 4:-Click on OAuth Consent Screen and click External and Create

Step 5:- Put All Details like App Name and Email

Step 6:- Click on Save and Continue

Step 7:- Click on Add Users which you want to Grant Access.

Step 8:- After that Click on Credentials and click on OAuth client ID

Step 9:- Click on Application type and put your type accordingly

Step 10:- Put the URLS shown in image and click on Create.

Step 11:- After that Click on Download JSON and put that file in your working Directory of Python

Code:-

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store