Import on-demand data from your favorite web services, directly in Excel and Google Sheets. Flex.io is a platform that translates data stored in cloud services like Wikipedia, Intercom, and GitHub into simple import functions that you can use without leaving your spreadsheet. Easily pull in data from APIs or external tables or files or even other spreadsheets with built-in integrations. Or, you can go off-road and create your own functions with Python or Node.js. * 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 CRMs like Intercom, Pipedrive and HubSpot. And more… * Instant Table Extracts and Lookups. Pull in refreshable extracts and lookups from your own data systems. 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 any data with your own code and then easily document your custom functions with YAML. Share 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 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: CELL A1: | [email protected] | SYNTAX in A2: =FLEX("team/fullcontact", A1, "full_name, twitter_url") RETURNS new data to cells A2:A3 | [email protected] | Bill Gates | https://twitter.com/BillGates | We're always looking to add new integrations so if you are missing something you'd like to see, just contact us and we'll do what we can to help! Thnx.
