Struggling to pull from API google sheets correctly

Yes, see my JSON API tutorial video here: API JSON Tutorial (Video)