New Row

Trigger a Flow when a new row is added to a spreadsheet.

Unless otherwise indicated, field types are text.

Required fields are indicated by a red asterisk.

Options

  • Spreadsheet (drop-down): list of spreadsheets in your Google Sheets account

  • Worksheets (drop-down): list of worksheets in the spreadsheet

Output

In addition to the Row Number field, custom column headers from Row 1 of your selected spreadsheet make up the output fields.

  • Row Number: location of the new row

  • Row: row content for each column

Note

Note

This event monitors spreadsheets based on their row count.

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

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

A maximum of 300 rows are processed per polling interval.

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

Polling intervals are defined by you in the connector Schedule dialog. See Set schedule options

Related topics

Google Sheets connector

About the elements of Okta Workflows

Google Sheets API documentation