Skip to content

Google Sheets node common issues#

Here are some common errors and issues with the Google Sheets node and steps to resolve or troubleshoot them.

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:

  1. The Split Out node.
  2. 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.