How to Install Derrick on Google Sheets

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

1. Open any Google Sheet
2. Go to Extensions → Add-ons → Get add-ons
3. Search "Derrick" in the marketplace
4. Click Install + accept the OAuth permissions
5. 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

1. Extensions → Derrick → Activate
2. Sign in with your work email (Google or Microsoft SSO)
3. Free tier auto-activated: 100 credits/month, credits roll over
4. 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:

1. Paste a list of 10 LinkedIn URLs in column A
2. Select the cells
3. Extensions → Derrick → Find Email
4. Choose target column (B)
5. 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.