Skip to content
Book a demo
Open the menu Close the menu
Call us 06 59 01 09 31 Book a demo

Import a table pasted in an email, one row per line

Partners often paste a price list or stock table in the body of an email. The AI turns it into clean lines, the workflow loops over them, extracts SKU, label, quantity and unit price of each and inserts one row per line in your table (columns: sku, label, quantity, unit_price, source). A Slack or Teams message tells you when it is done.

By
Loop & Roll team · Official
Copied
0 times
Steps
6
Version
1 · 18 October 2026
Requires
Loop & Roll 1.0.0 or later

Workflow graph

Import a table pasted in an email, one row per line Hover a node to see its role · Drag to move the graph
For each item of “For each line”Email with a pasted table — Email receivedEmail with a pasted t…Email receivedTurn the table into lines — Free instruction (AI)Turn the table into lin…Free instruction (AI)ModelFor each line — LoopFor each lineLoopfor eachdoneRead the line — ExtractRead the lineExtractModelInsert the row — Table — insert a rowInsert the rowTable — insert a rowTell the team — NotifyTell the teamNotifyOpenAI — OpenAI (GPT)OpenAIgpt-5-mini
Import a table pasted in an email, one row per line

How it works

  1. 1

    Email with a pasted table

    trigger.email

  2. 2

    Turn the table into lines

    ai.prompt

  3. 3

    For each line

    flow.loop

  4. 4

    Read the line

    ai.extract

  5. 5

    Insert the row

    table.insert

  6. 6

    Tell the team

    notify.send

What you will fill in after import

Nothing personal travels with a template: connections, mailboxes, tables and recipients are left blank for you to pick in your instance.

Tables to choose
Insert the row · table
Connections to choose
OpenAI · connection (llm_provider)
Secrets to fill in
Tell the team · webhookUrl

See also

More in Data extraction

All templates