Skip to main content

I would like to connect my Stan Store to my Outlook Calendar. When a user signs up for an appointment. I would like the appointment to show up in my Outlook calendar. I would like the calendar to show the time blocked off for 1 hour.

Hi ​@jennik 

It does not appear the Stan Zap app has an available trigger for appointments.

 

Review the available triggers/actions for each app:


Hey there, ​@jennik 👋

I see that you reached out to our Support team about this as well and they added you to a feature request for the ability to trigger on new appointments. We don’t have an ETA on when that might be added but we’ll definitely let you know by email once it is! 

I was hoping you might be able to use webhooks in the meantime but I couldn’t find any public-facing API available for Stan so you wouldn’t be able to get around this with Webhooks.

Do you happen to receive email notifications from Stan when a new appointment is added though? If you do, then you could set up an automatic email forwarding rule in your email account to forward those notifications to an app like Email Parser. Email Parser would extract information from the email so the Zap could then use that to create the event in the Outlook Calendar. You can learn more about how to work with Email Parser here: Trigger Zaps from new parsed emails.

 

Hope that helps. If you run into any issues on that or have further questions just let us know! 


Hi SamB,

Thank you for that information. I am trying to get the Email Parser to work. I believe I am close. This issue is the time. When the date and time come from the Email Parser, the Input field looks like this format. 07:00 AM CST February 04,2025. When I try to format it. It shows this time February 04 2025 01:00:00. I have the right date, just not the right time. Do you know what I am doing wrong? Thank you! 


Hey ​@jennik!

If the time is returned differently, it is likely that either the From Timezone or To Timezone fields are not set up correctly. If you want to return the date in CST as well, then make sure both fields are set up with the same timezone (US/Central).

Could you check those fields and let me know what you find?


Hi ​@Marge,

Thank you! I changed the To Timezone and the From Timezone in the Email Parser to US/Central. That changed the time to show 8am. I went into my Outlook calendar and saw that my time zone was sent to Eastern. So I changed that to Central as well and the time is now coming up as 7am. The meeting shows from 7am to 7am. I am trying to add 1 hour on the end time so that it shows 7am to 8am. When I am try to change the End Date & Time under the Microsoft Office 365 section, I have February 04 2025 07:00:00 in the field and then I add    +1h     at the end of it. I then test and I still get the 7am to 7am. Is there something else I need to do? Thank you!

 


Hi ​@jennik!

Could you share a screenshot of how the Start Date/Time and End Date/Time fields are configured and a screenshot of what appears in the Data Out tab after testing? As long as you type +1hr after the date, it should work.

I’ll keep an eye out for your reply!


Hi ​@Marge,

I have attached a screenshot. This is in the Microsoft 365 configure area. Thank you in advance!

 


Hi ​@jennik!

Thank you for sharing the screenshot. Is there a space after the date and before the +1hr? For the calculation to work properly, make sure to separate the date from the value to add/subtract.

Example: February 04 2025 07:00:00 +1hr instead of February 04 2025 07:00:00+1hr.

Let me know if that helps! 😁


Hi,

I am getting a 6am to 6am appointment now. I think there is something with the time zone that is affecting it. But I well I select my template in the parser, the timezone comes over even if I don’t select it. 

This is the Date/Time in formatter area. When i test it, it looks correct.

Below is what I have in the Microsoft Office 365 area

Any help would be greatly appreciated.

Thanks


Hi ​@jennik⚡️

In the latest screenshots you shared, it doesn’t look like there is a space between the date and time, and between the time and the addition of “+1hr”. It is likely that the operation is not being picked up because the date, time and +1hr are being read as a single string, “February 04 202501:30:00PM -0600+1hr”.

Another note is that there is no need to split the date and time outputs, you can use the previous date/time set up, and make sure to add a space before adding the +1hr. (Screenshot).

Could you try the changes above and let me know how it goes?


Hi ​@Marge 

Thank you for your help that worked! The time is showing correctly after I made this change below. 

Date/Time Formatter
 

Office 365
 

I have another question. I have been sending emails to the mailbox and notice they do not automatically show up in the office 365 calendar unless I run through to retest them. Does the Zap need to be published to automatically send it to the office 365 calendar? Thank you again!


Awesome ​@jennik, that is fantastic news!

To clarify, do you mean the Zap is not triggering automatically? If that is the case, then you are on the right track. A Zap can only trigger when it is turned on. If it is turned off, it won’t trigger.

Additionally, if you make changes and edit the Zap, the changes won’t apply to the live version of the Zap until you publish the changes.

I hope that helps!