Get pre-built functions for APIs and cloud services in a just few seconds. Or create custom lookups from your own files and spreadsheets in just a few minutes.
Do I need to know how to code?
Nope! Flex.io provides pre-built functions for popular services out-of-the-box that work just like
=IF() in your spreadsheet. However, if you do code, you can fork our integration scripts and modify as you wish.
What services can I connect to?
We focus on services that populate spreadsheets with custom data extracts or single row enrichments. For example, pull information from CRM systems like HubSpot or Pipedrive, enrichment services like Hunter or Crunchbase, or file systems like Dropbox or GitHub.
What if I need to connect to a different service?
So long, CSV extract. Get instant access to all your apps directly from your spreadsheet.
How do I add the plug-in?
It's easy. For Excel 365, go to the Microsoft App Page and click the "Get it Now" button. For Google Sheets, go to the Google App Page and click the "Install" button.
How I know what syntax to use?
Documentation is integrated with each function. In the add-on, you'll see the syntax and description for each function. and can click on 'Details' for full description of the syntax, arguments and properties. Then, simply click the copy button to paste the function into a cell.
How do I use a Flex.io function?
It's as simple as using any other function, like
=IF(). For example, here is a function that gets data from the enrichment service FullContact:
You've got credentials but your teammate needs data? No problem. You connect to your source and then control what gets shared.
How can I share my functions?
Just go to the Members tab and click the "Add Members" button. Add your teammate's email address and click "Send Invites". Each invitee will receive an email asking them to set up an account. After signing up, they'll immediately be part of your team and can have access to your functions.
Can I control what teammates can do?
Of course! You control the permissions for each member. Choose User to grant read-only access for analysts. Choose Contributor or Administrator to grant ability to also edit functions, connections and members.
How does the team get my functions in their spreadsheet?
After your invitation and their sign up; they simply need to install the add-on for Excel or Google Sheets and log in to see your functions. And, if you add a new function, they can simply click the refresh button in the add-on and instantly get your update.
Skip the CSV-extract-to-shared-network-drive set up. Broadcast on-demand, refreshable data from internal databases, files or APIs right into their spreadsheet. Or deliver read-only custom lookups to access master data files and systems of record.
What languages do you support?
Python and Node.js, including many common libraries out-of-the-box such as requests, pandas, and beautifulsoup4 (for Python) and lodash, axios and moment (for Node.js).
What's the best way to get started?
We'd suggest forking one of our open-source integration functions in GitHub. But, please let us know if you need any help and we'll be happy to jump in and assist!
Any suggestions for development workflow?
Sure, here's how we do it, but let us know if you need help!:
- Git clone the functions repo inside a Dropbox folder.
- Connect to that folder using a Flex.io connector.
- Edit and test the functions in Insomnia via Flex.io API call.
- Once finished, push to the Git repo.
- In Flex.io, use New > Function mount to add the functions.