Creating a new file in OneDrive form a form received in Gmail

Hi there @Olly23,

Welcome to the Community! 🎉

Here is how I see the Zap for the workflow that you have in mind:

1. Trigger: Gmail - New Email Matching Search - This will trigger on a new email that matches a search string you provided.
2. Action: OneDrive - Upload File - You can then map the sender’s email address or name from the trigger to the “File Name” field, and map the attachment file from the email to the “File” field.

Hopefully, this helps! 😊

Hi 

that’s great do I need to use a passer to do this? 
 

it doesn’t seem to be giving me the name as a option? 
 

thanks

olly

Hi @Olly23,

Is the form going to be sent in the same format every time? If so, you’re probably going to need to add a Text in Formatter by Zapier - Extract Pattern step.

To help you set this up, could you share an example of the email's structure? Just a heads up, please use a fictitious or test name to keep everything confidential.

Thanks! 😊

Thanks this is a copy of the email I'm trying  to extract the name from, so that any future emails from this sender will go to create a new file in one drive.

Many thanks

Olly

Hi @Olly23,

Thanks for the screenshots!

You can use this Regex pattern in the field: (?<=Name:\n\n)(.*?)(?=\n\nDate of Birth:) and map the “Body Plain” data from Gmail to the “Input” field. Like so:

(view larger)

If that doesn’t work, you can try using Email Parser by Zapier or Mailparser. Here are some help articles to help you get started:

• Mailparser: https://help.mailparser.io/hc/en-us/articles/16253533062420-Send-Your-Parsed-Data-to-other-apps-via-Zapier
• Email Parser by Zapier: https://zapier.com/blog/email-parser-guide/

Hopefully, this helps! 😊