# 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](../../credentials/google/) for guidance on setting up authentication.

## Operations

- **Document**
  - [**Create**](document-operations/#create-a-spreadsheet) a spreadsheet.
  - [**Delete**](document-operations/#delete-a-spreadsheet) a spreadsheet.
- **Sheet Within Document**
  - [**Append or Update Row**](sheet-operations/#append-or-update-row): Append a new row, or update the current one if it already exists.
  - [**Append Row**](sheet-operations/#append-row): Create a new row.
  - [**Clear**](sheet-operations/#clear-a-sheet) all data from a sheet.
  - [**Create**](sheet-operations/#create-a-new-sheet) a new sheet.
  - [**Delete**](sheet-operations/#delete-a-sheet) a sheet.
  - [**Delete Rows or Columns**](sheet-operations/#delete-rows-or-columns): Delete columns and rows from a sheet.
  - [**Get Row(s)**](sheet-operations/#get-rows): Read all rows in a sheet.
  - [**Update Row**](sheet-operations/#update-row): Update a row in a sheet.

## Templates and examples

**Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram**

by Dr. Firas

[View template details](https://n8n.io/workflows/5338-generate-ai-viral-videos-with-seedance-and-upload-to-tiktok-youtube-and-instagram/)

**Fully Automated AI Video Generation & Multi-Platform Publishing**

by Juan Carlos Cavero Gracia

[View template details](https://n8n.io/workflows/3442-fully-automated-ai-video-generation-and-multi-platform-publishing/)

**Generate AI Videos with Google Veo3, Save to Google Drive and Upload to YouTube**

by Davide

[View template details](https://n8n.io/workflows/4846-generate-ai-videos-with-google-veo3-save-to-google-drive-and-upload-to-youtube/)

[Browse Google Sheets integration templates](https://n8n.io/integrations/google-sheets/), or [search all templates](https://n8n.io/workflows/)

## Related resources

Refer to [Google Sheet's API documentation](https://developers.google.com/sheets/api) for more information about the service.

## Common issues

For common questions or issues and suggested solutions, refer to [Common issues](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](../../core-nodes/n8n-nodes-base.httprequest/) to call the service's API.

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

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

Refer to [Custom API operations](../../../custom-operations/) for more information.
