Read and Edit Spreadsheet Via local Python interface (automized)
GoogleSpreadsheet, Interfacing with python
GENERAL Instructions
#1 . Enabling Google Drive API on a Dev Project.(console.developer.google) #2 . Downloading the JSON for the CLient. #3 . Place the JSON in HOME folder (Working Directory of Python) #4 . Rename it as whatever file name you wish #5 . Creating Google spreadsheet. #6 . Get the CLIENT EMAIL ID from ADMIN&I credentials window, under console. #7 . Share the gspreadsheet with the client email. #8 . Using python ide run the code.