SPREADSHEET WIZARD

Every Monday at 10 AM, check my Google Sheet "Competitor Tracking" for 
URLs in the "Product Page" column. Use web browsing to extract current 
prices, availability status, and any promotional messaging. Update the 
"Current Price", "Last Updated", and "Notes" columns. Highlight rows 
where prices changed by more than 5% in red. Email me a summary of significant changes.

Daily at 8 AM, use news search and Tavily to find articles mentioning 
my company, competitors, and key industry terms. Add new findings to 
my Google Sheet "Industry News Tracker" with: headline, source, date, 
summary (2 sentences), sentiment (positive/neutral/negative), action needed (Y/N). 
Sort by date with newest first. Flag urgent items in a separate tab.

When new rows are added to my Google Sheet "Sales Pipeline", use the 
company name and contact email to: find the company's LinkedIn page, 
get employee count and industry, find the contact's LinkedIn profile 
and title, check their website for recent news. Populate empty columns 
with this enriched data. Flag any rows where enrichment failed for manual review.

Every Friday at 5 PM, pull data from: HubSpot (deals created/closed), 
Google Analytics (website traffic - if connected), Stripe (revenue), 
Jira (tickets resolved). Update my Google Sheet "Weekly Metrics" with 
new rows for this week. Calculate week-over-week changes and highlight 
trends. Create a summary chart and email it to the leadership team.

When I add a target criteria to my Google Sheet "Lead Gen" (industry, 
company size, location), use web search and LinkedIn to find 20 matching 
companies. For each, find: company name, website, LinkedIn URL, employee 
range, key decision maker name and title. Add to the sheet with status 
"New". Continue searching until I have 100 leads or you exhaust sources.

When I upload receipts to my Google Drive "Expenses" folder, use OCR 
to extract: vendor name, date, amount, category (auto-detected). Add 
to my Google Sheet "Expense Report" with receipt link. Flag any expenses 
over $100 for approval. At month end, calculate totals by category and 
flag any unusual spending patterns. Export a summary PDF to Drive.