In order to be able to use the Google Sheets API you need to be authenticated. To determine your authentication the APIs request a Token that proves who is trying to use the services and if that configuration has permissions to access the requested API.

Google has different types of authentication. You can use a service account or you can use a Google ID token where you have your Users logging in. You can check more information on the google documentation here.

On forge you have already Google Authentication Core and Google Authentication Management that allows you to do an Google Id token authentication. You can start by configure the Google Authentication Core  and create and configure your app in the Google Authentication Management.

On the Google Authentication Management, please add the Sheets API scopes. 

After having those configurations you're ready to use the Google Sheets integration. You'll need to use the Token that is generated. You can use the actions provided on the Google Authentication Core or provide the token yourself with other authentication methods.

Useful Actions:

• AddDataToSheet - Add data to an existing spreadsheet. You can edit values in a sheet or even add new sheets. Allows for a batch update of information;
• CreateNewSheet - Add a New sheet (or update) to a spreadsheet;
• CreateNewSpreadsheet - Creates a new spreadsheet;
• DeleteSheet - Deletes a sheet in a spreadsheet;
• GetSpreadSheetDetail - Get all the spreadsheet details: the metadata, formatting, sheets data etc.;
• GetValueByRange - Get a set of values for a defined range. The range follows the A1 notation. More info here.