Skip to main content

Call Sheet Best from n8n

Sheet Best is a standard REST API, so any n8n workflow can talk to it through the built-in HTTP Request node — no custom node or community package required. The examples below show the common request shapes; how you wire them into a workflow is up to you.

Before you start​

  • A Sheet Best connection. See the quickstart for how to create one.
  • Your connection URL, in the form https://api.sheetbest.com/sheets/<id>.
  • An API key only if your connection is protected. See API key authentication.

Reading rows (GET)​

Configure an HTTP Request node with method GET and your connection URL. The response is an array of row objects keyed by your sheet's column headers.

GET https://api.sheetbest.com/sheets/<id>

By default values are returned as strings. Add ?_raw=1 to get native JSON types. See formats.

Writing rows (POST)​

Set the method to POST, the URL to your connection URL, and send a JSON body. Sheet Best accepts either a single object or an array of objects (one row per element).

[
  { "Name": "Jane", "Email": "jane@example.com" },
  { "Name": "John", "Email": "john@example.com" }
]

Make sure the node sends the body as JSON (Content-Type: application/json). Column names in the body must match the headers in your sheet.

Authenticating​

If your Sheet Best connection requires a key, add an X-Api-Key header to the HTTP Request node:

X-Api-Key: <your-key>

You can store the key in n8n credentials or environment variables and reference it from the header field. See API key authentication for details.

Updating and deleting rows​

The same pattern applies to other verbs:

Target a specific row by including a column match in the URL, for example PATCH /sheets/<id>/Email/jane@example.com.

Next steps​