copy each new google form lead into a separate sheet automatically

IMPORTRANGE can lag a few minutes and now and then shows a loading error. If the team needs leads instantly, or wants an email alert as well, Zapier or Make can do form response > new row in the other sheet > notification without any code. The free tiers handle small volumes.

you don't need a script for this unless you want something fancy. the form already writes every response into its linked responses tab. in the other spreadsheet use IMPORTRANGE pointing at that tab, approve the access prompt once, and it stays in sync on its own. wrap it in QUERY or FILTER if you only want certain leads (one region, one service etc). only catch: anything you type next to the imported rows won't move with them if rows shift. if your team adds notes per lead, then yes go with an Apps Script onFormSubmit trigger that appends the row instead.