Toggl

Creating the data source

Toggl is a time tracking tool that lets you record and analyze the hours spent on projects and tasks. The Toggl data integration to the Data Warehouse built by Kondado gives you access to your time tracking data in your analytics cloud.

Adding the data source

Requirements

Follow the instructions below with a user who is a Workspace Administrator

Instructions

1) Log into your Toggl account, access your profile page at https://track.toggl.com/profile and copy your API Token

2) Log into your Kondado account, click to create a new Toggl data source and paste the API Token you obtained in step 1

Now just click SAVE and create your integrations to start receiving Toggl data in your Data Warehouse, Data Lake or spreadsheet

Pipelines

Relationship chart

Click to expand

Clients

Replication type: Full

Relationships:

wid → Workspaces > id

Clients registered in Toggl, one row per client, with name, the workspace it belongs to, archived flag and last-change date. Used to group projects by client.

Campo	Tipo
id	text	[en] Client ID
archived	boolean
at	timestamp	[en] When was the last update
name	text	[en] Name of the client
wid	text	[en] Workspace ID Workspaces > > id

Groups

Replication type: Full

Main object

Toggl user groups, one row per group, with name, the workspaces it belongs to and last-change date. Used to organize team members into sets.

Campo	Tipo
group_id	text	[en] Numeric ID of the group.
at	timestamp	[en] When was created/last modified
name	text	[en] Group name
workspaces	text	[en] List of group workspaces

toggl_groups_users

Users that make up each Toggl group; one row per group member, with identifier, name, avatar and join date. Related to the parent group by its identifier.

Campo	Tipo
group_id	text	[en] Numeric ID of the group.
users_avatar_url	text	[en] User avatar URL
users_joined	boolean
users_name	text
users_user_id	text

Projects

Replication type: Incremental

Parameters:

Read start date (Savepoint): Start date to replicate data

Relationships:

client_id → Clients > id
workspace_id → Workspaces > id

Main object

Toggl projects, one row per project, with name, associated client and workspace, status (active/private), color, billing, rate and currency, estimated and actual hours, dates and recurrence settings. It is the parent table of the recurring parameters.

Campo	Tipo
id	text	[en] Project ID
active	boolean	[en] Indicates if the project is active
actual_hours	float	[en] Actual hours spent on the project
actual_seconds	float	[en] Actual seconds spent on the project
at	timestamp	[en] Timestamp of last update
auto_estimates	boolean	[en] Indicates if auto estimates are enabled for the project
billable	boolean	[en] Indicates if the project is billable
client_id	text	[en] ID of the client associated with the project Clients > > id
color	text	[en] Color associated with the project
created_at	timestamp	[en] Project creation timestamp
currency	text	[en] Currency used for billing
estimated_hours	float	[en] Estimated hours for the project
estimated_seconds	float	[en] Estimated seconds for the project
fixed_fee	float	[en] Fixed fee for the project
is_private	boolean	[en] Indicates if the project is private
name	text	[en] Project name
rate	float	[en] Hourly rate for the project
rate_last_updated	timestamp	[en] Timestamp of the last update to the rate
recurring	boolean	[en] Indicates if the project is recurring
server_deleted_at	text	[en] Timestamp of when the project was deleted on the server
start_date	date	[en] Start date of the project
status	text	[en] Current status of the project
template	boolean	[en] Indicates if the project is a template
template_id	text	[en] Template ID of the project
workspace_id	text	[en] Project workspace ID Workspaces > > id

toggl_projects_recurring_parameters

Recurrence parameters of Toggl projects; one row per recurrence setting, with period, custom period, estimated seconds and start/end dates. Related to the parent project by its identifier.

Campo	Tipo
id	text	[en] Project ID
recurring_parameters_custom_period	text	[en] Custom recurring period
recurring_parameters_estimated_seconds	float	[en] Estimated seconds for recurring parameters
recurring_parameters_parameter_end_date	text	[en] End date for recurring parameters
recurring_parameters_parameter_start_date	date	[en] Start date for recurring parameters
recurring_parameters_period	text	[en] Recurring period type
recurring_parameters_project_start_date	date	[en] Project start date for recurring parameters

Projects: groups

Replication type: Full

Relationships:

group_id → Groups > group_id
pid → Projects > id
wid → Workspaces > id

Associations between projects and groups in Toggl, one row per link, relating the project, group and workspace identifiers. Indicates which groups have access to each project.

Campo	Tipo
id	text	[en] Refers to the unique identifier of the specific record.
group_id	text	[en] It's a unique identifier for the group. Groups > > group_id
pid	text	[en] It's the unique identifier of the project to which the group belongs. Projects > > id
wid	text	[en] Represents the unique identifier of the workspace where the project and the group are located. Workspaces > > id

Projects: users

Replication type: Full

Relationships:

user_id → Workspaces: users > id
project_id → Projects > id
group_id → Groups > group_id
workspace_id → Workspaces > id

Assignments of users to projects in Toggl, one row per user on a project, with user, project, group and workspace identifiers, manager flag, hourly rate, labour cost and last-change date.

Campo	Tipo
id	text	[en] Unique identifier of the project user
user_id	text	[en] Identifier of the user associated with this project Workspaces: users > > id
project_id	text	[en] Identifier of the associated project Projects > > id
group_id	text	[en] Identifier of the group this project user belongs to, if applicable Groups > > group_id
at	timestamp	[en] Timestamp of the last update to the project user
labour_cost	float	[en] Total labour cost for the user on this project
manager	boolean	[en] Indicates whether the user is a manager of the project
rate	float	[en] Hourly rate of the user for this project
rate_last_updated	timestamp	[en] Timestamp of the last update to the user's rate
workspace_id	text	[en] Identifier of the workspace this project user belongs to Workspaces > > id

Campo	Tipo
id	text	[en] TAG ID
at	timestamp	[en] IWhen was created/last modified
name	text	[en] TAG name
workspace_id	text	[en] TAG Workspace Workspaces > > id

Tasks

Replication type: Incremental

Parameters:

Read start date (Savepoint): Start date to replicate data

Relationships:

project_id → Projects > id
user_id → Workspaces: users > id
workspace_id → Workspaces > id

Toggl tasks, one row per task, with name, associated project and workspace, assigned user, status (active/recurring), estimated seconds and already tracked seconds, plus last-change date.

Campo	Tipo
id	text	[en] Unique identifier of the task
active	boolean	[en] Indicates whether the task is active
at	timestamp	[en] Timestamp of the last update to the task
estimated_seconds	float	[en] Estimated seconds for the task
name	text	[en] Name of the task
project_id	text	[en] Identifier of the project this task is associated with Projects > > id
recurring	boolean	[en] Indicates whether the task is recurring
tracked_seconds	float	[en] Total tracked seconds for the task
user_id	text	[en] Identifier of the user associated with this task Workspaces: users > > id
workspace_id	text	[en] Identifier of the workspace this task belongs to Workspaces > > id

Time entries

Replication type: Incremental with update window

Parameters:

Update window (days): How many days prior to the time entry start should records keep being updated
Read start date (Savepoint): Initial date to filter results (based on time entry start time)

Relationships:

project_id → Projects > id
tag_ids → Tags > id
task_id → Tasks > id
user_id → Workspaces: users > id
workspace_id → Workspaces > id

Toggl time entries, one row per tracked time record, with description, start, stop and duration in seconds, associated user, project, task, workspace and tags, billable flag, billable amount and hourly rate in cents. It is the core of tracked working hours in Toggl.

Campo	Tipo
id	text	[en] Unique identifier of the time entry
at	timestamp	[en] Timestamp indicating the last time the entry was updated
billable	boolean	[en] Indicates if the time entry is billable
billable_amount_in_cents	float	[en] The billable amount for the time entry in cents
currency	text	[en] Currency used for billing
description	text	[en] Description of the time entry
hourly_rate_in_cents	float	[en] Hourly rate for the time entry in cents
project_id	text	[en] Identifier of the project to which the time entry is associated Projects > > id
seconds	float	[en] Duration of the time entry in seconds
start	timestamp	[en] Start time of the time entry
stop	timestamp	[en] Stop time of the time entry
tag_ids	text	[en] List of tag identifiers associated with the time entry Tags > > id
task_id	text	[en] Identifier of the task to which the time entry is associated Tasks > > id
user_id	text	[en] Unique identifier of the user Workspaces: users > > id
username	text	[en] Name of the user
workspace_id	text	[en] Indicates the associated workspace for the given entry. Workspaces > > id

Workspaces

Replication type: Full

Toggl workspaces, one row per workspace, with name, organization, default currency and hourly rate, plan and subscription data, profile/premium, rounding rules and admin permissions. The workspace is the container of projects, clients, tasks and time entries.

Campo	Tipo
id	text	[en] Workspace ID
admin	boolean	[en] List of admins
at	timestamp	[en] Creation time
business_ws	boolean
csv_upload	text
default_currency	text	[en] Default currency, premium feature, optional, only for existing WS, will be 'USD' initially
default_hourly_rate	float	[en] The default hourly rate, premium feature, optional, only for existing WS, will be 0.0 initially
ical_enabled	boolean
ical_url	text
last_modified	timestamp
logo_url	text
name	text	[en] Workspace name
only_admins_may_create_projects	boolean	[en] Only admins will be able to create projects, optional, only for existing WS, will be false initially
only_admins_may_create_tags	boolean	[en] Only admins will be able to create tags, optional, only for existing WS, will be false initially
only_admins_see_billable_rates	boolean	[en] Whether only admins will be able to see billable rates, premium feature, optional, only for existing WS. Will be false initially
only_admins_see_team_dashboard	boolean	[en] Only admins will be able to see the team dashboard, optional, only for existing WS, will be false initially
organization_id	text	[en] Numeric ID of the organization
premium	boolean
profile	float
projects_billable_by_default	boolean	[en] Whether projects will be set as billable by default, premium feature, optional, only for existing WS. Will be true initially
rate_last_updated	timestamp	[en] Date of last update in the 'rate' field
reports_collapse	boolean	[en] Whether reports should be collapsed by default, optional, only for existing WS, will be true initially
role	text	[en] A user's level of access and permissions in a workspace.
rounding	float	[en] Default rounding, premium feature, optional, only for existing WS
rounding_minutes	float	[en] Default rounding in minutes, premium feature, optional, only for existing WS
server_deleted_at	timestamp
subscription_auto_renew	boolean
subscription_card_details	text
subscription_company_id	text
subscription_contact_detail	text
subscription_created_at	timestamp
subscription_currency	text
subscription_customer_id	text
subscription_deleted_at	text
subscription_last_pricing_plan_id	text
subscription_organization_id	text
subscription_payment_details	text
subscription_pricing_plan_id	text
subscription_renewal_at	timestamp
subscription_subscription_id	text
subscription_subscription_period	text
subscription_working_hours_in_minutes	float
subscription_workspace_id	text
suspended_at	timestamp

Workspaces: users

Replication type: Full

Relationships:

wid → Workspaces > id

Members of each Toggl workspace, one row per user in a workspace, with user and workspace identifiers, full name, email and admin/active/inactive flags.

Campo	Tipo
id	text	[en] User ID
email	text	[en] User's email
fullname	text	[en] User's full name
inactive	boolean
is_active	boolean	[en] If 'True', user with invitation accepted in Workspace.
is_admin	boolean	[en] If 'True', user has admin permissions on the workspace.
wid	text	[en] Project workspace ID Workspaces > > id

Notes

This data source is in beta mode

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Toggl as a Data Source on Kondado

Connect your Toggl time-tracking data to Kondado by generating an API token and configuring the beta connector.

Generate your Toggl API token

Log into your Toggl account as a Workspace Administrator, go to your profile page at https://track.toggl.com/profile, and copy your API Token.

Add Toggl as a source in Kondado

Log into your Kondado account, add Toggl as a data source, paste the API token you copied, then save the connector. Learn more about data integration on our platform.

Select the data entities to sync

Choose which Toggl entities to extract — such as Clients, Projects, Time entries, Tasks, Tags, Workspaces, and Workspaces: users — based on your reporting needs.

Send Toggl data to your destination

Route the extracted data to a BI tool, data warehouse, or spreadsheet for analysis. Explore all supported destinations to find the best fit for your workflow.

Frequently asked questions

What permission level do I need in Toggl to connect it to Kondado?▼

You need to be a Workspace Administrator in Toggl to generate the API token required for the connection.

Is the Toggl data source on Kondado fully released or still in testing?▼

The Toggl data source is currently in beta mode, meaning it is available to use but may still be undergoing refinements. You can adopt it today and any future improvements will be applied automatically.

Which Toggl data entities can I sync through Kondado?▼

You can replicate Clients, Groups, Projects, Projects: groups, Projects: users, Time entries, Tags, Tasks, Workspaces and Workspaces: users into your destination of choice.

Where can I send my Toggl data after extracting it with Kondado?▼

You can send Toggl data to BI tools, data warehouses or spreadsheets. View all available destinations to choose where to analyze your time-tracking data.

Do I need a paid Kondado plan to test the Toggl connection?▼

No. You can start a free Kondado trial to evaluate the platform, including beta data sources like Toggl. After the trial you choose a plan that fits your volume on the pricing page.

Written by

Thassyo Pereira·Published 2024-01-25·Updated 2026-06-01