Google Sheets

Use the Google Sheets node to automate work in Google Sheets, and integrate Google Sheets with other applications. Otera has built-in support for a wide range of Google Sheets features, including creating, updating, deleting, appending, removing and getting documents.

On this page, you'll find a list of operations the Google Sheets node supports and links to more resources.

Credentials

Refer to Google Sheets credentials for guidance on setting up authentication.

Operations

• Document
  • Create a spreadsheet.
  • Delete a spreadsheet.
• Sheet Within Document
  • Append or Update Row: Append a new row, or update the current one if it already exists.
  • Append Row: Create a new row.
  • Clear all data from a sheet.
  • Create a new sheet.
  • Delete a sheet.
  • Delete Rows or Columns: Delete columns and rows from a sheet.
  • Get Row(s): Read all rows in a sheet.
  • Update Row: Update a row in a sheet.

Related resources

Refer to Google Sheet's API documentation for more information about the service.

Common issues

For common questions or issues and suggested solutions, refer to Common issues.