I am looking for a way to import data using a URL that connects to a CSV and merge existing records on a recurring basis. This can be through a click of a button or the script running in the background. The CSV could also come from google sheets.
Which of the following would be easiest to automate the importing of the CSV?
- Using the Scripting block and creating a button that will trigger the CSV import app?
- The automation with run a script every hour to trigger the CSV import app?
- Google scripts on the Google sheets with the Airtable API to import the CSV?
If anyone has a built a similar script and is willing to share the script please do!
The ideal would then be to have additional columns in the base that only sit in Airtable. Due to data privacy concerns, we cannot use a third-party extension.
Thanks in advance!