Google Sheets (Tech Preview)

This connector was built with an OpenAPI specification.

Solution Details

Solution Type: Platform Connector
Author: Boomi
Published on: May 16, 2026
Last updated on: May 16, 2026

Get Started

Key Features

Read and write spreadsheet data programmatically through the Google Sheets API v4
Authenticate via OAuth2 Authorization Code Grant for interactive user-based access flows
Leverage JWT Bearer Token Grant with service accounts for automated server-to-server integrations
Manage spreadsheet properties, sheets, cells, and formatting through comprehensive API endpoint coverage
Synchronize structured data bidirectionally between Google Sheets and enterprise business applications

How it works

This connector integrates with the Google Sheets API v4, enabling automated reading and writing of spreadsheet data within Google Workspace environments. It supports both OAuth2 Authorization Code Grant and JWT Bearer Token Grant authentication methods, accommodating interactive and service-account-based workflows. Organizations can streamline data synchronization between Google Sheets and enterprise applications, eliminating manual data entry and reducing errors. Built from an OpenAPI specification, the connector provides comprehensive endpoint coverage for programmatic spreadsheet management at scale.

Applications Required