Writing to Google Docs Spreadsheets using Apps Script

0
votes

I'm trying to integrate Apps Script into my website's (not a Google Site) order page so that a user's order can be written to a Google Doc spreadsheet. I don't know how to go about this because the Apps Script documentation says Apps Script can only be developed and embedded in Google Sites Pages. Is there a way I can achieve this even though my site isn't a Google Site? I'll appreciate any help at all very much, thanks in advance.

2
webgoogle-apps-scriptgoogle-docsgoogle-docs-api
as far as I see, this type of application is not possible with the help of apps script - Viral Shah
So how do you suggest it can be done, Viral? - Nii Laryea

2 Answers

0
votes

You can write a regular HTML form (not in Apps Script) and set method='post' action='the script url'. That will invoke your script with the data from the form passed into the doGet as parameters.

0
votes

You can create a data capture spreadsheet, and create a Form for it. You can "clone" the form (field names and form action) into your web site.

Your spreadsheet can have an onFormSubmit action (https://developers.google.com/apps-script/understanding_events) which does whatever you need with the submitted data.