Import data from any API, file, or database table into Google Sheets. Try free for 7 days.
Extract data from the API or web service you know and love without ever leaving your spreadsheet by using the function =FLEX().
Flex.io 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 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, 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 Flex.io 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 https://www.flex.io/ and we'll be happy to help.