Tool · Airtable templateBeta
Fundraising CRM
Run your whole raise from one Airtable base, in five minutes a day.
Inside: your investor pipeline, a map of who can introduce you where, rehearsed answers to the questions investors ask most, a plan for the raise from preparation to close, and a dashboard that tells you what to do next. It’s free, and it works on Airtable’s free plan.
Beta. This CRM is in beta and still evolving. We’ll keep improving the template as founders use it, so expect updates, and please tell us what works and what doesn’t.
Free · Airtable template
Get the template
Leave your email and the link to copy the template opens here, with the full guide on how to use it.
it’s yours
Open the template and click “Copy base” to put it in your own workspace. Then start with your first day below.
Copy the template in AirtableHow to use the Fundraising CRM
Your first day
- Make your copy of the template and open the dashboard.
- Clear out the sample data and describe your round (setup).
- Map your warm intros in People and Intro Paths (warm intros).
- Draft rough bullets for your FAQ answers (FAQs).
The rest of this guide explains each step, then how to keep the CRM up to date once you’re pitching.
One place for your whole raise, in five minutes a day
Most founders run a raise from a spreadsheet, an inbox and memory. That works until you’re talking to 40 investors at once and can’t remember who you owe a deck, who could introduce you to whom, or what the last partner pushed back on.
This CRM keeps all of that in one Airtable base. It’s built so that the upkeep is small: after each conversation you change two fields and add any to-dos, and the dashboard tells you what to do next. In return you get:
- A follow-up list that tells you who to chase today, so no warm lead goes cold.
- A map of warm intros, so you know who in your network can reach each investor before you reach out.
- Answers you’ve rehearsed to the questions investors actually ask, ranked by how often they come up.
- A plan for the raise from preparation to close, so you can see what’s done and what’s next.
The template comes with fictional sample data so you can see how it works. You’ll clear it out during setup.
Start with the dashboard
The dashboard is the easiest way in, whether you’re opening Airtable for the first time or starting your day. To open it, click Interfaces in the bar at the top of the base, then Fundraising Overview. It has two pages, listed on the left:
- Overview is your daily view: round progress, follow-ups due, open tasks and the full pipeline.
- Prep is your weekly view: pipeline health, warm intro paths, the plan by phase and data room readiness.
Open Overview first and click around the sample data to see how everything connects.
Setup takes about 30 minutes, once
- Make your own copy. Open the template and click “Copy base” to put it in your own workspace. Keep the records when you copy, so you can click around the sample data first. A free Airtable account is enough.
- Clear out the samples. Here’s what to delete and what to keep:
- Delete: every row in Target Investors, People and Intro Paths (they’re all samples), and the tasks whose Notes say “Sample task”.
- Keep, and make your own: the other tasks (a ready-made plan for the raise: change the dates and owners), the FAQ questions, the Data Room checklist, and the Round row (overwrite it with your round).
- Describe your round. In Round, fill in the name, target, instrument, valuation or cap and target close date. Write Key Terms and Use of Funds in plain words. Set Round Status to Raising so the round shows on the dashboard.
- Invite your co-founders as collaborators on the base. That lets you assign each investor a Relationship Owner and each task an Owner.
- Set your currency. If you aren’t raising in US dollars, change the currency on Expected Cheque and the Round amounts.
Let Claude move your spreadsheet in
Don’t retype your investor list. If you’ve been tracking the raise in Excel or Google Sheets, Claude can move it across in one go.
- Connect Airtable to Claude (in Claude, under Settings → Connectors).
- Start a chat, attach your spreadsheet, and paste in the prompt below. Claude will ask you about anything it isn’t sure of. Answer those questions before it writes, so nothing lands in the wrong place.
- Check what it moved: open Target Investors and People, and spot-check five investors against your sheet.
I've attached the spreadsheet I've been using to track our fundraise. Please move it into my Fundraising CRM in Airtable. First, read every table and field description in the base so you understand how it's meant to be used. Then show me how you plan to map my columns before you write anything. Put people in People (Role = Investor contact or Introducer), firms in Target Investors, possible warm intros in Intro Paths, and to-dos in Tasks. Put anything that doesn't fit a field into Notes, rather than dropping it. If you aren't sure about something (a column you can't place, a possible duplicate, whether someone is an investor contact or an introducer), ask me instead of guessing.
The descriptions on every table and field are written for exactly this. They tell Claude what each field means, so it puts things in the right place.
Prepare before you pitch: warm intros and FAQs
This CRM helps you prepare for the raise as well as run it. Two sections do the preparing:
- Intro Paths shows who in your network can introduce you to each investor, and which investors you have no warm way into yet.
- FAQs holds your own considered answers to the questions investors ask most, ranked by how often they come up.
Together they tell you where to start and what to say once you’re in the room. Start with these two before you contact your first investor.
If your raise has already started, come back and fill them in anyway. You’ll get one view of your whole network and who can introduce you where, and answers you’ve worked out properly before the next investor asks.
Warm intros: who can introduce you where
A warm intro gets a far better response than a cold email, so work out who can reach each investor before you contact anyone.
- Add your introducers to People with Role = Introducer: advisors, existing investors, founder friends, former colleagues. Rate how well you know each one with Relationship Strength (three hearts = they’d do you a favor today).
- Add one row to Intro Paths for each possible intro. Pick the Investor, the Introducer, and the specific person they know there (Intro To). The first column names itself, e.g. “Marcus Ellery (Lumen Ridge Capital) · via David Lin”. Write how they know each other in Notes.
- Ask one introducer at a time per investor, and track it with Intro Status: Not asked → Asked → Agreed to intro → Intro made (or Declined).
- When the intro happens, set Introduced By on the investor’s row, so you always know who brought whom.
On each investor’s row, Possible Introducers lists everyone who could help, and “# Intro Paths” shows 0 where you have no warm path yet.
FAQs: write your answers yourself first
Investors will judge the answers, so the thinking has to be yours. Claude is good at turning your rough points into clean spoken answers. It can’t know your numbers, your customers or why you made the calls you made.
Write your first set of answers
- Choose your questions. FAQs comes with about 45 questions investors commonly ask, grouped by Category. Delete the ones that don’t apply to you and add any you know are coming.
- Draft 3–5 rough bullets yourself in Answer for each one: the point, the number, the example.
- Then ask Claude to polish them:
Read the FAQs table in my Fundraising CRM. For each question with rough bullets in Answer, rewrite them as 2–4 sentences I can say out loud in a pitch. Keep my numbers and examples exactly as they are, and don't add claims I haven't made. Save each one in Claude's Draft, never in Answer. I'll copy over what I like.
- Rehearse the most-asked answers first, out loud, until the whole team says the same thing.
- Link the proof. Use Supporting Docs to link each answer to the Data Room documents that back it up.
Keep them up to date after every pitch
- Give Claude the transcript. Paste in the transcript or your notes (from Granola, Fathom, Zoom or your own) and ask:
Here's the transcript of my pitch to [investor]. Find every question they asked or pushed back on. Match each one to an existing question in FAQs, or add it if it's genuinely new, then add the investor to Asked By and update Frequency. Ask me if you're not sure whether two questions are the same.
- Check what Claude changed. “# Times Asked” counts the investors in Asked By, and Frequency follows it: 5+ = 100% Asked, 2–4 = High Freq, 1 = Low Freq. Skim the changes and fix any question that was added twice.
- Answer any new questions the same way as your first set: your bullets first, then Claude’s polish.
Before a second meeting, open the investor’s row and read Questions Asked. It shows everything they’ve raised so far.
Every day: three steps, about five minutes
Start each morning with the Overview page of the dashboard (Interfaces → Fundraising Overview → Overview).
- Work through “Follow-ups due”. It lists every investor whose Follow-up Date is overdue or in the next 7 days. Chase each one, or move the date if the timing has changed.
- After every conversation, update the investor’s row:
- Status: where they are now (Preliminary Conversation, Conducting DD, and so on).
- Follow-up Date: when you’ll next contact them. Every active investor should have one.
- Notes (optional): only if there’s context worth keeping, like why they passed. What you agreed to do goes in Tasks (step 3).
- Add any to-dos to Tasks with an Owner, a Due Date and the Firm. Tick off what you finished under “Open tasks”.
You don’t need to log the date you spoke. Last Updated records it whenever Status, Follow-up Date or Notes changes.
Every week: a 20‑minute review with your co-founders
Once a week, open the Prep page of the dashboard (Interfaces → Fundraising Overview → Prep) together and go through it top to bottom.
| Section | What to look at | What to do about it |
|---|---|---|
| Pipeline health | Active conversations, investors in diligence, targets not yet contacted, expected amount by stage | Decide who to move forward this week and who to drop |
| No warm intro path | Active investors with zero intro paths | Find an introducer, or accept a cold approach |
| Warm intro paths | Intros not asked yet and intros waiting on an introducer | Send the asks; nudge introducers who’ve gone quiet |
| Fundraise plan | Tasks done and open, by phase | Re-date or reassign anything that’s slipping |
| Data room readiness | Share of documents with a final file | Finish the documents you’ll need at the next stage |
Then update Round if anything about the terms has changed.
Let Claude do the typing
With Airtable connected, Claude can read and update the CRM for you. Start each chat by pasting this line, so it doesn’t overwrite your work or add clutter:
Show me what you plan to change in my CRM before you save it. Never edit an FAQ Answer, only Claude's Draft. Only add a task if someone agreed to do something. Ask me when you're unsure.
| When | Ask Claude |
|---|---|
| Before a meeting | “I’m meeting Juniper Arc tomorrow. Summarize everything in the CRM about them: status, notes, who we know there, open tasks and the questions they’ve asked.” |
| Following up | “Draft short follow-up emails for every investor whose follow-up is due this week, using what’s in their Notes.” |
| Monday morning | “Give me a one-page summary of the raise: committed so far, who moved stage last week, who’s gone quiet, and overdue tasks.” |
What stays with you
Claude saves you the typing. These parts of the raise stay yours:
- The relationships. Make the asks to introducers yourself, and take the calls yourself.
- What goes to investors. Read every email, deck and document before it’s sent, even when Claude drafted it.
- The judgment calls. Who to prioritize, when to walk away, which term sheet to sign.
- The numbers. Check any figure Claude writes into the CRM or a draft against your own model.
Quick reference
| Table | What it holds | What you update |
|---|---|---|
| Target Investors | One row per firm or angel: your pipeline | Status and Follow-up Date after every conversation (Notes if useful) |
| People | Everyone you deal with: investor contacts and introducers | Role and Relationship Strength when you add someone |
| Intro Paths | One row per possible warm intro | Intro Status as the ask moves along |
| Tasks | The plan for the raise, grouped by Phase | Status, Owner and Due Date |
| FAQs | Questions investors ask, and your answers | The transcript to Claude after every pitch; your own Answer |
| Data Room | The documents investors will ask for | Final File when a document is ready; Shared With when you send it |
| Round | The terms of the round you’re raising | Key Terms when they change |
Pro tip: a morning email from your CRM
If you’d like a daily nudge in your inbox, Claude can set one up for you. With Airtable connected, paste this into a chat:
In my Fundraising CRM, create an automation that emails me at [your email] at 9am my time every weekday. It should list the investors whose Follow-up Date is today or overdue (leaving out Not Interested and Funds Received), and the open tasks due today or overdue. Leave it switched off so I can check it first.
Then open Automations in your base, check it and switch it on. It works on Airtable’s free plan.
Updates and feedback
This CRM is in beta, and we’ll keep improving the template based on how founders use it. Your copy won’t update by itself: when we release a new version, we’ll email you what changed, so you can make the change in your base or copy the new template.
If a field is confusing, a step takes too long, or something is missing, email me at me@akhilaryan.com. We’d especially like to hear what you stopped updating, and why.