Forum Discussion
Exporting Variables into a Google Spreadsheet
Having read this post on how to export variables to be read in a google spreadsheet, I set about trying to get this working in my project, I soon ran into problems, I just could not get it to work a...
After taking a quick look, I saw that this error message is generated:
XMLHttpRequest cannot load https://script.google.com/macros/s/AKfycbz7Xe_atONE7a8RSxj8UVZU5qqkEvLRdNZnGL8FXeFk_PJYPoo/exec. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://www.nagelsconsulting.com' is therefore not allowed access.
Recheck your permissions (Step #6).
Also, when I just this:
https://script.google.com/macros/s/AKfycbz7Xe_atONE7a8RSxj8UVZU5qqkEvLRdNZnGL8FXeFk_PJYPoo/exec
I get a "Script function not found: doGet" message. Don't have the time at the moment to find how those are related, but hopefully it will serve as a valuable clue.
For what it's worth, I had to take a few attempts at this before I got all the steps correct. Lots of moving parts.
