webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

View Only

Back to Library

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

Thu February 15, 2024 08:06 AM

webMethods Community Member

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:

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

Steps

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.
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.

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.

Google Calendar connector

Connect Google Calendar connector

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.

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

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.