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

[Grace78]

Automate CSV imports into Airtable using Zapier, scheduling triggers 3-4 times daily, connecting NetSuite, configuring actions for CSV fetch and import, and regularly testing and monitoring the process.
If you want to know about NetSuite Integration read this Blog at Ledger Labs