Doe can work with spreadsheets as live workbooks, not just uploaded files. Cloud agents can read targeted ranges, create new sheets, write formulas, batch edits, format cells, create charts, validate calculations, export files, and sync changes back to Google Sheets.Documentation Index
Fetch the complete documentation index at: https://docs.doe.so/llms.txt
Use this file to discover all available pages before exploring further.
How to Start
| Starting point | What to do |
|---|---|
| Existing Excel or CSV | Upload the file in chat or the Library, then mention it with @ |
| Google Sheets | Connect Google Sheets, mention the file, and ask Doe to import or sync |
| New workbook | Ask Doe to create a spreadsheet from a prompt, dataset, or analysis |
| Messy data | Upload the source file and ask Doe to clean, normalize, and validate it |
What Agents Can Do
| Capability | Details |
|---|---|
| Read | Inspect workbook structure, sheet names, headers, ranges, values, formulas, and formatting |
| Write | Update cells, formulas, cross-sheet references, and typed values |
| Batch edit | Apply many range edits atomically instead of one cell at a time |
| Format | Set number formats, fonts, colors, alignment, borders, freezes, widths, and heights |
| Create charts | Add column, bar, line, pie, area, and scatter charts |
| Aggregate | Calculate sums, averages, counts, medians, variance, standard deviation, min, and max |
| Validate | Check formulas and cross-check calculations before finalizing |
| Export | Save CSV or XLSX outputs for download and sharing |
| Sync | Import Google Sheets as editable workbooks and push local changes back |
Preview and Editing
Spreadsheet outputs open in the preview pane. From there you can:- Review values, formulas, formatting, and charts
- Rename the workbook
- Save changes
- Undo and redo
- Export CSV or XLSX
- See Google Sheets sync status
- Open the original Google Sheet when available
Google Sheets Sync
Google Sheets workflows use a local editable copy.- Doe imports the Google Sheet into a workbook preview.
- Agents edit the local workbook with spreadsheet features.
- Doe shows pending changes and sync status.
- You can sync changes back to the original Google Sheet.
Analysis Workflows
Spreadsheets can combine with code sandboxes and connected data sources.High-Leverage Workbook Examples
| Workbook | Prompt |
|---|---|
| Financial model | Build a 3-statement model from this filing. Link statements, add 5-year projections, and include sensitivity tables. |
| Deal analysis | Create an LBO model for a $500M software acquisition with sources and uses, debt schedule, IRR sensitivity, and returns waterfall. |
| Prospecting list | Build a prospect list of 100 CFOs at Series B+ SaaS companies with company, title, source, personalization angle, and priority score. |
| Public comps | Create a public comparables table for 15 enterprise software companies with growth, margins, valuation multiples, and source links. |
| Retention cohorts | Build retention cohorts by signup source, calculate LTV by channel, chart the trends, and explain the drivers. |
Best Practices
- Tell Doe whether you want formulas or pasted values.
- Name the sheets you expect in the output.
- Ask for validation when numbers matter.
- Ask Doe to preserve the original file and save edits as a new workbook when you need a clean audit trail.
- For Google Sheets, ask Doe to explain pending changes before syncing back.
Finance Playbook
Deploy agents for metrics, models, reports, and operating reviews
Working with Files
Upload and manage spreadsheet files
Research and Code Sandboxes
Analyze data and generate spreadsheet artifacts
Sharing
Share completed workbooks with reviewers