Google Sheets Enrichment 2 min read
Installing Derrick on Google Sheets takes 30 seconds. Once done, you can enrich emails, phones, LinkedIn URLs, company data - all from inside your spreadsheet, no copy-paste, no other tool.
Step-by-step guide for 2026.
Step 1: Install the add-on
- Open any Google Sheet
- Go to Extensions → Add-ons → Get add-ons
- Search "Derrick" in the marketplace
- Click Install + accept the OAuth permissions
- Reload your sheet - Derrick appears under Extensions menu
Required permissions: Sheets access (to read your data + write enrichment columns) + outbound network calls (to call Derrick API). No access to other Google services.
Step 2: Activate your account
- Extensions → Derrick → Activate
- Sign in with your work email (Google or Microsoft SSO)
- Free tier auto-activated: 100 credits/month, credits roll over
- Verify your email if prompted (5-second confirm click)
Note: no credit card required for the free tier. You can run 100 enrichments (email, phone, LinkedIn lookup) before any pay decision.
Step 3: Run your first enrichment
Test workflow with 10 leads:
- Paste a list of 10 LinkedIn URLs in column A
- Select the cells
- Extensions → Derrick → Find Email
- Choose target column (B)
- Hit Run - enrichment runs in ~30 seconds
You'll see results pour into column B as they come back. Each verified email = 1 credit. Nulls (no email found) = 0 credit charged.
Troubleshooting + Key takeaways
Common issues
- "Add-on not loading" - usually a browser cache issue. Hard reload (Cmd+Shift+R) + reopen the sheet.
- "Permission denied" - re-accept OAuth: Extensions → Add-ons → Manage → Derrick → Options.
- "Quota exceeded" - you hit your monthly credits. Upgrade or wait for next month rollover.
- "Empty results" - check the input format (URLs should be full https://, names should be First + Last).
Key takeaways
- Installation is 30 seconds: Extensions → Add-ons → search "Derrick" → install.
- Free tier: 100 credits/month, no credit card. Enough to validate the workflow on real prospects.
- Pay-per-verified-match only - null results don't burn credits.
- First enrichment in <2 minutes - paste 10 URLs, hit Find Email, watch results populate.
- OAuth scope is minimal: Sheets + outbound API calls only. Zero access to Gmail, Drive, Calendar.
Frequently asked questions
Combien de temps faut-il pour installer Derrick sur Google Sheets ?
About 30 seconds. Open any Google Sheet, go to Extensions, then Add-ons, then Get add-ons, search "Derrick", click Install and accept the OAuth permissions. After reloading the sheet, Derrick appears in the Extensions menu and you can run your first enrichment within 2 minutes.
Derrick fonctionne-t-il sur mobile (iPhone/Android) ?
Derrick is a Google Sheets add-on, and add-ons run in the desktop browser version of Google Sheets. To install Derrick and launch enrichments, use Sheets on a computer. Since results are written directly into the spreadsheet, you can still view your enriched data from the Google Sheets mobile app afterwards.
Puis-je installer Derrick si j’ai un compte Google Workspace professionnel ?
Yes, Derrick is built for work accounts: you activate it by signing in with your work email through Google or Microsoft SSO. The only caveat is that some Workspace admins restrict add-on installs from the marketplace. If the Install button is blocked, ask your admin to allow the Derrick add-on for your organization.
Quelles autorisations Derrick demande-t-il et pourquoi ?
Two scopes only: access to your Sheets, to read your input data and write the enrichment results into your columns, and outbound network calls, to reach the Derrick API. Derrick requests zero access to your other Google services - no Gmail, no Drive, no Calendar.
Que faire si Derrick n’apparaît pas dans le menu Extensions après installation ?
It is usually a browser cache issue. Do a hard reload (Cmd+Shift+R on Mac, Ctrl+Shift+R on Windows) and reopen the sheet. If you see a permission error instead, re-accept the OAuth authorization via Extensions, then Add-ons, then Manage, then Derrick, then Options.
Derrick est-il gratuit ou payant ?
Both. The free tier activates automatically with 100 credits/month, no credit card required, and unused credits roll over. Each verified result costs 1 credit, and null results are never charged. You can run 100 enrichments per month before deciding whether to upgrade to a paid plan.
Puis-je désinstaller Derrick facilement si je ne suis pas satisfait ?
Yes. Like any Google Sheets add-on, you remove it via Extensions, then Add-ons, then Manage add-ons, then Uninstall on Derrick. Your spreadsheet is untouched: all the data already enriched stays in your columns.
Derrick fonctionne-t-il avec Excel ou seulement avec Google Sheets ?
Derrick runs as a Google Sheets add-on, so it works inside Google Sheets only. If your data lives in Excel, import the file into Google Sheets first (File, then Import) and run your enrichments there. You can always export the enriched sheet back to .xlsx afterwards.
Continue exploring this cluster
Start enriching your sheet in 30 seconds
Free for 100 credits/month. No credit card.
Install Derrick free →