Overview
Stigg’s integration with Google Sheets allows you to export your product catalog, customer, and subscription data to a Google Sheet, with each entity group loading into its own tab — useful for quick reporting or sharing data with non-technical stakeholders.Stigg’s native data export integrations are included in the Scale plan, and are also available as an optional add-on to the Growth plan. See Stigg’s pricing for more details.
Google Sheets has a hard capacity limit of 400,000 rows or 10 million cells for the entire spreadsheet, across all tabs. If your data exceeds this, sync will fail — use a different destination for large datasets.
View the full entity schema
See every table and column exported to your destination, organized by entity group.
Setting up the integration
Prerequisites
A Google Sheet you want to sync data into (new or existing), and permission to share it.1
Share your Google Sheet
Create a new Google Sheet, or open an existing one, in Google Drive. Click Share in the top right corner, enter the service account email address shown in the Stigg connect form, grant it Editor permission, and click Send.
2
Connect Stigg with Google Sheets
In Stigg, navigate to Integrations > Apps > Google Sheets.Click Test & connect to verify Stigg can write to the sheet.
Access is controlled entirely through Google Drive sharing — no personal credentials are required, and access can be revoked at any time by removing the service account from the sheet’s share settings.
3
Select entities to export
After entering your connection details, expand the Entities to export section to choose which entity groups to include in the sync. All groups are selected by default.See Exported entities for a description of each group.