On this page
- Create a group for your team
- Share the project plan
- Present the project plan
- Comment on a spreadsheet
- Chat with collaborators in a spreadsheet
- Get notified about spreadsheet changes
- Archive your completed project plan
Create a group for your team
To make sharing easier, create a Google Group for your team.
- Sign in to Google Groups.
- At the top, click Create group.
-
Enter information and choose settings for the group.
- Click Create group.
Wait a few minutes for your new group to become active before sending a message to it. Otherwise, you might get a notification that your message couldn't be delivered.
Learn more at the Google Groups Help Center
Share the project plan
- Create a file in Google Drive, or open an existing file.
- In the file, click Share.
- In the Invite people field, enter the group's address.
- Select the level of access you want to provide the group: Editor, Commenter, or Viewer.
- Click Send.
Learn more at the Google Drive Help Center
Present the project plan
Attach the project plan to a meeting invite
Make sure everyone has the latest copy of the project plan before the meeting—attach your project plan to the Google Calendar meeting invitation. Team members, both onsite and remote, can access and update it in real time. You can even spend the first few minutes of the meeting getting status updates from everyone, and updating the project plan accordingly.
- In Calendar, open your event.
- Click Add attachmentGoogle Drive.
- Find your project plan spreadsheet and click Insert.
- Click Save.
Present the project plan in a team meeting
Present your project plan during your team meetings so everyone, including remote members, are on the same page.
- Join your meeting in Google Meet.
- In Sheets, open your project plan.
- At the top, click Meet Just present this tab.
- Click the tab you want to share and click Share.
Upload the project plan to a team website
Share a master copy of your project plan on your team website. Updates to the spreadsheet automatically appear on your website.
- In Google Sites, open the page on your website where you want to embed the spreadsheet.
- At the top of the page, click InsertSheets.
- Choose your project plan and click Insert.
Learn more at the Google Sites Help Center
Comment on the project plan
- On your computer, open a document, spreadsheet, presentation, or video.
- Highlight the text, images, cells, slides, or scenes you want to comment on.
- To add a comment, in the toolbar, click Add comment .
- Type your comment.
- Click Comment.
Learn more at the Google Docs Editors Help Center
Chat with collaborators in a spreadsheet
- On your computer, open a document, spreadsheet, or presentation.
- At the top right, click Show chat . This feature won't be available if you're the only one in the file.
- Tip: If there are many collaborators in the file, at the top right, to the right of the avatars, there will be a blue circle showing the number of additional collaborators. Click the blue circle Join chat .
- Enter your message in the chat box.
- When you’re finished, at the top right of the chat window, click Close .
Note: All chats in Google Docs, Sheets, and Slides include anyone viewing the file. The chats aren't saved.
Get notified about spreadsheet changes
If you need to know immediately when someone changes your spreadsheet, set up an email notification.
You’ll know exactly what’s changed and who to ask for details.
Set up email notifications
- On your computer, open a spreadsheet in Google Sheets.
- At the top, click Tools Notification settings Edit notifications.
- In the window that appears, select "when" you want to receive notifications. Notify you when:
- Any changes are made: Set notifications when someone makes a change to a spreadsheet.
- A user submits a form: Set notifications when someone fills out a form.
- In the window that appears, select "how often" you want to receive notifications. Notify you with:
- Email - daily digest: Send a daily summary of all changes.
- Email - right away: Send an email for every change.
- Click Save.
Learn more at the Google Docs Editors Help Center
Archive your completed project plan
You can rename your completed project plan to mark it as archived and then change the permissions on it to view-only. People can view the content but won’t be able to make changes.
Rename your project plan in Sheets
- Open the file and at the top, click the file name.
- Before the file name, enter [Final] or [Archived].
- Press Enter.
Change access to view-only
- In Google Drive, right-click your project plan and click Share .
- To the right of the group you want to change, click the Down arrow Viewer.
- Click Save.
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.