csv, and submit your query. Following the successful response you can copy the request URL that shows up. It should look like the following request, but with your own API key.
%22in this demo if you don't end up using the OpenAPI.
IMPORTDATAGoogle Sheet formula. Below is an example of this usage.