Finding funders

Build lists of potential funders, and let LouEllen research and fill them in.

Start a sheet

Click New at the top of the sidebar, choose Sheet and name it. Or just ask in chat: "Make me a new sheet for climate funders." That's faster, and she starts filling it in.

Find funders

Just ask. Even "Find us some grants" gets you a considered list of funders who back work like yours, with her reasoning. The search draws on public tax filings, so it shows who funders have actually paid, and how much.

You can also be specific or strategic:

  • "Find foundations in our state with an average grant of $10,000 or more."
  • "We've exhausted the obvious funders. What other approaches could we try?"

Research a whole column

This is the most powerful thing she does. Ask in chat for a column, and she researches it for every funder on the list. Cells fill in as she goes, and you'll see Filling Field in the chat.

Ask for almost anything you could research by hand:

  • "Find the grants contact email and phone number."
  • "What's the typical grant range?"
  • "When is the next deadline?"
  • "Rate the fit for our youth employment program from 1 to 10 and explain why."
  • "Draft a short intro message to their program officer."

Work with your table

  • Add a row: click Add Row below the table, or ask her to add funders.
  • Edit a cell: click it. Changes save automatically.
  • Toolbar: Fields (show or hide columns, and drag one up or down to move it), Filter, Sort, ⋯ (Add field, Row height, Export) and New (a new row).
  • Add a field: ⋯, then Add field. Types are text, number, date, select, multi-select and checkbox. To edit or delete one, use the three-dot menu on its header.

Export

Click ⋯, then Export. Choose Excel workbook, CSV, Save to Google Drive…, Save to OneDrive or Save to SharePoint…. The export matches your current view, with its filters and sort and without hidden fields. Exporting needs a paid plan. Docs and saved files have the same save options under Export.

Board view

Any sheet can add a Board tab that shows rows as cards, grouped by a select field like Status. Drag a card to another group to update it. Renaming a group renames that option everywhere.

Your Applications and Opportunities sheets

These open on ready-made tabs:

  • Applications: By status (a board), Due soon (open items due from 30 days ago to 30 days ahead) and All.
  • Opportunities: Best fits (High or Medium Fit, still open), By status and All.

You can change their filters and sort, and Reset puts them back. They can't be renamed or deleted, and neither can the Fit column.

Date filters can follow the calendar, such as Past due, Next 30 days or This fiscal year, so you don't have to update them.

Open a grant on its own card. Point at a grant's name and click Open, or click a card on the board. Edit any field on the card and the sheet updates. Press J and K to move between grants and Esc to close. New opens a blank card the same way.

The card sits beside the sheet, which narrows to make room. Drag the card's left edge to resize it (double-click the edge to reset); your width is remembered. On a narrow window the card floats over the sheet instead.

On the card, Next lists what's still ahead for that grant: what, who (you or LouEllen) and when. History under it shows the latest three things that happened; click Show all for the rest. When a step is done it moves from Next into History.

Press ? for all keyboard shortcuts.

A funder's page

Click a funder's name on any grant to open its page. Everything on it comes from the funder's public tax filings (Form 990-PF), so it works for any private foundation, even one you haven't applied to yet.

  • At the top: its typical grant (the median over the last 3 years), how much it gives a year and how that compares with other foundations, and how often it funds organizations it hasn't funded before.
  • Your history: when a funder's tax filings show grants to you, one line on everything it gave you (how many grants, since when, the total), then the grants themselves. A long history goes one row per year; click a year to see its grants.
  • Giving: key stats, giving over time, grant sizes, new versus returning grantees, and assets. Hover any number or bar for the detail behind it.
  • What it funds and where it gives, side by side, with a map.
  • Its people from the latest filing, and links to the filings themselves.
  • All past grants, searchable in plain words. Try a place, a cause, an amount or a year: "food bank Eugene", "over $25K", "since 2022", or "new grantees" for organizations it funded for the first time.

The first time anyone opens a big foundation, pulling its filings can take up to a minute. After that it opens right away. If several foundations file under the same name, the page shows the one that gives the most; click Not this one? to pick another, and the page remembers it. The search box at the top opens any funder by name.

Tips

  • Start broad, then filter using a column like Fit.
  • Check before you act. Column research is a great first pass, but verify the details you'll rely on.
  • Talk strategy first. She can suggest searches you hadn't thought of.