Issue

When setting up a new Google Sheets connector, the following error appears: Unable to validate named range. Named range doesn't exist.

Environment

Connector: Google Sheets

Resolution

If you have not created a Named Range, you need to explicitly define a Named Range.

1. Go to your Google Sheet
2. Click on Data > Named ranges
3. Click on Add a range
4. Provide a name to the range

If you have already created a Named Range, but are still getting this error, please refer to the following troubleshooting article.

Cause

We obtain Named Ranges from your sheet. These are used to indicate the data you want your connector to process. If we do not find any Named Ranges, we cannot know which data from your whole sheet you want to import.