App Icon
Import data in Google Sheets and showcase it on a website. No technical skills required.
Listing updated:November 25, 2021
Works with:
10,000,000+
Overview
Awesome Table lets you do two things without technical skills:

➤ Import data from third-party applications such as Hubspot or Zendesk, or REST APIs into Google Sheets

➤ Showcase that data as interactive catalogs, directories, FAQs, Google Maps, or Gantt charts to be embedded in your website or intranet.

 
GETTING STARTED

The easiest way to get started is in our Google Sheets add-on:
1) Install the Awesome Table add-on
2) In a Google Sheet, go to Extensions > Awesome Table > Import data
3) Select a data source to import data from
4) Configure the data you want to extract
5) Run your query
Your data magically appears in your Google Sheet!

 AVAILABLE DATA SOURCES TO IMPORT FROM

The add-on provides built-in data import for a growing list of data sources which makes it easy to log in to a selected service with your existing account and import your data into Google Sheets.

The list below provides an overview of the data you can import with the built-in connectors.

YouTube: Comment threads related to channel, Comments about channel, Comment for a video, Most popular videos, My playlists. My rated videos, My subscriptions, Playlist items, Playlists for a channel, Search channels or playlists, Search videos, Subscriptions for a channel, Video information

Zendesk Support: Tickets, Ticket Metrics, Business hours

Stripe: Customers, Charges, Disputes. Invoices, Prices, Products, Refunds

Google Drive: Files & folders, Shared drives

Google Photos: Albums, Photos & videos, Shared albums

Google Tasks: Tasks from a list, Tasks lists

Notion: List databases, List users, Search

HubSpot: Contact lists, Contacts from lists, List companies, List deals, List products, List properties, List quotes, List tickets, Search companies, Search contacts, Search deals, Search products, Search quotes, Search tickets

Figma: List comments from a file, List file components, List files in a project, List frames in a file, List team components, List team projects, List team styles

Vercel: You can configure the Vercel Connector to import data as specified in the Vercel API Documentation.

Unsplash: You can configure the Unsplash Connector to import data as specified in the Unsplash API Documentation.



SHOWCASE USE CASES
 
Here are a few examples of what you can build with Awesome Table:
➤ Catalogs: create sales assets portals, product catalogs, document libraries, training catalogs, people directories, and projects portfolios.
➤ Google Maps: create maps of your customers, stores, suppliers, warehouses, projects, etc. Easily attach a table to it.
➤ Knowledge bases & FAQs: quickly create a knowledge base, an FAQ, or an issue resolution matrix.
➤ Gantt charts: turn your action tracking spreadsheets into visual Gantt charts.
➤ Data summaries: quickly create some pie charts, bar charts, top-10 tables and word clouds to summarize your data from surveys, requests, and tickets.
➤ Newsfeed: create carousels full of the latest news, testimonials, accolades, and more.
➤ Org charts: create simple org charts or hierarchies.
 
Awesome Table works great with images, videos, hyperlinks, and almost anything from the web.
 
VISUALIZATION TYPES
 
We have 8 main view types: table, cards, google maps, charts, geochart, org chart, gantt chart, and slideshow.
 
MAIN BENEFITS AND FEATURES
 
➤ No coding skills required: if you can make a spreadsheet, you can make an Awesome Table.
➤ Filters and search: easily add interactive and intuitive filters and full text search, directly from the spreadsheet.
➤ Embed anywhere: embed your Awesome Table on any site, including Google Sites, Wordpress, Microsoft Teams, Sharepoint, Lumapps, Happeo, Wix, Confluence, Weebly, and Squarespace.
➤ Easy data management: updating your data is as easy as editing the spreadsheet. Anybody can do it.
➤ Ready-to-use templates: make your app in minutes by starting from a premade template from our template gallery.
➤ Fully customizable: know how to code or work with developers? Fully customize your Awesome Table with HTML, CSS and Javascript.
➤ Safe and secure: Awesome Table never uploads your data to our servers. They are fetched at display time from your browser.
➤ Easy permissions management: manage permissions directly from your spreadsheet. Whoever can see your sheet can see your app.
➤ Web-friendly: works well with images, hyperlinks, and videos.
➤ Usage reports: track all your Awesome Tables’ key stats in the usage metrics dashboard.
 
THE AWESOME TABLE ADVANTAGE
 
Awesome Table is both simple and extensible, It is made for data that often needs to be changed and with privacy in mind:
➤ Nocode tools such as Appsheet, Smartsheet, Bubble, Parabola, Adalo have more features but are complex to configure. While presented as “no-code”, they still require an expert of the tool to build something with it, and editing the data is difficult. They are also inflexible, meaning if you actually know how to code, even a little bit, there is no way that you can use your skills to extend or customize your app in those applications, and they instead make you jump through huge amounts of configuration options.
➤ An enterprise CMS is great for working with static data that is controlled by a global communication team. However, for data that changes regularly, and needs to be edited by business users, Awesome Table is the best. It even easily integrates with Lumapps, Happeo, Sharepoint and Microsoft Teams.
➤ Awesome Table never uploads or stores your data on its servers, unlike most other tools. Your data stays in your spreadsheet, and is fetched at display time. More details below.
 
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 Awesome Table?
➤ We have an extensive documentation with many examples available here: https://support.awesome-table.com/
➤ Contact our lovely support agents directly here: https://support.awesome-table.com/hc/en-us/requests/new
➤ Create your first Awesome Table Tutorial:
https://support.awesome-table.com/hc/en-us/articles/115004265825-Tutorial-Create-your-first-Awesome-Table-app 

COMPANION ADD-ONS
 
Use Add-ons to easily pull data from various sources in your spreadsheet
 
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.
➤ 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.
➤ Advanced summary: easily analyse your Google Form results.
➤ Publication workflow: create workflows in seconds to automate publication validation process.
➤ Sites catalog: List all Google Sites you have access to (admins can list all sites on a domain). 
 
 
PRIVACY - DATA SECURITY - GDPR - HIPAA
 
Awesome Table 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
 
OUR OTHER PRODUCTS
 
If you like Awesome Table, you might like our other add-ons:
Yet Another Mail Merge (YAMM): most popular mail merge tool for Gmail
Form Publisher: most popular document merge tool for Google Forms
 
TOP RATED APP
 
Awesome Table  is one of the most popular and best rated app on the Google Workspace marketplace among others, such as 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 and more...
 
Other use-cases: item list, performance statistic, business report, project scheduling, audience rating, product catalog, announcement list, photo gallery, FAQ, online bookstores, video library, people directory, project portfolio, weekly planner, task manager, product inventory, marketing action plan, contact list, movies gallery, lead tracking, salesforce reports, CRM views, hubspot reports, Zendesk tickets, etc.
Additional information
PricingPaid with free features
Privacy policy
Terms of service
Awesome Table will ask for the permissions shown below. Learn more
Awesome Table will need access to your Google account
This will allow Awesome Table to :
See, edit, create, and delete all your Google Sheets spreadsheets
See, edit, create, and delete only the specific Google Drive files you use with this app
View and manage spreadsheets that this application has been installed in
See all your Google Sheets spreadsheets
View your email messages when the add-on is running
Run as a Gmail add-on
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
View your country, language, and timezone
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Patricio Diez
October 18, 2016
AwesomeTable allows us to control quality of delivery As a worldwide training services provider (www.appstrainer.eu), our team manage a network of 450 trainers. For each of our trainers, we collect feedback at the end of each training session with Google form. Our responses sheet has now more than 40 000 lines making it impossible to easily read through. With just a click, we plugged AwesomeTable into our response sheet and now have a fast and efficient dashboard to analyse quality results per trainer, per country or even filter on lower grades to help improve our practice.
Is this review helpful?
Yes
No
Profile Picture
Gabriele Pozzi
December 6, 2016
Really Awesome. Thanks to this app it's possibile to create views from spreadsheet to surf data in a very fast way. Reporting has never been so easy and fast.
Is this review helpful?
Yes
No
Profile Picture
Aileen Sullivan
March 1, 2017
Using this to sort through athlete performances in track and field is opening a whole new world for having access to multiple data sources quickly.
Is this review helpful?
Yes
No
Profile Picture
Sami Azzouni
October 17, 2016
User-friendly and efficient!
Is this review helpful?
Yes
No
Profile Picture
Preserve_Ian Napier
October 17, 2016
Meets a real need (huge gap left by Google) to display selected Google Sheets data within Web pages. Glad I stumbled across this (saved me working out how to build something - much more inferior - like it)!
Is this review helpful?
Yes
No
Profile Picture
Jardín Antioquia
April 6, 2017
Thanks to Awesome Table I create a service easily! Thank you!
Is this review helpful?
Yes
No
Profile Picture
Georges Reuland
October 17, 2016
Just... Awesome !
Is this review helpful?
Yes
No
Profile Picture
Jeff Earls
February 3, 2021
Awesome Table is AWESOME!!! Awesome Table is the fastest and easiest way to transform your data into an extremely powerful and accessible web application... Feed it a spreadsheet, tweak the layout and you've just solved your data presentation problems!
Is this review helpful?
Yes
No
Profile Picture
SOMA LYCATEL
February 28, 2017
awesome
Is this review helpful?
Yes
No
Profile Picture
Mike Donghia
February 24, 2021
Very simple way to build a visual dashboard for information that exists in a spreadsheet/database format.
Is this review helpful?
Yes
No
1-10 of 166
Search
Clear search
Close search
Google apps
Main menu