thinkinglabs / toggl-google-sheet Goto Github PK
View Code? Open in Web Editor NEWImport Toggl time entries into a Google Sheet
License: MIT License
Import Toggl time entries into a Google Sheet
License: MIT License
Input data:
Resulted in the creation of a tab 07/2015 but without the times for 01/07.
When using 01/07/2015 as timesheetDate a tab 06/2015 is created.
For now I add manually a summary to the sheet that gives an overview of the total hours and days worked for a customer.
Customer Name | Total hours | Total days |
---|---|---|
Customer 1 | 122:53:29 | 16.39 |
Customer 2 | 40:47:18 | 5.10 |
This table should be generated automatically by the import.
toggl.com or www.toggl.com will no longer be a supported entry point for the Toggl Track API check:
https://github.com/toggl/toggl_api_docs
https://toggl.com/blog/api-documentation-change
Timings for 01/06/2015 and 02/06/2015 are not imported.
How would you pull all time data for all users into google sheet?
I worked 3 weeks and it brought me only 6 days and the working days 2
something is wrong...
How do I add the names, descriptions, start & end times of each task?
Dear @tdpauw
how would you handle it to add the detailed description and project (not just the customer) and maybe the username, too? Tested variations but unfortunately I can't figure it out directly
Documentation of the Google Drive import API
https://developers.google.com/apps-script/guides/import-export
Is it possible to pull more than one property into google sheets? At the moment the script imports "customer". I would like to import "project" and "description" as col 2 and 3?
I have been getting an error code in my google sheets the last few days "Exception: Request failed for https://www.toggl.com returned code 410."
If I run a debug in google scripts it gets stuck at UrlFetchApp and the debugger says page: undefined under local variables?
timesheetMonth = 02/08/2015
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.