Help

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

Topic Labels: Scripting extentions
971 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Derek_Gavorcik
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.

4 Replies 4

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
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

Regards
Deep

Airtable Expert | S: deepvyas71 | E: deepvyas71@gmail.com
Grace78
4 - Data Explorer
4 - Data Explorer

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