Integrating YoCoBoard and Google Sheets with Zapier
You can create Reports with YoCoBoard anytime, setting a date range and exporting the time clock data as a CSV file.
But what if you want to export your time entries to a spreadsheet in real time, automatically?
That’s where Zapier comes in. With Zapier, you can hook up YoCoBoard to a Google Sheets spreadsheet in your Google Drive. Then, whenever you clock in or clock out, the data will be “zapped” over to your spreadsheet.
Here’s how to set it up.
1.) Set up your Google Sheet
Before you being, create a simple Google Sheet with the following columns:
- Start time
- Stop time
- Duration
2.) Go to your Zapier account and choose “Make a Zap”
3.) For your Trigger app, choose YoCoBoard
4.) For your Trigger, choose New Clock Entry
Then, you’ll be prompted to test the step. Note that you must have at least one recent time clock entry in YoCoBoard so you have something to test.
5.) For your Action app, choose Google Sheets
6.) For your Action, choose Create Spreadsheet Row
7.) Choose the sheet that you set up in Step 1 to zap your data onto.
Here, we’re using a sheet called “Andrew Gosling’s Timeclock Data.” Choose the worksheet within that sheet you want to use. Using the fields, assign each spreadsheet column to the appropriate YoCo data: Start, Stop and Duration.
8.) Click Finish! Within moments, you should see your recent time clock entry appear in your Google Sheet!
If you have questions and need further assistance, please write to our support and we’d be happy to help!
