Skip to main content

AI automation issue

K
Forum|alt.badge.img+3

Hi,

I have a content management system in Airtable where I could use some automation support. I am attempting to use the new Airtable AI, but it just won't work the way I want it. What I want to do is:

  1. Request a new record (requests new content using a form) to be created, it currently creates a Google Doc with the record details on it and changes the status to "assign to writer"
  2. I want to have it where if I assign the writer as "AI" it submits the record details to AI (with a detailed prompt I created).
  3. Writes the content and places that content on the Google Doc.

I have it producing the AI generated content within Airtable using the prompt but can't get it to add that content to the Google Doc and update the database field to "For Review". I don't want to use Zapier/Make if I can help it.

Has anyone had success with this or have an idea, and would you mind sharing a shot of your automation?

Thank you.

 

3 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Hmm...the "Google Docs: Update Doc" action doesn't appear to let you set a Google Doc to update dynamically, so updating an existing Google Doc that you just created via an automation doesn't seem possible natively

Is it possible to change when the document is created?  Specifically, you would only create the doc when the "Writer" value is "AI", and the generated content exists in the field?  The same automation that creates the doc with the generated content would then update the field you want to "For Review" as well

Adam, Consultant @ thetimesaving.company
U
Forum|alt.badge.img+1
  • Upfrootov
  • New Participant
  • 1 reply
  • March 21, 2025

Check if the AI action is using the right field values and confirm that the automation settings match your expected inputs. Sometimes adjusting the trigger or testing different prompts helps.

Sachin_191
Forum|alt.badge.img+9
  • Sachin_191
  • Participating Frequently
  • 94 replies
  • March 21, 2025

Hey ​@kevink11 

Since you're already generating the content inside Airtable using the AI prompt, the key next steps would be: push that generated text into your existing Google Doc and flip the status to "For Review" without relying on external platforms like Zapier or Make.

We can do this directly using Airtable's scripting extension or with an Airtable Automation that triggers on the AI assignment and uses a small script to handle the Google Docs API.

  • Grabs the generated content from Airtable
  • Authenticates and connects to your Google Doc (you’ll need to set up an OAuth token via Google Cloud Console)
  • Replaces the placeholder or appends content inside the doc
  • Then updates the record status to "For Review" right in Airtable
Sachin karma - Automation consultant Growwstasks Automation Solutions https://www.growwstacks.com

Reply


Most helpful members this week

Terms & Conditions