# Webhook to Google Sheets

**URL:** <https://community.make.com/t/webhook-to-google-sheets/94066>\
**Category:** Questions\
**Tags:** google-sheets, webhooks\
**Created:** [October 14, 2025, 11:06pm UTC](https://community.make.com/t/webhook-to-google-sheets/94066 "2025-10-14T23:06:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Groves](https://avatars.discourse-cdn.com/v4/letter/m/ccd318/32.png) [@Matt\_Groves](https://community.make.com/u/Matt_Groves)\
**Post date:** [October 14, 2025, 11:06pm UTC](https://community.make.com/t/webhook-to-google-sheets/94066/1 "2025-10-14T23:06:21Z")

</div>

### What are you trying to achieve?

I have a custom webhook receiving a simple inventory report from my inventory software, and I would like that data to get added to google sheets. Currently I can only get it to work adding 1 row of data. The report has many rows of data. How can I get the full report to get added to google sheets?? Please help!

### Steps taken so far

I have already set up a custom webhook, I have that linked to google sheets, and when I click “run once” one row of data is entered to google sheets. I also tried to use an array aggregator but I could not get that to work.

---

<div class="post-metadata">

**Author:** ![vickswhat](https://avatars.discourse-cdn.com/v4/letter/v/ccd318/32.png) [@vickswhat](https://community.make.com/u/vickswhat)\
**Post date:** [October 14, 2025, 11:50pm UTC](https://community.make.com/t/webhook-to-google-sheets/94066/3 "2025-10-14T23:50:43Z")

</div>

Hi @Matt_Groves ,

Welcome to the community!

You can try the following module:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/1/e169b40777a6130aa5852b7a21c6bd5d4a7d556d.png)

In this example I’m using a json and we also need an aggregator.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/0/e0ca8a86822ef105508c3fd824a2c19e9d759a8f.png)

The json has 3 items, and they all can be pushed into a Google sheet at once:

[  
{  
“num”: “1”,  
“item\_id”: “378465”,  
“desc”: “red book”,  
“qty”: “5”,  
“tag”: “fiction”  
},  
{  
“num”: “2”,  
“item\_id”: “456890”,  
“desc”: “blue book”,  
“qty”: “3”,  
“tag”: “art”  
},  
{  
“num”: “3”,  
“item\_id”: “123645”,  
“desc”: “green book”,  
“qty”: “12”,  
“tag”: “poems”  
}  
]

For the aggregator you basically select the source and the fields.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/0/b0602eb032b2a52170ed76a1d981f0db634d65e5.png)

Next - prepare your Google spreadsheet, add column names:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/a/ba5ca1c26b997b8c95d5df2a1443bf69c78437e0.png)

Then go back to the Google sheets module, add the id, fill out the sheet name, column range and map the aggregator array with rows:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/6/36ea3dc7cb07c6cbb41853bf0136659c54fee126.png)

Now go back to the aggregator and choose the target structure - it’s how you make sure the array for the Google sheets module is properly formatted:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/0/d00d645130bc8ca311c69eb4fde9693c5ba174cd.png)

Map your source columns to the columns in the spreadsheet:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/8/98cffa8f9014512d2ea585348ac912f13bfb45a5.png)

Here is the result. It took just 3 operations:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/b/6b5d34dd9033d04cadf9610a49bf4cabaed87d7f.png)

Hope it helps!

---

<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:** [January 13, 2026, 12:57am UTC](https://community.make.com/t/webhook-to-google-sheets/94066/4 "2026-01-13T00:57:04Z")

</div>