Odoo Development
Google Drive Contact Sync | Odoo Google Sheets Integration | Google Sheets Contact Sync
by Wan Buffer Services https://wanbuffer.com
Odoo
$ 23.29
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Discuss (mail) |
| Lines of code | 421 |
| Technical Name |
wb_contact_sync |
| License | OPL-1 |
| Website | https://wanbuffer.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Discuss (mail) |
| Lines of code | 421 |
| Technical Name |
wb_contact_sync |
| License | OPL-1 |
| Website | https://wanbuffer.com |
| Versions | 17.0 18.0 19.0 |
Days Free Support
365
Custom Apps
50+
Happy Customers
254+
Year Of Experience
7+
countries
20+
Industries Served
12+
Odoo Implementation
200+
Branches
4
Community
Enterprise
Odoo.sh
Google Sheets Contact Sync
Seamlessly sync Odoo contacts with Google Sheets and Google Drive featuring bulk sync, manual controls, and auto-scheduling.
Features
1) Go to the Google Cloud Console and create a project
2) Click on New Projects
3) Add Projects name and click on create button.
4) Click on APIs Services.
5) Now select Library Section.
6) Scroll Down and find Google Drive API & Google Sheets API.
7) Click on the Enable button to enable Google Drive API.
8) Click on the Enable button to enable Google Sheets API.
9) Now Click on Credentials from left side Menu.
10) Click on the Create Credentials button.
11) Select OAuth client ID from the dropdown menu.
12) we have to Configure Consent Screen.
13) Click on the Get started button.
14) provide App name & Email and click on the next button.
15) Select on External Button and click on the next button .
16) Provide Email Address And click on the next button.
17) select policy check box and click on Continue button and last click on create button.
18) Back to dashboard and click on the create credentials button and select type OAuth Client ID and choose application type Desktop app and click create button.
19) Download json file and click on Ok button.
20) We have to add test user also go to the Audience section scroll down and click on add users button and provide email id.
21) Your json file look like this.
22) Go to Odoo and install Google drive contact sync module.
23) Add Clint ID and Client Secret from your json file and save then click on Authorize Button.
24) Choose your google account to get access.
25) Click on continue button.
26) Click on Select all checkbox and then click on Continue button.
27) Copy your Full URI including localhost.
28) Add that Url in Authorization code field and save than click on Exchange code for Token button.
29) Go to your Google Drive and create new folder and copy that folder Id from url.
30) Paste folder ID in Folder ID field and save button and if you have already some contacts so click on sync unsynced contacts button to sync all contacts in Google Drive folder .
31) Now you can see your synced Contact sheet in your Google Drive folder, Day wise created.
32) You can also sync any selected contact by Sync button from list view.
This module provides a robust, seamless integration between Odoo and Google Sheets/Drive, allowing you to easily synchronize contacts, maintain a clean sync history, and access the sheet directly.
Yes, it features an Automated Daily Batch Sync powered by Odoo's Cron scheduler, which synchronizes updates daily. You can also customize the sync frequency from Odoo's Scheduled Actions.
Yes! The module offers a One-Click Manual Sync directly from the Odoo general settings page. You can also use the Instant Bulk Sync action directly from the Contacts tree/list view.
Yes, a Direct External Link button is available directly in the Odoo settings page, allowing administrators to open the mapped Google Sheet with a single click.
The "Reset Sync History" action clears the existing synchronization timestamps/mapping data. This is useful for starting a fresh integration cycle without duplicate records.
Our Services
Odoo Customization
Odoo Consultancy
Odoo Implementation
Odoo Migration
Odoo Training
Odoo Integration
WhatsApp
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module