Hello everybody
I got a Google Form when a new player join my team I would like to create a player Profile on google sheet for this I create a Google form and a spreadsheet template to copy and past and fill with the information of the form i would like to automate this with zapier
When a new User answer to the google form I want
- duplicate a spreadsheet Template
- Rename the new spreadsheet with information of the google form
- Fill the last worksheet of the new spreadsheet with the same google form information in 2nd row
The two first steep are good for me but for the third steep I don’t arrived to write in the new spreadsheet or when I arrived it’s only write in the first spreadsheet create by Zapier (not the template).
2 first step
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/57e8cdf0-6d0f-4380-9096-68ace25816d2.png)
This not working
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/6de9504f-2d92-428a-a82c-eb5430ef51e1.png)
This not working too (write only in the spread sheet e!PID]_Rambow Six_PlayerInformation
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/51a1be85-ae81-4624-a913-8820e2bbb2f6.png)
Thank’s a lot to all people who will help me to solve my probleme