Trigger script on google spreadsheet when a new row is inserted

7
votes

I'm running a script on a google spreadsheet, that should be triggered by the onChange() event (when a new row is inserted in the spreadsheet) by a zap from Zapier (www.zapier.com). I can see the new info being created in the spreadsheet, but the trigger is not triggered. I already tested with the onEdit() event, but it's not working. It should not be a time-based trigger.

Any suggestions?

2
google-apps-scriptgoogle-sheetszapiertriggersgs-installable-triggers

2 Answers

2
votes

I'm getting data from external api (in my case IFTTT) and by using below function, I'm triggering a url fetch function to send data (the last Row) to another external api ( my own website). Working perfectly.

 function onChange(e) {
var ss = SpreadsheetApp.getActive();
ScriptApp.newTrigger('name of the function you need to trigger')
.forSpreadsheet(ss)
.onChange()
.create();
}
1
votes

If you have not set up the trigger in the script:

Go to resources menu, and select 'current project triggers'. you should be able to set up your script to run 'on change'.