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.

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

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

Parameter	Description	Default
prompt	the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")	""
value	The cell you are referring to in your prompt (ex: A1)	null
temperature	Between 0 (not creative) and 2 (very creative)	0
model	standard (GLM 5.2, 1 credit/token) or advanced (GLM 5.2 nitro, 5 credits/token, paid plans)	standard
bypassCache	Bypass the cache and query openai again. The results will be differents than before.	false