With OPI’s Google Sheets integration, you can enjoy real-time data syncing, enabling you to combine inventory information with other software exports, formulas, and custom reporting. Follow these steps to set it up.
Navigate to Google Sheets Integration Settings: #
- Go to Settings in your OPI account and select Additional Integrations.
- Click on Google Sheets at the top to begin setup.
Click “Add Sheet” and Grant OPI Access: #
- Click Add Sheet to connect a Google Sheet.
- In your Google Sheet, click the Share button.
- Add the email specified in OPI’s instructions as an Editor and click Done
- production-sheets-service-acct@onepageinventoryprod.iam.gserviceaccount.com
- Then, copy the spreadsheet URL from your browser and paste it into OPI.
Select Channels to Sync with Google Sheets: #
- You’ll be prompted to choose which channels to sync, such as Amazon, warehouses, or additional integrations like Shopify.
- For each selected channel, a new sheet will be created within your Google Sheets file. Note that these sheets will overwrite data every time OPI syncs, so be cautious with referencing cells that may change.
Save and Sync Your Data: #
- After saving your selections, your OPI data should begin populating into Google Sheets within a few minutes. This continuous sync keeps your data up-to-date, offering real-time insights.
