Pricing
All integrationsProject Management
Live~2 minutes

Clockify → Google Sheets

Import workspaces, projects, clients, tags & users from Clockify

API key · Read-only by default · No data stored

~2 minutesSetup time
API keyAuthentication
15 minMin sync interval
Read-onlyDirection

Capabilities

Everything in the Clockify connector

3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.

Technical details

Built for IT teams to approve in one read

Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.

Authentication
API key
Direction
Read-only

Setup guide

Connect in 3 steps

From install to your first live query in under 5 minutes. No engineering help required.

1

Connect your account

Authorize Brooked to access your Clockify data using an API key or token.

2

Choose what to import

Pick from 6 available data types, like Workspaces, Projects, Clients.

3

Schedule your sync

Run it once, or set a recurring schedule. Data flows straight into your Google Sheet.

Need help? Visit support →

Use cases

How teams use Clockify + Brooked

From finance reporting to real-time operations dashboards, see what your team can build.

Keep Clockify data current in Sheets

Automatically sync your project management data from Clockify into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in Clockify, no manual exports.

Live in Google Sheets
Clockify → Sheets · auto-refresh

Available functions

Query Clockify from a cell

Five built-in sheet functions, from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.

fx

=BRKD_QUERY("Clockify", "show me the top records from last month")

Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.

=BRKD_QUERY("Clockify", "show me the top records from last month")

Also supported

More Project Management integrations

Asana

Live

Import workspaces, projects & tasks from Asana

Import teams, spaces, folders, lists, tasks & goals from ClickUp

Coda

Live

Import your doc catalog from Coda

Get your spreadsheet hours back

Brooked sets up in seconds. Your team is querying live data before lunch.

Get started free