| Technical Name |
cr_odoo_to_sheets_connector
|
| License | OPL-1 |
Odoo To Google Sheets Connector
Overview
The Odoo to Google Sheets Connector bridges Odoo and Google Sheets, enabling smooth data flow between the two platforms. With this tool, users can effortlessly push essential Odoo into Google Sheets for quick analysis and team collaboration. The connector also allows updates in Google Sheets to sync back to Odoo, ensuring all records are kept accurate and up-to-date.
With this connector, Odoo records are mapped to Google Sheets. Users can choose to sync data automatically at intervals or manually when needed, eliminating repetitive data entry and speeding up reporting tasks. This connector empowers teams to analyze, report, and share data efficiently, providing better insights for decision-making and simplifying business operations
Logs are also generated in Odoo to track all sync actions and monitor the performance of data transfers. These logs help users keep track of the connector’s operations, including any successful updates or errors, providing transparency and aiding in troubleshooting. The logging system ensures that all records and sync activities are logged for future reference, enabling better audit trails and accountability.
Hot Features
Features
Odoo To Google Sheets Connector
- Navigate to Odoo To Sheets .
- Navigate to Google Sheet Connector .
- Click on New.
- Click on button Generate Token to generate Authentication Token.
- Click on button Generate App Script to generate App Script to connect with Google Sheet.
- Generated App Script is Attached in chatter .
- Copy the Generated App script content .
- Navigate to Google Sheets >> Extensions >> App Script .
- Navigate to Code.gs >> here Past the Copied App Script.
- Navigate to Triggers >> Click on button Add Trigger >> save .
- Navigate to Google Sheet >> Odoo Connector >> Set Url And Token .
- Here Add the URL And Authorization Token generated from Odoo
- Navigate to Google Sheet >> Select Tables and Fetch Data .
- Select The table of which you want to fetch the data >> click on button Fetch Data
- The Imported Data Can Be found in Sheet.
- Navigate to Google Sheet >> Send data to odoo .
-
Select The table that you want to export to odoo >> click on button
Export
data
- The Exported Data Can Be found in Odoo.
- Navigate to Google Sheet >> Set up Automatic refresh .
- Enter the Hours in which You want to Automatically fetch data from odoo to Sheets.
-
Select The table that you want to export to odoo >> click on button
Export
data
- Navigate to Google Sheet >> Refresh Now to fetch records from odoo to sheets .
- In Odoo Navigate to Odoo To Sheets >> Data Processing Logs .
- Transaction logs for syncing tables between Odoo and Google Sheets are available here.
Our Services
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & On-Premise) as well as Community.
- No, this app will not work for Odoo Online.
- Please contact us on [email protected]
- Yes, we give free support when you buy these app for 60 Days.
- Yes, you need to pay different prices of app version wise.
- You can raise a Ticket on [email protected] we'll get back to you with fixes.
Our Services
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.