How do I add items to google sheet?

hi i am trying to add data into my google sheet and have used the script below but i still cant get it to work, please help?


image

  1. There should be two curly brackets } at the end of the script, one for the else if and one to close the original if.
  2. Check/show the content of your global URL - need to ensure you have the ? and the & in the right places....
  3. Do you want the data posted to the first sheet of the spreadsheet? That is what ss.getSheets()[0] does

been getting

[Ljava.lang.Object;@1bb0c141
[Ljava.lang.Object;@7c5c71a9
[Ljava.lang.Object;@242eef4a
[Ljava.lang.Object;@73336c63

instead of text input by user, what should i do

Try:

sh.appendRow([e.parameter.id,e.parameter.task,e.parameter.note,e.parameter.time,e.parameter.date]);

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.