Use this action to add a row of data to a pre-existing Google Sheet.
The data appended to the Google Sheet can come from a previous task in an instance. This helps remove the need to copy or type in data into your Sheet.
- Append employee contact info to a running contact list.
- Append financial data so your Sheet functions work with a larger data set.
- Append vendor info to store contact and pricing details.
This action appends a row onto the bottom most empty cell of a google sheet. To define which columns to populate in the bottom row, you define the Columns and Values. Take the following sheet as an example:
If you want to add the values
30 to the last row, you would define the Columns and Values fields as such:
You define the beginning and ending “range” of the row with the Columns field, and enter a value for each cell in that range with the Values field. Here’s how that looks:
If you wanted to leave the third cell empty in that range, like if no price was set for Coconuts, you could define the fields as such:
You must leave the third value empty, to leave the third cell empty. Here’s how that looks:
The number of cells in the range you define with Columns must match the number of values you provide in Values. For example, if your columns range was
A,J, you need to enter 10 values, which may look like:
value1,value2,value3,value4,value5,value6,value7,value8,value9,value10. And if you wanted to leave some of those cells blank, it may look like
value1,,value2,value4,,,,value5,value6,value7. You could also make a smaller range, like
D,F instead of a large range like
- Select your Google integration from the options. These are your team’s integration accounts
- URL, ID, or reference field to the spreadsheet
- The default value is Sheet1
- Specify the starting and ending columns in a comma-delimited list
- These are the names of each column, usually labeled in row 1
- Comma-delimited list of values to append to the spreadsheet
- Values may reference fields from prior tasks
- The number of values must match the number of columns
This action will output a confirmation that the new Google Sheet row was appended to the spreadsheet.
Thanks for your feedback
We update the Help Center daily, so expect changes soon.
Paste this URL anywhere to link straight to the section.