Can AITable.ai connect with Microsoft Excel 365?

Yes, AITable.ai can connect with Microsoft Excel 365 using n8n.io. With n8n, you can create workflows that automate tasks and transfer data between AITable.ai and Microsoft Excel 365. Configure nodes for AITable.ai and Microsoft Excel 365 in the n8n interface, specifying actions and triggers to set up their connection.

Can I use AITable.ai’s API with n8n?

Yes, with n8n, you can programmatically interact with AITable.ai’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.

Can I use Microsoft Excel 365’s API with n8n?

Yes, with n8n, you can programmatically interact with Microsoft Excel 365’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.

Is n8n secure for integrating AITable.ai and Microsoft Excel 365?

Yes, it is safe to use n8n to integrate AITable.ai and Microsoft Excel 365. n8n offers various features to ensure the safe handling of your data. These include encrypted data transfers, secure credential storage, RBAC functionality, and compliance with industry-standard security practices (SOC2 compliant). For hosted plans, data is stored within the EU on servers located in Frankfurt, Germany. You can also host it on your own infrastructure for added control. Learn more about n8n’s security practices here.

How to get started with AITable.ai and Microsoft Excel 365 integration in n8n.io?

To start integrating AITable.ai and Microsoft Excel 365 in n8n, you have different options depending on how you intend to use it: n8n Cloud: hosted solution, no need to install anything. Self-host: recommended method for full-control or customized use cases. Unlike other platforms that charge per operation, step, or task, n8n charges only for full workflow executions. This approach guarantees predictable costs and scalability, no matter the complexity or volume of your workflows.

Back to Integrations

AITable.ai

Microsoft Excel 365

AITable.ai and Microsoft Excel 365 integration

Save yourself the work of writing custom integrations for AITable.ai and Microsoft Excel 365 and use n8n instead. Build adaptable and scalable Data & Storage, and Productivity workflows that work with your technology stack. All within a building experience you will love.

Get started

See n8n in action

How to connect AITable.ai and Microsoft Excel 365

Step 1: Create a new workflow
Step 2: Add and configure nodes
Step 3: Connect
Step 4: Customize and extend your integration
Step 5: Test and activate your workflow

Step 1: Create a new workflow and add the first step

In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.

AITable.ai and Microsoft Excel 365 integration: Create a new workflow and add the first step

Step 2: Add and configure Microsoft Excel 365 and AITable.ai nodes (using the HTTP Request node)

You can find the Microsoft Excel 365 node in the nodes panel and drag it onto your workflow canvas. To add the AITable.ai app to the workflow select the HTTP Request node and use the generic authentication method to make custom API calls to AITable.ai. Configure AITable.ai and Microsoft Excel 365 one by one: input data on the left, parameters in the middle, and output data on the right.

Microsoft Excel 365 and AITable.ai integration: Add and configure Microsoft Excel 365 and AITable.ai nodes

Step 3: Connect Microsoft Excel 365 and AITable.ai

A connection establishes a link between Microsoft Excel 365 and AITable.ai (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.

Microsoft Excel 365 and AITable.ai integration: Connect Microsoft Excel 365 and AITable.ai

Step 4: Customize and extend your Microsoft Excel 365 and AITable.ai integration

Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Microsoft Excel 365 and AITable.ai with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Microsoft Excel 365 and AITable.ai integration: Customize and extend your Microsoft Excel 365 and AITable.ai integration

Step 5: Test and activate your AITable.ai and Microsoft Excel 365 workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from AITable.ai to Microsoft Excel 365 or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.

Microsoft Excel 365 and AITable.ai integration: Test and activate your Microsoft Excel 365 and AITable.ai workflow

Build your own AITable.ai and Microsoft Excel 365 integration

Create custom AITable.ai and Microsoft Excel 365 workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

Supported API Endpoints for AITable.ai

To set up AITable.ai integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to AITable.ai to query the data you need using the API endpoint URLs you provide.

List records

Fetches the list of records from AITable.

GET

/api/get-records

Create record

Creates a new record in AITable.

POST

/api/create-records

Update record

Updates an existing record in AITable.

PUT

/api/update-records

Delete record

Deletes an existing record from AITable.

DELETE

/api/delete-records

Get records

Retrieve a list of records from a datasheet.

GET

/fusion/v1/datasheets/{datasheetId}/records

Delete record

Remove a specific record from a datasheet.

DELETE

/fusion/v1/datasheets/{datasheetId}/records/{recordId}

Create record

Creates a new record in the system.

POST

/api/createRecord

Update records

Updates existing records in the system.

PATCH

/api/updateRecord

Delete records

Deletes records from the system.

DELETE

/api/deleteRecord

Update records

This interface is used to update the records in the specified datasheet.

PATCH

/fusion/v1/datasheets/{datasheetId}/records

These API endpoints were generated using n8n

n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the AITable.ai official documentation to get a full list of all API endpoints and verify the scraped ones!

View workflow

Or explore 800+ other templates here

List fields

Fetches the list of fields in AITable.

GET

/api/get-fields

Create field

Creates a new field in AITable.

POST

/api/create-fields

Delete field

Deletes an existing field from AITable.

DELETE

/api/delete-fields

Get fields

This interface is used to get information about all fields in the specified datasheet that you have permission to view.

GET

/fusion/v1/datasheets/{datasheetId}/fields

Create field

This interface is used to create new fields in the specified datasheet.

POST

/fusion/v1/spaces/{spaceId}/datasheets/{datasheetId}/fields

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

List views

Fetches the list of views in AITable.

GET

/api/get-views

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Create datasheet

Creates a new datasheet in AITable.

POST

/api/create-datasheets

Create datasheet

Create a new datasheet in the system.

POST

/fusion/v1/datasheets

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

List spaces

Fetches the list of spaces in AITable.

GET

/api/get-spaces

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

List nodes

Fetches the list of nodes in AITable.

GET

/api/get-nodes

Search nodes

Searches for nodes in AITable.

GET

/api/search-nodes

Get node details

Retrieve details of a specified node.

GET

/api/get-node-details

Create embedded links

Create links for embedding purposes in nodes.

POST

/api/create-embedlinks

Get embedded links

Retrieve embedded links for nodes.

GET

/api/get-embedlinks

Delete embedded link

Delete a specified embedded link.

DELETE

/api/delete-embedlinks

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get a member

Retrieves details of a specific member.

GET

/api/get-a-member

Update a member

Updates information of a specific member.

PUT

/api/update-a-member

Delete a member

Deletes a specific member from AITable.

DELETE

/api/delete-a-member

List team members

Get a list of members in a specific team.

GET

/fusion/v1/spaces/{spaceId}/teams/{unitId}/members

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get field

Retrieve details about a specific field.

GET

/fusion/v1/fields/{fieldId}

Create field

Add a new field to a datasheet.

POST

/fusion/v1/datasheets/{datasheetId}/fields

Delete field

Remove a specific field from a datasheet.

DELETE

/fusion/v1/datasheets/{datasheetId}/fields/{fieldId}

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get view

Retrieve details about a specific view.

GET

/fusion/v1/views/{viewId}

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Upload attachment

Add an attachment to a record.

POST

/fusion/v1/attachments

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get list of spaces

Retrieve a list of all spaces available.

GET

/fusion/v1/spaces

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get node list

Retrieve a list of nodes within a space.

GET

/fusion/v1/nodes

Create embedded links

Add embedded links to a specific node.

POST

/fusion/v1/nodes/{nodeId}/embedded-links

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Get a member

Retrieve details about a specific member.

GET

/fusion/v1/members/{memberId}

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Create a team

Add a new team to the organization.

POST

/fusion/v1/teams

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Upload attachment

Uploads an attachment to the specified record.

POST

/api/uploadAttachment

Upload attachment

This interface is used to upload an attachment and bind the attachment to a datasheet.

POST

/fusion/v1/datasheets/{datasheetId}/attachments

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Delete record

Deletes a specific record from a datasheet.

DELETE

/fusion/v1/datasheets/{datasheetId}/records

Delete field

This interface is used to delete a specific field from a datasheet.

DELETE

/fusion/v1/spaces/{spaceId}/datasheets/{datasheetId}/fields/{fieldId}

Get view

This interface is used to fetch all views of the specified datasheet.

GET

/fusion/v1/datasheets/{datasheetId}/views

Create datasheet

This interface is used to create a datasheet with the specified fields in the specified space.

POST

/fusion/v1/spaces/{spaceId}/datasheets

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

List roles

Retrieves a list of all roles.

GET

/api/list-roles

List units under the Role

Retrieves the units associated with a specific role.

GET

/api/list-units-under-the-role

Create a role

Creates a new role in the system.

POST

/api/create-a-role

Update a role

Updates an existing role's details.

PUT

/api/update-a-role

Delete a role

Removes a role from the system.

DELETE

/api/delete-a-role

List roles

Retrieve a list of all roles in a space.

GET

/fusion/v1/spaces/spcjXzqVrjaP3/roles?pageSize=2&pageNum=1

These API endpoints were generated using n8n

View workflow

Or explore 800+ other templates here

Microsoft Excel 365 supported actions

Table
Workbook
Sheet

Append

Add rows to the end of the table

Convert to Range

Convert a table to a range

Create

Add a table based on range

Delete

Delete a table

Get Columns

Retrieve a list of table columns

Get Rows

Retrieve a list of table rows

Lookup

Look for rows that match a given value in a column

Add Sheet

Add a new sheet to the workbook

Delete

Delete workbook

Get Many

Get workbooks

Append

Append data to sheet

Append or Update

Append a new row or update the current one if it already exists (upsert)

Clear

Clear sheet

Delete

Delete sheet

Get Many

Get a list of sheets

Get Rows

Retrieve a list of sheet rows

Update

Update rows of a sheet or sheet range

AITable.ai and Microsoft Excel 365 integration details

AI Table is an app that allows you to organize and manage projects and client relationships in a user-friendly spreadsheet format. It provides a database for efficient project management and customer relationship management.

Using generic authentication

See AITable.ai integrations

Related categories

Data & Storage

Microsoft Excel is the most famous spreadsheet tool in the world. It is developed by Microsoft as part of their Office Suite. It is widely used by individuals, professionals, developers, and companies for many uses in statistics, accounting, data analysis, etc.

Microsoft Excel 365 node docs + examples

Microsoft Excel 365 credential docs

See Microsoft Excel 365 integrations

Related categories

Data & Storage

Productivity

Other integrations with Microsoft Excel 365

FAQs

Can AITable.ai connect with Microsoft Excel 365?
Can I use AITable.ai’s API with n8n?
Can I use Microsoft Excel 365’s API with n8n?
Is n8n secure for integrating AITable.ai and Microsoft Excel 365?
How to get started with AITable.ai and Microsoft Excel 365 integration in n8n.io?