Google Sheets
Read and append rows in your Google Sheet — a spreadsheet as backend. Connected with your own key — encrypted, server-side only, never exposed to the browser.
What you can build
Prompts like these, typed into opix, produce working Google Sheets features.
Connect it in three steps
Create the key
Generate an API key in your Google Sheets account — the link below takes you to the exact page.
Paste it in opix
Open your project → Connectors, paste the key. It's stored encrypted and injected server-side; even you only see the last four characters afterwards.
Prompt what you want
Describe the feature in chat — opix writes the Google Sheets code with honest fallbacks built in.
Keys & setup
| Environment variable | Required |
|---|---|
| GOOGLE_SERVICE_ACCOUNT_KEY | Yes |
| GOOGLE_SHEETS_SPREADSHEET_ID | Yes |
Create a service account in Google Cloud (IAM & Admin → Service accounts), add a JSON key and paste the whole file here. Then share the spreadsheet with the service account's email (client_email in the JSON) as Editor — without sharing, requests fail with 403/404.
Honest by default
Apps built with opix never pretend. Without keys, sheet-driven sections render a designed empty state with a connect note and write routes return 503.
Build with Google Sheets today
Describe the app, connect your key, ship it.
Google Sheets is a trademark of its respective owner, used for identification purposes only. opix is not affiliated with or endorsed by Google Sheets.