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 Asked & Answered 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.

Best answer

Upload gmail attachments to Google Drive folder - file extension gets duplicated

  • December 20, 2024
  • 6 replies
  • 148 views
M

So the zap seams pretty simple

I’m using new Attachment in gmail trigger and I want to upload the attachments to Google Drive.

each attachment could be a different file type so I’m leaving the “File Extension” parameter blank. (screenshot attached)

 

I’m expecting the filename to be “2024.12.06 - scan.jpg” and I’m getting ““2024.12.06 - scan.jpg.jpg”

Otherwise everything else is working fine.

 

I have created similar zaps before using the older versions of the Google Drive app and this has never happened before.

 

Any ideas?

 

Best answer by Troy Tessalone

Hi ​@Marika Shmotolocha 
 

Instead of using a Code step which counts as 1 Task, you can use a Formatter step that counts as 0 Tasks.

Zap action: Formatter > Text > Extract Pattern

^(.*?)(?:\.[^.]+)?$

 

Issue with the File name having double file extensions is because the file name include the extension already. (e.g. .jpg)

So even when you leave the File Extension field, GDrive is determining the file extension and including it as part of the file name you see.

Thus it becomes [file.jpg] + “.jpg” = file.jpg.jpg

 

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

Badger
Forum|alt.badge.img+5
  • Badger
  • New
  • December 20, 2024

​@Marika Shmotolocha 

Check your configuration it’s likely that the zap is adding the extension and you need to change a setting.

Most likely there will be a setting in the File Extension at the bottom. I believe if this is blank your files won’t get renamed. 

If it is blank reconnect your google drive in case it is misaligned.

 

 

M

it is blank (see attached screenshot.  That’s why I don’t understand why it’s adding it again.

Badger
Forum|alt.badge.img+5
  • Badger
  • New
  • December 20, 2024

 

This was wrong. See my next reply

Badger
Forum|alt.badge.img+5
  • Badger
  • New
  • December 20, 2024

​@Marika Shmotolocha 

I have just looked at it and any value I use from the gmail attachment ends up with a double extension. My idea about dates is invalid. 

What I found was I needed to strip the extension from the filename and then it would upload correctly.

I used a python code block to remove the last 4 characters and the upload worked

 

 

I hope that helps.

 

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • Answer
  • December 20, 2024

Hi ​@Marika Shmotolocha 
 

Instead of using a Code step which counts as 1 Task, you can use a Formatter step that counts as 0 Tasks.

Zap action: Formatter > Text > Extract Pattern

^(.*?)(?:\.[^.]+)?$

 

Issue with the File name having double file extensions is because the file name include the extension already. (e.g. .jpg)

So even when you leave the File Extension field, GDrive is determining the file extension and including it as part of the file name you see.

Thus it becomes [file.jpg] + “.jpg” = file.jpg.jpg

 

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor
    SamB
    Community Manager
    Forum|alt.badge.img+11
    • SamBCommunity Manager
    • Community Manager
    • December 23, 2024

    Thanks for marking the best answer here ​@Marika Shmotolocha! 🙏 I’m so pleased Troy’s suggestion was able to help get things solved. Big shoutouts to both ​@Troy Tessalone and ​@Badger for helping out here—love to see it! 🧡

    Image: b9641a96c3dbfdb2f98995138fb82b3f

    Build beyond no-code with the Zapier SDK

    Join us on Friday, June 19, 11:30 a.m. ET for a hands-on community build-along where you'll learn the Zapier SDK, follow a live walkthrough, then build your own use case with a Zapier team member in your corner.

    Register now!
    Terms & ConditionsAccessibility statement