Google Sheets: Append a row

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.

Use case

• 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.

How to configure this action

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 Coconut, JP, 1.75, and 30 to the last row, you would define the Columns and Values fields as such:

• Columns: A,D
• Values: Coconut,JP,1.75,30

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:

• Columns: A,D
• Values: Coconut,JP,,30

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 B,C or D,F instead of a large range like A,J.

This action requires a preconfigured Google Drive integration. For more information on integrating PagerDuty Workflow Automation with other systems, please refer to the Integrations section of our help center.

Fields for this action

• Integration

  • Select your Google integration from the options. These are your team’s integration accounts

• Spreadsheet URL or ID

  • URL, ID, or reference field to the spreadsheet

• Sheet name

  • The default value is Sheet1

• Columns

  • Specify the starting and ending columns in a comma-delimited list
  • These are the names of each column, usually labeled in row 1

• Values

  • 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

What will this output?

This action will output a confirmation that the new Google Sheet row was appended to the spreadsheet.