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
If you intend to set up the connection using a service account, you may need to log in to Gtmhub as the service account before completing the steps below. It may be helpful to use a different browser or an Incognito/Private Browsing window.
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.
For files stored in SharePoint document collections, the account that you set up the connection with must be a member of the site to see the file. Sharing a specific file with the user account will not display the file in the selection list if the user does not also have access to the site that contains the document..