GPT_WEB formula
Get up to date data from the Web with =GPT_WEB
Section titled “Get up to date data from the Web with =GPT_WEB”=GPT_WEB(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") required | "" |
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 |
Model & pricing
Section titled “Model & pricing”=GPT_WEB uses Perplexity Sonar Pro Search with live web access to fetch up to date information. It is only available on paid plans and has a minimum cost of 5,000 credits per call, regardless of the number of tokens generated.