Integry Docs
  • Welcome
  • Sign up for a free trial
  • Apps
    • Overview
    • Authentication
      • Access Control and Testing
    • Passthrough Requests
    • Supported Apps
      • Accelo
      • Aircall
      • Constant Contact
      • Copper
      • Elastic Email
      • Fireflies
      • Insightly
      • Instantly
      • Ontraport
      • RingCentral
      • Sendy
      • ServiceTitan
      • ActiveCampaign
      • Jotform
      • ActiveTrail
      • Agile CRM
      • Aha!
      • Airtable
      • Amazon SES
      • Asana
      • Basecamp3
      • BirdSend
      • Breezy HR
      • Brevo
      • Campaign Monitor
      • Capsule CRM
      • Chargify
      • CleverReach
      • ClickUp
      • ClickSend
      • Cliengo
      • Coda
      • Constant Contact
      • ConvertKit
      • Copper
      • Customer.io
      • Delighted
      • Demio
      • Drip
      • E-goi
      • Eventbrite
      • EverAction
      • Everhour
      • Formstack
      • Freshdesk
      • Freshworks CRM
      • Mautic
      • Customer.guru
      • Front
      • FTP
      • GetResponse
      • GitHub
      • Google Contacts
      • Google Sheets
      • GoToTraining
      • Groove
      • Help Scout
      • HubSpot
      • Keap
      • Mailchimp Transactional
      • Mailjet
      • MailUp
      • MeisterTask
      • Monday.com
      • MoonMail
      • Moosend
      • Nimble
      • Notion
      • Ontraport
      • PagerDuty
      • Pipedrive
      • Pipeline
      • Salesforce
      • SendPulse
      • Slack
      • Snappy
      • SolarWinds
      • Stripe
      • SurveySparrow
      • Teamgate
      • Unbounce
      • Zoho Books
      • Zoho Campaigns
      • Zoho CRM
      • Zoho Mail
      • Zoom
  • Flows
    • Overview
    • Flow Tutorials
      • Sync data TO another app from your app
      • Sync data FROM another app to your app
      • Create a two-way flow
    • Build a Flow
    • Trigger a Flow
      • Multiple Triggers in a Flow
    • Steps in a Flow
    • Integrations
      • Runs
  • Functions
    • Overview
    • Try Functions in 60 seconds
    • Quickstart for AI
    • Viewing Function Calls
    • Source Functions
    • Agent Frameworks
      • LangChain/LangGraph
      • CrewAI
      • AutoGen
      • LlamaIndex
      • Haystack
      • Smolagent
      • LiteLLM
      • Mistral AI
  • Embedded UI
    • Embed Integry Apps Marketplace
    • Add Integry Apps to an Existing Marketplace
    • Render modes, layouts and styling
    • Embedding FAQs
  • APIs and SDKs
    • JS SDK Reference
      • React Web Apps
    • API Reference
  • Workspaces
    • Overview
    • Workspace Variables
    • User Variables
  • Users
    • Testing with Beta Users
Powered by GitBook
On this page
  • Specifications
  • Limitations

Was this helpful?

Export as PDF
  1. Apps
  2. Supported Apps

Google Sheets

PreviousGoogle ContactsNextGoToTraining

Last updated 6 months ago

Was this helpful?

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 authorization type. The auth token expires after 1 hour and a new token is generated via refresh token.

Trigger Type

It uses 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:

  1. The user has revoked your app's access (ref:)

  2. The refresh token has not been used for six months.

  3. 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.

Google Sheets
OAuth
poll-based
https://support.google.com/accounts/answer/3466521#remove-access