Apipheny Appsumo: Apipheny is also equipped with advanced features, such as the ability to create API requests based on a cell value and call API requests in spreadsheets. Moreover you can integrate your spreadsheets with Google Data Studio and other free data visualization tools and create rich enterprise-grade visualizations of your API data.
Apipheny is the only tool you need to do just that. Simply enter your API URL address, basic parameters and headers into the add-on, and then click That’s it! No need to write any code.
I have a client who needed to create a report in Data Studio for their CRM. The CRM had an API and I was able to import the data into google sheets without any problems. I was then able to connect that sheet to Google Data Studio.