ClickTime offers Data Linking for the Customizable Data Export to Google Sheets. The process begins with the Customizable Data Export Report. You can find general information on how to use this report in the Customizable Data Export Overview Guide. If you need help creating or customizing the Customizable Data Export link, please refer to the Data Linking Overview guide.
Please note that to use data linking and populate your Google Sheet with ClickTime data, you must be on the Team plan or higher. Legacy customers need to have the Corporate or Enterprise feature set.
Data Import Instructions for Google Sheets:
BEFORE YOU BEGIN: make sure you have named/saved your report as described HERE.
- Ensure the Format parameter of your report URL is set to "CSV":
- Open Google Sheets.
- Create a new blank worksheet.
- Click on the first cell in the worksheet. You can work either directly in the cell or in the Formula Bar, which is visible under the View menu.
- Type or copy and paste your link URL into the cell using the following format (see screenshot below):
=importData("https://rpt.clicktime.com/App/CustomExport/RunSavedExport.aspx?ID=2zYcls4UUBs&Email=usersemail%40usersdomain.com&UserKey=UfI6GfZJydI%3d&Format=csv")
Please note that you will need to add parenthesis and quotes around the link you get from ClickTime. You will also need to append the link with &Format=csv (before closing the link with quotes and parenthesis) to make sure that the data loads in your spreadsheet.
After entering the link and tabbing out of the cell, Google 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.
Your Google Sheet may not display the actual dates of the entry, in which case you can select all cells in the column, and then go to Format --> Number --> Date to change the formatting.
Comments
0 comments
Article is closed for comments.