How does a form reach a spreadsheet?
Alex presses Submit. You want their name and email to appear in your spreadsheet without copying them yourself. An automation connects the form to the sheet.
In this example, Webflow records Alex’s submission. A configured webhook sends the details to your automation, telling it there is something new to process.
The automation needs to know where each answer belongs. It reads name and puts that value in the Name column; email goes in Email. This is field mapping: matching each piece of incoming data to its destination.
Then the automation sends a separate request to the Google Sheets API, asking it to add the row. When that request succeeds, Alex appears in your sheet.
If the row is missing, follow those handoffs: did the notification arrive, were the fields mapped, and did the request to Sheets succeed? The diagram lets you trace the same journey.
It starts with a person.
Alex submits their name and email. The form service records the submission.
- Name
- Alex
- alex@example.com
This is one setup you can configure, not something every form does automatically. The automation needs permission to edit the sheet and must avoid adding another row for a repeated event.