Create Google Calendar events from Google Sheets with webMethods.io Integration
Tags: webmethods, integration, googlesheets, googlecalendar
Published: 2024-03-01 15:18:35

---
title: Create Google Calendar events from Google Sheets with webMethods.io Integration
published: true
date: 2024-02-15 13:06:51 UTC
tags: webMethods, integration, googlesheets, googlecalendar
canonical_url: https://tech.forums.softwareag.com/t/create-google-calendar-events-from-google-sheets-with-webmethods-io-integration/291548
---

 

## 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](http://webmethods.io/) tenant – [sign up here](https://signup.softwareag.cloud/#/basic?product=webmethodsioint) for a free trial if you’re new (use the [advanced sign up form](https://signup.softwareag.cloud/#/advanced?product=webmethodsioint) for more options).
2. Google account

## Steps

1. To start with, login to your [webMethods.io Integration](https://www.softwareag.cloud/site/product/webmethods-io-integration.html) 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](https://docs.webmethods.io/integration/workflow_building_blocks/creating_first_workflow/#gsc.tab=0).
2. To set up a trigger action, click on the small setting icon on the Start step and choose the Google Sheets trigger.

[![Google Sheets trigger](https://global.discourse-cdn.com/techcommunity/optimized/3X/9/2/92c03d35ca887dc715ca44f5ce40b380e173e76f_2_310x220.png)](https://global.discourse-cdn.com/techcommunity/original/3X/9/2/92c03d35ca887dc715ca44f5ce40b380e173e76f.png "Google Sheets trigger")

[![Google Sheets trigger configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/8/28c70e5e6590c7d8a996265c0da907dbee7e17a2_2_310x219.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/8/28c70e5e6590c7d8a996265c0da907dbee7e17a2.png "Google Sheets trigger configuration")

Select _New spreadsheet row_ as a trigger and complete the authorization – connect [webMethods.io](http://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

[![Google Sheets](https://global.discourse-cdn.com/techcommunity/optimized/3X/5/9/59e66d186bf6a9cc3994f9edac6b479e21793750_2_690x286.png)](https://global.discourse-cdn.com/techcommunity/original/3X/5/9/59e66d186bf6a9cc3994f9edac6b479e21793750.png "Google Sheets")

Go back to the [webMethods.io](http://webMethods.io) Integration workflow and click **Test**. You should see the output data from the trigger which [webMethods.io](http://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.

![Google Calendar connector](https://global.discourse-cdn.com/techcommunity/original/3X/e/2/e24775f9016399d8883424acc74de1833eaa48c8.png)

![Connect Google Calendar connector](https://global.discourse-cdn.com/techcommunity/original/3X/d/3/d342045af8e682c224ef1f3e9817e6cb8ae795f5.png)

Click on the small settings icon on the Google Calendar connector, select _ **Create Calendar Event** _ as action and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Google Calendar account.

[![Create Calendar Event](https://global.discourse-cdn.com/techcommunity/optimized/3X/d/1/d125d9be14dd9220d27ad0086869209b427852c7_2_331x375.png)](https://global.discourse-cdn.com/techcommunity/original/3X/d/1/d125d9be14dd9220d27ad0086869209b427852c7.png "Create Calendar Event")

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.

[![Google Calendar connector configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/0/f/0f22eafd9e89d4f96224ba06bd336873392d1f19_2_690x338.png)](https://global.discourse-cdn.com/techcommunity/original/3X/0/f/0f22eafd9e89d4f96224ba06bd336873392d1f19.png "Google Calendar connector configuration")

Click **Next** and then **Done**.

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

[![Final workflow](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/9/b9ff0c701e5467ed44f98198711a2a9971d157b3_2_690x311.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/9/b9ff0c701e5467ed44f98198711a2a9971d157b3.png "Final 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:

[![The new Google Calendar event](https://global.discourse-cdn.com/techcommunity/optimized/3X/6/6/66c13c57165b2d6354e2d20f8cf68bf3af6ce39a_2_690x267.png)](https://global.discourse-cdn.com/techcommunity/original/3X/6/6/66c13c57165b2d6354e2d20f8cf68bf3af6ce39a.png "The new Google Calendar event")

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:

[![Execution history](https://global.discourse-cdn.com/techcommunity/optimized/3X/f/a/fa2af4ca083408d3eb19c38b1001b7c4dc4ca3a4_2_690x102.png)](https://global.discourse-cdn.com/techcommunity/original/3X/f/a/fa2af4ca083408d3eb19c38b1001b7c4dc4ca3a4.png "Execution history")

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

[![Workflow execution status](https://global.discourse-cdn.com/techcommunity/optimized/3X/6/1/6155b86b7555682d50e4d71f6554bb324ddf731f_2_690x139.png)](https://global.discourse-cdn.com/techcommunity/original/3X/6/1/6155b86b7555682d50e4d71f6554bb324ddf731f.png "Workflow execution status")

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

![Execution settings](https://global.discourse-cdn.com/techcommunity/original/3X/9/f/9f8f81d1142fbbceb32ac1dd20490f46eba93ef8.png)

[![Workflow settings](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca_2_690x373.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca.png "Workflow settings")

## Related articles

For more [webMethods.io](http://webmethods.io/) Integration workflow examples involving Google applications, refer to the following articles:

- [Integrate Outlook Calendar with Google Calendar through webMethods.io Integration](https://tech.forums.softwareag.com/t/integrate-outlook-calendar-with-google-calendar-through-webmethods-io-integration/288200)
- [webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online](https://tech.forums.softwareag.com/t/webmethods-io-integration-workflow-store-typeform-entry-data-in-google-sheets-or-excel-online/289772)

[Read full topic](https://tech.forums.softwareag.com/t/create-google-calendar-events-from-google-sheets-with-webmethods-io-integration/291548)