Sort a data range by one or more columns and apply a basic filter (with per-column sort/hide criteria) to a Google Sheet.

Documented steps

1. POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate using OAuth scope https://www.googleapis.com/auth/spreadsheets.
2. Add requests[0].sortRange.range = GridRange over the rows to reorder; SortRangeRequest's only fields are range and sortSpecs — there is no header-row concept, so start the range one row after any header (e.g. startRowIndex:1) or the header will be sorted as data.
3. Set requests[0].sortRange.sortSpecs = [{dimensionIndex, sortOrder:"ASCENDING"|"DESCENDING"}, ...] — multiple specs sort by the first entry, breaking ties with subsequent entries.
4. Separately, add requests[1].setBasicFilter.filter.range = GridRange for the filtered table.
5. Optionally set filter.sortSpecs[] (same {dimensionIndex, sortOrder} shape as SortRange) to sort within the filter, and filter.criteria = {"<columnIndex>": {hiddenValues:[...]}} or {"<columnIndex>": {condition:{type, values}}} to hide rows by value or condition.
6. Docs: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request | https://developers.google.com/workspace/sheets/api/samples/data | https://developers.google.com/workspace/sheets/api/guides/filters