WHAT IS THE PROJECT?

The application consists of searching for zigzag exchanges and adding it to a spreadsheet, making this loop once a day.

CONFIGURING THE ENVIRONMENT

1 - One step : program installation is packages

sudo su && apt-get update
apt-get upgrade && apt-get install python3
apt-get install python3-pip && apt-get install git
git clone https://github.com/devkakashi/zigzagtosheet/
cd zigzagtosheet && pip3 -r requirements.txt

2 - First step: Getting your credentials

.1 Go to the Google APIs Console.

.2 Create a new project.

.3 Click Enable API. Search for and enable the Google Drive API.

.4 Create credentials for a Web Server to access Application Data.

.5 Name the service account and grant it a Project Role of Editor.

.6 Download the JSON file.

.7 Copy the JSON file to your code directory and rename it to keyfile.json

3 - Two step: Sharing spreadsheet with app

.1 Ceate or import a spreadsheet named "book".

.2 Find the client_email inside keyfile.json. Back in your spreadsheet, click the Share button in the top right, and paste the client email into the People field to give it edit rights. Hit Send.

.2 If you skip this step, you’ll get a gspread.exceptions.SpreadsheetNotFound error when you try to access the spreadsheet from Python.

Starting the application

python3 app.py

Seeing the google spreadsheet

Custom settings

• You can change some settings in the code such as the size of the book to be taken, the name of the spreadsheet, the name of the keyfile, the settings are from line 11 to 17.

I freelance just call me on twitter DM @devkakashi

Image Credits