---
title: "Google Sheets"
canonical: "https://layest.com/en/integrations/google-sheet"
language: "en"
description: "Google Sheets is a browser-based spreadsheet application. Teams can analyze data with formulas and charts and work in the same spreadsheet simultaneously."
---

# Google Sheets

Google Sheets is a browser-based spreadsheet application. Teams can analyze data with formulas and charts and work in the same spreadsheet simultaneously.

## Authentication

**OAuth 2.0**: Authorize Layest on the provider’s sign-in page. The provider issues access tokens for the permissions you grant.

## Categories

- Other

## Actions from Google Sheets

These supported actions can be set up out of the box and used by our agents.

- **Append values to spreadsheet**: Append values to the end of a spreadsheet table
- **Batch clear values**: Clear values from one or more ranges in a spreadsheet, preserving formatting
- **Batch clear values by data filter**: Clear values from ranges matching data filters, preserving formatting
- **Batch get values**: Get values from multiple ranges
- **Batch get values by data filter**: Get values from ranges matching data filters
- **Batch update spreadsheet**: Apply multiple updates to a spreadsheet in a single request
- **Clear values**: Clear values from a range, preserving formatting
- **Copy sheet**: Copy a sheet to another spreadsheet
- **Create column**: Insert a new column into a sheet
- **Create spreadsheet**: Create a new spreadsheet
- **Create spreadsheet row**: Insert a new row at a given index in a Google Sheet
- **Delete worksheet**: Delete a worksheet by name from a Google Spreadsheet
- **Get spreadsheet by data filter**: Get spreadsheet data matching data filters
- **Get values**: Get values from a spreadsheet range
- **Search developer metadata**: Search developer metadata by criteria
- **Update conditional format rule**: Update or move a conditional format rule
- **Update values**: Update values in a spreadsheet range
- **Upsert row**: Append or update a row of values in a Google Sheet

## Triggers from Google Sheets

Once configured in Nango, these sync templates can provide changes as triggers.

- **Rows**: Sync worksheet rows from a Google Sheet
- **Worksheets**: Sync worksheets from a Google Sheets spreadsheet
