On my Odoo.sh v12 production database I have created numerous Google Spreadsheet Integrations via Products with custom "=oe_browse" fetch limits ranging from 1-10,000 and columns ranging from 1-8.
For results with less than 30,000 cells, the function is almost always successful. For results with 30,000-48,000 cells, the function is occasionally successful, but often produces an error, "Internal error executing the custom function." For results with 48,000+ cells, I have found them to fail consistently with the same error. In all instances, I have found the function to fail after executing for exactly 60 seconds
Can anyone tell me what the limiting factor here is? Is this a limitation of Odoo, Odoo.sh or the Google Sheets API? Is there any way to overcome this? Thank you!