Import data in Google Sheets

Import data from third party sources and APIs into Google Sheets.
Schedule automatic refreshes to periodically update your data.
Install the Google Sheets add-on
Awesome table import data illustration
StarStarStarStarHalf Star
4.6 / 5 • 10M+ users
Google Workspace Marketplace LogoGoogle Workspace Marketplace
The easiest way to import your data from a third
party data source to your spreadsheet
There is no need to know how HTTP or APIs work. We make it easy for you.
Awesome Table delivers the requested data
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.
Any REST APIAny REST API
FigmaFigma
Google DriveGoogle Drive
Google PhotosGoogle Photos
Google TasksGoogle Tasks
HubspotHubspot
NotionNotion
StripeStripe
UnsplashUnsplash
VercelVercel
YoutubeYoutube
ZendeskZendesk
COMING SOON
TikTokTikTok
TikTok AdsTikTok Ads
TwitterTwitter
AirtableAirtable
Microsoft ExcelMicrosoft Excel
Google SheetsGoogle Sheets
ShopifyShopify
GitHubGitHub
Google AnalyticsGoogle Analytics
Google BigQueryGoogle BigQuery
Google DatastoreGoogle Datastore
Google My BusinessGoogle My Business
TrelloTrello
QuickbooksQuickbooks
SlackSlack
Couldn't find the connector you were looking for?
We're constantly building new data source connectors based on our customers' needs.
If we don't yet offer a connector you'd like to use, please fill the request form.Suggest a new connector
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!
Main benefits and features
Icon solutions - Friendly authentication helper
Friendly authentication helperSign in with OAuth2, basic authentication and API keys.
Icon solutions - Multi accounts
Multi accountsSave and use multiple accounts on the same data source.
Icon solutions - Intuitive data fetcher
Intuitive data fetcherWe make it very easy for you to choose the data you want to import.
Icon solutions - Precise scheduler
Precise schedulerYour queries will run at the exact time you want them to run thanks to our top-notch scheduler.
Icon solutions - Interactive query history
Interactive query historyEasily track and reuse queries you've run before.
Icon solutions - Saved queries
Saved queriesSave queries for later, easily reuse in a different spreadsheet.
Icon solutions - Automatic pagination handling
Automatic pagination handlingEasily extract as many pages of data you need (as long as it fits in a Google Sheet).
Icon solutions - Advanced JSON to Sheet support
Advanced JSON to Sheet supportMultiple JSON to Sheet conversion options, and filtering with JMESPath.
Icon solutions - Email notifications for scheduled queries
Email notifications for scheduled queriesGet notified by email when your queries have run.
Awesome Table Google Workspace Marketplace iconUsed and loved by millions on Google Workspace Marketplace
Share the quota with your colleaguesCreate a team and share the import quota with the members.
Awesome Table Teams illustration
Copyright © 2021 Awesome Gapps Inc. All rights reserved.
Awesome Table Google Cloud Partner