Fetching, Filtering, and Sorting JSON APIs in Google Sheets: The Missing Functions Do you need to fetch, filter, and sort JSON Web APIs in Google Sheets? This tutorial describes how you can add some functions to supplement the built-in Sheets functions and accomplish the goal with ease.