About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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?
Question

How can I create subfolders in Google Drive based on email content and move PDFs there?

  • 15 November 2023
  • 10 replies
  • 51 views
R

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @robmich 

Good question.

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R

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

 

   
Troy Tessalone
Userlevel 7
Badge +14

@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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R

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

 

Rob

Troy Tessalone
Userlevel 7
Badge +14

@robmich 

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

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R

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

Troy Tessalone
Userlevel 7
Badge +14

@robmich 

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R

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

 

 

 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@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 +.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
R

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