Best answer

How can I parse POS alert email to create Google Drive folders in Zapier?

  • 13 June 2024
  • 3 replies
  • 10 views

Userlevel 1

My POS is sending me alerts with job information as follows:

 

The body of the email reads:

 

Alert: New EstimateCustomer: AC CorporationReference #: EST-1234Salesperson: Joe SmithDescription: New project  Event: New Estimate CreatedSubTotal Price: 100.00Occurred: 6/13/2024 8:37 AM

 

 

I want to start using things like the job number and price and create some zaps around that.  My first effort was simply to automate a new job folder in Google Drive but I cant seem to seperate “EST-1234”

 



This is not splitting any data up.   I’ve tried the Formatter and Dissect functions.  I’ve tried to use the email input as both body plain and raw snipped and my out put is just the entire body of the email.  Is there some special code for zapier to recognize “:” that I am not aware of?

 

icon

Best answer by Troy Tessalone 13 June 2024, 16:26

View original

3 replies

Userlevel 7
Badge +14

Hi @Kalish 

Use 2 Zap actions: Formatter > Text > Split

Split by:

#: 

Keep the last segment

 

Split by:

Salesperson:

Keep the first segment

Userlevel 1

Definitely some rookie mistakes there.  Thaks for helping me get back on track

Userlevel 7
Badge +6

That’s awesome @Kalish! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Reply