# Google Sheet module

**URL:** <https://community.make.com/t/google-sheet-module/15069>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [August 29, 2023, 7:38am UTC](https://community.make.com/t/google-sheet-module/15069 "2023-08-29T07:38:25Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![danielem](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@danielem](https://community.make.com/u/danielem)\
**Post date:** [August 29, 2023, 7:38am UTC](https://community.make.com/t/google-sheet-module/15069/1 "2023-08-29T07:38:25Z")

</div>

HI

how can i switch my Google Sheets - Watch New Row module from running every 15 minutes to a PUSH status. I need to be run immediately every time someone adds a new row

Thank you  
D

---

<div class="post-metadata">

**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\
**Post date:** [August 29, 2023, 11:00am UTC](https://community.make.com/t/google-sheet-module/15069/2 "2023-08-29T11:00:51Z")

</div>

it supposed to work exactly like that, make sure to set in the scheduling: **Inmediately as data arrives** like this:

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

---

<div class="post-metadata">

**Author:** ![danielem](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@danielem](https://community.make.com/u/danielem)\
**Post date:** [August 29, 2023, 11:52am UTC](https://community.make.com/t/google-sheet-module/15069/3 "2023-08-29T11:52:50Z")

</div>

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/2c858a6b578c86f463e56d9678f6494e0390e4a3.png)

i don’t have it ☹

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [August 29, 2023, 1:05pm UTC](https://community.make.com/t/google-sheet-module/15069/4 "2023-08-29T13:05:44Z")

</div>

That’s right, not all modules run instantly - only webhook triggers can do that instantly because they receive push data from the external application, compared to normal triggers that run on a schedule checking if things have changed.

For more information on triggers, please see the [types of modules](https://www.make.com/en/help/modules/types-of-modules.html) help guide.

---

<div class="post-metadata">

**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\
**Post date:** [August 29, 2023, 3:31pm UTC](https://community.make.com/t/google-sheet-module/15069/5 "2023-08-29T15:31:51Z")

</div>

Weird, what Make/Integromat plan do you have, Google Sheets module should display a list like this:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/3/321faf87243769d18ad28f8af21204a720e5f96a.png)

---

<div class="post-metadata">

**Author:** ![danielem](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@danielem](https://community.make.com/u/danielem)\
**Post date:** [August 29, 2023, 3:33pm UTC](https://community.make.com/t/google-sheet-module/15069/6 "2023-08-29T15:33:08Z")

</div>

I picked that… 🙂  
any idea?

---

<div class="post-metadata">

**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\
**Post date:** [August 29, 2023, 3:38pm UTC](https://community.make.com/t/google-sheet-module/15069/7 "2023-08-29T15:38:10Z")

</div>

@danielem sent you a DM

---

<div class="post-metadata">

**Author:** ![Rafael\_Sanchez](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/rafael_sanchez/32/5425_2.png) [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\
**Post date:** [August 29, 2023, 4:44pm UTC](https://community.make.com/t/google-sheet-module/15069/8 "2023-08-29T16:44:34Z")

</div>

@danielem Idid a test and its working for Me.

Google sheets in paid plan does not suppor ACID transaction but Webhooks does it so I create and script in Google Forms to send the post information to a Webhook .

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

Add this code script :

> function onSubmit(e) {  
> var data = e.response.getItemResponses();  
> var payload = {};
> 
> data.forEach(function(item) {  
> var title = item.getItem().getTitle();  
> var response = item.getResponse();  
> payload[title] = response;  
> });
> 
> // Make a POST request to the webhook receiver  
> var url = “[https://your-webhook-url.com](https://your-webhook-url.com)”;  
> var options = {  
> method: “post”,  
> contentType: “application/json”,  
> payload: JSON.stringify(payload)  
> };
> 
> UrlFetchApp.fetch(url, options);  
> }

and make sure to add the webhook URL and set the trigger in google form.

---

<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:** [December 7, 2023, 5:35pm UTC](https://community.make.com/t/google-sheet-module/15069/9 "2023-12-07T17:35:55Z")

</div>


