Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Use Microsoft Teams webinar registrations to add subscribers in Campaign Monitor

Hey Folks,

Have made a couple of Zaps but this one is eluding me. This started me on the journey Microsoft Teams Webinar Registration to Salesforce | Zapier Community
 

What I’m trying to make happen is - 

User signs up to Teams Webinar using the Teams registration page.

email gets sent to Zapier with registrant info

info gets parsed (and passed) to Campaign Monitor and added to a subscriber list.


So far, using Sharepoint and Flow/Power Automate, I’ve managed to get Teams to send the relevant info (name/emailaddress/subscription etc) in an email body to me, comma separated- it arrives in the format:

firstname, lastname, email, company , yes/no (required, one of these will be present)

 

It’s a messy ‘branded’ microsoft flow email so not just the salient user data, a bunch of other MS branding etc mixed in with it.

Next step now is how to get that relevant CSV body data out of the email and into something Zapier can send into Campaign Monitor fields.

 

Looking into Zapier Parser right now - will update as it comes together. if anyone has any previous experience on this, spare brains much appreciated :)

Cheers

J



 

Update - With a bit of wrangling back in MS Flow/Automate (adding fieldnames before the actual user input) and using Zapier Parser I have successfully managed to extract user data from the forwarded Microsoft email alert. Now to get that to Campaign Monitor !

Update - OK success - Following the instructions here :


The Email Parser Guide: How to Automatically Copy Data From Your Emails (zapier.com)


Managed to send Teams webinar sign-ups where they are saved in a sharepoint doc, through parser, and onto a list in Campaign Monitor. Good job done !
if you’re looking for the teams registrations doc in Sharepoint - it resides in Microsoft Lists - see

https://techcommunity.microsoft.com/t5/virtual-events-and-webinars/attendee-information/m-p/2595007#M260

and also see

https://www.definetomorrow.co.uk/blog/2021/7/29/automating-reporting-and-managing-attendees-with-microsoft-teams-webinars

Hope this helps some people.

WOW! Fantastic work here, @jman! 

Thank you so much for sharing how you solved this. I’m sure this information will be super helpful to many in the Community here! :)

Terms & Conditions