Add row to spreadsheet

The Add row to spreadsheet action adds a single row of data to a Google Sheets spreadsheet.

Connection

To begin using Sheets actions, you must first connect Flow to your Google Sheets account.

Fields

The Add row to spreadsheet action contains the following fields.

Fields used in the Add row to spreadsheet action.
FieldDescription
Spreadsheet URLRequired. Enter spreadsheet's URL that is displayed in the browser.
Tab nameRequired. Enter an existing tab name in the spreadsheet.
Row contents (comma separated)Required. Enter a comma separated list of fields. Each comma denotes a new column.

Triggers

The Add row to spreadsheet action can be used with any trigger.

Example

Example of a workflow that cancels an order when its risk level is high

In this example workflow, an order is canceled when its risk level is high.

API reference

Flow calls the Google Sheets API to add a row to a spreadsheet. To learn more, review the Google Sheets API.

Frequently Asked Questions

The data from Flow spans across multiple columns. Why is this happening?

Columns in Sheets are separated by commas. If the data from Flow could potentially include a comma, then the data will be split into multiple columns. To avoid this, use a liquid filter to remove commas. For example, use {{ order.note | replace:",", " " }} to replace commas with a space.

The data from Flow starts at the wrong column.

If your worksheet has empty values in the first few columns of the last row, then Sheets will insert the next column starting at the first column with content (docs). You can only fix this error by fixing your worksheet and by avoid entering blank values in spreadsheet.

I want to add a row for each line item in an order.

You can use Flow's For each action to loop through each line item and call the Add row to spreadsheet action for each of the line items.

I get a 403 error when I try to add a row to a spreadsheet. What does this mean?

Commonly, this means that the worksheet isn't accessible to the user that connected Google Sheets to Flow.

I get a 429 or 500 error when I try to add a row to a spreadsheet. What does this mean?

Commonly, this means that the worksheet is having trouble adding new rows. This can happen when the Google API receives too many requests or the worksheet has too many fields or rows.

Ready to start selling with Shopify?Try it free