Hi @Anuj30 ,
Since you don't have the SharePoint Spoke, you can still automate this without any issues.
A practical approach would be to use Microsoft Graph API to access the Excel file stored in SharePoint. You can create a Scheduled Job in ServiceNow that runs once a month, downloads the latest file from SharePoint, loads it into an Import Set, and then uses a Transform Map to update the Computer [cmdb_ci_computer] table.
The flow would look something like this:
SharePoint Excel File
↓
Microsoft Graph API
↓
ServiceNow Scheduled Job
↓
Import Set Table
↓
Transform Map
↓
cmdb_ci_computer
If your organization already uses Power Automate, that may be even easier. A monthly Power Automate flow can read the Excel file from SharePoint and push the data into ServiceNow through a REST API or Import Set API. This avoids the need for the SharePoint Spoke altogether.
Another option is to use a MID Server if your company prefers file-based integrations. In that case, the Excel file can be synced to a shared folder and a Scheduled Import can process it every month.
My recommendation would be:
Microsoft Graph API + Import Set + Transform Map for a fully automated and scalable solution.
Power Automate + ServiceNow REST API if your M365 team already has Power Automate expertise and licensing.
This is a fairly common pattern when customers do not have the SharePoint Spoke but still need monthly automated imports from SharePoint into CMDB tables.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P
