Choose a spreadsheet from Google Drive and refresh each tab as a warehouse table.
Google Sheets ingestion imports every spreadsheet tab as a warehouse table. Google OAuth and the native Google Picker let you choose exactly which spreadsheet Embrasure can access.
Start a Google Sheets connection in Embrasure and sign in with the Google account that can access the spreadsheet. Embrasure requests drive.file, which limits access to files you explicitly choose for the app instead of granting access to all of Google Drive.
Google Picker opens with Google Sheets from My Drive and Shared drives. Select one spreadsheet to connect it. The first row of each tab becomes normalized column names, and the remaining rows become table records.
The table picker shows the spreadsheet title and ID above its tabs. Embrasure records both the spreadsheet ID and Google's stable numeric tab ID, so renaming a tab does not create a different source table or break its existing sync.
Embrasure checks the spreadsheet hourly. When a tab changes, it rereads that tab as a complete snapshot. Managed sheet-version and row-number columns provide the incremental checkpoint and primary key. Rows removed from the sheet are removed from the warehouse snapshot on the next refresh.
Each Google Sheets connector gets its own destination-table prefix. This keeps tabs with the same name in different spreadsheets distinct when they sync into the same warehouse database.
If verification fails, reconnect Google Sheets with an account that can open the spreadsheet or choose a different spreadsheet.