# Google Sheets

{% hint style="warning" %}
Integrations is a part of the Custom plan. Additional cost might apply.  
{% endhint %}

Google Sheets integration provides flexible tools for organizing ticket data, creating reports, and automating workflows. It enables centralized tracking and real-time updates, helping teams analyze ticket metrics with ease.

**Use Cases with Suptask:**

* Automatically log tickets and ticket information.
* Generate charts and dashboards for monitoring and performance reporting.
* Analyze ticket trends to optimize support processes.

***

### Requirements

You need a Google Cloud Project and a Google Service Account account in order to set up the integration. 

#### Create a new Google Cloud Project

1. Navigate to [https://console.cloud.google.com](https://console.cloud.google.com/) 
2. Open the project dropdown in the top navigation menu and select **New Project**
3. Select the location of this project and give it a **name** e.g "Suptask integration"
4. **Create** the project and make sure it is selected from the top navigation menu.

#### Create a new Service Account

Official documentations from Google can be found here:

* <https://developers.google.com/workspace/guides/create-credentials#service-account>
* <https://cloud.google.com/iam/docs/service-accounts-create?hl=en#creating>

Retrieve the integration credentials:

1. Open the newly created Service Account, navigate to the Service Accounts section and select the Keys tab&#x20;
2. Select Add Key and **Create new key**
3. Select **JSON** and proceed by pressing Create.&#x20;
4. The JSON file will be downloaded to your local computer. &#x20;

{% hint style="info" %}
This JSON file will be shared with your Suptask Integrations Specialist (SIS) contact when setting up the integration in Suptask.
{% endhint %}

{% hint style="warning" %}
On certain Cloud accounts, the creation of API keys for Service Account is disabled. You will need to enable this from the [Organization Policy Service.](https://cloud.google.com/resource-manager/docs/organization-policy/creating-managing-policies?hl=en\&authuser=1#viewing_organization_policies)

1. Open the [**Organization Policies** ](https://console.cloud.google.com/iam-admin/orgpolicies/list)
2. Find the policy with the ID *iam.disableServiceAccountKeyCreation*
3. Change it to **Inactive**
   {% endhint %}

#### Enable the APIs required by Google Sheet

1. Open the [API library](https://console.cloud.google.com/apis/library) in your Google Cloud account
2. Search for these two APIs separately:
   1. Google Sheets API
   2. Google Drive API
3. Enable them both.&#x20;

***

### Example of how it works&#x20;

This integration can be customized to your needs where certain fields and syncing options can be adjusted.&#x20;

Here is an example of how this integration can work:

1. Ticket is created in Suptask
2. Suptask automatically pushes the ticket with all its options to the Google Sheet, where each field of the ticket receives its own column.

***

### How to get started

The Google Sheets integration is setup and enabled together with the Suptask Integrations Specialists (SIS).

1. Follow the steps in the [Requirements](#requirements)&#x20;
2. Create your **Google Sheets document**&#x20;
3. Set up the columns you would like to have in your Google Sheets document. For example:
   1. Ticket ID
   2. Description
   3. Priority
   4. etc.
4. Share the required information with your Suptask Integrations Specialist (SIS).&#x20;
   1. Google sheets link and name
   2. The[ JSON file](#create-a-new-service-account) retrieved from your API Key in the Service Account

{% hint style="info" %}
Contact [Suptask Support](https://support.suptask.com/getting-started/contact-support) for more information and to get started.&#x20;
{% endhint %}


---

# 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://support.suptask.com/integrations-automations-and-workflows/integration-guides/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.