Sync meetings from Google Calendar

Guide

After you've synced Google Calendar with Fibery, you'll have several new Databases. Let's say you've chosen to have Event Database with a list of all the meetings for a given period, and Calendar Database with a list of Google Calendars you've synced.

You might want to assign these meetings to users from User Database (in People Space) to allow teammates see all their meetings easily and receive notifications.

Here is how to do it.

Step 1. Create an auto-linking relation from person in Google Calendar to user in Fibery

For clarity, let's rename the User Database in Google Calendar Synced Space to Person Database.

Here are the steps:

Navigate to Person Database and click + on a column to create a new Relation.

Select User Database and setup one-to-one Relation.
Click Advanced button and Automatically link People to Users switcher and select "Email" in both sides.

As a result, Persons from Google Calendar will be linked to Users in Fibery automatically.

Step 2. Add People field to event database

Go to the Event Database in Google Calendar Synced Space, add new Field by clicking + and select "People" to add People Field. You can give it name "Assignees" for more sake.

Step 3. Create two rules in the event database

Navigate to Event database, click Automations in the upper right corner, and add two Rules.

Rule 1. Assign organizer

When Organizer Field in Event Database is updated, then add Assignees from relevant Users in User Database.

To define Assignees in the 'Then" part of this Rule, click … and add a Formula [Step 1 Event].Organizer.User

Rule 2. Assign event attendees

When new Attendees are added to Event in Event Database, then add Assignees from relevant Users in User Database.

To define Assignees in the 'Then" part of this Rule, click … and add a Formula [Step 1 linked Person].User

Step 4. Delete all events and re-sync again

Now we should delete all events and re-sync them to run these Rules for all old events.

Navigate to a Table View with all events. If you don't have it, create this View.
Select "All Events".
Click Actions and select Delete
Navigate to Google Calendar Synced Space.
Click synced … minutes ago label.
Click Sync now button on the right.

As a result, all events will be added again and assigned to proper people.

Note that Automation takes time - it may take 10+ minutes to get all events assigned to all users.