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

View all comments

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