Forms for Google Drive

Forms for Google Drive

Access Google Forms with managed OAuth authentication. Create forms, add questions, retrieve and export responses to Excel — all via natural language.

Quick Start

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/list')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Base URL

https://api.gformsfree.com/skill

Authentication

All requests require the API key in the Authorization header:

Authorization: Bearer $GFORMS_API_KEY

Environment Variable: Set your API key as GFORMS_API_KEY:

export GFORMS_API_KEY="YOUR_API_KEY"

Getting Your API Key

1. Download the Forms for Google Drive App: https://apps.apple.com/us/app/forms-for-google-drive/id6468928038 2. Sign in with your Google account 3. Go to Settings → Connect AI Agent 4. Copy your API key

API Reference

List Forms

GET /forms/list

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/list')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Response:

{
  "forms": [
    {
      "formId": "1BxiM...",
      "title": "Customer Feedback",
      "responderUri": "https://forms.gle/xxx",
      "editUri": "https://docs.google.com/forms/d/xxx/edit"
    }
  ]
}

Get Form

GET /forms/{formId}

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/FORM_ID')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Create Form

Create a new Google Form with questions in a single request.

POST /forms/create

import urllib.request, os, json
data = json.dumps({
  "title": "Customer Feedback Survey",
  "description": "We'd love to hear from you.",
  "questions": [
    {
      "type": "TEXT",
      "title": "What is your name?",
      "required": True
    },
    {
      "type": "RADIO",
      "title": "How satisfied are you?",
      "required": True,
      "options": ["Very satisfied", "Satisfied", "Neutral", "Dissatisfied"]
    },
    {
      "type": "SCALE",
      "title": "Rate your experience",
      "low": 1,
      "high": 5,
      "lowLabel": "Poor",
      "highLabel": "Excellent"
    },
    {
      "type": "CHECKBOX",
      "title": "Which features do you use?",
      "options": ["Feature A", "Feature B", "Feature C"]
    }
  ]
}).encode()
req = urllib.request.Request(
  'https://api.gformsfree.com/skill/forms/create',
  data=data, method='POST'
)
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
req.add_header('Content-Type', 'application/json')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Response:

{
  "formId": "1BxiM...",
  "responderUri": "https://forms.gle/xxx",
  "editUri": "https://docs.google.com/forms/d/xxx/edit"
}

Question types: TEXT · RADIO · CHECKBOX · SCALE · DATE · TIME

List Responses

GET /forms/{formId}/responses

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/FORM_ID/responses')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Summarize Responses

Get a natural language summary of all form responses.

GET /forms/{formId}/summary

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/FORM_ID/summary')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Use the returned summary field to present trends and insights to the user.

Export Responses to Excel

Generate a downloadable Excel file of all form responses.

POST /forms/export

import urllib.request, os, json
data = json.dumps({"formId": "FORM_ID"}).encode()
req = urllib.request.Request(
  'https://api.gformsfree.com/skill/forms/export',
  data=data, method='POST'
)
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
req.add_header('Content-Type', 'application/json')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

Response:

{
  "downloadUrl": "https://api.gformsfree.com/skill/files/xxx.xlsx",
  "expiresIn": 600
}

Return downloadUrl to the user. Remind them the link expires in 10 minutes.

Error Handling

| Status | Meaning | |--------|---------| | 400 | Missing or invalid request parameters | | 401 | Invalid or missing API key — check GFORMS_API_KEY | | 403 | Subscription expired — renew in the Forms for Google Drive App | | 429 | Rate limited (10 req/sec per account) | | 4xx/5xx | Passthrough error from Google Forms API |

Troubleshooting: API Key Issues

Verify your key is valid:

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/auth/check')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))

If invalid, regenerate in the app: Settings → Connect AI Agent → Regenerate Key

Agent Instructions

Resources

import urllib.request, os, json
req = urllib.request.Request('https://api.gformsfree.com/skill/forms/list')
req.add_header('Authorization', f'Bearer {os.environ["GFORMS_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))