What is Google Calendar Integration?
Google Calendar integration uses results from your form to create new Google Calendar events or add attendees to your existing Google Calendar events.
Requirements
The Google Calendar integration feature requires a Professional level Formsite account and a Google account.
Create a New Integration
On your form's "Integrations" page, click the integration for "Google Calendar". Then, click the "Get Authorization" button to authenticate and connect with your Google account. You'll be asked to log into Google if you're not already. When you're finished, click the "Save" button.
Collecting Google Calendar Results
The Google Calendar integration page allows you to select one of the calendars from your Google account having at minimum the "writer" access role.
The integration offers the following 2 modes:
Create a new event: When a form user completes your form in this mode, their result will create a new event in your Google Calendar and optionally add an attendee to the event.
The integration supports creating All Day events or Timed events. The time zone for a Timed event will be the same as that of your Formsite account. You may change the time zone of your Formsite account by going to your account's "Profile" page.
The "Event start" and "Event end" settings allow mapping with Calendar items. Additionally, you can map items like Short Answer, Hidden Field, Radio Button, Dropdown, etc. Acceptable date formats entered via these items are "12/31/2020", "12-31-2020", "2020-12-31", "31 December 2020", or "December 31, 2020". Start and End time settings can be mapped from Short Answer, Hidden Field, Radio Button, Dropdown, etc. Acceptable time formats entered via these items are "15:30" or "03:30 PM". "Event end" can be configured with the "Duration" option so the event's end time will be determined by adding a specific duration to the Event start time.
Add attendee to an existing event: In this mode, the attendee information collected on your form will be added to the attendee list of the event.
In either mode, when an attendee is sent to a Google Calendar, the attendee will be sent an invitation via email by Google and the event will be added to their Google Calendar. The attendee will get all updates related to the event.
Tips and Troubleshooting
If, for some reason, a result wasn't sent to your Google Calendar or your form wasn't integrated yet when the result was collected, you can resubmit it to Google Calendar on your form's "Results" page by editing and saving the result. If needed, the result's status can be manually changed to "complete" by clicking its status icon.
Google has a limit of 50 authorization tokens per Google account per app. If you integrate your Google account with more than 50 Formsite forms and exceed this limit, they may start revoking older tokens and cause the integrations for those forms to fail. If you need to integrate with more than 50 forms, you can work around this by copying the value of the "Token" setting from a working form into an older form so they share the same token and reduce the total number of tokens you're using. Google also suggests using multiple Google accounts to decrease the number of integrations in a single account.