Google Sheets

​

Exports

import {
  googleSheets,
  googleAccount,
  getGoogleSheetsApi,
} from "automate.ax/google-sheets"

• googleSheets contains the packaged Google Sheets actions and triggers.
• googleAccount("name") selects a named Google connection.
• getGoogleSheetsApi creates the authenticated Google Sheets API helper for a custom account-backed action.

​

Triggers

• On cells changed

​

Actions

• Append rows
• Append values
• Clear range formatting
• Clear values
• Create banded range
• Create conditional format rule
• Create sheet
• Create spreadsheet
• Delete banded range
• Delete conditional format rule
• Delete rows
• Delete sheet
• Delete table
• Duplicate sheet
• Find and replace
• Find rows
• Format range
• Get rows
• Get spreadsheet
• Insert rows
• List rows
• Move conditional format rule
• Read values
• Sort range
• Update banded range
• Update conditional format rule
• Update rows
• Update sheet
• Update spreadsheet
• Update table
• Upsert rows
• Write values