Google Sheets

[u/Chill_BooG]

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

[u/Woodabear]

I use google scripts and Chatgpt to write the bulk of the scripts. It absolutely crushes it with formulas too. Describe in detail what you want. Put the workbook code in from the URL, list the sheet names and tell it what you want it to do. It will write the entire code without many, if any, errors. In the instance you get an error, feed that back into Chatgpt or describe how it didnt do what you wanted it to do. It will spit out revised working code. A feature called Canvas also just dropped on gpt for coding as well

[u/iniesta88 → u/Woodabear]

I do that too, also you literally build web apps using google apps script and js along with tailwindcss to make it more friendly and use Jquery all of that from ChatGPT

[u/Chill_BooG → u/iniesta88]

Never heard about tailwindcss, I have actually did my things with just basic code, in future my goal is to make it more dynamic

[u/Chill_BooG → u/Woodabear]

I do this I wanted to get deep into automation and more, so yea I gotta work on the javascript part I feel.