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.