Write RSAs in a Google Sheet — one row per ad, 15 headline and 4 description columns — and the script validates character limits and creates them in bulk. Copywriters work in the sheet; nobody pastes ads into the UI one by one.
by Google (RSA Builder concept), Chiliad (rewrite)·github.com/google/responsive-search-ads-builder
Proofreads every enabled RSA for outdated years, double spaces, repeated punctuation, placeholder text, policy-risky ALL-CAPS words and stray spaces — the embarrassing details reviews always miss.
Ad Strength distribution across all enabled RSAs plus a worklist of POOR and AVERAGE ads ranked by impressions — so rewriting effort goes where the traffic actually is.
Finds the silently broken ad insertions: countdowns pointing at past dates, keyword-insertion defaults that are empty or too long, and malformed braces that serve literally as ad text.
Finds RSAs with identical headline sets reused across multiple ad groups — the copy-paste ads that show the same generic message everywhere regardless of each ad group's keywords.
Finds promotion assets whose redemption window has passed but that are still attached to campaigns, plus promotions expiring within the week — so ad real estate never quietly goes dark.
Reports which Search campaigns have image assets attached and which serve text-only — the free CTR lift still missing from a surprising share of accounts.
Bulk RSA Builder is the first creation tool in the workflow: RSAs are written in a spreadsheet (campaign, ad group, up to 15 headlines, up to 4 descriptions, paths, final URL), the script validates every row against Google's limits — 30-char headlines, 90-char descriptions, minimum counts, path lengths, https URLs — and creates the valid ads in bulk. Every row gets its outcome written into the Result column (CREATED, or the exact validation error), and processed rows are never touched twice.
| Variable | Default |
|---|---|
SPREADSHEET_URL | (empty) |
SHEET_NAME | RSAs |
PREVIEW_MODE | true |
EMAIL_ADDRESS | (empty) |
=== Bulk RSA Builder (LIVE) === Created: 8 Skipped/invalid: 2 Brand — Exact > Core: CREATED Shoes — Generic > Running: CREATED Sneakers > Promotions: SKIPPED: headline over 30 chars: "Our Biggest Summer Sale Ever Starts Now" (39 chars) Generic — Broad > Catch-all: SKIPPED: ad group not found Email sent to you@example.com
New ads are created ENABLED in their ad group; pause old ads separately if you're replacing copy. Pinning isn't supported in the sheet (deliberately — pinning hurts more than it helps in bulk workflows). Ads still pass Google's policy review after creation — CREATED means submitted, not approved. Concept from Google's Apache-licensed RSA Builder, rebuilt on the current Scripts API.