 So a big theme of this conference has been the need to communicate and collaborate effectively in a remote first workplace In the next demo Fiona Soderbergh of Google for nonprofits will cover some tips nonprofits get the most out of Google forums calendar Hi everybody, my name is Fiona Soderbergh and I'm a program manager at Google org today I'd like to go over three quick tips for nonprofits for Google workspace First off, what is Google workspace? Google workspace is Google's suite of productivity and collaboration tools for Google workspace for nonprofits You get access to one addition and that gives you the familiar tools like email docs calendars and slides And then you also have the option to go to a discounted more advanced version if you'd like Like I said, it's the those familiar tools that are designed to work from anywhere on any device Which is specifically and more important during the pandemic It allows you to connect and collaborate in real time with team members donors and volunteers It gives you great storage of 30 gigabytes per user and shared drives And also gives you access to google classroom, which is great if you're hosting trainings or events The three tips that i'm going to cover today is google forums how to quickly and easily make a spreadsheet from your volunteer sign up Google calendar create and publish an events calendar for your organization And then google groups create groups to communicate with members and volunteers All three products within a google workspace Firstly, how to make a spreadsheet from your volunteer sign up form Do you ever send out forms to your volunteers get a bunch of data back? Wish it was already in a sheet so that you can manipulate the data and crunch your numbers as you like I can show you how to do that in one quick click The first thing that you're going to want to do is go to forms.google.com to see your database of all the forms attached to your account Click on the form that you would like to make the spreadsheet for It'll open up the list of questions that you have created for your survey or your form that you've sent out to your users There's a responses tab where we'll have a summary of all those responses that have come back to you And then the really neat thing is at the top on the right hand side. There's a sheets icon And with one click you can click on that And you create a spreadsheet of all of that data for you to be able to manipulate send out Do whatever you'd like with it The next tip is how to create and publish an events calendar for your organization So if you ever struggle trying to get all your volunteers to get the right details of an event You don't want to show your personal calendar or your work calendar Well, this is a way to create a calendar for the public for volunteers Whoever you want to be able to see specific calendar meetings and invitation First thing you do here is go to calendar.google.com on the left hand side above other calendars There's a plus button and you can create a new calendar Provide a name and description Here i'm going to make sure to give a description that reminds me that it is a public calendar So that I know that i'm posting public events here You can create the calendar and it'll show up on the left hand side navigation of all the calendars you own You can click into it and then have Access to all the settings like access permission for events. You can make the event the events public You can also copy the link to share the calendar with your volunteers wherever it is You can also directly add users to the calendar so they can edit and also share and use the calendar as well So I've made this calendar publicly available. I've copied the link. I can share it with who I want to I can also create an event on my personal calendar or my work calendar So let's say it's a meet and greet and I can change the calendar to be that of the public account events calendar that I want Click save it's color coded. So I know the difference and then it is available to all those users who have access to the calendar The next one is how to create groups to communicate with members and volunteers Have you ever struggled keeping a sheet full of all your volunteer email addresses? G-mails MSN yahoo whatever it is. Would you like an easy way to be able to email all your volunteers in one place easily and quickly? Well, we have google groups, which is a great solution for this. So if you're at groups google.com Left hand side click create group You want to name the group something that is indicative of those folks who will be joining the group So let's say nonprofit volunteers here that will be the first part of the email Aliens followed by your organization's domain You can create it and choose who can search for the group who can join for the group And then who can view conversations can post and view members This way you're setting up that group for only the people that you want to add And if you either add them directly yourself or you can go ahead and share the group with them And they can request to be added as well. You can add a quick welcome message for anybody who does join Just as a reminder of what the group is for So there you have it once you add all the users to this group Then you have one email address that you can send out an email to all of your volunteers So how do you get all of these great tools under google workspace for nonprofits? First you need a google for nonprofits account. You go to google.com slash nonprofits Review the eligibility requirements to make sure that your organization is eligible Request an account by clicking get started in the upper right hand corner Wait for verification with techsuit and then you can activate and use the suite of google products and tools that we have for nonprofit users Specifically for workspace that means signing up for google workspace Verifying your domain Submitting it for review and then signing into google workspace admin console and get going But all this can be found at google.com slash nonprofits. Thank you