Creating Your Credentials for the Google Sheets API

Creating Your Credentials for the Google Sheets API

Creating your credentials



1 - Log in with your Google account in the reserved area where you can configure Google APIs, from this URL: https://console.cloud.google.com/apis/library

2 - If you already have projects created, just click on the selected project and then click on NEW PROJECT. If you don't have any project created, just search for a new project and create a new project.



3 - Enter the name of the project and click CREATE




4 - After the project is created, you will be directed to the OAuth permission screen:


  1. You must first click on the select project so that the project you just created is selected, as indicated by number 1 in the photo.
  2. Choose the External option and click Create






5 -  When you click on Create in step 4, you will see the following screen, and you will need to provide the necessary information; after providing the mandatory data, at the end of the page click on Save and continue.




6 - On the next screen, click on save for the steps, and on the last one click on BACK TO DASHBOARD at the end of the page.




7 - Now, you will need to activate the Google Drive and Google Sheets APIs, so go to ENABLE APIS AND SERVICES and click on ACTIVE APIS AND SERVICES 



8 -  Look for Google Drive and Google Sheets APIs to enable




5 - Click to Enable Google Sheets API


6 - Click to Enable Google Drive API



Using credentials in a local environment


10 - After activating the APIs, click on the “Credentials” option





11 - On the next screen, under Select, an API, check if the Google Sheets API is selected; also select the User data option and click CONCLUDE.


11 - After following the previous step, you will see the following screen. Just click on the Credentials tab, click on the “Create Credentials” button and select the “OAuth Client ID” option







12 - Select the option “Computer App”

13 -  Enter the name and click on the “CREATE” button


14 -  Download the JSON file


15 -  Enter in the App name the name of the created application and the JSON OAUTH downloaded.



16 - Click on the “Auth Code” option to generate the code generated by the google API

          



Using credentials in an external environment


17 - To use your credentials in an external environment, go to the "CREATE CREDENTIALS" button again and select the option "Help me choose"




18 - Select the options:

  1.  Select an API: Google Sheets API
  2.  Check the option: User data.
  3.  Click the NEXT button


19 - On the scopes screen, click on the button to “Add or remove scopes”







20 -  Enable all extensions containing the API name: Google Drive API and Google Sheets API. Click the button to “Save and continue"




21 - In the next step, select the option: “Web application” and inform the name of the application.


NOTE: This name will be informed in the scriptcase API interface credentials






22 - In the Redirect URL option, click to add your URL then click on the “CREATE” button.
Click CONCLUDE to finish the process.



You need to add the full path.
Example for the production environment:




23 -  Then just download the JSON file credentials to be informed in the scriptcase API.



24 - Enter in App name the name of the created application and the JSON OAUTH downloaded.




25 - Click on the “Auth Code” option to generate the code generated by the google API







    • Related Articles

    • Security Module Two-Factor Authentication - Google Authenticator

      Google Authenticator generates 2-step verification codes on your smartphone. Two-Step Verification provides greater security for your account as it requires a second verification step at login. In addition to the password, you will need a code ...

    • Enabling Google Drive API on the Google Console

      This tutorial shows you how to create a project and enable the Google Drive API for a specific Google account, and obtain access credentials. 1) Log in with your Google account in the reserved area where you can configure Google APIs, from this ...

    • Creating your credentials in Mercado Pago

      Access the development panel of your applications. https://www.mercadopago.com.br/developers/panel 2. Enter creation settings. 3)  Enter the creation settings. * Application name: Name to refer to your application. * Type of payment to integrate: ...

    • Generating Credentials for Authentication with Twitter

      In this article, we will learn how to generate credentials (API Key and API Key Secret) for authentication and access to our project developed in ScriptCase through Twitter. Account Creation 1 - The first step is to create a Twitter account through ...

    • Getting Credentials on Braintree

      1-Access your Braintree Sandbox or Production account Log in to your Braintree account  To use the API it is necessary to have an account. 2 - Acesse o dashboard no menu Settings > API 3 - In the Private Key column, click on the View link to access ...