Google Forms to Sheets Automation

I have a Google Form collecting customer information and one key multiple-choice field that lets the respondent pick a category or service. I want every submission to land in a Google Sheet automatically, but instead of piling into one big table, each response must appear in its own service-specific tab. If the form offers “Web Design,” “SEO,” or “Content Writing,” a row should go straight into the matching tab; if the category hasn’t been used before, the script should create the tab on the fly.

Please build the workflow entirely inside Google Workspace—Apps Script, the Form-to-Sheet link, or any lightweight add-on that stays under my ownership—so there’s no reliance on outside servers or paid third-party platforms.

Deliverables
• A working script (or add-on setup) that saves every new form submission to the Sheet and routes it to the correct tab based on the selected category/service.
• Clear inline comments plus a brief setup guide so I can tweak field names or tab logic later.
• Proof of functionality: screenshots or a short screen-recording showing test submissions flowing into their respective tabs.

Acceptance criteria
• Each form response arrives in the Sheet instantly.
• Rows appear in the tab whose name matches the chosen category/service; new categories create new tabs automatically.
• Original timestamps and response IDs remain intact.

Let me know your timeline and any quick questions—once it’s tested and documented, we’re done.