Skip to main content
Get up and running with Sheet Ninja in just a few minutes.
By the end of this guide, you’ll have a Google Sheet connected to Sheet Ninja and accessible via an API endpoint.

​
Prerequisites

Before you begin, make sure you have:
  • A Google Sheets workbook containing data you’d like to turn into an API
  • Column headers defined in the first row
Example:
idnameemailstatus
1Janejane@example.comactive
2Johnjohn@example.cominactive
  • The first row defines your schema
  • Each row represents a record

​
3 Simple Steps

1

Connect your Google account

Sheet Ninja needs permission to access your Google Sheets in order to read and write data.
  1. Click Sign In in the top-right corner
  2. Select the Google account you want to use
  3. Approve the requested permissions
Once connected, Sheet Ninja will be able to list and access your spreadsheets.
2

Create a project

A project links a Google Sheets workbook to Sheet Ninja.
  1. Sign in to your Sheet Ninja dashboard
  2. Paste your Google Sheets URL into the input field
  3. Click Preview to confirm you’ve selected the correct workbook
  4. Click Add Project
Your workbook is now connected and ready to use.
3

Create your first endpoint

Now let’s turn your sheet into an API endpoint.
  1. Open your project in the Sheet Ninja dashboard
  2. Select the sheet (tab) you want to expose
  3. Enable the desired endpoints using the toggle controls
  4. Copy your endpoint URL and start building. E.g.
https://api.sheetninja.io/98174693c7d743418d5dc614b6927270/workbook/sheet
  1. If required, configure access rules in the Authentication tab
That’s it — your Google Sheet is now accessible via an API 🎉

​
What’s next?

  • Secure your endpoints with authentication
  • Explore available API methods and query options
  • Build automations and integrations on top of your data
Head to the API Reference to see everything you can do with your new endpoint.