Before
A person likely had to review each form submission, copy the individual values, and switch to the spreadsheet to locate the next empty row. They then had to paste each field into the correct column and repeat the process for every submission.
How it works
- Capture the submitted form fields and use the configured spreadsheet as the destination.
- Retrieve the spreadsheet and identify the next empty row for the new record.
- Map the form values to the expected columns and append them as a complete spreadsheet row.
Workflow details
- Form capture: The workflow receives user-provided form values, including first name, last name, ID, email, group, subgroup, and ZIP code.
- Spreadsheet access: It uses the configured spreadsheet identifier to retrieve the target spreadsheet and determine where new information should be placed.
- Row preparation: The workflow identifies the next empty row so incoming records can be added without manually searching for the correct location.
- Data mapping: Each submitted value is mapped into the appropriate spreadsheet column, supporting a consistent structure based on the configured header row.
- Record creation: The mapped form data is written to the spreadsheet as a new row, making the submitted record available for ongoing spreadsheet-based work.
What changed
Each form submission is converted into a structured spreadsheet row automatically, with the destination row and column mapping handled by the workflow instead of by a person.
Work removed
Copying form fields one by one, switching to the spreadsheet, finding the next empty row, mapping values to the correct columns, and manually pasting each submission.
Expected outcome
The workflow removes at least one manual copy-and-paste sequence per form submission and provides a consistently structured spreadsheet record.
