Need Script to import a Google Sheets

Hello! :wave:
I have been trying to figure this out for a couple of weeks now, but finally diving into custom scripts.

I am trying to set up an Automation in my Airtable Workspace where:

Button is pushed > Import data from .csv or Google sheets.

Is there a script that will import when I push that button?

It doesn’t have to be this way exactly, it can be an import every couple hours as well. The goal is to just take data from a google sheet that is updated by 50+ people and just automatically import it that data to my airtable a couple of times a day.

I have tried visual Scripting sites like zapier,, Integromat,, sheetgo, chrome extensions, etc.

Thank you!