Get Google Api data¶
Getting data to access the table¶
Go to link;
Сopy the table to your Google drive account;
Save the spreadsheet ID.
Turn on the Google Sheets API¶
Follow the link api quickstart
Click “Enable the Google Sheets API”;
Click “DOWNLOAD CLIENT CONFIGURATION” and save the file credentials.json to your working directory.
Google Drive API authentication¶
Go to APIs Console and make your own project;
Search for ‘Google Drive API’, select the entry, and click ‘Enable’;
Select ‘Credentials’ from the left menu, click ‘Configure consent screen’. Enter app name and click ‘Save’;
Click ‘Create Credentials’, select ‘OAuth client ID’;
Once finished:
Select ‘Application type’ to be Web application;
Enter an appropriate name;
Input http://localhost:8080 for ‘Authorized JavaScript origins’;
Input http://localhost:8080/ for ‘Authorized redirect URIs’;
Click ‘Create’.
Click ‘Download JSON’ on the right side of Client ID to download client_secret_<really long ID>.json;
The downloaded file has all authentication information of your application. Rename the file to “client_secrets.json” and place it in your working directory.