If<\/em>\u00a0you know the right way to use them.<\/p>\n While GPT for Sheets is popular (as are the other related products under the GPT for Work umbrella, like GPT for Docs), there are aspects of the setup and usage that aren\u2019t quite beginner-friendly.<\/p>\n In this article, I\u2019ll cover how to set up GPT for Sheets<\/strong>. I\u2019ll also do my best to clear up the pricing<\/strong>\u00a0(it\u2019s complex) and go over some of the best use cases for cold emailers.<\/p>\n GPT for Sheets is part of a suite of tools called GPT for Work (which also includes GPT for Google Docs, Microsoft Word, and Microsoft Excel).<\/p>\n Here\u2019s the macro-level summary of GPT for Sheets: It introduces Google Sheets formulas that do things you would\u2019ve once assigned to a person.<\/strong><\/p>\n For instance, in the past, if you wanted to write a Google Sheets formula to extract and properly format email addresses out of a column of mismatched data, that would require regular expressions (or other sophisticated methods) \u2014 and still might not work all that great.<\/p>\n So, odds are, you would\u2019ve spent your own time doing it \u2014 or assigned the job to a virtual assistant who could manually go through the spreadsheet and clean up the data.<\/p>\n With GPT for Sheets, you just use a formula called GPT_EXTRACT and tell it to find the \u201cemail address.\u201d<\/p>\n ChatGPT can \u201cthink\u201d well enough<\/strong> to pull the email address out of almost any mangled data field you throw at it.<\/p>\n Here\u2019s how to install, then activate, GPT for Sheets in your Google account.<\/p>\n You can install GPT for Sheets by going to the Google Workspace Marketplace<\/a>, searching for GPT for Sheets, then clicking the Install<\/strong>\u00a0button.<\/p>\n Give the app the requisite permissions, then open a Google Sheet.<\/p>\n In the Extensions<\/strong>\u00a0menu, go to the GPT for Sheets and Docs menu item, and click Enable GPT Functions<\/strong>.<\/p>\n You\u2019ll now be able to use GPT for Sheets.<\/p>\n I\u2019ll get into this more in the pricing section of this article, but you have two primary options for how you get ChatGPT to power GPT for Sheets<\/strong>.<\/p>\n You can either not provide an OpenAI API key, and just lean on GPT for Sheets to cover the cost of ChatGPT \u2014 for which they charge you a nice little premium.<\/p>\n Or you can provide your own OpenAI API key, at which point you\u2019ll be paying two different entities to use GPT for Sheets. You\u2019ll pay GPT for Sheets for their tokens, then pay OpenAI for theirs as well.<\/p>\n As I cover in the pricing section, providing your own OpenAI API key should save you some money. However, it adds a big step, complicates costs and bookkeeping, and will slow down the process of getting started.<\/p>\n Still, if you do<\/em>\u00a0want to provide your own key, here\u2019s how you do it.<\/p>\n You\u2019ll need to generate and grab a key inside your OpenAI account<\/strong>.<\/p>\n Go to your OpenAI account<\/a>\u00a0and click API Keys in the sidebar. Then choose Create new secret key<\/strong>.<\/p>\n Copy the key, then head back to Google Sheets. Open the GPT for Sheets add-on.<\/p>\n Open the menu, then click API keys<\/strong>.<\/p>\n Paste in your OpenAI key, then click Save<\/strong>.<\/p>\n You\u2019ll now be able to use your own OpenAI key to save costs<\/strong> (and avoid shared rate limits).<\/p>\n And speaking of costs, time to address the biggest question of all surrounding GPT for Sheets\u2026<\/p>\n The pricing for GPT for Work is more than a bit confusing, especially if you aren\u2019t up on things like API keys and\/or the latest developments in the generative AI universe.<\/p>\n Plus, GPT for Sheets was initially a free product (where you just had to provide an OpenAI API key, which you paid for separately). It switched to a paid model in early 2024.<\/p>\n The costs aren\u2019t broken down very clearly on the pricing page of the GPT for Work website<\/a>, and when they do talk costs, it\u2019s in units of measurement like packs and tokens \u2014 so there\u2019s some decoding required on your end.<\/p>\n To use GPT for Sheets with OpenAI (ChatGPT), you need to buy a pack of GPT for Sheets\u2019 tokens.<\/p>\n (Note: Though \u201ctokens\u201d is technically correct, they probably could\u2019ve avoided confusion by picking a different term for what they\u2019re selling. Essentially you have to convert these tokens to OpenAI tokens; GPT for Sheets tokens are like tokens on top of actual generative AI tokens. Like if you were buying soybeans from a supplier, and you had to buy something called \u201csoybeans\u201d from them, but those soybeans were just middleman stand-ins for the actual soybeans and didn\u2019t necessarily convert 1:1 to actual soybeans.) <\/em><\/p>\n Generating one English word takes roughly 1.3 tokens, according to this study<\/a>. A basic prompt and response will probably run you at least 40 to 50 tokens. (But again, GPT for Sheets tokens don\u2019t always mean 1:1 OpenAI tokens.)<\/p>\n GPT for Sheets sells tokens by the millions, so your pack will probably last a while \u2014 but if GPT for Sheets becomes a tool you use daily and\/or on large data sets, you\u2019ll burn through them.<\/p>\n The lowest-priced pack is 29 million GPT for Sheets tokens for $29. Tokens expire after one year.<\/p>\n So let\u2019s dig into the two ways you can use your GPT for Sheets tokens.<\/p>\n You can start using your tokens right away without providing your own OpenAI API key. That means GPT for Work will be funding your AI calls<\/strong>.<\/p>\n They charge you a lot for that service<\/strong>, especially if you\u2019re using more sophisticated GPT models.<\/p>\n As of press time, your 29 million tokens are reduced down to 11.6 million tokens of gpt-3.5-turbo use, or 829,000 tokens of gpt-4-turbo use.<\/p>\n Another downside: According<\/a>\u00a0to GPT for Work, if you don\u2019t bring your own API key \u201cyou will share rate limits with other GPT for Work users.\u201d Meaning there\u2019s a risk if too many people are using this add-on in one day, Google could cut it off.<\/p>\n If you provide your own OpenAI API key, your GPT for Sheets tokens are also reduced below 1:1 in most cases, though a lot less so<\/strong>.<\/p>\n You\u2019ll get the full 29 million tokens of gpt-3.5-turbo, or 5.8 million tokens of one of the gpt-4 models.<\/p>\n But\u2026 you\u2019ll also be paying OpenAI<\/a>.<\/p>\n For instance, if you want to use gpt-4-turbo, they\u2019ll charge you $10 for 1 million tokens of inputting commands and $30 for 1 million tokens of outputted results. Gpt-3.5-turbo is just 50 cents for 1 million tokens of input and $1.50 for 1 million tokens of output.<\/p>\n And this<\/em>\u00a0is why I said the pricing is more than a bit confusing.<\/p>\n Even though you\u2019re paying two different providers, it\u2019s still likely going to be cheaper to take this approach than using GPT for Sheets without providing an OpenAI key<\/strong>.<\/p>\n Also note: You\u2019ll need to provide your own API key if you want to use the GPT_VISION function in GPT for Sheets, which is the function that can analyze images.<\/p>\n If you want to use the GPT_WEB function in GPT for Sheets, which searches the web for information, that\u2019s charged separately on executions and not with tokens. It\u2019s $15 for 1,000 executions.<\/p>\n Also, I found as I used GPT for Sheets that if I did something like adding a column or even making one small tweak, GPT for Sheets would re-run all of the formulas on my sheet<\/strong>.<\/p>\n So if you\u2019re not really careful, you could wind up paying multiple times. I recommend after you get satisfactory results from running a GPT for Sheets formula, copy the results into a new column and delete the column with the formulas.<\/p>\n And finally, you don\u2019t have to pay for GPT for Sheets tokens if you provide an API key from a non-OpenAI GPT, like Mistral AI or Claude. You\u2019ll just need to pay for one of those services. (Here\u2019s Mistral\u2019s pricing<\/a>\u00a0and here\u2019s Claude\u2019s<\/a>.)<\/p>\n It\u2019s tough to estimate exactly how many tokens you\u2019ll need from both GPT for Sheets and OpenAI until you try this out in real world examples. GPT for Sheets has a cost estimating calculator<\/a>, but I didn\u2019t find it helpful at all at estimating costs.<\/p>\n I can tell you what it cost me to put together various tutorials, which will hopefully give you a benchmark.<\/p>\n Clean up and extracting emails from some jumbled data wound up costing pennies.<\/p>\n Scraping data from a website and extracting data also cost pennies.<\/p>\n Searching the web than writing lines based on what it found came closer to costing dollars (or at least quarters).<\/p>\n Ultimately \u2014 and this is based on very<\/em>\u00a0rough estimates from all my experiments \u2014\u00a0I\u2019d say if you\u2019re an active cold emailer working with thousands of contacts every month, your $29 in GPT for Sheets tokens would probably last about a month or two<\/strong>.<\/p>\n But\u2026 the adventures through the pricing labyrinth will be worthwhile if GPT for Sheets can achieve its stated goal of saving you time.<\/p>\n And when it comes to different tasks throughout the cold outreach process, the add-on certainly can<\/em>\u00a0help you out considerably.<\/p>\n Some of the best ways GPT for Sheets can save you time in cold email<\/strong>\u00a0are:<\/p>\n Drop a list of inconsistently and\/or inaccurately formatted email addresses into a Google Sheet and GPT for Sheets can clean them up, standardize them, and eliminate lots of manual work<\/strong>.<\/p>\n GPT for Sheets can also dig people\u2019s names out of your data<\/strong>, find and universally format things like phone numbers or currencies<\/strong>, and otherwise prep your contact info<\/strong>\u00a0before you start a campaign.<\/p>\n All these are big time savers. In the past they probably would\u2019ve required manual work (from you or a virtual assistant) or super complicated regex formulas. AI makes it all a whole lot easier.<\/p>\n Check out our guide to how to quickly clean data and extract email addresses (and more) with GPT for Sheets<\/a> for a full walkthrough.<\/p>\n GPT for Sheets can visit a website, then read the contents of that website and write personalized lines about what it finds<\/strong>.<\/p>\n This can be good for personalized opening lines<\/strong>, identifying pain points<\/strong>, writing tailored calls-to-action<\/strong>, and more.<\/p>\n Check out our guide to using GPT for Sheets to research websites and prospects, then write unique cold email opening lines<\/a>.<\/p>\n There\u2019s a scraping function on GPT for Sheets where it can scrape the contents of a web page<\/strong>\u00a0into a cell in your Google Sheet.<\/p>\n Also, there\u2019s a function that can analyze the contents of an image<\/strong>\u00a0\u2014 so it could pull addresses and other info off an image of a PDF.<\/p>\n From there, you can use GPT for Sheets\u2019 functions on that content any way you need. Prospect names and email addresses<\/strong>. Identify company achievements. Whatever you need, it will find, analyze, and utilize.<\/p>\n Here’s our complete guide to using GPT for Sheets for prospecting<\/a>.<\/p>\n GPT for Sheets can write unique email copy for each contact<\/strong>.<\/p>\n Whether you just want it to \u201cspin\u201d a line you provide, or to write individualized lines based on other information about each contact in your Google Sheet, the process is quick and simple.<\/p>\n This is another fast way for GPT for Sheets to do something that used to be time-consuming.<\/p>\n You can save time by having ChatGPT proofread your grammar and measure your tone<\/strong>\u00a0before<\/em>\u00a0you put together an email.<\/p>\n Have GPT for Sheets analyze various pieces of your email, correct any mistakes or tonal issues you might have, then mail merge their corrected versions into your message.<\/p>\n Here’s our guide to using GPT for Sheets to fix typos, grammar, tone, and more<\/a>. (Also \u2014 to translate your messages into another language.)<\/p>\n If you\u2019re not familiar with GMass<\/strong>, it\u2019s one of the most popular cold outreach and email marketing platforms<\/strong> out there (400,000+ users, 4.8\/5 stars on 10,000+ reviews) \u2014 and GPT for Sheets was essentially <\/strong>born<\/strong><\/em>\u00a0to work with GMass<\/strong>.<\/p>\n GMass works inside Gmail, and has a native integration with Google Sheets.<\/p>\n That means it\u2019s super easy to mail merge anything GPT for Sheets generates in your Google Sheet right into your campaign<\/strong>.<\/p>\n Start a campaign with the email addresses GPT for Sheets digs out of some jumbled prospecting data.<\/p>\nGPT for Sheets: Table of Contents<\/h2>\n
\n
What Is GPT for Sheets?<\/h2>\n
Installing and Activating GPT for Sheets<\/h2>\n
How to install GPT for Sheets<\/h3>\n
![\"Install](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image1.png\")
<\/a><\/figure>\nHow to activate GPT for Sheets<\/h3>\n
![\"Enable](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image5.png\")
<\/a><\/figure>\nOptional: Adding your own OpenAI API key<\/h3>\n
![\"Create](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image2.png\")
<\/a><\/figure>\n![\"Open](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image4.png\")
<\/a><\/figure>\n![\"Find](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image3.png\")
<\/a><\/figure>\nHow Much Does GPT for Sheets Cost?<\/h2>\n
The \u201cunpublished pricing guide\u201d to GPT for Sheets<\/h3>\n
The two ways you can use your GPT for Sheets tokens to execute commands<\/h3>\n
Option 1: No API key<\/h4>\n
Option 2: Using your own OpenAI API key<\/h4>\n
Other potential costs (and one hidden way to save)<\/h3>\n
So\u2026 how much is this going to cost you and what should you do?<\/h3>\n
How GPT for Sheets Can Save You Time in Your Cold Outreach Campaigns<\/h2>\n
Data cleaning, extraction, and formatting<\/h3>\n
![\"\"](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image1-1.png\")
<\/a><\/p>\nAnalyzing content then writing personalized opening lines based on what it finds<\/h3>\n
![\"\"](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image3-2.png\")
<\/a><\/p>\nProspecting and finding other company info<\/h3>\n
![\"\"](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image3-3.png\")
<\/a><\/p>\nVary up and tweak your email copy<\/h3>\n
Fix your grammar and tone<\/h3>\n
![\"\"](\"https:\/\/www.gmass.co\/blog\/wp-content\/uploads\/2024\/06\/image1-4.png\")
<\/a><\/p>\nWhy GPT for Sheets Is a Great Companion to GMass<\/h2>\n