TimeTonic

TimeTonic is a time tracking and project management platform that helps teams log hours, manage tasks, and track project progress. With Coupler.io, you can automatically export your TimeTonic data—timesheets, project hours, team activity—to Google Sheets, Excel, BigQuery, Looker Studio, or AI destinations like Claude and ChatGPT for analysis and reporting.

Why connect TimeTonic to Coupler.io?

• Automate time tracking exports — Pull your latest timesheet and project data without manual downloads

• Build live dashboards — Feed TimeTonic data into Looker Studio or Google Sheets for real-time reporting

• Combine with other data — Use Join or Append transformations to merge TimeTonic hours with project costs, resource allocation, or payroll data

• Analyze with AI — Send timesheets and project metrics to Claude or ChatGPT for automated insights on team productivity and project profitability

Prerequisites

• A TimeTonic account with access to at least one workspace and table

• Permission to generate or access an API key from your TimeTonic account settings

• A destination ready to receive the data (Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination)

Quick start

Start with a single workspace and table to test the connection. Once you confirm the data looks correct, you can add more tables or views in separate data flows or expand your existing flow with transformations.

How to connect

1

Sign in to Coupler.io and create a new data flow. Choose TimeTonic as your source.

2

Paste your TimeTonic API key. In your TimeTonic account, navigate to your workspace settings and find the API key section. Copy your key and paste it into the Coupler.io connection form. Click Test connection to verify.

3

Select your workspace. Choose the workspace you want to export data from using the dropdown menu.

4

Choose a table. Select the table (timesheet, project, team activity, etc.) you want to export.

5

Pick a view (optional). If your table has multiple views, select the one you want to use. If you're unsure, the default view will work fine.

6

Select your destination. Choose where you want the data to land: Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination like Claude for automated analysis.

7

Run the data flow. Click Run to complete your first export. Once the run succeeds, your data is ready in the destination.

Available tables

TimeTonic data varies by workspace and account setup. Common tables include:

Table	Description
Timesheets	Employee or contractor time entries, logged hours, and project assignments
Projects	Project names, codes, budgets, status, and team members
Team Activity	Logs of who tracked time, when, and for how long
Tasks	Individual tasks, assignments, estimated vs. actual hours
Reports	Pre-built summaries like billable hours, resource utilization, or project spend

Your exact tables depend on your TimeTonic workspace configuration. If you don't see an expected table, check your workspace settings or contact your TimeTonic admin.

TimeTonic data overview

TimeTonic exports timesheet, project, and team activity data that's ready for payroll, billing, resource planning, and project analytics. The exact tables and columns available depend on your workspace setup and user permissions.

Common table types

Table Type	Purpose	Common Use
Timesheets	Logged hours by employee, date, and project	Payroll processing, billable hours tracking
Projects	Project details including budget, timeline, and team	Project profitability, resource allocation
Team Activity	Summary of who logged time and when	Team productivity reports, audit trails
Tasks	Individual tasks with time estimates and actual hours	Workload distribution, project scheduling
Reports	Pre-aggregated summaries	Quick dashboards without further transformation

Common metrics

Time tracking metrics

• Total hours logged — Sum of all hours tracked across projects or team members

• Billable hours — Hours marked as billable or chargeable to clients

• Overtime hours — Hours exceeding standard work week

• Project hours — Total hours allocated to a specific project

• Resource utilization — Percentage of time allocated vs. available capacity

Project metrics

• Budget vs. actual spend — Planned project cost vs. hours logged at rate

• Project completion rate — Percentage of tasks or hours completed

• Average task duration — Estimated vs. actual hours per task

• Team member utilization — Hours logged per person as percentage of availability

Common dimensions

Time dimensions

• Date/Week/Month — Time period for grouping logged hours

• Employee or contractor — Who logged the time

• Project — Which project received the hours

• Task — Specific task assigned

• Status — Approved, pending, draft, submitted

Business dimensions

• Department — Organizational unit

• Cost center — Internal billing or allocation code

• Client — External customer or internal department

• Billable flag — Whether hours are charged to a customer

Use cases by role

Finance & Payroll

Export timesheet data to calculate payroll, track labor costs by project, and reconcile billable vs. non-billable hours. Use Append to combine multiple months or employees, then feed results to your payroll system or accounting software. Use Join to add employee rates or cost center mappings for accurate costing.

Project Managers

Track project budgets, monitor hours against estimates, and measure team capacity. Pull project and task-level data, then use Aggregate to summarize hours by project, team member, or phase. Join with project budget tables to create variance reports (budget vs. actual).

Resource Managers

Plan team capacity, identify over-allocation, and balance workload across projects. Export team activity and utilization metrics, then use Aggregate to calculate average hours per resource and availability gaps. Join with employee information for headcount and role-based analysis.

Executives & Analysts

Build dashboards showing labor costs, project profitability, and team productivity. Send TimeTonic data to Looker Studio for live dashboards or to Claude/ChatGPT for automated insights on utilization trends, cost overruns, and resource bottlenecks.

Platform-specific notes

• Views matter — If your table has multiple views (e.g., filtered by date range, status, or team), make sure you select the right one. Different views can have different column sets.

• Permissions — The API key you use must have permission to access the workspace and tables you select. If you see "Permission denied" errors, check your TimeTonic role and API key settings.

• Data freshness — TimeTonic data is pulled at the time you run the data flow. Scheduled refreshes will export the latest data from your workspace.

• Time zone handling — Verify that dates and times in your export match your workspace time zone. TimeTonic may store times in UTC; check your workspace settings if you notice discrepancies.

• Large datasets — If exporting thousands of rows, the data flow may take longer. Consider filtering by date range or using views that limit the result set.

• Custom fields — If your tables include custom fields or metadata, they will appear as columns in the export. Column names come from your TimeTonic configuration.

TimeTonic common issues

Connection issues

API key is invalid or expired

If you see "Authentication failed" or "Invalid API key" when testing the connection, your API key may be incorrect or no longer active.

Fix: Go to your TimeTonic account settings, regenerate your API key, and paste the new key into Coupler.io. Test the connection again.

Cannot see my workspace in the dropdown

If the workspace dropdown is empty or doesn't show the workspace you expect, your API key may not have access to it.

Fix: Verify that your TimeTonic user account has permission to access the workspace. Ask your TimeTonic admin to confirm your role or add you to the workspace. Then regenerate your API key and test the connection again.

"No tables found" message

If after selecting a workspace, no tables appear in the table dropdown, the workspace may be empty or your permissions are limited.

Fix: Check with your TimeTonic admin to confirm that tables exist in the selected workspace. Verify that your user account has permission to view those tables. If you just created the workspace, you may need to create a table first before the connector can access it.

Missing data

Exported data shows fewer rows or columns than expected

If your export is missing rows or columns, you may have selected a view that filters or limits the data.

Fix: Check the view you selected. Try switching to the "All" view or default view to see if more data appears. You can also check your TimeTonic table settings to confirm that views are not hiding columns.

Recent hours or entries are not showing up

If you logged hours in TimeTonic but they don't appear in your Coupler.io export, the data may still be in draft or pending status.

Fix: In TimeTonic, check the status of your time entries (draft, submitted, approved). Export views or reports that include the status filter you need. If entries are still in draft, submit or approve them in TimeTonic first, then re-run the data flow.

Employee names or project names appear as IDs instead of names

If your export shows ID codes instead of human-readable names, the view may be configured to show IDs.

Fix: In your TimeTonic table settings, check if the view displays ID columns or name columns. You may need to adjust the view columns or create a Join in Coupler.io to look up names from a reference table (e.g., employee or project master data).

Permission errors

"Permission denied" when accessing a workspace or table

Your API key or user account does not have permission to access the selected workspace or table.

Fix: Ask your TimeTonic admin to grant you access to the workspace and table you're trying to export. Ensure your user role includes read access. After permissions are updated, regenerate your API key and re-test the connection.

Can connect but cannot see certain tables

You have access to the workspace but not all tables are visible in the dropdown.

Fix: Check your TimeTonic user role. Some users have limited access to certain tables or modules (e.g., reports, projects). Ask your admin to verify which tables your role can access.

Data discrepancies

Hours totals don't match TimeTonic UI

The sum of hours in your Coupler.io export may differ from what you see in the TimeTonic interface.

Fix: Check if the exported view includes filters (e.g., approved entries only, specific date range, or billable entries only). Compare the view's filter settings in TimeTonic to your export. If you need all hours including drafts, switch to an unfiltered view.

Date or time values are off by a few hours

TimeTonic stores times in UTC, but your workspace may be configured for a different time zone.

Fix: Check your TimeTonic workspace time zone settings. If needed, add a calculated column in your destination (Google Sheets or BigQuery) to convert times to your local zone. You can also check the time zone of the device where times were logged.

Rate limits

Data flow runs are slow or timing out

If your TimeTonic export takes a long time or fails, you may be hitting API rate limits or exporting too much data at once.

Fix: Try exporting a smaller date range or use a filtered view to reduce the number of rows. For large exports, consider splitting into multiple data flows (e.g., one per month or per project). Schedule exports during off-peak hours to avoid competing with other users.

TimeTonic FAQ

Can I export multiple tables from TimeTonic in one data flow?

Yes. Create a data flow for each table you want to export (e.g., one for Timesheets, one for Projects). You can then use Append transformations to combine them in your destination if they have the same structure, or keep them separate for different uses.

How often can I schedule TimeTonic data exports?

You can schedule data flows as frequently as you need—hourly, daily, weekly, or monthly. Choose based on how current your data needs to be. For payroll and billing, daily or weekly is typical. For dashboards, hourly may make sense if you update hours throughout the day.

What time zone does TimeTonic use for exported dates and times?

TimeTonic stores times in UTC by default, but your workspace may have a configured time zone. Check your TimeTonic workspace settings to see how times are being recorded. If there's a mismatch, you can add a formula in Google Sheets or BigQuery to convert times to your preferred zone.

Can I join TimeTonic data with other sources in Coupler.io?

Yes. Use the Join transformation to combine TimeTonic hours with employee rates, project budgets, or cost center data from another source (Google Sheets, Excel, BigQuery, etc.). This is useful for calculating labor costs, project profitability, or resource utilization.

How do I handle timezone issues when exporting timesheet data?

If your team works across time zones, verify that TimeTonic entries are logged in the correct zone. In your workspace settings, confirm the time zone for the account. If times are consistently off in your export, check if times were logged on a device with a different timezone setting. You can also create a calculated field in your destination to adjust times as needed.

What should I do if my TimeTonic export shows IDs instead of names?

This usually means the view or export is configured to display ID fields. In TimeTonic, edit the view to show name columns instead. Alternatively, create a Join in Coupler.io to look up names from a reference table (e.g., employee master list) using the ID as the key.

Can I send TimeTonic data to an AI destination like Claude?

Yes. You can send TimeTonic timesheet or project data to Claude, ChatGPT, Gemini, or other AI destinations. This is useful for generating automated insights on team productivity, identifying over-allocation, or analyzing project profitability trends without manual analysis.

How do I regenerate my TimeTonic API key?

Go to your TimeTonic account settings, find the API key section, and select the option to generate or regenerate your key. Copy the new key immediately and paste it into Coupler.io. The old key will no longer work after regeneration, so update any other integrations that use it.

What if I see a "No tables found" error?

This means your workspace doesn't have any tables yet, or your user account doesn't have permission to view them. Create at least one table in TimeTonic (e.g., a timesheet table), or ask your admin to grant you access. Then regenerate your API key and try connecting again.

For more details on metrics, dimensions, and use cases, see the Data Overview article. For troubleshooting steps, check Common Issues.