Dynamic cell value not working

[Jeff_Hager]

Doesn't write on my Google Sheet

Scroll down to the bottom of the sheet. The record is there. You populated all of your rows with formulas. New records from Glide will not touch these existing rows. You need to switch your formulas to Arrayformulas and then delete any empty rows. Then everything will work.