curl -sSL https://canifi.com/skills/google-sheets/install.sh | bash

cp -r skills/google-sheets ~/.canifi/skills/

# First, ensure canifi-env is installed:
# curl -sSL https://canifi.com/install.sh | bash

canifi-env set GOOGLE_EMAIL "your-email@gmail.com"

canifi-env set SERVICE_EMAIL "your-email"
canifi-env set SERVICE_PASSWORD "your-password"

User: "Create a monthly budget spreadsheet"
Claude: Creates new sheet with columns for Category, Budgeted, Actual, Difference.
        Adds SUM formulas for totals, conditional formatting for over-budget items.
        Returns: "Created budget spreadsheet: [link]"

User: "What were my top 5 expenses last month?"
Claude: Opens expense sheet, sorts by amount descending, reads top 5 entries.
        Reports: "Top 5 expenses: 1. Rent $1500, 2. Car Payment $450..."

User: "Add a formula to calculate the running total in column D"
Claude: Navigates to column D, enters formula =SUM($C$2:C2) in first data row,
        copies formula down to all rows. Confirms: "Running total formula applied"

User: "Create a pie chart of spending by category"
Claude: Selects category and amount columns, inserts pie chart,
        applies labels and formatting. Reports: "Pie chart created"

// New spreadsheet button
'#newButton' or '[aria-label="New"]'

// Spreadsheet title
'.docs-title-input'

// Cell reference box
'#t-name-box'

// Formula bar
'#t-formula-bar-input'

// Active cell
'.cell-input'

// Sheet tabs
'.docs-sheet-tab'

// Add sheet button
'#sheet-add-button'

// Menu bar
'.menu-button'

// Insert menu
'#docs-insert-menu'

// Format menu
'#docs-format-menu'

// Chart dialog
'.charts-dialog'

// Filter button
'[aria-label="Create a filter"]'

=SUM(A1:A10)           // Sum range
=AVERAGE(A1:A10)       // Average
=VLOOKUP(key,range,col,false)  // Vertical lookup
=IF(condition,true,false)       // Conditional
=COUNTIF(range,criteria)        // Count matching
=SUMIF(range,criteria,sum_range) // Sum matching
=CONCATENATE(A1," ",B1)         // Join text
=TODAY()               // Current date
=GOOGLEFINANCE("GOOG") // Stock price