Automate data collection for experiments - Feedback!
A client wanted a fast way to grab all their experiment data so that they could build a dashboard in Google sheets and watch their numbers tick. I found this original verison, but it was inadequete, so here's version 2 (with blood, sweat and tears).
My aim was to cut down a day's worth of reporting/data collecting, make it run faster, print vlookup friendly data (yay!) and make life a tad smoother.
you helped me a lot from reporting!
Now I actually got an error "TypeError: Cannot call method "getRange" of null." but still it's super helpful!
Glad you like it and thanks for the feedback!
I'll have to try and reproduce the error on my end. Simply speaking, the error is occuring because the sheet is trying to copy something that's empty. Any more information you could provide would be a great help
The most important question here is were you able to get a complete print out of your data?
Had a check through it and noticed that an addition I put in right before release was overlooked in QA!
I tested it a few times on a personal account and it should be working correctly now. Make another copy of the original spreadsheet and give it a go. Make sure you try pulling your data more than once!
Let me know if there are still any problems - happy to fix any issues. It was a personal project after all haha!
I just tried and it worked perfectly!!!
Oh my goodness, it's super awesome!!
I deeply appreciate you so so much!!!!