ClickTime supports Data Linking for the Customizable Data Export to Google Sheets. Data Linking starts with the Customizable Data Export Report - general information on using that report is available in the Customizable Data Export Overview Guide here. For assistance creating (or customizing) the Customizable Data Export link, please see the Data Linking Overview guide.
Please note you must have a Corporate or Enterprise account in order to use data linking to populate your Google Sheet with ClickTime data.
Data Import Instructions for Google Sheets
- Ensure your URL Format parameter is set to CSV.
- Open Google Sheets.
- Create a new blank worksheet.
- Click on the first cell in the worksheet. You can either work directly in the cell, or in the Formula Bar (made visible under the View menu).
- Type or copy and paste your link URL into the cell in the following format (screenshot below):
Please note that you will need to append the link with "&Format=csv" to make sure that the resulting file loads in the appropriate format.
Sheets will then immediately query and return the appropriate data to your spreadsheet.
In the above example, we have modified the link so that the Start Date is Jan 1, 2017 and the End Date is Jan 31, 2017 by adding "&StartDate=yyyymmdd" and "&EndDate=yyyymmdd" before the "&Format=csv" text.