Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable ➡️ Google Cloud Storage (.csv) ➡️ Google Data Studio [Help!]

Topic Labels: API
1565 1
cancel
Showing results for 
Search instead for 
Did you mean: 
VictoriaPlummer
7 - App Architect
7 - App Architect

Hey Y’all,

Is anyone familiar with Google Data Studio?

Context:

  • I’m playing with an idea of archiving data from Airtable.

  • To do that, I’m routinely exporting the JSON output from the API, and appending a CSV in Google Cloud Storage.

  • I’m using that CSV to create a report in Google Data Studio.

Problem:

  • I’m at a loss of how to leverage Linked Records in visualizations, which output from the API as an array of Record IDs.

  • Currently, Data Studio only sees them as strings.

Questions:

  • What are my options for replicating many-to-many linked record relationships in Google Data Studio? Will I need to load my data into Big Query first?
  • If so, what are some best practices/suggestions for working with Big Query I can leverage? Links are much appreciated!

Thanks in advance!

1 Reply 1

All the linked records must be duplicated to separate column as formula (as easy as reference the column). By doing that, the data is stored as text.