SheetBase Pro

Interact with SheetBase Pro backend (Code analysis + Google Sheets storage)

SheetBase Pro

AI-generated

Summary

Perform code analysis and manipulation operations on JavaScript/HTML/CSS source code or interact with the SheetBase backend database for managing sheets, projects, files, and webhooks.

Inputs

  • mode (required) — Select operation mode: 'Code Client' to analyze and manipulate code or 'Database (SheetBase)' to perform SheetBase backend actions.
  • codeAction — When in 'Code Client' mode, choose the code-related operation such as listing functions, searching code, updating or deleting code ranges, extracting or assembling code blocks.
  • language — Specify the language for code operations, with an auto-detect option.
  • codeField — Input field name containing the source code to analyze or manipulate (default 'code').
  • functionOutput — For 'listFunctions' action, choose output detail (metadata only or full code).
  • functionName — For 'getFunction' action, specify the function name to retrieve.
  • searchMode — For 'search' action, specify search by keyword or line range.
  • keyword — Keyword to search for in code when search mode is 'keyword'.
  • maxResults — Maximum number of results to return for search operations.
  • startLine — Start line number used for range-based search, update, or delete operations.
  • endLine — End line number used for range-based search, update, or delete operations.
  • replacementCode — Replacement code snippet used when updating a code range.
  • blocksField — Field containing code blocks data to assemble into full code.
  • dbAction — When in 'Database' mode, select the backend action such as managing sheets, rows, projects, files, or webhooks.
  • sheetName — Name of the sheet for sheet-related database actions.
  • rowNumber — Row number to delete when deleting a row.
  • cellRow — Row number of the cell to set.
  • cellColumn — Column number of the cell to set.
  • cellValue — Value to set in the specified cell.
  • limit — Limit the number of rows returned when getting sheet data.
  • newSheetName — Name for new sheet creation.
  • columns — Comma-separated list of column names for new sheet creation.
  • rows — JSON array of rows to append to a sheet.
  • projectId — Project ID for project/file related actions.
  • userEmail — User email for API key generation or project listing.
  • fileName — File name when saving or loading files.
  • mediaType — Media type (MIME) when saving files, default 'text/plain'.
  • fileContent — Base64-encoded file content when saving a file.
  • metadata — JSON metadata for saving a project.
  • package — JSON package data for saving a project.
  • webhookName — Name for webhook creation.
  • webhookUrl — URL for webhook creation.
  • eventType — Event type for webhook creation.
  • targetSheet — Target sheet for webhook event filtering.
  • filters — JSON filters applied when creating a webhook.
  • headers — JSON headers for webhook requests.
  • webhookId — ID of webhook to delete.

Output shape

a list of JSON objects representing the operation results for each input item

Output shape varies depending on mode and chosen action; code operations return code analysis or manipulation results; database operations return SheetBase backend responses. Errors include success=false and error details if 'Continue On Fail' is enabled.

Examples

Example 1: List functions in JS code

mode='code', codeAction='listFunctions', codeField contains source code, language='javascript' or 'auto' to detect.

Example 2: Get sheet data from SheetBase database

mode='database', dbAction='getsheetdata', sheetName specifies the sheet, limit optional.

Links

Discussion