Platform
Mga tampok
Ahente Studio
Buuin at i-customize ang iyong ahente nang mabilis
Autonomous Engine
Gamitin LLMs upang gabayan ang mga pag-uusap at gawain
Mga Batayan ng Kaalaman
Sanayin ang iyong bot gamit ang mga custom na mapagkukunan ng kaalaman
Mga mesa
I-store at pamahalaan ang data ng pag-uusap
Mga channel
Whatsapp Emblem
WhatsApp
Instagram Emblem
Instagram
Facebook Messenger logo
Messenger
Slack logo
Slack
Lahat ng channel
Mga pagsasama
Logo ng Hubspot
HubSpot
Notion logo
Notion
Logo ni Jira
Jira
Calendly logo
Calendly
Lahat ng pagsasama
LLM Mga provider
OpenAI logo
OpenAI
Anthropic logo
Anthropic
Groq logo
Groq
HuggingFace logo
Hugging Face
Lahat LLMs
Mga solusyon
Para sa
Enterprise
I-automate ang mga mission-critical production workflow
Mga ahensya
Magbigay ng mga sopistikadong serbisyo ng ahente
Mga developer
Galugarin ang isang matatag na API para sa pagbuo ng ahente
Mga Kwento ng Customer
Tuklasin mula sa matagumpay na mga customer kung paano Botpress ay nagbabago ng negosyo sa buong mundo.
Sa pamamagitan ng Industriya
Ecommerce
Edukasyon
Pananalapi
Hospitality
Lahat ng industriya
Sa pamamagitan ng Kagawaran
Benta
Engineering
produkto
ITSM
Lahat ng departamento
Sa pamamagitan ng Use Case
Shopping Assistant
Lead Generation
Karanasan ng Empleyado
Pamamahala ng Ticket
Lahat ng use case
Mga mapagkukunan
Mahalaga
Academy
Matutong bumuo sa pamamagitan ng mga curated na kurso
Library
Mga mapagkukunan upang mapahusay ang iyong mga daloy ng trabaho sa AI
Blog
Mga insight at update sa Botpress at mga ahente ng AI
gusali
Discord
Sumali sa libu-libong mga kapantay at magbahagi ng mga ideya
Docs
Mga komprehensibong gabay at sanggunian
API
Sangguniang materyal para sa paggamit sa mga panlabas na sistema
LLM Pagraranggo
Ihambing ang pagganap at gastos para sa mga provider ng modelo
Mga video
Mga tutorial, demo, at walkthrough ng produkto
Changelog
Manatiling up-to-date sa pinakabago Botpress mga update
Mga kasosyo
Maging Kasosyo
Sumali sa aming network ng mga sertipikadong eksperto
Mag-hire ng Expert
Kumonekta sa mga kasosyo at consultant
Docs
Enterprise
Pagpepresyo
Mag log in
Makipag-ugnayanMag-sign up
balik sa Hub

SharePoint Excel

v2.2.0
I-install sa iyong Workspace
Pinapanatili ng Botpress Growth Team
  # 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.

Bumuo ng Mas mahusay na may Botpress

Gumawa ng mga kamangha-manghang karanasan sa ahente ng AI.

Magsimula - libre ito
Icon ng isang arrow
Matuto pa sa Botpress Academy

Bumuo ng mga ahente ng AI nang mas mahusay at mas mabilis gamit ang aming na-curate na koleksyon ng mga kurso, gabay, at tutorial.

Mag-hire ng Expert

Kumonekta sa aming mga sertipikadong developer para makahanap ng ekspertong tagabuo na nababagay sa iyong mga pangangailangan.

Lahat ng System Operational
SOC 2
Certified
GDPR
Sumusunod
© 2025
Platform
Pagpepresyo
Ahente Studio
Autonomous Engine
Mga Batayan ng Kaalaman
Mga mesa
Hub
Mga pagsasama
Mga channel
LLMs
Mga mapagkukunan
Makipag-usap sa Sales
Dokumentasyon
Mag-hire ng Expert
Mga video
Mga Kwento ng Customer
Sanggunian ng API
Blog
Katayuan
v12 Mga Mapagkukunan
Komunidad
Suporta sa Komunidad
Maging Kasosyo
Maging Ambassador
Maging isang Affiliate
kumpanya
Tungkol sa
Mga karera
Balita at Press
Legal
Pagkapribado
© Botpress 2025