Import Toggl Data to Google Sheets

In this guide, we’ll walk through how to pull time tracking data from the Toggl API directly into Google Sheets, using the API Connector add-on for Sheets. We'll first get an API key from Toggl, and then set up a request to pull in your time tracking stats to your spreadsheet.

Contents

• Before You Begin
• Part 1: Get Your Toggl API Key
• Part 2: Get Your Workspace ID
• Part 3: Pull Toggl API Data into Sheets
• Part 4: Create a Custom Request
• Part 5: Handle Pagination
• Part 6: Toggl's V2 API
• Part 7: API Documentation

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Toggl API Key

1. Log into your Toggl track account on Toggl.com (or navigate to https://track.toggl.com/timer directly)
2. From the main dashboard, scroll down and click Profile > Profile settings
   
3. Scroll down the page until you see a section called "API Token". Copy this to your clipboard.
   
4. One last step: Because the Toggl API requires Basic Authentication, we need to encode our authentication info to base 64. Enter your your credentials in the format YOUR_API_KEY:api_token into this form, where you substitute in your own api key where it says YOUR_API_KEY, and follow it with a colon and then the word 'api_token' without quotes. Your encoded credentials will appear underneath.
   
   The encoding script runs in your browser, and none of your credentials are seen or stored by this site.
   Base64 Encode

    

Part 2: Get Your Workspace ID

We'll need your workspace ID for your API requests, so let's get that now. You can retrieve your workspace ID by clicking Reports from the dashboard and checking the URL. Your workspace ID is the numeric identifier after /summary.

That's it, now we can move on to fetching data.

Part 3: Pull Toggl Data into Sheets

This section shows how to use API Connector's built-in integration for Toggle.

1. Select Toggl from the drop-down list of applications
   
2. Under Authorization, enter your encoded API key with the word Basic in front of it.
   
3. Select an endpoint. For this example, we'll fetch a detailed time entries report
   
4. Under Path parameters, enter your workspace ID
5. Under Body parameters, fill in your end_date and start_date for your report. Optionally fill in any other parameters to filter or sort your data.
6. Choose a destination sheet, name your request, and hit Run to see the response data in your sheet.
   

Part 4: Create a Custom Request

Alternatively, you can run your own custom requests instead of using API Connector’s pre-built integration, using any of the data points shown in the API documentation. Here's an example request setup. Substitute in your own workspace ID, email address, and the encoded key you got above.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: POST
   • Request URL: https://api.track.toggl.com/reports/api/v3/workspace/your_workspace_id/search/time_entries
   • Headers:
     • Authorization: Basic your_encoded_key
     • Content-Type: application/json
   • Request body: {"start_date":"2023-01-01","end_date":"2023-03-31","first_row_number":1}
3. Create a new tab and click Set current to use that tab as your data destination.
4. Under Output options, switch to Grid mode (this makes the output easier to read).
5. Name your request and click Run. A moment later you’ll see your time stats populate your Google Sheet.
6. You can additionally filter data by billing status, client ID, project ID, and so on, by applying any of the parameters shown in their documentation.

Part 5: Handle Pagination

By default, Toggl will return only 50 records at a time. To get more, set up pagination handling like this:

• Pagination type: offset-limit body
• Offset body parameter: first_row_number
• Limit body parameter: limit
• Limit value: 50
• Run until: choose when to stop fetching data
  

Part 6: Toggl's v2 API

An earlier version of this article focused on Toggl's v2 API, as it was initially the only API available. It's also a bit easier to configure requests for, since parameters are added to the URL instead of in the request body. As the v2 API is still accessible, and many users have already configured their requests for it, this section has been retained for reference.

v2 Example Request Configuration

As above, substitute in your own workspace ID, email address, and the encoded key you got above. The dates are optional but if you leave them out you'll get data only from the current week (the maximum time span is 1 year).

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://api.track.toggl.com/reports/api/v2/summary?workspace_id=your_workspace_id&user_agent=your_email_address&since=2023-01-01&until=2023-01-28
   • Headers:
     • Authorization: Basic your_encoded_key
3. Create a new tab and click Set current to use that tab as your data destination.
4. Under Output options, switch to Grid mode.
5. Name your request and click Run.
   

v2 Endpoint Examples

• Weekly report
  GET https://api.track.toggl.com/reports/api/v2/weekly?user_agent=your_email_address&workspace_id=your_workspace_id&since=2023-01-01&until=2023-01-28
  
• Detailed report
  GET https://api.track.toggl.com/reports/api/v2/details?user_agent=your_email_address&workspace_id=your_workspace_id&since=2023-01-01&until=2023-01-28

v2 Pagination

By default, Toggl returns only 50 records at a time for the reports endpoint. To get more you need to use the "page" parameter. In API Connector you can do this automatically with pagination handling, like this:

• Pagination: page parameter
• Page parameter: page
• Run until: choose when to stop fetching data

Part 6: API Documentation

Official documentation: https://developers.track.toggl.com/docs/

v2 API documentation: https://github.com/toggl/toggl_api_docs/blob/master/reports/detailed.md