Google Sheets

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.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 });
   }

More in Productivity

• Airtable
• Asana
• Calendly
• ClickUp
• Google Calendar
• Google Contacts
• All of Productivity