Train your AI on Google Sheets
Connect your Google Sheets to train your AI agent on structured data. Open syncs all sheets within a spreadsheet, extracting rows as knowledge. Perfect for FAQs, product information, pricing tables, and any structured content.
Connect once, and Open automatically keeps your AI agent's knowledge up to date. When you update content in Google Sheets, the changes sync automatically—no manual retraining required.
What can be synced
Sheets — Each sheet tab within the spreadsheet is synced as a separate stream with all rows and columns.
Cell Values — All cell values including text, numbers, dates, and formulas (evaluated results).
Features
- •Sheet Sync — Sync all sheets within a spreadsheet, with each sheet becoming a separate data stream.
- •Header Detection — Automatically detects column headers and uses them as field names for structured extraction.
- •Row-based Learning — Each row becomes a knowledge entry, perfect for FAQ lists and product catalogs.
- •Named Ranges — Optionally sync specific named ranges instead of entire sheets.
Requirements
- •Google Sheets spreadsheet link
- •Read access to the spreadsheet
- •For Service Account: JSON key and sheet shared with service account email
How to connect
- 1.In Open, go to AI Training → Sources → Connect Google Sheets
- 2.Click "Authenticate via Google (OAuth)" and authorize access
- 3.Copy the spreadsheet link from your browser address bar
- 4.Paste the link and configure which sheets to sync
- 5.Optionally rename sheets or specify named ranges
- 6.Start syncing your spreadsheet data
Good to know
- Syncs from a single spreadsheet - use multiple connections for multiple spreadsheets
- First row is typically used as column headers
- Empty rows and columns are skipped
- Formulas are synced as their evaluated values, not the formula itself
- For multiple spreadsheets, use Google Drive connector instead
Common questions
Security: Open only requires read access to your Google Sheets. We never write, modify, or delete your content. All data is encrypted in transit and at rest. GDPR compliant, working toward SOC 2 Type II.
Ready to connect Google Sheets?
AI Training → Sources → Google Sheets
Other training sources
