Posts tagged #reference

2 posts

Jun 6, 20262 min read

Paginate, search, and sort Google Sheets data over REST

Learn how to paginate, search, sort, and shape Google Sheets data over REST with GKit SheetsAPI query params - limit, offset, search, search_exact, sort, fields, and format - with real URL examples.

Jun 4, 20263 min read

JSON, CSV, TSV, XML, and JSONP output from a Google Sheet

GKit SheetsAPI can return your Google Sheet as JSON, CSV, TSV, XML, or JSONP. Learn how the format query param works, see a real request for each, and pick the right format for BI tools, browsers, and legacy cross-origin scripts.