Google Sheets tool common issues

Here are some common errors and issues with the Google Sheets tool 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 tool.
2. The AI Transform tool. For example, try entering something like:

   Convert 'languages' array to JSON (key, value) pairs.
3. The Code tool.

Column names were updated after the tool's setup

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

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

Once the column names refresh, update the tool parameters.