Google Form Poster

Submit data rows to a Google Form via POST requests.

Installation

pip install google-form-poster

Usage — as a library

from post_to_google_form import post_data

url = "https://docs.google.com/forms/d/e/.../viewform"

# Data keys match entry IDs directly
data = [{"entry.12345": "Alice", "entry.67890": "alice@example.com"}]
results = post_data(url, data)

# Or use key_mappings to translate your keys
key_mappings = {"name": "entry.12345", "email": "entry.67890"}
data = [{"name": "Alice", "email": "alice@example.com"}]
results = post_data(url, data, key_mappings)

# results = [
#   {"index": 0, "status_code": 200, "payload": {"entry.12345": "Alice", ...}},
# ]

forms.gle short links are automatically resolved:

post_data("https://forms.gle/abc123", data)

Usage — CLI

post-to-google-form --file data.json --url https://forms.gle/abc123

# With key mappings:
post-to-google-form --file data.json --url https://forms.gle/abc123 \
    --key-mappings mappings.json

All flags fall back to environment variables (FILE_PATH, GOOGLE_FORM_URL, KEY_MAPPINGS), loaded from .env if present.