tr Skip to content
Black Friday Lifetime FlowMattic from $399 One payment, unlimited workflows. Ends in --Days --Hrs --Min --Sec See the deal

Connect Timely and Google Sheets

Timely tracks the hours your team works and the forecasts you plan. FlowMattic copies those entries into Google Sheets from your WordPress site, and keeps them right when hours are edited or removed. Agencies and consultancies get a timesheet they can bill from, pivot by client and share with finance.

18 triggers 19 actions 7 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Timely12 triggers

Do this in Google Sheets19 actions

1. TriggerHours Created
2. ActionAdd New Row

When Timely fires Hours Created, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Timely and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Timely app icon Google Sheets app icon Ready-made template

Add each new Timely hours entry to a timesheet

Every logged block of time becomes a row with person, project, date, duration and note, so finance has a timesheet without a monthly export.

Hours CreatedAdd New Row

View the template
Timely app icon Google Sheets app icon

Change the row when hours are edited

People fix their time after the fact. Look the entry up by its Timely ID and update the row, so the billed total matches what is in Timely.

Hours UpdatedLookup Row DataUpdate Row

Timely app icon Google Sheets app icon

Remove the row when hours are deleted

A deleted time entry should not stay on an invoice. Find its row by ID and delete it, so the sheet never bills for removed work.

Hours DeletedLookup Row DataDelete Row

Timely app icon Google Sheets app icon

Convert durations to decimal hours for billing

Number Formatter turns the duration into hours with two decimals, so a rate column can multiply it straight into an invoice amount.

Hours CreatedNumber FormatterAdd New Row

Timely app icon Google Sheets app icon

Keep a project list with budgets

Each new Timely project is added to a projects tab with its client and budget, which the timesheet tab can look up for totals per project.

Projects CreatedAdd New Row

Timely app icon Google Sheets app icon

Compare forecasts with logged hours

Forecasts go to their own tab with person, project and planned hours, so planned and actual time sit side by side for capacity reviews.

Forecasts CreatedAdd New Row

Timely app icon Google Sheets app icon

Write hours to the tab of their month

Date/Time Formatter turns the entry date into a month name used as the sheet name, so each billing period starts from its own tab.

Hours CreatedDate/Time FormatterAdd New Row

Set up: new hours in a timesheet

At the end, every hours entry created in Timely is added to your timesheet as one row.

  1. Prepare the timesheet

    Add a header row such as Entry ID, Date, Person, Project, Hours and Note.

  2. Connect Timely and Google Sheets

    In FlowMattic, open Connects and add your Timely account and a Google Sheets account that can edit the timesheet.

  3. Start with Hours Created

    Create a workflow with the Timely Hours Created trigger and log a short test entry so FlowMattic captures its fields.

  4. Map the row

    Add Google Sheets Add New Row, map the entry fields to your columns, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Add each new Timely hours entry to a timesheet Template
  1. Timely app icon 1. Trigger in Timely Hours Created
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From TimelyTo Google Sheets
    Entry IDEntry ID
    DateDate
    User namePerson
    Project nameProject
    DurationHours
    NoteNote
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • Store the Timely entry ID in its own column. Hours Updated and Hours Deleted need it to find the right row with Lookup Row Data.
  • Check how the duration arrives in the captured data, for example minutes or hours and minutes, before you build the billing formula.
  • The sheet follows Timely. Editing hours in the sheet does not change the entry in Timely, so make corrections in Timely.

Triggers (12)

  • Forecasts CreatedTriggers when a forecasts is created.
  • Forecasts UpdatedTriggers when a forecasts is updated.
  • Forecasts DeletedTriggers when a forecasts is deleted.
  • Hours CreatedTriggers when hours is created.
  • Hours UpdatedTriggers when hours is updated.
  • Hours DeletedTriggers when hours is deleted.
  • Labels CreatedTriggers when labels are created.
  • Labels UpdatedTriggers when labels are updated.
  • Labels DeletedTriggers when labels are deleted.
  • Projects CreatedTriggers when projects are created.
  • Projects UpdatedTriggers when projects are updated.
  • Projects DeletedTriggers when projects are deleted.
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Timely and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Billing from a sheet you control

Timesheets land in Google Sheets where rates, discounts and client codes can be added without changing Timely.

Edits and deletions follow through

Separate workflows for updated and deleted hours keep the sheet's totals equal to what people tracked.

Every entry, no task count

FlowMattic runs on your own WordPress site with unlimited runs, so a team logging dozens of entries a day costs the same.

Common questions

How do I export Timely hours to Google Sheets automatically?

Create a FlowMattic workflow with the Timely Hours Created trigger and a Google Sheets Add New Row step. Map the date, person, project, duration and note, and each new entry is added as a row.

What happens when someone edits their hours?

A second workflow on Hours Updated finds the row by the entry ID with Lookup Row Data and rewrites it with Update Row, so the sheet matches Timely.

Can I bill clients straight from the sheet?

Yes. Convert durations to decimal hours with Number Formatter, add a rate column per project and multiply. Monthly tabs keep each invoice period separate.

Can I track forecasts against actual hours?

Yes. Log Forecasts Created to a forecasts tab and hours to the timesheet tab, then compare the two per person and project with a pivot table.

Will hours logged before setup be copied?

No. Triggers act on entries created after the workflow is on. Export earlier hours from Timely once and paste them into the sheet to start complete.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Timely and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Timely integration 1.0.0, Google Sheets integration 2.2.4.