Prompt Engineering For Beginners & Get The Most From Your Current Tech





Prompt Engineering For Beginners
Our 2024 Nonprofit Technology Conference coverage continues. This panel explains how to get the most out of the generative Artificial Intelligence tools when you write your cues, or prompts, to them. You want ChatGPT and their ilk to serve you best, so here’s wisdom from Nyle Malik and Alfredo Ramirez, the co-founders of Prosal.
Get The Most From Your Current Tech
Dana Larkin and Patrick McDermott encourage you to explore the lesser-known features in the software you’re probably already using from Microsoft and Google. There’s a tech stack sitting in your office, underutilized. Let’s put it to work! They’re both from Heller Consulting and this is also part of our 24NTC coverage.
Here’s the transcript
Tony MartignettiHello and welcome to Tony Martignetti Nonprofit Radio, big nonprofit ideas for the other 95%. I am your aptly named host and the podfather of your favorite hebdomadal podcast. We're welcoming DonorBox back to the Nonprofit Radio family. They took a break and saw their mistake. Now they're back with us. For goodness sake. I think I'd have to say that Bruce Springsteen is probably the, the greatest influence on my poetry. Oh, I'm glad you're with us. I'd come down with ketoaciduria. If you rained down on me with the idea that you missed this week's show. Here's our associate producer Kate with what's up this week.
Kate MartignettiHey Tony, this week it's prompt engineering for beginners. Our 2024 Nonprofit Technology Conference coverage continues. This panel explains how to get the most out of the generative artificial intelligence tools when you write your cues or prompts to them. You want ChatGPT and their ilk to serve you best. So here's wisdom from Nyle Malik and Alfredo Ramirez, the co-founders of Prosal. Then get the most from your current tech. Dana Larkin and Patrick McDermott encourage you to explore the lesser-known features in the software you're probably already using From Microsoft and Google. There's a tech stack sitting in your office underutilized. Let's put it to work. They're both from Heller Consulting, and this is also part of our '24 NTC coverage. On Tony's Take Two.
Tony MartignettiThe vacation finger wag.
Kate MartignettiWe're sponsored by Virtuous. Virtuous gives you the nonprofit CRM Fundraising, volunteer, and marketing tools you need to create more responsive donor experiences and grow giving. Virtuous.org. And by DonorBox. Outdated donation forms blocking your supporters' generosity? DonorBox. Fast, flexible, and friendly fundraising forms for your nonprofit. DonorBox.org.
Tony MartignettiI love that the alliteration is back. Fast, flexible, friendly fundraising forms for your nonprofit. Love this. Love the alliteration. And you didn't even say anything about my insightful poetry.
Kate MartignettiIt was, it was cute.
Tony MartignettiDidn't you see the— couldn't you hear the Bruce Springsteen influence in it? They took a break and saw their mistake. Now they're back with us, for goodness sake. I mean, if that doesn't scream Springsteen, I don't know. You're not appreciating his music deeply.
Kate MartignettiYeah, not a Bruce Springsteen fan.
Tony MartignettiWell, you don't have to be a great fan to recognize the depth of my work and how it's influenced by him. Let's just move on.
Kate MartignettiHere is Prompt Engineering for Beginners.
Tony MartignettiWelcome to Tony Martignetti Nonprofit Radio coverage of 24NTC. It's the 2024 Nonprofit Technology Conference in Portland, Oregon at the Oregon Convention Center where we are graciously sponsored by Heller Consulting, technology strategy and implementation for nonprofits. With me now are Nyle Malik. He is co-founder and chief technology officer at Prosal, and Alfredo Ramirez, co-founder and chief marketing officer at Prosal. Nyle, Alfredo, welcome.
Alfredo RamirezThank you for having us. We're excited to be here.
Nyle MalikAbsolutely.
Tony MartignettiPleasure. All right. Alfredo seems a little more excited than Nyle. Maybe we can pump you up a little, Nyle. You have enough coffee? What, you're all right?
Nyle MalikOh, I've got my first cup in. You're okay?
Tony MartignettiOh, you're all right.
Nyle MalikI'm ready. It's going to hit in probably 10 minutes. Okay. You'll get me in there.
Tony MartignettiI just sense a little, little more enthusiasm from, uh, out of Alfredo.
Alfredo RamirezI'll put some coffee in your cup now. I got you.
Tony MartignettiYeah, thank you. Yeah, okay, we are talking about prompt engineering for beginners. Your session is, uh, Prompt Engineering for Beginners: Use Artificial Intelligence for Better, Faster Communications. I was excited to do this. Uh, this intrigued me a lot because we're hearing about prompt engineering, this new field. There are going to be degrees, I don't know, and Certificates at least, maybe even sometimes degrees in prompt engineering. Let's turn to you, Alfredo. What is— let's make sure everybody understands what prompt engineering is. Let's start with the basics, please.
Alfredo RamirezYes. So prompt engineering at the very base level is how you communicate with an AI tool like ChatGPT. A prompt is just the way that you speak to ChatGPT or to another tool, it is the input that you give it that it then takes to generate an output. All of these tools that we're talking about, they are generative artificial intelligence. They generate text, they generate images, and so you are telling it what to generate with your prompt. And we're going to get probably into the details of it, but the more defined and the more specific your prompt is, the more tailored the output
Nyle Malikwill be to what exactly you are
Alfredo Ramirezlooking for.
Tony MartignettiAnd Nyle, this is very iterative, right? We're not— you don't do one prompt and you're done.
Nyle MalikAbsolutely. This is actually— I consider it almost to be a little bit more of an art form because as these tools evolve and we're getting better models, the strategies to approach them are changing. And then also as you start to start using some of these models like ChatGPT specifically, iterating on kind of their outputs and getting more granular about what you want it to display is essential to getting the right output for you.
Tony MartignettiWhat more should we know about these tools before we get into the details of good prompt engineering?
Nyle MalikAbsolutely. Like, this is a new field for sure. I'm sure everyone's heard about ChatGPT at this point, but the fairly— the release to the public was really just over a little over a year ago where that started blowing up. And since then, a lot of research and a lot of iterations have gone into these tools. And we've heard of GPT-3.5, 4 being released, and now we have the next iterations coming out. There's plenty of competitors in this space. People start using Google's tools to do this. So while this is all happening and we, we're giving kind of the best way to do stuff right now, this is an evolving field. And we will constantly be trying to get humans to use these tools as best we can to get the outputs that we need. And so it's just kind of a learning process. Always be open-minded. use these tools to basically help you in your job and to stay on top of kind of the latest news of those things.
Tony MartignettiOkay. Okay. Are we ready to get into some of the—
Alfredo RamirezLet's do it.
Tony MartignettiThe details of what makes good prompts, how to work with what you get back. Who wants to start with like our first prompt? What do we need to plan? Yes. We need to have something in mind before we start Before we start typing our prompt.
Alfredo RamirezSo I brought this cheat sheet. I have a cheat sheet in my hands that folks probably can't see, but— No, they can't. I promise you they can't. You can envision me just holding a piece of paper. It's a little bit for me as much as for the people that we're talking about prompt engineering at NTC tomorrow. But there are really 5 components when it comes to a good prompt. The role, that you are setting for the tool, the intent, what do you want it to do? What is the outcome that you want that intent to accomplish? You can think of that almost like your goal or your objective. The format that you want it in, and format can be anything from the typeface to the style to the writing tone. And then the context, any background or information that— might be more specific to your use case and to your need. And within each of those 5 elements, there are guides, instructions, best practices so that you can generate the absolute best output for your needs.
Tony MartignettiOkay. The role you are— let's stick with you, Alfredo. The role you are a— you are a something. You are a fiction writer.
Alfredo RamirezYou are an expert podcast host. You are an expert writer. You are an experienced You are a professional grant writer.
Tony MartignettiDamn. And so, what kind of differences are you going to see if you keep all the other, the 4 variables the same, and you just change the role? You're going to see differences? Massive differences. What kind of differences?
Alfredo RamirezThis is like bringing somebody, like, it's almost like giving someone a college education with a sentence. You're going to bring in vastly different bases of knowledge because ultimately all these tools are are trained on what is available on the internet up to a certain period of time. And so by telling it, you know these things, this is what you are best at, you are telling it to focus on those specific things and draw knowledge from what it believes a world-class marketer, a world-class podcast host will know and will rely on to generate their knowledge or to rely their knowledge on.
Tony MartignettiThis is incredible. These are, uh, Nyle, this all just comes from the large learning, the large language— no, language learning, LLM.
Nyle MalikExactly.
Tony MartignettiTo me, it was Master of Laws when I was in law school, but that's an LLM degree. But I don't have that, but some people do. But, uh, large— help me with LLM, please.
Nyle MalikYes, large language models.
Tony MartignettiLarge language models.
Nyle MalikExactly that. Um, and as Alfredo is mentioning, you know, these are trained on massive, massive corpuses of human outputted text, robot-generated text, just tons of English language, for example, if your output's in English. And so there's so much in that corpus of information. And if you just throw a general prompt at it and you don't really specify a role or an intent, you're going to get a general generic output because it's just trying to synthesize all this information and give you the expected output that it thinks you want. But the more specific, the more granular you can get, the more it can kind of fine-tune or get on the specific training data that it's seen, and it can actually get you an output that's much more tailored to what you're wanting.
Tony MartignettiShould our— should our— the first words of our prompt be, you are a—
Nyle MalikAbsolutely.
Tony MartignettiFill in the blank?
Nyle MalikAbsolutely. Yeah. So we— I mean, this is that simple. It's— it's for— that's the first step for sure.
Tony MartignettiAt least you are a is simple. Now, what you want— what you want to fill that in as Well, you're a nonprofit executive director. I don't know, you're a nonprofit fundraiser. You're, you're a nonprofit donor, right? Um, so that, that's up to you, but you should start with you're a something.
Nyle MalikYeah, and a lot of, um, strategies that people use to, to really get really good outputs is they mirror themselves. So they use some mirroring in saying, hey, I'm the CTO of a startup and I am trying to do this and this is kind of what I'm looking for. And in doing that, it can almost act as your brain in this sort of way. Alfredo has a really good saying of use these tools like they're interns. So always verify their outputs and all that stuff.
Tony MartignettiThat's very good.
Nyle MalikBut in taking your own or the problem that you're facing or what you want to generate, I use it a lot for generating emails, for example. I say, hey, you are the CTO of a startup company that does this. I need you to make an email for this. And in that kind of way, it can mimic the tone or the language that I should use. And it gets much, much better in the output.
Tony MartignettiOkay. This 1 through 5 is ideal, by the way. We're breaking this down. So anything more we should say about role before we move to intent?
Alfredo RamirezThis is going to apply to anything that we say. There's not one fixed way to say this and what Nyle— or to write this out. You can say you are, you can say act as, you can say your role is. So there are a myriad of different ways where you can kind of execute this prompt. And to Nyle's point earlier, This is all ever-changing. You know, these— the way that we're going to write this right now, this is a best practice. In 6 months, this might not be the case. So in 6 months, we might be back here, we might be saying, you got to talk about role in a different way, or you got to specify role in some other way.
Tony MartignettiAll right, we better air this quickly then. I'm doing 25 of these interviews. That's 25 shows. That's about— well, we're going to double up some, so we've got a couple months' worth. All right, we better air this one promptly. So promptly. I like that one. Look at the host. World-class. I appreciated the world-class World-class podcast host, whoever. Was that you, Nyle? Yeah, I think it was Alfredo. Thank you. I'll just— I mean, you were using that as an example, but I take it personally. I was inspired. Thank you. Thank you. Intent. Intent. Who wants to talk of— start us off with understanding intent?
Nyle MalikYeah, I can totally take intent. Intent is kind of exactly what it's described as. It's really what is the goal you're trying to accomplish with this prompt output? And going back to the email example, if I just said, write me an email to send to my friend to schedule dinner, that's partly an intent there. I have a dinner planned. That's kind of what I'm trying to allude to. But what we really try and do is get more and more specific. So the more information that you can give these models, the better they can use that information in the output. So that's really— the intent is really, what are you trying to accomplish? Right.
Tony MartignettiOkay, like it's a fundraising— we're trying to raise money or encourage volunteers, or we're trying to write to a funder.
Alfredo RamirezRight, exactly.
Tony MartignettiWe're trying to encourage folks to work for us. Maybe we have job openings.
Alfredo RamirezIt's very different to say, write me an offer letter, as opposed to, write me an offer letter for a project manager that starts on Monday, April 1st.
Tony MartignettiOkay, okay. All right. So intent, that's different than your objective is more the next one, like the outcome. The outcome, yeah. So I see a fine difference between your intent and your outcome. Can you help us?
Alfredo RamirezYeah. So the intent is like to Nyle's point, he's writing an email. He might be saying, draft me this email. But the outcome, what do you want that email to do? Who's receiving that email? What is the effect that you want it to elicit? You can say, write me an amazing fundraising email. Probably will give you a really good fundraising email. But you can say, write me a fundraising email to audiences who respond to environmental conservation and who care about the Arctic and the bees and want to— and we want them to donate $5 when they read this email. It's going to be very different language and wording.
Tony MartignettiYou can do that? I mean, that's a—
Alfredo RamirezThat is perfectly—
Tony MartignettiThat's a very good prompt?
Alfredo RamirezThat's a perfect prompt that you can put in and you can— and it will give you back exactly what you were looking for.
Tony MartignettiOkay. Okay. Any more? So that intent, outcome, anything more on outcome? I love this. I mean, I didn't imagine this degree of specificity though. I mean, bees and the Arctic. I mean, okay.
Alfredo RamirezYou can get real specific. I mean, and this is, this all feeds, this is why the last one is context and we'll get to context, but this all ultimately feeds into What is the information that it needs to know? This is where you should really consider it. This is why I always say treat it like an intern. An intern, if you tell it, go create an Excel table, you know, it will probably create an Excel table, but does that accomplish what you need? You know, is that the outcome or the objective? Is that being fulfilled? Whereas if you tell an intern, I need this Excel table in this exact space, in this exact formatting, with these letters, and I need it to do this and have these formulas, then they have a guide to follow. It doesn't mean that they're gonna do it perfectly. And that's, again, to Nyle's point, verify the output, make sure that the information is correct and it's what you're needing. But it's at least gonna get you a lot closer than if you had just given it very vague instructions.
Tony MartignettiI always used to joke that I needed an intern on this podcast so I had somebody to blame.
Alfredo RamirezNow you, now you can just hire ChatGPT.
Tony MartignettiYeah, there you go. All right. We have an associate producer. I, I, I blame her occasionally. I'm, I'm getting, I'm getting more, more comfortable blaming her. She's only been with us since July. But I'm— it's just, it's out of necessity. Let's leave it at that. Okay. The format. All right. So Alfredo, you started to, you mentioned like Excel spreadsheet. We're not even getting into art. We're talking about text output. But you certainly could work with a DALL-E and you could be talking about a piece of art.
Alfredo RamirezYeah. And I mean, this is actually beyond my level of expertise, but going to the example of DALL-E and formatting, you can talk about the level of contrast, the aspect ratios, the temperature of the colors that you're using. You can get very specific. And so for what—
Tony MartignettiYou can be an artist. I want something that looks like a Chagall.
Alfredo RamirezYes, exactly. Like, I want the streets of New York painted in Mark Rothko style or Piet Mondrian style. Like, I—
Tony MartignettiAll right.
Alfredo RamirezBut when it gets to written format— That's the text. Yeah, when you get to text— and all of this also applies to DALL-E and Midjourney and other tools. We actually specify, This is not just for text. You can use this, especially if it's— if you don't have like a graphic designer on staff, you can use a tool like Midjourney or DALL-E to at least maybe create that inspiration that you can then share with the designer and say, this is kind of what I'm looking for.
Tony MartignettiLike a first draft. Exactly. First cut for a professional designer.
Alfredo RamirezExactly. But in the same vein, you can draft content to say, you know, give me an outline with heading, with H2 tags and with bullet points. Um, and give it to me, you know, properly formatted. And then you can tell it, give it to me in HTML so I can just copy paste this and drag it and put it into my, uh, my email builder or into my, my website builder. So there's a lot of different ways. I, I'm not by any means a coder, but for any coders listening, I'm sure Nyle's got really good tips for when it comes to the actual coding process.
Tony MartignettiOur Chief Technology Officer.
Nyle MalikNo, but Alfredo's exactly right. And even if you go back to that email example or you're doing an offer letter, like The standard elements of an offer letter will be part of that output if you specify that this format is going to be in an offer letter. And you can get even quirkier with it, especially with text. We've seen— I saw some pretty fun examples of them, people testing the tool, and they're outputting in Shakespearean format, like iambic pentameter is coming out in the text. And I was like, wow, this is pretty incredible. And it gets even more important with some of these other generative AI tools like you're mentioning, DALL-E, Midjourney, even OpenAI is just demoing a new model called Sora, which actually can do video. And with video, they can specify this was filmed on 35mm film or something like that, or even give it a specific camera that this should mimic in, in the output.
Tony MartignettiOh, man.
Nyle MalikAnd it's, it's really incredible stuff.
Kate MartignettiIt's time for a break. Virtuous is a software company committed to helping nonprofits grow generosity. Virtuous believes that generosity has the power to create profound change in the world and in the heart of the giver. It's their mission to move the needle on global generosity by helping nonprofits better connect with and inspire their givers. Responsive fundraising puts the donor at the center of fundraising and grows giving through personalized donor journeys that respond to the needs of each individual. Virtuous is the only responsive nonprofit CRM designed to help you build deeper relationships with every donor at scale. Virtuous gives you the nonprofit CRM, fundraising, volunteer, Marketing, and automation tools you need to create responsive experiences that build trust and grow impact. virtuous.org. Now back to Prompt Engineering for Beginners with Nyle Malik and Alfredo Ramirez.
Tony MartignettiHow could you not be a Bruce Springsteen fan? You're from New Jersey. Well, I, I— that's impossible.
Kate MartignettiI don't know.
Tony MartignettiYou don't know? There is no— there's no good excuse. All right, let's continue. Format. Anything more about format? Should we say anything more?
Alfredo RamirezUh, writing styles. Um, I think that's one that you can probably get into. It— there's some pretty funny ones in the early days of ChatGPT where you can look up like stories of certain, uh, characters that are written in humorous ways, we'll say. OK. But humorous is a tone. Persuasive is a tone. Argumentative, formal, professional, informal— these are all writing tones and styles that you can apply also to your writing. So don't feel limited in just that formatting is the actual format of the output, but what is the style that you want writing in? Now, I mentioned iambic pentameter. Ask it to write you an email in haiku format.
Tony MartignettiHaiku is very good. Yeah. Okay. Okay.
Nyle MalikBut even just something as simple as, hey, I've written all this stuff and I want to be a little more concise about it, it can go there and chop it up and make it much, much better. And it kind of gives you— it helps give you a voice that maybe you're not used to writing in. I know for me, I can tend to blabber a lot when I'm writing an email. So when I start using this and I tell the output format to be more Concise, it helps greatly.
Tony MartignettiAll right, last one, context. Let's stick with you, Nyle.
Nyle MalikYeah, so context is kind of an overarching term to just basically give it more information about— more specificity will always lead to a better output. And so when I'm saying draft an offer letter or send an email to schedule dinner with my friend, the more information I can give it, the better it can get and the better it can tailor that email or that offer letter to the audience. And so it goes much beyond that even. We use it a lot. We deal with a lot of documents all the time, massive, massive PDFs that we have to kind of go through and figure out different things about. And so you can actually take big corpuses of text. You can take other additional supporting information and give that to ChatGPT. Yeah. Or to any other LLM tool, and it will actually go through that and find out what's most relevant to you and what's important and use that in the output. You got to remember, these tools are kind of— they're trained on a lot of different knowledge, but your goal is to use the knowledge that's most pertinent to you. So taking it and giving it any kind of context that you have or anything that you think will be useful in the output and just providing it to the model will just help it give it something to reference and something to use in the output.
Tony MartignettiCan you, can you reference your own, your own writing, your own website, like a blog post that you did?
Alfredo RamirezOf course.
Tony MartignettiThat you wrote yourself and you wanted to imitate. So you give it the URL.
Alfredo RamirezYou can give it the URL. There's different— I'm not sure about 3.5, but I know ChatGPT-4 does parse links so it can go directly to a link if it's not even trained on that corpus. It will train itself in the moment. You can also just copy-paste the text. Now I'll mention, there's a ton of plugins that do this now. You can link to a PDF in your Google Drive or somewhere online that's easily accessible. One example that I've used it for— there's tools that already do this, but if you record a meeting and you have the entire transcript and you need to summarize the meeting for somebody— Yeah. You can just take that transcript and upload it and say, when did Tony mention role in our conversation, and what was the questions that he was asking? So I can go back and make sure that I'm answering them and pull out those questions specifically rather than having to go look at my notes or look at the video. And you can use that information to say, okay, we had this conversation. Now write me a blog about this, this entire topic. Write me a summary, right? Excellent. Make it SEO optimized too. And you can give it additional context and additional background information. It doesn't have to be on the first one. Nyle's probably going to bring up chain prompting at some point, but you can Build on all of these prompts. This isn't a one-and-done effort. This is an ongoing conversation.
Tony MartignettiYeah, we said iterative. Oh, but, but so it's remembering.
Alfredo RamirezIt's gonna remember that.
Tony MartignettiFrom when you're in prompt number 7, it's gonna remember the first 5. It remembers the first 6.
Alfredo RamirezExactly. And you can tell it to reference, hey, that last prompt was missing this specific piece of information. Update paragraph 2 to reference this information that is now new to you but is important to this topic of conversation.
Tony MartignettiDamn. All right. So you can train it. You can train it on obviously your own— you're talking about links, your own text. Okay. Your own document that you want summarized, you can give it.
Nyle MalikYeah, absolutely. And for example, I consider myself to be a terrible writer. I'm not writing blog posts. That's why we have Alfredo over here. And Alfredo outputs great blog posts in his style, and he's really good at writing the text that goes on our blog. So if I'm ever writing a blog post, I just take all of Alfredo's old blog posts and I say, this is a blog post I want to write. I want you to act as a blog writer and give it all the role, the intent, the outcome, the format. And then as context, I'll give it all of Alfredo's blog posts and say, this is the kind of style I want to mimic, or this is some of the information I want to retouch on. And it can actually use that in the output to one, mimic Alfredo's writing style or his voice, and then also reference some of the older blog posts that Alfredo has written. So that we can keep, uh, everything kind of in a tree structure.
Tony MartignettiNow, when I was growing up, we called that plagiarism.
Nyle MalikWell, I think, I think, uh, plagiarism is, uh, yeah, there's a fine line there.
Tony MartignettiThere's a fine line. No, I understand, because you're giving it— you use these as examples. You're not saying copy, although you just copied yourself. All right, but plagiarism came to mind as you were explaining that.
Alfredo RamirezWell, and I think you now bring up the— you start to go into the pros and cons of some of these elements where You know, you could— I don't, I don't see plagiarism as an accusation, but if you are posting, say, a blog post or you're sending an email, um, or, or anything like that, some of the writing, especially if you're not specific with your prompt, it can be easily detectable. You know, I, I think at this, I've gotten, I think, to the point, and Nyle too, where we can see if something was written with a poor prompt. And you can— there's a general writing style that ChatGPT has where you can see, okay, well, this was clearly written by ChatGPT. And Google is doing the same thing. Search engines are doing the same thing, and they're deprioritizing content that it can tell, okay, well, this was obviously written by an AI tool. This is not written by a human. We're not going to give this priority when sharing it with the rest of the world. And other— and it's not just Google. Google, I think, is the one that's probably most known for this right now and building it into its search algorithms. But I think other platforms, social media, search engines are following closely behind to deprioritize AI-generated content. As opposed to human-generated content.
Tony MartignettiNow, let's go to you because Alfredo referenced something. So now we've got our first output from our first newly engineered prompt, and it's not what we want. What do we do?
Nyle MalikWell, the beautiful part about these LLMs and the interfaces that they've built is that you can conversationally talk to them. So you can actually tell them exactly what you liked about the previous output, or you can actually ask it what you didn't like or tell it what you didn't like, and it can go and refine that and further refine the output. And you can just take it along a completely different direction just based on you giving it feedback. Something that's also pretty cool that I'll touch on a little bit is you can even give it an output that you like, like one of Alfredo's blog posts, and you can actually have it reverse engineer the prompt for you. And so that you'll start on a better baseline. So I can give an Alfredo blog post and I can say, hey, if I'm, I'm trying to create a prompt to use with ChatGPT for, with, with an output very similar to this style, what is a good prompt I should use? And it will actually give you a prompt that you can reverse feedback into it.
Tony MartignettiReverse engineer a prompt.
Nyle MalikExactly.
Tony MartignettiAnd from a, right, from a document, from, from text.
Nyle MalikExactly.
Tony MartignettiReverse engineer it.
Nyle MalikAnd a lot of the time, um, the output's never going to be perfect on the first try. And that's just to be expected. We all have our different biases in the way that we want to see the output. So the key here is that you can talk with it and you can refine and you can further, further refine. And you should, because that will help your voice come across better. That will help you get something that you desire better than just some generic ChatGPT content off the first try. And then, you know, people start to recognize that, or—
Tony MartignettiAlfredo was saying it gets deprioritized. It just becomes obvious. I mean, you can spot it, so certainly Google and other search engines can spot it and deprioritize.
Alfredo RamirezAnd once you get to the point where I think it's important to give that feedback to arrive at some— at that output that you want, especially when it comes to prompts that you might be reusing. If you're a marketing professional or if you're a blog writer and you're constantly churning out content and you need a little bit of help with inspiration on that first draft, you want to have the best prompt possible. You probably might— I would recommend saving that prompt in ChatGPT in maybe a Google Doc or some other kind of text, uh, save text, uh, editor. And you can ask ChatGPT— I've actually done this where I'll give it something and it will give me the output, and I will say, you missed this, or you didn't include this information, or this format was wrong. And I will ask it, what— how would you update the original prompt so that you get this right on the first try. And it will give me that prompt. And I'll test it again 3 or 4 times, and it will give me exactly what I wanted.
Tony MartignettiOkay. What else? So we— okay. So iterative. So it's not uncommon. We shouldn't be frustrated if we're getting— we've got to do this 4 or 5 times.
Nyle MalikAbsolutely not.
Alfredo RamirezIt's an intern, remember? Yeah. You've got to give the intern feedback.
Nyle MalikYou've got to give it guidance and feedback. And over time, hopefully, it will get a little better.
Tony MartignettiOkay. Don't be frustrated with the first 3 or 4 or 5. Okay. Okay. What else? Well, maintaining— you mentioned in your description of the session, maintaining an authentic and personal touch. Have we touched on that already? I mean, we talked about using Alfredo's blog posts. We alluded to it. But all right, well, go ahead. So say more.
Nyle MalikI mean, so authenticity, especially now with these tools and they're kind of They're helping a lot of people in a lot of different ways. Maintaining authenticity is, is kind of key here. We want to make sure that although something else is generating maybe the bulk of the content, you're ensuring that you're looking over it and you're giving it your personal touch. Because I think as we see a lot of— and we're seeing this pop up everywhere, especially in the blogs that different companies are uploading— we're starting to recognize when we're seeing AI-generated content. And I think that is taking away a little bit from just the personal experience of seeing someone having written a blog post and seeing their original thoughts and ideas. It's not that you can't contain your original thoughts and ideas in AI-generated content. That's not at all what I'm saying. It's just that you— there needs to be an element of a human element there of maybe a proofread or a fact-check. And the way I always think about it is that ChatGPT and LLMs, they're really great for the blank page problem. That's something that I encounter all the time when I'm just looking at the blank page and I'm like, hey, I need to write about this, or I need to draft an email for this, and I just don't know how to even start. The way I found to keep my voice coming through and keep my authenticity in writing is to use ChatGPT to just put something down on the paper. And once I actually see it there and I see some kind of general output that's a little more tailored to what I'm doing, I can actually go in and start editing and start chopping it up and doing that proofreading process. And that editing process is really where I can come in and reform the message or reform the intent to better suit me as a person.
Tony MartignettiI'm going to share with you something that is my concern, my biggest concern about the use of the generative AI, which is, and it's directly related to what you're saying, Nyle, that we're ceding to the technology our most creative role. Like you're saying, looking at the blank screen. Mm-hmm. I think that's the most creative thing that we can do is to start filling that page with what flows from our mind. And we've all been there with the frustration, like, I'm not sure how to start, or should I start with the conclusion? But we worked through it and we did it. And we've emerged. Here we are. I'm concerned that we will sacrifice some of our own, the most creative stuff that we can do to the technology. And then it reduces us to the role of copy editor, proofreader. What's your reaction to my concern?
Nyle MalikI think I think it's valid, and I totally think it just depends on you personally and where you think your creative process comes in. You and I might be different in that I really struggle with that blank page problem, and that's actually not where my creativity shines. It's more when I have something that's 70% there, I can really chop it up, and my creative process happens by cutting out a bunch of text and rewriting parts of text and really getting it better to my voice. But if that initial process of the blank page is very important to inform your creative process, then you should totally keep that. That's, that's your voice. And what you should go do instead, or maybe where you could start using ChatGPT or a tool like this, is maybe a part of that process where you struggle, where maybe at the output you want to get it in a specific format, or, you know, you tend to just write in a stream of consciousness or bullet points, and then you want to reform this back into full sentences. Mm-hmm. That's probably where A tool like this could come and help you out without sacrificing any of your creativity.
Tony MartignettiAwesome. That's the best response I've heard. And I've mentioned this a few times to guests. Okay. Alfredo, you want to leave us with— well, let me ask first before you leave. Anything we haven't talked about that you want to— you think is important?
Alfredo RamirezI think I would say, again, this is still a developing field. It's early. There is so much application that is possible, especially in the nonprofit industry. And for those supporting nonprofits where demand is high, capacity is low, and we're all trying to just get the next thing done, I think it's an additional pair of hands that— and eyes— that is invaluable and will only continue continue to improve our productivity and being conscious of those elements that you're bringing up. Don't sacrifice your creativity. Be careful about the information you're sharing because all this information will— it's not necessarily public, but it will be used to further train the AI tool. And stay up to date on what is a best practice and what you should and should not be doing for these tools, because the use cases will evolve, and the applications are there for nonprofit professionals, whether it's grant writing, email writing, fundraising, event planning, uh, anything that requires text, thought, images. It's, it's going to be helpful. Um, so don't be scared. You know, follow along. It's just, it's just the start of the journey, and I think it's gonna be pretty exciting, um, for anyone that gets involved. Yeah. That's
Tony MartignettiAlfredo Ramirez. He's co-founder and chief marketing officer at Prosal. And with him is Nyle Malik, co-founder and chief technology officer at Prosal. And Nyle, I appreciate— I really appreciated your thoughtful response to my concern. I mean, I don't feel 100% allayed, but you gave it— no, really, it was very— it was a reasoned and thoughtful response. Yeah. thoughtful response to it. So thank you. Well, I'm glad.
Nyle MalikI'm glad. And, um, there's definitely room for you to use some of these tools, um, to, you know, improve your process and everything. But I think you're absolutely right. We got to keep our voice. We got to keep our creativity. We got to keep our authenticity. I think that's absolutely key as this whole world evolves around us.
Tony MartignettiNyle, thank you. Alfredo, thank you very much.
Nyle MalikThanks for having us.
Alfredo RamirezThanks, Tony.
Tony MartignettiAnd thank you for being with Tony Martignetti Nonprofit Radio coverage of the 2024 Nonprofit Technology Conference, where we are sponsored by Heller Consulting, technology strategy and implementation for nonprofits.
Kate MartignettiIt's time for a break. DonorBox. Open up new cashless in-person donation opportunities with DonorBox Live Kiosk, the smart way to accept cashless donations anywhere, anytime. Picture this, a cash-free onsite giving solution that effortlessly collects donations from credit cards, debit cards, and digital wallets. No team member required. Plus, your donation data is automatically synced with your DonorBox account. No manual data entry or errors. Make giving a breeze and focus on what matters. Your cause. Try DonorBox Live Kiosk and revolutionize the way you collect donations. Visit donorbox.org to learn more. It's time for Tony's Take Two.
Tony MartignettiThank you, Kate. Although I don't know how you could be from New Jersey and not be a Bruce Springsteen fan, but, um, thank you nonetheless. It's time to be thinking about yourself You got to be a little bit selfish at summertime so that you set time aside to refresh yourself, to relax in whatever way you do that. It may be with lots of family around or friends. It might be hiking in solitude, sitting on a beach. I'm a big endorser of Beach usage, of course, will be taking full advantage this summer. But whatever it is, more cooking, more more needlework, more working out at the gym, whatever it takes, please. I'm giving like the the annual finger wag. Think about yourself this summer. Set time aside to rejuvenate. Relax. Take time for yourself because you have to take care of yourself before you can take care of others. So please be good to yourself this summer. The finger wag. That is Tony's Take Two. Kate.
Kate MartignettiTake care of yourself this summer and make sure you listen to Bruce Springsteen.
Tony MartignettiAnd I hope you're going to take your own advice.
Kate MartignettiYeah, I know, this summer I will.
Tony MartignettiAll right, I'm gonna make sure of it though, believe me.
Kate MartignettiWe've got beaucoup but loads more time. Here is Get the Most from Your Current Tech.
Tony MartignettiWe are sponsored by Heller Consulting, technology strategy and implementation for nonprofits, and where our guests right now are both from Heller Consulting. Dana Larkin is Principal Project Manager at Heller, and Patrick McDermott is Strategy Consultant at Heller. Dana, Patrick, welcome.
Alfredo RamirezThank you.
Tony MartignettiThank you for Heller's sponsorship of Nonprofit Radio at the conference.
Alfredo RamirezAbsolutely.
Tony MartignettiFun to be boothmates. Yes. In our oversized booth, sharing a space together. Thank you very much.
Alfredo RamirezAbsolutely.
Tony MartignettiWe're talking about your session Which is, do we really need new tools? Getting the most from your current tech. Technically, it's Patrick's session, but Dana knows an enormous amount about this too, and it just made sense to collaborate together. So, Patrick, why don't you start us off? What are we missing? Yeah. Why are we sometimes going beyond what we have to accomplish what we could Part of
Patrick McDermottthe impetus for even wanting to do this session in the first place was, and I was even a victim of this too when I was in nonprofits, is you get entranced to a certain extent by all of the bells and whistles and the marketing of all of these very discrete vendors that try to solve very specific problems like appointment scheduling and those types of things. And so that really And that really kind of compelled me to look at, well, are there features that maybe aren't necessarily as well known by the platforms that you're already using as a nonprofit, Google and Microsoft probably being the 2 top ones from a kind of productivity platform standpoint, that can do a lot of these things that these discrete tools are trying to sell you on doing for a price that nonprofits just honestly can't really afford to spend a lot of resources on? Right. Could they really get away with doing a lot of what it is that they're looking to do based off of what they already have available within their technical stacks? So some of the examples that I cite in the session that I'm doing tomorrow is specifically around, say, like appointment scheduling, for instance. So Microsoft Outlook has a scheduling poll feature. Don't know if necessarily a lot of people know that. In fact, actually, there are even some colleagues of mine at Heller that didn't even know that that was a feature. And there's always this constant, like, back and forth in email exchanges with clients about, all right, let's find, like, a mutual time to meet. But if you use scheduling pool feature, you might be able to get to that result a lot faster.
Tony MartignettiOkay.
Patrick McDermottAnd some of the ways in which I've even seen nonprofit clients work is they look at solutions like a Calendly, for instance, or something like that. Not to take anything away from Calendly. I've used the service before. It's a very well-known, very good service to use. But with a nonprofit, nonprofit that is resource-strapped, if they already are a Microsoft shop or a Google shop, because Google Calendar has these appointment slot features that you can now use as well that do something very similar to that, can we just use that instead to achieve the same end and the same function without necessarily having to pay an extra subscription cost? Especially because as a nonprofit you get Google oftentimes for free or at a discounted price, and the same with Microsoft.
Tony MartignettiOkay. Dana, how about you tee us off? What can you add to our Yeah.
Dana LarkinSo, um, the other thing to think about when you are trying to make these, these technology changes is that, uh, you know, there's an element to this that is change management, and there's pieces to this that you need to make sure you get the right buy-in. And it's much easier to get that buy-in, and you're like, okay, but we already have the technology, we just need to do a little bit of change management to get it. You're going to have a lot more success. Yeah. and buy-in. So it's just going to be an easier change all around.
Tony MartignettiOkay. What if the tool is free though?
Dana LarkinThe tool is free?
Tony MartignettiLike Patrick mentioned, Calendly.
Dana LarkinYeah. So to that I would say, well, the learning curve. What's the learning curve on it? There can be free tools out there, but what is the one— the tech— you're going to expand your tech stack either way. And, you know, if you can keep it smaller, it's going to make your tech stack a lot less complex, easier to hand over, transfer, whatever it is. And, um, if they already know a tool like Outlook, it's just going to make it that much easier to give them one more little thing that they can do in Outlook versus you're now going to need a new login, you're going to need a new— you're going to have to learn this new tool and how to use it with the tool you already have, Outlook. So there's a learning curve piece to it.
Tony MartignettiAll right, you're going to need to learn the integration between Calendly and Microsoft Outlook because you want it on your calendar, don't you?
Dana LarkinExactly.
Tony MartignettiExactly. Okay. So the two of you together make a lot of sense. Like, why bother? We already got it. We've already got something that does it. Why just use the shiny new tool because everybody else is?
Dana LarkinYeah.
Patrick McDermottYep.
Tony MartignettiOkay. I think Calendly is a very easy and simple example. All right. All right. So, Um, so, Dana, let's stick with you. What are some other devices— what are some other tools that we've already got that we, like Patrick was saying, you know, even folks at Heller didn't know exist? What else might we have in our tech stack that we're not exploiting?
Dana LarkinYeah, Microsoft is the great example of like a ton of tools, because they pretty much do anything you could think of, really. You think about process mapping, for example. They have Visio for that. Um, and that comes free.
Tony MartignettiWait, what is process mapping?
Dana LarkinOh, so process improvement and process mapping, when you take a step-by-step and visualize that. Um, and so you say, okay, uh, step 1, uh, get up in the morning. Step 2, uh, go to the bathroom. You know, something like that. That you can make a process map that just lays all that out. And a lot of nonprofits use that as a tool to, uh, figure out where in their process they can improve.
Tony MartignettiSo, like how an acknowledgement letter gets out.
Dana LarkinExactly. For instance. That's a very popular one.
Tony MartignettiOkay. Maybe event management.
Dana LarkinYeah, or moves management is a big one too. Okay.
Tony MartignettiSo Microsoft has—
Dana LarkinA tool to do that. It's called Visio.
Tony MartignettiOkay.
Dana LarkinYeah. And that comes free with your Microsoft 365 subscription. It, and it does You— there is a downloadable desktop one that is more— you have to pay a little bit for that, but you can do the same things that you can do on the desktop app in their free cloud version, and it comes with your subscription a lot of times, and it's underutilized. You can even use it to make org charts, for example. It's a very easy tool to make org charts. It, again, used for process mapping, used for any visualization. Yeah. that you want to make, you can probably do that in Visio. And again, it's a free tool.
Tony MartignettiWhere do you find it? Down in the, in the, just in the search?
Dana LarkinYeah, there's like an app that, like at the top of the, I forget what they're called, the 9 dots in the top.
Patrick McDermottThe grid pattern button.
Dana LarkinYeah, the grid pattern button, um, where you would find Outlook, where you would find, uh, Word, all of the, it's in the same spot. You just scroll a little bit further and Visio.
Tony MartignettiVisio comes up.
Patrick McDermottAnother way you can also find it too is If you go to office.com, it's a Microsoft domain, and if you log into your Microsoft account, there's usually a homepage, but it also offers you kind of a directory listing of all of the apps that are a part of your subscription as well. So another example I'll also point out that's a part of the Microsoft stack is Microsoft Stream. So this is the system and the app that they use to be able to do their Teams recording. So if you're using Teams to be able to record sessions, Stream is the one that is basically like a video hosting or recording platform. Okay. recording hosting platform, but one of the other things it offers as a feature is, uh, you to be able to record screen clips of yourself and screen recordings. So if you are a kind of virtual—
Tony MartignettiA quick thank you, thank you so much to a donor for a gift, or a volunteer for reaching their 100th hour. I can just record myself and send it.
Patrick McDermottYep. Or if you're on like the IT team and you need to show people like how to do something in particular, you can do a quick recording of that, and then you can post that either on your SharePoint site, in Teams, in whatever platform that you want, because it's essentially a link that you're just embedding it into wherever it is that you want.
Tony MartignettiCan I do screen share with that? Yes, you can. If you're— if I'm— if I want to share, if I need to show someone where something is located? Yep. Screen share is included?
Patrick McDermottYep.
Tony MartignettiOkay.
Patrick McDermottAnd this, this can be in substitution of like a platform like Loom, for instance, which I know is very popular and very slick looking, and I've used it before. Nothing against it, but it's another added thing that you have to use. With Stream, however, it's already a part of your Microsoft subscription.
Tony MartignettiThese are brilliant. I mean, it's sitting in— it's like gold sitting in the subscription you're already paying.
Dana LarkinYep.
Tony MartignettiAll right, Dana, it's your turn. Name some more. Why don't we stick with Microsoft for the time being, and then we'll move to Google after a few minutes.
Dana LarkinYeah, let me think.
Tony MartignettiWhat else we got in the Microsoft stack?
Dana LarkinIn the Microsoft— oh, well, so kind of riffing off of that Stream piece, um, a lot of people are starting to get into the AI note-taking apps. And
Tony Martignettithose, we're seeing them pop up in Zoom.
Dana LarkinYeah, Microsoft actually has their own, and it can auto-generate not only the transcript from your meeting, but it will auto-generate notes, like a summary of the notes. Now, sometimes it is a little bit more expensive to to get that with Copilot. But again, it's built into your system, right? So you're not having to get another subscription necessarily. You might have to pay a little bit more with your current subscription, but it will do all the things that you're probably gonna have to pay for from a third-party vendor anyway. And you— it's like a toggle of a button, right? Copilot does that for you in Microsoft.
Tony MartignettiIt's called Copilot? No, Copilot is where you access it from, or—
Dana LarkinCopilot is the AI, like the AI that Microsoft uses, and that's the subscription that you would get. It's for Copilot, but that is a feature of Copilot to do this note-taking.
Patrick McDermottCopilot is essentially the branding that Microsoft has given all of its AI products and features, and it's weaving it into the fabric of every one of the apps within their stack. So you'll have Copilot for Word, Excel, PowerPoint, Teams, all of these different kinds of things. Okay. Okay. Um, in terms of Microsoft, another one that I'll also point out too, which is one I'm going to cover in my session tomorrow, is Microsoft Lists. So this is another app that's part of your subscription that is essentially a database product. So you're able to put together like really quick, easy, fairly straightforward databases. Uh, some of the use case examples I can think of for nonprofits are if you just need like a basic IT asset inventory, Inventory or something like that, or a quick kind of digital asset manager or something along those lines. You can use Lists as a part of your subscription instead of paying for a tool like Airtable or Coda or Notion or any of those other like really popular database applications that are now available out there that are trying to sell themselves to nonprofits. Again, nothing against those products, but Lists is already a part of your Microsoft subscription and you can do ostensibly a lot of the things that those platforms can do in a very kind of foundational way, but you don't necessarily have to pay extra for it.
Tony MartignettiRight. You don't. Okay.
Dana LarkinYeah.
Tony MartignettiIs there any more Microsoft?
Patrick McDermottI mean, Microsoft ecosystem is so large, so I'm sure—
Tony MartignettiIt's like buried treasure. All you have to do is just— you're providing them— you two are providing the map.
Patrick McDermottYeah.
Tony MartignettiNow you know how to get to it. It's waiting there. The tools are waiting there for you. Anything else?
Dana LarkinI think it's just If you think of something and you're thinking about a third party, just check first. Check to see if Microsoft can do it because there's probably a chance it's there. Mm-hmm. Um, it might not be as like clean looking as maybe the third parties are making it seem, but it's gonna be better for your users, most likely the user experience. It's gonna be, uh, most likely a lesser cost and just a much shorter learning curve.
Patrick McDermottYeah. And to be fair, you know, some of these third-party applications try and sell themselves with certain differentiating features that are more like at a premium level. And so there might be some benefits to going in that route. It all depends on specifically what your needs are as a nonprofit. But if you're just kind of looking for a base solution for an asset inventory management system or, you know, a quick screen recording or something like that, and you're not really all that interested in the extra bells and whistles, you just need something to get the job done, you probably already have something in your tech stack right now.
Tony MartignettiBrilliant. You already have it.
Patrick McDermottYeah.
Tony MartignettiAll right. Just got to find it. All right. All right. So where— I've been using Apple since like 1983. Okay. So I use Microsoft because clients give me an HP laptop, but I'm a reluctant user of Microsoft. So this may be a totally basic question, but where can you see like an inventory or a description of what you've already got in your 360? I mean, Patrick, you mentioned a place where you could go when you were talking about Stream, where you could find Stream. Where can you see something comprehensive that describes what you've got and what it does?
Patrick McDermottYeah. Advantages to more and more technology moving to web-based is that it's now operating system agnostic in a lot of ways. So this is true of Microsoft, of Google, and a number of others. A lot of the functionality that you're looking for can be found just by going to the website of the particular vendor, and you can find all of the different products that are listed in the license or the plan that you're subscribing for. Be it on the Microsoft or on the Google side. Okay. You could also do it when you're logged into your accounts, usually through a web browser. Google is a similar fashion to Microsoft. They usually have a little grid icon in the corners that when you tap on it, it lists all of the different apps that are a part of your subscription that you have access to. So Dana was talking about Microsoft. You have that grid app that shows everything there. You also have the same thing on Google. So when you click on it, you can see all the things like your Gmail, your Google Calendar, your Docs, Sheets, and Slides, your AppSheet, which is kind of the database and app builder component that's similar to Microsoft Lists. So there's a lot of parity there in terms of building tables and databases and those types of things. But you can see all of those that are available to you. And if you just click on it, it opens it up in a new tab. Or whatever kind of format they take with it. Uh, and then you can more or less just kind of like start creating like right off the bat. There's no paywall that's listed, that's listed there. Okay.
Tony MartignettiOr at least just browsing. Exactly. Know what you have. Yeah, that's right. That's what I'm just trying to get at. Like, where's the inventory? Yep. Okay. Okay. So that, that 9, the grid.
Dana LarkinYeah.
Tony MartignettiYeah. The grid is a good place for both. Yeah. Okay. All right. So then, uh, it sounds like we've exhausted the hidden, the buried treasure in Microsoft. Let's go to Google. Patrick, you started to tease a couple.
Patrick McDermottYeah.
Tony MartignettiGo ahead.
Patrick McDermottSo similar to what I was mentioning before about the scheduling poll in Outlook—
Tony MartignettiBut leave some for Dana too.
Patrick McDermottYeah, yeah, yeah. I'll just do one at a time and we'll piggyback and forth. Okay. Um, so, uh, similar to the scheduling poll in Outlook, uh, Google Calendar now has these, uh, appointment slots or appointment schedule, uh, options that it recently introduced. And so these are, uh, very similar options. Where you can block out specific time slots on your calendar to be able to then go and send that out to particular folks that you're looking to have a meeting with. It says these are the slots that I'm available for and go ahead and book it. And you can take out a lot of that back and forth emailing to be able to do that kind of thing. It's also very similar to, again, like a Calendly or a Doodle, which I know a lot of nonprofits use as well to just try and find mutual meeting times that work for everyone. This is a way to be able to garner that interest within the same ecosystem and tool that you're using. So, you know, to Dana's point before, you're not necessarily having to toggle between different tools and do a lot of context switching, which is just frustrating and takes out time in people's days to be able to get to the end result that you're really looking for, which is just a meeting at the end of the day. You just want to be able to have something on your calendar and then move on to the next thing. Nonprofits and nonprofit employees especially have way too much on their plates already, and the last thing they want to do is have to spend an exorbitant amount of time just to try and find a meeting time for folks.
Tony MartignettiAnd what is this tool called?
Patrick McDermottIt's within Google Calendar. So if you go to your Google Calendar and click on the new button, it is one of the options that now pops up. So instead of like just a new meeting, you now have an option to be able to book appointment slots.
Tony MartignettiIt's a poll.
Patrick McDermottYeah, well, it's— they don't call it a poll, they call it an appointment slot or something like that. Okay, but it's essentially the
Tony MartignettiGo to the new button.
Patrick McDermottBasically, yeah.
Tony MartignettiOK. Dana?
Dana LarkinUm, so they aren't new tools, but it's improvements on the tools that are already part of Google. So, you know, you got the power— the Slides, which is equivalent to Microsoft PowerPoint. The comparison point is always going to be Microsoft. So Google Docs is equivalent to Microsoft Word. Uh, Google Sheets is Excel. Uh, PowerPoint is slides in Google. All of the functionality was being slowly built up, and I think that's the big thing to think about with your tech stack is you need both still, because Google has come a long way in making their PowerPoint or Slides better, making their Docs, you know, very close to what you can do in Word doc. I was an early adopter of Google Drive and Google, all of that Google Suite. And I was frustrated at first because I couldn't get it to do all the things that it—
Tony MartignettiI remember that specifically on Sheets.
Dana LarkinRight? Yeah. But now they have, they, they heard the feedback and they pushed to get it closer, right? And so all of that functionality, I would double-check it if you haven't, uh, checked it in a while. I would double-check if you can do the things that you were missing before because there's a There's a great chance you can now.
Patrick McDermottOne other thing I'll also add to that as well is Google has actually made a lot of recent investments on you being able to edit a Word doc, an Excel doc, or a PowerPoint file in the native file format within Docs, Sheets, or Slides. So what that means is you don't have to convert it to a doc, a sheet, or a slide first to edit it. You can do it within its native format and still have some of that powerful functionality that Google has within the web browser, uh, and it preserves it. So if you're working with someone, like especially if you're like a Google user, for instance, but you're working with people that are adamant about using the Microsoft suite, you can do it in your own preferred Google method, but it's not going to necessarily affect what other people need to use it for in opening up in Word, Excel, and PowerPoint, because it's going to keep the file resolution— file format, excuse me.
Tony MartignettiThe format, right. Does that work by default? It does now. Do you have to select something?
Patrick McDermottNo, it does by now, because it will detect the file that you upload as either a native DOC, Excel, or PowerPoint file, and it will actually give you a little indicator next to the file name of this is a DOCX file or an Excel X file or PowerPoint X file, and it'll just indicate it for you and keep it that way.
Tony MartignettiI've seen that designation, but I didn't know why. Right. So it means that it's editing in the native In native format. After I've uploaded an Excel spreadsheet.
Patrick McDermottYep.
Tony MartignettiOkay. I saw that right after the file name, and I just thought, oh, well, yeah, I did upload an Excel sheet, so it's just telling me that. But so I can bring it back down and not have to go through the conversion process. Exactly. Download it back down. Okay. All right. That's a winner.
Patrick McDermottOkay.
Tony MartignettiYep.
Patrick McDermottOkay.
Tony MartignettiAnother one. It's not your turn.
Patrick McDermottOh, I'm sorry. I'm sorry. Sorry.
Dana LarkinSorry. No, it's okay. Go ahead, Patrick. I got to think of another one.
Patrick McDermottOkay. All right. Another one I was going to mention too, uh, which I alluded to a little bit before, is, uh, AppSheet. So, uh, Google recently had a kind of beta product that it was teasing, um, called Tables, which was kind of their answer to Microsoft Lists and Airtable and those types of things. They've now incorporated that kind of standalone beta product into AppSheet. And so essentially what AppSheet is, it allows for you to build custom applications, especially for like mobile phones, based off of data that you are storing within Google products, whether it be Docs, Sheets, those types of things. Um, and Tables is one of those components now where you're basically just creating, much like you would in Microsoft Lists, a quick database, say for instance, like an inventory system, where you put all of that information, you customize the columns and those types of things, store that information, and then you can build an application where— let's just take the example of an IT inventory, for instance. If you are on the IT team of a nonprofit and you're in your office and you just need to do maybe like a month's end inventory of how many computers you have or something along those lines, you can have this mobile app that's connected to a table that you can go and you can log, okay, this is the serial number, the asset tag for this. Right. And you can do XYZ with this, and these are the specs for that machine. Like, the use cases are almost endless, but it's based off of a free tool that's already available to you with your Google subscription that you can build that allows for that kind of functionality. I will preface it. I will say that in terms of AppSheet, Google recently offered, um, the AppSheet, uh, in a certain kind of context where it's part— partly free. Uh, as a part of your existing subscription up until like a certain tier. You could probably still do quite a lot in a really kind of fundamental, like rudimentary way with what they're already offering to you right out of the box.
Tony MartignettiAll right. Now we're talking about app development. It sounds intimidating. I know. Is that something— but is that something the average user could do?
Patrick McDermottI would say—
Tony MartignettiAgain, rudimentary. I mean, it's not going to— it's not going to look like, uh, my Delta Fly app, but—
Patrick McDermottRight. Right, right.
Tony MartignettiBasic? Can an average user figure it out?
Patrick McDermottI would say so. It has a little bit of a learning curve, I will say that. But you don't have to code at all. There's no coding involved in this whatsoever. In fact, I wouldn't even say it's like low-code, which is more of a nuance that I think us tech professionals understand a little bit more. But it's basically just all these clicks that you're making that Google walks you through in terms of a wizard. It also gives you templates that you can start. Like, if you're looking to build, like, this IT asset inventory system, it can— it gives you an option of this template that allows you to basically start not from scratch, but instead with a sample app layout and different buttons you want to click on and those types of things. And it's asking you then, what Google Sheet, for instance, do you want to link the app to as far as databases goes? And so if you spend all of your time on just building the Google Sheet and and then go to AppSheet and then tell them that you want to start like an IT inventory app and then connect it to the Google Sheet you were working on, you've already done probably 75-80% of the work. And it was mostly in the sheet that you worked in, not necessarily configuring an app for someone to be able to use.
Tony MartignettiRight. But now you've created kind of a dashboard that we can— that's more user-friendly than the sheet. All right. All right. So it's worth looking at. Yeah. Dana, did you think of one?
Dana LarkinYeah. So, um, there's a product called Google Whiteboard. And so this is on the opposite end of, you know, Patrick's going into apps. If you just want to draw something, you know, you're, you're a nonprofit professional that's a visual person, just wants to draw something, Google Whiteboard, uh, is a great tool. The equivalent in Microsoft would be Mural. Um, the third-party apps are going to be Miro or Lucidchart. Okay. You know, there are products that are now inherent for Google and Microsoft that you can just draw and, you know, brainstorm and, you know, work it out, um, collaboratively. Yeah, and you can do it collaboratively.
Tony MartignettiCollaborative whiteboard.
Dana LarkinYeah, you can do it collaboratively. You can also use these whiteboards on Google Meet calls.
Patrick McDermottYes.
Dana LarkinSo it's like, uh, it's not just a standalone board that then you share with somebody. You can also bring that board to a call and, you know, work on it together on the call, which I think is really cool.
Tony MartignettiOkay, yeah, that's outstanding. All right, all right. Anything else? Google? Buried treasure?
Patrick McDermottI would say also Google and Microsoft both have data visualization tools. So Microsoft is very well known for its Power BI platform. So you can use Power BI to do lots of different types of data visualization.
Tony MartignettiIt's not very well known.
Patrick McDermottBasically, a data visualization tool or platform is one where you take the data that you have, ostensibly mostly in like Excel workbooks and that kind of thing, and it allows for you to more visually represent what that data is saying and telling you. Okay. So your bar charts and graphs and those types of things, and you can kind of suss out different insights from those different types of platforms. So Power BI is one that allows for you to do that kind of visualization. To a certain extent, you can do that, um, as a part of your existing subscription already based off of certain Excel workbooks that you have and those types of things. And then Google has a similar product. It used to be called Google Data Studio. I think it's called Looker Studio now, but it's still a Google product and allows you to do ostensibly the same thing. So you connect it to a Google Sheet, that's your data, and then it allows for you to do these different types of visualizations and dashboards that you You can then share freely with internal colleagues, publicly, whoever it is that you want.
Tony MartignettiAll right. These are fantastic. Anything else? Don't hold back on Nonprofit Radio listeners. You all are sponsoring the show.
Dana LarkinYeah. I'm thinking, like, really, you can start using Microsoft for, you know, your CRM now. And I don't know how widely that's really known in the nonprofit world. You know, there's always these big names of CRMs. Microsoft has become a really big player. So look into that as well if you're looking to transfer from your Excel sheets to something more user-friendly, maybe something that's a little more robust and can do data in a different way and give you statistics.
Tony MartignettiIs there a tool, a CRM Microsoft tool?
Dana LarkinYeah, it's called Microsoft— it's like Fundraising and Engagement is one of the ones that we recommend to nonprofits, and it is an actual CRM. It's an extra cost, of course, but, you know, it's, it's not something that maybe is top of mind for listeners or for nonprofit professionals, right? It's— they are newer to the space, relatively newer. They've still been around for a while, but they've really made an investment into nonprofits and what they need. So they've made modules that work for fundraisers. They've made it work so that you can do all your emailing, your mass emailing, through this Microsoft CRM. So it's just another, you know, it's a big one actually, but maybe your listeners might not know as much about it.
Tony MartignettiYeah. Would you say it's as robust as Salesforce?
Dana LarkinYes, it's a competitor. Really? It's, it's a, it's a very good competitor actually. And, you know, cost comparison is really a lot of what our clients come down to is when they're looking at the two, and Microsoft has a good price point. And if they're— again, if their users are already using Microsoft products, that learning curve again, it's just— there's a big benefit. Um, so this is brilliant.
Tony MartignettiI don't think anybody knows about you all, but I don't think the vast majority of people know that Microsoft has a CRM product.
Dana LarkinYeah, yeah, yeah. And, and we help implement that product, so we are seeing the, the really the big benefits for our clients getting to use that and finding out, oh, this exists? Oh, I already know Microsoft. This looks exactly like I've been using for years. And when you get to a product like Salesforce, it's just a little bit bigger. It's way different. And so the learning curve, again, is just so high that some people, they just don't have the time or the investment that they can put into a product like Salesforce. Microsoft Microsoft can do almost everything.
Tony MartignettiYou keep coming back to the learning curve, which is important. It's just the way it looks. It just looks comfortable to me because I know Microsoft. To me, me personally, Tony Martignetti, Apple looks comforting to me. The fonts, the organization. I think more like Apple because I've been using it since 1984 than I do Microsoft. Microsoft is still a little elusive to me for some things. But, uh, but yeah, it's just to come— I mean, Dina, I'm just, I'm reemphasizing your point, the comfort level, and even just to the, the appearance. It's just, it just feels like a friend.
Dana LarkinYes.
Tony MartignettiIt's somebody I already know. It's something I already know. Let's not get carried away. Somebody— it's something I already know. I recognize it. Okay. And I've, I've worked with it for years. All right. So, all right. Microsoft CRM. So tell me, how again would you access it? You have to This is something you would have to purchase.
Dana LarkinYeah, you'd have to purchase it. You would want to go through Microsoft to purchase it. Um, but, uh, then it is just in your— again, that, that 9-dot. Uh, I have been in that. You just click that 9-dot and you go to the CRM section and you can see your, your full database.
Tony MartignettiOkay. Okay. That's a brilliant— they're all brilliant, but that's— that particularly because I don't think most people are thinking about that at all because there are so many CRM Yeah. Um, and they all look shiny and new and—
Dana LarkinYeah, yeah.
Tony MartignettiBut you don't have to. You don't have to go that way. Consider, like you said, consider Microsoft as a CRM vendor.
Patrick McDermottYeah. I mean, Microsoft has a lot of, of, of help and assistance that it's providing nonprofits, and it's very, um, focused on trying to discount its products as much as possible for nonprofits that could really benefit from them. as well, um, and offer add-ons as well. Like, one of the things that I'm also going to be mentioning in my session tomorrow is, you know, if you are in the Salesforce or the Microsoft ecosystem and you need like a volunteer management solution, there are discrete ones that you could pay for that are third-party apps, but Salesforce has a Volunteers for Salesforce app that you can install for free. Mmhmm. And then there's also Volunteer Management and Engagement on the Microsoft side that you can also install for free. It might require a little bit of configuration for you to be able to get the best, uh, the best, um, kind of usage out of it, depending upon what your needs are. But there are free add-ons that you can install that are going to work within your existing ecosystem and structure, uh, that you can start using right now.
Tony MartignettiOkay. Patrick, we, uh, we opened with you, so we're going to close with Dana. Give us, uh, just give us a little more motivation and comfort about what we may very well— we do already have, and why it could very well be sufficient.
Dana LarkinYeah, I think, uh, you gotta take the, take the time to research. That's like our main message. Maybe you do end up with a third-party app, but do the research to really understand what it is that you're paying for, because everybody knows in nonprofit, those dollars really matter. They're going to the communities, they're going to the places that are getting impacted the most. And so when you spend even a couple more dollars on a product that you don't need, that's money you're taking away from whatever cause it is that you are trying to, uh, you know, bring, uh, light to, right? Mm-hmm. So if it just takes you 10 minutes more to just check if Microsoft does that, check if Google does that, you know, that's that much more impact that you can give to the community. And it's going to make your staff a lot happier. You know, we're hearing about burnout a lot. If they don't have to learn a new product, like I've been saying, if they don't have to learn something brand new, you're going to have happier staff. You're going to make more impact. You're— it's— there are many benefits to this. So just take the 10 minutes.
Tony MartignettiThat's Dana Larkin, Principal Project Manager at Heller Consulting. And with her is Patrick McDermott, Strategy Consultant at Heller Consulting. I thank you both again for the Heller sponsorship. Yeah, we're Heller Consulting. Technology strategy and implementation for nonprofits.
Patrick McDermottThanks for having us.
Tony MartignettiThanks, Dana. Thank you, Patrick.
Dana LarkinThank you so much.
Patrick McDermottAbsolutely. Thank you.
Tony MartignettiAnd thank you for being with Tony Martignetti Nonprofit Radio coverage of 24 NTC.
Kate MartignettiNext week, we'll depart from 24 NTC with experiential fundraising. If you missed any part of this week's show,
Tony MartignettiI beseech you, find it at tonymartignetti.com.
Kate MartignettiWe're sponsored by Virtuous. Virtuous gives you the nonprofit CRM, fundraising, volunteer, and marketing tools you need to create more responsive donor experiences and grow giving. virtuous.org. And by DonorBox. Outdated donation forms blocking your supporters' generosity? DonorBox, fast, flexible, and friendly fundraising forms for your nonprofit. donorbox.org. Our creative producer is Claire Meyerhoff. I'm your associate producer, Kate Martignetti. The show's social media is by Susan Chavez. Marc Silverman is our web guy, and this music is by Scott Stein.
Tony MartignettiThank you for that affirmation, Scotty. Be with us next week for Nonprofit Radio, big nonprofit ideas for the other 95%. Go out and be great. Thank you.
I love our sponsors!

Virtuous
Virtuous gives you the nonprofit CRM, fundraising, volunteer, and marketing tools you need to create more responsive donor experiences and grow giving.

More Episodes from 2024 Nonprofit Technology Conference
View All


Exploit Conflict & Intuition To Make Better Programs & Products
with Drew Nelson, Cassi Johnson, and Eve LaCivita




Use Your Tech To Enable Generosity
with Jamie Mueller, Peter Genuardi, and Natania LeClerc



