How to Integrate NotebookLM with Google Sheets

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

1. Inside your spreadsheet, navigate to the top menu bar and click File.
2. Hover over the Download option and select your preferred file format — PDF or HTML is recommended to avoid compatibility issues.
3. Configure the export settings and click Export in the top-right corner to save the file.
4. Head back to NotebookLM and click Create New to start a fresh notebook.
5. Click Choose File and select the newly downloaded spreadsheet to upload it as a source.
6. Once complete, your notebook will be integrated with Google Sheets and the imported spreadsheet will be available as a queryable data source.