Skip to main content

Microsoft Graph

Microsoft Graph API integration for Excel automation in OneDrive and SharePoint. This package provides comprehensive Excel file operations through Microsoft's cloud services, enabling you to automate spreadsheet tasks without requiring local Excel installation.

Key Features​

  • Cloud-based Excel automation via Microsoft Graph API
  • Access Excel files in OneDrive and SharePoint
  • OAuth2 authentication with automatic token refresh
  • Complete worksheet management (create, read, update, delete)
  • Cell and range operations
  • Formula support
  • Table creation and management
  • Row and column operations

Authentication​

The Microsoft Graph package uses OAuth2 authentication. You'll need to:

  1. Create an Azure AD application in the Azure Portal
  2. Configure the following permissions:
    • Files.ReadWrite.All
    • Sites.ReadWrite.All
  3. Create a credential vault item with your OAuth2 credentials containing:
    • client_id: Your Azure AD application ID
    • client_secret: Your Azure AD application secret
    • tenant_id: Your Azure AD tenant ID (optional, defaults to "common")

The package automatically handles token refresh and OAuth2 flow when needed.

Connection Modes​

This package supports two authentication modes:

  1. Connect Node Mode: Use the Connect node once and pass the client ID to other nodes
  2. Direct Credentials Mode: Pass credentials directly to each node (useful for parallel operations)

Common Use Cases​

  • Automated report generation in Excel Online
  • Data synchronization between systems and Excel files
  • Batch processing of Excel data in SharePoint
  • Cloud-based Excel file manipulation
  • Multi-user Excel automation workflows

Getting Started​

  1. Start with the Connect node to establish a connection
  2. Use List Files to find Excel files
  3. Use Get Workbook to open a specific file
  4. Perform operations like Get Range or Set Cell Value
  5. Close the connection with Disconnect