Step 2: Connect Clockify and Define Global Settings

Fetch the workspace and define global variables used across the workflow.

1. Configure Fetch Primary Workspace with Resource set to workspace and Limit set to 1.
2. Credential Required: Connect your clockifyApi credentials in Fetch Primary Workspace.
3. In Define Globals, set workspace_id to {{ $json.id }}.
4. In Define Globals, set github_repo.owner and github_repo.name to your GitHub owner and repository values.
5. Connect Fetch Primary Workspace → Define Globals → Assign Month Indices.

Step 3: Build the Month Loop and Date Ranges

Create a rolling list of months and compute report ranges.

1. In Assign Month Indices, set monthIndex to [0, 1, 2] to process the current and previous two months.
2. In Expand Month List, set Field to Split Out to monthIndex.
3. In Compute Date Range, set reportName to =detailed_report_{{ $now.minus($json.monthIndex, 'month').format('yyyy-MM') }}.
4. Set startDate to {{ $now.minus($json.monthIndex, 'month').startOf('month').format('yyyy-MM-dd') }}.
5. Set endDate to {{ $now.minus($json.monthIndex, 'month').endOf('month').format('yyyy-MM-dd') }}.

Step 4: Request Clockify Reports and Locate GitHub Files

Fetch monthly report data and look up existing files in GitHub.

1. In Request Monthly Detail, set URL to https://reports.api.clockify.me/v1/workspaces/{{ $('Define Globals').item.json.workspace_id }}/reports/detailed.
2. Set Method to POST and JSON Body to { "dateRangeStart": "{{ $json.startDate }}T00:00:00Z", "dateRangeEnd": "{{ $json.endDate }}T23:59:59.999Z", "detailedFilter": { "page": 1, "pageSize": 50 }, "exportType": "json" }.
3. Credential Required: Connect your clockifyApi credentials in Request Monthly Detail.
4. In Locate GitHub File, set File Path to reports/{{ $('Compute Date Range').item.json.reportName }}.
5. Credential Required: Connect your githubApi credentials in Locate GitHub File.
6. Note the parallel flow: Locate GitHub File outputs to both Map New Report Data and Parse File Data in parallel.

Step 5: Compare Data and Update Existing Reports

Parse existing files, compare with new data, and update reports if needed.

1. In Map New Report Data, set data to {{ $('Request Monthly Detail').item.json.timeentries }}.
2. In Parse File Data, set Operation to fromJson to parse the file content.
3. In Compare Records, set Merge By Fields to compare data against data.
4. In Modify GitHub File, set File Path to reports/{{ $('Compute Date Range').item.json.reportName }}.
5. Set File Content to {{ JSON.stringify($json.data, null, 2) }} and Commit Message to Update report.
6. Credential Required: Connect your githubApi credentials in Modify GitHub File.

Step 6: Create New Reports When Files Are Missing

Handle missing files and only create reports when there is data.

1. In Detect Missing File, confirm the condition checks {{ $json.error }} contains could not be found.
2. In Filter Empty Reports, ensure the condition checks {{ $json.timeentries }} is notEmpty.
3. In Create GitHub File, set File Path to reports/{{ $('Compute Date Range').item.json.reportName }}.
4. Set File Content to {{ JSON.stringify($json.timeentries, null, 2) }} and Commit Message to Create report.
5. Credential Required: Connect your githubApi credentials in Create GitHub File.

Step 7: Add Error Handling

Stop the workflow when errors are not related to missing files.

1. Verify Locate GitHub File has Continue On Fail behavior (it outputs to the error branch when the file is missing).
2. Connect the false path of Detect Missing File to Halt on Error.
3. In Halt on Error, set Error Message to {{ $json.error }}.

Step 8: Test and Activate Your Workflow

Validate the run and turn on the schedule.

1. Click Execute Workflow to run Scheduled Run Trigger manually.
2. Confirm that Request Monthly Detail returns timeentries and that Locate GitHub File finds or routes missing files correctly.
3. Verify GitHub updates: Modify GitHub File should commit updated JSON, or Create GitHub File should create a new file under reports/.
4. Set the workflow to Active to enable the daily run at 5:00.