Export Clockify Time Entries to Google Sheets Automatically with Pabbly Connect

Learn how to export Clockify time entries to Google Sheets automatically using Pabbly Connect with this detailed step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To export your Pabbly Connect time entries from Clockify to Google Sheets automatically, you first need to access the Pabbly Connect platform. Open your internet browser and type in Pabbly.com. Once on the landing page, hover over the ‘Products’ icon and click on ‘Pabbly Connect’ to start the integration process.

Next, you can set up a free trial account by clicking the ‘Sign Up Free’ button. If you already have an account, simply click on ‘Sign In’. After logging in, navigate to the Pabbly Connect dashboard to begin creating your workflow.

2. Create a Workflow in Pabbly Connect

Creating a workflow is essential for automating the transfer of Clockify time entries to Google Sheets. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. Enter a relevant name for your workflow, such as ‘Send Clockify Time Tracking Data to Google Sheets’, and then click on ‘Create’.

• Select ‘Clockify’ as the trigger app.
• Choose the trigger event as ‘New Time Entry’.
• Copy the provided webhook URL.

After creating the workflow, you will see two sections: Trigger and Action. The trigger will be a new time entry in Clockify, while the action will send that entry to Google Sheets. This is where Pabbly Connect facilitates the integration seamlessly.

3. Set Up the Clockify Webhook

To connect Clockify with Pabbly Connect, go to your Clockify dashboard. Click on your profile icon at the top right corner and select ‘Profile Settings’. Scroll down to find the ‘Webhooks’ section and click on ‘Manage Webhooks’.

• Click on ‘Create New Webhook’.
• Name the webhook (e.g., ‘Time Sheet Spreadsheet’).
• Paste the copied webhook URL into the endpoint URL field.
• Select the event ‘Time Entry Created Manually’.

After saving, Pabbly Connect will start waiting for the webhook response. This setup allows new time entries in Clockify to trigger updates in Google Sheets automatically.

4. Test the Integration with a New Time Entry

Now it’s time to test your integration. Go back to your Clockify application and add a new time entry. For example, select a project, enter the date, and input the working hours. Once the time entry is created, check Pabbly Connect to see if the data has been captured.

If successful, you will see the time entry details in Pabbly Connect. This confirms that the webhook is functioning correctly and that Clockify is sending data to Pabbly Connect.

5. Send Data to Google Sheets

After testing, the next step is to send the captured data to Google Sheets. In Pabbly Connect, add a new action step and select Google Sheets as the app. Choose the action event ‘Add New Row’ and connect your Google account.

Map the relevant fields from Clockify to Google Sheets, such as project name, start date, end date, and working hours. After mapping, click on ‘Save and Send Test Request’. If successful, a new row will appear in your Google Sheets with the time entry data from Clockify.

This entire process showcases how Pabbly Connect effectively automates the transfer of Clockify time entries to Google Sheets automatically, streamlining your workflow.

Conclusion

In this tutorial, we explored how to export Clockify time entries to Google Sheets automatically using Pabbly Connect. By setting up a webhook and creating a workflow, you can efficiently manage your time tracking data without manual intervention. This integration enhances productivity and simplifies your reporting process.