I have a database with 10k rows, and I’d like to be able to edit that database in Google Sheets and/or the database.
i.e., I would like to be able to add/delete/update rows in the database, and have that show up in the spreadsheet, and vice versa.
Would Zapier be a good fit for this?
To do this, would I need to create one zap for additions, one zap for updates, and one zap for deletions, in both directions?
Yes it is doable. Depending on the frequency of these changes it can be zap consuming. We had people that ended at the support because they were surprised that syncs are heavly consuming Zaps.
So from a Zapier experts view I would say yes you can do this. As a developer I would say at a certain point think about an integration - but start and go with Zapier.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.