Dynamic Chart Generation and Google Drive Upload - n8n Workflow

Data analysts and business intelligence specialists.
Users looking to automate report generation and visualization.
Anyone interested in advanced data handling within an n8n workflow.
Teams needing robust, reusable n8n templates for cloud reporting.

This powerful n8n workflow is designed for automated data visualization and cloud archiving. Many business processes require timely graphical reports, and this n8n template provides a quick, effective solution. It uses the QuickChart n8n node to dynamically generate high-quality line charts from simple input data, converting raw numbers into actionable visuals. The value of this specific n8n workflow lies in its ability to immediately handle the resulting image file and upload it directly to Google Drive for secure storage and sharing. This setup dramatically simplifies the reporting pipeline, offering an excellent foundation for creating more complex reporting n8n workflow solutions, whether you use a manual n8n trigger or schedule it daily.

The execution of this automated process starts with a manual n8n trigger, labeled ‘When clicking ‘Test workflow’’.

1. Data Initialization: The flow moves to the 'Edit Fields: Set JSON data to test' n8n node, which injects sample data (labels and sales figures) into the execution item. This node serves as a placeholder; in a production n8n workflow, it would be replaced by an n8n node fetching data from a database or API.


2. Chart Creation: The data is passed to the QuickChart n8n node. This specialized n8n node interprets the input arrays to dynamically render a line chart as a binary image file.


3. Archiving: Finally, the binary chart image is passed to the 'Google Drive: Upload File' n8n node. This n8n node handles the secure upload, naming the file dynamically based on the chart's file extension and placing it into the designated Google Drive location. This completes the automated n8n workflow cycle, transforming data into a visual report stored in the cloud.

1. Import the n8n workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Set up Credentials: The Google Drive n8n node requires credentials.

1. Customize Data: Modify the 'Edit Fields: Set JSON data to test' n8n node to input your required data structure, or replace it entirely with a real data source n8n node (like Google Sheets, Postgres, or HTTP Request).


2. Test: Execute the n8n workflow by pressing 'Test workflow' on the manual n8n trigger. The generated chart will appear in your Google Drive.

When clicking ‘Test workflow’ (Manual Trigger): The starting point of this n8n workflow. It is a simple n8n trigger used for testing and manual execution.
Edit Fields: Set JSON data to test (Set n8n node): Used to define the sample input data structure necessary for the chart generator. Key configuration involves setting the jsonData object containing arrays for labels (e.g., Q1, Q2, Q3, Q4) and salesData (numerical values).
QuickChart (QuickChart n8n node): The core visualization component. It is configured to create a line chart, mapping the input salesData to the chart data and labels to the X-axis labels. This n8n node generates the image as a binary file ready for output.
Google Drive: Upload File (Google Drive n8n node): Takes the binary chart file output by the QuickChart n8n node and uploads it. The file name is dynamically set using the expression =chart.{{ $binary.data.fileExtension }}. Requires Google Drive credentials to execute this final step of the n8n workflow.