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.
Google Sheet
I’ve created Orders spreadsheet in my Google account:
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:
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:
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:
Then, fill out the columns with the data from the form:
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:
Now, each time you fill out a form:
And submit it:
You’ll get all the records added to your Google Sheet:
