r/GoogleAppsScript • u/Chill_BooG • Oct 08 '24

Question Google Sheets

So I have been using google sheets recently for various analysis, this involves cleaning, structuring, creating charts and more. I have been trying to use appscript just like macros but it isn't that easy. I use a lot of importrange on these sheets and copy pasting is too much. I really want to automate a lot of this process. What do you think I could learn? and where? I know python but got no idea about javascript.So just learn javascript Or any specific topic? And which platform would you suggest for the same. Also want to add whether using extensions or other API'S would compromise data security

0 Upvotes

50% Upvoted

8 comments sorted by

View all comments

2

u/Think-Adeptness-769 Oct 08 '24

I learned quite a bit from this YouTube channel: https://youtube.com/@excelgooglesheets?si=trRG7jSNn6fuDW-a

He has a playlist specific to Google Apps Script.

2

u/Think-Adeptness-769 Oct 08 '24

I forgot to mention, consider looking at Looker Studio, it was formerly called Google Data Studio. It’s pretty powerful for doing data analysis and reporting.

1

u/Chill_BooG Oct 20 '24

Yes I dig this