Answer exact Discord lookups from a published Google Sheet

What it needs

• Sheet Lookup is a Pro module. It adds no Discord permissions or privileged intents; it registers one guild slash command and sends only ephemeral replies.
• It needs one Google Sheets tab published to the web as CSV. A published sheet is public to anyone with the link, so include only data you have permission to share, cache and display.

Setting it up

1. In Google Sheets, choose File → Share → Publish to web, select one tab, select Comma-separated values (.csv), and copy the published HTTPS docs.google.com link. The first row must contain nonempty column headers.
2. Open Sheet Lookup in your bot’s Modules tab, paste the Published CSV link and select Test. The preview detects headers and returns the first five shortened rows without saving settings.
3. Select a key column and 1–10 output columns. Keep /lookup or choose a 1–32-character lowercase command name, turn on Enable lookups in this server, save, then regenerate and start the bot.

Example

With Item selected as the key column and Answer selected as the output column, /lookup key:rules matches a cell containing Rules after case and surrounding spaces are ignored. The member receives the selected Answer value in a private reply; a second Rules row returns a duplicate-key error instead of an arbitrary answer.

Limits and troubleshooting

Limits

• Only one published HTTPS docs.google.com CSV tab is accepted. Private sheets, Google accounts or API keys, writes, arbitrary formulas or ranges, multi-tab joins, partial matches and fuzzy matches are not supported.
• A fetch has a 10-second deadline and allows at most three validated redirects. CSV input is capped at 1 MiB, 5,000 nonblank data rows and 100 columns; it needs at least two columns, nonempty headers and consistent row widths.
• The in-memory cache holds at most 20 sheets per process for up to about five minutes, while a 30-second refresh cooldown applies after a URL change or cache removal. Cache contents are never written to disk.

If it doesn’t work

• The link is rejected: publish the tab as Comma-separated values (.csv) and paste its HTTPS docs.google.com Publish to web link. Export, API, range and private-sheet links are refused.
• The command reports no match: check the selected key column and the key spelling. Matching ignores case and surrounding spaces, but it remains exact and does not search partial words.
• The command reports a duplicate key or data error: make each key unique and make sure the CSV has a nonempty header row, at least two columns and consistent row widths. Reduce the sheet if it exceeds 1 MiB, 5,000 data rows or 100 columns.