Known issues and limitations for Google Sheets connector

Be aware of some limitations to the Google Sheets connector that may impact your Flows.

Action or Event Card

Limitation

New Row event card:

Add new rows in a single spreadsheet.

A maximum of 300 rows are processed per polling interval. This New Row event card monitors spreadsheets based on their row count.

Updated rows are not included in the maximum number of rows that are processing in a polling interval.

New Row event card:

Add and remove new rows in a single spreadsheet.

A Flow will not be triggered when rows are added and then immediately removed, or removed and then immediately added back.

New Row event card:

Add blank rows in a single spreadsheet.

Blank rows will only trigger a Flow if they are added between rows with content.

New Row event card:

  • Add rows to a single spreadsheet in a Google sheet

  • Monitor the spreadsheet with one connection to the Google Sheets connector.

  • Use the New Row event card to trigger a Flow.

None. The New Row event card should detect new data as expected.

New Row event card:

  • Add rows to two or more spreadsheets inside the same Google sheet.

  • Monitor the spreadsheets with one connection to the Google Sheets connector.

  • Use two or more New Row event cards to trigger a Flow.

None. You may experience delays where data is not returned consistently at every polling interval, but data loss is not expected.

New Row event card:

  • Add rows to a single spreadsheet in a Google sheet

  • Monitor the spreadsheet with two different connections to the Google Sheets connector.

  • Use the New Row event card to trigger a Flow.

The New Row event card will not detect new data or trigger a Flow as expected.

Related topics

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation