Data Linking with Google Sheets from Customizable Data Export

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 be using ClickTime on the Team (or higher) plan in order to use data linking to populate your Google Sheet with ClickTime data (Legacy customers must 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 your report 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):
  
  =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.