Skip to main content
Glama

sheet_to_json

Convert Google Sheets data into JSON format using column headers as keys. Extract structured records from spreadsheets for integration with other systems.

Instructions

Convert a Google Sheets tab into JSON records using the header row.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
spreadsheet_id_or_urlYes
sheet_nameYes
header_rowNo
start_rowNo
end_rowNo

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/NgoQuocViet2001/google-workspace-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server