Saviba License Delivery with Google Sheets

Description

Saviba License Delivery with Google Sheets maps each product SKU to a Google Sheet tab.
When an order is completed, the plugin reserves the first available row, stores the delivery data in the order, shows it to the customer, and marks the row as sold.

The plugin uses a Google service account JSON credential because it needs permission to read and update the sheet.

External Services

This plugin connects to the Google Sheets API only after the site administrator enters a Google service account JSON credential and a Google Sheet ID in the plugin settings.

The plugin sends requests to https://sheets.googleapis.com/ to read and update spreadsheet rows, and to https://oauth2.googleapis.com/token to request an OAuth access token for the configured Google service account.

Data sent to Google can include the configured spreadsheet ID, sheet tab names, selected row values, store order IDs, and the Google service account credential provided by the administrator. The plugin does not send this data to Saviba or to any server controlled by the plugin author.

Google API terms: https://developers.google.com/terms
Google privacy policy: https://policies.google.com/privacy

Sheet Format

Default range: D2:K

Delivery columns are configurable in Settings > Saviba License Delivery with Google Sheets.
Default delivery columns: D,E,F,G,H,I.
Enter any columns separated by commas, such as D,F,H or D,G,K,M.

The status and store order ID columns are configured separately.
The plugin automatically reads a range that includes the selected delivery, status, and order ID columns.

Optional column labels can be configured in Settings > Saviba License Delivery with Google Sheets.
For example, set D to Account or F to TOTP.
Blank labels keep the original cell text unchanged.

Empty status cells are treated as available.
The plugin writes reserving while processing and sold after delivery is confirmed.