5 Google Sheets Tips with Apps Script (I Wish I Knew Before)

4,520 views

Published on May 17, 2024

About :

Create custom functions, custom menus, automatically move rows, integrate external APIs, and consolidate data from multiple spreadsheets. In this video, we’ll cover five useful tips for optimizing your Google Sheets spreadsheets using custom scripts. Whether you’re managing your finances, projects, or time, these tips will expand the functionality of your spreadsheets by integrating with other Google apps and external APIs. ????️ LINKS TO EXAMPLES 1. Custom function: https://docs.google.com/spreadsheets/... 2. Custom menus: https://docs.google.com/spreadsheets/... 3. Automatically move rows between pages: https://docs.google.com/spreadsheets/... 4. Integration with external APIs: https://docs.google.com/spreadsheets/... 5. Spreadsheet consolidator: https://docs.google.com/spreadsheets/... IMPORTANT: 1) In order to access Apps Script in spreadsheets, you first need to copy the spreadsheet to your Drive by clicking on: File → Make a copy. 2) Create your key (API key) at https://openweathermap.org/api BEFORE testing example 4, otherwise it will give an error. . After creating your API KEY, access Apps Script and go to: Project Settings → Script Properties → Add Script Properties. In the name, write OPENWEATHER_API_KEY and in the value, paste your API Key. Now you will be able to test it. If you have just created the key, wait a few minutes because it takes a while for them to release it. ???? REFERENCES AND SOURCES Google Apps Script Documentation: https://developers.google.com/apps-sc... OpenWeather API: https://openweathermap.org/api ▶️ RECOMMENDED VIDEOS: How to Connect a Spreadsheet in ChatGPT: • ChatGPT within Google Sheets via A... ???? QUOTE REQUEST: Do you want my help with your project? Access: https://forms.gle/6oFSHDYtMa8J6KeZ7 ???? CHAPTERS 0:00 - Introduction 0:17 - Why Use Apps Script? 0:36 - List of Tips 0:58 - Tip 1: Creating a Custom Function 3:29 - Tip 2: Creating a Custom Menu 5:14 - Tip 3: Moving Rows Between Pages 9:38 - Tip 4: Integration with External API 11:31 - Tip 5: Creating a Consolidated Spreadsheet ???? Your Opinion Matters! Did you like the tips? Comment below which one you liked the most and which one you would like to see in more detail in the next videos! ???? Follow More Tips: Subscribe to the channel and activate the bell so you don't miss any new content about Google Sheets and automation! ⏭️ Next Video: How to Send Emails Using Google Sheets: • How to Send Emails Using Google Sheets ✍️ TITLES: How to Boost Your Google Sheets Spreadsheet with Apps Script 5 Tips on How to Boost Your Google Sheets Spreadsheet Apps Script 5 Tips on How to Boost Your Google Sheets Spreadsheet Apps Script 5 Tips to Boost Your Google Sheets Spreadsheet Apps Script 5 Tips to Boost Your Google Sheets Spreadsheet with Apps Script Hashtags: #GoogleSheets #GoogleAppsScript #Automation #AdvancedSpreadsheets

vidoe Comments

Trend Videos