Most teams connect a form to a sheet and stop there. The sheet becomes the destination, and someone downloads a CSV when they need the data somewhere else.
There's a faster path.
Read submission data as JSON
Once a form is connected to a Google Sheet through Info2Sheets, you can pull that data directly using an authenticated API call:
GET /api/forms/:formId/data
The response looks like this:
{
"success": true,
"total": 42,
"data": [
{
"name": "Alice",
"email": "alice@example.com",
"message": "Interested in the pro plan",
"timestamp": "2026-04-30 14:22:01+00:00"
}
]
}
Each row in the sheet becomes an object. Column headers become keys. Timestamp is always included.
Why this matters
Your sheet is already the source of truth. This endpoint lets your internal tools treat it like a live database without any extra sync logic.
Practical uses:
- Pull new submissions into a Slack notification script
- Feed a follow-up queue in your admin panel
- Trigger a webhook handler from a nightly cron job
- Power a lightweight reporting view without a BI tool
Authentication is required
Requests need a valid session cookie. That means this endpoint is designed for server-side scripts and internal dashboards running with your credentials, not public-facing pages.
No schema definition needed
You don't define any schema upfront. Info2Sheets reads whatever headers exist in the sheet and returns them as-is. Rename a column in the sheet and the JSON keys update automatically on the next read.
Ready to turn your form data into something your tools can actually use? Set up your first form with Info2Sheets.