#dataanalytics #googledatastudio #bigquery #airtable
The javascript code mentioned can be found in the links below.
I demonstrate how to get data from Airtable and report on it in Google Data Studio. This is done by extracting Airtable data into Google Sheets using Google Apps Script.
Then we use Big Query to transform the data and prepare it for our dashboard in Google Data Studio.
Chapters:
02:35 Pulling Airtable Data Airtable - Google Apps Scripts
11:44 Prepare/transform data in Big Query
25:26 Report/Dashboard set up in Google Data Studio
Links:
Javascript for Airtable to Google Sheets
https://drive.google.com/file/d/1gRTlOaYzBkPWyXP9Ghh8bvJ-lAzEr8y4/view?usp=sharing
Arrogant Sage Media showcases technology, tools, and strategies across various disciplines. Please subscribe, share, like, and comment.
My Songwriter/Official Artists Channel is here:
https://www.youtube.com/channel/UCGjN7Q1I1PJHDNCGPkTZaSA
