Quick summary
Integrating NotebookLM with Google Sheets lets you use your spreadsheet data as an AI-queryable source inside a notebook. This process involves downloading your sheet as a file and uploading it directly into NotebookLM as a new source.
Steps
- Inside your spreadsheet, navigate to the top menu bar and click File.
- Hover over the Download option and select your preferred file format — PDF or HTML is recommended to avoid compatibility issues.
- Configure the export settings and click Export in the top-right corner to save the file.
- Head back to NotebookLM and click Create New to start a fresh notebook.
- Click Choose File and select the newly downloaded spreadsheet to upload it as a source.
- Once complete, your notebook will be integrated with Google Sheets and the imported spreadsheet will be available as a queryable data source.
