Actually, there are many ways to visualize external data in Airtable. Let’s start with the obvious.
Perhaps you could sync the data from Google Sheets into a table and use Airtable’s extension to plot the data.
You could write a Google Apps Script process that sends the data via an Airtable webhook and then plots the results in the charting extension. If you have really custom chart requirements, Airtable’s interface with Vega Lite may be useful.
You could use the Airtable Embed extension to publish your Google charts in about 1 minute.