How to Use Google Sheets With Calendar, Keep, and Tasks

5 suggestions for using Google Sheets with Keep, Tasks, and Calendar, now that they're instantly accessible in the spreadsheet side panel.

Just like Google Docs and Gmail, the side panel in Google Sheets now features quick access to Keep, Tasks, and Calendar:

  • Google Calendar: Quickly reference, create or edit invites.
  • Google Keep: Easily take notes, create lists, and see your other content.
  • Google Tasks: Manage your tasks and to-dos.

As noted on Google’s blog, linking these three products will help you work more efficiently within and across G Suite.

We have a few suggestions for how you might use Keep and Calendar in Google Sheets. First, a quick overview of each of the products in the side panel.

Google Keep

Google Keep

Google Keep is a simple yet powerful memo and notes app. It’s perfect for saving an idea on the go, creating shopping and to-do lists, and capturing ideas as you browse the web.

With Keep, you can save notes, lists, photos, and audio. You can also clip webpages as you browse the web.

Keep is available anywhere you get online. It automatically syncs across devices. Use it as a mobile app, in your browser of choice, or as a Chrome extension.

You can color-code notes, label notes into sortable categories, create checklists, and invite collaborators to share lists. Because it’s a Google product, searching notes in Keep is fast and fluid.

More about Keep in the Google Learning Center

Google Tasks

null 4

Google Tasks first appeared in Gmail. Indeed, in Google’s Learning Center, Keep is still only listed in the Gmail help section.

As Techcrunch notes, “The app itself is a fairly standard take on to-do lists. You can create and manage your task list in the app, and break down tasks into subtasks. The app keeps things simple by not allowing you to set a time to be reminded — just a date.”

It’s worth noting that Google Keep also acts as a to-do list. You can create checklists within notes, and you can even add reminders to said notes.

Tasks is great for very simple running lists, but Keep is a more robust tool for to-do lists.

Here’s a comparison of the features of Keep vs Tasks

Google Calendar

Google Calendar

You already know about this ubiquitous app.

“With Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.”

Calendar also features tools for creating reminders and to-dos. Wired has a great guide for using Keep and Calendar together for the “Best To-Do App Ever

How to Use Calendar, Keep, and Tasks Together in Google Sheets

Tiller is planning on building on the new side panel tools in Google Sheets. But to get you started, here are five ideas for you might use Keep, Calendar, and Tasks in Google Sheets today.

1- Easily Log Receipts in Google Sheets With Snapshots from Keep

Receipts in Google Keep with Sheets

You can snap photos and store them directly in Google Keep. This makes it easy to log receipts, car mileage, invoices, and other data you might later want to add to Google Sheets.

2- Create Bill Payment or Subscription Cancelation Reminders

Google Calendar in Google Sheets

As you’re categorizing your financial transactions in Google Sheets, you can quickly create a repeating bill payment reminder in Google Calendar.

You can also flag subscriptions with a reminder and alert to cancel in Calendar or Keep.

3- Track Historical Grocery Costs in Your Shopping Lists

Shopping List in Keep in Google Sheets

If you keep your grocery list in Google Keep and track your grocery costs with Tiller (or manually) in a Google spreadsheet budget, you can easily add total

4 – Collect Data in Keep as You Browse the Web to Analyze in Google Sheets

Chrome Keep Extension

When you use the Google Keep Chrome Extension, you can easily save page links, text and images as you browse the web. You can also take notes on saved content.

You might gather while researching prices or products while browsing the web. Then, later, you can easily cut and paste that data into Google Sheets.

You could also use keep while gathering stock symbols and trading data as you build your own investment spreadsheet.

5 – Learn Google Spreadsheet Shortcuts and Functions

Google Spreadsheet with Receipt

Mastering keyboard shortcuts and functions is essential for mastering Google Sheets.

You can easily create a list of your favorites in Keep. Simply open the side panel and find them there. Maybe you’ll eventually memorize them all and can delete the note.

In the meantime, here’s a list of Keyboard shortcuts for Google Sheets. Here’s a list of Google Sheets functions.

Edward Shepard

Edward Shepard

Marketing Lead at Tiller. Writer. Spreadsheet nerd. Get in touch with partnership ideas at edward @ tillerhq.com.

Leave a Reply

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023