OpenApps Sheets

For AI assistants

Your assistant can run the roster.

Sheets has a public API with no key and no account. An assistant can set up a volunteer roster or a potluck from one sentence, sign people up, and tell you who is bringing what.

Full reference: /llms.txt. A sheet's id is its secret, like its link. The owner key and each sign-up's key come back once, so keep them private. The owner key also deletes a sheet and everything on it.

# Volunteer shifts: 9 to 5, one hour each, 3 people per shift
curl -X POST https://functions.openapps.xyz/apps/1b07970e223c44d2d70d24f6/api/sheets \
  -H 'content-type: application/json' \
  -d '{"title": "Spring fair volunteers", "timezone": "America/Chicago",
       "location": "Lincoln Elementary",
       "shifts": {"date": "2027-05-08", "from": "09:00", "to": "17:00",
                  "minutes": 60, "quantity": 3}}'

# A potluck from a list ("x3" means three people can bring it)
curl -X POST https://functions.openapps.xyz/apps/1b07970e223c44d2d70d24f6/api/sheets \
  -H 'content-type: application/json' \
  -d '{"title": "Team potluck",
       "items": ["Main dish x3", "Salad", "Dessert x2", "Drinks"]}'

# Sign someone up
curl -X POST https://functions.openapps.xyz/apps/1b07970e223c44d2d70d24f6/api/sheets/SHEET_ID/signups \
  -H 'content-type: application/json' \
  -d '{"slotId": "SLOT_ID", "name": "Sam Lee", "email": "sam@example.com"}'

# Everyone, with contact details (owner key from the first call)
curl https://functions.openapps.xyz/apps/1b07970e223c44d2d70d24f6/api/sheets/SHEET_ID/signups \
  -H 'x-owner-key: OWNER_KEY'

# Delete the sheet and everything on it (owner key)
curl -X DELETE https://functions.openapps.xyz/apps/1b07970e223c44d2d70d24f6/api/sheets/SHEET_ID \
  -H 'x-owner-key: OWNER_KEY'

Back to Sheets