2

I'm building a Google Spreadsheet that uses an official add-on to pull data from Google Analytics using the new add-on store. What I'd like to have it do is automatically refresh the data every day at some time and email me the info. The add-on requires you to manually click "Run Reports" from its drop-down menu in order to refresh the data.

The heart of the question is this: can you call an add-on menu option from a script? Is there a google-script API or handle or reference that will allow me to grab a line from the drop-down Google Spreadsheet menus that is attached to a black-box code?

Improve this question
2

I've looked in these places on the Google Apps Developer site:

but wasn't able to find a solution. Therefore I created an feature request in the issue tracker: 3803

Improve this answer
1
  • Well, thanks. I appreciate the effort. – Emmett R. Mar 21 '14 at 14:11
-1

The "goog-ly" way to this is to have the sheet pull in live data every time you look at it, and just set a calendar reminder for yourself to check the sheet every day. The calendar reminder can be configured (in Google Calendar, Outlook, and other calendars) to send you an email reminder that would include a link to the sheet.

If you need help getting the sheet to update automatically, this link may help:

http://www.computerworld.com/slideshow/detail/79661

It uses very simple data, but the main thing isn't the specific data as much as it is encapsulating your data in a script, and using a trigger to run the script when the sheet opens.

Improve this answer
8
  • Right, I'm just having trouble with setting it up so that it can pull the data while using the new Out-Of-The-Box apps without human intervention. – Emmett R. Mar 19 '14 at 20:46
  • @EmmettR. Is the problem it that you can't get it to refresh data automatically when you view the sheet, or that the data is so time sensitive that viewing it at times that vary by a few minutes (or even an hour an so) will cause problems? – Joel Coehoorn Mar 19 '14 at 20:55
  • The first. It's not very time-sensitive, I would just like to get it to refresh automatically. – Emmett R. Mar 19 '14 at 22:14
  • @Emmett R. Updated. – Joel Coehoorn Mar 20 '14 at 16:24
  • 1
    I really don't think you're apprehending the problem at hand. I'm not dealing with a normal script. I need to know if there is any kind of handle, reference, API or call to reach a google sheets menu item that is linked to a black-box. I edited my question to try and clarify. – Emmett R. Mar 20 '14 at 22:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.