# GPT formula

## Using the =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.

<figure><img src="https://1096151144-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGl9bWvDp1A2xWk189Yux%2Fuploads%2Fk3adqI6qALwvWnswbvgU%2Fmvk4owlksh3l8myf.gif?alt=media&#x26;token=f78a29dd-35a2-44a5-b3a0-8da1e9030f06" alt=""><figcaption></figcaption></figure>

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

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

<table><thead><tr><th width="191">Parameter</th><th width="446">Description</th><th>Default</th></tr></thead><tbody><tr><td><code>prompt</code></td><td>the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")</td><td>""</td></tr><tr><td><code>value</code></td><td>The cell you are referring to in your prompt (ex: A1)</td><td>null</td></tr><tr><td><code>temperature</code></td><td>Between 0 (not creative) and 2 (very creative)</td><td>0</td></tr><tr><td><code>model</code></td><td><code>standard</code> or <code>advanced</code> (gpt-4o-mini or gpt-4o)</td><td><code>standard</code></td></tr><tr><td><code>bypassCache</code></td><td>Bypass the cache and query openai again. The results will be differents than before.</td><td>false</td></tr></tbody></table>
