API to Google Sheet without 'API Connector Pro'

Welcome back to the community, @Chris123! If your project does not have the repeat groups, you could do it as outlined in the support article shared earlier:

Or you could use this approach to load your data to google data studio: