Google Sheets

Read, write, and manage data in Google Sheets spreadsheets. In Appbricx, your workflows and server functions call it by name once it is connected.

Connect Google SheetsFull reference

What you can do

21 actions, each one call from a workflow or a server function. Triggers come from your app: a row changing, a schedule or a webhook.

  • Clear Sheetclear_sheet
    Clears all rows on an existing sheet.
  • Find Rowsfind_rows
    Look up rows in a worksheet based on a column value.
  • Add Rowinsert_row
    Add a new row of data to a specific spreadsheet.
  • Update Rowupdate_row
    Update the data in an existing row.
  • Copy Worksheetcopy-worksheet
    Creates a new worksheet by copying an existing one.
  • Create Spreadsheet Columncreate-column
    Creates a new column in a specific spreadsheet.
  • Create Spreadsheetcreate-spreadsheet
    Creates a blank spreadsheet.
  • Create Worksheetcreate-worksheet
    Create a new blank worksheet with a title.
  • Delete Rowdelete_row
    Delete a specific row from the selected sheet.
  • Delete Worksheetdelete-worksheet
    Permanently delete a specific worksheet.
  • Export Worksheetexport_sheet
    Download a worksheet as a CSV or TSV file.
  • Get Single Row by IDfind_row_by_num
    Retrieve a specific row using its unique ID.

All 21 actions with their inputs

Set it up

About two minutes, once per project or once for the whole workspace.

  1. Open Integrations in the builder

    Backend panel, Integrations tab, then Google Sheets. To connect it for every project, use Workspace settings, Integrations.

  2. Sign in to Google Sheets

    You sign in to Google Sheets and approve access. Appbricx keeps the tokens, encrypted, and refreshes them.

    • https://www.googleapis.com/auth/spreadsheets

    This uses an OAuth app: the platform's, or your own from the admin panel, and you can bring your own credentials.

  3. Call an action

    From a workflow, by integration id and action name. The call answers with success, output and, when it fails, the reason.

    Workflow
    // .workflow.js (native ctx)
export async function run(ctx) {
  const res = await ctx.integrations.invoke("google_sheets", "clear_sheet", {
    "spreadsheetId": "<spreadsheetId>",
    "sheetId": "<sheetId>",
    "is_first_row_headers": true,
    "headerRow": 1
  });
  if (!res.success) throw new Error(res.error);
  ctx.log.info("Google Sheets answered", { output: res.output });
}

Google Sheets and its logo are trademarks of their owner, shown only to identify the service this integration connects to. Their use does not imply endorsement by, or affiliation with, that company.

Connect Google Sheets once. Every workflow can use it.

Start freeAll integrations