I need to create a Zap for quite a long Google Form. 100 questions in the Google Form are not mandatory and I would like to assign a default value for each when there is a blank answer.
I know I could use the Formatter > Text > Transform > Default Value function, however I want to avoid using multiple steps. My best guess is that this could be possible using Google Sheets.
Anyone have any ideas?