SheetDB connector for Okou
Connect SheetDB to read, search, append, update, delete, and manage data in Google Spreadsheet JSON APIs.
Docs & knowledge · API Token or Basic Authentication
Use SheetDB in Okou
SheetDB (SheetDB.io) Google Spreadsheet JSON API for reading, searching, appending, updating, deleting, importing, and managing spreadsheet sheets.
Once connected, supported SheetDB actions can become steps in a reusable workflow alongside the other services your team uses. Run the workflow once, on a schedule, or when an event starts it.
What you can do with SheetDB
- Read spreadsheet rows, column names, document metadata, cell values, row counts, and available sheets.
- Search spreadsheet rows with all-match or any-match queries and the documented read options.
- Append one or more rows to a selected spreadsheet sheet.
- Import JSON rows into an empty spreadsheet or append them to a selected sheet.
- Update rows matching a column/value query or apply the paid batch-update endpoint.
How the SheetDB connector works
A connected service becomes one permissioned step in the work you hand off.
- 1
Connect SheetDB
Choose API Token or Basic Authentication.
- 2
Choose the work
Use only the supported actions your workflow needs.
- 3
Run it your way
Start it once, schedule it, or attach an event trigger.
Connect SheetDB securely
Use the connection method that fits your account and grant only the access the workflow needs.
- API Token or Basic Authentication
Connector access is controlled per service and per action, so a workflow does not need broader access than the work you ask it to do.
What SheetDB covers
The topics this connector's published operations touch.
- spreadsheets
- google sheets
- database
- data automation
- rest api
SheetDB connector questions
- What can Okou do with SheetDB?
- Connect SheetDB to read, search, append, update, delete, and manage data in Google Spreadsheet JSON APIs. Documented actions include: Read spreadsheet rows, column names, document metadata, cell values, row counts, and available sheets. Search spreadsheet rows with all-match or any-match queries and the documented read options.
- How do I connect SheetDB to Okou?
- Connect SheetDB using API Token or Basic Authentication. The connection controls which supported actions a workflow can use.
- Can SheetDB run in an automated workflow?
- Yes. After it is connected, supported SheetDB actions can run in reusable Okou workflows on demand, on a schedule, or from an event trigger.
More docs & knowledge connectors
Explore other connectors in the same product category.
Showpad
Connect Showpad to read users, content assets, and tags through the v4 API.
Semantic Scholar
Connect Semantic Scholar to search scientific papers, inspect authors and citation graphs, retrieve paper metadata, and find relevant text snippets.
Sign.Plus
Connect Sign.Plus to create, send, track, and download electronic-signature envelopes, manage templates, and configure webhooks.
