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'.
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'.
Next, for Application, select 'Toggl Track' to use the Toggl Airtable integration.
For Authorization you need to locate and enter your Toggl Track API token. This can be found in your Toggl Track profile.
Copy and paste your Toggl Track API key into Data Fetcher.
For Endpoint, select 'All time entries' in order to import all your Toggl Track entries into Airtable.
Enter a Name for your request, e.g. 'Import Toggle Track Data'. Then click 'Save & Continue'.
On the next screen, choose the Toggle Track Workspace you want to fetch the data from.
Select the Date Range you would like to import track data for, e.g. 'Last 7 Days'.
For Billable you can choose only billable time entries, non-billable time entries or everything.
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.
Choose the output table and view where your want to export your data into.
Click 'Save & Run'.
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'.
Data Fetcher will create any new fields in the output table and then import the data from Toggl to Airtable.
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'
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'.
A new tab will open where you can select a plan and enter your payment details to upgrade.
Return to the Data Fetcher extension and click 'I've done this'.
Under Schedule click '+ Authorize'.
On the next screen, you'll need to authorize which Airtable bases you want Data Fetcher to have access to.
By selecting 'All current and future bases in all current and future workspaces' you will avoid problems with unauthorized bases in the future.
Click 'Grant access'.
Back in Data Fetcher, Schedule this request will now be toggled on.
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.
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.
