Skip to main content
Best answer

Zap to Add Row in Excel Spreadsheet located on Group OneDrive or Sharepoint online

  • Mar 11, 2021 7:13 PM UTC
  • 29 replies
  • 2181 views

I am trying to set up a Zap which pulls data from Clio into an Excel Spreadsheet which is located in a Business Group OneDrive or Sharepoint online.   I have no issue pulling the data from Clio and can push it into a Google Sheet or an Excel spreadsheet on a personal (not shared) onedrive.  But I don’t seem to find the way to access the group onedrive folders to be able to push there.  Any help appreciated.

Best answer by SamB

Hi folks! 👋

Sorry we missed your messages here previously, @Online, @Joseph Esposito and @Syndesus_Stacey! Just popping by with a quick update to confirm that this feature request has been implemented. 😁🎉

In case you missed the recent email notification that went out, here’s what you need to know:

“We have now added support for this, via several new features:

We added a new trigger, New Shared Item, which triggers any time a file or folder is directly shared with you. Please note that this will not fire if a file or folder is only created within a folder that is shared with you. If you wish to trigger on such files and folders, you need to explicitly select the folder you wish to monitor in the trigger via the Folder input field.

For searches and actions, we have added a "Shared Folder" input field to Find Folder, Find File, Create New Text File, Upload File, and Create Folder. Generally, you can only choose one folder, either a folder within your drive (set via the "Folder" input field) or a folder shared with you (set via the "Shared Folder" input field). If you select both, the step will immediately error, as we can only use one at a time.”


Please do give those new trigger and actions a try and get in touch if you run into any issues on that at all. In the meantime, happy Zapping! ⚡

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

29 replies

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • Mar 13, 2021 10:00 AM UTC

@jgillman 

From personal experience, only Excel files located in your OneDrive space, not those in shared/group folders are accessible to Zapier.

Would you like me to flag this post so someone from Zapier can add your vote to a feature request?


Matt_Boyden
Forum|alt.badge.img
  • Zapier Staff
  • May 21, 2021 2:08 PM UTC

Hi @jgillman,

 

Andrew is correct, the OneDrive integration won’t work yet with shared/group folders. I’ve added your email address to the feature request for that, so you’ll be notified if/when it is available!


@Matt_Boyden Add us as well, please, to be notified if/when this is available. Thank you!


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • Jul 1, 2021 7:59 PM UTC

Hi @RealTraining!

Your vote has been added to that feature request, which means you'll be notified via email when it's been implemented.


@Matt_Boyden Add us as well, please, to be notified if/when this is available. Thank you!

Please add me, too! :) Thanks in advance!


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • Jul 14, 2021 10:57 AM UTC

Thanks for your reply, @Joydancer81, I’ve added you to that feature request 🙂


  • New
  • Aug 20, 2021 5:32 PM UTC

Hi, @Danvers! Is this still the case? 

If so, are there any workarounds to use Zapier to access files in a shared OneDrive/Sharepoint? Maybe through Web Hooks?

 

Thank you!


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Aug 20, 2021 7:39 PM UTC

Hi there @aims2020. We don’t currently have a solution for this in place but I’ve gone and added your vote to the feature request as well! 🙂


Id also like to be added to the vote for this level of integration. Indeed ive been invited to another companies sharepoint, as they would like me to live update rows in a sheet in a shared folder.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Sep 9, 2021 10:48 AM UTC

Welcome @Harris Karatzetzos! :)

I’ve added your vote for this feature request as well. We’ll be in touch by email once it’s been implemented! 


  • New
  • Sep 17, 2021 6:46 AM UTC

Please add a vote from and add me to the email list to inform me once implemented


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Sep 17, 2021 10:09 AM UTC

Hey @andy.h! 

We’ve added your vote and can confirm that you’ll receive an email notification from us as soon this feature request has been implemented. :)


  • New
  • Sep 22, 2021 7:21 PM UTC

Please add me to the list be notified once this feature is implemented.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Sep 23, 2021 9:11 AM UTC

Welcome to the Community, @marysavage! :)

Happy to confirm that your vote has been added to the list. You’ll get notified by email when that feature has been added! 


  • New
  • Oct 27, 2021 4:53 PM UTC

Please add a vote from and add me to the email list to inform me once implemented.  This would be a huge help to me.


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Oct 27, 2021 5:40 PM UTC

Thanks for reaching out, @kaiarter! I’ve got your vote added and you’re all set. 🙂We’ll be sure to send an email and update this thread once we know more! 


Forum|alt.badge.img+1
  • Tinkerer
  • Dec 20, 2021 8:12 PM UTC

Take my vote please!


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Dec 21, 2021 7:49 AM UTC

You got it, @ericg! I’ve got your vote added and we’ll be sure to keep you in the loop as soon as we know more. 🙂


Hi @jgillman,

 

Andrew is correct, the OneDrive integration won’t work yet with shared/group folders. I’ve added your email address to the feature request for that, so you’ll be notified if/when it is available!

Please Add me as well!!!


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Jan 11, 2022 12:53 AM UTC

Thanks for reaching out. I’ve got your vote added to that feature request, @Wolfgang H.!


NadiaW
Forum|alt.badge.img
  • Zapier Staff
  • Mar 10, 2023 7:16 PM UTC

Hello! I would share a workaround that one of our customers was able to use successfully to get around this limitation, in case it’s helpful for you all.
They used Microsoft's Power Automate's template to copy a shared file to their own account. Here is a screenshot of how they configured the template: 


JTHOM6
Forum|alt.badge.img
  • Beginner
  • Apr 11, 2023 1:02 AM UTC

Add me too please. @JTHOM6 


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • Apr 11, 2023 6:17 AM UTC

Thanks - I’ve got you added, @JTHOM6. Also replied to your other topic as well. 🙂


Online
  • New
  • Apr 28, 2023 12:27 PM UTC

Hello, I have created a Zap that if an Article is added to any feedly board, create a row in excel file which is located on onedrive. Now, the problem is that the Zap is successful but there is no entry in the excel file. It is still empty. Could you please enlighten what can be the problem?


Joseph Esposito

@christina.d  Has this bug been fixed? this identified issue has been outstanding for what seems to be two years. May you also add me to the recipient list?