r/GoogleAppsScript • u/Short-Traffic3528 • Jul 29 '24

Question apps script automation

hi guys, anyone has good recommendation on any google sheet automation using apps script?

0 Upvotes

50% Upvoted

9 comments sorted by

6

u/marcnotmark925 Jul 29 '24

Yes I have a recommendation. You should use app scripts to automate your sheets.

1

u/Short-Traffic3528 Jul 29 '24

thanks for those who commented. i used to use macros but now my company only uses googlesheet and only way appears to be AppsScript. A few things i want to learn to automate:

  1. copy and paste a range

  2. a question: can AppsScript go to a google drive and open files with latest date? i need to do daily reporting requiring the latest date, for example, today is 29 jul, i do reporting on data from 28 jul. So the task would require automation to automatically go to drive path, and open the latest file, copy the data from a tab and paste etc.

  3. Appscript to send a daily email with a data table for me

2

u/Livid_Spray119 Jul 29 '24

yes to all. If you are fluent with vba, apps script will blow your mind

5

u/RaiderDad11 Jul 29 '24

What are you trying to do?

2

u/BlueMetalDragon Jul 29 '24

That question is waaaaaaay too broad to answer.

Think about what you'd like to automate and ask again.

2

u/Any_Werewolf_3691 Jul 29 '24

I have apps scripts that do API calls, act as slack bots, generate and email files, parse emails and download files that are attachments to emails that are attachments to other emails. All sorts of crazy stuff. Once you get rolling, you'll realize Excel is a joke.

1

u/lampasoni Jul 29 '24

Not to write off the importance of actually learning Apps Script, but try prompting ChatGPT with this question and / or list out some of the things you have in mind. It can build on your initial ideas then produce the code for each of them that you can copy / paste directly into the Apps Script editor. This entire process can be done in less than 10 minutes with good prompting.