Auto create new sheet and email a summarized view of responses in google forms

Question

I'm doing performance measurement for my office. And I probably just need to be pointed in the right direction. But here goes. I want to make a form that employees can fill out every day, these responses go to a google spreadsheet. I want this spreadsheet to create a new sheet for every week and then at the end of every month email the results to my boss.

What are my options for auto creating a new sheet, emailing results and summarizing?

Definitely too broad to be answered. All this is doable but you'll need to put your hands on the basics of google apps. — Serge insas
I figured it might be just that - too broad.. Do you have a sugestion as to where i could start? — Thomas Tesfaye-Berhane

Ryan Roth Ryan Roth · Accepted Answer · 2014-10-24T20:43:46

Start by reviewing the Managing Responses for Google Forms quickstart. Then look at Installable Triggers, the SpreadsheetApp service and the FormApp service.

One strategy for what you need would be to have a script that (based on a weekly trigger), creates a new spreadsheet and then resets the Form's destination to that spreadsheet.

That script can also have another (monthly) trigger that uses MailApp to send a summary email to whomever you choose.

Auto create new sheet and email a summarized view of responses in google forms

1 Answers