Dust Community Icon

Need Help with Google Calendar Events Creation Using Make?

·
·

I’ve been trying to achieve the Creation of Google Calendar events from a Dust assistant, replacing Zapier by Make. Any experienced Make expert around here? 🙂

  1. 1.

    When I send these instructions to the Make webhook as in the tutorial:

name: env.state.INPUT.name, start: env.state.INPUT.start, end: env.state.INPUT.end, guests: env.state.INPUT.guests, description: env.state.INPUT.description

  1. 1.

    I parameter the Event Creation module in Make this way:

  • Event name: {{name}}

  • Start Date: {{start}}+02:00

  • End Date: {{end}}+2:00

  • Description: {{description}}

  • Attendees / Email: {{guests}}

  • And I get this error:

  • Missing value of required parameter ‘summary’.

  • Invalid date in parameter ‘start’.

  • Invalid date in parameter ‘end’.

  • Missing value of required parameter ‘email’.

  • Avatar of Léo Martin
    Léo Martin
    ·
    ·

    Hey Pierre Bernat Do you have an example of the output you receive in the Make Webhook you can share please ?

  • Avatar of Léo Martin
    Léo Martin
    ·
    ·

    I've tested on my side, here is a couple of ideas :

    1. 1.

      It's weird that the 4 variables are in black : If you get them directly from the webhook, they should be in a "red-ish" color or purple if you manipulate them in between.

    2. 2.

      Are the dates variables in the same format as the examples in the guide ? eg., 2025-06-20T21:30:00 If not, you can use the "formatDate() formula, or even the addDate() formula (cf screen to add the 2h diff)

    3. 3.

      If you have many emails in the guests, I guess split them with only a "," doesn't work. I guess you would have to create an array, that looks like sthg like this :

    [
      {
        "email": "leo.martin@malt.com",
        "displayName": "Léo M"
      },
      {
        "email": "leo.martin@gmail.com",
        "displayName": "Léo"
      }
    ]
  • Avatar of Léo Martin
    Léo Martin
    ·
    ·
  • Avatar of Léo Martin
    Léo Martin
    ·
    ·

    PS : What I would find useful to help is to create a test event from the Make module with variables "en dur". Then, you copy-paste the input and ask Claude to rewrite your prompt so that your assistant's output matches what's expected in the Calendar module 😉

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    Hi Léo thanks for your insights! First, I get this output in dust after I run the event. it’s cryptic to me but there may be some info in there.

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    In Make the scenario is queued and the log is the following: { "_gl": "1*doj0zw*_gcl_au*MjgxMjA4NzEwLjE3MzQ2NDMyMDg.*_ga*NTk3NjE0MzA3LjE3MzQ2NDMyMDM.*_ga_MY0CJTCDSF*MTczOTM5Mzc2Ni45LjEuMTczOTM5NDExNC41NC4wLjA." }

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    It’s weird that the 4 variables are in black

    I don’t retrieve the tags in the panel as you see in the screenshot and the animated. I input them directly as {{name}} fo i.e.

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    Are the dates variables in the same format as the examples in the guide?

    Actually they are as you can see here. They’re set this way in the database schema.

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    If you have many emails in the guests, I guess split them with only a “,”

    I suspected a possible problem here too, so I had simplified by passing a one and only “guest” for the moment: guests: env.state.INPUT.guests,

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    And I’ve created an item 1 Attendee in the calendar module in Make:

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    Noted for the array tip, thank you.

  • Avatar of Léo Martin
    Léo Martin
    ·
    ·

    Ok clearer, thanks Pierre Bernat! To retrieve the variables from the Webhook, you 1st have to :

    1. 1.

      Click on the Webhook > Redetermine Data Structure > Push a test from DustApp that seems to work (seeing your output from Make)

    1. a.

      Or directly : Right click on the Webhook module > Run once > push a test from DustApp

    1. 2.

      And then on the event part, to retrieve the Data from the Webhook you need to click on little star at the top left ! (cf video)

    1. a.

      In the video I don't have a webhook running so retrieving the info from the Step2, but it's the same idea!

    Should work like a charm then! If not, we can take 15' if you want

  • Avatar of Pierre Bernat
    Pierre Bernat
    ·
    ·

    One time I manage to run the webhook, one time to retrieve the variables, one time to create an event (when I run it separately), but never all 3 together! I’d be happy to take 15' of your time. I’ll send you a DM with availability.