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

[Derek_Gavorcik]

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.

[Alexey_Gusev]

Hi,
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?

[Derek_Gavorcik]

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.

[Deep_Vyas]

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

Regards
Deep