doPost(e) function in Apps Script project to capture webhook json data. I am getting no data in my google sheet

Question

My apologies for asking what may be a basic question for experienced coders. I am trying to capture webhook data from Shopify into a google sheet. I am using Google Apps Script but I feel like I have hit a roadblock.

This is the link of the code that I have changed to suit my needs: https://github.com/samaybar/googlewebhookreceiver/blob/master/Code.gs

I published the script as a web app and entered the url link for the Shopify webhook to send me the data, but I get no data. I know that the webhook is firing as I have made another webhook(for same type - Orders Paid), and it is showing JSON data in webhook.site These are the resources that I have checked :

I also checked the https://github.com/gsuitedevs/apps-script-samples for any clue to see what I might be doing wrong but not getting anywhere.

When I try to debug the function doPost (which contains almost all of my code), I get this error:

TypeError: Cannot read property "postData" from undefined. (line 9, file "

This is the part of my code:

 function doPost(e){

   var ss=SpreadsheetApp.openById("SHEETID");
   var sheet = ss.getSheetByName("Sheet1");
   var lastRow = ss.getDataRange().getLastRow();

   ss.insertRowAfter(lastRow);

   var params=JSON.stringify(e.postData.contents);
   params=JSON.parse(params);

   var myObj=JSON.parse(e.postData.contents);

   var orderId=myObj.name;
    var email=myObj.customer.email;
  var phone=myObj.shipping_address.phone;

  var ss = SpreadsheetApp.getActivesheet();

  ss.getRange(lastRow +1,1).setValue(orderId);
  ss.getRange(lastRow +1,2).setValue(email);
  ss.getRange(lastRow +1,3).setValue(phone);
 SpreadsheetApp.flush();

  return HtmlService.createHtmlOutput("Post Received");

}

I Googled the error and came across this reddit post which describes the same problem https://www.reddit.com/r/javascript/comments/55rwaj/google_apps_scripts_json_postdata_typeerror/

I am however, unable to follow what should I do to fix the code.

References from Shopify: https://help.shopify.com/en/manual/sell-online/notifications/webhooks#create-webhooks https://help.shopify.com/en/api/reference/events/webhook

Any help will be really appreciated as I have nearly exhausted myself trying to figure out what to do.

Note: I know this can be done via Zapier integration but I would like to do it using google Apps script. I am not a programmer/coder

Update: I modified the code above by removing the following lines:

var params=JSON.stringify(e.postData.contents);
   params=JSON.parse(params);

   var myObj=JSON.parse(e.postData.contents);

   var orderId=myObj.name;
    var email=myObj.customer.email;
  var phone=myObj.shipping_address.phone;

  var ss = SpreadsheetApp.getActivesheet();

  ss.getRange(lastRow +1,1).setValue(orderId);
  ss.getRange(lastRow +1,2).setValue(email);
  ss.getRange(lastRow +1,3).setValue(pone);

And adding these lines of code:

Logger.log("Post function called");
if (typeof e !== 'undefined')
Logger.log(e.parameter);
sheet.getRange(lastRow+1, 1).setValue(JSON.stringify(e));

My aim was to verify if data was being sent at all. I am now getting the following which I believe is the raw data :

This entire value is coming inside a single cell. Now I have two challenges/issues here:

How to only parse data that I need? (order ID, email, Phone)
How to send back the 200 OK code so I do not end up getting multiple rows of same value?(currently I am getting 4-5 multiple rows when Webhook is fired in a short interval)

You cannot manually execute triggered functions as the function argument (**`e`**) is missing. Thus, the error you receive about `postData`. Instead, try logging debug data to Stackdriver with `console.log` when using the function "normally" (i.e. activating the webhook / sending POST data to the webapp URL). Review https://developers.google.com/apps-script/guides/web and https://developers.google.com/apps-script/guides/logging#stackdriver_logging — tehhowch, Dec 26 '18 at 05:34
Sorry for asking pretty basic questions - what should I look for in Stackdriver? When I use it, it is giving me info like this : 2018-12-25 19:15:08.584 EST TypeError: Cannot read property "postData" from undefined. at doPost . I know that the webhook is firing properly as I can see the json data in webhook.site for the other(similar) webhook. — Neville N, Dec 26 '18 at 09:07
`2018-12-25 19:15:08.584 EST` Is that the time, your web hook fired? — TheMaster, Dec 26 '18 at 11:37
@TheMaster: No. That is why it is even more confusing. Nothing shows on the logs when the webhook is fired. The logs are showing up only when I use the Run/debug option by selecting the doPost function. — Neville N, Dec 27 '18 at 00:14
Try Postman/curl and try to post to your web-app(Redeploy it just in case) — TheMaster, Dec 27 '18 at 12:09
@TheMaster: I am not familiar with postman/curl so I am not sure how it would help me in my case. I redeployed the webapp but still it is returning no data as of writing this comment. — Neville N, Dec 31 '18 at 00:55

doPost(e) function in Apps Script project to capture webhook json data. I am getting no data in my google sheet

0 Answers0