Use “Add rows to a spreadsheet table” in Recued. Append one or more rows to a named Excel table in a single approval, keeping its formulas and formatting intact. Actions that change data use Recued's approval controls.
Add rows to a spreadsheet table
Use “Add rows to a spreadsheet table” in Recued. Append one or more rows to a named Excel table in a single approval, keeping its formulas and formatting intact. Actions that change data use Recued's approval controls.
Complete workflow
Excel Workbook Desk
5 pinned recipes
Use Excel Workbook Desk in Recued for spreadsheets, tables, and trackers. Find a workbook by name, ask questions about a sheet, look up rows the way you would in a database, and add rows to a table. It includes 5 ready-to-run workflows, and the one that changes data uses Recued's approval controls.
You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.
Use “Find a spreadsheet in OneDrive” in Recued. Search your OneDrive by name and get back the two ids every Excel action needs. It reads information without changing anything in OneDrive.
Use “Ask a spreadsheet” in Recued. Read a worksheet's live values and answer a question about them, quoting the cells used. It reads information without changing anything in the workbook.
Use “Look up rows in a spreadsheet table” in Recued. Find the rows of an Excel table whose column matches what you are looking for — a customer, an order, an invoice number. It reads information without changing anything in the workbook.
Use “Search a spreadsheet like a database” in Recued. Download a OneDrive spreadsheet once, keep the converted copy, and search it by column — re-downloading only when the file has actually changed. It reads information without changing anything in OneDrive.
How it works
Inspect the data fetches, transforms, gates, and output this recipe runs.
Process (14 steps)
tables_raw
?
tables
default
Apply default
have_tables
template
Generate text from a template
fail: step.tables is_empty
table_count
count
Count items in tables
names
pluck
Extract name from each item
chosen
find
Find first match in
table_found
template
Generate text from a template
fail: step.chosen is_null
table_id
default
Apply default
row_count
count
Count items in setting rows
have_rows
template
Generate text from a template
fail: config.rows is_empty
exact_values
json_stringify
Apply json_stringify
append
?
written
compare
Check if append result index exists
card
to_summary
Format results as a summary card
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
rows
setting
=
[object Object]
item id
setting
=
[object Object]
drive id
setting
=
[object Object]
microsoft
setting
=
table name
setting
=
[object Object]