Integration

Connect API Ninjas with Excel

Read and write Excel workbooks stored in OneDrive for Business / SharePoint via Microsoft Graph — add and read table rows, get/update cell ranges, manage worksheets, tables, charts, and sort data. Operates on a workbook file (.xlsx) identified by its DriveItem id. Delegated (on-behalf-of-signed-in-user) only.

Create this Automation Browse Workflows

Triggers and actions

What API Ninjas and Excel
bring to a workflow

Triggers are the events in API Ninjas that start a workflow. Actions are the steps it runs in Excel.

API Ninjas

Trigger app

Fetch facts, quotes, and current weather from API Ninjas.

How it works

API Ninjas and Excel,
working together.

Three steps run automatically, every time.

API Ninjas detects a new event
Something happens in API Ninjas and the workflow is triggered automatically.
Your workflow runs
WorksBuddy instantly connects API Ninjas to Excel no code, no manual steps.

Automate
API Ninjas and Excel today

Put the two apps on autopilot with WorksBuddy no code, ready in minutes.

Excel

Actions

Add Chart
Adds a chart to a worksheet from a source-data range. Returns 200 OK.
Add Row to Table
Adds one or more rows to the end of an Excel table (or at a given index). values is a 2-D array; each inner array is one row matching the table’s columns. Returns 200 OK.
Add Table Column
Adds a column to a table. values is a 2-D array (header row first), index sets the position. Returns 200 OK.
Add Worksheet
Adds a new worksheet to the end of the workbook with an optional name. Returns 201 Created.
Create Workbook Session
Creates a workbook session and returns a session id to pass as the Workbook-Session-Id header on subsequent calls. persistChanges=true saves edits to the file; false keeps them in a temporary server copy. Returns 201 Created. Not supported for personal Microsoft accounts.

Connect API Ninjas with Excel

What API Ninjas and Excel
bring to a workflow

API Ninjas

API Ninjas and Excel,
working together.

API Ninjas detects a new event

Your workflow runs

Automate
API Ninjas and Excel today

More triggers are on the way

Excel

Add Chart

Add Row to Table

Add Table Column

Add Worksheet

Create Workbook Session

Excel performs Add Chart

Connect API Ninjas with Excel

What API Ninjas and Excel bring to a workflow

API Ninjas

API Ninjas and Excel, working together.

API Ninjas detects a new event

Your workflow runs

Automate API Ninjas and Excel today

More triggers are on the way

Excel

Add Chart

Add Row to Table

Add Table Column

Add Worksheet

Create Workbook Session

Excel performs Add Chart

What API Ninjas and Excel
bring to a workflow

API Ninjas and Excel,
working together.

Automate
API Ninjas and Excel today