Setting temperature to 0

If the issue is that the agent field starts with some inner-monologue (e.g., “I see that the source includes a date, so I’ll provide it here: 2025-11-18”), I’ve found that instructing the agent to output in a JSON format and then using a formula field to read that format eliminates any extra data. See below.

Agent field output:

"Based on the IMDb page for Frozen, I'll create the requested JSON output with all the required information:

```json
{
  ""title"": ""Frozen"",
  ""originalLanguage"": ""English"",
}
```"

Formula: 

IF({Agent field},REGEX_EXTRACT({Agent field}, '"originalLanguage":\\s*"([^"]*)"'),BLANK())

Formula output:

English

Thanks ​@Mike_AutomaticN ! I thought I’d seen this option somewhere. I will switch to an automation to set temp to custom value of 0 and see how that goes.

​@ryanmr thank you for the tip, and JSON is indeed a good fix for that problem - my issue is the agent inserting random text in the middle of what it’s meant to be copying 😬

​@nroshak - That is really unfortunate! You could still give the JSON instruction a try since the agents seem to operate more mechanically when they receive that instruction. Shifting to an automation is definitely the best way to actually control the temperature value in the prompt until Airtable releases some additional field prompting options.

​@ryanmr ​@Mike_AutomaticN  Unfortunately, turns out I can’t get an automation to work for this, since the Automations agent is not able to connect to Google Docs. Automations have a very limited ability to interact with Google Docs. The field agents can connect to Google Docs and read the file, but I can’t set the temperature directly (it seems).

I’ll mark this attempt to use Airtable AI to automate this task a failure for now. Thanks for your help! 

Ohhhhh ​@nroshak I’m super sorry to hear that.

I have one additional suggestion before sending the classic “you can still do this by building your own n8n/make automation” lol.

What if you enable internet access on the automation -see screenshot below, and you make sure (i) to share the drive url on the prompt, and (ii) such url is accessible publicly.

 

I guess it will NOT work, but it might make sense to give it a shot?

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

Hi Mike, that would probably work, but these particular files need to stay internal-only, not visible to the whole internet. But many thanks for your help! -Natalka