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.
Search a spreadsheet like a database
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.
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 “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 (34 steps)
cache_path
template
Generate text from a template
meta_raw
?
file_meta
default
Apply default
live_etag
default
Apply default
readable
template
Generate text from a template
fail: step.live_etag is_empty
file_name
default
Apply default
drive_id
default
Apply default
probe
?
have_file
default
Apply default
seen
?
seen_etag
default
Apply default
etag_matches
compare
Check if seen etag equals live etag
stale
any
Check if any of the conditions are true
sheets_raw
?
sheets
default
Apply default
sheet_count
count
Count items in sheets
download
?
skip: step.stale not_equal true
downloaded_ref
default
Apply default
converted
?
skip: step.stale not_equal true
fresh_csv
default
Apply default
stored
?
skip: step.stale not_equal true
version_write
?
skip: step.stale not_equal true
search
?
column_exists
compare
Check if search column found equals true
known_columns
default
Apply default
column_found
template
Generate text from a template
fail: step.column_exists not_equal true
matched_ref
default
Apply default
row_count
default
Apply default
file_read
?
csv_text
decode_base64
Apply decode_base64
hits
csv_parse
Apply csv_parse
found
count
Count items in hits
card
to_summary
Format results as a summary card
table_view
to_table
Format results as a data table
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
match
setting
=
contains
sheet
setting
=
1
value
setting
=
[object Object]
column
setting
=
[object Object]
item id
setting
=
[object Object]
microsoft
setting
=
cache slug
setting
=
[object Object]
version key
setting
=
spreadsheet_versions
Trust & control
What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.