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.

Hi, I have a zap that collects data from a webhook and creates a new row in a google sheet.

Then I need to send a copy of that google sheet to an email recipient.

The email is sending correctly but the attachment (google sheet) has no name and no file extension (see attached). 

Please, does anyone know how do I attach the file so that I can download it and open it?

Thank you 

 

Hi @mrmac2you 

Please post screenshots of how your Zap steps are configured, thanks.

Hi @Troy Tessalone I have a simple 3 step zap - it all works except that the attachment I am adding to the email does arrive in the recipients mailbox in any format that can be opened - the file name does not match any name of a file in my drive either.

I’ve attached the steps and the URL that I added to the attachments field in the last step.

Thank you 

@mrmac2you 

You need to use the File download URL, which is different than the file sharing URL.

Also, the file URL needs to be publicly accessible, so you may have to adjust the file sharing permissions in GDrive.

Best way to test is to open the file URL you are trying to use in a new private browser.

If the browser file attempts to download the file, then you are using the correct file URL.

@mrmac2you 

Check out this related article:

 

Thank you very much for getting back to me on this one @Troy Tessalone - I think I messed up the syntax so when I test it I just get a 404 error.

My drive does not give me a download link, only a share link which I modified using the guidance in the article 

 

https://drive.google.com/drive/u/0/my-drive/uc?export=download&id=<FILEID>

This is what I used 

 

Thank you 

@mrmac2you

You need to replace the FILE ID at the end of the link with the ID of the file, which would be the redacted value in the screenshot you provided.

 

@mrmac2you

You need to replace the FILE ID at the end of the link with the ID of the file, which would be the redacted value in the screenshot you provided.

 

My apologies @Troy Tessalone - I should have added that I was already replacing the fileid at the end.

I’m going to have to find a different way to do this, I have now spent too much time trying to get this one single step to work. 

I noticed that there is a comment in the following document saying that the method you described above only works for files NOT created in Google Drive. 

I created a new XLS and uploaded that to my drive but then Zapier is not able to see the sheet, even after changing permissions etc.

Thank you 

@mrmac2you 

You can do a GDrive Find File step and it will return many different URLs, one of which is the download URL for the file.

Thank you very much @Troy Tessalone - the “find” option has turned out to be the way forward.

I do appreciate you taking the time to guide me here. 

Terms & Conditions