Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

In the very good article 7 Ways To Make A Google Map Using Google Spreadsheet Data Angela Alcorn says:

"Also, don’t try anything smart with the Spreadsheet Mapper, like importing data from another spreadsheet automatically. If you do, it will run the script each time it checks the other spreadsheet for new data. This will result in the following error:

error: Script invoked too many times per second for this Google user account"

Does this also apply to importing data from another sheet in the same spreadsheet? I get the "Script invoked too many times" error all the time and don't know why. It's so frustrating...

Magnus H
2014-09-10 08:40:59
Thanks Angela!I only use the reference way of importing the data and almost constantly have the “Script invoked too many times” error . What more triggers that? I try to understand what I'm doing wrong to do it the right way but just can't figure this out :( This makes my spreadsheet almost unusable now when I can't update the map and that's really frustrating.
MAKEUSEOF VIDEO OF THE DAY
SCROLL TO CONTINUE WITH CONTENT
Angela A
2014-09-10 08:02:14
If you're using ImportData or ImportRange as the function then yes, that will trigger the error. If the data is in the same spreadsheet though, you can just reference the cells simply and it shouldn't cause the problem (by that I mean using ='StaffDetails'!A4 as the way to import the data). Hope this helps!