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.
Ask a spreadsheet
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.
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 “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.
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.
How it works
Inspect the data fetches, transforms, gates, and output this recipe runs.
Process (26 steps)
sheets_raw
?
sheets
default
Apply default
have_sheets
template
Generate text from a template
fail: step.sheets is_empty
sheet_count
count
Count items in sheets
first_sheet
find
Find first match in
named_sheet
find
Find first match in
want_named
compare
Check if setting sheet name has data
named_missing
all
Check if all conditions are true
sheet_exists
template
Generate text from a template
fail: step.named_missing equal true
chosen
ternary
Apply ternary
sheet_id
default
Apply default
sheet_label
default
Apply default
want_address
compare
Check if setting address has data
used_raw
?
skip: step.want_address equal true
explicit_raw
?
skip: step.want_address not_equal true
range_obj
default
Apply default
range_address
default
Apply default
cell_count
default
Apply default
row_count
default
Apply default
too_big
compare
Check if cell count is greater than setting max cells
within_budget
template
Generate text from a template
fail: step.too_big equal true
values
default
Apply default
have_values
compare
Check if values has data
answer
?
skip: step.have_values not_equal true
result
defaults
Apply defaults
card
to_summary
Format results as a summary card
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
address
setting
=
item id
setting
=
[object Object]
drive id
setting
=
[object Object]
question
setting
=
[object Object]
max cells
setting
=
20000
microsoft
setting
=
sheet name
setting
=