> For the complete documentation index, see [llms.txt](https://developer.kizen.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.kizen.com/docs/integrations-and-plugins/integrations/google-sheets/set-up-google-sheets-in-kizen.md).

# Set Up Google Sheets in Kizen

Learn how to configure the Google Sheets integration in Kizen to work with live Google Sheet data in Agentic Workflows.

{% hint style="success" %}
**Audience:** Admins, Developers, Solution Architects

**Purpose:** Explains how to connect Google Sheets to <code class="expression">space.vars.Kizen\_company\_name</code> for reading and writing live data to Google Sheets using <code class="expression">space.vars.automations</code>
{% endhint %}

## Overview

{% hint style="warning" %}
**Caution:** This setup reflects Kizen's default configuration. Your administrator may have customized your layout, so columns or navigation may appear differently. Trial accounts may have limited features.
{% endhint %}

Connect Google Sheets™ to <code class="expression">space.vars.Kizen\_company\_name</code> to use Google Sheets data in <code class="expression">space.vars.automations</code>.

***

## Before You Begin

To set up Google Sheets in <code class="expression">space.vars.Kizen\_company\_name</code>, you need:

* Any standard Google account with access to Google Sheets
* A <code class="expression">space.vars.Kizen\_company\_name</code> admin account

***

## Set Up Google Sheets in Kizen

To set up Google Sheets in <code class="expression">space.vars.Kizen\_company\_name</code>:

{% stepper %}
{% step %}

#### Go to the App Marketplace

In <code class="expression">space.vars.Kizen\_company\_name</code>, select **Platform** > **App Marketplace** from the global navigation.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2Fgssjgut2NeY3BQXr3smG%2Fglobal_platformappmarketplace.png?alt=media&amp;token=2f685c7c-69cb-4660-a3d4-981121607f6b" alt="The App Marketplace menu item under the Platform group in the global navigation" width="375"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}

#### Activate Google Sheets

In the App Marketplace, find the Google Sheets card, and select the slider to activate the integration.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2FdOsg1AHGpTj9mTgqPF9f%2Fgooglesheets_appoff_first.png?alt=media&amp;token=25ea8302-ebb7-4bbb-aaef-b4d8296b470f" alt="The Google Sheets card in the App Marketplace" width="375"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}

#### Edit the configuration

Select **Edit Configuration** on the Google Sheets card.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2FwsdEwgADdP85QPmO78Gi%2Fgooglesheets_appon_preauth.png?alt=media&amp;token=a4fca1ee-4546-43b0-aaa8-c4b986ebdc81" alt="The Edit Configuration link on the Google Sheets card in the App Marketplace" width="375"><figcaption></figcaption></figure></div>

The integration settings page appears.
{% endstep %}

{% step %}

#### Authorize Google Sheets

Switch to the **Authorization** tab in the integration settings, and select **Authorize App**.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2FZr6qeyTApT9HjZ0s0axb%2Fgooglesheets_authorizeapp_cropped.png?alt=media&amp;token=c9ed86b1-999b-46b9-b712-47847887d23b" alt="The Authorize App button in the Authorization settings of the integration" width="375"><figcaption></figcaption></figure></div>

The Google sign-in page appears.
{% endstep %}

{% step %}

#### Allow the integration to access your Google account

Sign into Google, and select **Allow** to connect <code class="expression">space.vars.Kizen\_company\_name</code> to Google Sheets.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2FPvr2PyD3ZOnFiH3cAxR8%2Fgooglesheets_auth03.png?alt=media&amp;token=bf87034b-4f44-40d2-b822-caf6107b15f1" alt="The Allow button to allow the integration to connect to Google Sheets" width="563"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}

#### Confirm the connection

Back in the authorization settings, check that you have authenticated successfully.

<div data-with-frame="true"><figure><img src="https://3898351136-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQd8ufpN7wkdnx7JtgoeZ%2Fuploads%2FT92EGoMFd1PIqQPmItn0%2Fgooglesheets_appauthorized_cropped.png?alt=media&amp;token=648ae76e-33ac-44b1-87a8-f6e84b5a1d30" alt="The connection confirmation in the Authorization settings of the integration" width="375"><figcaption></figcaption></figure></div>
{% endstep %}
{% endstepper %}

***

## What's Next

Continue to [Work with Google Sheets in Agentic Workflows](/docs/integrations-and-plugins/integrations/google-sheets/work-with-google-sheets-in-agentic-workflows.md) to learn how to read and write data to Google Sheets from <code class="expression">space.vars.Kizen\_company\_name</code>.

<details>

<summary><strong>Related Topics</strong></summary>

* [Google Sheets](/docs/integrations-and-plugins/integrations/google-sheets.md)
* [Work with Google Sheets in Agentic Workflows](/docs/integrations-and-plugins/integrations/google-sheets/work-with-google-sheets-in-agentic-workflows.md)
* [Troubleshoot Google Sheets](/docs/integrations-and-plugins/integrations/google-sheets/troubleshoot-google-sheets.md)

</details>

***

*Google Sheets™ is a trademark of Google LLC. Kizen's Google Sheets integration is not affiliated with, sponsored by, or endorsed by Google LLC.*


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://developer.kizen.com/docs/integrations-and-plugins/integrations/google-sheets/set-up-google-sheets-in-kizen.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.