You want to use just a single Google Sheet and a single Google Sheet connector in Fivetran to ingest your data.
- Use a single Google Sheet, but create a named range that spans more rows and columns than are - or may ever be - populated
- Ensure that any new rows are added into the existing named range
- Ensure that any columns are added into the existing named range
Fivetran’s Google Sheets connector works with a ‘named range’; this named range tells Fivetran from which columns and rows to read data.
The named range doesn't just need to specify rows that currently contain data; the range can include currently blank rows that you expect to be populated in the future.
- Amending the named range (such as adding more rows or more columns into the named range) will be automatically accommodated by Fivetran; Fivetran works with the name of the named range, rather than the cells selected
- Fivetran won't sync blank rows, so you can make the named range as large as is required