Adding a Toggl pack so that time tracking could seamlessly be integrated into Coda docs would be AWESOME
Matt, I totally agree with you on this. I am a long-time user of Toggl and would love to see this come in as a pack.
I’m currently using a Zapier recipe to pull that data in right now. Have you tried that?
I’m not sure what that is, but if it would automatically pull in filtered data from Toggl, I would LOVE to hear how. This would make my work flow MUCH more efficient.
Hope you have the solution,
Zapier (www.zapier.com) uses APIs from approximately 1500 apps to enable you to exchange data automatically. No programming knowledge is necessary. To create a “Zap” you define a trigger (for example, “Whenever a new Toggl record is created…”) and an action ("… then copy the data to a specific table in Coda"),
If you have ever heard of or used If This Then That (IFTT), it’s the same idea.
After setting up your Zapier account, the first thing to do is connect your Toggl and Coda accounts to Zapier. Essentially you are logging into those accounts and giving Zapier permission to read and write data. Once the accounts are connected, you can use Zapier’s editor to go through the process of setting up your trigger and action.
To set up the trigger:
- Choose Toggl from the app list
- Select “New Time Entry” as your Toggl Trigger
- Choose your Toggl account (if you have connected more than one)
- Set up Toggl Time Entry (choose your work space, specific task - i leave it blank - and tags for filtering entries you want)
- Finally, Zapier will prompt you to pull in test data
To set up the action:
- Choose Coda from the app list
- Select “Create Row” as your Coda action*
- Choose your Coda account (if you have connected more than one)
- Set up your Coda row
a. Select your Coda document from the first select list
b. Select your Coda table from the second select list
At this point, the columns from your Coda table show up. You need to tell Zapier how to populate the columns. This will depend on how your Coda table is set up and how you have set up Toggl. My original set-up:
Coda ----> Toggl
TimeEntry (text) ----> Description
Duration (number) ----> Duration Minutes (it’s easier for computations in Coda)
TogglTags (text) ----> Tags
Project (text) ----> Project
Start (DateTime) ----> Start
End (DateTime) ----> Stop
GUID (text) ----> GUID
Toggl’s API makes a ton of values available. This minimal set up should get you started.
Note: I actually use “Upsert” as my Coda action, which enables me to add a row to Coda if the Toggl record doesn’t already exist, or modify the row in Coda if the Toggl record was previously sent but then was updated in Toggl. It’s a more advanced method but nothing big.
Hope this helps.