Sync with GoogleSpreadSheets

Ask the Community
1

I’m a Japanese wine farmer developing an agricultural app with Google AppSheet. AppSheet doesn’t have a built-in ER diagram feature, so I’ve been using dbdiagram, which has been very helpful.

In AppSheet, I’m using Google Spreadsheets as my database. I’ve converted the spreadsheet to DBML using Gemini, but it’s a bit tedious to manually create the ER diagram every time.

Is it possible to automatically synchronize the spreadsheet and dbdiagram using an API or something similar?

I’m a novice when it comes to databases, so I would appreciate it if you could point out any basic mistakes I might have made.

2

Hi @kawano164,

Currently, we do not support converting spreadsheet data directly to DBML schema.

However, provided that you already obtained the DBML from somewhere else (Gemini or other AI tools), you can use our public API to update your diagram programmatically.

By combining your AI tools API to generate the dbml from your spreasheet with our public API to update your diagram’s dbml, I think it is entirely possible.

3

Thank you!

It seems possible also for person like me; unexperienced citizen developer.
I’ll try it. Thanks!