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|
You can configure the Vercel Connector to import data as specified in the Vercel API Documentation.
You can configure the Unsplash Connector to import data as specified in the Unsplash 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.
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.
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.
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.
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.
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.
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.
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.
Create a filterable filing cabinet of documents, spreadsheets, and slides to easily manage them all in one place.
Frequently asked questions
Create an accordion-style FAQ that is easily expandable, searchable, and filterable.
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.
Build a playlist of videos for online courses, recorded webinars, personal use, and others.
Quickly create a visualization dashboard for your data. Make it easier for users to filter the results.
Make finding the right person easy with a filterable list of all the members of your organization.
Remote equipment catalog
Offer a catalog of products that your employees can request to set up their home office or remote work.
Enterprise app store
Build an app store with Awesome Table to promote approved business apps and productivity tools.
Awesome Table with Google Forms
Utilize Google Forms to let users actively edit and add to the data of the Awesome Table.