Google Sheets is a file and data management tool that manages your data, and sheets and lets you collaborate with your team in real-time. You can use its in-built formulae and charts to perform data analysis. It can be used to keep an eye on trends and stats with charts, pivot tables, and other data filters. Your data and sheets stay synchronized across all platforms, so you are up-to-date across all your devices. The Google Sheets App Connector manages and syncs rows with other third-party apps.
Specifications
Before you connect your Google Sheets account with Integry, here are a few things you need to learn about the Google Sheets App Connector.
Authorization Type
Google Sheets uses the OAuth authorization type. The auth token expires after 1 hour and a new token is generated via refresh token.
Trigger Type
It uses poll-based triggers. Integry will send a request to Google Sheets every 5 minutes to collect data. In case of an occurrence of selected events, a trigger will be received at Integry with the required payload. Therefore, when you set up an integration (in which Google Sheets acts as a trigger application) and perform an action in Google Sheets, expect a 5-minute delay for the trigger to be received at Integry.
Limitations
Following are the limitations of the Google Contacts App Connector.
The user's refresh token will stop working when:
- The user has revoked your app's access (ref:https://support.google.com/accounts/answer/3466521#remove-access)
- The refresh token has not been used for six months.
- The user account has exceeded the maximum number of granted (live) refresh tokens. The limit is 100 live refresh tokens. After the 101st token is added, it will revoke the first refresh token.