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
This not working
This not working too (write only in the spread sheet [!PID]_Rambow Six_PlayerInformation
Thank’s a lot to all people who will help me to solve my probleme
Best answer by Liz_Roberts
Circling back here to share some good news with you. You let our team know that you were interested in using a custom value to specify the worksheet or spreadsheet while using the Google Sheets integration. Previously, you had to select a single option from the dropdown menu.
After some deep investigating, we've finally been able to bring that to reality. That means you can now create more powerful Zaps that use dynamic values for either of these!