I have successfully connected google sheets to our odoo implementation in the past, and use the data to drive formulas in other sheets. Lately, the connected sheets give an error:
Exception: Request failed for http://URL returned code 404. Truncated server response: {"jsonrpc": "2.0", "id": 1, "error": {"code": 404, "message": "404: Not Found", "data": {"name": "werkzeug.exceptions.NotFound", "debug": "Tracebac... (use muteHttpExceptions option to examine full response) (line 315).
Troubleshooting steps I have performed:
Disconnect google drive, re-enter authentication
create new sheet through odoo menu
connect to personal google drive account instead of business account
tried using admin login credentials in sheet settings.
Any assistance would be greatly appreciated!
In case anyone else runs into this, I believe I have resolved the issue.
It appears that leaving a "/" after entering the url in the settings was the issue. The spreadsheet was attempting to access "url:port//web/session/authenticate" instead of "url:port/web/session/authenticate"
I will post more information if another issue pops up.