How to be more productive w/ Google Sheets using Google Apps Script - Google Sheet Automation Tips
✨Video tutorials are not enough? Need more help with your Google Apps Script project? I might be able to help you ! Let's talk about your project here : https://bit.ly/freelanceautomationser... ✨
⭐️ Copy the spreadsheet used in the video here : https://docs.google.com/spreadsheets/...
If you use Google Sheets a lot and end up doing the same tasks over and over again, in this video, I’ll show you can you can save time and be more productive by automating your sheets with Google Apps Script.
The script shown in this video :
Filters the rows in a sample dataset and then adds the filtered values in another sheets
Removes the duplicate values
Creates a menu to run the script directly in the
-------------------------------------------
📚 Resources
More info on the Array method filter() in Apps Script https://spreadsheet.dev/array-method-...
The remove duplicates function code : https://blog.coupler.io/how-to-remove...
The setValues method documentation : https://developers.google.com/apps-sc...)
The getRange method documentation : https://developers.google.com/apps-sc...)
-------------------------------------------
📱 Socials
Twitter : / moniquebma
Blog : https://moniquesexperiments.com