With Sheetgo, you can connect your Freshdesk account directly to Google Sheets to automatically import ticket data, customer interactions, agents’ performance metrics, and service response times. This integration helps support teams monitor key metrics in real time without needing to manually export reports. Automating Freshdesk data into a spreadsheet simplifies performance tracking and helps identify patterns to improve customer satisfaction and team productivity.
Prerequisites
- A verified Freshdesk account.
- Your Freshdesk subdomain (e.g., yourcompany from https://yourcompany.freshdesk.com).
- A valid Freshdesk API Key obtained from your Profile Settings.
- Access to the official Freshdesk API Documentation: https://developers.freshdesk.com/api/.
- A Sheetgo account linked with the same email used for Freshdesk.
Step 1: Identify the Required API Endpoint
To begin, go to the Freshdesk API Documentation linked in the Prerequisites. Identify which endpoint you need based on the data you wish to retrieve. For example, to pull ticket information, you would use the GET /api/v2/tickets endpoint. Other endpoints include contacts, companies, or conversations. Make sure to review the available query parameters such as per_page or updated_since to control pagination and filtering.
Step 2: Generate API Credentials
Log in to your Freshdesk account and click your profile picture in the top-right corner. Select Profile Settings, then locate and click View API Key. Copy the API key that appears — this acts as your authentication credential. Store it safely since you will need it to authorize your GET requests within Sheetgo. Freshdesk uses Basic authentication, which requires encoding your API key as API_KEY:X (where X is a placeholder) and then Base64 encoding the full string if necessary.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Open Sheetgo, create a new workflow, and choose HTTP Request as the data source. Enter the Freshdesk suitable API endpoint you identified earlier. Then, insert the following Header JSON structure in the configuration field:
{
"Authorization": "Basic YOUR_BASE64_ENCODED_API_KEY",
"Content-Type": "application/json",
"@pagination": {
"type": "page",
"page_param": "page",
"per_page_param": "per_page"
}
}This configuration ensures Sheetgo can automatically fetch multiple pages of ticket data using pagination parameters supported by the Freshdesk API.
Step 5: Choose the Destination Spreadsheet
Next, select a Google Sheet where the data will be imported. You can create a new spreadsheet or select an existing one. Each time your Sheetgo workflow runs, the data from Freshdesk will automatically populate or update this file, allowing for centralized, real-time customer support tracking.
Step 6: Execute the Sheetgo Connection
Finally, click Run to execute your workflow. Sheetgo will send a GET request to Freshdesk and retrieve the ticket data into your chosen spreadsheet. Once data is successfully loaded, you can schedule automatic refreshes within Sheetgo to update your Freshdesk reports hourly, daily, or weekly—ensuring your support dashboards always reflect the latest customer service activity.