Getting Started with Google Sheets

Creating a New Calendar

You can quickly add a new calendar based on a Google Sheet. Here's how.

1. Copy the URL of your Google Sheet

  • Find the Google Sheet you want to use and copy its entire URL from your browser's address bar.

2. Click "Add New Calendar" in DayBack

  • Go to DayBack's admin settings at DayBack Settings.
  • In the left-hand sidebar, click on "Google Sheets," and turn its visibility to "on" if it isn't already. Here's a brief article showing you how to turn on Google Sheets and Authorize with Google.
  • Click "Add New Calendar," give your calendar a name, and paste the URL into the field labeled "Google Sheet URL."

Don't See "Google Sheets"?

If you don't see "Google Sheets" in the settings sidebar, ensure you are logged into DayBack as an administrator.

3. Enter Your Date & Time Format

  • There are several optional fields below the sheet URL for specifying parts of a sheet. Fill those in if needed.
  • Locate the "Sheet Date Format" setting in DayBack. Match the date format from your Google Sheet and enter it here. For example, if your sheet displays dates like 2020-04-26 , enter YYYY-MM-DD . A comprehensive list of date formats is available here.
  • Remember, this isn't the format you wish to see in the calendar: this is how the dates are showing up on your Google Sheet. You're telling DayBack how to interpret your dates.
  • After entering the date format, proceed to the "Sheet Time Format" field and input the time format used in your sheet.

4. Enter your sheet's column names into DayBack

  • Click on "Field Mapping" at the top of the screen.
  • For each calendar field in DayBack, enter the heading of the corresponding column from your Google Sheet. Column names are typically letters like A or BD.
  • Repeat this process on the next tab to create any custom fields you’d like to see in the calendar, such as currency fields for tracking money.

That's it!

  • Click "Back to Calendar" in the upper-left of DayBack settings. You should now see the rows from your Google Sheet displayed as events on your calendar.

Who Can See Your Sheet?

DayBack respects the sharing settings you've assigned to your Google Sheet. To allow other users in your DayBack group to see your calendar, make sure to adjust the sharing options for your sheet and share it with everyone in your G-Suite group.

You do not need to make the sheet "public" to share a read-only version with DayBack. The sharing feature in DayBack exports the information visible on the calendar, so recipients don't need access to the original source—your Google Sheet. Learn more here: Publish & Share Your Calendar.

Going Further: Adding Images

If cells in your Google Sheet include URLs to images, DayBack can display these as thumbnail and featured images for each event. Learn more here: Featured Images & Thumbnails.