	In Browser
	StumbleUpon
	del.icio.us
	Google
	Google Buzz
	reddit
	LinkedIn

	Facebook
	Twitter
	Linkedin
	E-Mail

Generative AI > Google Gemini API > ADK with Google Forms - Collecting Structured Input

ADK with Google Forms - Collecting Structured Input

Author: Venkata Sudhakar

Google Forms is a practical way to collect structured data from store staff, vendors, and customers without building a custom UI. ShopMax India uses Forms to run monthly store audits and vendor satisfaction surveys. An ADK agent can create forms programmatically, distribute them via Gmail, and later retrieve and summarise the responses - all in one automated workflow.

The Forms API v1 supports creating forms with questions, retrieving form metadata, and reading responses. The API requires the forms.body scope for creating forms and forms.responses.readonly for reading answers. Unlike Sheets or Docs, the Forms API does not support domain-wide delegation in all configurations - service account access requires the form to be explicitly shared or created by the service account.

The below example shows an ADK agent that creates a store audit form and reads the submitted responses.

from google.adk.agents import LlmAgent
from google.adk.tools import FunctionTool
from google.adk.sessions import InMemorySessionService
from google.adk.runners import Runner
from google.oauth2 import service_account
from googleapiclient.discovery import build

SCOPES = [
    "https://www.googleapis.com/auth/forms.body",
    "https://www.googleapis.com/auth/forms.responses.readonly",
]

def get_forms_service():
    creds = service_account.Credentials.from_service_account_file(
        "/secrets/sa-key.json", scopes=SCOPES
    )
    return build("forms", "v1", credentials=creds)

def create_audit_form(store_name: str, month: str) -> dict:
    """Create a monthly store audit form for the given store."""
    svc = get_forms_service()
    form = {
        "info": {"title": f"ShopMax Store Audit - {store_name} - {month}",
                 "documentTitle": f"Audit_{store_name}_{month}"}
    }
    created = svc.forms().create(body=form).execute()
    form_id = created["formId"]
    # Add questions
    questions = [
        ("Stock shelves fully stocked?", "RADIO", ["Yes", "No", "Partially"]),
        ("Safety compliance issues found?", "RADIO", ["None", "Minor", "Major"]),
        ("Overall store cleanliness rating (1-5)", "SCALE", []),
        ("Additional comments", "PARAGRAPH", []),
    ]
    requests = []
    for i, (title, qtype, options) in enumerate(questions):
        q = {"title": title, "required": True}
        if qtype == "RADIO":
            q["choiceQuestion"] = {"type": "RADIO",
                                   "options": [{"value": o} for o in options]}
        elif qtype == "SCALE":
            q["scaleQuestion"] = {"low": 1, "high": 5}
        else:
            q["textQuestion"] = {"paragraph": True}
        requests.append({"createItem": {"item": {"title": title, "questionItem": {"question": q}},
                                        "location": {"index": i}}})
    svc.forms().batchUpdate(formId=form_id, body={"requests": requests}).execute()
    link = f"https://docs.google.com/forms/d/{form_id}/viewform"
    return {"form_id": form_id, "link": link}

def get_form_responses(form_id: str) -> dict:
    """Retrieve all responses submitted to a form."""
    svc = get_forms_service()
    resp = svc.forms().responses().list(formId=form_id).execute()
    responses = resp.get("responses", [])
    return {"response_count": len(responses), "responses": responses[:5]}

agent = LlmAgent(
    name="shopmax_forms_agent",
    model="gemini-2.0-flash",
    instruction="You are a ShopMax India audit agent. Create store audit forms and summarise the responses when asked.",
    tools=[FunctionTool(create_audit_form), FunctionTool(get_form_responses)],
)

session_service = InMemorySessionService()
runner = Runner(agent=agent, session_service=session_service)
events = list(runner.run(
    user_id="audit_team", session_id="sess_forms_001",
    new_message={"role": "user", "parts": [{"text": "Create April 2026 audit form for the Pune store."}]},
))
print(next(e.content.parts[0].text for e in events if e.is_final_response()))

It gives the following output,

Store audit form created:
  Title  : ShopMax Store Audit - Pune - April 2026
  Questions: 4 (stock, safety, cleanliness, comments)
  Link   : https://docs.google.com/forms/d/1FormIdXYZ.../viewform

Share this link with the Pune store manager to begin the audit.

Automate the full audit cycle by chaining three agents: the Forms agent creates the form, the Gmail agent emails the link to store managers in Mumbai, Bangalore, Pune, and Hyderabad, and a third scheduled agent reads the responses after the deadline and writes a consolidated report to Sheets. Use Cloud Scheduler to trigger each step at the right time during the month-end cycle.

Send your comments, suggestions or queries regarding this site to [email protected].