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.
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 Created→Add New Row
View the templateChange 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 Updated→Lookup Row Data→Update Row
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 Deleted→Lookup Row Data→Delete Row
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 Created→Number Formatter→Add New Row
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 Created→Add New Row
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 Created→Add New Row
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 Created→Date/Time Formatter→Add New Row