DEV Community

Keep your SQL database in sync with Google Sheets

jorin on October 27, 2018

This is basically a README but oh well it might be useful to someone. I created googlesheets-sql-sync to let users manually insert data using Goog...
Collapse
 
mike_seekwell profile image
Mike

This awesome! I actually dealt with this problem a ton in the past and decided to create a product around it. SeekWell (seekwell.io/) does a lot of this stuff for someone that wouldn't want to fool with JAR's, etc. Nice work!

Collapse
 
jorinvo profile image
jorin

Nice!
For us the main reason to do this ourselves was to not go through yet another SaaS ETL service for such a little and specific task. But for more complex use cases, it's definitely a good idea to consider one of the many automation and ETL solutions out there.

Collapse
 
binarypatrick profile image
BinaryPatrick

This is such a hack. Kudos

Collapse
 
nebojsac profile image
Nick Cinger

Such an interesting way to use google docs - I think this can actually be very useful for giving non-tech people to specific database tables. Thanks for sharing!