What is Awesome Table?

With no technical skills required, you can use Awesome Table to achieve the following two things:

import data from third-party applications, such as Hubspot, Zendesk, or REST APIs, into Google Sheets
showcase data as interactive catalogs, directories, FAQs, Google Maps, or Gantt charts to be embedded in your website or intranet.

Import data in Google Sheets from business applications and APIs

Awesome Table includes an add-on for Google Sheets with which you can set up data imports by using any of the built-in connectors or by using the REST API connector to import data from REST APIs.

Import data with our built-in connectors

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 table below provides an overview of the data you can import with the built-in connectors.

Connector	Data you can import
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
Google Drive	Files & folders Shared drives
Google Photos	Albums Photos & videos Shared albums
Google Tasks	Tasks from a list Tasks lists
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
Notion	List databases List users Search
Stripe	Customers Charges Disputes Invoices Prices Products Refunds
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	Business hours Ticket metrics Search tickets (by assignee, commenter, tags, date of creation, created by user, status)
Unsplash	You can configure the Unsplash Connector to import data as specified in the Unsplash API Documentation.
Vercel	You can configure the Vercel Connector to import data as specified in the Vercel API Documentation.

For example, you can easily import your YouTube channel subscriptions as data in Google Sheets.

And you can then easily turn your YouTube channel subscriptions data into an embeddable Table app for your website.

Copy this template

info For more information about how you can use the visualization types in Awesome Table to easily present the imported data, see Select the best app type to showcase your data.

Import data from any REST API service

If you want to import from a data source for which there is no built-in connector yet and you know what REST APIs are and how to use them, you can then use the REST API connector.

It provides all of the necessary options to establish an authenticated connection and to quickly configure a data query.

For example, with the free REST API at coingecko.com, you can import crypto markets data:

Coingecko API Reference	https://www.coingecko.com/en/api/documentation
REST API Request URL	https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc&per_page=100&page=1&sparkline=false&price_change_percentage=24h

Schedule data imports

You can schedule regular data imports with the built-in and the REST API connectors.

You can schedule your data queries to run every 30 minutes, hourly, daily, weekly, or monthly and configure the updates your Awesome Table app will need.

All scheduled data imports configured in the current Google spreadsheet are available in the Scheduled tab.

Showcase your spreadsheet data

With minimum configuration and no developer or coding skills needed, Awesome Table can have your spreadsheet data displayed on a website in real-time.

Edit your data instantly by using "Sheets as a CMS"

With Awesome Table, you use Google Sheets as your CMS or database. You can edit your data directly in Google Sheets.

The data will be refreshed automatically at the next display. Awesome Table will always use the most up-to-date information from your spreadsheet.

And you can keep track of version history and editing changes.

Control access simply with Google Sheets sharing options

You can easily control who can see the data displayed in your Awesome Table app: it is the same list of people that have access to the underlying Google sheet.

07-at-sharing-permissions-google-sheets-sharing-list.png

Select the best app type to showcase your data

Configuring your data layout and presentation is easy with Awesome Table.

Awesome Table supports a wide range of data visualizations and presentation layouts which you can set up easily to make your data speak

App type	What it does
Table	Present your data interactively in a tabular format
Cards	Present your data interactively in a deck of cards
Maps	Create highly customizable interactive maps
Geochart	Explore location-based data at a glance
Charts	Create insightful analytics dashboards
Gantt chart	Display your project timeline interactively
Slideshow	Create a responsive slideshow
Org chart	Create an organizational chart

All app types are optimized to work on desktop and mobile screens.

You can review the following examples of apps which illustrate the various types of data layouts and presentation styles you can achieve with Awesome Table.

Copy this template

Use keywords to configure data visualization

You can easily fine-tune the visual display of information in Awesome Table apps by using keywords.

Keywords are used in the second row (under the table header) to quickly configure or switch to more appropriate data visualizations.

For example, if you need to display the images from Google Drive links, transform CSV values into bulleted lists, or hide table columns from appearing in the app, setting the appropriate keyword is all that's needed.

Add interactive filters to quickly surface relevant data

To enable users to explore your data efficiently, you can easily create different types of user-facing filters such as full-text search, drop-downs, or range filters. All you need to do to enable a filter is to use one of the specific keywords.

A filter applies to one column of data.

Embed your apps on any website

You can embed Awesome Table apps in any website or intranet.

Embedding is as easy as clicking Embed in the Awesome Table dashboard, copying the embed code, and pasting it on your website. You can use the embed code in any website builder: Google Sites, Wordpress, Wix, and others.

Customize with HTML, CSS, JavaScript

If you are a web developer or have web developers in your team, Awesome Table makes it easy to apply any HTML, CSS, and JavaScript customizations you might need.

Awesome Table keeps your data separate from the HTML, CSS, and JavaScript code. This means that you can manage your data independently from the customizations and keep the work of the business owner and the web developer in your team cleanly separated.

In the video below, you can find a brief demonstration of how you can quickly change the background color of one of the elements in the app and refresh the app immediately to review the result.

Integrate with Microsoft Excel

You can configure a Microsoft Excel file to serve as the CMS or database for your Awesome Table web app/widget.

From the Awesome Table dashboard/web app, you can log in to your Microsoft Office 365 account and select your Excel spreadsheet.

To migrate from Google Sheets, you can just export your spreadsheet to Microsoft Excel and upload it to Office 365.

Use cases

Product catalog

Create filterable and searchable product catalogs that you can embed into your website. No need for complicated databases, manage all your products directly from a spreadsheet.

Copy this template

Store locator

You can create interactive maps with store locations and information, such as hours and contact details, so customers and internal teams can easily find the information they need.

Copy this template

Sales and marketing assets

Centralize all your digital sales and marketing assets in one place. Make finding images, presentations, templates, one-pagers easier with advanced filters and searches.

Copy this template

Filing cabinet

Create a filterable filing cabinet of documents, spreadsheets, and slides to easily manage them all in one place.

Copy this template

Frequently asked questions

Create an accordion-style FAQ that is easily expandable, searchable, and filterable.

Copy this template

Project management dashboards

Showcase all of your ongoing projects in an easy-to-understand display. Filters and search tools let you quickly find the projects you're looking for.