Clockify REST API with VBA | GET & POST Requests Explained
This video is a step-by-step tutorial on how to connect Excel VBA with the Clockify REST API. You’ll learn how to:
Generate and use your Clockify API key
Retrieve your Workspace ID with a GET request
Authenticate API calls using the X-Api-Key header
Perform a GET request to fetch all clients in your workspace
Perform a POST request to create new clients using a JSON payload
Handle common API errors (like duplicate client creation)
By the end, you’ll be able to integrate Clockify time-tracking data into Excel and automate client management directly from VBA.
👉 Perfect for developers, analysts, and anyone looking to combine time-tracking automation with Excel.
*Chapters:*
00:00 - Introduction & Series Welcome
00:45 - Clockify Sign-up & Account Setup
01:40 - How to Find Your API Key
02:50 - Making the First API Call: Get Workspace ID
04:30 - API Authentication: The X-API-Key Header
05:45 - GET Request: Listing All Clients in a Workspace
06:30 - POST Request: Creating a New Client (JSON Body)
08:00 - Handling API Errors & Duplicate Entries
09:00 - Conclusion & Preview of Next Videos
Please contact for any project or VBA Automation.
Contacts:
Email : [email protected]
Whatsapp: +8801515649307
LinkedIn : / md-ismail-hosen-b77500135
Facebook : / mdismail.hosen.7
Youtube : / @mdismailhosen8280
File link : https://resumenext.io/wp-content/uplo...