Charts Archives - Have Workflow

Gym progress visualization n8n templates cover

n8n

Reporting

Fitness

Gym Progress Charts from Google Sheets Data

Requirements

Need help importing? Click here for instructions.

CREATED BY

Julius Pau

This n8n workflow lets you create custom charts using data from Google Sheets and the Quickchart API. While n8n offers a basic Quickchart node, this workflow provides greater flexibility, including the ability to adjust the minimum value for your charts.

It’s currently set up to visualize gym progress, but you can easily adapt it to chart any data stored in Google Sheets.

Workflow Steps

This automated workflow follows a simple, yet powerful sequence:

1. Manual Trigger (Configurable)

Initiate the workflow manually with a click. Alternatively, configure it to run on a schedule or automatically trigger based on another event.

2. Google Sheets Data Retrieval

Retrieve data from your specified Google Sheets file using the provided URL. This node reads all the necessary information for generating the chart.

3. Data Extraction (Exercise)

This node processes the Google Sheets data, separating the list into distinct data points, ready for charting. This ensures each data point is correctly visualized.

4. Chart Plotting and Customization

This node generates the chart image. Crucially, this is where you customize the chart’s appearance, including setting the minimum value for the data axis.

5. Base64 Encoding

The chart datais converted into a Base64 encoded string. This is necessary for embedding the chart image within the subsequent HTTP request.

6. Quickchart HTTP Request

This node sends a request to the Quickchart API, including the Base64 encoded chart data. The Quickchart API returns the generated chart image.

Requirements

To get started, you’ll need:

n8n Account

An active n8n account for building and running workflows.

Try n8n for Free

Google Sheets Credentials

Permissions to access data from your Google Sheets account.

How to get Google Sheets Credentials?

Workflow Automation Community

Still have questions about this workflow automation template? Get help from our community of users and experts.

Supercharge Your Workflows with n8n

n8n is the perfect platform to bring this template to life. With its intuitive visual interface, you can easily connect your accounts, customize the workflow, and schedule automated reports.

Automated Strava Data Visualization template cover

Reporting

Fitness

Automated Strava Data Visualization

Requirements

Need help importing? Click here for instructions.

CREATED BY

Julius Pau

This n8n workflow retrieves activity data from your Strava account, allowing you to filter by specific activity types such as cycling, running, or walking.

It then processes this data to calculate and visualize key metrics like total yearly distance, time, and elevation gain for the selected activities, providing a comprehensive overview of your fitness progress.