Google Sheet module

Questions & Answers
1

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

2

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

image
image1172Ă—193 18 KB

1 Like
3

image
image510Ă—798 47 KB

i don’t have it :frowning:

4

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 help guide.

2 Likes
5

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

image
image321Ă—902 60.5 KB

6

I picked that… :slight_smile:
any idea?

7

@danielem sent you a DM

8

@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
image846Ă—333 40.7 KB

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”;
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.

1 Like