平台
特点
代理工作室
快速建立和定制您的代理
自主发动机
使用LLMs 引导对话和任务
知识库
使用自定义知识源训练机器人
表格
存储和管理对话数据
渠道
Whatsapp 徽章
WhatsApp
Instagram 徽章
Instagram
FacebookMessenger 徽标
Messenger
Slack 徽标
Slack
所有频道
集成
Hubspot 徽标
HubSpot
Notion 徽标
Notion
Jira 徽标
Jira
Calendly 徽标
Calendly
所有集成
LLM 提供商
OpenAI 徽标
OpenAI
Anthropic 徽标
Anthropic
Groq 徽标
Groq
拥抱脸庞徽标
Hugging Face
全部LLMs
解决方案
对于
企业
实现关键任务生产工作流程自动化
机构
提供完善的代理服务
开发者
探索用于代理开发的强大 API
客户故事
从成功客户那里了解Botpress 如何改变全球业务。
按行业分类
电子商务
教育
财务
接待服务
所有行业
部门
销售
工程学
产品
ITSM
所有部门
按用例
购物助理
潜在客户生成
员工体验
票务管理
所有用例
资源
必要
Academy
通过精心设计的课程学习建造
图书馆
增强人工智能工作流程的资源
博客
有关Botpress 和人工智能代理的见解和最新情况
建筑物
Discord
与成千上万的同行一起交流思想
文件
全面的指南和参考资料
应用程序接口
与外部系统配合使用的参考资料
LLM 排名
比较模式提供商的性能和成本
视频
教程、演示和产品演示
更新日志
了解Botpress 的最新更新
合作伙伴
成为合作伙伴
加入我们的认证专家网络
聘请专家
与合作伙伴和顾问联系
文件
企业
价格
登录
联系方式注册
返回Hub

SharePoint Excel

v2.2.0
安装到工作区
由Botpress 增长团队维护
  # SharePoint Excel Integration

## Overview

This integration allows you to sync one or many Excel sheets from a SharePoint document library into one or more Botpress tables. You can map each sheet to a specific table, and the integration will automatically create or update tables as needed. Knowledge Base (KB) links are always preserved—tables are never deleted, only cleared and repopulated.

## Configuration

To set up the connector, you need an App registration with the correct API permissions in Microsoft Entra admin center and the following details:

- **Client ID**: Application (client) ID of your App registration.
- **Tenant ID**: Directory (tenant) ID of your App registration.
- **Thumbprint**: Thumbprint of the certificate you uploaded to your App registration.
- **Private key**: Content of your private key used to sign the certificate. **Important**: Only include the content between "-----BEGIN PRIVATE KEY-----" and "-----END PRIVATE KEY-----", excluding these header and footer lines. The content should be one continuous string with spaces between each line of the key.
- **Primary Domain**: The SharePoint primary domain (e.g. `contoso`).
- **Site Name**: The name of the SharePoint site.
- **Botpress Personal Access Token (PAT)**: A Personal Access Token from your Botpress workspace, required for Tables API access.

## Action: Sync Excel File

### Inputs
- **sharepointFileUrl**: Relative path to the Excel file in SharePoint. The path should be in the format `/{DOCUMENT_LIBRARY}/{file_path}` where:
  - `DOCUMENT_LIBRARY` is the name of your SharePoint document library (e.g., "Documents", "Shared Documents", or any custom library name)
  - `file_path` is the path to your Excel file within that library, including any subfolders
  - Examples:
    - `/Documents/Book.xlsx` - File in the root of the Documents library
    - `/Shared Documents/Reports/2024/Book.xlsx` - File in a nested folder structure
    - `/MyCustomLibrary/Data/Book.xlsx` - File in a custom document library
- **sheetTableMapping**: Map sheets to tables. Format can be either:
  - Comma-separated: `Sheet1:table1,Sheet2:table2`
  - JSON: `{ "Sheet1": "table1", "Sheet2": "table2" }`

  Each sheet listed will be synced to the specified table. If a table does not exist, it will be created with a schema matching the sheet's columns. If it exists, all rows will be cleared before new data is inserted. **Note:** If providing a pre-existing table, ensure its column names match the Excel sheet headers exactly, as the integration will not alter an existing table's schema.

### Example
```json
{
  "sharepointFileUrl": "/doclib1/Book.xlsx",
  "sheetTableMapping": "Sheet1:Customers,Sheet2:Orders"
}
```

## How to's

### How to register an app on Microsoft Entra admin center
- From the Home page of Microsoft Entra admin center, open App registrations (under Applications in the left nav).
- Add a new registration by clicking on "+ New registration".
- Give your app an appropriate name, and click register.
- Open the App registration and take note of the following:
  - `Application (client) ID`
  - `Directory (tenant) ID`

### How to create a certificate for your app registration
- We will be using a self-signed certificate to authenticate. To create a self-signed certificate, run the following commands:
  - `openssl genrsa -out myPrivateKey.key 2048`
  - `openssl req -new -key myPrivateKey.key -out myCertificate.csr`
  - `openssl x509 -req -days 365 -in myCertificate.csr -signkey myPrivateKey.key -out myCertificate.crt`

### How to add your certificate to your app registration
- Navigate to the Azure portal and go to your Azure AD app registration.
- Under "Certificates & secrets," choose "Certificates" and click "Upload certificate."
- Upload your `.crt` file.

### How to update API permissions for your app registration
- Go to "API Permissions" (under the Manage group in your App Registration).
- Click "Add a permission".
- Click on "Microsoft Graph".
- Select "Application permissions" as the type of permission.
- Check `Sites.FullControl.All`, `Sites.Manage.All`, `Sites.Read.All`, `Sites.ReadWrite.All`, `Sites.Selected.All`, `Files.Read.All`, and `Files.ReadWrite.All`.
- Click "Add a permission" again.
- Scroll until you find SharePoint and click on it.
- Select "Application permissions" as the type of permission.
- Check `Sites.FullControl.All`, `Sites.Manage.All`, `Sites.Read.All`, `Sites.ReadWrite.All`, and `Sites.Selected.All`.
- Click "Add permissions."
- You should see all the permissions you added in the permissions list.
- Click on "Grant admin consent for <your_org_name>".

## Notes
- The integration always preserves tables to maintain KB links. Tables are never deleted, only cleared and repopulated.
- If a sheet or table mapping is invalid, the action will fail with a descriptive error.
- Data types for columns are auto-detected (string or number) based on the sheet data.
- If you choose to pre-create a table in Botpress, ensure its column names exactly match the corresponding Excel sheet's header row. The integration will clear existing data but will not alter the schema of an existing table. For successful data import, the column names must align.

用Botpress

打造令人惊叹的人工智能代理体验。

开始免费使用
箭头图标
了解更多信息,请访问Botpress Academy

利用我们精心挑选的课程、指南和教程,更好更快地构建人工智能代理。

聘请专家

与我们的认证开发人员联系,寻找适合您需求的Botpress 专家。

所有系统运行
SOC 2
认证
GDPR
符合要求
© 2025
平台
价格
代理工作室
自主发动机
知识库
表格
Hub
集成
渠道
LLMs
资源
咨询销售人员
文档
聘请专家
视频
客户故事
API参考
博客
状态
v12 资源
社区
社区支持
成为合作伙伴
成为大使
成为会员
公司
关于
职业机会
新闻中心
法律门户
隐私权
©Botpress 2025