Skip to content

GPT formula

With GPT for Sheets, you can effortlessly craft attention-grabbing ad copy, taglines, and subject lines that perfectly align with your brand, captivating and retaining your customers’ interest.

The GPT formula generating ad copy in a sheet

To get started, select a cell and input then use the following formula

=GPT(prompt, value, temperature, model, cache)

ParameterDescriptionDefault
promptthe prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")""
valueThe cell you are referring to in your prompt (ex: A1)null
temperatureBetween 0 (not creative) and 2 (very creative)0.5
modelstandard or advanced (paid plans). See AI modelsstandard
bypassCacheSet to true to ignore the cached result and generate again.false