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