| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 641 |
| Technical Name |
auto_rate_googlesheet |
| License | LGPL-3 |
| Website | https://onessbiz.com |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) |
| Lines of code | 641 |
| Technical Name |
auto_rate_googlesheet |
| License | LGPL-3 |
| Website | https://onessbiz.com |
| Versions | 18.0 19.0 |
Google Sheets Currency Rate Provider
Automatically fetch and update currency exchange rates from Google Sheets into Odoo using a secure Service Account.
Required Python Libraries
Install Required Python Packages
Before installing the module, ensure the following Python libraries are installed on your Odoo server:
pip install gspread oauth2client google-auth
These libraries are required for connecting to Google Sheets API via Service Account.
A. Install the Module in Odoo
Step 1: Install the Application
- Go to Apps → Update Apps List
- Search:
Google Sheets Currency Rateorauto_currency_google_sheets - Click Install
After installation, a new icon will appear on your Odoo dashboard.
Module successfully installed – icon appears on dashboard
B. Google Cloud Console – Create Service Account
B1. Login & Create a New Project
Go to: https://console.cloud.google.com/
B2. Create Project
B3. Enable Required APIs
Must enable:
- Google Drive API →
- Google Sheets API →
B4. Create Service Account & Download JSON Key
Important: Save the downloaded
.json file securely – you will upload it to Odoo later.
C. Prepare Google Sheets
C1. Create a New Google Sheet
Go to: docs.google.com/spreadsheets
C2. Share with Service Account (Editor)
Use the email from the Service Account (ends with .iam.gserviceaccount.com)
C3. Copy Spreadsheet ID
Copy the ID from the URL: https://docs.google.com/spreadsheets/d/THIS_IS_THE_ID/edit
D. Configure in Odoo
Upload JSON Key & Enter Spreadsheet ID
- Upload the
.jsonkey file - Paste the Spreadsheet ID
- Enter Sheet name (usually:
Sheet1) - Select Base Currency (USD, EUR, VND, etc.)
- Click Save → Test Connection
E. Run & Verify
Update Rates Manually or Automatically
Manual Update:
Click "Update Rates Now"
Automatic (Cron):
Runs daily at 2:00 AM
(Can be changed in Scheduled Actions)
Click "Update Rates Now"
Automatic (Cron):
Runs daily at 2:00 AM
(Can be changed in Scheduled Actions)
Success when:
- Rate Date = Today
- Rates updated correctly
- Status shows: Updated Today
Need Fast Support?
Contact me directly on WhatsApp/X:
WhatsApp: +84 394 716 818
X: Onessbiz
Please log in to comment on this module