GS
Data integration
Extables + Google Sheets
Import sheets as tables, refresh them any time, export tables to Sheets and add rows from automations.
Works nowWhat you can do
Works today
- Import any tab of a Google Sheet as a new table (field types detected)
- Refresh an imported table from its sheet in one click
- Export a table or view to a new or existing spreadsheet
- Automation: add a row to a sheet whenever a record is created or matches conditions
How to set it up
- Super admin (once): in Google Cloud Console create an OAuth client (Web application), enable the Google Sheets API, add the redirect URI shown in Admin β Integrations β Google Sheets, then paste the Client ID and secret there.
- Each person: in a base choose + Add or import β Import from Google Sheets β Connect Google account.
- Paste a sheet link, pick the tab and import β or use Export to Google Sheets from a table menu.