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

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 Like

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.