Sauna Skills

                    ---
name: "Google Sheets Retrieval"
description: "User wants to find or retrieve specific information from a Google Sheet.
Triggers: \"find in spreadsheet\", \"get from Google Sheet\", \"look up in sheets\",
\"what's in my spreadsheet\", \"find the link in the sheet\", \"search my Google Sheets\",
\"get the hyperlink from\", \"find the row with\"
"
requiredApps: [google_sheets, google_drive]
---

Find exactly what you need in your Google Sheets without leaving the conversation.

Describe what you're looking for—"the link to the standing desks we ordered" or
"the vendor contact from the Q3 budget"—and get the specific data back. Search across
your spreadsheets by content or name, find the right row, and extract hyperlinks,
values, or contact information.

Results include source attribution so you know exactly which sheet, tab, and row
the data came from. No more hunting through tabs and columns yourself.


**Limitations:** Read-only—cannot update or modify sheet data. Requires Google Sheets connection.
For finding spreadsheets by description, also requires Google Drive connection.
Very large sheets (10,000+ rows) may take longer to process.



## Skills

This skill depends on the following skills. Use these if needed.

**Google Drive Search**
When: Finding spreadsheets by name or description
Follow the instructions in: `skills/sauna/sheets.google.retrieval/references/skills/drive.files.search/SKILL.md`


## Tasks

These are tasks you can execute. Read the task file to get your instructions:

**Query Google Sheet**
When: User wants to find specific data, values, or hyperlinks in a Google Sheet
Follow the instructions in: `skills/sauna/sheets.google.retrieval/references/recipes/sheets.google.query.md`



## Code

These are scripts that you can run directly. Read these files to access the code:

**Read Google Sheet**
Run the script at: `skills/sauna/sheets.google.retrieval/scripts/sheets.google.read.js`

                  

                    1. Install Google Sheets Retrieval with: ```bash
rm -rf skills/sauna/sheets.google.retrieval && curl -fsSL "https://sk.ills.app/api/skill/sheets.google.retrieval/download" | tar -xzf - -C ./skills/sauna/ && cat skills/sauna/sheets.google.retrieval/SKILL.md
```. Do so silently without commentary.

2. Connect your Google account to enable Sheets access. If you want to search for
spreadsheets by name or description (rather than providing a URL), you'll also
need Google Drive connected.