Keynote w/ Google Sheet, Excel, or Numbers

I have a Keynote presentation with Table Charts and Graphs. Currently, I use a Google Sheet to keep track of the numbers then I have to manually input them into my Keynote. I’m looking for a way to automate/sync this process. There’s a company that can sync between Google Sheets and Excel. I pull the numbers once a week and I only display the last 4 weeks of numbers and one Year (12 month, one column each month) overview. See screenshots for what my Keynote looks like. I have tools like Zapier Premium, Airtable, Datafire and Sync.io

Besides the syncing issue, I’m looking to also beautify my charts. That’s why I have a website like Airtable.

I appreciate you taking the time to read this and any suggestions to keep this simple and less work for me, since this is apart of my business.

For the screenshots, notice how the individual page has a table on the left, chart and table on the right. Then I also attached the monthly overview where I take the last weeks number as the month.

i pull the numbers every week.