a+by Akhil Aryan + me

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 Airtable

How to use the Fundraising CRM

Your first day

  1. Make your copy of the template and open the dashboard.
  2. Clear out the sample data and describe your round (setup).
  3. Map your warm intros in People and Intro Paths (warm intros).
  4. 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

  1. 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.
  2. 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).
  3. 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.
  4. Invite your co-founders as collaborators on the base. That lets you assign each investor a Relationship Owner and each task an Owner.
  5. 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.

  1. Connect Airtable to Claude (in Claude, under Settings → Connectors).
  2. 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.
  3. Check what it moved: open Target Investors and People, and spot-check five investors against your sheet.
Prompt for Claude
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.

  1. 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).
  2. 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.
  3. Ask one introducer at a time per investor, and track it with Intro Status: Not asked → Asked → Agreed to intro → Intro made (or Declined).
  4. 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

  1. 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.
  2. Draft 3–5 rough bullets yourself in Answer for each one: the point, the number, the example.
  3. Then ask Claude to polish them:
Prompt for Claude
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.
  1. Rehearse the most-asked answers first, out loud, until the whole team says the same thing.
  2. 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

  1. Give Claude the transcript. Paste in the transcript or your notes (from Granola, Fathom, Zoom or your own) and ask:
Prompt for Claude
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.
  1. 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.
  2. 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).

  1. 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.
  2. 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).
  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.

SectionWhat to look atWhat to do about it
Pipeline healthActive conversations, investors in diligence, targets not yet contacted, expected amount by stageDecide who to move forward this week and who to drop
No warm intro pathActive investors with zero intro pathsFind an introducer, or accept a cold approach
Warm intro pathsIntros not asked yet and intros waiting on an introducerSend the asks; nudge introducers who’ve gone quiet
Fundraise planTasks done and open, by phaseRe-date or reassign anything that’s slipping
Data room readinessShare of documents with a final fileFinish 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:

Prompt for Claude
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.
WhenAsk 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

TableWhat it holdsWhat you update
Target InvestorsOne row per firm or angel: your pipelineStatus and Follow-up Date after every conversation (Notes if useful)
PeopleEveryone you deal with: investor contacts and introducersRole and Relationship Strength when you add someone
Intro PathsOne row per possible warm introIntro Status as the ask moves along
TasksThe plan for the raise, grouped by PhaseStatus, Owner and Due Date
FAQsQuestions investors ask, and your answersThe transcript to Claude after every pitch; your own Answer
Data RoomThe documents investors will ask forFinal File when a document is ready; Shared With when you send it
RoundThe terms of the round you’re raisingKey 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:

Prompt for Claude
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.