How to extract fields from AI-generated JSON inside Glide for DocsAutomator?

Hi Glide community,

I have an AI-generated JSON column in my Glide app, for example:

{
  "Site": "Sample Site",
  "Client": "Sample Client",
  "Subcontractor": "Sample Subcontractor",
  "A1": "Yes – Sample answer 1",
  "A2": "Yes – Sample answer 2",
  "A3": "Yes – Sample answer 3",
  "B1": "Yes – Sample answer 4",
  "B2": "Yes – Sample answer 5",
  "B3": "Yes – Sample answer 6"
}

I want to extract each field (Site, Client, A1–B3, etc.) into separate Glide columns so I can map them directly to placeholders in DocsAutomator and generate a Word document automatically.

i don’t really find a way to do this.

Thank you!

1 Like
2 Likes

you are a Star, thank you

2 Likes