App Icon
Export data from many sources to Google Sheets™. No technical skill required.
Listing updated:November 26, 2022
Works with:
10,000,000+
Overview
Awesome Table has two products:

➤ Connectors: Export data from applications such as Salesforce, Jira, Hubspot or Zendesk into Google Sheets™ in a few clicks with the add-on for Google Sheets™

➤ Apps: Make your spreadsheet data accessible and searchable in a website or intranet as interactive catalogs, directories, FAQs, maps for Google Maps™, or Gantt charts with the app creation tool at app.awesome-table.com

Forget copy/paste and csv hell, focus on building reports and dashboards.

 
GETTING STARTED WITH CONNECTORS

After having installed our add-on for Google Sheets™:
1) Connect to a data source you want to import from
2) Choose the data you want to extract
3) Customize and preview before importing
4) Run your request
In a matter of seconds, your data appears in your spreadsheet!

Instantly connect, integrate & sync with, export & pull reports from:

✅ Accounting, Tax, Finance Ops

🔹Quickbooks - Connect to Google Sheets™ and export any report (including Balance Sheet, Profit and Loss, Statement of Cash Flows, and other segmented, detailed or summary reports) or raw data (including Accounts, Bills, Customers, Employees, Invoices, Items, Payments and Vendors)
🔹Xero - Integrate with Google Sheets™ and export any report (including Aged payables and receivables by contact, Balance Sheet, Budget summary, Executive summary, Profit and Loss) or raw data (including Accounts, Bank transactions and transfers, Contacts, Credit notes, Expense claims, Invoices, Payments, Purchase orders)

✅ CRM, Customer Support, Customer Service, Customer Success, RevOps

🔹Hubspot - Connect to Google Sheets™ and export your Contacts, Companies, Deals, Products, Properties, Quotes and Tickets
🔹Salesforce - Connect to Google Sheets™ and export your Reports, build sales funnels and understand your sales performance
🔹Zendesk - Export and monitor Support Tickets, and Comments on Posts and Articles

✅ Developer and Design tools, DevOps, REST API

🔹Jira - Integrate with Google Sheets™ and export issues, comments, projects, and user details. Search through issues using Jira Query Language (JQL). Analyze your team’s performance and productivity
🔹Figma - Keep track of comments, components, and frames by file and monitor your team components, projects and styles
🔹Google BigQuery - input an SQL query and get the data directly in your spreadsheet
🔹Github - Integrate with Google Sheets™ to sync your own or public repository issues, comments, commits and pull requests
🔹Unsplash - easily login with Unsplash and make use of Awesome Table’s intuitive API interface to get stats on photos, users and collections
🔹Vercel - use OAuth 2 to connect to Vercel and query any endpoint
🔹Any REST API - connect to your favorite API using an API key or your username and password, and use a table to configure your query instead of editing long URL paths. Query like a pro using JMESPath and your pagination method of choice. 

✅ E-commerce

🔹Shopify - Create custom dashboards and run your own analytics on exports of Abandoned checkouts, Customers’ contact details, Inventory levels, Orders and Transactions. Keep track of and report on your Locations, Discount Codes, Marketing events, Price Rules, Products and Product Variants
🔹Stripe - export your charges, disputes, refunds, invoices, customer details, and keep track of your prices and products

✅ Productivity, project management

🔹Airtable - Connect to any table using Awesome Table’s Airtable integration with Google Sheets™, and keep your data in sync
🔹Excel 365 -  Export your data from Excel to Google Sheets™ and keep it in sync
🔹Notion - Integrate with Google Sheets™ to list users and databases in your workspace. Keep an eye on updates to your documentation page by page

✅ Crypto, DeFi, BTC, ETH, finance, portfolio tracking

🔹CoinGecko - track and analyze current and historical prices, trading volumes and market caps of many coins including BTC, ETH, USDT, USDC, BNB, SOL, ADA, DOGE; monitor trading volumes by exchange, including derivative exchanges; get a global DeFi summary, build your own candle sticks with OHLC data, 
🔹DefiLlama - track current and historical total value locked (TVL) by protocol and chain, or across all chains

✅ Google Workspace™

🔹Google Contacts™ - export and keep track of your contacts, groups and directories
🔹Google Drive™ - search using advanced filters and export lists of files and folders to keep track of file changes, ownership and permissions
🔹Google Photos™ - export details of all your photos and albums
🔹Google Sheets™ - no more IMPORTRANGE, keep spreadsheets synced between themselves and your stakeholders up to date with what’s relevant to them
🔹Google Tasks™ - get a birds-eye view of all your todos and analyze your productivity

✅ Marketing, agencies, Marketing Ops, performance marketing

🔹Google Search Console™ - run analytics, including clicks, impressions, CTR and position by device, country, page, search query or type. Keep track of changes to your site maps
🔹Google Analytics 3™ - run analytics, including pageviews, sessions, users and segments by device, country, page.
🔹Google Analytics 4™ - run analytics, including pageviews, sessions, users and segments by device, country, page.
🔹Mailchimp [Coming soon] 
🔹Similarweb [Coming soon] 
🔹Youtube Analytics[Coming soon] 
🔹Google Trends™ [Coming soon] 
🔹G2 [Coming soon] 

✅Social media

🔹Twitter [Coming soon]
🔹Youtube: put Youtube’s API to work and monitor comments for individual videos or across your channel or other channels, export and analyze lists of videos, subscriptions, and much more 

✅Can’t find what you’re looking for? Not a problem - set up your own connection with our generic API connector, or let us know what integration you’d like to see
______________________________________________________________________________________________


❓Need some help?

➤Get started with Awesome Table
https://support.awesome-table.com/hc/en-us/articles/4415790572690-Start-Awesome-Table-Connector-add-on

➤ Run your first request (Zendesk example)
https://support.awesome-table.com/hc/en-us/articles/4415782299026-Log-in-the-Zendesk-Support

➤ Many other examples available here: https://support.awesome-table.com/hc/en-us/categories/4415790335634-Import-data

➤ Contact our lovely support agents directly here: https://support.awesome-table.com/hc/en-us/requests/new

‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗‗





CREATE APPS FROM SPREADSHEETS
 
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.
➤ Maps for 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, 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 for 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. 


COMPANION ADD-ONS
 
Awesome Table companion add-ons are easy-to-use and help you create an Awesome Table showcase 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 workspace domain and turn it into a table or cards app.
➤ Photo gallery: create a gallery from photos for use with Google Drive™ folder.
➤ Publication workflow: create workflows in seconds to automate publication validation process.

 
 
PRIVACY & COMPLIANCE - ISO 27001 - GDPR - HIPAA - FERPA - COPPA

Talarian, the company behind Awesome Table, is ISO 27001 certified.

Your data stays in your Google Sheets™. 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 YAMM 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.

Awesome Table has been certified by iKeepSafe to be FERPA and COPPA compliant.

All those provisions make Awesome Table safe to use.
 
Please find all the information you need about privacy, GDPR, HIPAA, FERPA, COPPA, our DPA and BAA here: https://support.awesome-table.com/hc/en-us/articles/360001374519


Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
Awesome Table - Data Connector for Sheets will ask for the permissions shown below. Learn more
Awesome Table - Data Connector for Sheets will need access to your Google account
This will allow Awesome Table - Data Connector for Sheets 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
Loading
Search
Clear search
Close search
Google apps
Main menu