How to update existing rows when importing CSV files with Make automation

Typically, importing data adds all rows as new, even if they exist. Ideally, we should update existing rows using key values like the primary field. This involves updating files during the import process, preventing row duplication, and ensuring data integrity. Follow these steps:

  • Set up your Baserow database
  • Configure table structure
  • Create a database token
  • Add a CSV module to import data
  • Add Baserow module to list rows
  • Add the Baserow module to update existing rows
  • Test and schedule the Make scenario

Here is the detailed guide.

1 Like