Ary Aranguiz used Perplexity AI to generate an Excel list of Dutchess County nonprofits with over $1 million in revenue, pulling names, board chairs, executives, and phone numbers in minutes. The tool worked fast enough to be practical, though some fields were incomplete.
Chapters
Yeah, so we were working with somebody who was interested in targeting nonprofits in a county in New York State called Dutchess County. And he was trying to figure out how he could get a list of them, how he could meet the people that run them, how he could get the contact info. And his initial thought is, I would have to just, you know, sit on Google and go to every single nonprofit's website and get the information off their 990s and stuff. But what I did is we created a prompt that basically said, create a list in Excel of all the nonprofits over $1 million in 2024 located in Dutchess County, New York. Identify the name of the organization, the board chair, the board chair's email, the executive director's name, the email, and the phone number for all the nonprofits in the county. And we are looking for it to create it. in Excel. And let me bring up and show you exactly what it did real quick. And the output that, that it came up with was— it only took a few minutes.
I can see it. No, we can't. Not yet. Oh, almost. Here we go. There we go.
So what it brought up is, here's the full list. Now you're asking why a lot of this is blank. It's because I stopped it because it was going to take longer to do. And the person I was doing it for was really focused on nonprofits in this range. But you could see it lists all the board chairs. Some of the board chairs' emails were not as readily available, but you could see here's all your executive directors, here's their emails, and here's their phone numbers real quick. So it organized it very quickly. And what I did is I picked a couple of these nonprofits that I actually work with as a way to validate the information.
