ABCDEFG
1
#REF!
▶️ YouTube Demo
2
List of Functions
3
(click to jump)=GPTX()
4
Generates text using OpenAI's GPT model
5
=GPTX()
6
=GPTX_LISTPrompts=GPTX(D7)
7
=GPTX_MAPWrite a haiku about bringing the power of AI to SaaS spreadsheetsData flows like streams,
AI weaves through every cell,
Insights bloom in sheets.
8
=GPTX_FILL
9
=GPTX_TABLE
10
=GPTX_TAGTell me in 8 words why Google Sheets > ExcelCollaboration features make teamwork seamless and efficient.
11
=GPTX_CLASSIFYFind the misteak in this sentenceFind the mistake in this sentence.
12
=GPTX_EXTRACTWhat date is 72 weeks from June 15, 2022?November 15, 2023
13
=GPTX_EDITWhat formula works for Net Revenue Retention? Net Revenue Retention (NRR) = (Beginning MRR + Expansion MRR - Churned MRR) / Beginning MRR x 100%
14
=GPTX_FORMAT
15
=GPTX_SUMMARIZE
16
=GPTX_TRANSLATE
17
=GPTX_CONVERT=GPTX_LIST
18
=GPTX_CODEGenerates a list of values using OpenAI's GPT model
19
20
Prompt=GPTX_LIST(D21)
21
5 subject lines to A/B test for my email introducing GPT in Google Sheets, use emojis Unlock the Power of GPT in Google Sheets! 🌟
22
Boost Your Productivity with GPT in Sheets! 🚀
23
Transform Your Data Analysis with GPT! 📊
24
Discover GPT: Your New Best Friend in Google Sheets! 🤖
25
Get Started with GPT in Google Sheets Today! 📝
26
27
28
=GPTX_MAP
29
Given a list of search keys and a list of input values, performs a fuzzy search and outputs the most similar search key for each input value, using OpenAI's GPT model
30
31
Look up these items......from this list=GPTX_MAP(D33, E$33:E$36)
32
KeysValuesResult
33
gooooogle incGoogle, IncGoogle, Inc
34
magentoMagentoMagento
35
magnetosSalesforce.comMagento
36
google.caTeslaGoogle, Inc
37
magentooMagento
38
saleforceSalesforce.com
39
Model XTesla
40
SALES FORCE!Salesforce.com
41
Google CloudGoogle, Inc
42
43
44
45
=GPTX_FILL
46
Fills in missing information in a table, based on example rows, using OpenAI's GPT model
47
48
=GPTX_FILL(D49:E52,D53:D56)
49
Full NameEmail
50
Maria Isabel Rodriguezm.rodriguez@cooldomain.org
51
Omar Ali Khano.khan@cooldomain.org
52
Jacqueline Lee Chenj.chen@cooldomain.org
53
William Thomas Jenkinsw.jenkins@cooldomain.org
54
Samantha Grace Reynoldss.reynolds@cooldomain.org
55
Elijah Daniel Nguyene.nguyen@cooldomain.org
56
Ruby Rose Patelr.patel@cooldomain.org
57
58
59
60
=GPTX_TABLE
61
Generates a table of values using OpenAI's GPT model, using OpenAI's GPT model
62
(with header row argument)
63
64
Top 10 largest public SaaS companies by Market Cap=GPTX_TABLE(D64, D65:F65)
65
CompanyTickerMarket Cap
66
SalesforceCRM$230 billion
67
AdobeADBE$200 billion
68
ServiceNowNOW$115 billion
69
Zoom VideoZM$100 billion
70
AtlassianTEAM$70 billion
71
ShopifySHOP$65 billion
72
DocuSignDOCU$50 billion
73
TwilioTWLO$45 billion
74
SquareSQ$40 billion
75
HubSpotHUBS$35 billion
76
77
(no header row arg)
78
79
10 target customer profiles for an App Developer, including job title, business type, and app idea=GPTX_TABLE(D79)
80
job titlebusiness typeapp ideaindustry
81
Product ManagerE-commerceShopping AssistantRetail
82
Fitness TrainerHealth & WellnessWorkout TrackerFitness
83
TeacherEducationInteractive LearningEducation
84
ChefFood & BeverageRecipe OrganizerCulinary
85
Travel AgentTravelTrip PlannerTravel
86
Real Estate AgentReal EstateProperty FinderReal Estate
87
MusicianEntertainmentMusic CollaborationMusic
88
Event PlannerEventsEvent ManagementEvents
89
Software EngineerTechnologyCode CollaborationTech
90
ParentFamilyChild Activity TrackerFamily
91
92
93
94
=GPTX_TAG
95
Applies one or more tags matching a piece of text, using OpenAI's GPT model
96
97
=GPTX_TAG(E99, $D$99:$D$105)
98
TagsItemTag(s)
99
TechUber
100
SaaSLyft