Add your data to Google Sheets.
Make sure the data you want to analyze is ready for the OpenAI prompt.
Updated
Paid plans
Ask Open AI Row-level AI processing
Turn your data into actionable insights using built-in AI.
Start using GPT in Google Sheets →You give
Your list
You get back
- response Here's an analysis of your prospect list...
Demo finished
Run it on your own list
Install Derrick in Google Sheets and enrich your own leads - free to start, no credit card.
Install Derrick - it's free →Try it01 / 05
The output02 / 05
What lands in your columns
1 fields, with a real example of each. You pay when the answer comes back, and never when it does not.
| Field Name | Description | Example |
|---|---|---|
| response | The AI-generated response from OpenAI to your prompt | Here's an analysis of your prospect list... |
Step by step03 / 05
How to use this feature
Get started in 3 simple steps.
Select Ask Open AI
Open the Derrick add-on, choose Ask Open AI, and select the columns to include in your prompt.
Get GPT results instantly
Your sheet fills with AI-generated insights.
When to reach for it04 / 05
Ask Open AI use cases
Run any GPT-4 / GPT-4o prompt directly from a Google Sheets cell - for lead scoring, email drafting, segmentation, summarisation, and anything else AI can do better than Excel formulas.
-
Lead scoring
score every row by AI based on company size + industry + intent - no separate scoring tool needed.
-
Personalised opener
draft a custom first line for every prospect based on their LinkedIn headline.
-
Account summarisation
turn a multi-paragraph company description into a 2-bullet pitch-ready summary.
-
ICP segmentation
classify accounts as A/B/C tier from raw firmographic + tech-stack inputs.
Data Enrichment workflows
Chain actions without technical knowledge. Everything happens in Google Sheet.
These workflows come from phone numbers
For your stack05 / 05
Use Ask Open AI via the API and the MCP
Ask Open AI isn't tied to the Google Sheets sidebar. Every Derrick enrichment - this one included - is also exposed through the REST API and the MCP server, so you can run it from your CRM, your data pipeline, an AI assistant, or any no-code tool (Zapier, Make, n8n). Same credit cost as the add-on, same data. API access is included from the PLUS plan up.
Customer stories
Loved by sales teams worldwide
See what our customers say about Derrick.
"This app saved me so much time and effort. Great for anyone looking to build a contact list or network at scale quickly. As a start-up it's been invaluable."
Alex Clark
Director | SaaS GTM Leader
"Working pretty nifty compared to Snov.Io. Price wise it does give a fair shake, and IMO better interface since it's google sheets."
David Sire
Mortgage Broker at Zero Point Mortgage
"Derrick is a very simple and user-friendly app to enrich your contacts database. Best thing: you can test it for free. And then the price is so low, it's a no brainer."
Etienne Grange
CEO Form'actions
"I have been using other expensive apps or freemium like phantombuster, but Derrick has replaced them all. I love the simplicity of the Google sheet add-in, but what is best is the efficiency it delivers."
Julien Walon Cohen
CEO & Co-founder @ Diffly | B2B Sales Advisor
"Super easy to enrich linkedin urls using this tool. Both personal and company url data can be easily enriched with a click of a button."
Zaid Bilal
RevOps Professional
"Amazing Tool, I would like to advocate this to my colleagues. So that you can get more users. Keep it Up. 5 Stars!"
Asif Hanzala
Lead Generation Specialist at IdeaPeel
"The LinkedIn scraping and email finder combo is incredibly powerful. I can build a complete prospect list with contact info in under an hour. Absolute must-have for outbound."
Michael Kim
SDR Team Lead at CloudScale
"This app is fantastic. Brilliantly created to help small and mid sized businesses."
Dan Hughes
Founder/CEO, AlmanacIO
"Have tested over 10+ LI scraper apps, Derrick beats them all. Simple to use, accurate data, and affordable price."
AJ Alexander
Opportunity Prospector
Calling GPT-4 from inside Google Sheets unlocks an entire category of workflows that used to require a separate scripting environment : lead scoring from free-text bios, automatic classification of CRM notes, extracting structured data from messy LinkedIn headlines, and so on. The two existing options are a dedicated GPT-for-Sheets add-on (its own monthly subscription) and custom Apps Script with hand-coded OpenAI calls.
Derrick gives you a single function - paste a prompt referencing other cells, get the GPT-4 response back. No API key to provision, no rate-limit code to write, no monthly subscription on top of the OpenAI quota. The credit cost is bundled into Derrick's standard plan, billed per call like a regular enrichment. Free up to 100 calls/month, no card. Higher volumes on the Derrick pricing page.
Related : Claude 3.5 in Google Sheets for the workflows where reasoning matters more than raw speed, Derrick MCP integration for AI-driven enrichment pipelines.
Start generating AI insights today
Get clear, usable IA insights without leaving your sheet.
1 Credit per line
Unused credits roll over Keep unused credits for next month
No learning curve Install, click, get results instantly
Do I need to install anything to use Ask Open AI?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, Ask Open AI is one of the workflows available from the Derrick sidebar inside any Sheet. The same feature is also available via REST API and via the Derrick MCP server for Claude / ChatGPT.
Can I use Ask Open AI on a list of 1,000+ rows?
+
Yes - Ask Open AI runs as a batch job inside Google Sheets, with progress tracking and per-row credit accounting. The workflow scales linearly: 10 rows or 10,000 rows, the steps are identical and you can step away while it runs.
Where does the data behind Ask Open AI come from?
+
Derrick aggregates 10+ public-data sources (LinkedIn graph, company websites, registry data, web crawl, third-party providers) and runs a multi-source lookup for Ask Open AI. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is Ask Open AI GDPR-compliant?
+
Yes. Derrick only enriches public data, doesn't store personal records beyond the duration of the lookup, and supports full deletion on request. The Sheets add-on runs inside Google's OAuth-protected environment so your data stays private to your account.
Can I trigger Ask Open AI automatically when I add a row?
+
Yes - set up a Google Sheets onEdit trigger (Apps Script, takes 2 minutes) so a new row in column A automatically runs Ask Open AI into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.