Skip to main content
  • 🚀 Quickstart
  • 🧑‍💻 OAuth app setup
  • 🚨 API gotchas
1

Create an integration

In Nango (free signup), go to Integrations -> Configure New Integration -> Microsoft Excel. Nango doesn’t provide a test OAuth app for Microsoft Excel yet. You’ll need to set up your own by following these instructions. After that, make sure to add the OAuth client ID, secret, and scopes in the integration settings in Nango.
2

Authorize Microsoft Excel

Go to Connections -> Add Test Connection -> Authorize, then log in to Microsoft Excel. Later, you’ll let your users do the same directly from your app.
3

Call the Microsoft Excel API

Let’s make your first request to the Microsoft Excel (Microsoft Graph) API (fetch worksheets from a specific workbook). Replace the placeholders below with your secret key, integration ID, connection ID, and a workbook file ID:
  • cURL
  • Node
curl "https://api.nango.dev/proxy/v1.0/me/drive/items/{fileId}/workbook/worksheets" \
  -H "Authorization: Bearer <NANGO-SECRET-KEY>" \
  -H "Provider-Config-Key: <INTEGRATION-ID>" \
  -H "Connection-Id: <CONNECTION-ID>"
Or fetch credentials dynamically via the Node SDK or API.
The {fileId} in the URL is the unique identifier for the Excel file in OneDrive/SharePoint. You can obtain this ID by first making a Nango proxy call to /v1.0/me/drive/root/children to list files and retrieve their IDs. Then, use the ID of the desired workbook to access its worksheets.
✅ You’re connected! Check the Logs tab in Nango to inspect requests.
Next step: Embed the auth flow in your app to let your users connect their Microsoft Excel accounts.
Questions? Join us in the Slack community.