Creating your credentials
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:
- 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.
- 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
9 - Click to Enable Google Sheets API10 - Click to Enable Google Drive API
Using credentials in a local environment
1 - After activating the APIs, click on the “Credentials” option
2 - Click on "CREATE CREDENTIALS" and then click on "OAuth Client ID" .
3 - Select the option “Computer App”
4 - - Enter the name and click on the “CREATE” button
5 - Download the JSON file
6 - In the creation of the API, inform in App name the name of the application created in google and in JSON OAUTH the JSON code that is in the downloaded file.
7 - Click on the “Auth Code” option to get the code generated by the Google API. You will be redirected to a page, copy the code, paste it in the Auth Code field and click the "Save" button.
Using credentials in an external environment
1 - To use your credentials in an external environment, go to the "CREATE CREDENTIALS" button again and select the option "Help me choose"
2 - Select the options:
- Select an API: Google Sheets API
- Check the option: User data.
- Click the NEXT button
3 - On the scopes screen, click on the button to “Add or remove scopes”
4 - Enable all extensions containing the API name: Google Drive API and Google Sheets API. Click the button to “Save and continue"
5 - 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
6 - 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:
7 - Then just download the JSON file credentials to be informed in the scriptcase API.
8 - In the creation of the API, inform in App name the name of the application created in google and in JSON OAUTH the JSON code that is in the downloaded file.
9 - Click on the “Auth Code” option to get the code generated by the Google API. You will be redirected to a page, copy the code, paste it in the Auth Code field and click the "Save" button.