Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How to automatically run code from Google Sheets script?

M

Hi there ! 

I am trying to run a script (in javascript) automatically. The trigger in the google app script do not work but when I run my code manually it is correct. 

Here the code : 

function deleteRows() {

var ss = SpreadsheetApp.getActiveSpreadsheet();

var s = ss.getSheetByName('Feuille 1');

var r = s.getRange('A:A');

var v = r.getValues();

for(var i=v.length-1;i>=0;i--)

if(v[0,i]=='a')

s.deleteRow(i+1);

};

I have tried to use the “code by Zapier” action bu it does not work either. Here the error message I get : 

Error: You did not define `output`! Try `output = {id: 1, hello: "world"};`

Does someone know if it is possible to code a google sheet code in the action code by zapier ? And why does it not work ? 

 

Thank you all for your time :) 

Best answer by GetUWiredBest answer by GetUWired

HI @Mathiilde 

This has been discussed here before: 

 

You could send a webhook to the script to trigger the run. Though I am not sure getActiveSpreadsheet will work since this is not running while the spreadsheet is open. You may need getSpreadsheetById instead. 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • Answer
  • July 27, 2021

HI @Mathiilde 

This has been discussed here before: 

 

You could send a webhook to the script to trigger the run. Though I am not sure getActiveSpreadsheet will work since this is not running while the spreadsheet is open. You may need getSpreadsheetById instead. 

M
  • MathiildeBeginner
  • Author
  • Beginner
  • 4 replies
  • July 27, 2021

Hi @GetUWired  and thank you a lot for your answer. 

I went through the conversation you sent me and that helped me. 

However, I do not understand the doPost() part, do you have any idea or precision about where I need to put it in my code ? 

Here is my code : 

function deleteRows() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheetByName('Feuille 1');
  var r = s.getRange('A:A');
  var v = r.getValues();
  for(var i=v.length-1;i>=0;i--)
    if(v[0,i]=='a')
      s.deleteRow(i+1);
};

Finally I do not understand why getActiveSpreadsheet will not work I am a kind of beginner in coding. 

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • July 29, 2021

the doPost function is how you would receive the webhook from Zapier. Essentially, when you post to the script url, doPost is the function that runs.

the doPost function could possibly something that just calls the deleteRows function. 

function doPost( e ) {

  deleteRows()

}

More in depth explanation can be found here: https://www.labnol.org/code/19871-get-post-requests-google-script 

 

i am not sure getActiveSpreadsheet will work because it returns the currently active sheet. If the script is bound to a sheet then I think it would work. 

If not, there are other methods for defining a sheet like openById or openByUrl.  

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openbyidid

 

A
1 person likes this
  • A
    Anthony
Terms & Conditions