Google Sheets How to Make a Table in Google Sheets — Three Easy Ways How to make Tables in Google Sheets that work like tables in Microsoft Excel — look great, easy to filter, and easy to query.
Google Sheets How to use Google Sheets as JSON database back-end (an easy way) How to use Google Sheets as a database back-end that produces JSON for your web applications
Google Sheets How to create Dynamic Arrays in Google Sheets with Concatenate, Split and Transpose A few Dynamic Array and Dynamic Table examples in Google Sheets using arrayformula, concatenate, split, and transpose.
Google Sheets XLOOKUP in Google Sheets: Equivalents and Alternatives XLOOKUP alternatives and equivalents in Google Sheets - Filter, Query, and Index(Match).
Google Sheets Build An Entire API in Google Sheets and Google Apps Script How to build a whole API in Google Sheets, sourcing data from a Google sheet you write, and retrieving it via HTTP Get.