Back to Autobound in Excel
SheetXAI logo
Autobound logo
Autobound · Excel Guide

Bulk Generate Personalized Cold Emails From a Google Sheet Using Autobound

2026-05-13
5 min read

The Scenario

You're an SDR. It's Wednesday morning and your manager just moved the campaign launch up by two days. You've got an Excel workbook with 100 target prospects — first name, job title, company, and LinkedIn URL in the FirstName, Title, Company, and LinkedInURL columns of the ProspectList table — and the PersonalizedEmail column is supposed to hold the cold emails that go into the sequence. It's empty.

The bad version:

  • Open Autobound, enter each prospect's details by hand, copy the generated email, tab back to Excel, find the right row, paste into PersonalizedEmail, check that the name matches, move to the next one.
  • By row twenty you realize you pasted row 19's email into row 18's cell and now you're re-reading every entry to find the others you misplaced.
  • By row fifty your generated emails are getting increasingly generic because you're burning through Autobound's free-form fields faster than you can think of what to put in them.

You're a sales rep. Your job is outreach, not data entry. And the campaign is supposed to go out Thursday.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Excel workbook. It reads the prospect data, talks to Autobound for you, and writes the generated email body back into the column you name.

Read the Excel table 'ProspectList' and use Autobound to generate personalized outreach for each row using FirstName, LastName, Title, Company, and LinkedInURL columns; write the email into the 'PersonalizedEmail' column.

SheetXAI works down the table row by row, calling Autobound with each prospect's details and writing the output into PersonalizedEmail. When it's done, every row has a generated email waiting for your review.

What You Get

  • The PersonalizedEmail column fills with the generated email body for each prospect, matched to the correct row.
  • Rows with missing LinkedInURL values surface a note in PersonalizedEmail rather than a blank — so you know exactly which ones to fill in.
  • The writeback happens in the table you already have open, with no intermediate CSV, no worksheet switching, no copy-paste.
  • You can read through PersonalizedEmail, edit any individual cell, and hand the workbook off to your sequence tool as-is.

What If the Data Is Not Quite Ready

The LinkedInURL column is a mess — some cells have full URLs, some have just the handle, some are blank

For each row in the ProspectList table where LinkedInURL is not blank, use Autobound to generate a personalized sales email; write the email into PersonalizedEmail. For rows where LinkedInURL is blank, write "Missing LinkedIn URL" in PersonalizedEmail.

The company name has variations — "Acme Inc," "ACME," "Acme, Inc." depending on who entered it

Before generating emails, normalize the Company column by stripping punctuation and standardizing case; write the cleaned company name into a new CleanedCompany column, then use that cleaned value when calling Autobound. Write the generated email into PersonalizedEmail.

The prospect list spans two worksheets — "Tier 1" and "Tier 2" — and you need emails for both

For each row in the "Tier 1" worksheet's ProspectList table, use Autobound to generate a personalized email and write it into PersonalizedEmail. Then do the same for every row in the "Tier 2" worksheet's table.

You want cleanup, insight generation, and email generation in one shot

For each row in this workbook: clean up the Company column, use Autobound to get the top company insight for that account, write the insight into TopInsight, then generate a personalized email referencing that insight and write it into PersonalizedEmail.

The cleanup and the content generation happen in a single prompt — you don't have to run three separate passes and reconcile the results.

Try It

Get the 7-day free trial of SheetXAI and open your Excel workbook with prospect names and LinkedIn URLs in the ProspectList table, then ask it to fill the PersonalizedEmail column with Autobound-generated emails. Also worth reading: how to enrich your account list with prospect insights before outreach calls.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more