Add rows in bulk action

This action adds multiple rows at the bottom of a selected sheet in Google Sheets.

Input fields

Input field	Description
Google Drive	Select either your personal drive or a team drive. Your personal drive is selected by default.
Spreadsheet	Choose the spreadsheet where to add new rows.
Enforce top-left insert	Choose to insert the new row into the leftmost logical table if multiple tables exist on the same sheet. The default is set to No.
Sheet	Specify the sheet where to add new rows. The sheet must contain at least one header row.
Rows source list	Provide a list datapill. For example, a list of rows in a CSV file. The action automatically iterates through all list items and creates multiple Google Sheet rows.
Rows fields	This section displays all the columns in the Google Sheet. Map the datapills under the list datapill (for example, CSV column names under the CSV Rows list datapill). The action iterates through all items in the list and creates multiple Google Sheet rows automatically.

Output fields

Output field	Description
Spreadsheet ID	ID of the spreadsheet.
Sheet name	Name of the sheet.
All rows successfully added?	Indicates whether this batch successfully added all rows.
Number of rows added	Number of rows in this batch that are successfully added.
Number of rows failed	Number of rows in this batch that failed to be added.
CSV contents of failed rows	Stores the contents of all failed rows.
List of batches	This action adds rows in small batches to optimize performance. This datapill lists all batches, which you can iterate through.

How to configure this action

Complete the following steps to configure this action:

1

Select the Google Drive, Spreadsheet, and Sheet to which you plan to add rows.

Select the Google Drive, Spreadsheet, and Sheet that you plan to add rows into

2

Fields corresponding to the sheet columns appear. Configure the mappings to create multiple rows in the sheet.

In this example, we map the CSV columns from the Box New CSV file in folder trigger into the Google Sheet columns. The action then iterates through the rows from the Box CSV file and adds them to the Google Sheet.

Configure the mappings to create multiple rows in the sheet