Pushing data to Google spreadsheet through JavaScript running in browser

by

Step-by-step instructions with screenshots

After reading Martin Hawskey‘s good introduction (to sending data from an HTML form to a Google Spreadsheet) and seeing a few gaps/assumptions, we decided to write a detailed/comprehensive tutorial with step-by-step instructions which a few people have found useful:

https://github.com/dwyl/html-form-send-email-via-google-script-without-server

The script saves any data sent via HTTP POST in the Google Spreadsheet, and optionally forwards the content to an email address. (useful if you want to be notified of new data)

HTML Form:

contact form

Result (row in sheet):

row in sheet

Hope it helps others.

More Related Contents:

  1. “Origin null is not allowed by Access-Control-Allow-Origin” error for request made by application running from a file:// URL
  2. Does Wikipedia API support CORS or only JSONP available?
  3. Google Apps Script for Multiple Find and Replace in Google Sheets
  4. Why does my JavaScript code receive a “No ‘Access-Control-Allow-Origin’ header is present on the requested resource” error, while Postman does not?
  5. XMLHttpRequest cannot load XXX No ‘Access-Control-Allow-Origin’ header
  6. Enabling CORS in Cloud Functions for Firebase
  7. Post data to JsonP
  8. How to configure CORS in a Spring Boot + Spring Security application?
  9. No ‘Access-Control-Allow-Origin’ header is present on the requested resource. Origin ‘…’ is therefore not allowed access
  10. Convert column index into corresponding column letter
  11. HTTP status code 401 even though I’m sending credentials in the request
  12. canvas.toDataURL() SecurityError
  13. Google Spreadsheet Script – How to Transpose / Rotate Multi-dimensional Array?
  14. Javascript search inside a JSON object
  15. Cross Domain Resource Sharing GET: ‘refused to get unsafe header “etag”‘ from Response
  16. CORS – Is it a client-side thing, a server-side thing, or a transport level thing? [duplicate]
  17. Access to Image from origin ‘null’ has been blocked by CORS policy
  18. How to allow CORS in react.js?
  19. fetch() does not send headers?
  20. Cross-domain requests stopped working due to no `Access-Control-Allow-Origin` header present in the response
  21. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  22. AJAX call and clean JSON but Syntax Error: missing ; before statement
  23. How can I access Google Sheet spreadsheets only with Javascript?
  24. How to fix ‘TypeError: Cannot call method “getRange” of null’ in Google Apps Script
  25. Jquery success function not firing using JSONP
  26. Cross-domain connection in Socket.IO
  27. How to authorize CORS preflight request on IIS with Windows Authentication
  28. socket.io, ‘Access-Control-Allow-Origin’ error
  29. XMLHttpRequest: Network Error 0x80070005, Access is denied on Microsoft Edge (but not IE)
  30. Slack incoming webhook: Request header field Content-type is not allowed by Access-Control-Allow-Headers in preflight response

Leave a Comment