Recued
Menu
← Back to recipes

Find a spreadsheet in OneDrive

by recued-core v2 52 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 v2

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 v3

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 v2

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 v3

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 v2
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 recued-core.onedrive.drive.search
Search drive on onedrive
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
▼
Output
summary card
table table
Settings 1 configurable

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

search text setting = [object Object]

Uses (1 operation)

Pack operation Search drive on onedrive recued-core.onedrive.drive.search

About

Tags

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

Details

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