New Row
Trigger a flow when a new row is added to a spreadsheet.
You may experience delays where data isn't returned consistently at every polling interval, but data loss isn't expected.
For limitations on this event card, see Known issues and limitations for Google Sheets connector.
Options
| Field | Definition | Type | Required |
|---|---|---|---|
|
Use Spreadsheet ID? |
Option to specify a Google Sheets spreadsheet by ID. If you select No, select a spreadsheet from the Spreadsheet dropdown list and ignore the Spreadsheet ID field. If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown list isn't populated. Select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown list and enter an ID in the Spreadsheet ID field. The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps. |
Dropdown | TRUE |
|
Spreadsheet |
List of spreadsheets in your Google Sheets account. Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option. |
Dropdown | TRUE |
|
Spreadsheet ID |
Unique identifier for your selected spreadsheet. |
Text | FALSE |
|
Worksheets |
List of worksheets in the spreadsheet. |
Dropdown | TRUE |
Define the polling intervals in the connector Schedule dialog. See Set schedule options.
Output
In addition to the Row Number field, custom column headers from row 1 of your selected spreadsheet make up the output fields.
| Field | Definition | Type |
|---|---|---|
|
Row Number |
Location of the new row. |
Text |
|
Row |
Row content for each column. |
Text |