Google Sheets

How to integrate with Google Sheets

Integrations is a part of the Custom plan. Additional cost might apply.

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

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

2. Select Add Key and Create new key

3. Select JSON and proceed by pressing Create.

4. The JSON file will be downloaded to your local computer.

This JSON file will be shared with your Suptask Integrations Specialist (SIS) contact when setting up the integration in Suptask.

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.

1. Open the Organization Policies
2. Find the policy with the ID iam.disableServiceAccountKeyCreation

3. Change it to Inactive

Enable the APIs required by Google Sheet

1. Open the API 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.

---

Example of how it works

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

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
2. Create your Google Sheets document

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).

   1. Google sheets link and name

   2. The JSON file retrieved from your API Key in the Service Account

Contact Suptask Support for more information and to get started.