Create Google Calendar events from Google Sheets with webMethods.io Integration

[Community-admin (Tech Community team)]

Overview

This step-by-step tutorial will guide you through creating a seamless workflow that automatically translates new rows in your Google Sheet into scheduled events on your Google Calendar.

Prerequisite:

1. webMethods.io Integration tenant – sign up here for a free trial if you’re new (use the advanced sign up form for more options).
2. Google account

Steps

1. To start with, login to your webMethods.io Integration tenant and create a new project or choose an existing one. Go ahead and get started by creating a blank workflow. If you need a refresher on how to get to this point, this guide.
2. To set up a trigger action, click on the small setting icon on the Start step and choose the Google Sheets trigger.

Select New spreadsheet row as a trigger and complete the authorization – connect webMethods.io Integration with your Google account and select a Spreadsheet and Sheet ID.

Click Save. You should see the test trigger window.

To test your trigger, you need to perform the trigger action. Open your sheet and add a new row with the following event information and column headers:

• Event name
• Description
• Start and End time – use the following Date/Time format:

YYYY-MM-DDThh:mm:ssZ, where ‘Z’ indicates that the time is in Coordinated Universal Time (UTC)

• Location

Go back to the webMethods.io Integration workflow and click Test. You should see the output data from the trigger which webMethods.io Integration will use to configure and test the rest of the workflow. Click Done.

3. Moving on to the next step - add the Google Calendar connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.

Click on the small settings icon on the Google Calendar connector, select Create Calendar Event as action and complete the authorization – connect webMethods.io Integration with your Google Calendar account.

Click Next.

Now you can proceed with the action configuration – choose the Calendar ID and use the Incoming data panel to fill out the fields with the calendar event information received from the trigger output.

Click Next and then Done.

4. Connect the Google Calendar connector to the Stop step. Don’t forget to save your workflow.

5. To test your workflow, use the play button in the right upper corner and review the result. If you have configured the workflow correctly, you should see the newly created event in your Google Calendar:

Now every time a new row is added in Google Sheets, a new event will be automatically added to your Google Calendar too. Please note that this may take some time.

6. At the bottom-left corner of the screen you can find the Execution history of the workflow:

From here you can monitor the execution status and view error details if needed:

Please note that workflow execution logs must be enabled from the workflow execution settings:

Related articles

For more webMethods.io Integration workflow examples involving Google applications, refer to the following articles:

• Integrate Outlook Calendar with Google Calendar through webMethods.io Integration
• webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online