# Tutorial: Integrating OpenRefine into Automated ELT Workflows – Looking for Guidance

**URL:** <https://forum.openrefine.org/t/tutorial-integrating-openrefine-into-automated-elt-workflows-looking-for-guidance/2442>\
**Category:** Teaching OpenRefine\
**Created:** [July 27, 2025, 4:35pm UTC](https://forum.openrefine.org/t/tutorial-integrating-openrefine-into-automated-elt-workflows-looking-for-guidance/2442 "2025-07-27T16:35:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Abdelkrim](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/abdelkrim/32/1639_2.png) [@Abdelkrim](https://forum.openrefine.org/u/Abdelkrim)\
**Post date:** [July 27, 2025, 4:35pm UTC](https://forum.openrefine.org/t/tutorial-integrating-openrefine-into-automated-elt-workflows-looking-for-guidance/2442/1 "2025-07-27T16:35:35Z")

</div>

Hi everyone,  
I'm new to **OpenRefine** , but I’ve been working in the **ETL/ELT world** for quite some time.

I'm exploring ways to **integrate OpenRefine into a broader, automated data pipeline** , and I’d really appreciate any pointers or documentation to help with this.

Here's a quick overview of our setup:

1. We collect data from a variety of **IoT devices**.
2. We run **data transformations** to clean and standardize it.
3. We feed the processed data into **dashboards** for analysis and visualization.

What I’d love to know is:  
**Can OpenRefine transformations be automated and executed programmatically** within such a workflow?

Thanks in advance for your insights and any real-world examples or resources you can share!

Best,  
Abdelkrim from Brussels

---

<div class="post-metadata">

**Author:** ![Michael\_Markert](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/michael_markert/32/88_2.png) [@Michael\_Markert](https://forum.openrefine.org/u/Michael_Markert)\
**Post date:** [July 29, 2025, 6:26am UTC](https://forum.openrefine.org/t/tutorial-integrating-openrefine-into-automated-elt-workflows-looking-for-guidance/2442/2 "2025-07-29T06:26:37Z")

</div>

Hi,

you can find the documentation of the API here: [OpenRefine API | OpenRefine](https://openrefine.org/docs/technical-reference/openrefine-api).  
Also, have a look at this Python implementation of the API: [OpenRefine Client](https://pypi.org/project/openrefine-client/).  
To automate edits, you have to have a look at the Undo/Redo tab (Extract...) for the structure of the JSON that is needed to apply operations via the API.

Best,  
Michael