> For the complete documentation index, see [llms.txt](https://support.suptask.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.suptask.com/integrations-automations-and-workflows/integration-guides/google-sheets.md).

# 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](/getting-started/contact-support.md) for more information and to get started.&#x20;
{% endhint %}