Looking for solution to add Outlook calendar invite information to Smartsheet

Brandon Berg · 09/21/21

We want to create a Smartsheet that is automatically populated with Subject, Location, Date, Time, Duration when we invite an alias to a meeting. Is anyone aware of a way to do this?

我们所有的项目我们会这样做/program meetings to help us provide corporate visibility to the meetings and attempt to avoid scheduling conflicts.

From this Smartsheet we could add additional information like meeting notes and action items and build reports that are then individual project/program calendars for folks to be able to view only events they are interested in.

Andrée Starå · 09/21/21

Hi@Brandon Berg

I hope you're well and safe!

We could probably structure this with a 3rd-party service like Zapier or similar.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Brandon Berg · 09/21/21

Hi Andrée,

I was thinking it would most likely need a 3rd party like Zapier or Microsoft Power Automate. (For a production level solution Power Automate would probably be the route I would need to go as it's already through our IT approved applications.) If you've got Zapier ideas, I'm all ears!

Thanks for your response.

Best,

Brandon

Brandon Berg · 10/15/21

Hi@Andrée Starå- any further thoughts on this?

Andrée Starå · 01/09/22

Hi@Brandon Berg

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

Lori Hight · 05/02/22

@Andrée StaråI am looking to do a form for people to register if they want to attend a training. I have created a meeting in outlook and would like to paste the invite link into a cell as the default when someone submits the form. I then have an automation to send an alert to the contact cell with the meeting invite field for them to click and save it to their outlook calendar. The problem is, how do I get the iCalendar link to put in the meeting invite field in smartsheet?

Shannon G. · 07/11/22

@Andrée Starå<\/a> I am looking to do a form for people to register if they want to attend a training. I have created a meeting in outlook and would like to paste the invite link into a cell as the default when someone submits the form. I then have an automation to send an alert to the contact cell with the meeting invite field for them to click and save it to their outlook calendar. The problem is, how do I get the iCalendar link to put in the meeting invite field in smartsheet?<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Andrée Starå\",\"userID\":8888}}},{\"insert\":\" I am looking to do a form for people to register if they want to attend a training. I have created a meeting in outlook and would like to paste the invite link into a cell as the default when someone submits the form. I then have an automation to send an alert to the contact cell with the meeting invite field for them to click and save it to their outlook calendar. The problem is, how do I get the iCalendar link to put in the meeting invite field in smartsheet?\\n\"}]","format":"rich","dateInserted":"2022-05-02T12:32:13+00:00","insertUser":{"userID":117642,"name":"Lori Hight","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Hight","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T11:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327987#Comment_327987","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327987#Comment_327987

I'm looking to do this exact same thing - any information on this?

Mike TV · 07/13/22

@Shannon G.

Does this work for you? On the form settings you can put the link to your calendar invite into the confirmation message:

Shannon G. · 07/13/22

@Mike TVthis is a great idea - thank you!

Heather_Verde · 04/25/23

I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.

Patrick_CFA · 05/03/23

I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.<\/p>","bodyRaw":"[{\"insert\":\"I do something similar and have the link pulled from a separate sheet where we house the event information. The event link is added to a column on the event data sheet. I then use formulas to pull over which event and the appropriate data to the registration sheet. When they register, they receive either a confirmation email or a waitlist email depending on how many seats are still available. The confirmation email has the link and instructs them to download and save to their calendar.\\n\"}]","format":"rich","dateInserted":"2023-04-25T15:05:54+00:00","insertUser":{"userID":150223,"name":"Heather_Verde","url":"https:\/\/community.smartsheet.com\/profile\/Heather_Verde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-18T21:04:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373182#Comment_373182","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373182#Comment_373182

@Heather_VerdeI'd be interested in seeing how you set up your event registration sheet + your event data sheet. Could you share a screenshot without any records so we can see your columns and such? Or perhaps a Miro/Mural screenshot of the flow? This is something high on our interest as well.

Heather_Verde · 05/03/23

@Patrick_CFAI will put something together and get back to you.

Looking for solution to add Outlook calendar invite information to Smartsheet

Answers

Categories