Skip to main content

Hi I have an excel file located in sharepoint, which I want to turn it into a json file to use in a zapier “Run python by code” block. However I am not sure how to turn the excel file to a json file.

If it was a google sheets I could use the “Get many spreadsheet rows”, but there I can’t find an equivalent for an excel file in sharepoint. I cannot just convert to google sheets, because I do not have access to google sheets.

Hi @testing123 

Good question.

You may have to explore using the SharePoint API to get the contents of an Excel file.

Zap action: SharePoint - App Extensions

Use the AI to help configure.