Finally In the redirection on completion you can setup a redirection the url of your choice in this case we will redirect to youtube passing the corresponding video id
@james.survey - welcome to the community from a fellow user
This may not be the ideal solution for you, but since there is no way to pull from a Google Sheet dynamically during a typeform session at this point, you might be able to do the following:
if you have the email addresses for the 20 respondents already, you could send each of them an email with the url for the typeform - BUT adding their email to the URL string so that it is passed to the typeform as a hidden field
inside your typeform, you would have to create the hidden field on the Advanced Logic tab - this would enable you to know this particular respondent
in your form logic you would set up a text variable called, for example, v_youtube as a text variable and leave it blank
in your form logic, you would have to set up the following type of logic rules:
if hidden field email is person1@email.com then replace v_youtube with “youtube link for person 1
if hidden field email is person2@email.com then replace v_youtube with “youtube link for person 2
etc
on your typeform page, you would use the @recall function to grab the v_youtube variable and display it to the user.
you could also do this by sending your respondents a ‘unique code’ - something you make up that is correlated to your user id’s - that they could enter in the survey -
in the email invitation, send them the url and the unique code, telling them to enter this code into the survey so that they can be provided with unique content just for them. something like that
once they enter in the code, you would need to evaluate that code in a similar set of logic rules as described above that would like them to a particular youtube video.
just a couple of ways that you might be able to do this quickly.. for what it’s worth
Finally In the redirection on completion you can setup a redirection the url of your choice in this case we will redirect to youtube passing the corresponding video id