Help & Support
Send Feedback API Import
Import data from any API, file, or database table into Google Sheets. Try free for 14 days.
437 users
Works with
Extract data from the API or web service you know and love without ever leaving your spreadsheet by using the function =FLEX(). is a platform that translates data stored in cloud services like Wikipedia, Intercom, and Quandl into simple lookup functions that anyone can use inside their spreadsheet.  

Easily import data from APIs or remote CSV files or even other spreadsheets with built-in integrations. Or, go off-road and create your own functions with Python or Node.js and common libraries like request, pandas, beautifulsoup, lodash, axios and moment. 

* Instant Integrations. Get on-demand lists and enrichments from web services out-of-the-box. Enrich lead lists with services like Hunter, FullContact, and Crunchbase. Get custom lists of data from a CRM like Pipedrive and HubSpot. And many more.

* Instant Table Extracts and Lookups. Pull in refreshable extracts and lookups from your own local data systems and databases. Easily snap together key value lookup functions from file stores like Dropbox, Box and S3. Broadcast data extracts to your end users from master files in Google Sheets, Postgres, or MySQL.

* Roll your Own. Build your own custom spreadsheet functions with Python or Node.js. Go off-road and access just about API using your own code and then easily document your custom functions with YAML. Share and permission functions with your team without sharing your credentials.

How does it work?

Instead of using a traditional function like =SUM() to add up a column of numbers, you simply use the function =FLEX() to pull in data from remote data sources.   

For example, here is a function that gets data from the enrichment service FullContact:


| |


=FLEX("team/fullcontact", A1, "full_name, twitter_url")

RETURNS new data to cells A2:A3

| | Bill Gates | |

What else can I do?

Current out-of-the-box, nocode integrations include the following services:   Amazon AWS S3, Box, Crunchbase, Currency Conversion, Dropbox, FullContact, GitHub, Google Drive, Google Sheets, Hacker News, HubSpot, Hunter, Intercom, MySQL, Pipedrive, Postgres, Product Hunt, Quandl, Sample Data from Faker, Shopify and Wikipedia, among others.  

Other services that can be implemented with code include: ActiveCampaign, Airtable, Algolia, AngelList, Anymail, Apify, Asana, Autopilot, Aweber, Azure, Basecamp, Bing, Bitbucket, Bubble, Buffer, Calendly, Campaign Monitor, Capsule, Chargebee, Chatfuel, Clearbit, ClickFunnels, Coinbase, Constant Contact, ConvertKit, Dandelion, DataBox, Discord, Disqus, Docupilot, Drip, Egnyte, Elasticsearch, EmailHippo, Etsy, Eventbrite, Evernote, Facebook, Facebook Ads, Feedly, Fieldbook, Firebase, Flickr, Foursquare, FreshBooks, Freshdesk, Front, FTP, G2Crowd, GetResponse, GitLab, Google Maps, Gravity Forms, Harvest, Help Scout, HipChat, Hootsuite, HTTP, IFTTT, Indeed, Infusionsoft, Insightly, Instagram, Integromat, Invoice Ninja, JIRA, Kickbox, KissFlow, Klaviyo, Knack, Leady, LinkedIn, LionDesk, Listrak, Magento, Mailchimp, Mailgun, Mandrill, ManyChat, Marketo, Mattermark, Mattermost, Medium, Meetup, MessageBird, Microsoft Teams, MongoDB, MonkeyLearn, Moosend, Moz, NetSuite, Ninox, OneDrive, OneNote, Paperform, Patreon, PayPal, Pinterest, Pipefy, Pipeline Deals, Pitchbook, Plivo, Plutio, Pocket, Podio, Quickbooks, RAYNET, Rebrandly, Recurly, Reddit, Redshift, RSS, Runkeeper, Salesflare, Salesforce, ScheduleOnce, Segment, SendGrid, SendinBlue, SendPulse, Sendy, ServiceNow, SFTP, ShipStation, Shopio, SigParser, Slack, Smartsheet, SoundCloud, Spotify, SQL Server, Square, StackExchange, Streak, Stripe, SugarCRM, Survey Monkey, Teamgate, Telegram, Todoist, Toggl, Trello, Tumblr, Twilio, Twist, Twitch, Twitter, Typeform, Unbounce, Wasabi, Watson, Webflow, Weebly, Wild Apricot, WooCommerce, WordPress, Wrike, Wufoo, Wunderlist, Xero, YouTube, Zapier, Zendesk, ZeroBounce, Zoho and many more.

New service and API integrations are being added all the time. Don't see something you need?  Just let us know and we'll do what we can to add it for you. For further information and support, please visit us at and we'll be happy to help.
Benjamin Williams
January 8, 2020
This product achieves what I believe the future of the spreadsheet is: Gathering live data from around the Internet and integrating it into a dynamically updating spreadsheet.
Submit reply
David Wolfe
January 7, 2020
Too much $$$, not worth the purchase or download.
Submit reply
A User of API Import
November 15, 2019
Fast and powerful application that allows you to use siloed data from around the Internet to meet your needs within environments where your data lives and you have control. Devs have a genuine interest in what users are doing with data, and a passion for making the tool an indispensable part of their workflow. Strongly recommended!
Submit reply
1-3 of 3
Additional information
Clear search
Close search
Google apps
Main menu