The Sorzio library
Sorzio Outbound, AI & Enrichment Library
Guides, use cases, and a working glossary for running AI, email verification, lead enrichment, and ICP workflows across Claude, ChatGPT, and Google Sheets.
BlogLatest
Email Subject Line for Sales: What Gets Opened vs Deleted
Learn what makes an email subject line for sales get opened instead of deleted. Practical examples, formulas, and list prep tips for better outreach.
Oct 30, 20267 min readRead article
Blog7 min read
Ideal Customer Profile Template: Fields, Scoring & Setup
Build an ideal customer profile template with the right fields, then turn it into a scoring system that ranks real leads in your spreadsheet.
Oct 25, 2026Read
Blog9 min read
SPF DKIM DMARC Explained: Essential Cold Email Setup Guide
Learn what SPF, DKIM and DMARC do for email authentication. Get the minimum correct setup for cold email deliverability in this practical guide.
Oct 20, 2026Read
Blog7 min read
What Is ICP in Sales? Definition, Examples & How to Build
Learn what ICP means in sales, how it differs from buyer personas, and get a step-by-step framework for building an ideal customer profile that works.
Oct 15, 2026Read
Blog7 min read
Subject Line for Cold Email: What Opens and What Fails
Learn what makes a cold email subject line get opened. Practical patterns that work, common mistakes to avoid, and how to personalise at scale.
Oct 10, 2026Read
Blog7 min read
Formula Parse Error IMPORTXML: Causes and Quick Fixes
Fix formula parse error IMPORTXML issues in Google Sheets. Learn what causes #ERROR! and parse errors, plus reliable alternatives for web scraping.
Oct 5, 2026Read
Blog7 min read
IMPORTRANGE vs IMPORTXML: Which Google Sheets Function?
Learn the key differences between IMPORTRANGE and IMPORTXML in Google Sheets. Discover which function fits your data needs and when to use alternatives.
Sep 30, 2026Read
Blog8 min read
IMPORTXML Blocked by Robots.txt: How to Fix It
Learn why IMPORTXML gets blocked by robots.txt, what legitimate options exist, and how to enrich website data in Google Sheets without crawling issues.
Sep 25, 2026Read
Blog5 min read
Every Google Sheets Limit That Stops a Big Job
350 cells, 30 seconds, 6 minutes, 10 million cells, 20,000 fetches. One page with every Google Sheets limit that ends a large batch, and what each one means.
Sep 20, 2026Read
Blog5 min read
Why Enrichment Coverage Is Never 100%, and What Is Normal
A fifth to a third of company URLs will not return data, and no vendor fixes that. Why coverage fails, what a realistic rate looks like, how to measure yours.
Sep 15, 2026Read
Blog4 min read
What 1,000 Enriched Leads Actually Cost, Line by Line
Per-row enrichment costs less than most people assume. The real spend is seats and rows you should never have processed. The arithmetic, worked through.
Sep 10, 2026Read
Blog5 min read
Scrape, Summarise, Score: Multi-Step Enrichment in Sheets
Running enrichment one step at a time wastes money on rows that already failed. How to chain steps in a spreadsheet so each one only sees rows that qualify.
Sep 5, 2026Read
Blog4 min read
How Many Rows Can You Run AI On in Google Sheets?
Every method for running AI over a Google Sheet has a different ceiling: 350 cells, 30 seconds, 6 minutes, or your provider's rate limit. The real numbers.
Aug 31, 2026Read
Blog6 min read
The Apps Script 6-Minute Limit: Why Your Script Dies
Exceeded maximum execution time is a hard 6-minute ceiling on every plan. The real quota table, why custom functions get only 30 seconds, and the four fixes.
Aug 26, 2026Read
Blog5 min read
IMPORTXML: Imported Content Is Empty (The Real Causes)
Imported content is empty means the fetch worked and your XPath matched nothing. Usually the tbody DevTools adds, or JavaScript. How to tell in 30 seconds.
Aug 21, 2026Read
Blog5 min read
IMPORTXML Could Not Fetch URL: What It Means, What Fixes It
The IMPORTXML could not fetch url error is a network failure, not a formula failure. Here is what Google's servers actually got back, and the fixes that work.
Aug 16, 2026Read
Blog5 min read
Why the AI Function Is Not Working in Google Sheets
The AI function missing, greyed out, or returning nothing in Google Sheets? Every documented cause, how to tell them apart in a minute, and what fixes each one.
Aug 11, 2026Read
Blog9 min read
Cold email follow up: how many, how far apart, and what to actually say
Follow-ups send to the same list four or five times, so they multiply whatever is already wrong with it. How many to send, how long to wait, what each one should say, and why an unverified list makes your reply rate meaningless.
Aug 9, 2026Read
Blog6 min read
The 350-Cell Limit in Google Sheets AI (and What to Do)
Google Sheets generates only the first 350 cells when you use AI functions. Here is where that number comes from, what else caps you, and four ways past it.
Aug 6, 2026Read
Blog7 min read
Cold Email ICP Problem: Fix the List, Not the Copy
Silence after 60 careful emails? It's an ICP problem, not a copy one. Score each row in plain English, then Gate out the non-fits before you send.
Jul 7, 2026Read
Blog8 min read
Qualify Before You Send, Not After Replies Stack Up
Reply-triage is cleanup. Score each row against your ICP before the send and a bad prospect costs a keystroke, not a wasted send and a reputation hit.
Jun 30, 2026Read
Blog6 min read
Better Data, Not Better Models, Wins B2B Outbound
Your AI isn't the problem - your list is. Audit list freshness, email verification, and signal research before you blame the model for weak replies.
Jun 22, 2026Read
Use case12 min read
AI in Google Sheets: how to run a prompt on every row
Run Generative AI, Live Web Search, and Decision Mode across every row in Google Sheets, Hosted Lists, or Claude and ChatGPT MCP. Pricing, models, and prompt rules.
Jun 8, 2026Read
Blog9 min read
Best AI tools for Google Sheets in 2026 (honest comparison)
An objective 2026 guide to the best AI tools and add-ons for Google Sheets: what each does, who it suits, rough pricing, and one real limitation each.
Jun 8, 2026Read
Blog3 min read
How to write an AI formula in Google Sheets (no script)
Write an AI formula that runs a prompt over a column in Google Sheets, without Apps Script. The fastest method, why custom functions fail, and the cost.
Jun 8, 2026Read
Blog8 min read
Bulk AI in Google Sheets: run one prompt across thousands of rows
Run a single AI prompt across thousands of Google Sheets rows at once. The fastest method, why in-cell formulas stall, how to keep cost predictable, and a worked example.
Jun 8, 2026Read
Blog6 min read
GPT for Google Sheets: how to use ChatGPT in Sheets (no script)
Use GPT and ChatGPT models in Google Sheets without writing Apps Script. The add-on method, why in-cell formulas stall at scale, what it costs, and a worked example.
Jun 8, 2026Read
Blog6 min read
AI personalization at scale in a spreadsheet
Personalize outreach for thousands of rows with AI from a spreadsheet. The row-level prompt method, why it beats mail-merge tokens, and what it costs.
Jun 8, 2026Read
Glossary1 min read
AI prompt
An AI prompt is the instruction you give a language model. In Google Sheets, it is the template applied to every row with column values substituted in.
Jun 8, 2026Read
Glossary3 min read
Token (LLM)
A token is the unit a language model reads and writes text in. It is also the unit AI is billed in, which is why token count drives the cost of every AI run.
Jun 8, 2026Read
Use case10 min read
Email verification in Google Sheets: verify a list before you send
Verify email lists in Google Sheets, Hosted Lists, or Claude and ChatGPT MCP at $0.01/email. Catch-all handling, bounce benchmarks, Scale BYOK, and step-by-step instructions.
Jun 8, 2026Read
Blog6 min read
How to verify an email list (the fast way, in Google Sheets)
A step-by-step guide to verifying an email list in Google Sheets: check deliverability, handle catch-all and disposable addresses, and cut your bounce rate.
Jun 8, 2026Read
Blog7 min read
How to reduce your email bounce rate (a practical playbook)
How to reduce email bounce rate: clean and verify your list, fix authentication, warm your domain, and handle soft bounces. The exact steps to get under 2 percent.
Jun 8, 2026Read
Blog6 min read
How to handle catch-all emails in cold outreach
Catch-all emails cannot be confirmed by a verifier, so they carry bounce risk. How to segment, send, and warm them safely in cold outreach without hurting your domain.
Jun 8, 2026Read
Glossary2 min read
Catch-all email
A catch-all (accept-all) email domain accepts mail for every address, even ones that do not exist. Why it cannot be verified normally and how to handle it.
Jun 8, 2026Read
Glossary3 min read
Bounce rate
Bounce rate is the share of sent emails a server refuses to deliver. Hard vs soft bounces, the formula, healthy thresholds, and why staying under 2 percent matters.
Jun 8, 2026Read
Glossary2 min read
Email deliverability
Email deliverability is whether your messages reach the inbox rather than spam. The factors that drive it, why bounce rate matters, and how verification helps.
Jun 8, 2026Read
Use case11 min read
Web scraping in Google Sheets: IMPORTXML, JavaScript pages, and what scales
IMPORTXML returns nothing on JavaScript pages and caps out around 50 calls. How server-side URL enrichment works across 6-page websites and LinkedIn in Google Sheets, Hosted Lists, and MCP.
Jun 8, 2026Read
Blog8 min read
How to enrich website data into a spreadsheet (no code, 2026)
Turn a column of website URLs into data in a spreadsheet without code. The three real methods, where each one breaks, what it costs, and a step-by-step that scales to thousands of URLs.
Jun 8, 2026Read
Blog7 min read
How to enrich LinkedIn company data safely (and the legal limits)
Collecting LinkedIn company data has real legal and ToS limits. What the hiQ ruling actually said, why public company data is the safer angle, and a compliant Enrich workflow.
Jun 8, 2026Read
Blog7 min read
IMPORTXML in Google Sheets vs Enrich: when each one wins
IMPORTXML is free and fine for a few static pages, but it caps at ~50 calls and fails on JavaScript sites. Here is how it works, where it breaks, and when to switch.
Jun 8, 2026Read
Glossary2 min read
URL enrichment
URL enrichment turns a column of URLs into structured data by fetching each page and extracting the values you need. In Google Sheets, it is the Enrich step.
Jun 8, 2026Read
Glossary3 min read
Rate limiting
Rate limiting is when a server caps how many requests a client can make in a time window. In scraping, it triggers HTTP 429 errors and is handled with pacing and backoff.
Jun 8, 2026Read
Use case10 min read
Cold email from Google Sheets: build, verify, enrich and personalize a list
Turn a Google Sheet or Hosted List into a verified, ICP-scored, personalized cold-email list with Decision Mode and self-healing AI copy, then export to your sender.
Jun 8, 2026Read
Blog8 min read
Personalized cold email at scale: how to write specific mail for thousands of rows
Personalized cold email at scale means writing a genuinely specific message for every prospect without writing each by hand. Here is how to do it in a spreadsheet.
Jun 8, 2026Read
Blog8 min read
Cold email deliverability checklist for 2026: the steps that keep you in the inbox
A concrete 2026 cold email deliverability checklist: authentication, domains, volume limits, warm-up, list verification and the monitoring that catches problems early.
Jun 8, 2026Read
Blog8 min read
ICP scoring for outbound: how to grade a prospect list against your ideal customer
ICP scoring turns your ideal customer profile into a grade on every prospect, so you target best-fit accounts first. Here is how to score an outbound list in a spreadsheet.
Jun 8, 2026Read
Glossary3 min read
Ideal customer profile (ICP)
An ideal customer profile (ICP) describes the companies most likely to buy, succeed and stay. It is the targeting blueprint that drives cold-email reply rates.
Jun 8, 2026Read
Glossary3 min read
Spintax
Spintax is a syntax for cold-email text variations: each recipient gets a randomly chosen version, so identical content stops looking like bulk mail to spam filters.
Jun 8, 2026Read
Use case9 min read
BYOK AI: bring your own API key in Google Sheets
BYOK runs AI in Google Sheets, Hosted Lists, and Claude or ChatGPT MCP on your own provider key at 0% Sorzio markup. Exact pricing math, supported providers, and security.
Jun 8, 2026Read
Blog7 min read
BYOK vs managed AI pricing: when each is cheaper
BYOK bills AI at raw provider cost with no markup; managed adds a small margin but needs no key. Worked cost math, the break-even point, and when each wins.
Jun 8, 2026Read
Blog7 min read
Use one OpenRouter key for many models in Google Sheets
An OpenRouter key reaches 300+ models across providers through one credential. How to bring it into Google Sheets with Sorzio and run AI at raw cost.
Jun 8, 2026Read
Blog6 min read
How to estimate AI API cost for a Google Sheets job
Estimate AI API cost from token counts and per-million rates, then scale to a full Sheets batch. Worked math for input, output, managed markup, and BYOK.
Jun 8, 2026Read
Glossary2 min read
BYOK (bring your own key)
BYOK means using your own AI provider API key in a tool, so model calls bill to your provider account at raw cost with no platform markup added.
Jun 8, 2026Read
Glossary3 min read
API key
An API key is a secret credential that authenticates and bills requests to a service. In BYOK tools, your provider key runs AI at raw cost on your account.
Jun 8, 2026Read
Use case11 min read
Lead enrichment in Google Sheets: the complete guide
Lead enrichment in Google Sheets means filling in firmographics and contact data on a list using scraping and AI. How it works, waterfall logic, and the cost.
Jun 8, 2026Read
Blog7 min read
How to enrich leads in Google Sheets without Clay
A Clay alternative for lead enrichment that lives in Google Sheets. An honest comparison of coverage, cost, and when Clay is still the right call.
Jun 8, 2026Read
Blog8 min read
Firmographic enrichment explained: what it is and how to do it
Firmographic enrichment fills in company size, industry, revenue, and location on a lead list. What the fields mean, how accurate they are, and how to do it in Sheets.
Jun 8, 2026Read
Blog5 min read
How to build a waterfall enrichment workflow in Google Sheets & MCP
Step-by-step guide to running a multi-source B2B enrichment waterfall in Google Sheets, Hosted Lists, or Claude MCP, with 1,000-row TCO math against credit tools.
Jun 8, 2026Read
Glossary3 min read
Firmographics
Firmographics are company-level attributes, employee count, industry, revenue, location, and ownership, used to segment and qualify B2B accounts. Definition and examples.
Jun 8, 2026Read
Glossary2 min read
Waterfall enrichment
Waterfall enrichment is a B2B data pattern that queries multiple providers in sequence and stops at the first verified match, raising coverage from ~50% to 80%+.
Jun 8, 2026Read