When setting up a new Google Sheets connector, the following error appears: Unable to validate named range. Named range doesn't exist.
Connector: Google Sheets
If you have not created a Named Range, you need to explicitly define a Named Range.
- Go to your Google Sheet
- Click on Data > Named ranges
- Click on Add a range
- 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.
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.