Platform
Ciri
Studio Ejen
Bina dan sesuaikan ejen anda dengan pantas
Enjin Autonomi
guna LLMs untuk membimbing perbualan dan tugasan
Pangkalan Pengetahuan
Latih bot anda dengan sumber pengetahuan tersuai
Jadual
Menyimpan dan menguruskan data perbualan
Saluran
Whatsapp Lambang
WhatsApp
Instagram Lambang
Instagram
Facebook Messenger logo
Messenger
Slack logo
Slack
Semua saluran
Integrasi
Logo Hubspot
HubSpot
Notion logo
Notion
Logo Jira
Jira
Calendly logo
Calendly
Semua integrasi
LLM Pembekal
OpenAI logo
OpenAI
Anthropic logo
Anthropic
Groq logo
Groq
Logo HuggingFace
Hugging Face
Semua LLMs
Penyelesaian
Bagi
Perusahaan
Automasi aliran kerja pengeluaran kritikal misi
Agensi
Menyediakan perkhidmatan ejen yang canggih
Pemaju
Terokai API yang teguh untuk pembangunan ejen
Cerita Pelanggan
Ketahui daripada pelanggan yang berjaya bagaimana Botpress mengubah perniagaan di seluruh dunia.
Mengikut Industri
E-dagang
Pendidikan
Kewangan
Hospitaliti
Semua industri
Mengikut Jabatan
Jualan
Kejuruteraan
Produk
ITSM
Semua jabatan
Mengikut Kes Penggunaan
Pembantu Beli-belah
Penjanaan Utama
Pengalaman Pekerja
Pengurusan Tiket
Semua kes penggunaan
Sumber
Penting
Academy
Belajar membina melalui kursus yang dipilih susun
Perpustakaan
Sumber untuk meningkatkan aliran kerja AI anda
Blog
Cerapan dan kemas kini tentang Botpress dan ejen AI
bangunan
Discord
Sertai beribu-ribu rakan sebaya dan kongsi idea
Dokumen
Panduan dan rujukan yang komprehensif
API
Bahan rujukan untuk digunakan dengan sistem luaran
LLM Kedudukan
Bandingkan prestasi dan kos untuk pembekal model
Video
Tutorial, tunjuk cara dan panduan produk
Changelog
Ikuti perkembangan terkini Botpress kemas kini
Rakan kongsi
Menjadi Rakan Kongsi
Sertai rangkaian pakar bertauliah kami
Upah Pakar
Berhubung dengan rakan kongsi dan perunding
Dokumen
Perusahaan
Harga
Log masuk
KenalanDaftar
kembali ke Hub

SharePoint Excel

v2.2.0
Pasang pada Ruang Kerja anda
Diselenggara oleh Botpress Pasukan Pertumbuhan
  # 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.

Bina Lebih Baik dengan Botpress

Cipta pengalaman ejen AI yang menakjubkan.

Mulakan - ia percuma
Ikon anak panah
Maklumat lanjut di Botpress Academy

Bina ejen AI dengan lebih baik dan pantas dengan koleksi kursus, panduan dan tutorial kami yang dipilih susun.

Upah Pakar

Berhubung dengan pembangun bertauliah kami untuk mencari pembina pakar yang sesuai dengan keperluan anda.

Semua Sistem Operasi
SOC 2
Diperakui
GDPR
Patuh
© 2025
Platform
Harga
Studio Ejen
Enjin Autonomi
Pangkalan Pengetahuan
Jadual
Hub
Integrasi
Saluran
LLMs
Sumber
Bercakap dengan Jualan
Dokumentasi
Upah Pakar
Video
Cerita Pelanggan
Rujukan API
Blog
Status
Sumber v12
Komuniti
Sokongan Komuniti
Menjadi Rakan Kongsi
Menjadi Duta Besar
Menjadi Ahli Gabungan
Syarikat
Tentang
Kerjaya
Berita & Akhbar
Undang
Privasi
© Botpress 2025