Google Sheets

The Google Sheets connector is a Palantir-provided driver for Google Sheets.

To create a new Google Sheets source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Google Sheets-specific configuration and networking. For the complete property reference, see the official Google Sheets driver documentation ↗.

Supported capabilities

CapabilityStatus
Exploration🟢 Generally available
Batch syncs🟢 Generally available
Incremental🟢 Generally available

Configuration

The properties below are mandatory or recommended.

PropertyRequired?DescriptionDefault
InitiateOAuth ↗RecommendedSpecifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.REFRESH
OAuthClientId ↗RecommendedSpecifies the client ID that was assigned when the custom OAuth application was created. This ID registers the custom application with the OAuth authorization server.—
OAuthClientSecret ↗RecommendedSpecifies the client secret that was assigned when the custom OAuth application was created. This secret registers the custom application with the OAuth authorization server.—

Networking

The table below lists the domains that the source must access to run.

For Foundry worker connections, add an egress policy for each domain.

If the domains are on another network and you use agent proxy egress policies (preferred) or an agent worker (not recommended), the agent must be able to reach them. The systems on those domains must also allow connections from the agent. Learn more about agent networking.

DomainRequired
accounts.google.comAlways. Required for OAuth
www.googleapis.comAlways