Google Sheets

The Google Sheets API is available for use in Form applications. With it, you can create and insert data into a Google spreadsheet.

Configuring a Profile

In the menu Tools > API you can create API profiles for use in your projects. This way, you will only need to provide your credentials once to use the API in your project.

See how to obtain the credentials needed to configure the profile.

When deploying your project, you will need to configure the API credentials in Prod, by accessing the API menu.

Google Sheets API

Name

Defines the name to identify the API profile. This name is unique and will be used to reference the API profile in your project’s applications.

Mode

The mode defines the availability of the Profile in Scriptcase.

Public - Users from all projects will be able to view and use the created profile.
Project - Users will be able to view and use the profile in the project where it was configured.
User - Only the user who created the profile will be able to view and use it in the applications.

Regardless of the mode used for creation, profiles can only be edited by users with administrator access in the project. See how to define user access levels in Scriptcase.

Gateway

Defines the API that will be used to create the profile.

Application name

Enter the application name defined in the fifth step of the credential acquisition tutorial.

OAuth JSON

Enter the content of the JSON file obtained at the end of the credential usage configuration.

Authentication code

This code will be generated by clicking the auth button.

When clicking the button, you will be redirected to the Google login screen, where you must enter the access credentials for the account where the API was configured.

After logging in, a code will be generated. Copy this code and enter it in the field.