Awesome table import data illustration

Get data from many sources into Google Sheets

No technical skills required:
anyone can do it
Try now for FREE
No credit card required.
Trustpilot
How it works
Get data in Google Sheets in a few clicks
1
Connect to data source
Easily connect to Shopify, Salesforce, Hubspot, Jira, Google Analytics, Quickbooks, Zendesk, Stripe and many others.
How it works step
2
Choose the data you want with intuitive filters
Adjust your export with the filters you're used to: dates, keywords, numerical values and more.
How it works step
3
Customize and preview before importing
Rearrange, rename or exclude columns. Transpose rows and columns.
How it works step
4
Your data gets imported into your spreadsheet in seconds
You can now focus on building your analyses and reports!
How it works step
5
Schedule an automatic refresh up to every 15 minutes
Get email notifications when your data is ready.
How it works step
A growing number of user-friendly connectors
Our user-friendly connectors allow you to sign in and configure your imports easily.
Also, you can connect your spreadsheet manually to any REST API.
Accounting
CRM, Customer Service
Dev & Design
Any REST APIAny REST API
FigmaFigma
GitHubGitHub
JiraJira
UnsplashUnsplash
VercelVercel
E-Commerce
Productivity
Crypto and Defi
Google Workspace
Marketing
Databases
COMING SOON
MailchimpMailchimp
Similar WebSimilar Web
Google My BusinessGoogle My Business
SlackSlack
TrelloTrello
Don't see your tool of choice listed above?
We're adding connectors for new data sources continuously.
If you have a specific connector in mind, please let us know.
Suggest a new connector
Your data is kept private and secure with Awesome Table
Secure credentials storage
Your credentials (API key, OAuth token, Username/Password) are stored securely (AES-256 encryption) on Awesome Table servers. They are not accessible from within the add-on or a spreadsheet.Learn more
Encrypted source data processing
Data is securely encrypted while it is in transit from the source to your spreadsheet. All communication with our servers is encrypted.Learn more
Isolated user data access
Your Awesome Table user data (account information, request and schedule configuration) can only be accessed by you and are stored encrypted on our servers.Learn more
Secure-by-design infrastructure
Awesome Table infrastructure is hosted on Google Cloud Platform to take advantage of the same secure-by-design infrastructure, built-in protection, and global network that Google uses.Learn more
Schedule import data
Schedule your imports and refreshes
With Awesome Table you can import data when it suits you the most. Set up hourly, daily, weekly or monthly refresh intervals in a few clicks, and get notified via email when your data is ready!
Share the quota with your colleaguesCreate a team and share the import quota with the members.
Awesome Table Teams illustration
Awesome Table Google Workspace Marketplace iconUsed and loved by millions on Google Workspace Marketplace