So, you want to run cold outreach that actually gets replies—but you don’t want to spend hours hand-crafting emails or getting lost in some overpriced CRM. You’re in the right place. This guide is for anyone who wants to automate a simple, effective outreach process using Google Sheets and Texau—without losing their mind (or their budget).
Here’s how you do it, step by step, with honest notes about what matters and what’s just fluff.
Step 1: Get Your Tools Ready
You don’t need a fancy stack. Here’s what you’ll actually use:
- Google Sheets: Free, easy, and shareable. This is your master list.
- Texau: An automation tool that can scrape data, send messages, and connect with other platforms. It’s not magic, but it’s handy.
- A Gmail account (or similar): For sending emails.
- A clear offer: No, really—don’t skip this. If you’re just “touching base,” you’re wasting everyone’s time.
Pro tip: Don’t bother with 10 different tools just because some blog said you should. You can always add bells and whistles later.
Step 2: Build a Solid Prospect List
The quality of your outreach lives and dies here. Garbage in, garbage out.
How to Put Together a Good List
- Define your target: Be specific. “Marketing managers at SaaS companies in the US with 10-50 employees” is good. “Anyone with an email” is lazy.
- Find prospects:
- Use LinkedIn search, Crunchbase, or even Google to find people who fit.
- Don’t buy a sketchy list—half those emails will bounce or go to spam.
- Gather the data:
- Name
- Company
- Role
- Email (double-check it)
- LinkedIn profile URL (if you’re using Texau for LinkedIn)
- Any custom fields for personalizing your outreach (e.g., last blog post, mutual connection)
How to get this into Google Sheets: - Just create columns for each field. Nothing fancy. - Paste the data in manually, or use tools like Hunter.io or Apollo to find emails (if you must).
Honest take: If you’re scraping 1,000 names and blasting them all, expect to get ignored or flagged as spam. Start small, focus on quality.
Step 3: Clean and Prep Your Data
Don’t skip this. Messy data means embarrassing mistakes (“Hi [First Name],” anyone?).
- Check for duplicates: Use Google Sheets’ “Remove duplicates” feature.
- Standardize columns: Make sure every row has the info you need. If you’re missing emails, fix that now.
- Personalization fields: Add at least one field you can use to make your emails less generic.
Pro tip: Send yourself a test row. If it looks off, your prospects will notice.
Step 4: Set Up Texau to Automate Outreach
This is where Texau comes in. If you’ve never used it, start with a test run. Don’t expect it to be plug-and-play—there’s a learning curve, but it’s not rocket science.
Connect Google Sheets to Texau
- Create a new Google Sheet with your cleaned list.
- In Texau, choose the automation (“spice”) you want.
- For LinkedIn: Try “LinkedIn Message Sender” or “LinkedIn Connection Request Sender.”
- For email: Use “Email Sender via Gmail” or similar.
- Set up the integration:
- In Texau, select Google Sheets as your data source.
- Connect your Google account and point Texau to the right sheet and tab.
- Map your columns.
- Make sure Texau knows what each column means (name, email, etc.).
- If you have personalization fields, map those too.
What to ignore: Don’t waste time on every single automation Texau offers. Focus on the ones that actually move the needle—messaging and connection requests.
Step 5: Write Your Outreach Messages
Don’t overthink this, but don’t sound like a robot either.
- Personalize where you can: Use their name, company, or recent work.
- Be clear and concise: Why are you reaching out? What’s in it for them?
- Have a call to action: Even if it’s just “Let me know if you’re interested.”
- Keep it short: Nobody’s reading a wall of text from a stranger.
Bad example:
Dear Sir/Madam,
I hope this message finds you well. I wanted to reach out to discuss potential synergies...
Good example:
Hey Sarah,
Saw your team just launched the new app—congrats! Quick question: are you open to chatting about ways to speed up user onboarding?
Pro tip: Send your draft to a friend. If they cringe, rewrite it.
Step 6: Configure Texau to Send Your Messages
- Set up the “spice” in Texau for your chosen channel.
- For LinkedIn, you’ll need to connect your account (Texau will walk you through the steps).
- For email, connect your Gmail account. Be careful not to blast too many emails at once—Google will notice.
- Upload your message template.
- Use Texau’s templating: e.g., “Hi {{firstName}}, I liked your recent post on {{topic}}...”
- Choose your sending limits.
- Start slow: 20–30 messages per day. Ramp up only if you’re not getting flagged.
- Run a test with a small batch.
- Check for errors, weird formatting, or personalization fails.
- Go live with the full batch.
- Monitor as you go. Don’t just “set and forget.”
What doesn’t work: Sending the same message to 500 people. You’ll get spam complaints, and LinkedIn or Gmail will throttle you.
Step 7: Track Replies and Follow Up
Automation gets you started. Real conversations bring results.
- Replies: Set up your inbox or LinkedIn to flag replies. Texau can’t have a human conversation for you.
- Follow-ups: Not everyone replies to the first message. Use a simple column in Google Sheets to mark who’s replied, and schedule a polite follow-up (manually or with a Texau sequence, if you’re comfortable).
- Update your sheet: Keep it simple. Status columns like “Contacted,” “Replied,” “Followed Up” are enough.
Honest take: The best responses come from people you actually engage with, not just “automated touchpoints.” Don’t be a robot.
Step 8: Measure, Tweak, and Repeat
There’s no perfect script or tool. It’s all trial and error.
- Measure what counts: Response rate, meetings booked, not just “messages sent.”
- Tweak your message: If nobody’s replying, change it up.
- Clean your list: Remove bounced emails and people who never reply.
- Iterate: Make small changes—don’t overhaul everything at once.
Ignore: Fancy dashboards or endless A/B testing if you’re just starting. Focus on actually talking to people.
Keep It Simple and Iterate
Cold outreach isn’t magic. It’s a straightforward process: find the right people, send a real message, and follow up. Texau and Google Sheets are just tools—they won’t save a bad offer, or fix lazy messaging. Start small, get feedback, and improve as you go. Most people overcomplicate this stuff. Don’t be one of them.