Docs and files
Google Sheets + Pilot
Use the numbers in your Google Sheets as cited sources in reports, briefs and answers.
What you can doWith Google Sheets connected to Pilot.
- Cite a cell or range in Research answers
- Turn a sheet into a written summary
- Fact check numbers in a draft against a sheet
- Refresh figures in recurring Autopilot reports
What it does
A lot of reporting starts in a spreadsheet. With Google Sheets connected, Research can answer questions from your own data, such as which region grew fastest last quarter, and cite the exact range it used.
In Write, point Pilot at a sheet and ask for a summary of what changed, and it writes the paragraph with the numbers linked to their cells. Fact check compares the figures in a draft against the sheet before you publish. Autopilot agents can read the same sheet every week and update the numbers in a recurring report, so the Monday metrics note is ready before the meeting.
Good to know
- Pilot reads values, not formulas, and respects protected ranges.
- Sheets referenced in a report are refreshed each time it runs.
- Very large sheets are summarised by tab. Charts and images are skipped.
Related integrations
All integrations- Google DriveSearch, cite and draft from the Docs, Sheets, Slides and PDFs your team keeps in Google Drive.Docs and files
- NotionBring your Notion wiki, specs and meeting notes into Library, and publish finished drafts as Notion pages.Docs and files
- DropboxSearch and cite the documents and PDFs stored in Dropbox, and save finished drafts back to a folder.Docs and files
Your next draft is already started
Join 14,000 teams that research, write and ship with Pilot.