28.10.2022
551

How to Connect Google Calendar as Data Source

How to Connect Google Calendar as Data Source

The integration will allow you get new, modified, and canceled events or events by the start/end date, transferring them to other systems. For example, you can send new events to Google Sheets or send them as notifications to yourself or a group of managers. You can also send data events to the SMS or Email Distribution service. This will allow you to maximize the automation interaction of Google Calendar with other services and systems.

Let's go through the entire Google Calendar setup steps together!

Navigation:
1. What data can get from Google Calendar?
2. How to connect Google Calendar account to ApiX-Drive?
3. Select a calendar.
4. An example of event data.

Answers to frequently asked questions:
1. I get an error after connecting the account: "Request had insufficient authentication scopes".

To start setup click "Create Connection".

How to Connect Google Calendar as Data Source | Create Connection

Select a system as the Data Source. In this case, Google Calendar must be specified.

How to Connect Google Calendar as Data Source | System selection 

Next, you need to specify an action, for example, "Get EVENTS (new)".

How to Connect Google Calendar as Data Source | Action selection

- Get EVENTS (new) -ApiX-Drive will get new events from Google Calendar that appear once set up the connection and start auto-update.
Get EVENTS (by start date) - ApiX-Drive will get events by start date from Google Calendar that appear once set up the connection and start auto-update.
Get EVENTS (canceled) - ApiX-Drive will get canceled events from Google Calendar that appear once set up the connection and start auto-update.
Get EVENTS (by end date) - ApiX-Drive will get events by end date from Google Calendar that appear once set up the connection and start auto-update. 
Get EVENTS (modified) - ApiX-Drive will get modified events from Google Calendar that appear once set up the connection and start auto-update.

The next step is to select the Google Calendar account from which will get the data.

If there are no accounts connected to the system, click "Connect account".

How to Connect Google Calendar as Data Source | Account connection 

Select which account you want to connect to ApiX-Drive and grant all permissions to work with this account.

How to Connect Google Calendar as Data Source | Account selection

Check the box "See, edit, share and permanently delete all the calendars that you can access using Google Calendar" so that the system gets access to work with your account.

How to Connect Google Calendar as Data Source | Allow access

When the connected account is displayed in the "active accounts" list, select it for further work.

Attention! If your account is in the "inactive accounts" list, check your access to this account!

How to Connect Google Calendar as Data Source | Account selection

Select the calendar from which the upload will take place from the list.

How to Connect Google Calendar as Data Source | Calendar selection

Pay attention! If after connecting, at the Settings stage, you see the error "Request had insufficient authentication scopes.", you will need to connect your Google Calendar account again, providing all permissions.

To do this, follow these steps:

  1. Go to Access - Google Service - Google Calendar and delete the connected account.
  2. Go to the main page and turn off auto-update link.
  3. Go to the Access step in the Google Calendar Data Source and connect the account. Be sure to check the box next to "See, edit, share and permanently delete all the calendars that you can access using Google Calendar" when you connect.
  4. If the error has not disappeared, and your account is picked up from the browser automatically, then repeat steps 1-3 by logging in to the browser through incognito mode.
  5. Configure the Data Source and load the test data in the Validate step.

If necessary, you can set up a Data Filter, or click "Continue" to skip this step.

To find out how to set up the Data Filter, follow the link: https://apix-drive.com/en/help/data-filter

How to Connect Google Calendar as Data Source | Data Filter

Now you can see test data for one of the events in your Google Calendar.

If the test data does not appear automatically, click "Load test data from Google Calendar".

If you want to change the setup - click "Edit" and you will go back one step.

If everything suits you, click "Next".

How to Connect Google Calendar as Data Source | Data Test 
How to Connect Google Calendar as Data Source | Data Test 

This completes the entire Data Source setup! See how easy it is!?

Now you can set up the Data Destination system.

To do this, set up it yourself or go to the help section "Data Destination", select the service you need as Data Destination, and follow the setup recommendations.

Good luck!

How to Connect Google Calendar as Data Source | Go to the setup Data Destination