I’m using google forms to capture questions for a survey. At the bottom of the form edit page, there’s the option to: Publish and show a public link to form results. Which is great except it also publishes the emails, names, etc of everyone whose submitted a response. I can’t publish that, I just want the graphs.

Can I have the scripts/is there something else i can do. Clearly there’s quite a lot of power in the basic and add-ons within google docs/forms, but it doesn’t seem that customisable unless I’m missing something.

After this I have a somewhat more complex question about syncing to a different excel sheet. Help shall be rewarded with beer/wine/potential bike parts!