Google Sheets Outbound Command Center
I will keep adding different google sheets automations so make sure to bookmark this page!
Visit closedwonleads.com for more information

by Matt Herzog

Clearbit API

Google Docs

Clearbit API

Clearbit Company name,Domain Google,<a href="http://google.com">google.com</a> Facebook,<a href="http://facebook.com">facebook.com</a> <a href="http://penske.com">penske.com</a>

Loading...
Workflow
  1. Get Free Company name to domain API key from clearbit
  1. Run this whenever you get a list of company names and no websites
  1. Upload to apollo.io
  1. Use the companies filter then go to the people filter to search your ICP
go to extensions → apps scripts → clearbit.gs to run
Clean Companies names

Google Docs

Clean Companies Name

Clearbit Company name,Domain Google,<a href="http://google.com">google.com</a> Facebook,<a href="http://facebook.com">facebook.com</a> <a href="http://penske.com">penske.com</a>

Loading...
Workflow
  1. Run this whenever you get a list of companies that have special characters or end phrases like "LLC"
go to extensions → apps scripts → cleancompanies.gs to run
Split first and last name

Google Docs

Clean Names

Clearbit Company name,Domain Google,<a href="http://google.com">google.com</a> Facebook,<a href="http://facebook.com">facebook.com</a> <a href="http://penske.com">penske.com</a>

Loading...
Workflow
  1. Use this workflow when a data provider only returns full names or it has weird special characters attached
go to extensions → apps scripts → cleannames.gs to run
Email Permutator

Google Docs

Email Permutator

Clearbit Company name,Domain Google,<a href="http://google.com">google.com</a> Facebook,<a href="http://facebook.com">facebook.com</a> <a href="http://penske.com">penske.com</a>

Loading...
Workflow
  1. Run this when you pull a list from a data provider and you don't receive that many emails back
  1. then take these emails and validate them before sending
go to extensions → apps scripts → permutation.gs to run
Email Validation

Google Docs

Email Validator

Clearbit Company name,Domain Google,<a href="http://google.com">google.com</a> Facebook,<a href="http://facebook.com">facebook.com</a> <a href="http://penske.com">penske.com</a>

Loading...
Workflow
  1. use your own API keys for your email validation tools
  1. Run this workflow to double validate your email list before sending
go to extensions → apps scripts → validator.gs to run
How I can help
  • I can create you custom google sheets like the ones above
  • I can run completely done for you outbound campaigns and book sales calls on your calendar
Book a call here to chat

Cal.com

15 Min Meeting / Closed Won Leads | Matt Herzog | Cal.com

15 Min Meeting / Closed Won Leads

Subscribe to my newsletter where once a month I will go over a sales play that we are seeing success with

Closed Won Leads Newsletter

Closed Won Leads Newsletter

Get an inside look of the outbound engine we've developed over 2 years of generating sales pipeline across startups and Fortune 500 companies

Made with