{"id":24252,"date":"2024-06-07T18:18:45","date_gmt":"2024-06-07T18:18:45","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=24252"},"modified":"2026-02-13T19:09:38","modified_gmt":"2026-02-13T19:09:38","slug":"ai-cold-openers-sheets","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/","title":{"rendered":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)"},"content":{"rendered":"<p>The AI era has made it a lot easier \u2014 <em>a lot<\/em>\u00a0easier \u2014 to create unique, personalized opening lines for cold emails.<\/p>\n<p>Of course, the standard is now higher than ever too; your AI-written openers need to feel genuine, relevant, and insightful so they don\u2019t seem like the work of AI.<\/p>\n<p>The good news: <strong>We can accomplish all that.<\/strong>\u00a0Pretty easily, too.<\/p>\n<p>In this guide, I\u2019ll show you how to use a Google Workspace add-on called <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/gpt_for_sheets_and_docs\/677318054654\">GPT for Sheets<\/a>\u00a0to <strong>research prospects\u2019 websites<\/strong>\u00a0and <strong>write them personalized opening lines<\/strong>\u00a0\u2014 all <strong>inside Google Sheets<\/strong>.<\/p>\n<p>And I\u2019ll also show you how to take the results and <strong>mail merge them into your outreach campaigns with GMass<\/strong>.<\/p>\n<p><em><strong>Note: If you need help installing GPT for Sheets \u2014 or figuring out its complex pricing \u2014 check out our full <\/strong><\/em><em><strong><a href=\"https:\/\/www.gmass.co\/blog\/gpt-for-sheets\/\">guide to GPT for Sheets<\/a> <\/strong><\/em><em><strong>first.<\/strong><\/em><\/p>\n<div class=\"alert alert-info\" style=\"text-align: center;\">Check out our other guides to using GPT for Sheets: <a href=\"https:\/\/www.gmass.co\/blog\/clean-extract-gpt-sheets\/\">Clean data and extract emails<\/a>&#8230; <a href=\"https:\/\/www.gmass.co\/blog\/scrape-prospect-data-gpt\/\">Scraping prospect data<\/a>&#8230; <a href=\"https:\/\/www.gmass.co\/blog\/gpt-grammar-typos\/\">Fixing grammar, typos, and more<\/a><\/div>\n<h2 id=\"gpt-for-sheets-for-u-avfz\">GPT for Sheets for Unique Cold Email Openers: Table of Contents<\/h2>\n<ul>\n<li><a href=\"#using-gpt-for-sheets-ubro\">Using GPT for Sheets to Research Prospects and Write Personalized Messages<\/a>\n<ul>\n<li><a href=\"#researching-a-compan-buan\">Researching a company\u2019s About page then writing a personalized opener<\/a><\/li>\n<li><a href=\"#researching-a-compan-rfec\">Researching a company without providing a URL, then writing an opening line<\/a><\/li>\n<li id=\"using-gpt-for-sheets-ubro\"><a href=\"#fully-scraping-websi-ebyy\">Fully scraping websites, then writing personalized lines based on the results<\/a><\/li>\n<li><a href=\"#researching-prospect-koqy\">Researching prospects\u2019 LinkedIn pages to write personalized openers<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#using-your-ai-genera-bmzw\">Using Your AI-Generated Opening Lines with GMass<\/a><\/li>\n<\/ul>\n<h2>Using GPT for Sheets to Research Prospects and Write Personalized Messages<\/h2>\n<p>GPT for Sheets has <strong>two web scraping features<\/strong>, and I\u2019ve experimented heavily with both of them to generate customized opening lines for cold emails.<\/p>\n<p>The first feature is <a href=\"https:\/\/gptforwork.com\/help\/gpt-for-sheets\/search-web#search-the-web-using-gpt_web\">GPT_WEB<\/a>, which actually searches the internet and reads live websites. GPT for Sheets uses <a href=\"https:\/\/www.perplexity.ai\/hub\/blog\/introducing-pplx-online-llms\">Perplexity AI\u2019s online model<\/a>, not OpenAI\u2019s, for this process.<\/p>\n<p>The other scraping feature in GPT for Sheets is <a href=\"https:\/\/gptforwork.com\/help\/gpt-for-sheets\/search-web#scrape-web-pages\">GPT_SCRAPE<\/a>, which requires some extra setup steps but actually <strong>scrapes the full contents of a web page into a Google Sheets cell<\/strong>. (From there, you can have another function analyze it however you need.)<\/p>\n<p>One gigantic difference: GPT_WEB costs an extra $15 per 1,000 executions, or 1.5 cents per search. That makes it <strong>more expensive than anything else you\u2019ll do with GPT for Sheets<\/strong>\u00a0\u2014 by far.<\/p>\n<p>And, in contrast, <strong>GPT_SCRAPE doesn\u2019t cost <\/strong><em><strong>anything<\/strong><\/em>, not even your tokens. But it has an extra technical setup step and adds more manual work to the process. Plus, you\u2019ll have to use at least <em id=\"researching-a-compan-buan\">some<\/em>\u00a0tokens later on to analyze what you\u2019ve scraped.<\/p>\n<p>I\u2019ll now cover both of these features and how you can use them for prospect and company research.<\/p>\n<h3>Researching a company\u2019s About page then writing a personalized opener<\/h3>\n<p>To prepare for these experiments, I created a Google Sheet featuring 10 American companies that manufacture and sell socks. (Because I was trying to figure out what to use for my example, and I looked down at my feet. Obviously.)<\/p>\n<p>In the Google Sheet, I added a column called CompanyURL, where I linked to each company\u2019s About page.<\/p>\n<p>Then I added a GPT_WEB formula to <strong>create a personalized greeting based on something it found on the page<\/strong>.<\/p>\n<p>The structure for GPT_WEB is <code>=GPT_WEB(research prompt, URL)<\/code>. So here\u2019s what my formula looks like.<\/p>\n<p><code>=GPT_WEB(\"Write a short, conversational intro sentence for an email to this company expressing interest and\/or admiration about something in their history or that they\u2019re doing\",A2)<\/code><\/p>\n<p>Most of the results were exactly what I was looking for; ChatGPT really only got carried away and went off the rails in row 8.<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image3-2.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image3-2.png\" alt=\"Generating openers using the GPT_WEB function\" width=\"1999\" height=\"1289\" \/><\/a><\/figure>\n<p>I\u2019m pretty happy with my results here. It got the assignment right far more than it got the assignment wrong. After a quick spot check, I\u2019d feel comfortable mail merging the output into a cold outreach campaign.<\/p>\n<p>I could also continue playing around with my prompt to try to get even better results.<\/p>\n<p>However, this added up cost-wise: Between trying a few different prompts, just these 10 lines cost me $1.25 in my GPT for Sheets credits. So <strong>for a large contact list, this process could get pricey<\/strong>.<\/p>\n<p>And this <strong id=\"researching-a-compan-rfec\">would not be cheaper if you\u2019re using your own OpenAI API key<\/strong>, as GPT for Sheets sets the GPT_WEB rate at $15 per 1,000 executions regardless.<\/p>\n<h3>Researching a company without providing a URL, then writing an opening line<\/h3>\n<p>So the above example produced solid results.<\/p>\n<p>But it also required me manually finding the About Us page for all the companies. That wasn\u2019t a big deal for 10 companies, but <strong>could be a prohibitive amount of research<\/strong>\u00a0for larger lists.<\/p>\n<p>For my next example, I cut out that step. This time I\u2019m relying here on AI to look up a company, research it, and write an opening line without me providing <em>any<\/em>\u00a0URL.<\/p>\n<p>To do this, I inputted company names in column A. Then in column B, I concatenated a prompt.<\/p>\n<p><code>=\"Write a short, one-sentence, conversational opening line to an email to the sock company \"&amp;A2&amp; \" expressing interest and\/or admiration about something in their history or that they\u2019re doing\"<\/code><\/p>\n<p>In column C, I used the formula <code>=GPT_WEB(B2)<\/code>.<\/p>\n<p>Here are the results.<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image9.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image9.png\" alt=\"Generating openers by having GPT_WEB do all the research\" width=\"1999\" height=\"1327\" \/><\/a><\/figure>\n<p>Once again, <strong>these are not bad at all<\/strong>. I don\u2019t see any hallucinations in there, which is excellent.<\/p>\n<p>The results when I supplied the About page URL felt less generic and would likely be a bit more effective.<\/p>\n<p>However, if you\u2019re looking for a result with less legwork required, this process will certainly get the job done.<\/p>\n<p>I\u2019ll reiterate, though, that <strong>this method will burn through your GPT for Sheets budget <\/strong><em><strong id=\"fully-scraping-websi-ebyy\">significantly<\/strong><\/em><strong>\u00a0quicker<\/strong>\u00a0than any of the other uses.<\/p>\n<p>The next method is a much cheaper approach to this mission.<\/p>\n<h3>Fully scraping websites, then writing personalized lines based on the results<\/h3>\n<p>As I mentioned earlier in this article, there are two ways you can use GPT for Sheets to research websites.<\/p>\n<p>One is the GPT_WEB function, which is efficient but pricey.<\/p>\n<p>The other is GPT_SCRAPE, which adds extra steps but burns through way less of your money.<\/p>\n<p>In my previous examples, I used GPT_WEB. Now let\u2019s try GPT_SCRAPE.<\/p>\n<p><em><strong>You\u2019ll need to follow GPT for Work\u2019s <\/strong><\/em><em><strong><a href=\"https:\/\/gptforwork.com\/help\/gpt-for-sheets\/search-web#prerequisite-install-the-script-in-your-spreadsheet\">instructions<\/a><\/strong><\/em><em><strong>\u00a0for installing a Google Apps Script to get GPT_SCRAPE to work. It only takes a few minutes.<\/strong><\/em><\/p>\n<p>Once you\u2019ve installed the necessary Google Apps Script, it adds a new <strong>Scrape<\/strong>\u00a0menu in Google Sheets. I will use that to scrape the contents of the URLs (the sock companies\u2019 About pages) in Column A into Column B.<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image7-1.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image7-1.png\" alt=\"Scraping websites with GPT for Sheets\" width=\"1999\" height=\"1233\" \/><\/a><\/figure>\n<p>Here are the results (though it\u2019s a little hard to see in this screenshot, GPT_SCRAPE scraped the contents of all 10 About pages as text into Google Sheets cells).<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image5-2.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image5-2.png\" alt=\"Scraped web page results in Google Sheets\" width=\"1999\" height=\"1431\" \/><\/a><\/figure>\n<p>And now I\u2019ll have GPT for Sheets write personalized opening lines based on those scraped results.<\/p>\n<p>For this I\u2019ll use the most basic GPT for Sheets function, simply called <a href=\"https:\/\/gptforwork.com\/help\/gpt-for-sheets\/gpt-functions\/all-available-functions#gpt-function\">GPT<\/a>. It takes the format of <code>=GPT(prompt, value)<\/code>.<\/p>\n<p>I made sure to clarify we were basing the line on a scraped page so the model didn\u2019t get confused about what it was looking at:<\/p>\n<p><code>=GPT(\"Write a short, conversational intro sentence for my email to this company based on their scraped About Us page expressing interest and\/or admiration about something in their history or that they\u2019re doing\", B2)<\/code><\/p>\n<p>Here are the results:<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image1-2.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image1-2.png\" alt=\"Writing opening lines based off scraped websites\" width=\"1999\" height=\"1291\" \/><\/a><\/figure>\n<p>I certainly could play with the prompt a bit here (or switch to a more sophisticated AI model) and possibly get even better results, but once again, <strong>I\u2019m happy with the output<\/strong>.<\/p>\n<p>And the biggest benefit is <strong id=\"researching-prospect-koqy\">this was so much cheaper than using GPT_WEB<\/strong>.<\/p>\n<p>GPT_SCRAPE doesn\u2019t use up your GPT for Sheets tokens, and generating the first lines cost 1 cent.<\/p>\n<h3>Researching prospects\u2019 LinkedIn pages to write personalized openers<\/h3>\n<p>Now that we\u2019ve done unique personalized openers to companies, I was curious if GPT_WEB could <strong>research LinkedIn profiles to write personalized opening lines to individuals<\/strong>.<\/p>\n<p>And the answer is\u2026 apparently, yes. It can do that too.<\/p>\n<p>I put links to my own LinkedIn profile and GMass founder Ajay\u2019s LinkedIn profile in a Google Sheet. Then I used this GPT_WEB prompt.<\/p>\n<p><code>=GPT_WEB(\"Write a friendly 1-sentence opening line to an email to this person based on something on their LinkedIn page\", A2)<\/code><\/p>\n<p>Here\u2019s what I got:<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image8.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image8.png\" alt=\"Writing openers by looking up LinkedIn profiles\" width=\"1999\" height=\"1053\" \/><\/a><\/figure>\n<p>So GPT for Sheets was able to look up a LinkedIn profile, find something notable in the profile, then write an opening line about it.<\/p>\n<p>(Word of caution: I\u2019m not sure if this would work at a massive scale, as I know LinkedIn aims to stop scraping. However, for my small scale test, it worked without issue.)<\/p>\n<p>Once again, since this technique uses GPT_WEB, it could get pricey.<\/p>\n<p>But considering what some services charge to do LinkedIn prospect research and line writing manually (or even with other AI-based products), <strong id=\"using-your-ai-genera-bmzw\">the cost could be pretty reasonable depending on how much time you save<\/strong>.<\/p>\n<h2>Using Your AI-Generated Opening Lines with GMass<\/h2>\n<p>Now that you\u2019ve generated unique opening lines for your prospects \u2014 no matter which of the above approaches you took \u2014 you\u2019re <strong>ready to use them in a campaign<\/strong>.<\/p>\n<p>Because GMass is a cold outreach platform <em>inside<\/em>\u00a0Gmail and has a native integration with Google Sheets, <strong>GMass <\/strong><strong>works hand-in-hand with your GPT for Sheets output<\/strong>.<\/p>\n<p>To start, I <strong>connected my Google Sheet to a new GMass campaign<\/strong>. Then I selected my Google Sheet (and the correct tab within that Google Sheet).<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image4-2.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image4-2.png\" alt=\"Connecting the Google Sheet of openers to a GMass campaign\" width=\"1999\" height=\"1257\" \/><\/a><\/figure>\n<p>Now I can use <strong>mail merge<\/strong>\u00a0to bring in my personal greeting.<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image6-1.png\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image6-1.png\" alt=\"Mail merging in the opening line\" width=\"1999\" height=\"1329\" \/><\/a><\/figure>\n<p>And here\u2019s an example of one of the emails that generates.<\/p>\n<figure style=\"text-align: center;\"><a href=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image2-2.png\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image2-2.png\" alt=\"How the email looks in Gmail drafts\" width=\"1999\" height=\"1154\" \/><\/a><\/figure>\n<p>Want to <strong>try GMass for yourself<\/strong> \u2014 and see why there are <strong>400,000+ happy users<\/strong>\u00a0who rate it an average of <strong>4.8\/5 stars<\/strong>?<\/p>\n<p>It\u2019s <strong>totally free to try<\/strong>\u00a0\u2014 you don\u2019t even need to put in a credit card.<\/p>\n<p>And you can be <strong>up and running in minutes<\/strong>\u00a0by <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/gmass-powerful-mail-merge\/ehomdgjhgmbidokdgicgmdiedadncbgf\">downloading the Chrome extension<\/a>\u00a0and connecting your Gmail or Google Workspace account.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The AI era has made it a lot easier \u2014 a lot\u00a0easier \u2014 to create unique, personalized opening lines for cold emails. Of course, the standard is now\u2026<\/p>\n","protected":false},"author":29,"featured_media":24324,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5428,9155,4261],"tags":[],"class_list":["post-24252","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cold-email","category-email-copywriting","category-google-sheets"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)<\/title>\r\n<meta name=\"description\" content=\"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)\" \/>\r\n<meta property=\"og:description\" content=\"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/\" \/>\r\n<meta property=\"og:site_name\" content=\"GMass Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GmailMailMerge\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2024-06-07T18:18:45+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-02-13T19:09:38+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"2002\" \/>\r\n\t<meta property=\"og:image:height\" content=\"934\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Sam Greenspan\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:site\" content=\"@GMassForGmail\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sam Greenspan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/\"},\"author\":{\"name\":\"Sam Greenspan\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/de82c1ac2f78713b569bb57bfb313c98\"},\"headline\":\"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)\",\"datePublished\":\"2024-06-07T18:18:45+00:00\",\"dateModified\":\"2026-02-13T19:09:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/\"},\"wordCount\":1564,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/gptforsheets-openersfeat-tinified.png\",\"articleSection\":[\"Cold Email\",\"Email Copywriting\",\"Google Sheets\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/\",\"name\":\"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/gptforsheets-openersfeat-tinified.png\",\"datePublished\":\"2024-06-07T18:18:45+00:00\",\"dateModified\":\"2026-02-13T19:09:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/de82c1ac2f78713b569bb57bfb313c98\"},\"description\":\"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/gptforsheets-openersfeat-tinified.png\",\"contentUrl\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/gptforsheets-openersfeat-tinified.png\",\"width\":2002,\"height\":934},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/ai-cold-openers-sheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/\",\"name\":\"GMass Blog\",\"description\":\"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/#\\\/schema\\\/person\\\/de82c1ac2f78713b569bb57bfb313c98\",\"name\":\"Sam Greenspan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g\",\"caption\":\"Sam Greenspan\"},\"url\":\"https:\\\/\\\/www.gmass.co\\\/blog\\\/author\\\/sam_greenspan\\\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)","description":"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)","og_description":"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.","og_url":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/","og_site_name":"GMass Blog","article_publisher":"https:\/\/www.facebook.com\/GmailMailMerge\/","article_published_time":"2024-06-07T18:18:45+00:00","article_modified_time":"2026-02-13T19:09:38+00:00","og_image":[{"width":2002,"height":934,"url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png","type":"image\/png"}],"author":"Sam Greenspan","twitter_card":"summary_large_image","twitter_creator":"@GMassForGmail","twitter_site":"@GMassForGmail","twitter_misc":{"Written by":"Sam Greenspan","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#article","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/"},"author":{"name":"Sam Greenspan","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/de82c1ac2f78713b569bb57bfb313c98"},"headline":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)","datePublished":"2024-06-07T18:18:45+00:00","dateModified":"2026-02-13T19:09:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/"},"wordCount":1564,"commentCount":0,"image":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png","articleSection":["Cold Email","Email Copywriting","Google Sheets"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/","url":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/","name":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)","isPartOf":{"@id":"https:\/\/www.gmass.co\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#primaryimage"},"image":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png","datePublished":"2024-06-07T18:18:45+00:00","dateModified":"2026-02-13T19:09:38+00:00","author":{"@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/de82c1ac2f78713b569bb57bfb313c98"},"description":"How to use the GPT for Sheets add-on to research companies or prospects and write unique cold email openers for them, then mail merge into GMass.","breadcrumb":{"@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#primaryimage","url":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png","contentUrl":"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/gptforsheets-openersfeat-tinified.png","width":2002,"height":934},{"@type":"BreadcrumbList","@id":"https:\/\/www.gmass.co\/blog\/ai-cold-openers-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gmass.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How AI Can Write Unique Cold Email Opening Lines in Google Sheets (New, Easy Method)"}]},{"@type":"WebSite","@id":"https:\/\/www.gmass.co\/blog\/#website","url":"https:\/\/www.gmass.co\/blog\/","name":"GMass Blog","description":"Tips and tricks for sending mail merge and mass email campaigns directly from Gmail","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gmass.co\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gmass.co\/blog\/#\/schema\/person\/de82c1ac2f78713b569bb57bfb313c98","name":"Sam Greenspan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/544dc4a3d6b96b537586cdde9d818feb8f0de187faed221fdb0dee3a356bf41a?s=96&d=mm&r=g","caption":"Sam Greenspan"},"url":"https:\/\/www.gmass.co\/blog\/author\/sam_greenspan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/24252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/comments?post=24252"}],"version-history":[{"count":4,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/24252\/revisions"}],"predecessor-version":[{"id":26033,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/posts\/24252\/revisions\/26033"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media\/24324"}],"wp:attachment":[{"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/media?parent=24252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/categories?post=24252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gmass.co\/blog\/wp-json\/wp\/v2\/tags?post=24252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}