Suptask
Suptask Web AppSignup for FREE
  • Welcome
  • Getting Started
    • Install Suptask
      • Slack permission scopes
      • Invite the Suptask App
    • Your first Inbox & Form
    • Ticket submission
    • Manage and Reply on tickets
    • Key concepts
    • User Guides
      • Ticketing as an Agent
      • Ticketing as a User
      • Rollout and Onboarding guide
    • FAQ & Troubleshooting
    • Contact Support
    • Videos
  • Setup & Configure
    • Inboxes
      • Inboxes
      • Users and Agents in the same channel
      • Service Level Agreements (SLA)
      • Agent Work Hours
      • Automatically create tickets from new messages
      • Migrate to the new generation
    • Forms & Fields
      • Forms
      • Custom Fields
      • Default Fields
      • Custom Statuses
      • Tags
      • Using the Organization field
    • Users & Permissions
    • Slack External Connections
    • Multiple Slack Workspaces
      • Multiple Workspaces & Slack Community
      • Enterprise Grid
    • Branding & White-labeling
    • Language & Translations
  • Working with tickets
    • For Agents: who respond and manage tickets
      • Overview and manage tickets as an Agent
      • Responding to tickets
      • Move or Escalate to another Inbox
      • Submit tickets on behalf of a user
      • Request and manage Approvals
      • Customer Satisfaction Score (CSAT)
      • Templated answers with Canned Replies
      • AI Assistant
      • Followers
      • Delete tickets
    • For Users: who submit tickets
      • How to submit a ticket
      • Overview your tickets as a user
    • Overview & Analytics
      • Overview and track tickets
      • Dashboard
      • Reports
    • Essentials for Your daily work
      • Tickets Summary Notifications
      • Setup one-click emoji reactions
      • How to search for tickets
      • Display Suptask in Slack
  • Integrations, Automations & Workflows
    • Introduction to Integrations
    • List of integrations
    • Integration guides
      • Slack Workflows
      • WhatsApp
      • JIRA Software
      • Zendesk
      • ClickUp
      • Notion
      • Google Sheets
      • Suptask API
      • WebHooks
      • Export API
      • Integrate with other Slack Apps
      • External issue & ticketing systems
        • Create tickets from Suptask to GitLab
        • Create tickets from Suptask to GitHub
        • Create tickets from Suptask to JIRA
    • Email-to-Slack Ticketing
      • Email-to-Slack Ticketing
      • Gmail & Google Workspaces
      • Microsoft Outlook
      • AI Email routing
    • On-call rotation
    • Automations in Suptask
  • Account Management
    • Account Settings
    • Subscription & Billing
      • Subscription & Billing
      • Integrations billing
      • Limitations in the Free plan
Powered by GitBook
On this page
  • Requirements
  • Example of how it works
  • How to get started

Was this helpful?

Export as PDF
  1. Integrations, Automations & Workflows
  2. Integration guides

Google Sheets

How to integrate with Google Sheets

PreviousNotionNextSuptask API

Last updated 3 months ago

Was this helpful?

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

  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:

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.

  1. Find the policy with the ID iam.disableServiceAccountKeyCreation

  2. Change it to Inactive

Enable the APIs required by Google Sheet

  1. Search for these two APIs separately:

    1. Google Sheets API

    2. Google Drive API

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

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

  3. Share the required information with your Suptask Integrations Specialist (SIS).

    1. Google sheets link and name

On certain Cloud accounts, the creation of API keys for Service Account is disabled. You will need to enable this from the

Open the

Open the in your Google Cloud account

Follow the steps in the

The retrieved from your API Key in the Service Account

Contact for more information and to get started.

https://console.cloud.google.com
https://developers.google.com/workspace/guides/create-credentials#service-account
https://cloud.google.com/iam/docs/service-accounts-create?hl=en#creating
Organization Policy Service.
Organization Policies
API library
Suptask Support
Requirements
JSON file