Microsoft Excel Online is a Web-based application that allows users to create, update and modify spreadsheets and share the data live online.
How to connect
In Gtmhub, navigate to Insights -> Data Sources screen.
Click the Add new data source button.
From the Choose a connector dialog, select the Files tab and then Excel Online.
Give your connection a name.
Once you grant the necessary permissions to read data from your account you will be able to choose the spreadsheet you want to pull data from. Choose the folder where the spreadsheet is filed.
Note that when you select the spreadsheet you will be presented with a list of sheets inside the spreadsheet to choose from as your data source.
For example here we have an Excel Online spreadsheet with two tabs: For Gtmhub and Summary.
You can select the Excel Online tab name as the data source.
Give your data source a name and then choose its sync schedule.
Now you are ready to write Insights based on the data fetched from Basecamp. Learn more about how to create Insights here.
Every change that is made in a file stored in any of Microsoft’s online storage solutions will be reflected through their API and Gtmhub’s connector after 3-5 minutes.
If you make a change to your spreadsheet, wait 5-10 minutes after the last change to the file and re-sync. If the change involved changing a column heading or adding/deleting a column, you can check for a schema change and update the schema as necessary.