Create calendar events automatically

Get Started

1. Read first: How to set up the Calendar Events Creator add-on? (click to read the answer)

For the first use (beginner), please read the basic setting.

The basic setting (Start)

1. Open your Google Sheets and choose Add-ons menu → Calendar Events Creator → Start
2. Select your calendar (for a shared calendar, you need writing permission from the owner).
3. Select the column contains valid dates (a valid date will be right-aligned of a cell)
4. Click Event Start Date on the right sidebar to set the date of the selected column to be the start date of the event.
5. Choose a column that you want to view the result in and click the Status column button.
6. Finally, choose a row and click the Create event(s) button to create an event for the row (details of the event will come from the selected row's data).

Automation
• Check ✅ Form submit to automatically create event by submitting a form.
• Check ✅ Update event automatically to automatically create event when new data row added or update event if changing spreadsheet data.
The advanced setting
1. From your Google Sheet, choose Add-ons menu → Calendar Events Creator → Set up
2. Select a column to be event title

   Customize event title

   Hi <<A>>

   <<A>> is column A. It means that the add-on will add values of column A to calendar.

   Some examples:

   The Sheet	The Setting	The Created Event

3. Set the event time.
   • Uncheck All day to add event start time and event end time.
   • If you don't have end date/time, select event end date/time as same as event start date/time.
   • Event start date must be sooner than the event end date.
4. Select your calendar
5. Click Apply Setting to save the setting.
6. Finally, choose a row and choose Add-ons > Calendar Events Creator > Create event(s)to create an event for the selected row.

Animation for the instruction:


Options
• Recurrence events. Check ✅ Repeat and choose daily, weekly, monthly, yearly
• Add guests/ Invite guests, send notification to invited guests' email addresses.

  Check ✅ Add guests and choose a column contains email addresses

  Use comma , to separate email addresses. E.g. acc1@gmail.com, acc2@gmail.com

• Formatting bar for event description: bold, italic, center, justify, order list, emoji icons, insert link, etc..
• Support 11 event colors.
2. How to create Google Calendar events?

Open your Google Sheets spreadsheet.

Select the entire row or any cell in a row, then choose Add-ons menu → Calendar Events Creator → Create Event(s).

3. How to create multiple Google Calendar events at the same time?

Open Google Sheets

Select a range of rows you want to create events and choose Add-ons menu → Calendar Events Creator → Create Event(s)



Note: Due to limitations for Google Services, create less than 25 events at the same time for best results.

4. How to update event(s) automatically (Google Calendar Sync: Google Sheet to Google Calendar)?

Choose Add-ons menu → Calendar Events Creator → Start → Check ✅Update event automatically

When changing a spreadsheet row data or adding a new row of data, the created event will be updated or created automatically.

5. How to create events automatically by submitting Google Form?

Step 1. Create a Google Form.

Step 2. Create a spreadsheet for responses in Google Sheets.

Step 3. Set up the add-on. (As shown on question number 1. )

Step 4. Check ✅Create events by submitting form . Then click Apply Setting.

6. How to view created events?

Step 1: Open the setting by choosing Add-ons menu → Calendar Events Creator → Set up

Step 2: Check ✅Enable status view

Step 3: Select a column to view created events' hyperlink.

Step 4: Click Apply Setting.