Zyfy for Sheets is live on the Google Workspace Marketplace
Zyfy for Sheets is now live on the Google Workspace Marketplace — UK postcode and vehicle intelligence, called as a regular formula, right inside the spreadsheet you're already working in.
If you've ever exported a column of postcodes to look something up elsewhere and pasted the results back in by hand, this is for that.
Two formulas
=ZYFY_POSTCODE(A2, "signals.flood.riversSea")
=ZYFY_VEHICLE(B2, "signals.motStatus")
Every field in the Zyfy API — flood risk, crime rate band, deprivation decile, property price trend, broadband speed, MOT history, tax status, ULEZ compliance, and dozens more — is available as the second argument. Type a formula, get a value back, same as any other Sheets function.
There's no bare "give me everything" mode. You always name the exact field you want, so a formula's output never silently changes shape later when Zyfy adds new signals.
Finding the field you want
Memorising 80+ field paths per product isn't realistic, so the add-on includes a Field Picker — a searchable sidebar covering every postcode and vehicle field. Click one to copy its path, paste it into your formula.
Filling a whole column at once
Formulas are great for one-off lookups, but if you've got a list of a few hundred postcodes or registrations, you don't want to write — or wait on — that many individual formula calls. Bulk Enrich (Starter tier and above) runs it as a background job instead: pick your input range, choose your fields, and results land in the sheet while you keep working. Cancel any time.
Getting started
- Install Zyfy for Sheets from the Marketplace.
- Get a free Zyfy API key — no card required.
- In Sheets: Extensions → Zyfy for Sheets → Configure API key, then start typing formulas.
The free tier is enough to try it immediately. Bulk Enrich needs Starter tier or above. Full walkthrough, screenshots, and field examples at zyfy.uk/sheets.