[Workaround] Syncing products databases (name update, price update, delete)

How To
, ,
1

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?

image
image1544×1432 154 KB

Maybe there is some simple ways to do so that I don’t know

2

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.