Plataforma
Características
Estudio de agentes
Crea y personalice su agente rápidamente
Motor autónomo
Utilice LLMs para orientar conversaciones y tareas
Bases de conocimiento
Entrena tu bot con fuentes de conocimiento personalizadas
Tablas
Almacenar y gestionar los datos de las conversaciones
Canales
Whatsapp Emblema
WhatsApp
Instagram Emblema
Instagram
Facebook Messenger logo
Messenger
Logotipo de Slack
Slack
Todos los canales
Integraciones
Logotipo de Hubspot
HubSpot
Logotipo de Notion
Notion
Logotipo de Jira
Jira
Calendly logotipo
Calendly
Todas las integraciones
LLM Proveedores
Logotipo OpenAI
OpenAI
Logotipo Anthropic
Anthropic
Logotipo Groq
Groq
Logotipo de HuggingFace
Hugging Face
Todos LLMs
Soluciones
Para
Empresa
Automatice los flujos de trabajo de producción de misión crítica
Agencias
Proporcionar servicios de agente sofisticados
Desarrolladores
Explore una sólida API para el desarrollo de agentes
Historias de clientes
Descubra de la mano de clientes de éxito cómo Botpress está transformando los negocios en todo el mundo.
Por sector
Comercio electrónico
Educación
Finanzas
Hostelería
Todos los sectores
Por Departamento
Ventas
Ingeniería
Producto
ITSM
Todos los departamentos
Por caso de uso
Asistente de compras
Generación de clientes potenciales
Experiencia de los empleados
Gestión de entradas
Todos los casos de uso
Recursos
Esencial
Academy
Aprenda a construir a través de cursos curados
Biblioteca
Recursos para mejorar sus flujos de trabajo de IA
Blog
Perspectivas y actualizaciones sobre Botpress y agentes de IA
edificio
Discord
Únete a miles de compañeros y comparte ideas
Docs
Guías y referencias completas
API
Material de referencia para uso con sistemas externos
LLM Clasificación
Comparar el rendimiento y el coste de los proveedores de modelos
Vídeos
Tutoriales, demostraciones y guías de productos
Registro de cambios
Mantente al día de las últimas actualizaciones Botpress
Socios
Hágase socio
Únase a nuestra red de expertos certificados
Contratar a un experto
Conectar con socios y asesores
Docs
Empresa
Precios
Inicia sesión
ContáctanosRegístrate
volver a Hub

SharePoint Excel

v2.2.0
Instalar en su espacio de trabajo
Mantenido por 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.

Crea Mejor con Botpress

Cree increíbles experiencias con agentes de IA.

Empieza - es gratis
Icono de una flecha
Aprende más en Botpress Academy

Crea Agentes de AI mejor y más rápido con nuestra colección curada de cursos, guías y tutoriales.

Contratar a un experto

Póngase en contacto con nuestros desarrolladores certificados para encontrar un constructor experto que se adapte a sus necesidades.

Todos los sistemas operativos
SOC 2
Certificado
GDPR
Conforme
© 2025
Plataforma
Precios
Estudio de agentes
Motor autónomo
Bases de conocimiento
Tablas
Hub
Integraciones
Canales
LLMs
Recursos
Hable con Ventas
Documentación
Contratar a un experto
Vídeos
Historias de clientes
Referencia API
Blog
Estado
v12 Recursos
Comunidad
Apoyo comunitario
Hágase socio
Conviértete en embajador
Afiliarse
Empresa
Acerca de
Carreras profesionales
Noticias y prensa
Legal
Privacidad
© Botpress 2025