Summarize new Google Form submissions

5
Connect

This Applet will output the original answers + a summary of all answers.

If

Google Forms icon
New form response

This trigger fires when a new form response is received.

With

Summarize icon
Query

This query will summarize content and return the summary as an ingredient you can use in actions.

Then

Google Sheets icon
Add row to spreadsheet

This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.

Fewer details

Explore more great ways to automate Google Sheets and Google Forms