I’m looking to automate the import and export of CSV files into a couple of live DB’s. The format of each CSV will remain consistent, as will the field matching. Ideally, I’m looking to update existing records and then add new ones.
While it seems the CSV upload ability from the “Data” portion adds new records, it creates duplicates instead of updating existing rows. Also, there doesn’t seem to be a way to automate this process. I’d love to perhaps leverage Zapier to trigger the import by e-mailing it to a specific address or having it poll periodically a specifically Google Drive folder.
Additionally, with the export, I’m hoping there is a way to setup automated downloads of another DB.
Any ideas?