sssapi.app

What It Is

SSSAPI is an API service for Google スプレッドシート（Google Sheets）: enter a spreadsheet URL and generate a read-only JSON API with no coding required. It emphasizes “no server, no code,” making it suitable for using spreadsheets as a lightweight data source while allowing non-engineering team members to maintain data through a familiar spreadsheet interface.

Core Features and Ecosystem

Functionally, SSSAPI does more than simply convert spreadsheets into JSON. It supports list endpoints, fetching a single record by the value in column A, converting fields with the same name into arrays, generating nested objects from dot-notation fields, as well as common query capabilities such as pagination, filtering, array filtering, sorting, and descending order across multiple fields. On the security side, the service is positioned as a read-only API and supports domain and access key restrictions. It also states that broad permissions such as Google Drive access are not required. The ecosystem mentioned in the article includes Google Forms, Firebase/Firestore, GitHub Actions, Flutter, WordPress, and more, mainly as use cases or integrations covered in related articles.

Pricing

Pricing is very lightweight: Free includes 3 APIs, 50 rows per API, 2 members, and unlimited requests; Standard costs 280 yen/month before tax and increases the limits to 60 APIs, 300 rows per API, and 5 members; Premium costs 900 yen/month before tax and supports 600 APIs, 5000 rows per API, and 10 members. Annual billing saves about 1 month. For individuals and small teams, it offers good value, though the row and member limits mean it is better suited to small and medium-scale read-only data use cases.

Pros, Cons, and Best Fit

Its strengths are fast onboarding, low pricing, friendly collaboration for non-engineers, and more complete query capabilities than a basic spreadsheet-to-JSON tool. Compared with writing your own Google Apps Script, it also has lower maintenance overhead. The drawbacks are that the article does not clarify whether it is open source, supports self-hosting, provides an SLA, offers enterprise support, or what payment methods are available. It is also a read-only API, so it is not suitable for backend systems that require complex writes, authentication workflows, or transactional logic. It is especially suitable for prototyping, API mocks, master data, website announcements, configuration, multilingual copy, education, or introductory IoT demos.

Access from China

For use in mainland China, there are two layers of dependency to consider: the article does not specify the accessibility of SSSAPI itself, but the data source depends on Google Sheets, and Google services are generally restricted in mainland China. Overall, it should therefore be considered “partially restricted.” If your team mainly deploys in a domestic China environment, you may want to consider a self-built backend, Firestore alternatives, domestic spreadsheet/low-code platforms, or a Headless CMS that is reliably accessible from within China.