I use oe_browse() to retrieve data from Odoo and everything works fine. But I would need to refresh de synchronization periodically as data on Odoo side gets updated and has to be reflected in the linked Google Sheet.
There are 2 functions in Google Sheets which are normally used for refreshing calculations:
1. Spreadsheet Settings > Calculations > Recalculation > On change and every minute: This does only work with NOW, TODAY, RAND and RANDBETWEEN functions.
2. Add NOW() to calculation like +NOW()-NOW(): This only works out with numerical calculations.
Any idea how to get this done?
I have same issue also