import { useState } from 'react' import { Button } from "/components/ui/button" import { Card, CardContent, CardHeader, CardTitle, CardDescription } from "/components/ui/card" import { Input } from "/components/ui/input" import { Copy, HelpCircle, X, Link as LinkIcon, Download } from "lucide-react" export default function CipherMysteriesScraper() { const [subjectName, setSubjectName] = useState('') const [formula, setFormula] = useState({ title: '', url: '', hyperlink: '', staticLinks: '' }) const [showHelp, setShowHelp] = useState(false) const [copied, setCopied] = useState('') const [activeView, setActiveView] = useState<'formulas' | 'pdf'>('formulas') const generateFormula = () => { if (!subjectName.trim()) { alert('Please enter a subject name') return } const encodedSubject = encodeURIComponent(subjectName.trim()) const baseUrl = `https://ciphermysteries.com/?s=${encodedSubject}` // Generate both the active link version and PDF-ready version setFormula({ title: `=IMPORTXML("${baseUrl}", "//h2/a")`, url: `=IMPORTXML("${baseUrl}", "//h2/a/@href")`, hyperlink: `=ARRAYFORMULA(IF(A1:A="", "", HYPERLINK(B1:B, A1:A)))`, // Active links staticLinks: `=ARRAYFORMULA(IF(A1:A="", "", "=HYPERLINK("""&B1:B&""","""&A1:A&""")"))` // PDF version }) setActiveView('formulas') } const copyToClipboard = (text: string, type: string) => { if (!text) return navigator.clipboard.writeText(text) setCopied(type) setTimeout(() => setCopied(''), 2000) } return (

Cipher Mysteries Scraper Generate IMPORTXML formulas to scrape data from Cipher Mysteries

{showHelp && (

How to use:

Enter the subject name you want to search for
Click "Generate Formula"
Copy each formula one by one and paste into Google Sheets
Column C will contain clickable links in your spreadsheet

PDF Export:

Use the "Prepare for PDF Export" button when ready
Follow the special instructions to make links work in PDFs

)}

Subject Name * setSubjectName(e.target.value)} />

{formula.title && (

{activeView === 'formulas' ? ( <>

Column A (Titles) Paste into A1

                        {formula.title}

Column B (URLs) Paste into B1

                        {formula.url}

Column C (Clickable Links) Paste into C1

These will be active hyperlinks in your spreadsheet

                        {formula.hyperlink}

) : ( PDF Export Preparation Replace Column C with this formula before exporting to PDF

                      {formula.staticLinks}

PDF Export Instructions:

Copy the formula above
In your spreadsheet, overwrite Column C with this new formula
Select column C → Right-click → Copy
Right-click → Paste Special → Values Only
Press Ctrl+H (Find/Replace) and replace:

Find: =

Replace with: =
Click "Replace all" to activate the links
Now your PDF export will contain working hyperlinks!

)}

) }