Read Data from MySql and importing to Google Spreadsheet daily

[atDesign]

Hello everyone,

I read a ton of posts but never found a solution that fits to my case.
I have a website that uses a MySql database. I linked one table of this DB to my appsheet application. I want to preserve this DB in order to not creating any problem to my website.
I would like to pull informations from this “read only DB” and put them in a google sheet where I can freely develop the application. I would like to do it automatically to every sync or daily/time dependent.

I just created all the references between my “Order MySql DB” and “Order Google Sheet”.

I was only able to create a “Sync” action that do this for me, but I have to trigger it manually and select every order.

I would like to sync everything every time there’s a new order on my Mysql DB

Is there any way???

Thanks in advance