Developers: Google Sheets
Find work emails in Google Sheets
Paste one script and your sheet gets two things:
=GTM_EMAIL(A2)returns the work email for the LinkedIn URL inA2.- GTMMAXING > Find emails for selected cells enriches a whole column, shows you the price first, and writes email and verdict next to it.
Cost: 1 credit per email found, up to 3 with verification. Misses are free, and recalculating a cell your account already paid for is free.
Install (2 minutes)
- Open your sheet and choose Extensions > Apps Script.
- Delete what is there, paste the script, and click Save.
- Reload the sheet. A GTMMAXING menu appears.
- Choose GTMMAXING > Set API key and paste a key from API keys. Google asks you to authorize the script the first time.
Use it
One cell: type =GTM_EMAIL(A2), or =GTM_EMAIL(A2, TRUE) to also verify the mailbox.
Drag it down the column like any formula.
A whole column: select the LinkedIn URLs, then GTMMAXING > Find emails for selected cells. You get a free quote with your balance and confirm before anything is spent. Email goes in the next column and the verdict in the one after. It sends 100 profiles per request and handles any number of rows.
The bulk action is the better choice for more than a few dozen rows. Custom functions have a 30-second limit per cell, while the menu action can run for up to 6 minutes.
Notes
- The key is stored in the script’s properties, so anyone who can edit this script can use it. Use a dedicated token with a low credit cap, and revoke it from API keys when you are done.
- Results are cached for 6 hours to keep recalculation fast.
- Every request carries an idempotency key built from its inputs, so retries never charge twice.
Full reference: GTMMAXING API.