The ReplyLabs library
Blog
Guides, use cases, and a working glossary for running AI, verification, enrichment, and enrichment from inside Google Sheets.
BlogLatest
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.
15 Sept 20265 min readRead article
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.
10 Sept 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.
5 Sept 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.
31 Aug 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.
26 Aug 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.
21 Aug 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.
16 Aug 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.
11 Aug 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.
9 Aug 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.
6 Aug 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.
7 Jul 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.
30 Jun 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.
22 Jun 2026Read
Use case11 min read
AI in Google Sheets: how to run a prompt on every row
Run one AI prompt against every row of a column in Google Sheets, no scripts and no copy-paste. How it works, what it costs per row, and how to keep outputs tied to real data.
8 Jun 2026Read
Blog8 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Blog6 min read
AI personalisation at scale in a spreadsheet
Personalise 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.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Use case10 min read
Email verification in Google Sheets: verify a list before you send
Verify an email list inside Google Sheets without exporting. How verification works, how catch-all and disposable addresses are handled, what it costs, and the steps.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Use case11 min read
Web scraping in Google Sheets: IMPORTXML, JavaScript pages, and what scales
IMPORTXML returns nothing on JavaScript-rendered pages and caps out around 50 calls. Here is why, what to use instead, the 6-minute Apps Script limit, the ethics, and a step-by-step for thousands of URLs.
8 Jun 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.
8 Jun 2026Read
Blog6 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.
8 Jun 2026Read
Blog6 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.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Use case12 min read
Cold email from Google Sheets: build, verify, enrich and personalise a list
Turn a Google Sheet into a clean, verified, personalised cold-email list. Deliverability fundamentals, ICP scoring, AI personalisation at scale, then export to your sender.
8 Jun 2026Read
Blog8 min read
Personalised cold email at scale: how to write specific mail for thousands of rows
Personalised 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Use case9 min read
BYOK AI: bring your own API key in Google Sheets
BYOK means running AI in Google Sheets on your own provider key at raw cost with zero markup. How it works, the pricing math, supported providers, and the security model.
8 Jun 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.
8 Jun 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 ReplyLabs and run AI at raw cost.
8 Jun 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 maths for input, output, managed markup, and BYOK.
8 Jun 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.
8 Jun 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.
8 Jun 2026Read
Use case10 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.
8 Jun 2026Read
Blog6 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.
8 Jun 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.
8 Jun 2026Read
Blog7 min read
How waterfall enrichment works (and how to do it in Sheets)
Waterfall enrichment queries multiple data sources in sequence and keeps the first verified match. How it lifts coverage from ~50% to 80%+, and a Sheets version.
8 Jun 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.
8 Jun 2026Read
Glossary3 min read
Waterfall enrichment
Waterfall enrichment queries multiple data sources in sequence for the same field and keeps the first verified match, lifting B2B coverage from ~50% to 80%+. Definition.
8 Jun 2026Read