Google Drive is available as a data source via Basedash Warehouse. This allows you to sync your Google Drive data into a centralized warehouse managed by Basedash.
Organize related sheets in a dedicated folder for easier management
Ensure consistent column naming across sheets for better schema integration
Use the folder structure to maintain logical grouping of related data
Important: Only include sheets in the folder that are meant to be part of the same schema. Other files or unrelated sheets should be kept in separate folders to avoid unnecessary data syncing and potential schema conflicts.
For detailed information about the Google Drive connector, including schema information and sync behavior, see the Fivetran Google Drive documentation.