Extract data from an API or web service without ever leaving your spreadsheet using the function =FLEX().
Flex.io is a platform that translates data stored in cloud services such as Wikipedia, Intercom and Quandl into simple lookup functions that anyone can use inside their spreadsheet.
Easily pull in 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.
(PLEASE NOTE: Some API integrations require that you first have an account with that cloud service provider. For example, to use the Flex.io Dropbox integration, you'll need a Dropbox account).
HOW DOES IT WORK?
Instead of using a traditional function like =SUM() to add up a column of numbers, you simply use the Flex.io function =FLEX() to pull in data from remote data sources.
For example, here is a function that gets data from the enrichment service FullContact:
| email@example.com |
SYNTAX in A2:
=FLEX("team/fullcontact", A1, "full_name, twitter_url")
RETURNS new data to cells A2:A3
| firstname.lastname@example.org | Bill Gates | https://twitter.com/BillGates |
WHAT ELSE CAN I DO?
Current out-of-the-box, integrations that do not require any coding 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, and many more. New nocode 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 https://www.flex.io/ and we'll be happy to help!