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 (32 steps)
cache_path
template
Generate text from a template
meta_raw
recued-core.onedrive.file.read
Read file on onedrive
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
core.storage.file.stat
Stat storage file
have_file
default
Apply default
seen
core.storage.shared.read
Read storage shared
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
recued-core.excel.worksheet.search
Search worksheet on excel
sheets
default
Apply default
sheet_count
count
Count items in sheets
download
recued-core.onedrive.file.download
Download file on onedrive
skip: step.stale not_equal true
downloaded_ref
default
Apply default
converted
recued-core.xlsx2csv.spreadsheet.to_csv
To csv spreadsheet on xlsx2csv
skip: step.stale not_equal true
fresh_csv
default
Apply default
stored
core.storage.file.put-ref
Put ref storage file
skip: step.stale not_equal true
version_write
core.storage.shared.write
Write storage shared
skip: step.stale not_equal true
search
core.storage.csv.rows
Rows storage csv
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
row_count
default
Apply default
found
default
Apply default
hits
default
Apply default
shown
count
Count items in hits
card
to_summary
Format results as a summary card
table_view
to_table
Format results as a data table
▼
Output
summary
card
table
table_view
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]
cache slug
setting
=
[object Object]
version key
setting
=
spreadsheet_versions
Uses (9 operations)
Pack operation
Read file on onedrive
recued-core.onedrive.file.read
Files
Stat storage file
core.storage.file.stat
Shared store
Read storage shared
core.storage.shared.read
Pack operation
Search worksheet on excel
recued-core.excel.worksheet.search
Pack operation
Download file on onedrive
recued-core.onedrive.file.download
Pack operation
To csv spreadsheet on xlsx2csv
recued-core.xlsx2csv.spreadsheet.to_csv
Files
Put ref storage file
core.storage.file.put-ref
Shared store
Write storage shared
core.storage.shared.write
Files
Rows storage csv
core.storage.csv.rows
Trust & control
What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.
What it's allowed to do
Read
Files
core.storage.file.stat
read-only
Read
Shared store
core.storage.shared.read
read-only
Write
Files
core.storage.file.put-ref
external change
Write
Shared store
core.storage.shared.write
external change
Read
Files
core.storage.csv.rows
read-only
4 more aren't listed here. You'll see them at install.