5 Google Apps Script Tips You Need to Know 💡

[@rajon_kobir]

Miss, can you suggest me a video editor or other tools or software need to use for creating this kind of tutorial video?

[@saperis]

I have used ScreenFlow (Mac only) and Camtasia. Both work very nicely.

[@thinkthinktechs1119]

Nice work saperis love your work and love you too

[@saperis]

Glad you enjoy it!

[@abdurrehman1901]

Seperis I Love your stuff always. Please make videos about converting sheet to a REST API, example: we POST array or object and script should catch the incoming data, process and store in sheet, then send response. 💕

[@saperis]

Thank you for the feedback. The Apps Script videos we create are aimed at people getting started with automating Google Workspace apps. That's why they are very beginner friendly and quite generic. Your request though, is a bit more advanced and probably not something we will be covering on our channel.

[@cristiangabrielnicolescu6985]

Hello there! Really nice video, i do have one problem and you might be able to help me. Someone helped with me with me google sheets script but now i can't reach him and my scripts are not triggering giving me this in the execution logs: Exception: You do not have permission to access the requested document. Do you know what i have to do?

[@saperis]

The script is most likely trying to access a file to which you don't have accessing rights. If the file is, for instance, in view only mode for you, then the script can't execute exactly. But this is just a guess.

[@cristiangabrielnicolescu6985]

@@saperis hmm. It’s public because it’s a sheet that i share with a lot of people. I’ll try re-making the script from my user. Maybe that works. Thanks

[@Bfarialima]

Your videos are great. Congratulations. I'm stuck with a problem and if I could, I'd like to make a cheeky suggestion for a video so you can help me solve it. :) Say that you have a column with uneven stacked data and you want to unstack it into rows. How do you go about doing it? (Ex: State 1; City 1.1; City 1.2; City 1.3; City 1.4; State 2; City 2.1; State 3; City 3.1; City 3.2; City 3.3). Thanks

[@saperis]

Thanks for your feedback. I can't promise I'll make a video for your specific situation. I try to keep the videos interesting to as many as possible. But in any case, I think you should look into array flattening. Sheets data is stored in two dimensional arrays like so: [[A1, B1, C1], [A2, B2, C2]]. Have a look here: developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/flat

[@ehsanulhaq9916]

The Best Tips!

[@saperis]

Glad you think so! 😀

[@ok.1ai]

When I’m on google chrome on a iMac I put a new tab it always go to yahoo but yours go to google can you help me?

[@saperis]

Hi Tiffany. Check this guide to change the settings: support.google.com/chrome/answer/95314?co=GENIE.Platform%3DDesktop&hl=en#zippy=%2Chave-a-new-tab-open

[@blalezarian]

Apps script can be slow. Tips around speeding up execution would be helpful

[@saperis]

Batch process data. Meaning you shouldn't process data row by row. Instead you get all your data, process it and then right it back to the sheet in one go.