n8n Clockify Monthly Reports to GitHub Backup Workflow

This n8n workflow automates the process of backing up monthly Clockify reports to a GitHub repository. It fetches time entries for the previous month, processes them, and then creates or updates a JSON file in a specified GitHub repository.

What it does

This workflow performs the following steps:

1. Schedules Execution: Runs automatically on the first day of every month.
2. Fetches Clockify Time Entries: Retrieves all time entries from Clockify for the previous month.
3. Processes Time Entries:
   • Initializes an empty array to store processed time entries.
   • Iterates through each raw time entry from Clockify.
   • Extracts relevant fields (like billable, description, duration, projectId, taskId, userId, workspaceId, start, end, timeInterval).
   • Adds a month field (e.g., "YYYY-MM") to each entry.
   • Adds a reportDate field (e.g., "YYYY-MM-DD") to each entry.
4. Checks for Existing GitHub File: Attempts to retrieve the content of a specific JSON file (e.g., clockify-monthly-reports/YYYY-MM.json) from a GitHub repository.
5. Compares Datasets:
   • If the file exists, it extracts the JSON content from the file.
   • Compares the newly fetched Clockify data with the existing data in the GitHub file.
   • Filters out any time entries that are already present in the GitHub file.
6. Updates GitHub File (if new data exists):
   • If there are new time entries to add, it merges the new data with the existing data.
   • Creates or updates the JSON file in the GitHub repository with the combined data.
   • Commits the changes with a descriptive message.
7. Handles Errors: If any step fails (e.g., GitHub file not found, API error), the workflow will stop and report an error.

Prerequisites/Requirements

• n8n Instance: A running instance of n8n.
• Clockify Account: With an API key configured as an n8n credential.
• GitHub Account: With a Personal Access Token (PAT) configured as an n8n credential, granting repository write access.
• GitHub Repository: A designated GitHub repository where the Clockify reports will be stored. You will need to specify the owner, repo, and branch in the GitHub node.

Setup/Usage

1. Import the Workflow:
   • Download the workflow JSON.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON.
2. Configure Credentials:
   • Clockify: Configure your Clockify API credential.
   • GitHub: Configure your GitHub Personal Access Token credential.
3. Configure Nodes:
   • Clockify node (ID: 371): Ensure the correct Clockify credential is selected.
   • GitHub node (ID: 16):
     • Select your GitHub credential.
     • Update the Owner, Repository, and Branch fields to match your GitHub repository.
     • The File Name expression dynamically generates the file path (e.g., clockify-monthly-reports/{{ $json.month }}.json).
   • HTTP Request node (ID: 19): This node is used to fetch the raw content of the GitHub file. Ensure the URL and headers are correctly configured to use your GitHub PAT for authentication.
4. Activate the Workflow: Once configured, activate the workflow to enable its scheduled execution. It will run automatically on the first day of each month.