Export data from Salesforce, Quickbooks, and many other sources to Google Sheets™. No technical skill required.
Informações atualizadas:1 de maio de 2024
Verificação de segurança independente
Compatível com:
12 mi+
Visão geral
Awesome Table has two products:

➤ Connectors: schedule data exports from applications such as Salesforce, Quickbooks, Hubspot, Facebook Ads, Zendesk or databases like MSSQL, MySQL, PostgreSQL or BigQuery (~40 different sources), 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.


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

We integrate with roughly 40 sources. The full list is available here:

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).

✅ 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

🔹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. 
🔹Figma - Keep track of comments, components, and frames by file and monitor your team components, projects, and styles.
🔹GitHub - Integrate with Google Sheets™ to sync your own or public repository issues, comments, commits and pull requests.
🔹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.
🔹Unsplash - Easily log in with Unsplash and use 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.

✅ Productivity, project management

🔹Google Maps™ Geocode - Convert addresses into geographic coordinates and vice versa.

✅ 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

🔹Facebook Ads - Export data related to your advertising campaigns, ad sets, and individual ads.
🔹Google Analytics 4™ - Run analytics, including pageviews, sessions, and users. Additionally, segment the data by device type, country, and page.
🔹Google Analytics 3™ - Run analytics, including pageviews, sessions, and users. Additionally, segment the data by device type, country, and page.
🔹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 Trends™ - Explore and analyze the popularity of search terms on Google Search over time and across different geographic regions.
🔹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 more.
🔹YouTube Analytics - Run analytics and access videos and playlist reports from your channels.


🔹Google BigQuery - Input an SQL query and get the data directly in your spreadsheet
🔹MySQL - Export data from tables, databases, and query results in various formats, including SQL, CSV (Comma-Separated Values), and XML.
🔹PostgreSQL - Export data from tables, databases, and query results in various formats, including SQL, CSV (Comma-Separated Values), and other text-based formats.
🔹SQL server - Export data from tables, databases, views, and query results in various formats, including SQL scripts, CSV (Comma-Separated Values), Excel, XML, JSON, and other text-based formats



❓Need some help?

➤Get started with Awesome Table

➤ Run your first request (Zendesk example)

➤ Many other examples available here: www.awesome-table.com/connectors/help/export-to-google-sheets

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


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.
We have 8 main view types: table, cards, maps, charts, geochart, org chart, gantt chart, and slideshow.
➤ 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. 

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 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.

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://awesome-table.com/connectors/help/data-security
Informações adicionais
PreçosSem custo financeiro com recursos pagos
Política de Privacidade
Termos de Serviço
O Awesome Table pedirá as permissões abaixo. Saiba mais
O Awesome Table precisará de acesso à sua Conta do Google
Isso permite que o Awesome Table faça o seguinte:
Ver, editar, criar e excluir todos os seus arquivos do Planilhas Google
Ver, editar, criar e excluir apenas os arquivos do Google Drive que você usa com este app
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Ver todos os seus arquivos do Planilhas Google
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Conectar a um serviço externo
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Ordenar por:
O Google não verifica avaliações nem classificações. Saiba mais sobre as avaliações
Profile Picture
Rodrigo Lopes
22 de julho de 2023
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
7 de maio de 2018
Mais de 8 milhões de usuários e... apenas 196 avaliações (em 07/05/2018) e 2 comentários (idem)? Os poucos recursos e templates que utilizei não funcionaram! Os add-ons pedem acesso amplo geral e irrestrito aos seus conteúdos, mas parecem não entregar nada funcional.
Esta avaliação foi útil?
Profile Picture
Caique Amaral
3 de novembro de 2020
Realmente muito bom, pena que não vi que era pago.
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
4 de fevereiro de 2021
O suporte me atendeu muito bem e muito rápido pra tirar dúvidas, recomendo!
Esta avaliação foi útil?
Profile Picture
wildes Marcio
6 de outubro de 2020
muito bom
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
2 de julho de 2019
Es increíble! Fácil de usar. Simplemente maravillosa.
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
20 de março de 2019
É realmente incrível, ainda mais a tabela de feeds que permite alterar o design usando CSS3, Awesome!
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
26 de dezembro de 2018
Fantastic tool! Really awsome! Thank you very much!
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
11 de março de 2018
Achei incríveis as tabelas com a funções de mapas.
Esta avaliação foi útil?
Profile Picture
Um usuário do Awesome Table
31 de agosto de 2017
Congratulations for this amazing tool... many thanks.
Esta avaliação foi útil?
1-10 de 10
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal