Hello makers, I have an idea of how I’m going to create this scenario to sync 2 databases. As I haven’t started it yet, I’m posting this message by curiosity to get to know how some of you would do.
In few words, I have a Google Sheet parent products database with about 550 lines. In an other side, the same database in an internal tool I had to, for some reasons, split in some kind of category.
How would you create this scenario, depending on Google Sheets as parent database?
Maybe there is some simple ways to do so that I don’t know
Hey, syncing databases could get messy quickly if not configured properly, or if you have loops.
For your description, you could start with GSheets - Watch Changes module, set up filters if needed and connect to your internal tool.
You can provide more details as necessary.
Hey Garry,
is it a one way or two way sync?
If its only Google sheets (parent) → internal tool, then have an appscript watch for changes in the sheet and call a make webhook to edit the internal tool.
If its a two way sync then, yeah, we are going to need a lot more information. You definitely need to figure out a safe guard to prevent feedback loops.
