Troubleshooting Google Sheets errors

When using Google Sheets as your data source, you may run across an error. In this article we help you to troubleshoot the most common error cases related to Google Sheets.

Missing data source

Mapped Google spreadsheet ‘{spreadsheet_name}’ can no longer be found.

This error can happen when your Google spreadsheet is moved to trash or deleted.

If your Google spreadsheet is moved to a place you don’t have access to, you should ask its owner to give you access to the file.

If the Google spreadsheet was deleted permanently, you will need to use an alternative spreadsheet as your data source.

Mapped Google sheet ‘{sheet_name}’ can no longer be found.

This error can be caused by the sheet being renamed or deleted.

If your sheet was renamed, you can simply rename the table back to its original name. Alternatively you can map your block(s) to the newly named sheet.

If the sheet was deleted permanently, you will need to map your block(s) to another sheet.

Mapped field ‘{column_field_name}’ can no longer be found.

This means that a column field you had mapped to your block was renamed or deleted.

If the column field was renamed, you can:

• Rename the column field back to its original name

• (Re-)map the newly named column field to your block

If the column field was deleted permanently, you will need to use another field.

Access

Access token for Google Account {account_name} is no longer valid

This error happens when the Softr access token for accessing your Google Sheets has expired. To renew the token, you need to re-authenticate Softr with your Google Account. Start in App Settings > Data Sources > Re-authenticate and follow the authentication flow.

Make sure you give Softr the right to edit your Google Sheets by checking these two boxes during the authentication flow.