Named Range Doesn't Exist Error

Question

Why do I get the error "Unable to validate named range. Named range doesn't exist" when trying to set up a new Google Sheets connector?

Answer

Newly created Named Ranges are not always available to use right away. There might be a time lag of up to 15 minutes until a newly created Named Range is available for Fivetran to read.

To solve the issue, exit the setup form, then retry the setup again in 15 minutes. Scroll to the Named Range field and click the drop-down menu to select the desired Named Range.