How to create rows in Google Sheets from Data Table with Zapier

In this article, we are going to show you how you can use Data Table and Zapier to add multiple rows to a Google Sheet.

The same method can be used to add just one row, if you are not using a Data Table, and just need to add a record on form submission.

For an example on how to work with Data Table and Google Sheets/Excel in MS Flow instead, check out the following article <./excel-datatable>-.

We will use the Order Form in this example, which you can download here.

Order Form

Google Sheet

I’ve created Orders spreadsheet in my Google account:

Orders Google spreadsheet

You should use the first row to add names to each column. Don’t forget to name your worksheet appropriately as well, where you want results to be stored.

Zapier

Now, you can create a new custom Zap, by following this instruction - Creating a Zap.

After completing the setup for your form, search for Google Sheets the Google Sheets App:

Search for Google Sheets App

If this is your first time using this connector, you will most likely need to connect to your Google Account and give Zapier access to your files.

To select the appropriate action you’ll either need to use search or click show less common options:

Show less common options

It’s extremely important to select the action that can add multiple rows - Create Spreadsheet Row(s), so that each row from our Data Table is inserted as new:

Create Spreadsheet Row(s)

Then, fill out the columns with the data from the form:

Fill out the columns

Since Data Table columns have multiple records, they’ll add a row for each record.

Once the columns are filled, the action is saved, it is time to name and activate the Zap:

Save and activate the Zap

Now, each time you fill out a form:

Forms to Google Sheets Zap is saved

And submit it:

Form is submitted

You’ll get all the records added to your Google Sheet:

Result in Google Sheets