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.
Thank you! The particular sheet is being used and edited by so many people that I noticed all changes weren’t being pushed to airtable
I was using New or Updated Spreadsheet Row in zapier to then update the record in airtable and it missed a lot of changes. I need like a whole import of the whole .csv instead of just changes and couldnt really find that
Will try the data fetcher one above! Thank you!