# Google Sheets

## Authentication

Follow the steps below to create a service account for your Google Cloud project and share your Google sheet through the \*\*\*\* service account key.

### Create a service account key

Follow the steps below:

1. Enable the [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com) of your Google Cloud project.
2. Select **APIs & Services** > **Credentials** from the left panel.
3. Click **+ CREAT CREDENTIALS** > **Service account** to create a new service account.
4. Get a service account key:
   1. Click the **Email** of the service account.
   2. Click **KEYS** > **ADD KEY** > **Create new key**.
   3. Select **JSON** as the key type.
   4. Click **CREATE** to download it.

{% hint style="success" %}
Now the service account key, in a JSON format, is downloaded to your device. Make sure to keep it somewhere safe.
{% endhint %}

### Share your Google sheet

Navigate back to to [Google Sheets](https://docs.google.com/spreadsheets), and follow the steps below to share your sheet through the \*\*\*\* service account key.

1. Open the JSON file of the key.
2. Copy the value of `client_email`, which is an identity used for access management of your sheet.
3. Click **Share** at the top right and paste the copied `client_email` value to add a member with access.
4. Select **Editor** as the role and click **Send**.

{% hint style="success" %}
When you see the notification **Access updated**, you have authorized this service account to edit your sheet.
{% endhint %}

## Connect Google Sheets to Lowcoder

Follow the steps below:

1. Click **Data Sources** on Lowcoder homepage.
2. Click **New Data Source** on the top right. Note that this permission is restricted to workspace admins and developers.
3. Select **Database** > **Google Sheets** as the type.
4. Set its name and paste the whole content in the JSON flie of the key to **Service Account**.
5. Click **Save**, and you can check it in your data source library later.
6. To access and manipulate data in your app, you can fill in the **Spreadsheet** id and **Sheet Name** in a query editor as follows.

   The available methods are **Read Data**, **Append Row**, **Update Row**, and **Clear Row**.

## Demo

{% embed url="<https://demos.lowcoder.cloud/demo/clzmujgro01mhgumtrlpvvdal>" %}


---

# Agent Instructions: Querying This Documentation

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

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.lowcoder.cloud/lowcoder-documentation/connect-your-data/data-sources-in-lowcoder/apis-as-datasource/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.