Lesson 5 of 15
In Progress

Triggering Google Applications via Webhooks – Example Workflow

Hi there, today we’re gonna be showing you how to authenticate and set up integrations with Google. We’ve got three different services we’re going to be trying today.

First of all, what we’re going to be looking to do is how to send an email through Gmail. The trigger for this is going to be a webhook. If we jump into this cycle here, you’ll see the actual setup, it’s very simple, we just have our webhook connector, where we’ve got the webhook URL, and we actually have that already set up in Postman as a post event with some JSON that’s going to be sent to Gmail. This is then going to be sent to the Gmail connector, which will trigger sending an email with the content that’s in that in that JSON string.

If we first of all go to the Gmail connector, we want to authenticate it. We will go to set up, we then have to sign in, and then we’re going to be selecting our account from the list.

At the moment, what we have to do is we have to click the advanced and then go to cyclr.com, then we can actually give the permissions, that is done now. (This is no longer the case)

If we then go back to the workflow, we can then set it to run. What we can do now is if we quickly go to our email provider in Gmail, then we can go back, and we can hit send. That should trigger the workflow. Now we can go back to our email address, and the email is here. That’s the first step done.

Secondly, what we have is, if we go back here, the ability to ‘add a row’ of data into a Google Sheet. We go into this and once again, it’s very similar, it’s going to be a webhook event with some JSON data, which is going to be triggered by an event here in Postman.

That will append a row into a Google Sheet, what we need to do first of all, is we need to go into the settings, and we need to authenticate the connector. Very much the same way through the pop up, we’ll be selecting this advanced, and cyclr.com we’ll allow those.

Back to the builder and what we can do is jump into this step here to make sure that we’ve got the right mapping. We have the ability to select the spreadsheet and as default, sheet 1 is what we’re going to need, we’ve pre-mapped these fields. Now what we can do is we can run this and before we send, and trigger the webhook. Let’s just go into the spreadsheet itself, which is blank at the moment. Let’s go to postman, and trigger this, as you can see, that’s already put the data in, straightaway. We can do that again and it has added another line here.

You can change this data, this represents any other kind of data source meaning it could be from any other application, or another type of webhook, or any other step you want to use in your workflow.

The final thing we’re going to show you today is if we go back, this is going to be Google Drive based. So this is going to be copying a file in Google Drive, making a new version of it in your in your drive storage area.

Let’s go back here and once again, we’re going to need to just authenticate to the connector, go to set up and we’re going to be signing in under the same details.

What we’ll be doing in steps here is we entered a file ID which we have, this is the file that we were just using. What we’re going to do is when this is triggered, we’re going to be creating a new version of this with a new file name which has been defined in the webhook body. This will be copy of Google Sheet so that when run, let’s get this ready. That is live now and as you’ll see, there’s only one version of it here. Now if we open Postman, click on send. If you go back to the Ccylr application, you should be able to see it run, but it’s already happened here and it has created one, and it’s now copy of Google Sheets, which you could name to anything.

Again, that could be triggered by any other step from anything in your workflows, not just a webhook. So feel free to create as many advanced workflows as you want.