Google Forms responses to a clean Google Sheets tab
“send our google form signups to a clean google sheets tab with one row per person: names in proper case, phone numbers in one format, the latest submission kept when someone signed up twice, and flag signups with an email that is not valid and signups missing a phone number”
Send our Google Forms responses to a clean Google Sheets tab with one row per person: names in proper case, phone numbers in one format, the latest submission kept when someone signed up twice, and flag signups with an email that is not valid and signups missing a phone number, using +14155550182 for phone numbers.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGoogle Forms responsesCSV export · 40 rows
- StepClean and keep latest signupStep 1
- ResultClean Signup Sheet33 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 33 rows.
- Download Google Forms responses sample (40 rows)Google Forms: Responses > Link to Sheets > Form responses 1
What you get back
The result of that run, the rows to look at first.
| Name | Phone | Email status | Phone status | Submission date | Age group | |
|---|---|---|---|---|---|---|
| Liam Carter | liam.carterexample.com | +14155550154 | Invalid email | Phone present | 2026-09-10 | U14 |
| Mila Brooks | mila.brooks@example.com | · | Valid email | Missing phone | 2026-09-19 | U8 |
| Julian Ortiz | julian.ortiz@example.com | · | Valid email | Missing phone | 2026-09-19 | U12 |
| Ethan Brooks | ethan.brooks@example.com | +14155550158 | Valid email | Phone present | 2026-09-04 | U8 |
| Sofia Martinez | sofia.martinez@example.com | +14155550109 | Valid email | Phone present | 2026-09-04 | U14 |
| Wyatt Cooper | wyatt.cooper@example.com | +14155550116 | Valid email | Phone present | 2026-09-14 | U12 |
| Chloe Nguyen | chloe.nguyen@example.com | +14155550189 | Valid email | Phone present | 2026-09-17 | U12 |
| Lucas Brown | lucas.brown@example.com | +14155550164 | Valid email | Phone present | 2026-09-14 | U14 |
| Sebastian Gray | sebastian.gray@example.com | +14155550149 | Valid email | Phone present | 2026-09-15 | U8 |
| Mia Chen | mia.chen@example.com | +14155550171 | Valid email | Phone present | 2026-09-05 | U12 |
| Ava Wilson | ava.wilson@example.com | +14155550136 | Valid email | Phone present | 2026-09-12 | U12 |
| Nora Hill | nora.hill@example.com | +14155550104 | Valid email | Phone present | 2026-09-09 | U12 |
How it works
How to use the Clean Signup Sheet workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Clean Signup Sheet: questions
How do you clean Google Forms responses in Google Sheets?
What file should I export from Google Forms?
What happens to rows that do not match the rules?
How do I change the cleanup rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Remove duplicates, tidy names and addresses, fill the blanks, and merge files into one.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Merge Excel or CSV filesOne tidy table with every file's rows, re-sent rows dropped, and a Period columnSee the workflow Template
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Multi-entity consolidationEvery entity's balances in one currency, by accountSee the workflow Template