# Sheety: Sharing Google Sheets without Google Workspace

## Overview

[Sheety](https://sheety.co/) 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 Request` Brick to make spreadsheet requests

## Prepare your Spreadsheet in Google Sheets

Follow Sheety’s documentation to [Prepare your spreadsheet](https://sheety.co/docs/spreadsheet.html)

## Add your Spreadsheet to Sheety

Follow Sheety’s documentation to [Add your spreadsheet](https://sheety.co/docs/project.html) to a project

## Configure Authentication in Sheety

Follow Sheet’s documentation [to set up Authentication](https://sheety.co/docs/authentication.html)

## Create an Integration Configuration in PixieBrix

Create a `Sheety` Integration Configuration in PixieBrix. See [Configuring Integrations](https://www.notion.so/Configuring-Integrations-519952f1528d4080acc9504039bdd1d8?pvs=21) for information on configuring integration:<br>

<figure><img src="https://2274778196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq123bF1HPQPV35s5vHa1%2Fuploads%2Fy9tjpybS6UNMzBmYEgA5%2FUntitled%20(19).png?alt=media&#x26;token=de9ff76b-1493-41ca-b456-0cacf6876e74" alt=""><figcaption><p>Selecting the Sheety Integration</p></figcaption></figure>

For Token, provide the token you set in the “Configure Authentication in Sheety” step:<br>

<figure><img src="https://2274778196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq123bF1HPQPV35s5vHa1%2Fuploads%2Fskqn7G9jGCStxJiJlQOc%2FUntitled%20(20).png?alt=media&#x26;token=71c0eb91-0a1d-4e35-adf1-c0a2fb1942cc" alt="" width="539"><figcaption><p>Configuring the Sheety Integration</p></figcaption></figure>

## 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](https://sheety.co/docs/requests.html) to determine the URL and request parameters/data.

<figure><img src="https://2274778196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq123bF1HPQPV35s5vHa1%2Fuploads%2Fn882CMuAgleYQId4SWkh%2FUntitled%20(21).png?alt=media&#x26;token=511cf88f-ec52-4a01-b52c-edf4fa6a6646" alt=""><figcaption><p>Retrieving rows from a Google Sheet with the Sheety API</p></figcaption></figure>
