Google Forms - Watch Responses - How to Know Questions

I’m having difficulty getting the values of the Google Form I want.

I have 42 questions, and they do not seem to order in the collection when it comes to selecting them for use in a Google Doc Template. They are also not labeled in a way that can be recognized, and the make UI preview is too small to see what the values are.

Any ideas on how I can accomplish this?

I tried using the legacy spreadsheet update, but it won’t pull anything past column Z

you can use google sheet Module and watch for new rows where you can define the limit upto which coloum you want it to pull whats the range

2 Likes