✨ Instagram integration is live! Tutorial

How to Import Toggl Track Data to Airtable

May 30, 2022Rosie Threlfall

In this how-to guide, we'll import Toggl track data into Airtable using Data Fetcher. Data Fetcher is an Airtable extension that allows you to fetch data from another application into Airtable without code.

We'll locate your Toggl API Key in order to sync the data from your workspace into Airtable. Finally, we'll schedule the Toggl Airtable integration to run automatically.

Install Data Fetcher

Install Data Fetcher from the Airtable marketplace. You can now sign up for a free Data Fetcher account by entering your name, email address and password and clicking 'Sign up for free'. 

Group 1Data Fetcher Sign Up .png

Import Toggl Track Data to Airtable

By creating requests in Data Fetcher, you can import data to or send data from an Airtable base. You can create multiple Data Fetcher requests to the same Airtable base.

On the home screen of the Data Fetcher app, click 'Create your first request'.

click-create-your-first-request.png

Next, for Application, select 'Toggl Track' to use the Toggl Airtable integration.

toggle-track-app.png

For Authorization you need to locate and enter your Toggl Track API token. This can be found in your Toggl Track profile.

Find your toggle track api key

Copy and paste your Toggl Track API key into Data Fetcher.

Toggle Track api code in Data Fetcher

For Endpoint, select 'All time entries' in order to import all your Toggl Track entries into Airtable.

Toggle Track endpoint

Enter a Name for your request, e.g. 'Import Toggle Track Data'. Then click 'Save & Continue'.

toggle-track-import-settings.png

On the next screen, choose the Toggle Track Workspace you want to fetch the data from.

toggle-track-workspace.png

Select the Date Range you would like to import track data for, e.g. 'Last 7 Days'.

toggle-track-date.png

For Billable you can choose only billable time entries, non-billable time entries or everything.

toggle-track-billable.png

There are optional steps under More options for this Toggl Track endpoint. You can Import only time entries for particular Clients, import only time entries for particular Projects, import only time entries for particular Tags or import only time entries for particular Users.

Toggl Track more options for Airtable

Choose the output table and view where your want to export your data into.

Toggl Track output table in Airtable

Click 'Save & Run'.

toggl-track-export.png

The Toggl Airtable integration will run and the Response field mapping window will open. This is where you specify which fields to import from Toggl and how they should map to your output table. For each Toggl field, you can either import or filter it. You can set whether to map each field to an existing Airtable field or create a new one.

You can filter all fields and type in the 'find fields' search bar to find your required fields. For this example, we will import 'Id' 'Description', 'Duration', 'User', Client', 'Project'.

Make sure you import the 'Id' field, as we will use this to ensure the data is kept in sync with any changes in Toggl. 

Once you have selected your fields, click 'Save & Run'.

toggl-response-field.png

Data Fetcher will create any new fields in the output table and then import the data from Toggl to Airtable.

Toggl Airtable table data

We'll also need to ensure Data Fetcher can match up items in Toggl with records in Airtable and check all data is syncing correctly. To do this, click 'Advanced settings' to open the advanced output settings. Then for Update Based on Field, select 'Id'. 

Click 'Save'

toggl-Id.png

Automatic Toggl Airtable Integration

By following these steps we would currently have to manually run the request to import the data every time from Toggl. We can use Data Fetcher's scheduled Toggl Airtable integration to automatically update the prices every 15 minutes/ hour/ day etc.

In Data Fetcher, scroll to Schedule and click 'Upgrade'.

Group 1(8).png

A new tab will open where you can select a plan and enter your payment details to upgrade.

Screenshot 2021-12-29 at 10.25.19.png

Return to the Data Fetcher extension and click 'I've done this'.

Group 1(9).png

Click 'Add API key' in order to add your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

Group 1(10).png

Enable Schedule this request.

Group 1(12).png

Select how often you want the Toggl Airtable integration to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run on the schedule and import track data from Toggl automatically.

Group 11(2).png

What is Toggl Track?

Toggl Track is a time-tracking software service that allows you to track a range of activities. You can gain access to detailed insights in order to help optimize your workflow by identifying specific areas for improvement. 

Why Import Toggl Track to Airtable?

By importing data from Toggl Track into Airtable you are able to combine data from other applications and use this for doing tasks such as creating invoices, organizing payroll, managing projects etc.

Other Recent Posts

Get a Favicon from a Website in Airtable

Get a Favicon from a Website in Airtable

Oct 27, 2022

Rosie Threlfall

Icon