Frequently Asked Questions
Answers to common questions
Can I share data from an integration with my team?
How can I share my integrations?
How does my team get my functions in their spreadsheets?
Can I control what teammates do?
Can I turn off access to my integrations?
Flex.io is a cloud service for directly integrating data from web apps into Microsoft Excel and Google Sheets. Flex provides a simple way to lookup data from any web app or API using spreadsheet functions: type a formula and get the data you want.
- Get live, refreshable data from CRMs like HubSpot, Pipedrive and Intercom
- Enrich customer lists with services like Hunter, FullContact, and Crunchbase
- Work with order and product data from Ecommerce stores on BigCommerce and Shopify
- Directly integrate data from multiple web apps in your own spreadsheet
- Share current data from your web apps with members of your team
Flex.io’s integration with Excel and Google Sheets couldn’t be easier. Simply get the Excel 365 or Google Sheets add-on, sign in with your Flex.io account, and then use the
=FLEX() function. When you add the
=FLEX() function to a cell in your spreadsheet, Flex.io automatically loads a refreshable set of data from your web apps using pre-built integrations. You can also use a range of spreadsheet templates for different apps to get started immediately.
It’s as simple as using any other function in your spreadsheet, like
=IF(). Just add the
=FLEX() function to a cell in your spreadsheet and it will automatically load the data you request from your web app.
Documentation is included with each function. In the add-on, you’ll see the syntax and description for each function. and can click on “Details” for a full description of the syntax, arguments and properties. Then, simply click the copy button to paste the function into a cell. You can also look up the syntax for each integration in our Functions and Syntax guide.
Sure. Here are examples for a few functions you can try immediately.
Check out our Getting Started guide to get going!
Click on the message icon in the lower-right of this page or the application and type away. Or email us at firstname.lastname@example.org. We’d love to help you!
It’s easy. Just sign up for a Flex.io account and get our spreadsheet add-on for Excel 365 or Google Sheets. During the sign-up process, you can pick the web apps you want to work with along with some templates to get you set up with immediate access to data from these apps.
Nope! Flex.io provides pre-built functions for popular services out-of-the-box that work just like other functions in your spreadsheet, like
=IF(). However, if you do code, you can fork our integration scripts and modify as you wish.
In most cases, the only thing you’ll need to set up an integration is your access credentials for the web app, such as your username and password, or an API key if the app requires this. For a few integrations, some additional setup may be needed. For specifics, visit our Functions and Syntax guide, select the integration you want to use, and see the “What you need” section.
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.
We’re adding more integrations all the time, so let us know what you need! Or, if you’re a developer, you can quickly build your own custom integration for your team.
Yes! You’ll need to have the Team edition or a higher tier to have access to team features. Flex.io is a multi-user app designed to make it easy to share data from web apps with your team and their spreadsheets.
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 integrations and functions.
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.
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.
Yes, absolutely. You can remove access for any teammate at any time. Just go to the Members tab and select “Remove” from the dropdown menu to the right of their name.
- Go to the Account Settings Profile tab.
- Enter your new username.
- Save the changes.
- Go to the Account Settings Password tab.
- Confirm your current password.
- Enter your new password.
- Save the changes.
- Go to the Forgot Password page.
- Enter your email address.
- Click the “Send Reset Instructions” button.
Please ask us! Click on the message icon in the lower-right of this page or the application and type away. Or email us at email@example.com.
Here’s our Getting Started guide that will step you through how to get going.
Here’s our current pricing.