- Overview
- Prepare your Spreadsheet in Google Sheets
- Add your Spreadsheet to Sheety
- Configure Authentication in Sheety
- Create an Integration Configuration in PixieBrix
- Performing Spreadsheet Operations in PixieBrix
Overview
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:
- Create a Sheety Account
- Prepare your Spreadsheet
- Add your Spreadsheet to Sheety
- Configure Authentication
- Create a Integration Configuration in PixieBrix
- Use the
HTTP Request
Brick to make spreadsheet requests
Prepare your Spreadsheet in Google Sheets
Follow Sheety’s documentation to Prepare your spreadsheet
Add your Spreadsheet to Sheety
Follow Sheety’s documentation to Add your spreadsheet to a project
Configure Authentication in Sheety
Follow Sheet’s documentation to set up Authentication
Create an Integration Configuration in PixieBrix
Create a Sheety
Integration Configuration in PixieBrix. See for information on configuring integration:Integrations Guide
For Token, provide the token you set in the “Configure Authentication in Sheety” step:
Performing Spreadsheet Operations in PixieBrix
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.