Step 1: Set up a free Zapier account and add Timely Zap to it.
When you've set up an account, go to this link to accept the invite to our Zapier app.
Step 2: Set up a Google Sheet spreadsheet with some rows:
Here's an example of how it could look:
Step 3: Create a new Zap
Choose Timely as the Trigger app, and New Entry as the trigger:
Follow the instructions to connect your Timely account to Zapier:
Make sure you choose the right Timely account on the next step:
Test it and make sure you get "Test Successful!" before proceeding:
Now, add your Google account and choose the spreadsheet you created in step 2:
Use the dropdowns on the hours, name, project and date field to choose the corresponding values coming from Timely. Here's how it should look:
Now test and make sure it works:
Go to your spreadsheet and you'll see the data start to appear there:
Power tip: I've added a formula in the "Days" column to calculate how many days the hours amount to (I define a work day as 8 hours).
Make sure you turn on the Zap:
From now on, every time a new timesheet entry is created on the account you chose, the spreadsheet will be updated with new rows.
Note: The Zapier Free and Basic plan only runs Zaps every 15 minutes, so your spreadsheet won't update in real-time.