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 auto-upload Gmail attachments to specific Google Drive folders for numerous contractors?
Question

How can I auto-upload Gmail attachments to specific Google Drive folders for numerous contractors?

  • 12 February 2024
  • 6 replies
  • 135 views
B

Hello 

I need a possible solution on how I can automatically upload incoming gmail attachment to its specific folder on google drive. To put in specifics suppose I received a specific email with an attached file that needs to be uploaded to specific folder on google drive now I tried doing this by creating lots of paths and different zaps for each contractors but there are many of them so path limit is an issue. Is there any other way to do this? i can do different zaps for different contractors but can i use other tools to fit it in one? 

thank you

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

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Beka 

Try using a Lookup Table:

 

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

Can you expand on this? I have 11 different clients with their own google drive folders and each of them contain 4 main folders (MAF,IPC,WIR,RFI) and in each of them there are different contractors. is there any way to automate process, i receive an email with an attachment which for example is named “Client-MAF-Contractor” I need this to be moved to that specific clients MAF folder and to specific contractor folder. how can i automate process by using lookup table do you have any suggestions?

Thank you

Troy Tessalone
Userlevel 7
Badge +14

@Beka 

Can you outline a specific example for us to have more context?

We would need to see the file name and the matching GDrive Folders.

You may need to use a Formatter > Text > Split (return as separate fields) to isolate the parts of the file name to then use to search by for GDrive Folders.

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

 

The trigger for zap would be new attachment from gmail (from one specific email)

New attachment has name as follows: our company name-client-document type (ex. WIR)-contractor name-discipline-revision-grade, every one of them has 2, 3 or 4 letter abbreviation so for example:

LMK-GTC-WIR-ANJ-CIV-001-Rev00.pdf from this example I need to sort buy Client (GTC), Document type (WIR), and contractor (ANJ) i need this attachment to move to GTC’s folder > WIR folder > ANJ’s folder. 

now i am guessing the workflow will be something like this: 

  1. trigger new attachment on gmail
  2. filter by name the document type maybe using paths (WIR,IPC,MAF,RFI) 
  3. find a folder on Gdrive by client name (GTC) and contractor name (ANJ) (lookup table?)
  4. move a file to that specific folder

Now i understand that layout should be something like this but i don’t understand how lookup table could be used or how finding a folder could be used (so basically steps 3 and 4)

B

Gdrive folder is as follows 

 

company abbreviation  > 10 QC > 05 WIR’s > 02 contractor name > 00 Submissions

 

every client folder as the same numbering in the beginning (10 is for QC, 05 is for WIR’s, 02 is for contractor, 00 is for submissions)  so i am guessing i could use that to my advantage.

Troy Tessalone
Userlevel 7
Badge +14

@Beka 

Try these Zap steps:

  1. Trigger: Gmail - New Attachment
  2. Action: Filter
    1. TBD if you need this step or not as you may be able to filter in Step 1
  3. Action: Formatter > Text > Split
    1. Split by -
    2. Return as separate fields
  4. Action: GDrive - Find Folder
    1. Search by Client (GTC)
    2. Set the Parent Folder to search within
  5. Action: GDrive - Find Folder
    1. Search by Doc Type (WIR)
    2. Map the Folder ID from the previous step to search within
  6. Action: GDrive - Find Folder
    1. Search by Contractor (ANJ)
    2. Map the Folder ID from the previous step to search within
  7. Action: GDrive - Upload File
    1. Map the Folder ID from the previous step
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions