Accessing our customized spreadsheets via Google Sheets API

Introduction

Our customized spreadsheets are hosted on Google Sheets and can be accessed through Google's APIs, ensuring a seamless and efficient user experience.

Authentication

Authentication Method: Service Accounts

API Key

Base URL
https://sheets.googleapis.com/v4/spreadsheets/

Endpoint

https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{sheetName}!{range}?key={API_KEY}

Response Example (json)

{

“range”: “Sheet1!A1:D10”,
“values”: [
[“Product”, “Price”, “Quantity”, “Total”],
[“Apple”, “1.00”, “10”, “10.00”],
[“Banana”, “0.50”, “20”, “10.00”]
]
}

OpenAPI (Swagger) 
Below, you will find the API description available in both JSON and YAML formats for your reference.

You may easily read the API description using OpenAPI tools, such as Swagger Editor.

To obtain an API key for testing, please send a request via email to
amangenot@emergingtextiles.info