Data flow from R to Metabase to Google Docs: a live-connected reporting workflow

Building live-connected reporting pipelines: We develop tools that stream data from R through Metabase directly into Google Docs for automated updates.

Open SourceAutomationWeb Development SurveyProcess

Status: Finished
Project Period: October 2022 – March 2023
Outputs: Code Repository Code Repository Documentation
Partner: Anonymous Organization

A project with an anoymous organization.

The project developed two key components to automate and scale data workflows:

DataToMetabase: A set of R tools designed to automate the (pre-)curation of a Metabase instance by leveraging the Metabase API. The goal was to reduce manual effort in tasks such as creating tables and queries, thereby improving scalability and efficiency in data management.
metabase-to-google: A solution connecting Metabase with Google Spreadsheets, enabling automated (pre-)curation of Google Sheets from Metabase dashboards and saved queries (cards). This component utilized the Metabase API, Google Apps Script, and Google APIs (e.g., Sheets API) to bridge the two platforms.

Though prototypical, the project demonstrated the feasibility of building data pipelines outside traditional technical stacks. This approach empowers less technical users to leverage automation and reproducibility in environments like Google Workspace, expanding accessibility to data-driven workflows.

CorrelAid Team

Konrad Wölms