Recued
Menu
← Back to recipes

Ask a spreadsheet

by recued-core v3 42 views

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.

Ask a spreadsheet
This recipe

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 “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 “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 26 steps

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

Process (26 steps)
◆ sheets_raw recued-core.excel.worksheet.search
Search worksheet on excel
■ 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 recued-core.excel.worksheet.used_range.read
Read worksheet used range on excel
skip: step.want_address equal true
◆ explicit_raw recued-core.excel.range.read
Read range on excel
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 core.ai.extract
AI extracts structured fields from data
skip: step.have_values not_equal true
■ result defaults
Apply defaults
■ card to_summary
Format results as a summary card
▼
Output
summary card
Settings 6 configurable

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
sheet name setting =

Uses (4 operations)

Pack operation Search worksheet on excel recued-core.excel.worksheet.search
Pack operation Read worksheet used range on excel recued-core.excel.worksheet.used_range.read
Pack operation Read range on excel recued-core.excel.range.read
AI models AI extracts structured fields from data core.ai.extract

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 AI models core.ai.extract read-only

3 more aren't listed here. You'll see them at install.

Data it touches

SurfacesAI models

About

Tags

excel excelmicrosoft-365officespreadsheetworkbookworksheetread-onlyquestionai_surfacepack:excel-workbook-desk

Details

26 steps 6 configurable settings recipe_id: ask-workbook-excel