Skip to content

How to Build a CEO's Second Brain from Your PDFs and Spreadsheets

In about two hours you can have an AI read your board memos and sales spreadsheets, then show you where the numbers contradict what you told the company.

The problem

Before a big decision you probably upload a few files to ChatGPT or Claude and read the summary. It is quick, but the AI forgets everything afterwards. Next week you upload the same files again and may get a different answer.

The bigger loss is the link between files. Say your August strategy memo announced a move upmarket to enterprise customers. The Q3 pipeline file shows enterprise deals now take 108 days to close, up from 61 in Q2. Your Q4 forecast still assumes 60. Each fact sits in a different file, so nobody sees that the forecast is too optimistic. (All names and numbers in this article are made up.)

The idea

Instead of re-reading your files every time you ask, the AI keeps a folder of short, linked notes about them: one for each strategic priority, key number and finding. When you add a file, it updates every note the file affects and flags anything that contradicts what you said earlier.

Notes kept by hand usually die, because keeping them current is tedious. The AI does not get bored and updates every note a file affects, so upkeep costs you almost nothing.

You choose the files, ask the questions and make the decisions. The AI does the filing.

Build it in about two hours

You need the Claude desktop app (start a task and connect your folder) or the ChatGPT desktop app (switch to Codex and add the folder as a project). Both can work directly in a folder on your computer.

The AI processes whatever you show it in the cloud. Before you copy anything in, use a business plan that keeps your data out of model training, and check your company's AI policy before you add board-confidential files.

1. Put your files in one folder

Create a folder called CEO-Brain with two empty folders inside, originals and notes. Copy two or three strategy documents and two or three quarters of sales spreadsheets into originals. Leave notes empty, because the AI fills it. Starting small gets you a first result quickly. Begin each file name with its date, like 2026-08-14-strategy-memo.pdf, 2026-Q2-pipeline.xlsx and 2026-Q3-pipeline.xlsx, so the AI can see what changed over time.

2. Give the AI its rules

The AI forgets between chats, so it needs written rules it can read again. The rules make every number traceable and every disagreement visible. They also say what matters in each kind of file, so you do not need a separate prompt for each file. Create a rules.md file in your CEO-Brain folder and paste the text below.

You keep a set of notes for me, the CEO. My original files are in the originals folder. Never change, move or delete them. Write your notes in the notes folder: one short page per strategic priority, per key number and per finding.

Write every note in the Open Knowledge Format (OKF) and always follow the latest version of its spec:
https://raw.githubusercontent.com/GoogleCloudPlatform/open-knowledge-format/main/SPEC.md
If you cannot open that link, tell me before you write any notes. The notes folder is the OKF bundle and each note is one concept. Use the type Priority, Number or Finding. Give every note a title, a one-sentence description, its sources (relative paths such as ../originals/2026-08-14-strategy-memo.pdf) and a generated field with the date and time of the last update. Keep all notes directly in the notes folder, with no subfolders. Link them to each other with ordinary Markdown links that use only the file name, like [Average sales cycle](average-sales-cycle.md), with no leading slash, even if the spec recommends one. Never use [[double brackets]].

Keep a log in the file log.md inside the notes folder. It is not a note, so give it no header. For each run, add an entry at the top, newest first, under a heading with today's date, like ## 2026-11-17. Add one bullet for each file you processed and each note you created or changed. Use the log to see which files you have already processed and what changed recently.

How to treat each kind of file:
- Strategy documents (memos, board decks, all-hands notes): write a note for each strategic priority I announced, with the date, the source file and the numbers that would prove or disprove it. A slogan is not a priority.
- Sales spreadsheets: write a note for each key number, with its latest value and its trend by period. Then compare the numbers with my priorities. Where they support a priority or contradict it, write a finding.
- Any other file: ask me what it is and what matters in it, then add that to this list in rules.md.

Calculate every number from the spreadsheets with code and say which file and sheet it came from. Never guess. If data is missing or two files disagree, tell me. Keep facts from the files separate from your own opinion, and label your opinion "Assessment".

When I say "process originals", write notes for every file in the originals folder that you have not processed yet. For kinds of files you know, just write the notes. If you do not recognise a file, ask me before writing anything about it. When you finish, add an entry to log.md and tell me in at most 5 bullets what changed, what now contradicts something older, and what needs my decision.

The rules are a starting point. If you want something handled differently, such as splitting revenue by region, tell the AI and it adds the rule to rules.md.

3. Process your files and read the first report

Because the rules cover each kind of file, one prompt processes everything in originals. Send this:

Read rules.md, then process originals.

The AI writes notes for every file it recognises. If it meets one it does not recognise, it stops and asks. Answer in plain words, and it adds your answer to rules.md, so it does not need to ask again.

When it finishes you get the first return on your two hours: a short report on where your numbers and your strategy disagree. If it missed a priority or listed one that is not real, tell it to add or drop it.

4. Ask questions, then add new files each month

Once the notes are written, you can start using them. Ask anything, for example:

Using only the notes, draft a three-paragraph update to the board on our Q4 priorities. Link every claim to the note it comes from.

Once a month, put new files in originals and send the prompt from step 3 again. It only processes files it has not done yet, and the whole update takes about 20 minutes.

What you get

From the example above, the AI saves a note like this in notes:

---
type: Finding
title: Enterprise sales cycle is longer than the forecast assumes
description: Deals now take 108 days to close, but the forecast assumes 60.
sources:
  - resource: ../originals/2026-Q2-pipeline.xlsx
  - resource: ../originals/2026-Q3-pipeline.xlsx
generated:
  by: ai-assistant/1.0
  at: 2026-11-17T09:00:00Z
---

Enterprise deals took 61 days to close in Q2 and 108 days in Q3 (2026-Q3-pipeline.xlsx, sheet "Deals"), but the Q4 forecast assumes 60. About €2.1M of Q4 enterprise pipeline is unlikely to close this year.

Assessment: worth raising with your CRO and CFO.

Related: [Move upmarket to enterprise](move-upmarket-to-enterprise.md), [Average sales cycle](average-sales-cycle.md)

The lines at the top label the note: what kind it is, what it says, which files it comes from and when it was written. They follow the Open Knowledge Format, an open format published by Google Cloud. The notes are plain files in your own folder, so you can switch from ChatGPT to Claude, or to whatever comes next, without moving anything.

Read your notes in Obsidian

You can ask questions in the Claude or ChatGPT app, as in step 4. To read the notes yourself, use Obsidian, a free app.

  1. Download and install Obsidian.
  2. Open Obsidian, choose Open folder as vault, and pick your notes folder, not CEO-Brain. Links between notes work from the notes folder, and your PDFs and spreadsheets stay out of the way.

Then you can:

  • Click any link to move from one note to the next.
  • Open Backlinks to see every note that points to the one you are reading. For a priority, that shows the findings that support or contradict it.
  • Open Graph view to see each note as a dot and each link as a line. A priority with no lines has no evidence linked to it.
  • Use Bases to list notes as a table you can sort and filter by the fields in their headers.

If you do not see Backlinks or Graph view, switch them on under Settings, Core plugins.

Ask Claude inside Obsidian

If you would rather ask questions without leaving Obsidian, the community plugin Claudian (plugin page) puts a Claude chat next to your notes. In Obsidian, go to Settings, Community plugins, Browse, search for Claudian, check that the author is Yishen Tu, then install and enable it. Check these limits before you do:

  • It is not made by Anthropic.
  • It needs Claude Code installed and signed in on your computer, a one-time job for someone technical.
  • It works on desktop only.
  • It can read and write files and run commands in your notes folder, so check its permission settings before you let it change anything.

Use it for reading and asking. Processing new files still happens in the Claude or ChatGPT app, because rules.md and originals sit outside the notes folder.

Where this stops

Your notes are only as current as the last file you added. Your live pipeline sits in Salesforce, your daily numbers in Power BI or a data warehouse, and many decisions in email and Slack. Exporting files by hand every week will not last, and an out-of-date second brain is worse than none because it looks authoritative.

Connecting live systems is easy to demo and hard to do safely. You need to settle:

  • Who sees what: your CFO's notes should not include HR email threads or restricted deals.
  • One meaning per term: "pipeline", "bookings" and "Enterprise" must mean the same in Salesforce, Power BI and your notes.
  • Reliable updates: fresh data every day, and an alert when a source breaks.
  • Data protection: which data may go to a cloud AI, and what your auditors need documented.

Done well, it puts a short briefing in your inbox every Monday at 7:00 on what moved and what needs your attention.

Let's build it for your company

I help leadership teams turn this from a personal experiment into a secure, company-wide system:

  1. Discovery workshop: map your priorities, key metrics and data sources, and agree the security boundaries.
  2. Pilot: connect one live source, usually Salesforce or Power BI, with a weekly executive briefing.
  3. Rollout: add email, collaboration tools and more data sources, with per-person access and monitoring your auditors will accept.

If you want to see this running on your own data, book a free 30-minute discovery call.