n8n
Reporting
Fitness
Gym Progress Charts from Google Sheets Data
Requirements
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:
Permissions to access data from your Google Sheets account.
Still have questions about this workflow automation template? Get help from our community of users and experts.
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.
© 2025 No Bad Content OÜ. All rights reserved.