Skip to main content
Question

Unable to send data from Google Sheets to shared Excel doc on SharePoint.

  • November 15, 2023
  • 1 reply
  • 24 views

Hi all,

We are working with a client that cannot work directly with Google Sheets (for privacy reasons, etc)
So they created a Microsoft Excel doc, which they then shared with us via SharePoint under a shared folder.

We need to send data (new spreadsheet row) from our Google Sheet to this shared Microsoft Excel doc.

We have tried 2 zaps to achieve this with no luck:
1. New or Updated Row in Google Sheets - Add New Row in Microsoft Excel
2. New or Updated Row in Google Sheets - Create List Item in SharePoint

It seems as though it would connect because:
1. It is a shared file/folder
2. Needs to main account admin holder login details for sharepoint

Is there a way around this?
eg. Copy the shared Microsoft Excel url link or something?

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

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 15, 2023

Hi @vamossq 

Good question.

Did you already review the help articles for using Excel in Zaps?

https://zapier.com/apps/excel/help