How Should I Define a Named Range When My Row Count Keeps Increasing?

Question

How should I define my Google Sheets named range if new rows are added regularly?

Environment

Connector: Google Sheets

Answer

If you expect the number of rows to increase, set your named range to cover the full column instead of a limited range. For example, use A:Z instead of A1:Z100. This approach ensures Fivetran automatically includes new rows without requiring you to update the named range.