Event Creator creates Google Calendar event automatically

from Google Form submission and Google Sheets data

Install      Demo

Google Form

Use Google form for booking events.


Google calendar

Booking events will be shown in Google calendar.

Google Forms to Google Sheets to Google Calendar



Create event(s) automatically

The booking(s) from Google Form will automatically show in Google Calendar when the form was submitted.

Creates multiple events

In just a few clicks, you can create multiple events from your spreadsheet.

Booking and scheduling

Creates Google Calendar events from your spreadsheet or Google Form



Other Features:




Any changes on the spreadsheet will automcatically reflect in the Google Calendar.


The title and description of events can be customized programmatically. E.g. the title can contain start date field, location field, etc...


You can actively send an email to the support team regarding any issues.



Some Screenshots





Pricing

  • Pro
    $1.99/month(*)
  • 10,000 events/day
  • Create 5 events per time
  • 1 Google account
  • -
  • Technical support
  • -
  • Google account
  • Premium
    $7.99/month(*)
  • 10,000 events/day
  • Create 15 events per time
  • Unlimited users by domain
  • Create event from form submission
  • Full support
  • -
  • Your domain
  • Premium+
    $19.99/month(*)
  • 10,000 events/day
  • Create 25 events per time
  • Unlimited users by domain
  • Create event from form submission
  • Full support
  • Remote Support via TeamViewer (?)
  • Google account/your domain

(*) billed annually
Debit or credit cards (Visa, MasterCard, American Express,...) are accepted. Paypal account is accepted.



FAQ



  1. 1. First, open your Google Sheets and open the add-on setting by choosing Add-ons menu → Calendar Events Creator → Set up
    2. Second, set up the add-on:
         • Set the event title
    Set event title         event creator: select a column to be event title
         • Set the event time
    event creator: set up event start/end time
            Note:
              - uncheck All day if you need 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
         • Select calendar
    3. Third, click Apply Setting to save the setting.



    Set up Calendar Events Creator add-on, setting: Google Sheets to Google Calendar, Form to Calendar

  2. Open your spreadsheet.

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

  3. Open Google Sheets

    Select the range of rows you want to create 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. When user changes the event's value, the created event will be updated automatically.

  5. 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.

    form to Calendar
  6. 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 event(s) hyperlink.

    Step 4: Click Apply Setting.

    show created events
  7. Solution 1: Check if the event time is valid. If the event date/time is invalid, event will not be created on the calendar.

    A valid date is right-aligned and has a calendar picker. See below:: check valid date
    Note: Event start date/time should be sooner than the event end date/time.

    Solution 2: Select the correct column for the event time. select event time

    Solution 3: Set the date format. The add-on may not understand your event date format correctly. Set the spreadsheet locale to yours by going to File →Spreadsheet settings...

    change spreadsheet locale

  8. To solve the problem, try one of the following solutions:

    1. First solution: Clear your browser's cache & cookies.
    If you're using Chrome follow these steps:
    - On your computer, open Chrome browser.
    - At the top right, click More.
    - Click More tools and then Clear browsing data.
    - At the top, choose a time range. To delete everything, select All time.
    - Check the boxes next to "Cookies and other site data" and "Cached images and files”.
    - Click Clear data.

    2. Second Solution: Re-install the add-on by:
    - Remove the addon: from your Google Spreadsheet → Add-ons menu → Manage add-ons... → Calendar Events Creator → Manage → Remove
    - Install addon again: Add-ons menu → Get add-on → Search 'Calendar Events Creator’ → Click Free icon → Follow steps

    3. Third Solution: Open your Google spreadsheet in Incognito mode or a different browser (Ctrl+Shift+N)


  9. 1. First, open add-on setting by choosing Add-ons menu → Calendar Events Creator → Set up
    2. Second, check ✅ Add guests to select the column that contains the email addresses.
    event creator - form to calendar - send an email invite to multiple people
    ⇨Then, select the column that contains the email addresses to send an email invite to multiple people.
         • Email addresses: Use a Comma as a Separator.

    Example: EmailAddress1@gmail.com, EmailAddress2@example.com, EmailAddress3@icloud.com

         • If the email addresses are in more than one column, use the fomula to join:
               =JOIN(",",H5:I5)
    Use a comma as a seprator - join fomula
    3. Third, check ✅ send notifications.

    4. Finally, click Apply Setting.

  10. There are two solutions:
         1. Change your spreadsheet's timezone and Google Calendar's timezone to your current timezone.

         2. If the first solution doesn't work, try to change your spreadsheet's timezone and Google Calendar's timezone to Eastern Time.


    To change your spreadsheet's timezone, choose File ➡️ Spreadsheet Settings... Then, select (GMT -05:00) Eastern Time on Timezone field.

    Finally, create event again by submitting form or by selecting a row and choose Add-ons menu ➡️ Calendar Events Creator ➡️ Create event (s)

  11. To automatically add video call to the created events, create a Hangouts link in the event descriptions and invitations,
    1. On your computer, open Google Calendar.
    2. On the top right, click Settings menu icon ⚙ ➡️ Settings.
    3. Select Event settings on the left side bar.
    4. Check Automatically add video calls to events I create.

    create a Hangouts link in event descriptions and invitations

    Note
    If you do not want to add video call to events automatically, just uncheck Automatically add video calls to events I create.


  12. It is possible to simply start over. You can remove the add-on and then install it again (at no charge).
    Firstly, uninstall the add-on:
    1. On your computer, open a spreadsheet
    2. Click Add-ons ➡️ Manage add-ons...
    3. Choose Calendar Events Creator add-on from the list.
    4. Click Manage ➡️ Remove.
    Then, install the add-on again:
    1. On your computer, open a spreadsheet.
    2. Click Add-ons and then Get add-ons.
    3. Search "Calendar Events Creator", click the add-on on the result.
    4. To install the add-on, click Free.
    5. A message will appear requesting access to data that the add-on needs to work. Read the message, then click Allow.


    Note:
    1. Re-installing the add-on will reset some settings. It doesn't change your plan or your quota.
    2. If you get this notification: "ScriptError: Authorization is required to perform that action", sign out of the other Google account(s) that you might have been signed into and clear the data browsing. Then, log-in using the Google account you have installed the Calendar Events Creator add-on.





Drop Us A Line