The Scenario
You are a content marketer. You have 50 company descriptions in a Google Sheet, one per row in column A, written in bland corporate language pulled from LinkedIn company bios. You need each one rewritten as a personalized LinkedIn outreach opening line, ready for your SDRs to paste into connection requests this week.
The briefs are due by Wednesday at noon. It is Tuesday at 2 PM.
The bad version of Tuesday afternoon:
- You open ChatGPT and paste the first company description
- You type a prompt asking it to write an opening line
- The output is generic and sounds like every other AI-written opener
- You adjust the tone prompt and try again
- You do this for six companies before realizing you have 44 left and three hours
- You write the remaining ones yourself, inconsistently, getting worse as you go
- You deliver 50 openers on Wednesday morning with noticeably different quality across the batch.
The fast version is one prompt and SheetXAI handles all 50.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can send each row in your column to PhantomBuster AI completions and write the output back into column B, so you never leave the sheet.
Open the SheetXAI sidebar and type:
For each company description in column A, 50 rows, send the text to PhantomBuster AI completions with the prompt "Write a personalised LinkedIn outreach opener for this company:" and write the result into column B.
SheetXAI reads each row, sends the text to PhantomBuster AI with your instruction, and writes the generated opener back into column B. Fifty rows, fifty openers, consistent quality across the whole batch.
What You Get
Column B filled with 50 personalized LinkedIn opening lines, one per company:
- Each one grounded in the specific company description in column A
- Consistent format and length across the batch
- Ready to hand to SDRs without further editing
The openers are as specific as the descriptions you gave. The more concrete the input in column A, the sharper the output in column B.
If a batch of openers is too formal or too casual, tell SheetXAI to re-run column A rows 20-35 with a different tone instruction. You adjust by row range without starting over.
What If the Data Is Not Quite Ready
Company descriptions scraped from LinkedIn are rarely usable as-is. SheetXAI cleans them before sending to PhantomBuster AI.
When the descriptions are in inconsistent formats
Some rows are full sentences, some are comma-separated keyword lists, some are fragments. The AI completions quality will be uneven without normalization.
For each row in column A, first normalize the company description into two clean sentences before sending to PhantomBuster AI completions. Then write the resulting LinkedIn opener into column B.
When you want a different output format for some rows
Your SDRs have two templates: one for founders and one for heads of sales. The company description in column A tells you which role to target.
For each company description in column A, check if the description mentions "founder-led," "bootstrapped," or "founder." If yes, write an opener in column B directed at a founder. If no, write an opener directed at a head of sales. Use PhantomBuster AI completions for each.
When some descriptions are too short to generate a useful opener
A batch of 8 rows have descriptions under 10 words. The AI cannot do much with "B2B SaaS. Series A."
For each company description in column A, if the description is fewer than 15 words, write TOO SHORT in column B and skip the AI call. For all other rows, send to PhantomBuster AI completions with the opener prompt and write the result into column B.
When you need to clean the descriptions, generate openers, and score them for quality in one go
You want to hand a ready-to-use sheet to the SDR team with openers already graded.
For each row in column A, normalize the company description into two clean sentences. Send the normalized version to PhantomBuster AI completions with "Write a personalized LinkedIn outreach opener for this company, under 25 words, conversational tone." Write the result into column B. In column C, write SHORT if the opener is under 15 words, GOOD if 15-25 words, LONG if over 25 words.
The pattern: the whole batch runs in one prompt. You review the output in the sheet, not one generation at a time in a chat window.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of text descriptions, then ask it to run PhantomBuster AI completions row by row and write the results back. The PhantomBuster integration is included in every SheetXAI plan. For related workflows, see how to export leads from PhantomBuster storage to a sheet or the PhantomBuster in Google Sheets overview.