n8n Token Usage Analytics Dashboard

This n8n workflow provides a robust solution for collecting, processing, and visualizing token usage analytics. It acts as a backend for a dashboard, allowing you to track and analyze how tokens are being consumed, likely in an AI or API context.

The workflow listens for incoming token usage data via a webhook, processes it, and then stores it in a Google Sheet. It also includes functionality to generate a CSV file from the processed data, which can be used for further analysis or visualization.

What it does

This workflow automates the following steps:

1. Receives Token Usage Data: It starts by listening for incoming POST requests to a webhook URL, expecting token usage data in the request body.
2. Processes Incoming Data: It extracts relevant fields from the incoming JSON payload and transforms them into a structured format.
3. Appends to Google Sheet: The processed token usage data is then appended as a new row to a specified Google Sheet, serving as a persistent data store.
4. Generates CSV for Visualization: It reads all data from the Google Sheet, converts it into a CSV file, and then responds to the initial webhook request with this CSV data. This allows an external application or dashboard to easily consume and visualize the latest token usage.
5. Includes a Wait Step (Optional/Placeholder): A "Wait" node is present in the workflow, which could be used to introduce a delay if there are rate limits or processing requirements between steps, though its current configuration is not detailed in the JSON.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance to import and execute the workflow.
• Google Sheets Account: A Google Sheets spreadsheet to store the token usage data. You will need to configure a Google Sheets credential in n8n with access to this spreadsheet.
• Webhook Trigger: An external system or application that sends token usage data (as JSON in a POST request) to the n8n webhook URL.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the workflow JSON or upload the file.

2. Configure Credentials:

   • Google Sheets:
     • Locate the "Google Sheets" node.
     • Click on the "Credential" field and select an existing Google Sheets credential or create a new one. Ensure the credential has write access to your target spreadsheet.
     • Enter the "Spreadsheet ID" and "Sheet Name" where you want to store the data.
   • Webhook:
     • Locate the "Webhook" node.
     • Copy the "Webhook URL". This is the URL you will use to send token usage data to this workflow.

3. Configure Nodes:

   • Edit Fields (Set): Review the "Edit Fields" node to ensure the field mapping matches the incoming data structure and your desired output for the Google Sheet.
   • Code: Review the "Code" node for any custom logic or data transformations.
   • HTML: Review the "HTML" node for any specific HTML templating or data extraction.
   • Convert to File: Review the "Convert to File" node to ensure the CSV conversion settings (e.g., delimiter, header) are as desired.
   • Wait: If the "Wait" node is configured, adjust the delay as needed.

4. Activate the Workflow:

   • Once configured, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.

5. Send Data to the Webhook:

   • Send POST requests containing your token usage data (JSON payload) to the Webhook URL you copied in step 2. The workflow will then process and store this data.

6. Access Analytics:

   • The latest token usage data in CSV format will be returned as the response to the webhook call, allowing your dashboard or application to consume it directly.
   • You can also directly view the accumulated data in your configured Google Sheet.