# Extracting line items **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [February 8, 2025, 12:29pm UTC](https://community.glideapps.com/t/extracting-line-items/79908 "2025-02-08T12:29:17Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Mikaeldorval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikaeldorval/32/67405_2.png) [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Post date:** [February 8, 2025, 12:29pm UTC](https://community.glideapps.com/t/extracting-line-items/79908/1 "2025-02-08T12:29:17Z")
What would be the best way to extract line items from an invoice using a workflow? I need to extract multiple data points from an invoice line item and add a row for each line item. I’m used to using the iterator in Make along with other JSON modules but I’m just now starting to use Glide workflows and can’t figure it out. Thanks! ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 1:07pm UTC](https://community.glideapps.com/t/extracting-line-items/79908/2 "2025-02-08T13:07:17Z")
You have multiple options here. One of the solution you have is to use the AI actions to extract data from document (document to text), also called Optical Character Recognition (OCR). Create another action/column (Text to JSON) to convert the text to JSON with your instructions (structure you want in the JSON). To add multiple rows for each items, you can use either the mutations method with Glide API or use the new Glide webhook triggered workflow by using loop. ---
**Author:** ![Mikaeldorval](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikaeldorval/32/67405_2.png) [@Mikaeldorval](https://community.glideapps.com/u/Mikaeldorval)\ **Post date:** [February 8, 2025, 1:31pm UTC](https://community.glideapps.com/t/extracting-line-items/79908/3 "2025-02-08T13:31:43Z")
That last part gives me trouble. How do I add multiple rows from a JSON webhook? How do I iterate trough it? ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 6:39pm UTC](https://community.glideapps.com/t/extracting-line-items/79908/4 "2025-02-08T18:39:16Z")
You can follow my guide here: > [@Bulk Edit Column Values Across Multiple Rows in Glide with User-Specific Column Compatibility](https://community.glideapps.com/t/bulk-edit-column-values-across-multiple-rows-in-glide-with-user-specific-column-compatibility/77644): > > I implemented a feature that allows you to edit values across an entire column, similar to the solution discussed [here](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546), but using the official Glide API in a compliant manner. For this example, I configured a choice component that enables you to select the rows you wish to edit. There’s a button that allows you to select all rows or clear your selections. This flexibility lets you choose whichever rows you need to update. Once you’ve made your selections, you can set a new value for a specific … ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 8, 2025, 6:39pm UTC](https://community.glideapps.com/t/extracting-line-items/79908/5 "2025-02-08T18:39:31Z")
No sorry, you want to add rows. Here is the right guide: > [@mortar\_board Glide Tutorial - Add, Edit or Delete Multiple Rows (Using Glide's API)](https://community.glideapps.com/t/glide-tutorial-add-edit-or-delete-multiple-rows-using-glides-api/65138): > > [[🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)] ](https://www.youtube.com/watch?v=b7_k3_brusQ) What’s up Gliders! Glide’s new native API functionality has unlocked a ton of power exploding_head I’ve always wanted the ability to natively add, edit, or delete multiple rows without needing Make/Zapier… And after seeing a quick loom from @Darren_Murphy I was reminded that this is now possible handshake In this video I explain: How to add a predefined list of tasks to a new project. How to delete any task…