Guides for work at row scale.
How to run AI and web scraping from a Google Sheet: which formula does which job, what a run costs, and the workflows people actually build. Product updates land here too.
- Articles
- 28
- Series
- 5
- Series articles
- 3
All articles
On-Page SEO Audit in Google Sheets for 100 URLs
Run an on-page SEO audit in Google Sheets. Paste 120 URLs, add five formulas, and flag every bad title, description, and H1 in about 10 minutes.
Guides · · 13 min read
Amazon Product Research in Google Sheets
Amazon product research in Google Sheets: 40 ASINs checked in about a minute instead of 2 hours of tabs. Result tables, a template, and what it costs.
Guides · · 13 min read
Enrich Lead Lists in Google Sheets
Enrich lead lists in Google Sheets with formulas. A 3-column export becomes a 14-column prospect sheet, 6 hours down to 20 minutes. Copy the template.
Guides · · 13 min read
35 New Scraper Functions for Google Sheets
Amazon, Google Search, Instagram, LinkedIn, and more, all as plain formulas now. Same credit cost as the AI Chat sidebar, zero setup.
Product · · 5 min read
AI Chat Agent Is Live in SheetMagic
SheetMagic v6.0.0 puts a conversational AI agent in Google Sheets. Describe what you want and it reads data, writes cells, and scrapes the web.
Product · · 4 min read
Scrape Images from Websites into Google Sheets
Extract image URLs from any webpage into your spreadsheet with one formula. Build product image libraries and run image SEO audits fast.
Guides · · 8 min read
How to Check Domain Availability in Bulk
Check hundreds of domain names in Google Sheets with one formula. Find available domains for brands, projects, and investments fast.
Guides · · 9 min read
IMPORTXML vs SheetMagic for Web Scraping
Compare IMPORTXML with SheetMagic formulas for scraping websites in Google Sheets. See where built-in functions fall short and what to use instead.
Guides · · 10 min read
Bulk SERP Scraping in Google Sheets
Scrape Google search results for 50+ keywords at once in Google Sheets. Build a keyword research dashboard without expensive SEO tools.
Guides · · 9 min read
CSS Selector Scraping in Google Sheets
Use CSS selectors to scrape exact data from any webpage into Google Sheets. Prices, ratings, titles, and more with one formula.
Guides · · 9 min read
Showing 10 of 28 articles
Latest in the series
How to Use the AI Chat Agent in Google Sheets
A practical guide to the AI Chat Agent sidebar: analyze data, write cells, scrape the web, and automate multi-step workflows in plain English.
AI in Google Sheets · · 10 min read
AITEXT: Generate Text in Google Sheets
Use the AITEXT function to generate marketing copy, summaries, and email drafts inside Google Sheets. Includes prompt templates and real examples.
AI in Google Sheets · · 11 min read
The Complete Guide to AI in Google Sheets (2026)
Everything you need to know about using AI inside Google Sheets, from built-in features to custom functions to add-ons like SheetMagic.
AI in Google Sheets · · 19 min read
Five series, from first formula to full workflow.
AI in Google Sheets
Everything about using AI inside Google Sheets, from built-in Gemini to custom formulas to bulk automation.
3 of 11 published
Web Scraping & Data Extraction
No-code web scraping from a spreadsheet. Pull data from any website, SERP, or API directly into your cells.
11 planned, none published yet
SEO Workflows
SEO automation with Google Sheets. Keyword research, rank tracking, content audits, and competitor analysis at scale.
10 planned, none published yet
Sales & Lead Generation
Turn Sheets into a sales machine. Prospect enrichment, email outreach, CRM sync, and pipeline automation.
8 planned, none published yet
Data Analysis & Reporting
AI-powered data analysis beyond formulas. Summarize, classify, extract insights, and build reports with natural language.
9 planned, none published yet