A common use case for Retool Workflows is to automate ETL tasks. Retool apps can query data from a variety of sources but it's much more efficient to prepare data outside of the frontend application.
This tutorial explains how to build an ETL workflow that:
- Upserts the transformed data into a PostgreSQL database.
- Reads behavioral event data from a Google Sheet.
- Aggregates event data at an account level.
- Upserts aggregate event counts into a PostgreSQL database alongside account data.
The transformed data is then available to all Retool apps without the need for complex queries that run every time the app launches.