# Generate Google Sheet with multiple records

**URL:** https://community.make.com/t/generate-google-sheet-with-multiple-records/4903
**Category:** Questions
**Tags:** google-sheets
**Created:** [November 4, 2022, 7:13am UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903 "2022-11-04T07:13:57Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Ramagu](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ramagu/32/9459_2.png) [@Ramagu](https://community.make.com/u/Ramagu)
#### Post date: [November 4, 2022, 7:13am UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/1 "2022-11-04T07:13:57Z")

</div>

Hello,

I am setting up an Airtable integration with Google Sheet via Make that allows me to generate Google Sheet sheets for each record with the same order reference.

The configuration is:

-I have a table with products in which a supplier is specified.  
-These products have an order number, the same order may have several products.  
-You have to generate a Google Sheet in which all the products of the same supplier and order are included.

I have it configured but I don’t know what module I have to add and configure to keep adding products from the same order in the same sheet.

Can you think of anything?

 ![CREACIÓN POR PEDIDO](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/a/abfb9142f86e63072193a01f204dbeba1666c8c0.jpeg)

---

<div class="post-metadata">

### Author: ![AnthonyatXRAY](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@AnthonyatXRAY](https://community.make.com/u/AnthonyatXRAY)
#### Post date: [November 4, 2022, 4:47pm UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/2 "2022-11-04T16:47:13Z")

</div>

Hello,  
If you want to sequentially create a new row in GSheets for each record in Airtable there is no need to add any other modules as Make will sequentially process each Bundle(record) into Google Sheets.

 ![CleanShot 2022-11-04 at 12.33.14@2x](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/a/ace4b2d8aeb236c22afba41d74e0d19e9b530ae1.png)

Then map the output like normal

 ![CleanShot 2022-11-04 at 12.43.11@2x](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/c/c91bbe4a946a5cccb95e014629541cf9fe43fd24.jpeg)

Finally run the scenario and you will see a number by the Sheets Icon, this will be the number of rows created.

 ![CleanShot 2022-11-04 at 12.46.15@2x](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/e/e7605da6a7cbbb29b14f3f77983ff1217bd8d21f.jpeg)  
You will see three operations that were executed indicating the rows created.

---

<div class="post-metadata">

### Author: ![Ramagu](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ramagu/32/9459_2.png) [@Ramagu](https://community.make.com/u/Ramagu)
#### Post date: [November 4, 2022, 6:19pm UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/3 "2022-11-04T18:19:23Z")

</div>

The problem is that I don’t know how to specify in which row and column the field I want to insert is located.

 ![field](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/4/47f54fdf26f5842905e94e59d0e24f65448e5faa.jpeg)

---

<div class="post-metadata">

### Author: ![loic.wiseflow](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/loic.wiseflow/32/132_2.png) [@loic.wiseflow](https://community.make.com/u/loic.wiseflow)
#### Post date: [November 4, 2022, 7:20pm UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/4 "2022-11-04T19:20:46Z")

</div>

Hi @Ramagu,

You need to first identify your header row ID (either with a search module, if not static, or just hard coded, if static). Then when you specify the row ID for the row update you just use a formula that would look like that:

Row ID = {{Row ID of header}} + {{Bundle order order position}}

---

<div class="post-metadata">

### Author: ![Ramagu](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/ramagu/32/9459_2.png) [@Ramagu](https://community.make.com/u/Ramagu)
#### Post date: [November 14, 2022, 4:18pm UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/5 "2022-11-14T16:18:35Z")

</div>

Thank you very much for your help, it worked perfectly!

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [September 7, 2023, 3:03pm UTC](https://community.make.com/t/generate-google-sheet-with-multiple-records/4903/6 "2023-09-07T15:03:28Z")

</div>