No matter how advance Project Management and CRM tools can get, no one can ever ditch Google Sheet.
Google Sheet is still one powerful tool that if you know how to exploit the service to your advantage, you know that it's more than just a spreadsheet-editing software.
And if you're using Google Sheet as an additional tool aside from your usual project management service, here's a nifty tip on how to enable email notification so you'll be notified in real-time whenever a collaborator is making some updates on a shared spreadsheet; no need for you to waste time waiting for hours for other collaborators to update the sheet.
Enable Email Notification On A Shared Google Spreadsheet
Email notification for Google Sheet is actually a built-in feature, but not activated by default. You have to manually enable it to start receiving email notifications. Here's how:
- Open the spreadsheet where you want to get notified for any changes.
- Go to the Tools > Notification rules.
- In the window that popups, select when and how often you want to receive email notifications.
- “Any changes are made”
- “A user submits a form”
- How often:
- “Email - daily digest”
- “Email - right away”
- Hit Save.
You're done. Whenever someone made some changes on a shared spreadsheet, you'll be automatically alerted via email, like this:
You may also need to setup email push notification on your smartphone so that no emails will be missed.
Google Sheet is still my go-to place when it comes to working and collaborating with clients for a specific project. During a website pre-deployment, after the QA, we have a client review phase where a client is expected to inspect and jot down all design & functionality hiccups of a website. While BaseCamp, Asana or Teamwork may be used to collect the findings, I find it a lot time-saver and efficient if I can get a consolidated view of all findings inside a single Google sheet. And now that I can setup email notification, both the client and I can save time.