Easily integrate FileMaker and Google Calendar with Integromat

Hello.
I am Teruhiro Komaki of frudens Inc.

Since it was decided to speak at FM-Tokyo, I will tell you about it for the time being, although it is easy.

I will fix it later!

Demo file download

https://github.com/frudens/fm-tokyo-integromat

Integromat

https://www.integromat.com

Screen after login

It is the screen after login.

Select “Create a new Scenario”.

filemaker-google-integration-integromat-01

Select a service for scenario creation

Enter “web” and narrow down.

Select “Webhook” and select “Continue” in the upper right.

filemaker-google-integration-integromat-02

Create a scenario

“?” Is displayed in the middle.

Right click and select “Webhook”.

filemaker-google-integration-integromat-03

Select “Custom webhook” from Webhook Menu

The menu available on Webhook is displayed.

Select “Custom webhook”.

filemaker-google-integration-integromat-04

Publish Webhook URL

Publish the Webhook URL.

Select “Add”.

filemaker-google-integration-integromat-05

Set the name of Webhook

Any name is fine.

filemaker-google-integration-integromat-06

Let’s say “Create Google Calendar” here.

filemaker-google-integration-integromat-07

The Webhook URL was Published

For this URL, POST it using FileMaker Insert from URL and cURL option.

Select “Copy address to clipboard” and copy the URL.

filemaker-google-integration-integromat-08

Open demo file

Look for “demo_calendar_create.fmp 12” from the downloaded file and open it with FileMaker Pro 16.

Select the blue button at the top and switch the layout.

filemaker-google-integration-integromat-09

POST to URL

Paste the URL of the Webhook you just copied into curlUrl.

Select “post” at the bottom.

Make sure that the posted data is correctly sent to Integromat.

filemaker-google-integration-integromat-10

About post script

The post script is as follows.

post

filemaker-google-integration-integromat-script-01

Set variable

filemaker-google-integration-integromat-script-02

JSONSetElement (
	"{}" ;
	[ "id" ; demo::id ; JSONString ] ;
	[ "start" ; demo::start ; JSONString ] ;
	[ "end" ; demo::end ; JSONString ] ;
	[ "title" ; demo::title ; JSONString ] ;
	[ "description" ; demo::description ; JSONString ] ;
	[ "location" ; demo::location ; JSONString ]
)

Insert text

filemaker-google-integration-integromat-script-03

--request POST
--header "Content-Type: application/json"
--data-binary @$json

Return to Integromat and check the data

It is OK if “Successfully determined.” Is displayed.

Select “OK” and close.

filemaker-google-integration-integromat-11

Add module

Move the mouse closer to the right part of the created Webhook.

Select “Add another module”.

filemaker-google-integration-integromat-12

Add Google Calendar

In “Search” enter “Google Calendar” and narrow down.

filemaker-google-integration-integromat-13

Select “Google Calendar”.

filemaker-google-integration-integromat-14

Select “Create an Event”.

filemaker-google-integration-integromat-15

Configure Connection

Since “Connection” is not set at the beginning, select “Add” and authenticate “Integromat” with a Google Account.

By default, I think that it will be “My Google connection” by default.

filemaker-google-integration-integromat-16

Select an arbitrary calendar

The calendar of the authenticated Google Account will be loaded and available for selection.

Here, select “FM-Tokyo”.

filemaker-google-integration-integromat-17

Looking at the screen of Google Calendar, it is the place of “My Calendars” on the left.

filemaker-google-integration-integromat-18

Confirm POSTed data from FileMaker

Map JSON data set in the body of FileMaker’s “post script”.

When “Event name” is selected, the key of the JSON data is displayed.

In this case, set “title” to “Event name”.

filemaker-google-integration-integromat-19

Similarly for “start” and “end”, set the key.

When you are done, select “OK” and close it.

filemaker-google-integration-integromat-20

Test the scenario

Before testing the scenario, save it with “Save” at the bottom of the screen.

Select “Run once”.

filemaker-google-integration-integromat-21

Thunder beside the module turns round and waits.

filemaker-google-integration-integromat-22

Execute post from FileMaker

Go back to FileMaker from Integromat and run post.

filemaker-google-integration-integromat-25

Confirm the scenario

If there is no problem in the setting, the scenario ends normally.

filemaker-google-integration-integromat-26

Check Google Calendar

The JSON data Posted in FileMaker will be added to the calendar.

filemaker-google-integration-integromat-24

Confirm insertion response data from FileMaker URL

What is the insert response response data from the URL executed in FileMaker?

It is “Accepted”.

I really want you to return the id of the calendar you added, not “Accepted”.

By adding more modules here, you can retrieve the response data of the Google Calendar API.

filemaker-google-integration-integromat-25

Next time

This time, I wrote from FileMaker to adding Google Calendar events.

Next time, I will write response data acquisition, event information acquisition etc.

Afterword

People who are familiar with this type of service, please try to cooperate in various ways!

We will also write a link between FileMaker and DynamoDB, so please look forward to it!

I am a Japanese developer. (I am studying English.) I met the FileMaker Platform at the company I worked at the time. Develop a custom App as an in-house developer. Acting as freelance from 2014 and establishing frudens Inc. in 2016. Recently, I use 'Insert From URL'. I enjoy FileMaker and various services in Integration!