Google Spreadsheets is a Web-based application that allows users to create, update and modify spreadsheets and share the data live online. The Ajax-based program is compatible with Microsoft Excel and CSV (comma-separated values) files.
How to connect
- In Gtmhub, navigate to Setup -> Data Sources screen.
- Click the Add new data source button.
- From the Choose a connector dialog, select the Files tab and then Google Spreadsheet
Give a name for the connection:
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:
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.
Select the entity you want. Then choose its sync schedule:
Authorization failure: HTTP protocol error. 401 Unauthorized. Invalid Credentials :
If you encounter such an error when you attempt to sync a data source it is most probably due to the fact that you have added multiple connections for the same Google Spread Sheet account. Google provides an access token refresh mechanism only for one connection per application. Therefore any subsequently added connection will work for a brief period of time. To ensure the proper synchronization of your data - create all data sources using the initial connection that was added to your Gtmhub account. If you do not know which of your connections is the initial one you can remove Gtmhub`s access to your Google account like this:
- Click on "Security" section in your Google Account and on "Manage third-party access"
If this is not an option you can contact our support team for instructions how to revoke previous connections.