Recued
Menu
← Back to recipes

Find a spreadsheet in OneDrive

by recued-core v1 16 views

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.

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.

onedriveexcelmicrosoft-365office
by recued-core pinned v1

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.

excelmicrosoft-365officespreadsheet
by recued-core pinned v1

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.

excelmicrosoft-365officespreadsheet
by recued-core pinned v1

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.

onedriveexcelmicrosoft-365office
by recued-core pinned v1

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.

excelmicrosoft-365officespreadsheet
by recued-core pinned v1
View pack details, dependencies, and permissions →
How it works 11 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (11 steps)
safe_search replace
Replace text in setting search text
hits_raw ?
skip: config.search_text is_empty
hits default
Apply default
files_only filter
Filter by condition
workbooks filter
Filter by condition
found count
Count items in workbooks
hit_count count
Count items in hits
rows map
Extract from each item
top find
Find first match in
card to_summary
Format results as a summary card
table to_table
Format results as a data table
Settings 2 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

microsoft setting =
search text setting = [object Object]

About

Tags

onedrive onedriveexcelmicrosoft-365officespreadsheetworkbooksearchread-onlypack:excel-workbook-desk

Details

11 steps 2 configurable settings recipe_id: find-workbook-onedrive