2 ms·
Hey HN - We [1] released a Google Sheets Addon that uses Apps Scripts Triggers to send changes in Sheets to Postgres, Snowflake, MySQL, Redshift, etc. The basic
by mritchie712 6y ago
Hey HN - We [1] released a Google Sheets Addon that uses Apps Scripts Triggers to send changes in Sheets to Postgres, Snowflake, MySQL, Redshift, etc. The basic flow is:
1. Connect to your database in SeekWell
2. Seed the Sheet with data from your database
3. Write an UPDATE statement with Parameters [2]
4. Launch the addon in the Sheet you want to sync and click "Set up a sync" under the Run button
5. Map the column names in Sheets to the Parameter names in SeekWell (leave blank if the same)
Changes will now be sent to the update block as soon as they happen. Let me know if you have any questions! Happy to help anyone get set up.
1 - https://seekwell.io/hn https://seekwell.io/hn
2 - https://doc.seekwell.io/e18b84a0e07d42ba981a449e2e53f018 https://doc.seekwell.io/e18b84a0e07d42ba981a449e2e53f018