GTMMAXINGby BAGS

Developers: Google Sheets

Find work emails in Google Sheets

Paste one script and your sheet gets two things:

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)

  1. Open your sheet and choose Extensions > Apps Script.
  2. Delete what is there, paste the script, and click Save.
  3. Reload the sheet. A GTMMAXING menu appears.
  4. 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

Full reference: GTMMAXING API.