Install Unblockly AI Extension in Google Sheets: Step-by-Step Setup & Template Guide

Finding, qualifying, and contacting new prospects shouldn’t feel like detective work. With the free CLAY Google Sheets extension you can bring LinkedIn-style search power straight into a spreadsheet, automate the heavy lifting, and keep every step of your outreach in one familiar place.

Why Prospect Inside Google Sheets?

• One source of truth – research, enrichment, and outreach data sit side-by-side with your existing pipeline sheets.

• No-copy-paste workflow – AI formulas pull company and people data directly into cells; no toggling between tabs.

• Team-friendly – share a single sheet instead of clunky CSV exports or locked-down SaaS dashboards.

• Custom reporting – build charts, pivot tables, or connect Looker Studio without extra integrations.

What CLAY Brings to the Table

How to Get Started

1. Install the Extension

1. Head to unblockly store page.

2. Click Download Extension → Install on my account.

3. Grant Google permission and wait for the success message.

2. Copy the Ready-Made Template

1. Back on the site, hit Use our template.

2. In the new Sheet, choose File → Make a copy to work on your own version.

3. Enable CLAY Functions

1. Open your copy, then select Extensions → Unblockly → Open Unblockly.

2. A sidebar loads all AI formulas (AI_SEARCH(), COMPANY_INFO(), PEOPLE_EMAIL() & friends).

3. Formulas inside the template will refresh automatically once enabled.

   
   

4. Prospect Like a Pro

• Type a keyword (e.g., “FinTech, Series A, USA”) into the AI Search input.

• Let the sheet populate company domains, headcount, and LinkedIn URLs.

• Use People Search to surface decision-makers; fetch emails with one formula.

• Add personalized columns (icebreakers, first-line hooks) and sync to your CRM or mail-merge platform.

Real-World Workflows

Sales Development

1. Filter companies by ICP criteria.

2. Enrich contacts & emails.

3. Export a ready-to-send CSV for sequencing tools.

Recruiting

• Search for candidates with specific skills, seniority, or location.

• Pull LinkedIn profiles and current employers into a shortlist.

Partnerships & BizDev

• Identify complementary tools in your niche.

• Grab founder emails for warm intros.

Tips to Level-Up Your Sheet

• Freeze the first row for quick scrolling through long lists.

• Combine AI formulas with native Sheets functions (FILTER, SORT, UNIQUE) for advanced targeting.

• Color-code stages (New, Contacted, Qualified) to visualise pipeline health.

• Schedule a weekly refresh with Apps Script triggers so your data never goes stale.

Frequently Asked Questions

Is the extension really free?
Yes — core search and enrichment features cost nothing. Premium data add-ons may be introduced later, but the current tool is free to install and use.

Does it work with Google Workspace domains?
Absolutely. Admins can push the add-on to every user via the Workspace Marketplace.

What about email deliverability?
CLAY verifies each email before it reaches your sheet, reducing bounce risk. Still, follow best practices (warm-up domains, include unsubscribe) for bulk outreach.

Can I use it with other CRMs?
Anything that imports CSVs or connects to Google Sheets will work — HubSpot, Pipedrive, Airtable, and more.

Ready to Try It?

1. Install Extension – two clicks and you’re done.

2. Copy the Template – hit the ground running with pre-built formulas.

3. Start Prospecting – build richer lists, faster, right inside Google Sheets.

Stop juggling tabs and start building relationships—the easy way with CLAY.