Embed tally form integrated with google sheet (logged-in user data)

hello i’m using google sheet but i have problem to embed the tally form.
I want to pass logged-in user data to google sheet.

how can i fix it? I really appreciate it in advance




<script>
    let tallyUrl = 'https://tally.so/embed/n99kNp?alignLeft=1&hideTitle=1&transparentBackground=1&dynamicHeight=1';

    if(window['logged_in_user'] && window['logged_in_user']['softr_user_email']) {
        tallyUrl = tallyUrl + '&record_id=' + window['logged_in_user']['softr_user_email'];
    }
 
    document.write('<iframe src="' + tallyUrl + '" width="100%" height="800" frameborder="0" marginheight="0" marginwidth="0" title="My Application"></iframe>');
</script>