Auto C.E. v2

Auto C.E. is a python program used in the First Tech Challenge as a tool for organizing the engineering notebook in an online, automatic and integrating way with Google services. Code developed with the purpose of helping other teams to have more organization in engineering notebooks online.

Thanks for seeing my repository, I appreciate that:)

How it works

Our python program integrates with Google Docs, Drive and Sheets API to request some data from its sources.

First, we collect all data avaliable in the main database source DATABASE_SHEET inside the Google Spreadsheet based on the columns DATABASE_FIELDS_REPRESENTATION of the first sheet.

First, we collect all the data available from the main source of the database DATABASE_SHEET within Google Spreadsheet based on the DATABASE_FIELDS_REPRESENTATION columns in the first spreadsheet.

We back up the database, just to ensure that we don't lose data. But we ** can't change anything in the database, just read **

Based on this information, we generate many files using a copy of the template files TEMPLATE_FILES_ID and replacing each specified field DATABASE_FIELDS_REPRESENTATION with its correspondent in the database (based on the order, therefore the order in the database fields and in config.json is important to us)

THE FIRST THREE DATABASE COLUMNS MUST BE: CREATED_AT, AREA, DATE, but the names don't matter, just the order of those elements.

After generating these files, we put them in a specific Google Drive folder DEFAULT_FOLDER, and then we download them in PDF format on our computer (just to make a backup of the files)

Requirements

One account from Google (@gmail.com)
- You don't need have a Google Developer's Account
Python 3.7.x and pip installed on your machine (3.7.3 is recommended)
- Install it from Python
This repository installed on your computer
Follow steps on next session

Steps to get started

Clone this repository to your computer How?
Log-in on Google Cloud Plataform Here
Enter on GCP's Console Here
Create a project by clicking "Select project > NEW PROJECT"
- (This can be found on top left border of screen)
Select your recently created project by clicking "Select project"
Enable Google Drive API, Google Docs API, Google Sheets API
- (Just cick "Enable" for each link below)
- Google Docs API
- Google Sheets API
- Google Drive API
On Google Drive API, go to "Credentials > + CREATE CREDENTIALS" (middle-left border)
Select "OAuth client ID"
Select "CONFIGURE CONSENT SCREEN > External > Create"
- By selecting this options, your app will be public, but don't worry, your credentials don't will until you protect them
Follow steps from Google (information about your app)
- Skip "Scopes" section, we'll configure that later
After that, go back to "Credentials > + CREATE CREDENTIALS > OAuth client ID" (middle-left border)
For an application type, select "Desktop App"
Put a name on your new credential and create it
Click on your recently generated credentials
Click "Download JSON" on the top of your screen
Rename it to credentials.json
Download python library required for this project by executig this commands:
- pip install -r requirements.txt or pip3 install -r requirements.txt
Open file example_config.json
- Rename it to config.json
- Change some fields based on your configuration setup
Execute this on your command line:
- python autoce.py or python3 autoce.py

Docs for Google API and used libraries

License and credits