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.

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.

Append an array#

To insert an array of data into Google Sheets, you must convert the array into a valid JSON (key, value) format.

To do so, consider using:

The Split Out node.
The AI Transform node. For example, try entering something like:
1
Convert 'languages' array to JSON (key, value) pairs.
The Code node.

Column names were updated after the node's setup#

You'll receive this error if the Google Sheet's column names have changed since you set up the node.

To refresh the column names, re-select Mapping Column Mode. This should prompt the node to fetch the column names again.

Once the column names refresh, update the node parameters.