Outreach Tracker

Have a Sheet Code?

Enter the code for a sheet that's already set up to load it straight away.

1. Connect Your Google Sheet

First time? One-time setup (about 2 minutes)
  1. Open your contacts Google Sheet. Row 1 must be the column headers (for example First Name, Last Name, Company, Title, LinkedIn URL, Messaged, Opened?).
  2. In the sheet, go to Extensions → Apps Script. Delete what's in Code.gs and paste in the script below. Click Save.
    View script
  3. Click Deploy → New deployment. Click the gear next to "Select type" and choose Web app. Set Execute as: Me and Who has access: Anyone, then click Deploy.
  4. Google will ask you to authorize. Pick your account; if you see "Google hasn't verified this app", click Advanced → Go to (project name) and Allow. This is your own script, so this is expected.
  5. Copy the Web app URL (it ends in /exec) and paste it below together with your sheet's URL.

If the same person is on several tabs, marking them on one tab marks them on all of them (the script keeps a shared Outreach Status tab). To fill it from what's already marked, reload the sheet and use Outreach Tracker → Build status from all tabs.

The script can only read and write the sheet it is attached to. Anyone who has the Web app URL can read that sheet, so keep the URL private, or set a TOKEN at the top of the script and enter it below. If you edit the script later, use Deploy → Manage deployments → Edit → New version so the URL stays the same.

2. Your Message

Tags (click to insert):
Preview with the first contact

      

3. Contacts

Your contacts will show up here. Enter a sheet code above, or open 1. Connect Your Google Sheet and click Load contacts.