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
  • How can I create subfolders in Google Drive based on email content and move PDFs there?

I am using a Zap to watch for a gmail with a specific tag.  It then auto creates a PDF of the attachment and places it is a folder on Gdrive.  What I would like to do is to use a specific word in the email to create a sub folder based on that word.  The email has a 2 letter abbreviation for a state.  I would like to auto create the subfolder based on that abbreivation (if it does not already exist) and place the finished pdf in that folder.

 

Is that possible?

 

Thanks

Hi @robmich 

Good question.

Can you post screenshots of a specific example to help give us more context.

Sure…

 

ITQ Form Responses - Stamford Police Department, TX

 

I need to search on the above subject line or:

The below actual name of the file:

MSI Mobile Video IT Questionnaire - v2.0 Bald Knob Police Department, AR.pdf"

 

I would need to use the two letter state abbreviation for the sub folder.

Rob

 

   

@robmich 

You can use Formatter > Text > options to isolate the 2 letter state abbreviation if it’s always the last 2 letters in the subject line.

That is great. As I am pretty new to Zapier, if someone could assist with an example  I  would be grateful. 

 

Rob

@robmich 

Try this Formatter step if there is only 1 comma in the Subject.

 

That looks like it would work.  I have a functional Zap and there is supposed to be a + at the end so I can add the formatter.  I believe I have tried to look for it in edit but it is not there.  Is there something else I need to do to see the +.  Sorry for the dumb question.

 

Rob

@robmich 

Please post screenshots with how your Zap steps are configured to help us have true context.

Here ya go.. Thanks for the help...

 

 

 

 

 

@robmich 

Can you post screenshots about this?

 

I have a functional Zap and there is supposed to be a + at the end so I can add the formatter. 
I believe I have tried to look for it in edit but it is not there. 
Is there something else I need to do to see the +.

OK, I am slowly Figuring this out. I am successfully creating the child folder in the parent, but the attachment to the email it queries is not getting there.  I will keep trying.  Do not want to bog down this folder..

 

Rob

 

Terms & Conditions