Automating-GSheets

Python script to update all child sheets data into Parent sheets data using GoogleAPIs

How to use:

Get authorized to use Google Sheets Api and Google Drive Api by using Google service Client
Save the file downloaded as "client_secrets.json"
create and activate virtual environment
install requirements.txt
run main.py

Live updation on the Parent Gsheet(Create an extention on spreadsheets)
Different no of columns and column names in the parent sheet as that of children
Each spreadsheet has one more than worksheet

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
LICENSE		LICENSE
README.md		README.md
auth.py		auth.py
main.py		main.py
requirements.txt		requirements.txt