Re: Create script to delete records and then import csv on a schedule

383 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Looking for help with my base. I want to automate importing a csv on a schedule into Airtable. Currently, I have to delete all of the records in my table, export and import a new csv from NetSuite, and then the rest of the base does the work. How do I automate this? My goal is to have this run 3-4 times daily.

3 Replies 3

are you going to use scripts or try to do it via automation? What’s the purpose of delete record action? Maybe you can use additional table for import and/or do the update existing / create new?

4 - Data Explorer
4 - Data Explorer

I think I will have to use scripts. The delete record is necessary because if I try to import and merge records, the records duplicate because of the linking from table to table. And my knowledge of this isn’t perfect either as I did not design/build the base.

Hi Derek ,
I can help you achieve the automation needed.
Please connect further to discuss


Airtable Expert | S: deepvyas71 | E: