Welcome to Next Matter home pagelight logodark logo
  • Contact us
  • Status
  • Sign in
  • Sign in
Get started
Components
Integrations
Portals
Sidebars
Solutions
Updates
APIs
  • Product updates
  • Videos
  • Overview
    • Integration types
    • Webhook triggers
    • Templates
    • Scopes and permissions
    API
    • API keys and credentials
    • Quick scripts and API examples
    No-code
    • No-code automations
    • Quick actions
    • Next Matter actions
    • No-code operations
    Custom integrations
    • Integrate with Airtable
    • Integrate with Amazon Redshift
    • Integrate with Asana
    • Integrate with Azure Event Hubs
    • Integrate with Box
    • Integrate with DHL
    • Integrate with Docusign
    • Integrate with Front
    • Integrate with Freshdesk
    • Integrate with GIPHY
    • Integrate with Google
    • Integrate with HubSpot
    • Integrate with Intercom
    • Integrate with Jira
    • Integrate with Mailchimp
    • Integrate with Microsoft
      • Integrate with Microsoft
      • Integrate with Microsoft Dynamics 365
      • Integrate with Outlook
      • Integrate with SharePoint
      • Integrate with Teams
      • Integrate with Excel
      • Integrate with OneDrive
    • Integrate with Notion
    • Integrate with Nutshell
    • Integrate with PostgreSQL
    • Integrate with Sendgrid
    • Integrate with Slack
    • Integrate with Smartsheet
    • Integrate with Twilio
    • Integrate with Zapier
    • Integrate with Zendesk
    Custom integrations
    Integrate with Microsoft

    Integrate with Excel

    You can add worksheets, use Vlook, add rows, or update row data.

    As part of the integration, you need to whitelist the Next Matter domain and create a service account. See if you’ve completed all the required steps.

    It might also happen that a placeholder can be replaced by a data reference of the data provided in one of the previous steps. That’s why it’s a good idea to learn more about Data references.

    Use a Next Matter no-code step. You can select it in Integrations. For details, see Excel no-code

    ​
    Prerequisites

    • Get your file drive ID. You’ll need it in the step configuration. To get the ID

      1. Sign in to https://developer.microsoft.com/graph/graph-explorer.

      2. Select GET as the method, and provide the following URL: GET https://graph.microsoft.com/v1.0/users/{user-id}/drives This call will list all the drive data for a specific user.

      3. View the JSON response for the value of the id parameter.

    • Get the drive item ID (workbook ID). To get it, call this endpoint: https://graph.microsoft.com/v1.0/me/drive/root/search(q=’.xlsx’)?select=name,id,webUrl

    • Get the table name you’ll be editing. To get a table name, click on the table. Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name

    • Make sure that the range is formatted as a table in Excel.

    ​
    Add worksheet to workbook

    1. In your Next Matter workflow, click +Add step and select Integration > Custom integration.

    2. Click Settings to configure the step.

    3. Enter the following details:

      • Authorization: Microsoft OneDrive

      • Method: POST

      • URL: https://graph.microsoft.com/v1.0/me/drive/items/DRIVE_ITEM_ID/workbook/worksheets/

      • Content-Type: application/json

      • In the Body enter the values you want to add in the table row.

        Copy
        Ask AI
        {
            "name": "SHEET_NAME" //this is a placeholder
        }
        
    4. Save your changes.

    ​
    Use Vlookup

    Use VLOOKUP to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. For details, see Vlookup.

    1. In your Next Matter workflow, click + Add step and select Integration > Custom integration.

    2. Click Settings to configure the step.

    3. Enter the following details:

      • Authorization: Microsoft OneDrive

      • Method: PATCH

      • URL: https://graph.microsoft.com/v1.0/drives/DRIVE_ID/items/DRIVE_ITEM_ ID/workbook/worksheets/WORKSHEET_NAME/range(address='RANGE') Tip: The worksheet name is the name of the current tab Provide the range in the format of A1:A1 (it defines the cell or cells containing VLOOKUP formula)

      • Content-Type: application/json

      • In the Body enter the values you want to add in the table row.

        Copy
        Ask AI
        {
        "formulas" : [  ["=VLOOKUP(\"LOOKUPVALUE\",SEARCH_RANGE,INDEX,FALSE)"] ]//these are all placeholders; 
        }// If you want to look up a number field instead of a text field, remove the \" characters from Vlookup
        
    4. Add a variable for the Vlookup result with the value of $.text[0][0]

    5. Save your changes.

    Was this page helpful?

    Integrate with TeamsIntegrate with OneDrive
    youtubelinkedin
    Powered by Mintlify
    Assistant
    Responses are generated using AI and may contain mistakes.