Besides the possibility to generate static reports in Google Sheets, there is also a custom function that can be used in cells. The special thing about this is that Google Sheets automatically keeps these fields up to date. Sol can easily build your own dashboards or generate live reports.

Example report with functions

How to use the TimeOwl Function

The timeowl function can be used in every sheet that is connected to the timeowl service. It will automatically pull the information from the connected timeowl account.

=TIMEOWL(tags, startDate, endDate, rows, fields, groupBy, calendars)
FieldDescription
tagsComma seperated list of tags that will be analyzed.
If its an empty string (“”), all tags will be used.
startDate/PeriodUse this field together with endDate to define a period of time that should be analyzed.
Its also possible to use a dynamic range:
– today
– yesterday
– thisWeek
– lastWeek
– thisMonth
– lastMonth
– thisYear
– lastYear
endDate
(optional)
End of the period to analye (optional)
cols
(optional)
Number of rows to display. Default ist “-1” which displays all data in the report.
The limitation can be used to fit the result into a given design
fields
(optional)
Fields that should be displayed. Used when you want to create an output with multiple columns.
Available Fields are:
– tag
– description
– calendarName
– label: Shows details
– duration
– date
– day
– week
– month
– year
– timestamp
groupBy
(opional)
Grouping of the query. Only one level supported on Google Sheets
Options are:
– tag: Group by tag/project
– description: Group the same descriptions
– calendar: group by calendar
– day: Group by days
– week: Group by weeks (show the week number)
– month: Group by month
– year: Group by year
– log: show the raw log (every single tracking item)
calendars
(optional)
List of calendarIds to filter