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.

Question

Trouble attaching a specific Google Sheets worksheet from OneDrive to an Outlook email.

shdk85

Hi!

I am trying to figure out how to export and email a specific worksheet once a week from a spreadsheet and am running into some issues. 

The original spreadsheet lives on OneDrive, but I wasn’t able to find anything related to finding worksheets with that integration, so I thought I might be able to solve that by uploading the OneDrive spreadsheet to Drive on a weekly basis, and go from there. So far so good.

Next I was using the “find worksheet action” through the Google Sheets integration, which was also able to find the worksheet in question.

But it doesn’t seem as if I am able to use this worksheet to attach it in my “Outlook/Send Email” action in the last step. I have access to the worksheet ID, but don’t see any values that would allow me to attach this to the email that is being sent.

Any advice is greatly appreciated - thank you!

 

 

4 replies

Brem
Userlevel 4
Badge +6

Hi @shdk85 

Welcome to the Community! I'm sorry you’re having trouble with your Zap.

Have you tried using the ID from the result of step 4 in Google Sheets?

a4c4f16d4c55e30427074ce9b6a18cd4.png

Please give it a try and see if it achieves the result that you want.

shdk85

Hi @Brem -

 

I tried just using the ID from step 4 in the attachment field, but that just attaches a .txt file with that number. I also tried combining the file URL from step 3 with the ID from step 4, but it still send the complete google sheet, not the individual worksheet I need.

I also tried copying/creating a new worksheet based on the worksheet I’m trying to send, but it doesn’t transfer over the values / just grabs the formulas if that makes sense.

I feel like I’m missing something obvious, but not sure. Your help is much appreciated!

 

 

shdk85

To add to this, I also tried to see if I could convert the worksheet with CloudConvert to circumvent some of these problems. I’m using the IDs for the spreadsheet and specific worksheet, and while the resulting URL in the test seems to look OK, I’m getting an error when running the test:

 

Charie
Userlevel 3
Badge +4

Hi @shdk85 

Thanks for confirming that information.

Unfortunately, the "Find Worksheet" won't export it to a file as it only fetches the details of the worksheet.
Using a different app, you would have to export the worksheet as a file.

You may check other apps here: https://zapier.com/apps/categories/documents

Let me know if you have other questions.

Reply


Terms & Conditions