Google Sheets

What this connects

Report output and bulk data import to Google Sheets.

Supported workflows

• Scheduled export of sales or stock reports
• Bulk product or customer import from a prepared sheet
• Sharing figures with an accountant who works in spreadsheets

Data exchanged

• Report rows and columns
• Import records
• Sheet and tab references

Setup requirements

• A Google account
• OAuth authorisation
• A target spreadsheet and tab

Permissions required

• Read and write access to the nominated spreadsheet

Security and privacy

• Data is transmitted over encrypted connections (TLS).
• Credentials and tokens are stored server-side and never exposed to the browser.
• Access can be revoked at any time from the provider's own account settings.

Known limitations

Stated plainly, because finding these out during implementation is worse than knowing them now.

• Availability and scope are confirmed during setup for your specific configuration.