I used to connect Airtable with Looker Studio by using a Google Sheet and Make.com to update the sheet from Airtable. I’ve noticed that there is now a connector available to link Airtable directly to Looker Studio via Make.com. However, I haven’t found any pre-built scenarios or tutorials that explain how to do this. Do you have any ideas?
Hi @Pascal,
There seem to be no pre-built templates in Make. Luckily, Make is very intuitive. I prompt you to create a scenario and test. If need be, we can help you if you get stuck.
Please, follow these steps when asking a question, and you’ll be more likely to get a helpful answer:
Give us a detailed explanation of what you’re trying to achieve
Tell us about any steps you’ve tried so far
Include screenshots of:
-
your scenario flow and setup (functions, mappings, variables, etc.)
-
module configurations and outputs
-
any error messages you are getting
Share the blueprint of the scenario you are asking a question about. (this does not contain any connection or personal information)
Henk
Certified Make Expert and Partner
Book a consult with me
1 Like
Thanks, Henk, for your help.
I am trying to pull data concerning class placement for 410 students. This data includes checkboxes (student in learning support, high achiever, etc.), date of birth, language selected in the curriculum, etc.
I have been able to create a scenario to pull the gender for 410 students, but when using the data in looker studio, I have an error message:
blueprint.json (32.3 KB)
Hey Pascal, where you able to solve this issue? I’m having the same problem!
I have not, I ma using this : Airtable Data Studio connector – TheDataStudents and pay the license.
You can try to connect Looker Studio to a google sheet and then use make.com to add all the info. This way you can avoid paying for the license. I’m attaching a youtube example:
By the way you should defenitely use the bulk add rows to lower operation consumptions:
Hope it helps!
I use in the past Google sheet. However, the scenario is more complex to create as if you delete a value in one cell in airtable it does not update automatically in Google sheet. My database is always evolving and it is just too much to handle. But it’s true it works well with Google sheet too.