I am wanting to create dashboards to represent my data from Airtable, using Google Looker Studio. What is the best way to get my data from Airtable into Looker Studio automatically? I have tried using the 3rd party Airtable Connectors offered on Google Looker Studio, but I keep getting an error where access is automatically revoked by Airtable due to "security concerns". I have looked at the 3rd party integrations on Airtable and all seems fine there in terms of permissions.
Using the Google sheets sync function won't work as my datasets are too large. And I am not too great at working with APIs either. And the Interface provided in Airtable is not an option.