Add your data to Google Sheets.
Create a column with G2 product names (e.g. Notion, Airtable) and ensure they match how they appear on G2.
Updated
Paid plans
G2 Insight Software review lookup
Retrieve reviews and product information for your prospects’ tools.
Start pulling G2 insights in Google Sheets →You give
Your list
You get back
- categories Marketing Automation Software
- Averagerating 4.5
- LookaLike Competitors HubSpot, Pipedrive
+2 reviews count, star distribution
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
5 fields, with a real example of each. You pay when the answer comes back, and never when it does not.
| Field Name | Description | Example |
|---|---|---|
| categories | G2 product category classification | Marketing Automation Software |
| Averagerating | Average star rating of the product on G2 | 4.5 |
| LookaLike Competitors | Competing products in the same G2 category | HubSpot, Pipedrive |
| reviews count | Total number of reviews on G2 | 1247 |
| star distribution | Distribution of reviews by star rating | 5:850|4:120|3:124|2:12|1: 80 |
Step by step03 / 05
How to use this feature
Get started in 3 simple steps.
Select G2 Insight
Open the Derrick add-on, choose G2 Insight, and select the columns to enrich.
Get review insights instantly
Your sheet fills with ratings and summary insights.
When to reach for it04 / 05
G2 Insight use cases
G2 Insight is a Derrick workflow that runs natively inside Google Sheets (plus REST API + MCP server). It pulls the data class you need and writes it back into the sheet your team already lives in - no CSV exports, no separate web app.
-
ICP-fit scoring
feed g2 insight into your scoring model as a live signal.
-
Pre-outreach prep
enrich your list with g2 insight before the campaign launches.
-
Daily account-research
pull g2 insight on every account in your morning queue.
-
CRM hygiene
keep g2 insight fresh on existing records to avoid stale-data costs.
Data Enrichment workflows
Chain actions without technical knowledge. Everything happens in Google Sheet.
These workflows come from company data
For your stack05 / 05
Use G2 Insight via the API and the MCP
G2 Insight 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
Pulling G2 ratings + reviews into a spreadsheet is the missing piece in B2B competitive intelligence : you can map your prospect's existing tools, see what they're complaining about, and frame your pitch around the exact pain points G2 reviews already surface. Most teams approach this by hand - opening each G2 product page, copy-pasting the rating, then writing notes.
Derrick reads a column of company names or G2 product URLs directly from Google Sheets and returns the average rating, total review count, top-3 pros, and top-3 cons in the next 6 cells. Useful pattern : enrich your CRM's "current stack" field with G2 data, then prioritise outreach to accounts whose current tool has a low G2 score. Per-credit cost on the Derrick pricing page.
Related : G2 rating from a company name recipe, G2 review snippet recipe. Tool comparison context : Clay review covers waterfall-enrichment alternatives.
Start extracting G2 insights today
Access the G2 signals you need instantly.
2 Credits 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 G2 Insight?
+
Just the Derrick Google Sheets add-on (one click, no API keys, no developer setup). Once installed, G2 Insight 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 G2 Insight on a list of 1,000+ rows?
+
Yes - G2 Insight 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 G2 Insight 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 G2 Insight. The first source that returns a confident match wins; if no source is confident enough, the cell is left blank rather than guessed.
Is G2 Insight 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 G2 Insight 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 G2 Insight into column B. Pair with Zapier / Make / n8n to push CRM contacts directly into the sheet for hands-free enrichment.