Haran Shivanan

02 November 2019

New Office 365 Calendar Integration, On-Premise Connectors and Bug Fixes
We just pushed out a new release of Lucy. Here’s what’s new:
Google Sheets
Office 365

We have enabled the Office 365 Calendar Connector by default and done a few enhancements for some of our other connectors.
We have also introduced On-Premise connectors that let you connect to services and devices running on your local premise from Lucy on the cloud.
We have connectors for all popular control system protocols and some enterprise systems.

Using the Office 365 Calendar Connector

Using the Office 365 Calendar Connector

This connector lets you manipulate Office 365 Calendar events in Lucy. You can also receive event triggers whenever a calendar event is about to start or end or got created or updated. You can create, update and delete events using blocks from the Office 365 Calendar category in the block list. You can link your Office 365 account and authorize Lucy to connect to it.

You can also react to calendar events. Open the Action List and then select an Office 365 Calendar event to add it to the staging area.
You can then configure that event by linking an account and a calendar as well as set up a time window to specify how long before or after an event to trigger your workflow.

Google Sheets Connector enhancements

Google Sheets Connector enhancements

The Google Sheet’s GetData block has an improved structure for returning data. Previously, data was returned as nested arrays:


It has been changed to return data as an array of columns. This lets you easily access data by the column and row.


With this structure – you can easily feed the output into a repeater and access individual cells by their Sheet Column ID.

Repeater Block Improvements

Previously, repeater blocks worked by processing items in parallel. However, we have found that most users find it counter-intuitive and sometimes leads to strange results.
We added an option to repeaters that lets you process items in a sequence, so one item in the input list is guaranteed to be processed only after preceding items are processed.
This will now be the default option for new repeater blocks that you add.
For backward compatibility -this feature will not be enabled by default on existing repeater blocks you have. You can explicitly turn it on by checking off the ‘Run in sequence’ option.

On-Premise Connectors

This is an entirely new feature which deserves a blog post of its own. This will be coming soon!

02 November 2019

New Office 365 Calendar Integration, On-Premise Connectors and Bug Fixes

There are also some significant enhancements to the web service connector toolkit.
As you may know – Lucy comes with a comprehensive toolkit to build your own connectors using point-and-click configuration.

This toolkit has become more powerful now and gives you more control over your connectors. You can use javascript code to write custom processing logic for inputs to your connector and can run custom processing and data transformations on the results.

In fact, all the 3 connectors we have enabled in this release were built using the same connector toolkit that you have access to.

Using the Google Sheets Connector

You can query any data range from a Google Sheet as well as append data to an existing Sheet using the connector.

Search for ‘Google Sheets’ in the block library to find the available functionality.

  • Get Data
  • Append Data

To use them, find them under the ‘Google Sheets’ category and drop them into the staging area. You need to connect the block to your Google Account and authorize Lucy to access it. Once you do this, you can read data from any Sheet and append data to any Sheet. All you need is the url of your Sheet – you can find it by simply opening the sheet and copying the url from the browser.

Appending Data

One of the most common use cases is to append data to a list in a Sheet. You can use the AppendData block for that. As inputs, you need to specify the Google Sheet url, a cell range for the table you want to append data to, and a JSON array of values to append. Here, a table just means a contiguous block of data. And you just need to give a cell range that falls within the table. Google will figure out the ‘breadth’ of the table and append data to the end of it. This is a great way to keep track of items in a lightweight manner and share a dynamically updating list of data with others.

Using the Google Calendar Connector

You can use the Google Calendar Connector to create, modify and delete events on the calendar from Lucy. There are also events available that will trigger whenever a calendar item is created, modified or deleted. You need to sync your Google Account and authorize Lucy to access the calendar app. Once this is done, you can use Lucy to access all calendars in your Google Account. For each operation, along with the account, you need to supply the calendar id.

For your main calendar, this will be your Google email address. For secondary calendars, you can find the id by going to settings and scrolling down to the bottom. You can respond to create/modified/deleted events on the calendar by adding the appropriate event handler when creating a new action sequence.

Using the Zoom Connector

Zoom is a fantastic video conferencing solution that we use quite regularly. It provides an API for doing many things – right now the Zoom connector for Lucy lets you schedule meetings. You can find the Zoom blocks in the block list to access its functionality. You need to authorize Lucy to access your Zoom account. You also need to specify the email address of the Zoom user that the operation is being done on behalf of. One common use case we are already adopting internally: Since we have a limited number of Zoom users, we created a shared Google Calendar to keep track of who’s using Zoom and when. Using Lucy, we can sync our Google Calendar with Zoom so anyone authorized can book Zoom meetings via Google Calendar.