Google Sheets

Use google_sheets in twins and put this configuration under seed_config.google_sheets. Google Sheets workbooks with named sheets, values, native spreadsheet/sheet properties and native batchUpdate requests.

Example seed

This is the complete Scenario request body for creating a Scenario. You can also import it with arga test-runner scenarios import --file scenario.json.

{
  "name": "Google Sheets eval fixture",
  "twins": [
    "google_sheets"
  ],
  "seed_config": {
    "google_sheets": {
      "sheets_gemini": {
        "enabled": true,
        "response_mode": "scenario",
        "responses": [
          {
            "prompt": "Sum the budget",
            "text": "The total is **200**."
          }
        ]
      },
      "spreadsheets": [
        {
          "title": "Launch plan",
          "sheets": [
            {
              "title": "Milestones",
              "properties": {
                "sheetId": 0,
                "gridProperties": {
                  "rowCount": 1000,
                  "columnCount": 26
                }
              },
              "values": [
                [
                  "Owner",
                  "Status"
                ],
                [
                  "Ada",
                  "Ready"
                ]
              ]
            }
          ],
          "requests": [
            {
              "updateDimensionProperties": {
                "range": {
                  "sheetId": 0,
                  "dimension": "COLUMNS",
                  "startIndex": 0,
                  "endIndex": 1
                },
                "properties": {
                  "pixelSize": 180
                },
                "fields": "pixelSize"
              }
            }
          ]
        }
      ]
    }
  }
}

Parameters

The following fields belong directly inside seed_config.google_sheets. Required nested fields are marked in their tables. Provider-native objects can contain service-specific fields beyond the representative record shapes below.

Parameter	Type	Description
`sheets_gemini`	`SheetsGeminiConfig`	Google Sheets assistant configuration.
`spreadsheets`	`object[]`	Spreadsheets fixtures in provider-native format.
`client_id`	`string`	Test OAuth client identifier.
`client_secret`	`string`	Test OAuth client secret.
`redirect_uris`	`string[]`	Redirect uris fixtures in provider-native format.
`require_pkce`	`boolean`	Enable or set require pkce behavior.
`access_token_ttl_seconds`	`integer`	Access token ttl seconds, in seconds. Minimum: 1.
`authorization_code_ttl_seconds`	`integer`	Authorization code ttl seconds, in seconds. Minimum: 1.
`oidc_issuer`	`string`	Oidc issuer.
`base_time`	`string`	Reference clock for repeatable fixtures. Omit to use the current clock.
`principals`	`SeedPrincipal[]`	Shared Google file identities and their permission IDs.
`tokens`	`SeedToken[]`	Test credentials, identity assignments, and permission scopes.
`docs_gemini`	`DocsGeminiConfig`	Google Docs writing-assistant configuration.
`connected_sheets`	`ConnectedSheetsConfig`	Connected Sheets data-source fixtures.

Seeding behavior

Values are entered with USER_ENTERED, so formulas are evaluated. Native requests run after convenience values. Use explicit sheet IDs in sheets[].properties.sheetId when later requests refer to those IDs. Provision this API independently; selected Google file siblings share state within the same Twin Run.

Resource fields

These tables describe the record shapes used by the example. Keep native field names and casing. Map keys such as property names, IDs, and metadata keys are supplied by your fixture.

`spreadsheets[]`

Parameter	Type	Description
`title`	`string`	Human-readable name.
`sheets`	`object[]`	Sheets fixtures in provider-native format.
`requests`	`object[]`	Requests fixtures in provider-native format.
`properties`	`object`	Properties.
`permissions`	`object[]`	Permissions fixtures in provider-native format.

`spreadsheets[].sheets[]`

Parameter	Type	Description
`title`	`string`	Human-readable name.
`properties`	`object`	Properties.
`values`	`string[][]`	Values fixtures in provider-native format.

`spreadsheets[].requests[]`

Parameter	Type	Description
`updateDimensionProperties`	`object`	UpdateDimensionProperties.

Typed configuration objects

Named object types in the parameter table use these fields.

ConnectedSheetsConfig

Parameter	Type	Description
`results`	`DataSourceResult[]`	Results fixtures in provider-native format.
`refresh_delay_ms`	`integer`	Refresh delay ms. Minimum: 0. Maximum: 600000.
`delegated_access_enabled`	`boolean`	Enable or set delegated access enabled behavior.
`delegated_access_user_ids`	`string[]`	Delegated access user ids fixtures in provider-native format.

DataSourceResult

Parameter	Type	Description
`spec`	`object`	Required. Spec.
`parameters`	`object`	Parameters.
`columns`	`string[]`	Columns fixtures in provider-native format.
`rows`	`any[][]`	Rows fixtures in provider-native format.
`allowed_user_ids`	`string[] or null`	Allowed user ids.
`error_code`	`string or null`	Error code.
`error_message`	`string`	Error message.

DocsGeminiConfig

Parameter	Type	Description
`enabled`	`boolean`	Enable or set enabled behavior.
`response_mode`	`"scenario" / "live"`	Response mode.
`responses`	`GeminiResponse[]`	Responses fixtures in provider-native format. Maximum entries: 250.
`delay_ms`	`integer`	Delay ms. Minimum: 0. Maximum: 30000.

GeminiResponse

Parameter	Type	Description
`document_id`	`string or null`	Document id.
`tab_id`	`string or null`	Tab id.
`prompt`	`string`	Required. Prompt. Minimum length: 1. Maximum length: 20000.
`text`	`string`	Required. Text content. Minimum length: 1. Maximum length: 200000.
`action`	`"answer" / "insert" / "replace"`	Action.

SeedPrincipal

Parameter	Type	Description
`user_id`	`string`	Required. User id.
`display_name`	`string`	Required. Display name.
`email_address`	`string`	Required. Owner mailbox address.
`permission_id`	`string`	Required. Permission id.
`photo_link`	`string or null`	Photo link.
`account_type`	`"auto" / "workspace" / "consumer" / "service_account"`	Account type.
`organization_id`	`string or null`	Organization id.
`group_email_addresses`	`string[]`	Group email addresses fixtures in provider-native format.
`is_domain_admin`	`boolean`	Enable or set is domain admin behavior.

SeedToken

Parameter	Type	Description
`token`	`string`	Required. Token.
`user_id`	`string`	Required. User id.
`scopes`	`string[]`	Scopes fixtures in provider-native format.

SheetsGeminiConfig

Parameter	Type	Description
`enabled`	`boolean`	Enable or set enabled behavior.
`response_mode`	`"scenario" / "live"`	Response mode.
`responses`	`SheetsGeminiResponse[]`	Responses fixtures in provider-native format. Maximum entries: 250.
`delay_ms`	`integer`	Delay ms. Minimum: 0. Maximum: 30000.

SheetsGeminiResponse

Parameter	Type	Description
`spreadsheet_id`	`string or null`	Spreadsheet id.
`sheet_id`	`integer or null`	Sheet id.
`prompt`	`string`	Required. Prompt. Minimum length: 1. Maximum length: 20000.
`text`	`string`	Required. Text content. Minimum length: 1. Maximum length: 50000.
`formula`	`string or null`	Formula.
`table`	`any[][] or null`	Table.
`action`	`SheetsGeminiAction or null`	Action.

SheetsGeminiAction

Parameter	Type	Description
`title`	`string`	Required. Human-readable name. Minimum length: 1. Maximum length: 200.
`description`	`string`	Required. Description. Minimum length: 1. Maximum length: 5000.
`requests`	`object[]`	Required. Requests fixtures in provider-native format. Minimum entries: 1. Maximum entries: 100.

API coverage and limitations

Twin name: google_sheets CLI quickstart: Use the Google Workspace CLI with Arga twins Supports

Google Sheets v4 spreadsheet creation and reads, A1 values get/update/append/clear and batch methods, sheet mutation batches, formulas, formatting, and developer metadata.
A Sheets v4 Discovery document rewritten to the provisioned twin URL.
Deterministic spreadsheet content with auth, ACL, failure, rate-limit, and reset behavior.
A browsable Sheets-style home and spreadsheet editor with blank-spreadsheet creation, editable cells, a formula bar, sheet tabs, autosave, sharing, and CSV, XLSX, and PDF export.
The preset spreadsheet ID google-sheets-launch-plan, which matches the corresponding file metadata in the default Drive twin.

Known limitations

This provision contains the Sheets API and editor UI only. Provision google_drive for Drive metadata, google_docs for document editing, and google_workspace for People, Workspace Events, Apps Script, and Pub/Sub.
The editor focuses on common grid workflows. It does not model charts, pivot-table editors, macros, or real-time multi-user cursors.

Provision

arga twin-runs create --twins google_sheets --ttl 60 --wait

MCP tools: get_twin_catalog, provision_twins, start_url_validation, get_validation_results. See Scenario seeding for saving, provisioning, and resetting fixtures.

Get started

Digital twins

Tests

Setup

Integrations

Resources

Google Sheets

Example seed

Parameters

Seeding behavior

Resource fields

`spreadsheets[]`

`spreadsheets[].sheets[]`

`spreadsheets[].requests[]`

Typed configuration objects

ConnectedSheetsConfig

DataSourceResult

DocsGeminiConfig

GeminiResponse

SeedPrincipal

SeedToken

SheetsGeminiConfig

SheetsGeminiResponse

SheetsGeminiAction

API coverage and limitations

​Example seed

​Parameters

​Seeding behavior

​Resource fields

​spreadsheets[]

​spreadsheets[].sheets[]

​spreadsheets[].requests[]

​Typed configuration objects

​ConnectedSheetsConfig

​DataSourceResult

​DocsGeminiConfig

​GeminiResponse

​SeedPrincipal

​SeedToken

​SheetsGeminiConfig

​SheetsGeminiResponse

​SheetsGeminiAction

​API coverage and limitations

Example seed

Parameters

Seeding behavior

Resource fields

`spreadsheets[]`

`spreadsheets[].sheets[]`

`spreadsheets[].requests[]`

Typed configuration objects

ConnectedSheetsConfig

DataSourceResult

DocsGeminiConfig

GeminiResponse

SeedPrincipal

SeedToken

SheetsGeminiConfig

SheetsGeminiResponse

SheetsGeminiAction

API coverage and limitations