Comment on page
Sheety: Sharing Google Sheets without Google Workspace
Sheety is a web service for securely making Google Sheets via API without users requiring a Google Account.
Benefits of using Sheety with PixieBrix:
- Mod users do not need a Google Account
- Authentication per sheet
- Access control per sheet: read/write/add/delete
To use Sheety to serve content for PixieBrix, you will:
- 1.Create a Sheety Account
- 2.Prepare your Spreadsheet
- 3.Add your Spreadsheet to Sheety
- 4.Configure Authentication
- 5.Create a Integration Configuration in PixieBrix
- 6.Use the
HTTP RequestBrick to make spreadsheet requests
Create a
Sheety Integration Configuration in PixieBrix. See Configuring Integrations for information on configuring integration:
.png?alt=media&token=de9ff76b-1493-41ca-b456-0cacf6876e74)
Selecting the Sheety Integration
For Token, provide the token you set in the “Configure Authentication in Sheety” step:
.png?alt=media&token=71c0eb91-0a1d-4e35-adf1-c0a2fb1942cc)
Configuring the Sheety Integration
To read/write/add/remove to your sheet, use the
HTTP Request brick. See Sheety’s documentation on Making requests to determine the URL and request parameters/data..png?alt=media&token=511cf88f-ec52-4a01-b52c-edf4fa6a6646)
Retrieving rows from a Google Sheet with the Sheety API