Title: Google App Scripts Problem
Last modified: August 30, 2016

---

# Google App Scripts Problem

 *  Resolved [quadmasta](https://wordpress.org/support/users/quadmasta/)
 * (@quadmasta)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/)
 * I wrote a Google Apps script that spits out a bunch of HTML for a gallery based
   on images in a certain folder in Drive. I’ve tried using the raw string return
   and the HTML output from HtmlService.createHtmlOutput() and neither seems to 
   work. I put some text before and after the shortcode and when I inspect the DOM
   there’s nothing in-between.
 * Please help!
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6817926)
 * The Google Apps Script HtmlService outputs an iframe. This plugin expects raw
   HTML. You can only produce raw HTML from the TextOutput class provided by Google
   Apps Script. Use that instead.
 *  Thread Starter [quadmasta](https://wordpress.org/support/users/quadmasta/)
 * (@quadmasta)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6817994)
 * I created a “Hello world” script that returns just the string. When I execute
   the script in a browser I get the GAS “unsupported output”. I tried using the
   script in that state and it didn’t work. I modified it to use ContentService.
   The script output a string to the browser when called. Still zero effect when
   using the plugin.
 * Could my theme be causing a problem? I’m using Divi 2.
 *  Thread Starter [quadmasta](https://wordpress.org/support/users/quadmasta/)
 * (@quadmasta)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6818002)
 * I can get the Hello World script working if I use this url:
    [https://script.googleusercontent.com/a/macros/atlantapetpartners.org/echo?user_content_key=2us–2DmtBGqa0n03CbFFDnUPJB2kByo9iClcFaxEQmJz78scVrBI-lL9HFKZA7prSEZxtZ-z6I7KOWzx68CLe_4zUMh89Vkm5_BxDlH2jW0nuo2oDemN9CCS2h10ox_nRPgeZU6HP-w-i9ZHR6gidbofTtJyfVtrdjMKR3EYj1LhyHCd5hHa0TQj99vU1_wwFGEOrbQ1gp4x_KtMl1ZOw6EnmqrYQLXg7PMQKg8IcJhyVcTQheNVzvvdDXmJhWR&lib=MFRFPmOenNEpIzRHfKWhlGfDkkAMmCj16](https://script.googleusercontent.com/a/macros/atlantapetpartners.org/echo?user_content_key=2us–2DmtBGqa0n03CbFFDnUPJB2kByo9iClcFaxEQmJz78scVrBI-lL9HFKZA7prSEZxtZ-z6I7KOWzx68CLe_4zUMh89Vkm5_BxDlH2jW0nuo2oDemN9CCS2h10ox_nRPgeZU6HP-w-i9ZHR6gidbofTtJyfVtrdjMKR3EYj1LhyHCd5hHa0TQj99vU1_wwFGEOrbQ1gp4x_KtMl1ZOw6EnmqrYQLXg7PMQKg8IcJhyVcTQheNVzvvdDXmJhWR&lib=MFRFPmOenNEpIzRHfKWhlGfDkkAMmCj16)
 * This doesn’t work
    [https://script.google.com/macros/s/AKfycbyQdDAEEMJakg_Jn0c_on1OBLGByC7m2nLVq-PCGmY_1wSjQ2lX/exec](https://script.google.com/macros/s/AKfycbyQdDAEEMJakg_Jn0c_on1OBLGByC7m2nLVq-PCGmY_1wSjQ2lX/exec)
 * If I use the same approach with my other script, I’m getting a login window. 
   It’s configured to run as my user and to allow anyone, even anonymous access.
 * If I look at File>Project Properties>Scope it says OAUTH is required for the 
   drive scope. I couldn’t find anything anywhere that indicated this plugin could
   handle that.
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6818024)
 * Correct, this plugin currently only handles public/anonymous accesses where no
   login is required. If you can get your apps script to produce an HTML snippet(
   not a full document) without requiring a login, it’ll work with this plugin, 
   which simply makes an HTTP request and returns the result.
 *  Thread Starter [quadmasta](https://wordpress.org/support/users/quadmasta/)
 * (@quadmasta)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6818054)
 * I ended up changing the script to spit out JSON and wrote my own shortcode to
   grab the JSON and handle it. Thanks for the support anyhow!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Google App Scripts Problem’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [quadmasta](https://wordpress.org/support/users/quadmasta/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/google-app-scripts-problem/#post-6818054)
 * Status: resolved