API Sandbox & Documentation

Direct REST APIs to receive JSON invoice records and automatically sync or upsert them into Google Sheets.

Google Sheets API v4 Connected

Target Sheet: SalesInvoice

Matching Key: Firm Name + Invoice No. + FY

Auth: Bearer Token

POST API Request Runner

Select Endpoint

Bearer Token (Required for Authorization)

JSON Request Body

Live Response

Full Request URL

Response JSON

Click "Send Request" to test the API...

34-Column Google Sheet Schema

Mapped directly to Google Sheet SalesInvoice tab. Upsert matches on Firm Name + Invoice No. + FY.

#	Google Sheet Header	Recommended JSON Key	Supported Aliases	Description

Ready-to-use integration code in cURL, JavaScript, PHP, and Python.