Back to Integrations
integrationMicrosoft Excel 365 node
integrationSolve Data node
HTTP Request

Microsoft Excel 365 and Solve Data integration

Save yourself the work of writing custom integrations for Microsoft Excel 365 and Solve Data 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.

How to connect Microsoft Excel 365 and Solve Data

  • 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.

Microsoft Excel 365 and Solve Data integration: Create a new workflow and add the first step

Step 2: Add and configure Microsoft Excel 365 and Solve Data 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 Solve Data app to the workflow select the HTTP Request node and use the generic authentication method to make custom API calls to Solve Data. Configure Solve Data 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 Solve Data integration: Add and configure Microsoft Excel 365 and Solve Data nodes

Step 3: Connect Microsoft Excel 365 and Solve Data

A connection establishes a link between Microsoft Excel 365 and Solve Data (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 Solve Data integration: Connect Microsoft Excel 365 and Solve Data

Step 4: Customize and extend your Microsoft Excel 365 and Solve Data 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 Solve Data with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.

Microsoft Excel 365 and Solve Data integration: Customize and extend your Microsoft Excel 365 and Solve Data integration

Step 5: Test and activate your Microsoft Excel 365 and Solve Data workflow

Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Microsoft Excel 365 to Solve Data 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 Solve Data integration: Test and activate your Microsoft Excel 365 and Solve Data workflow

Build your own Microsoft Excel 365 and Solve Data integration

Create custom Microsoft Excel 365 and Solve Data 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.

Microsoft Excel 365 supported actions

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

Supported API Endpoints for Solve Data

To set up Solve Data 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 Solve Data to query the data you need using the API endpoint URLs you provide.

List orders
Retrieve a list of orders.
GET
/latest/api/orders
Process order
Processes an order that has been created.
POST
/latest/api/event-schemas/order-processed
Cancel order
Cancels an existing order.
DELETE
/latest/api/event-schemas/order-canceled
Return order
Processes a returned order.
POST
/latest/api/event-schemas/order-returned
Fulfill order
Marks an order as fulfilled.
POST
/latest/api/event-schemas/order-fulfillment-delivered
Fail order fulfillment
Marks an order fulfillment as failed.
POST
/latest/api/event-schemas/order-fulfillment-failed
Check order fulfillment status
Checks the fulfillment status of an order.
GET
/latest/api/event-schemas/order-fulfillment-in-transit
Get payment status
Retrieves the payment status for an order.
GET
/latest/api/event-schemas/order-payment-paid

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List carts
Retrieve a list of shopping carts.
GET
/latest/api/carts
Add item to cart
Adds an item to the shopping cart.
POST
/latest/api/event-schemas/cart-item-added
Remove item from cart
Removes an item from the shopping cart.
DELETE
/latest/api/event-schemas/cart-item-removed

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List returns
Retrieve a list of returns.
GET
/latest/api/returns

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List payments
Retrieve a list of payments.
GET
/latest/api/payments

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List subscriptions
Retrieve a list of subscriptions.
GET
/latest/api/subscriptions

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List products
Retrieve a list of products.
GET
/latest/api/products

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List webhooks
Retrieve a list of webhooks.
GET
/latest/api/webhooks

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List events
Retrieve a list of events.
GET
/latest/api/events
Track email open
Tracks when an email is opened.
POST
/latest/api/event-schemas/email-open
Queue event
Queue an event using the event input data.
POST
/latest/api/events

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List event schemas
Retrieve a list of event schemas.
GET
/latest/api/event-schemas

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Merge attributes
Merge various attributes for specified entities.
POST
/latest/api/attribute-merging

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Handle cart abandoned event
Handle an event when a cart is abandoned.
POST
/latest/api/event-schemas/cart-abandoned

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Create an order
Create a new order.
POST
/latest/api/event-schemas/order-created

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Create a return
Create a new return for an item.
POST
/latest/api/event-schemas/return-created

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Delete an order
Delete an existing order.
DELETE
/latest/api/event-schemas/order-deleted

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Delete a return
Delete an existing return.
DELETE
/latest/api/event-schemas/return-deleted

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Perform search
Executes a search query.
GET
/latest/api/event-schemas/search

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

List profiles
Retrieve the most recent profiles based on activity.
POST
/graphql

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Create API Key
Create a new API Key via the GraphQL API.
POST
/latest/api/authentication#create_api_key
List API keys
Returns all API keys as a connection object.
GET
/api_keys
Create API key
Creates a new API key record and returns the created key.
POST
/create_api_key
Update API key
Updates an existing API key record referenced by its id.
PUT
/update_api_key
Disable API key
Disables an existing API key record as referenced by its id.
PUT
/disable_api_key
Enable API key
Restores a currently archived API key record as referenced by its id.
PUT
/enable_api_key

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

Create API Key
Generates a new protected API key with a specified name.
POST
/auth/create_api_key
Update API Key
Updates the name and notes of an existing API key.
PUT
/auth/update_api_key
Disable API Key
Disables an existing API key, preventing its use.
POST
/auth/disable_api_key
Enable API Key
Enables a previously disabled API key, allowing its use again.
POST
/auth/enable_api_key
Get Token
Gets an access token for a public API key using Basic authentication.
POST
/auth/get_token

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 Solve Data official documentation to get a full list of all API endpoints and verify the scraped ones!

FAQs

  • Can Microsoft Excel 365 connect with Solve Data?

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

  • Can I use Solve Data’s API with n8n?

  • Is n8n secure for integrating Microsoft Excel 365 and Solve Data?

  • How to get started with Microsoft Excel 365 and Solve Data integration in n8n.io?

Looking to integrate Microsoft Excel 365 and Solve Data in your company?

Over 3000 companies switch to n8n every single week

Why use n8n to integrate Microsoft Excel 365 with Solve Data

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon