Google Sheets#

Use the Google Sheets node to automate work in Google Sheets, and integrate Google Sheets with other applications. n8n 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.

Templates and examples#

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.

What to do if your operation isn't supported#

If this node doesn't support the operation you want to do, you can use the HTTP Request node to call the service's API.

You can use the credential you created for this service in the HTTP Request node:

In the HTTP Request node, select Authentication > Predefined Credential Type.
Select the service you want to connect to.
Select your credential.

Refer to Custom API operations for more information.