📅 Creating Google Calendar events from a Dust assistant

💡 By combining Dust with Zapier (using a Dust App), we can give to an assistant the capability to create Calendar events. This is an advanced use case that will help you understand how anything you can do in Zapier (or Make.com, [Windmill.dev](http://Windmill.dev), pipedream etc…) can be triggered from Dust assistants.

Create a Dust App

Screenshot 2024-06-17 at 12.32.52.png

First, create a Dust App with an “Input” block. The input block will be responsible for collecting the data required to create the calendar event.

Screenshot 2024-06-17 at 15.11.09.png

After clicking on “Create dataset” we can start filling the expected data schema. The description for each field is very important, as this is what the AI model will use to understand what should go in each of the field.

You should then add some test values in the “Data” section — these will be used to test your Dust App before making it available to a Dust assistant.

⚠️ Make sure to use your own email(s) in the `guests` field — otherwise you won’t see the test event created in your Google Calendar (and you invite Gabriel and myself to your test event 🙃) ⚠️ Make sure to pick a start and end date that is in the future, otherwise your test event will be scheduled in the past (and you might not see it)

Create a Zap

Screenshot 2024-06-17 at 11.58.08.png

On Zapier, we create a new Zap. The Zap should use the “Catch Hook” webhook trigger: this is how your Dust App will be calling your Zap.

Once the Zap trigger is created, go to the “Test” tab and copy the webhook URL to your clipboard.

Call your Zap from your Dust App

Screenshot 2024-06-17 at 12.41.17.png

In your Dust App, add a CURL block as pictured above. The CURL block is used to call your Zap’s webhook trigger.

Once you have pasted the webhook URL of your Zap and filled-in the body section of the block with all the required parameters, you can run your Dust App.

To make it easier, you can simply copy and paste this code into your CURL block body section:

_fun = (env) => {
  return JSON.stringify({ 
    name: env.state.INPUT.name,
    start: env.state.INPUT.start,
    end: env.state.INPUT.end,
    guests: env.state.INPUT.guests.split(','),
    description: env.state.INPUT.description
   });
}

Create the Calendar Event from Zapier

Screenshot 2024-06-17 at 12.15.40.png

After running your Dust App, you can go back to your Zap. In the “Test” tab of your webhook block, you can now click on “Test trigger”, and you should see that the webhook event sent from Dust has been detected by Zapier. You can now click on “Continue with selected record”.

Screenshot 2024-06-17 at 12.16.03.png

We’re now ready to add the Google Calendar action in Zapier. You should pick the “Create Detailed Event” from the Event dropdown.

Next, you should connect your Google account from the Account tab if not already done.

Screenshot 2024-06-17 at 12.24.10.png

Now, navigate to the Tools tab and fill in all the relevant fields using the values from your webhook.

⚠️ As you can see in the screenshot above, we added `+02:00` at the end of our Start/End Date & Time fields. That is because we are in the France timezone. Make sure to pick the right value for your own timezone. Screenshot 2024-06-17 at 12.24.22.png

Finish adding all the values, including the Attendees field using the guests value from your webhook.

Screenshot 2024-06-17 at 12.24.34.png

You can now test the Zap Google Calendar action. If everything went according to plan, you should see something similar to the picture above, and your test event should be created in Google Calendar.

Test your Dust App

Screenshot 2024-06-17 at 12.26.34.png

Go back to your Dust App and add a final CODE block at the end. This code block should simply return a string as pictured above. That will prevent your assistant from receiving noisy technical (and useless) information from your CURL block.

You can simply copy and paste this into the block:

_fun = (env) => {
  return "The event was successfully created !"
}

Make sure you have deleted the Calendar event created via Zapier in the previous step. You can now run your Dust App.
If the event has been created again, it means everything is working as expected!

Create a mapping between names and emails

When we ask our assistants to create events for us, it is annoying to have to specify the exact email addresses every time. I prefer asking “Schedule a one on one with me and Gab tomorrow at 9:30am” than “Schedule a one on one with [email protected] and [email protected] tomorrow at 9:30 am”.

To achieve this, I’ll create a spreadsheet with a list of employees at Dust:

Screenshot 2024-06-17 at 13.15.59.png

In practice, this could be a Notion Database, a CSV file, a Google Doc, a raw text file, a database or anything where you have a directory of employees that work at your company.

Plugging everything together

Screenshot 2024-06-17 at 14.56.04.png

We can now proceed to create a Dust assistant. First, fill in the instructions. These are the ones I have used:

You are a helpful assistant that helps employees of the company Dust schedule their Google Calendar events.
If the email addresses of the attendees is not explicitly specified, you must always search for their emails in the employees directory spreadsheet first.
Never invent or assume email addresses.
If you can't find the email of an employee, ask the user for confirmation.

Screenshot 2024-06-17 at 14.56.50.png

Next, you can add a Query Tables tool to plug your employees spreadsheet. This is what your assistant will use to find the right email addresses for your query.

Screenshot 2024-06-17 at 14.58.18.png

Finally, add the Dust App you previously created as a tool for your assistant.

Screenshot 2024-06-17 at 14.59.04.png

This is how your “Tools & Data sources” screen should look like.

Screenshot 2024-06-17 at 15.00.22.png

You should now be ready to save your new assistant !

Try your assistant !

Screenshot 2024-06-17 at 15.37.24.png

It worked !

Screenshot 2024-06-17 at 15.37.56.png

If we inspect the Tools Details, we can see the assistant first queried our spreadsheet and then scheduled an event for me and Margaux.

Screenshot 2024-06-17 at 15.39.48.png