Pav*r is a great tool for organizing your Google Calendar events with Categories and Labels. With pav*r, you can export your Calendar to a Google Sheet where you’ll see an at-a-glance view of how you (or your team) spent your time.
This is a step by step guide that will teach you how to set up pav*r to optimize how you spend your time and, hopefully, provide you with valuable insights and analytics around our most precious resource.
Before we begin, make sure that you have installed the pav*r Google Calendar add-on from the G Suite Marketplace.
To begin, launch the pav*r add-on from the Google Calendar toolbar.
If this is your first time using pav*r, you’ll see the Welcome card.
Click LOG IN to get started.
Once you log in, you’ll be directed to create your profile.
Now you’re ready to connect your calendar. Select the calendar you’d like to connect from the dropdown. You will see every available calendar that is shared with you listed on the dropdown.
Tip: If you’d like to setup multiple calendars, simply complete the setup for the calendar selected, create your categories & labels, then navigate to the Calendar Settings screen and you will have the option to set up a new calendar.
Now that you’ve connected your calendar, you’re ready to configure your Categories & Labels.
Select ADD CATEGORY to begin adding your categories. This is also where you will select the color for that category.
Select ADD LABELS to begin adding your labels.
Note: Multiple labels may be applied to a category, but only one category may be selected for a calendar event.
You can now begin adding Categories & Labels to your calendar events!
Make sure that pav*r has been launched from the toolbar, then click on the event you want to apply a category and label to.
Note: You must first create the event before you can apply the category and label. This can not be done during the event creation stage.
Once you’ve applied your Categories & Labels you’re ready to begin exporting your calendar data & creating your first report!
We recommend doing this weekly or monthly.
To create your export, click on the three verticle dots and navigate to Export Calendar.
From there you’ll enter the date range you want to export to Sheets.
Once you’ve entered your date range and clicked EXPORT, you’ll be directed to another card.
Select GO TO SHEET to access your export!
Upon opening the Sheet you’ll see the DASHBOARD tab, which will show you how many total events and event hours were exported, along with a pie chart of both your Category and Label breakdowns.
The CALENDAR ENTRIES tab of the sheet will show you a spreadsheet view of all of the exported calendar events.