Profile

Cover photo
Mikael Thuneberg
Works at Supermetrics
Attended University of Helsinki
Lives in Espoo
112 followers|749,874 views
AboutPostsPhotosVideosReviews

Stream

 
We're having major problems with URLFetchApp when running from add-on time-based triggers. It has always been unreliable, randomly returning "Unexpected error" or "Timeout", so we've been looping attempts until at some point it succeeds. But it appears that recently this has changed so that it's first stuck for one minute and then returns the error. Obviously with the limited trigger run time this delay causes huge problems, as the looping workaround is no longer effective.

Developers have been complaining about the problems with trigger-based URL fetch for years:
https://code.google.com/p/google-apps-script-issues/issues/detail?id=3473
https://code.google.com/p/google-apps-script-issues/issues/detail?id=3996
https://code.google.com/p/google-apps-script-issues/issues/detail?id=2758
https://code.google.com/p/google-apps-script-issues/issues/detail?id=4267
https://stackoverflow.com/questions/16778964/urlfetchapp-fetchurl-intermittent-unexpected-error
https://stackoverflow.com/questions/29664691/why-unexpected-error-on-urlfetchapp-gas
https://stackoverflow.com/questions/23959870/unexpected-error-on-urlfetchapp

Why can't we get this fixed??? We now have users that are paying to use our add-on, so it's really bad that the service doesn't work and we can't do anything about it.
Google Apps Script issues and feature requests. *Note*: This project is exempt from the read-only timeline listed above. Please continue to file issues here.
11
Steve Webster's profile photoZig Mandel's profile photoSpencer Easton's profile photoMikael Thuneberg's profile photo
19 comments
 
Thanks guys! We're using the webapp workaround now, it seems to work more reliably but the quotas are a problem. It seems we need to create a bunch of Google accounts with copies of the relay script to stay under the 10,000 request/day limit. 
Add a comment...
 
We noticed that GAS custom spreadsheet functions break if the user launces an add-on that contains a function by the same name. Please star the issue!
Google Apps Script issues and feature requests
2
Steve Webster's profile photo
 
Interesting find. I starred it.
So if I have a spreadsheet (or doc/form) with a contained script, and later run an add-on, then add-on function names supersede function names with the user's existing script.

I think I would rather have add-ons function names contain prefixes or suffixes, instead of Google introducing a Caja type layer that does this for us.

Now I'm wondering, if this is limited to IFRAME.

I'm going to update my add-on with a suffix. For example, Remove Blank Rows add-on will soon contain " function updateRowRBR() { ".
Add a comment...
 
After publishing our add-on to GAM, running it requires a new permission "View your Google Drive apps". Can this be avoided somehow?
1
1
Faustino Rodriguez's profile photoEric Koleda's profile photoMikael Thuneberg's profile photoTiffany Lauderdale's profile photo
11 comments
 
Than k d
Add a comment...
 
We did some testing with running our Google Sheets add-on (published as a web app), as an add-in for Excel 2013. Sidebar works great, but unfortunately it seems Caja breaks the Office js library, so it's not possible for the sidebar to interact with the spreadsheet. Would've been so cool if this had worked..
3
1
Martin Hawksey's profile photoBruce Mcpherson's profile photoJames Swansburg's profile photo
2 comments
 
thanks martin .. to be honest I've kind of ignored Microsoft JavaScript romance - it was horrible when it first came out. But thanks for reminding me - I must go back and see where it's got to.
Add a comment...
 
Anyone managed to Selectize.js (http://brianreavis.github.io/selectize.js/) to work in add-ons? Caja breaks it somehow and I haven't been able to find out the reason..
A jQuery-based custom <select> UI control. Useful for tagging, contact lists, country selectors, and so on.
1
Add a comment...
Have him in circles
112 people
Brian Alpert's profile photo
Casper Blicher Olsen's profile photo
Lukáš Lanc's profile photo
Malta Covered's profile photo
Faustino Rodriguez's profile photo
Vesa Kajander's profile photo
Jacob Kildebogaard's profile photo
Bryan Povlinski's profile photo
Justin Root's profile photo
 
There's something wrong with the add-on gallery ratings. We had 4.5 stars, and got one new 5 star rating the day before yesterday, but that dropped our add-on to 4 stars. Looking at the number of ratings and the averages, we see the new rating was counted as one-star. Any idea where we should report this bug?
4
Add a comment...
 
Publishing a minor update to our add-on, I suddenly get "Your item has been submitted for publishing, but it has been flagged for a manual review." Any idea why this happens? Hopefully the manual review happens soon, we really need to update the add-on..
1
Ryan Roth's profile photoFilipe Gazzinelli L F Werneck's profile photo
4 comments
 
Thanks for the clarification :)
Add a comment...
 
Anyone else having problems updating add-ons? Ours is stuck in "Publishing in progress" for much longer than usual..
1
Ryan Roth's profile photoMikael Thuneberg's profile photoSteve Webster's profile photo
5 comments
 
I decided to enter an issue for the CWS Dashboard under Status column displaying both "Published" and "Publishing in progress" at the same time. 
https://code.google.com/p/google-apps-script-issues/issues/detail?id=4980
Add a comment...
 
All add-ons seem to be failing to load on Firefox 34.0.5 on OS X, the sidebar and dialogs open blank. A user reported this to us today and we can reproduce it here.
5
Romain Vialard's profile photoFaustino Rodriguez's profile photoMikael Thuneberg's profile photoJohn McGowan's profile photo
9 comments
 
Thanks +Mikael Thuneberg. I have has about a dozen users per day reporting blank sidebar issues and not using Chrome is the issue. This helped identify the cause!
Add a comment...
 
We're trying to use the Prediction service in our add-on, but so that it would use our own models, not those of the add-on user, and we're running into permission issues. It seems we have to use OAuth service account authentication for this. Is there any guide on how to implement this in GAS? And is it so that in this case, we need to user URL Fetch rather than the GAS Prediction service to access the Prediction API?
1
Steve Webster's profile photoMikael Thuneberg's profile photo
2 comments
 
Thanks Steve, this is very helpful, I didn't know about Content Service. I would prefer to use the Prediction Service directly rather than via URL Fetch (I fear the performance will be worse and it consumes URL Fetch quota), but it looks like that's not possible for what we want to do, so unless there are other ideas, we'll go ahead with yours.
Add a comment...
 
Our add-on has suddenly stopped installing, whenever trying to install, it returns the attached error. Is anyone else seeing this? In addition, when I try "Deploy as Sheets add-on" in the GAS editor, the popup window no longer fills with the latest published version, and the description, post-install tip and instruction URL fields are empty.
1
Mikael Thuneberg's profile photoSteve Webster's profile photoAndrew Stillman (Personal)'s profile photoEric Koleda's profile photo
6 comments
 
Re-opened your issue, let's follow up there: https://code.google.com/p/google-apps-script-issues/issues/detail?id=4345
Add a comment...
 
I created a script that scrapes add-on user counts and ratings from the Chrome web store pages, so you can get a better picture of how you're doing relative to other add-ons.

If you want to track your add-ons, just make a copy of the attached, enter the store listing URLs to row 2, and set up a trigger to run this daily. Leave two empty columns between the URLs as the script fetches three metrics for each add-on (# of users, avg. rating, # of ratings).

Google beat us to 10,000 users but we're catching fast :)
Käyttämääsi Firefox-versiota ei enää tueta. Jotkin ominaisuudet eivät ehkä toimi oikein. Päivitä selaimesi tai kokeile Google Chromea.Hylkää. Tiedosto. Muokkaa. Näytä. Lisää. Muoto. Tiedot. Työkalut. Lomake. Laajennukset. NEW! Ohje. Esteettömyys ...
6
Faustino Rodriguez's profile photo
 
pretty cool, no idea you can get that info so easily
thanks for sharing !!!
Add a comment...
People
Have him in circles
112 people
Brian Alpert's profile photo
Casper Blicher Olsen's profile photo
Lukáš Lanc's profile photo
Malta Covered's profile photo
Faustino Rodriguez's profile photo
Vesa Kajander's profile photo
Jacob Kildebogaard's profile photo
Bryan Povlinski's profile photo
Justin Root's profile photo
Work
Occupation
Founder of AutomateAnalytics.com
Employment
  • Supermetrics
    CEO & Founder, 2013 - present
  • AutomateAnalytics.com
    Founder & CEO, 2010 - 2013
  • T-Media
    2011
  • Sulake Corporation
  • 15/30 Research
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Espoo
Previously
Helsinki - Ithaca - Jülich - Copenhagen
Links
Contributor to
Story
Tagline
Founder of Supermetrics
Education
  • University of Helsinki
    Political Science, 1999 - 2005
Basic Information
Gender
Male