This Applet will output the original answers + a summary of all answers.
With
Query
This query will summarize content and return the summary as an ingredient you can use in actions.
Then
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.
ID GraSh2JE
Explore more great ways to automate Google Sheets and AI Summarizer