Google Sheets

Google Sheets is a web-based service for creating and editing spreadsheets from Google.

Integrations and Connectors

AgilePoint NX integrates in these ways with Google Sheets:

  • Activities in Process Builder
  • Access tokens

Activities in Process Builder

You can use out-of-the-box activities for Google Sheets to execute actions in process-based apps.

An activity is a functional unit, or task, in a process-based app. Activities that integrate with a third-party system provide access to the API functionality for that system in a simple, point-and-click, form-entry format. This means that you can easily leverage APIs without writing code.

Figure: Process Activities for Google Sheets

Process Activities for Google Sheets

The following activities are available for Google Sheets:

  • Add Rows
  • Add Sheet In A Spreadsheet
  • Clear Cell Data
  • Copy Sheet
  • Create Spreadsheet
  • Delete Columns
  • Delete Rows
  • Delete Sheet
  • Insert Columns
  • Insert Rows
  • Read Rows
  • Update Cell Data

For more information, refer to the process activities for Google Sheets in Process Builder.

Access Tokens

You can create access tokens for Google Workspace.

An access token is a secure object that stores an endpoint (usually a URL) and authentication credentials to connect to a service or technology. Often this is an external or third-party service, like Salesforce or SharePoint, but access tokens can also connect to an AgilePoint NX enviornment, local database, or other types of technologies. Once an access token is created, app designers can simply select and reuse it, rather than entering the credentials each time they are needed.

For more information, refer to Access token for Google Workspace.

Figure: Google Workspace Access Token Configuration screen

Google Workspace Access Token Configuration screen

Related Topics

Google Sheets Documentation

Use these links to find third-party vendor documentation for Google Sheets:

About This Page

This page is a navigational feature that can help you find the most important information about this topic from one location. It centralizes access to information about the concept that may be found in different parts of the documentation, provides any videos that may be available for this topic, and facilitates search using synonyms or related terms. Use the links on this page to find the information that is the most relevant to your needs.

Keywords

Google Sheets, Google, Google Workspace, spreadsheet