Hi @Bernadette_Hennessy and welcome to the community.
I have done this many times, but it requires an external process running a G-Suite (or Gmail) account and a fair bit of API and coding skill.
The way I created an automated and highly visual process is to pull the data from Airtable (via the API) into the G-Suite environment using Google Apps Script. Then, using the native aspects of Google Docs (and Slides in some cases) I built various report templates with placeholders for the data including text narratives and charts.
Then I created a simple table (in Airtable) so users could administer automation properties such as how often a report was generated, who should receive it, and the template it should be based on.
Lastly, I built the scripting process to do it all without any manual effort. This involves establishing repeatable processes that use Google’s integrated chron-job platform for running scripts at various intervals.
As you can see, this is not a product or a recipe, there are no succinct steps and clicks anyone could follow to just implement this. Rather, it is a solution crafted for a business that embraces automation process to make its workers productive and especially where data and visualizations are key to their communications success.
All I did was leverage the great elements of Airtable which the client loves, and make it possible to build and manage the reporting process far beyond anything we could ever expect Airtable to provide.
Here’s an example output. All of the data in these pages came from Airtable.
What you are wanting to achieve is definitely well within my area of expertise and I would be glad to help you build this out.
You can reach me on email@example.com