Frequently Asked Questions
Quick answers about using sheet2api. See the documentation for the full setup and request guide.
Create and find an API
How do I create my first API and find its endpoint?
- Format the first row of each worksheet as column names.
- Give sheet2api access to the Google Sheet or Excel Online workbook.
- Open Create Spreadsheet API, paste the spreadsheet link, and select Create.
- On Your Spreadsheets, copy the API URL or open Go to JSON API Docs for generated examples.
The URL contains your account ID and API name. A worksheet name is added for that tab. The default URL reads the first worksheet.
Does each worksheet get its own API?
Each worksheet has its own resource endpoint under the same Spreadsheet API. Use the generated API docs to copy a worksheet URL. Tabs do not get separate credentials or provider permissions.
Is the API URL an API key?
No. The URL identifies the API endpoint; it is not a secret. REST authorization is optional and uses HTTP Basic Authentication credentials when enabled in Configure API.
Connect and share
Which spreadsheet formats are supported?
Connect a Google Sheet or an Excel Online workbook. Local Excel files, CSV uploads and Microsoft SharePoint links are not direct connections. Put the first row of each tab in column names, and avoid duplicate column names.
If an ID must retain leading zeroes, format it as text in the spreadsheet and check the API response.
How do I connect a private Google Sheet?
Open the sharing instructions in the documentation and share the sheet with the Google address shown there. Signing in to sheet2api with Google alone does not grant access to the private sheet.
Can I keep a Google Sheet private?
Yes. Share a private sheet with the sheet2api Google address shown in the docs instead of enabling public-link access. Anyone who can call an unauthenticated API can see the rows returned by its enabled endpoints, so secure the API as well.
How do I connect an Excel Online workbook?
Sign in to sheet2api with the Microsoft account that can access the workbook, grant the requested permissions, and paste its Excel Online link when creating the API. See the Excel connection steps.
Why was my Excel API paused, and how do I reconnect?
Microsoft can reject an expired or revoked refresh token. When that happens, sheet2api pauses the affected API and emails its owner once with a link to sign in again. After Microsoft reauthorization, APIs paused for that auth failure are enabled again. APIs you had manually disabled stay disabled.
Can I set different access permissions for each tab?
No. Worksheet endpoints are separate routes, but Google and Excel sharing permissions apply to the spreadsheet or workbook. Sheet2API authorization and operation controls apply to the Spreadsheet API, not to individual tabs. Do not use a tab name as a privacy boundary.
Why does sheet2api say it cannot access my spreadsheet?
Check that the URL is for a Google Sheet or Excel Online workbook, that the correct Google address or Microsoft account has access, and that the workbook still exists. For Excel, reconnect if sheet2api emailed you a reauthorization link. If access still fails, email support with the error message.
Requests and errors
How do I read or filter rows?
A GET returns a JSON array of row objects. Add
a query parameter whose name matches a column,
for example
?Status=Open&limit=10.
Several filters use AND by default; add
query_type=or to match any
filter. See the generated API docs for
wildcard and numeric comparison examples.
limit bounds the rows returned.
The REST API does not provide page numbers or
an offset parameter.
How do POST, PUT and PATCH differ?
POST appends one JSON object as a
row. PATCH updates the fields you
send on rows matched by the URL filters.
PUT replaces the matched rows;
fields omitted from the object are cleared.
Use a specific filter before updating, and
check the generated API docs for a copy-ready
request.
What does “Invalid new row data” mean?
The row must be a JSON object, and each key
must match a column name in the first row of
the worksheet. Check the JSON syntax, use
Content-Type: application/json,
and compare the keys with the generated API
documentation. A repeated POST appends another
row; check for duplicates before retrying a
request whose result is unknown.
Why do I get 402 or 429?
Plans and account
Where can I check my plan and usage?
Usage shows your API count and monthly API request total, with per-API usage history. It does not show a daily usage chart. View available features and current prices on the pricing page.
How do I manage or cancel a subscription?
Open Account > Plan and select Manage subscription. The available actions depend on the billing portal configuration. If you cannot find the cancellation option, email support for help.
What is the refund policy, and how do I get account help?
The Terms state that subscription fees may be refunded on request within 30 days of purchase. For refunds, account changes, or help with a subscription, email [email protected].
Security and integrations
Can anyone see or change data through my API?
New APIs allow Read, Create, Update and Delete by default, and authorization starts off. Anyone who can reach an unauthenticated API can use the enabled operations. In Configure API, enable HTTP Basic Authentication and disable operations callers should not use. Keep credentials on your server, not in public browser code. See security guidance.
Can I connect a website, Python, JavaScript or an AI assistant?
Yes. Use the REST endpoints from an HTTP client, including Python and JavaScript. Sheet2API also provides an MCP server for compatible AI assistants, plus dashboard examples for an embeddable table and a website form. See the docs and the generated API examples.
Does sheet2api send calendar events or messages to other services?
Sheet2API exposes spreadsheet data through REST and MCP APIs. Your app or automation service must handle workflows such as creating calendar events, sending messages, or calling another service. Sheet2API does not provide those workflows itself.
Where can I get more help?
Read the documentation, use the generated docs on your dashboard, or email [email protected].