I've been looking for an alternative to import my ad platform data directly to Google Sheets and KPI Bees turned out to be the best option for this at a really great price. I tried a few similar costed apps and none of them were pulling through JSON request data from the FB API correctly. I tried it on KPI Bees and it immediately pulled the data through the way I needed it to,

Thoroughly recommend to anyone looking to do small to medium business API data queries in Google Sheets. Especially helpful for updating dashboards in Data Studio.