With Sheetgo, you can connect your Odoo account directly to Google Sheets using the API Connector. This allows you to automatically retrieve business data such as sales orders, invoices, customers, products, inventory levels, accounting records, and CRM opportunities into a spreadsheet. Instead of manually exporting CSV files from Odoo, Sheetgo uses Odoo’s REST API to pull live data into Google Sheets on a scheduled basis. This helps finance, operations, and sales teams centralize reporting, build dashboards, monitor KPIs, and make faster data-driven decisions while keeping everything automatically updated.
Prerequisites
Odoo account with API access enabled
Odoo database name
Odoo user login (email/username)
Odoo password or API key (depending on your Odoo version)
Odoo External API documentation: https://www.odoo.com/documentation
Odoo developer/API reference: https://www.odoo.com/documentation/latest/developer/reference/external_api.html
Sheetgo account (logged in with the same email associated with Odoo)
Sheetgo API Connector documentation: https://support.sheetgo.com/en/articles/8529746-how-to-connect-an-api-to-a-spreadsheet
Step 1: Identify the Required API Endpoint
To retrieve data from Odoo, you first need to determine which model (dataset) you want to extract. Odoo uses model-based endpoints such as res.partner for customers, sale.order for sales orders, account.move for invoices, and product.product for products.
Visit the Odoo External API documentation linked in the Prerequisites and locate the model corresponding to your required data. Odoo commonly uses JSON-RPC endpoints, typically structured like this:
https://your-odoo-domain.com/jsonrpc
Inside the request body, you specify the model and method such as search_read to retrieve records. Review the documentation linked in the Prerequisites to confirm the correct model name and available fields before proceeding.
Step 2: Generate API Credentials
To authenticate with Odoo’s API, you need your database name, username, and password or API key. In Odoo, go to your user profile settings and generate an API key if your version supports it. If not, you can use your login password for authentication.
Odoo authentication requires sending login credentials through the JSON-RPC endpoint using the authenticate method. After successful authentication, Odoo returns a user ID (uid), which is required to make further API calls.
If your Odoo environment supports OAuth2 authentication, follow the credential generation instructions in the documentation linked in the Prerequisites to obtain your Client ID, Client Secret, and Refresh Token. Keep your credentials secure, as they will be used inside the Sheetgo header configuration.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
Log in to Sheetgo and create a new workflow. Select HTTP Request as the source, as explained in the Sheetgo documentation linked in the Prerequisites.
Enter your Odoo JSON-RPC endpoint URL:
https://your-odoo-domain.com/jsonrpc
In the Headers section (Advanced editor), insert the following JSON structure that includes OAuth2 authentication with refresh token and pagination configuration:
{
"Content-Type": "application/json",
"@auth": {
"auth_method": "oauth2",
"auth_type": "Bearer",
"refresh_url": "https://your-odoo-domain.com/oauth2/token",
"refresh_params": {
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET",
"refresh_token": "YOUR_REFRESH_TOKEN",
"grant_type": "refresh_token"
}
},
"@pagination": {
"type": "offset",
"offset_param": "offset",
"limit_param": "limit"
}
}Make sure your JSON request body specifies the correct model and fields according to the Odoo documentation linked in the Prerequisites.
Step 5: Choose the Destination Spreadsheet
After configuring the API request, click Next in Sheetgo and choose your destination. Select an existing Google Sheet or create a new one where the Odoo data will be stored. You can organize different datasets into separate tabs, such as one tab for customers, another for invoices, and another for sales orders.
This step allows you to centralize operational data from Odoo into a structured reporting environment that your team can easily access and analyze.
Step 6: Execute the Sheetgo Connection
Click Finish and run the workflow. Sheetgo will send the request to Odoo and import the returned JSON data directly into your selected Google Sheet.
You can then schedule automatic updates to keep your spreadsheet synchronized with Odoo data. This eliminates manual exports and ensures your reports always reflect real-time information.
By integrating Odoo with Sheetgo’s API Connector, businesses gain automated reporting, improved visibility across departments, reduced manual workload, and better decision-making powered by live ERP data.