Skip ke Konten
Pertanyaan ini telah diberikan tanda
googleoauthspreadsheets
1 Balas
2635 Tampilan
Avatar
Yoann Guirimand

Hello, Odooers

On Odoo 15, I'm trying to export data to Google spreadsheet as detailed in this link: https://www.odoo.com/fr_FR/blog/voyager-5/changes-to-google-drive-and-google-spreadsheet-integrations-for-existing-odoo-versions-957

I have copied the template as detailed in the procedure, Oauth with my google credentials, inserted my URL, db_name, login, password through the Odoo>Settings menu of the spreadsheet

When I copy my formula, I get the following error: 


More details on GoogleAppsScript: 


So it looks to me an authentification error, but my url, db name, login, password are OK

Anyone already faced this issue ? Any ideas how to solve it ?


Avatar
Buang
Avatar
Yoann Guirimand
Penulis Jawaban Terbai

Hi everyone,

So I have found the solution and put the details here for the record, in case someone face the same issue one day

We should first notice that the error message isn't detailed enough and we don't know exactlyu what was the problem (but I guess it was an auth issue)

1st: Server settings:


We need to put here the complete url as it is on Odoo.sh. Our company used a redirection link (odoo.mycompany.com), which I never noticed before, and that was the first mistake

2. Database name

As surprising as it can be, there is no clear documentation where to find the database name.  

So we need to fill the complete name displayed nearby the name (but I do not see where else we can copy/paste taht on Odoo), rather that the name displayed on odoo.sh
  

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Google OAuth2 Authentication Error problem with OpenERP 7
google oauth
Avatar
0
Apr 15
6135
Google Spreadsheets Diselesaikan
google spreadsheets
Avatar
Avatar
1
Mar 15
9856
Google oauth2 activation link not required reset button ???
google oauth
Avatar
0
Mar 15
3936
Can anyone provide a detailed explanation of how to use the Google Spreadsheets module?
google v11 spreadsheets
Avatar
Avatar
Avatar
Avatar
3
Mei 22
14669
Odoo Spreadsheet category_id
google spreadsheets spreadsheet
Avatar
0
Jul 21
2362