Redirect after clicking 'submit'

on my website, I have an embedded questionnaire, that is linked to a google sheet that makes calculations and changes according to what the respondent answers on the questionnaire. There is a specific cell in the google sheet (let's call it A1) with the result, which is a URL address. My goal: That my website will redirect the respondent to the URL that A1 got. So, in other words... step 1 - respondent clicks 'submit' after filling the questionnaire that is embedded on my website. Google sheet is updated/changes and the specific A1 cell in that sheet changes and gets a URL. So far so good. step 2 (here is where I am stuck) - I want that after the respondent clicks 'submit' in the questionnaire, he or she will be redirected to a URL on my website, according to A1 cell in that google sheet.