Is there an easy way to update my existing index using a CSV file?
By easy I mean, no code involved.
I’m keeping a Google Sheet as my source of truth (dataset). Every now and then (twice a year) I’ll need to sync the Sheet with Algolia. I’m planning to export a CSV file and use it to update existing records and add new ones.
Yes, you can upload a CSV file to your index via the dashboard:
Note that if you want to update your existing records, the CSV file must include an objectID field and the value in the CSV must match the existing value in the index – otherwise we will create a new record rather than updating the existing one.
You may also be interested in our new Connector and Flow feature we will be debuting next week at our Developer Conference – these will help automate the process if retrieving the CSV file and mapping objectIDs.
Finally, there is a basic Zapier integration you could use for doing the attribute mapping, if you’re comfortable with stitching things together in Zapier: