Vini’s Google Sheets API Wrapper

Welcome to the worst API documentation ever!

I created this wrapper to simplify how students use the Google Sheets API.

Endpoints

Use the endpoints below to send a GET request:

Reading from a Google Sheet

Each call gets all rows and values of the specified range

Parameters:

• id (Google Sheets ID)
• range (Tab name or range of cells)
• format (How you want the data to be structured)
  • array-of-objects (My API’s default)
  • array-of-arrays (Google Sheets API’s default)
  • object-of-objects (Using first column as keys)

Example:

https://sheets.vsueiro.com/api/read?id=GoogleSheetsID&range=TabNameOrRange

Writing to a Google Sheet

Each call appends a new row to the Google Sheet, with the value(s) of the “row” param

Parameters:

• id (Google Sheets ID)
• range (Tab name or range of cells)
• row (Array of values, encoded as JSON)

Example:

https://sheets.vsueiro.com/api/write?id=GoogleSheetsID&range=TabNameOrRange&row=["Abc",123]

The above example would create a new row with 2 cells (filled with "Abc" and 123)

⚠️ Disclaimer

This API only works with a few magic* spreadsheets. You need to share your spreadsheet with an email address that Google Cloud has automatically created for you. This email should have editor privilege.