Advance Summary of responses generates charts and filters based on a Google Form responses.
Listing updated:April 9, 2024
Works with:
2M+
Overview
Discover a powerful tool to save time analyzing Google Forms data.

Advanced Summary allows you to dig deeper into your Google Forms responses. Using intuitive filters, you can make the most of your charts and data by isolating variables and segments that are important to you. Native charts on Google Forms won’t give you anywhere near this level of flexibility. 

With Advanced Summary, you can quickly summarize your responses data by any field of responses you’ve collected - things like location, department, or age. 

Advanced Summary is built on Awesome Table, a Google Sheets add-on with over 10 million installations and a 4.6/5 rating on the Google Workspace Marketplace.

Click the install button above to start using Advanced Summary. 

GETTING STARTED
Turn your Google Form responses into filterable charts in a few steps.
Install the Advanced Summary add-on from the Google Workspace Marketplace.
Open the Google Form that you want to use. Then select (a) Add-ons (it looks like a puzzle piece) > (b) Advanced Summary by Awesome Table > (c) click Create Advanced Summary.  
Select the questions that you want to include in the Awesome Table. 
(Optional) Add or remove filters. 
(Optional) Add, modify or remove charts. 

USE CASES
 
➤ Academic research: conduct deeper analysis of your research. Intuitive filters allow you to isolate responses and variables to see how they impact other parts of your data. 
➤ Community building: understand your community better. Slice and dice survey results to see how variables like age, experience, and equipment affect preferences.
➤ Education: filter through teacher feedback and easily group results by teaching grade, subject, location, or any variable that's meaningful to you. 
➤ Businesses and entrepreneurs: save time analyzing user survey data with improved filtering of results based on demographic and psychographic information you've collected.

MAIN BENEFITS AND FEATURES
 
➤ Filters and search: your Advanced Summary will include a selection of interactive filters and searches for your users to easily find the exact information they want. This isn’t possible with the native charts in the Google Forms Summary tab. 
➤ Embed anywhere: embed your Advanced Summary on any site, including Google Sites, WordPress, Microsoft Teams, Sharepoint, Lumapps, Happeo, Wix, Confluence, Weebly, and Squarespace.
➤ Automatic charts: Advanced Summary will automatically find the most appropriate chart type for each Google Form section whether it’s a pie chart, word cloud, table that shows off the top five or ten results in a given column, or a selection of other visualizations.
➤ Customization: each Advanced Summary is connected to a spreadsheet just like any Awesome Table. If you want to change the type of chart being displayed then you just need to change the keyword on the spreadsheet!
➤ Safe and secure: Advanced Summary never uploads your data to our servers. They are fetched at display time from your browser.

The ADVANCED SUMMARY ADVANTAGE

➤ Much more customizable than native Google Forms charts and much easier to configure than creating separate charts via Google Sheets or Excel. 
➤ Advanced Summary users have access to Awesome Table’s world-class customer support team that works around the clock.
➤ Advanced Summary is built by the company behind Awesome Table, AODocs, YAMM, and Form Publisher, which has some of the best Google Workspace expertise in the world. 
PRICING
➤ Free Plan: 500 pageview limit
➤ Paid apps start at $39 / user / month
More options on our pricing page: https://awesome-table.com/pricing 
HELP CENTER
Do you need some help with Advanced Summary? Please contact the Awesome Table support team at https://support.awesome-table.com/hc/en-us/requests/new
 
OUR OTHER PRODUCTS
If you like Advanced Summary, you might like our other add-ons:
Awesome Table: most popular Google Sheets visualization tool for websites
Form Publisher: most popular document merge tool for Google Forms
Yet Another Mail Merge (YAMM): most popular mail merge tool for Gmail
OTHER COMPANION ADD-ONS
Advanced Summary is a companion add-on to Awesome Table. Companion add-ons are easy-to-use and help you create an Awesome Table app before jumping into the full Awesome Table experience. Other companion add-ons include:
 
➤ Files cabinet: automatically list files from a selected folder in Drive and display them in a nice view.
➤ Geocode: Get GPS data (latitude and longitude) from a list of addresses and turn them into a map.
➤ People directory: List all users from a Google Workspace domain and turn it into a table or cards app.
➤ Photo gallery: create a gallery from photos in a Google Drive folder.
➤ Publication workflow: create workflows in seconds to automate the publication validation process.
➤ Sites catalog: List all Google Sites you have access to (admins can list all sites on a domain). 
TOP-RATED APP
Advanced Summary is a popular app on the Google Workspace marketplace. Other apps include  SketchUp for Schools, LucidChart Diagrams, BetterCloud, Pear Deck, Lucidpress, BrainPOP, Form Ranger, AODocs, EasyBib, GAT+, formLimiter, Smartsheet, Doctopus, Hapara Teacher, diagrams.net, SMART Learning Suite, Nearpod, Kami, Mavenlink, Flubaroo, NoodleTools, MindMeister, Form Publisher, MathType, Backupify, Choice Eliminator, EasyBib, Bark, Digication, Cisco Webex, Form Mule, MindMup, SysCloud Security, Screencastify, Spanning Backup, Doc Appender, DocHub, Pixton for Schools,  Wrike, Virtu / Virtru Data Protection, Mailmeteor, Super Quiz, PowerSchool, JoeZoo Express, gPanel, LumApps, Asana, GQueues, chromebookInventory, Timify.me, DocuSign eSignature, Easy Accents, Kaizena, Kabanchi, Grackle Docs, Power Tools, PlanbookEdu, VoiceThread, Sketchboard, Mindomo, Mojo Helpdesk, Slido, Stupeflix, Certify'em, StackEdit, Colaboratory, GoFileDrop, Drag, PerformFlow, Slack, Zapier, Zoom, Appsheet, Awesome Table and more…
 
PRIVACY - DATA SECURITY - GDPR - HIPAA
 
Advanced Summary is GDPR compliant as we do not store or transfer any personal data. This is because your data (mailing list) is stored in your Google Sheets and is never saved in our database.
 
Our DPA is available online and is incorporated by reference to the Terms of Service that you (or your domain admin) accepts when starting using the application.
 
Upon completion of DPA, it is stipulated that: The application of lawful data transfer mechanisms for our customers who wish to transfer personal data to a third country (outside the EEA) in accordance with Article 45 or 46 of the GDPR, relies on entering into Standard Contractual Clauses or offer any alternative transfer solution if requested (for example, the EU-U.S. Privacy Shield).
 
On July 16, 2020, the Court of Justice of the European Union issued a judgment declaring as “invalid” the European Commission’s Decision (EU) 2016/1250 of 12 July 2016 on the adequacy of the protection provided by the EU-U.S. Privacy Shield. As a result of that decision, the EU-U.S. Privacy Shield Framework is no longer a valid mechanism to comply with EU data protection requirements when transferring personal data from the European Union to the United States. 
However, Awesome Gapps does not depend on the Privacy Shield mechanism. Rather, Awesome Gapps relies on the Standard Contractual Clauses to transfer all of its users’ EEA personal data in compliance with the GDPR. The Court confirmed that such Standard Contractual Clauses remain a valid data export mechanism. The Standard Contractual Clauses are referenced in and automatically apply through Awesome Gapps' Data Processing Addendum, which you can find here.
This means that our users can take comfort that their EEA personal data continues to be protected to European standards in compliance with applicable data protection laws including GDPR.
 
Please find all the information you need about privacy, GDPR, HIPAA, our DPA and BAA here: https://support.awesome-table.com/hc/en-us/articles/360001374519
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Advanced Summary by Awesome Table will ask for the permissions shown below. Learn more
Advanced Summary by Awesome Table will need access to your Google account
This will allow Advanced Summary by Awesome Table to :
View and manage your forms in Google Drive
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Atka Films
October 17, 2022
doesnt work
Is this review helpful?
Yes
No
Profile Picture
Thomas Harris
April 11, 2022
First said that I had duplicate names on my questions yet only showed one question. After changing that, it then says I have questions that didn't have anything named. Everything has content in all fields...uninstalling this.
Is this review helpful?
Yes
No
Profile Picture
Ken Kum
January 3, 2023
After clicking on the add-on link, it only shows a 'Help' button, which does not help at all. Nothing else. Uninstalling.
Is this review helpful?
Yes
No
Profile Picture
Asha Moncrieffe
October 20, 2022
It does nothing
Is this review helpful?
Yes
No
Profile Picture
Renee Fields
September 19, 2020
hate it. Every other add on is intuitive. I installed this but it doesn't show up or do anything. I don't have time to figure it out when the form gives me analysis anyway. I was just hoping it was better. Now I"m just annoyed.
Is this review helpful?
Yes
No
Profile Picture
Nirjhor Sarker
December 23, 2020
I really do not understand HOW to change the types of tables shown. It seems like it's going to be great and then the tables are not the kind of tables I want. I am so confused and disappointed.
Is this review helpful?
Yes
No
Profile Picture
Victoria Sylvestre
November 6, 2020
I really do not understand HOW to change the types of tables shown. It seems like it's going to be great and then the tables are not the kind of tables I want. I am so confused and disappointed.
Is this review helpful?
Yes
No
Profile Picture
Big G's Common Sense
October 28, 2020
Not intuitive or helpful. Did things I could easily do in excel, but not handle checkbox questions. Also don't trust it as you have to give it access to your Google account.
Is this review helpful?
Yes
No
Profile Picture
Vi
September 17, 2020
For multiple choice questions, it seems like if there are few respondents, the add-ons would automatically graph the responds as words (?) ranging from big to small to demonstrate the frequency of each answer. However I wanted the exact number. There was no way to change how it graphed the answers for that question which was really annoying. Overall it is convenient.
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Summary by Awesome Table
January 24, 2018
This Add-on is very strong generating a set of nice graphs. Very useful for making a report after a User Satisfaction Survey. I found one bug, if some fields in the dataset has no data you get a bug "[NOT FOUND]" This happens when 0% of the users choose that answer. In my case 0% was "VERY unsatisfied" and the Pie chart does not show this, because of the "[NOT FOUND]" bug. Except for this, the add-on was very very useful!
Is this review helpful?
Yes
No
1-10 of 64
Search
Clear search
Close search
Google apps
Main menu