Google Drive

Reads CSV, Excel, and Google Sheets files from Google Drive.

Go to Data → Add → Google Drive, pick OAuth.

Approve the Drive scope. Flitch only sees the files you pick in the next step.

Use the Drive picker.

Each picked file becomes a dataset.

For production setups with a dedicated identity.

Google Cloud Console: IAM & Admin → Service Accounts → Create service account.

For the service account's project.

Open the Drive folder, Share, add the service account email (name@project.iam.gserviceaccount.com) with Viewer access.

Go to Data → Add → Google Drive, pick Service account, paste the JSON key, pick the shared folder.

Folders

Pick a folder to pull every CSV, Excel, and Google Sheets file inside it. New files are picked up on the next refresh. Other types are skipped.

Type	Notes
CSV	Auto detect delimiter and headers.
Excel `.xlsx`, `.xlsm`, `.xls`, `.xlsb`	Each sheet becomes a dataset.
Google Sheets	Exported as XLSX. Each sheet becomes a dataset.

Drive datasets refresh on the schedule you set. Each refresh re-reads the file. See Refresh.

Scope: drive.file. Flitch only sees files you pick in the Drive picker (or files inside a folder you pick).

File not found after rename. Renames are fine (tracked by file id). Moving to a new owner is not. Re-pick the file if the original owner left.

Permission denied. Tokens revoked or sharing tightened. Reconnect from the connection's edit panel.