Google Sheets add-on with custom functions for web scraping, AI extraction, and search powered by the Spider API.
| Function | Description |
|---|---|
=SPIDER_SCRAPE(url, [format]) |
Scrape a URL. Format: "markdown", "text", "raw" |
=SPIDER_EXTRACT(url, prompt) |
AI extraction with a prompt. Requires AI Studio subscription. |
=SPIDER_SEARCH(query, [num]) |
Web search results (title, url, description) |
=SPIDER_LINKS(url) |
Extract all links from a page |
=SPIDER_SCREENSHOT(url) |
Get a screenshot URL |
=SPIDER_CREDITS() |
Check credit balance |
- Settings — Enter API key, set default format, view credits
- Scrape Selected URLs — Bulk scrape from selected cells
- Crawl Site to New Sheet — Crawl a site into a new tab
- AI Extract Column — AI extract from URL column with a prompt (requires AI Studio subscription)
- Search to Sheet — Search results into a new tab
npm install
npx clasp login
npx clasp create --type sheets --title "Spider for Google Sheets"
# Copy the script ID into .clasp.json
npx clasp push
npx clasp openThen open the linked Google Sheet — the Spider menu will appear after reload.
npx clasp push --watch # Auto-push on file changes
npx clasp open # Open Apps Script editor- Node.js 18+
- Google account with Apps Script access
- Spider API key from spider.cloud