[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This article will teach you how to use Google Apps Script in Google Sheets. We will share script examples and how they affect spreadsheets. We will also explain some key concepts like Custom Functions and Data Types.<\/p>\n
Let\u2019s get right into it!<\/p>\n
Key Takeaways:<\/b><\/p>\n [\/et_pb_text][et_pb_text module_id=”what” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Google Apps Script is a cloud-based platform that lets you create your own programs to work with your Google apps (like Gmail, Docs, and Sheets). These programs perform tasks automatically. They can send emails or organize data. They can also add new features to your apps, like custom menus or buttons.<\/b><\/p>\n Google Apps Script uses a simple programming language called JavaScript. You don’t need to be an expert coder to write it, though.<\/b><\/p>\n In simple terms, this is how Google Apps Scripts works:<\/b><\/p>\n Now, how to use Apps Script in Google Sheets?<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_1.webp” alt=”Apps Script Google Sheets \u2014 new Untitled project editor with empty myFunction in Code.gs” title_text=”New Untitled project editor with empty myFunction in Code.gs” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_2.webp” alt=”Apps Script Google Sheets \u2014 Extensions menu open with Apps Script highlighted in a blank spreadsheet” title_text=”Extensions menu open with Apps Script highlighted in a blank spreadsheet” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. You will see Code.gs. This is the main file where you’ll write your JavaScript code. It\u2019s located in the \u201cEditor\u201d menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_3.webp” alt=”Google Apps Script in Google Sheets \u2014 Code.gs file highlighted in the editor with an empty function” title_text=”Code.gs file highlighted in the editor with an empty function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4. Type in or paste your code. You might need to learn Javascript to know how to write code, or you can generate code with Gemini or ChatGPT<\/a>. But here is the script we\u2019ll use for this tutorial:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]function sendEmails() { What\u2019s the scenario behind this script? Let\u2019s assume we have a contact list in a Google Sheet and want to use it for a basic email campaign. The script will fetch all the necessary data, such as email and name, to compose and send emails.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_5.webp” alt=”Apps Script Google Sheets \u2014 Email Campaign sheet with Email, Name and Other Data columns” title_text=”Email Campaign sheet with Email, Name and Other Data columns” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5. Click the \u201cSave<\/b>\u201d icon to save the script. <\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_6.webp” alt=”Apps Script Google Sheets \u2014 Save project icon highlighted above the sendEmails code” title_text=”Save project icon highlighted above the sendEmails code” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6. In the top left corner, rename your project and click \u201cRun<\/b>.\u201d The script will send emails to all addresses in your sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_7.webp” alt=”Apps Script Google Sheets \u2014 project renamed Email Campaign with the Run button highlighted” title_text=”Project renamed Email Campaign with the Run button highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 7. Apps Script scripts require authorization to access your Google Sheets data. You’ll be prompted to grant these permissions when you run a script.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_8.webp” alt=”Apps Script permissions \u2014 Authorization required dialog with Review permissions button” title_text=”Authorization required dialog with Review permissions button” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 8. You can also set up a trigger to run the script automatically on a schedule (e.g., daily or weekly). To do that, hover over your mouse on the left icons and click \u201cTriggers<\/b>.\u201d<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_9.webp” alt=”Apps Script trigger \u2014 Execution log shows run completed, Triggers menu item highlighted” title_text=”Execution log shows run completed, Triggers menu item highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 9. Click the \u201c+ Add Trigger<\/b>\u201d button.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_10.webp” alt=”Apps Script trigger \u2014 empty Triggers page with the Add Trigger button highlighted” title_text=”Empty Triggers page with the Add Trigger button highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 10. Go to event source and choose “Time-driven<\/b>.”<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_11.webp” alt=”Apps Script trigger \u2014 Add Trigger dialog with Time-driven selected as event source” title_text=”Add Trigger dialog with Time-driven selected as event source” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 11. Select a time-based type.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_12.webp” alt=”Apps Script trigger \u2014 time-based trigger type list with Minutes timer highlighted” title_text=”Time-based trigger type list with Minutes timer highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 12. Click “Save<\/b>.” The trigger is now active.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_13.webp” alt=”Apps Script trigger \u2014 sendEmails set to run every 15 minutes with Save button highlighted” title_text=”SendEmails set to run every 15 minutes with Save button highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here is the email I received after running the script.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_14.webp” alt=”Google Apps Script in Google Sheets \u2014 Gmail inbox showing the Automated Email sent by the script” title_text=”Gmail inbox showing the Automated Email sent by the script” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There you go! You now know how to use Google Apps Script in Google Sheets. But let\u2019s discuss more use cases and see how Apps Script enhances spreadsheets.<\/p>\n<\/p>\n [\/et_pb_text][et_pb_text module_id=”practical” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can use Google Apps Scripts in Google Sheets to automate data entry.<\/p>\n Manual data entry is prone to typos. With automation<\/a>, you reduce the chances of human mistakes. Apps Script can pull data from other sources (like websites, forms, or emails) and automatically plug it into your spreadsheet.\u00a0<\/p>\n Let’s say you get emailed receipts for business expenses. Apps Script can scan those emails, extract the relevant numbers (date, amount, category), and neatly organize them in your expense tracker spreadsheet.<\/p>\n Let\u2019s write and explain a script:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]function extractExpensesFromEmails() {<\/p>\n \/\/ 1. Get Unread Emails with Receipts \/\/ 2. Process Each Email \/\/ 3. Extract Expense Details (This is a simplified example) \/\/ 4. If found, add to Spreadsheet \/\/ 5. Mark Email as Read We assume you have a Gmail label called “Receipts” where you store expense emails. The script fetches the first 5 unread threads (conversations) from that label. It loops through each thread and its individual messages (emails).<\/p>\n It then extracts expense details. Keep in mind that we’ve highly simplified this part. The script assumes a specific format for expenses in the email body (e.g., “$15.99” and “07\/25\/2024”).<\/p>\n Then, if the script finds both the amount and date, it gets the active spreadsheet and adds a new row with the extracted data (and the email subject for reference).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_16.webp” alt=”Google Apps Script in Google Sheets \u2014 Business Expenses sheet filled with dates, amounts and vendors” title_text=”Business Expenses sheet filled with dates, amounts and vendors” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Finally, after processing, the script marks the email thread as read to avoid duplicates.<\/p>\n Note:<\/b> Our script is simplified. The accuracy of the data depends entirely on the email format and the script’s ability to parse it correctly. Moreover, you might have additional columns in your actual expense tracker (e.g., category, payment method).<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also use Google Apps Script in Google Sheets to generate reports.<\/p>\n Think about those tedious reports you have to make\u2014maybe sales summaries, project updates, or student grades. Apps Script can take the pain out of this process by pulling that data from a Google Sheet or other places.\u00a0<\/p>\n Let’s say you track your weekly sales in a Google Sheet. Apps Script can:<\/p>\n You set it up once, and then Google Apps Script does the rest \u2013 week after week!<\/p>\n Here is a script example, and we will explain it below.<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n function generateSalesReport() {<\/p>\n \u00a0\u00a0\/\/ Get the sales data<\/p>\n \u00a0\u00a0var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“WeeklySales”);<\/p>\n \u00a0\u00a0var data = sheet.getDataRange().getValues();<\/p>\n \u00a0\u00a0\/\/ Calculate total sales and sales by product<\/p>\n \u00a0\u00a0var totalSales = 0;<\/p>\n \u00a0\u00a0var salesByProduct = {};<\/p>\n \u00a0\u00a0for (var i = 1; i < data.length; i++) { \/\/ Skip header row<\/p>\n \u00a0\u00a0\u00a0\u00a0var product = data[i][1];<\/p>\n \u00a0\u00a0\u00a0\u00a0var sales = data[i][2];<\/p>\n \u00a0\u00a0\u00a0\u00a0totalSales += sales;<\/p>\n \u00a0\u00a0\u00a0\u00a0salesByProduct[product] = (salesByProduct[product] || 0) + sales;<\/p>\n \u00a0\u00a0}<\/p>\n \u00a0\u00a0\/\/ Create the report<\/p>\n \u00a0\u00a0var report = “<h2>Weekly Sales Report<\/h2>\\n\\n”;<\/p>\n \u00a0\u00a0report += “<p>Total Sales: $” + totalSales.toFixed(2) + “<\/p>\\n\\n”;<\/p>\n \u00a0\u00a0report += “<h3>Sales by Product:<\/h3>\\n\\n”;<\/p>\n \u00a0\u00a0for (var product in salesByProduct) {<\/p>\n \u00a0\u00a0\u00a0\u00a0report += “<p>” + product + “: $” + salesByProduct[product].toFixed(2) + “<\/p>\\n\\n”;<\/p>\n \u00a0\u00a0}<\/p>\n \u00a0\u00a0\/\/ Send the email<\/p>\n \u00a0\u00a0var emailSubject = “Weekly Sales Report”;<\/p>\n \u00a0\u00a0var emailBody = report;<\/p>\n \u00a0\u00a0MailApp.sendEmail(“YOUR_EMAIL_ADDRESS”, emailSubject, “”, {htmlBody: emailBody}); \/\/ Include your email address<\/p>\n }<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_17.webp” alt=”Google Apps Script in Google Sheets \u2014 generateSalesReport function in the Apps Script editor” title_text=”GenerateSalesReport function in the Apps Script editor” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Recommended reading:<\/b> Top 5 Google Sheets sales templates<\/a><\/p>\n The script fetches all the values from the “WeeklySales” sheet. It loops through the data and calculates total sales and sales per product. It then creates an HTML report with the calculated data. Finally, the script uses MailApp.sendEmail to send the report as an email.<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n MailApp.sendEmail<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here is a Google Sheet grouping all sales:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_18.webp” alt=”Apps Script Google Sheets \u2014 WeeklySales sheet with Week, Product and Sales columns” title_text=”WeeklySales sheet with Week, Product and Sales columns” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here is what the total weekly sales report looks like in the email:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_19.webp” alt=”Google Apps Script in Google Sheets \u2014 Gmail showing the Weekly Sales Report with totals by product” title_text=”Gmail showing the Weekly Sales Report with totals by product” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Note:<\/b> This is a simplified script. Change “WeeklySales” if your sheet has a different name. Replace “YOUR_EMAIL_ADDRESS” with the actual recipient\u2019s email address.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Cleaning and formatting data is another way to use Apps Scripts in Google Sheets.<\/p>\n Imagine you have a messy spreadsheet filled with customer information. Maybe some names have extra spaces, dates are in different formats, or some cells have typos. Cleaning this up manually would be a real headache. This is where Apps Scripts come in to save the day.<\/p>\n You can use Google Apps Scripts to scan your data and find and fix specific issues, such as:<\/p>\n You can also use Google Apps Scripts to organize information and combine or split data.<\/p>\n Let\u2019s create a Javascript for this example.<\/p>\n Imagine you have a Google Sheet with customer orders. Each row has information like Order ID, Customer Name, Product, Quantity, and Order Date. You want to organize the orders by date, with the most recent orders at the top.<\/p>\n Our script could be something like this:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n function sortSheetByDate() {<\/p>\n \u00a0\u00a0var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();<\/p>\n \u00a0\u00a0var range = sheet.getRange(“A2:E26”); \/\/ Adjust the range to cover your data<\/p>\n \u00a0\u00a0\/\/ Get the data<\/p>\n \u00a0\u00a0var data = range.getValues();<\/p>\n \u00a0\u00a0\/\/ Check if dates are in Date object format and convert them to strings<\/p>\n \u00a0\u00a0data.forEach(function(row) {<\/p>\n \u00a0\u00a0\u00a0\u00a0if (Object.prototype.toString.call(row[4]) === ‘[object Date]’) {<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0row[4] = Utilities.formatDate(row[4], SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone(), ‘dd\/MM\/yyyy’);<\/p>\n \u00a0\u00a0\u00a0\u00a0}<\/p>\n \u00a0\u00a0});<\/p>\n \u00a0\u00a0\/\/ Parse the dates correctly and sort<\/p>\n \u00a0\u00a0data.sort(function(a, b) {<\/p>\n \u00a0\u00a0\u00a0\u00a0var dateA = new Date(a[4].split(‘\/’).reverse().join(‘-‘));<\/p>\n \u00a0\u00a0\u00a0\u00a0var dateB = new Date(b[4].split(‘\/’).reverse().join(‘-‘));<\/p>\n \u00a0\u00a0\u00a0\u00a0return dateB – dateA; \/\/ Sort from newest to oldest<\/p>\n \u00a0\u00a0});<\/p>\n \u00a0\u00a0\/\/ Set the sorted data back to the sheet<\/p>\n \u00a0\u00a0range.setValues(data);<\/p>\n }<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_20.webp” alt=”Apps Script Google Sheets \u2014 sortSheetByDate function in Code.gs that sorts rows by date” title_text=”SortSheetByDate function in Code.gs that sorts rows by date” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The script finds the order of information you want to sort. It then carefully takes all the information from each order form \u2013 customer name, order date, etc. \u2013 and puts it into separate cells. This is where the magic happens! The script looks at each order date and finds which orders are newer and which are older.<\/p>\n Data with dates not in chronological order:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_21.webp” alt=”Apps Script Google Sheets \u2014 Customer Orders sheet with unsorted order dates” title_text=”Customer Orders sheet with unsorted order dates” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Data with dates in chronological order after using the script:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_22.webp” alt=”Apps Script Google Sheets \u2014 Customer Orders sheet after the script sorted by newest date first” title_text=”Customer Orders sheet after the script sorted by newest date first” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”essential” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Custom functions allow you to create your own functions that you can use directly in Google Sheets, just like the built-in functions (SUM<\/a>, AVERAGE<\/a>, etc.). These functions<\/a> are written in JavaScript within Apps Script and can perform various tasks, from simple calculations to complex data manipulations.<\/p>\n Here is an example of a custom function:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n function DOUBLE(input) {<\/p>\n \u00a0\u00a0return input * 2;<\/p>\n }<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This custom function doubles numbers in a cell. After adding the custom function to the Script Editor, go back to your spreadsheet.<\/p>\n Let’s say cell A1 contains the number 580.<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =DOUBLE(A1)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_23.webp” alt=”Apps Script custom function \u2014 spreadsheet cells A1 and B1 showing 580 and 1160 highlighted” title_text=”Spreadsheet cells A1 and B1 showing 580 and 1160 highlighted” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The main difference between a custom function and any other code lies in how you use and call them within Google Sheets.<\/p>\n A custom function code must return a value<\/b>, like:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n return input * 2;.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n A function cannot modify any part of the spreadsheet or trigger any other actions. It can only compute and return a result based on its inputs.<\/p>\n Moreover, to use a custom function, you must enter the =functionName() code into a cell<\/b> on the spreadsheet, like:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n \u00a0=DOUBLE(A1) <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You also need to learn about triggers if you want to use Google Apps Script in Google Sheets.<\/p>\n Imagine you have a task in Google Sheets that should happen automatically, without you having to click any buttons. That’s where triggers come in!\u00a0 A trigger is like a little alarm clock you set up within your Apps Script code. It tells your script to wake up and run a specific part of your code when a particular event happens in your spreadsheet.<\/p>\n You can customize triggers to run your script when a sheet is opened, a cell is edited, a form is submitted, or even on a specific date and time.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_24.webp” alt=”Apps Script trigger \u2014 From spreadsheet event type list with On open, On edit, On change, On form submit” title_text=”From spreadsheet event type list with On open, On edit, On change, On form submit” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also use triggers to keep your data fresh. For example, a trigger could automatically pull in the latest stock prices or weather information.\u00a0<\/p>\n If you’d rather start a script yourself with one click, you can assign it to a button in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Properties and methods let you change how Google Sheets works. You can write scripts that automatically format cells or move data around. For example, instead of manually changing the color of hundreds of cells, your script can do it instantly.<\/p>\n Think of properties like the traits or attributes of an object. In Google Sheets, this could be:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.getBackground()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.getValue()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n \u00a0cell.getFontSize()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can find out a property’s current value or set it to change its appearance or behavior.<\/p>\n Methods, however, are like the verbs or actions that an object can perform. For example, a cell in Google Sheets can:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.setValue(“Hello!”)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.clearContent()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.mergeAcross()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You “call” a method to make it happen. It’s like giving an instruction.<\/p>\n Here is a simple script example:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n function formatImportantCells() {<\/p>\n \u00a0\u00a0var sheet = SpreadsheetApp.getActiveSheet();<\/p>\n \u00a0\u00a0var range = sheet.getRange(“A1:B10”); \/\/ Get a group of cells<\/p>\n \u00a0\u00a0var cells = range.getCells(); \/\/ Get individual cells<\/p>\n \u00a0\u00a0for (var i = 0; i < cells.length; i++) {<\/p>\n \u00a0\u00a0\u00a0\u00a0if (cells[i].getValue() > 100) { \/\/ Check the value<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cells[i].setBackground(“yellow”); \/\/ Set a property (color)<\/p>\n \u00a0\u00a0\u00a0\u00a0}<\/p>\n \u00a0\u00a0}<\/p>\n }<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_25.webp” alt=”Google Apps Script in Google Sheets \u2014 formatImportantCells function that colors cells above 100 yellow” title_text=”FormatImportantCells function that colors cells above 100 yellow” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This script checks the values in cells A1 through B10. If a value is greater than 100, the script turns the cell’s background yellow.<\/p>\n In short:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n cell.getValue()<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Data types are another concept you need to learn to use Google Apps Script in Google Sheets.<\/p>\n Data types are labels that tell Apps Script what kind of information it’s dealing with. Just like you’d distinguish between apples and oranges, Apps Script needs to know if it’s working with numbers, text, dates, or other types.<\/p>\n But why do data types matter in Google Sheets?<\/p>\n There are at least three reasons:<\/p>\n Let’s say you’re tracking sales and have a column in Google Sheets with the number of items sold. When you use Apps Script to calculate total sales, it needs to understand this column contains numbers, not just random characters.<\/p>\n For instance, the script below mentions the data type:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n if (valueType === “number”) {<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here’s the breakdown:<\/p>\n We\u2019ve just covered a few Apps Scripts concepts or terms. There are more, though, such as Apps Script Services, Error Handling, and Libraries.<\/p>\n [\/et_pb_text][et_pb_text module_id=”tips” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Learning JavaScript gives you a solid foundation for understanding how Google Apps Script works. It becomes way easier to figure out code you find online, troubleshoot your own projects, and write more advanced scripts.<\/p>\n Once you’ve grasped the basics of JavaScript, you’ll manipulate data in really clever ways and interact with other services on the web.<\/p>\n Moreover, JavaScript is a widely used language, so your new skills won’t go to waste. You can apply them to other projects beyond Google Apps Script. For instance, you can build simple websites or even work on complex web development projects.<\/p>\n Your code is like a recipe, and a good recipe is:<\/p>\n Here are a few additional tips for Google Apps Script:<\/p>\n In Google Apps Script, bugs are errors or unexpected behavior in your code. Debugging is the process of finding and correcting these issues.<\/p>\n When Apps Script encounters a problem, it usually displays an error message. This message is your first clue. It often tells you what went wrong. You\u2019ll know if you used a variable that doesn’t exist, divided by zero, or something else. You\u2019ll also know where it went wrong, like the line of code causing trouble.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_26.webp” alt=”Apps Script Google Sheets \u2014 Execution log TypeError error highlighted for generateSalesReport” title_text=”Execution log TypeError error highlighted for generateSalesReport” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Apps Script has a built-in debugger. It’s like a more powerful version of \u201cconsole.log().\u201d You can pause your code, step through it line by line, and inspect variables in real time.<\/p>\n Let’s say you have this code:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n function calculateArea(length, width) {<\/p>\n \u00a0\u00a0var area = length * width;<\/p>\n \u00a0\u00a0console.log(“The area is: ” + area);\u00a0<\/p>\n }<\/p>\n calculateArea(10,); \/\/ Notice the missing argument for width<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You run it, and it crashes with an error: “TypeError: Cannot read property ‘*’ of undefined.” What’s happening?<\/p>\n Fix the error:<\/b> Change the last line to:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n calculateArea(10, 5);<\/p>\n [\/et_pb_text][et_pb_text module_id=”use” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Congratulations! You’ve just unlocked the power of Apps Script within Google Sheets. In this article, we saw some practical use cases and shared script examples. You are now fully equipped to use Google Apps Script in Google Sheets.<\/p>\n By automating tasks, customizing functions, and even building interactive web applications, you’re well on your way to becoming a spreadsheet ninja. Keep learning, keep scripting, and keep pushing the boundaries of what’s possible in Google Sheets.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once your first script runs, these are good next steps, roughly in this order:<\/p>\n Google’s Apps Script reference<\/a> documents every service and method, and its guide to extending Google Sheets<\/a> has samples you can copy. If you’d rather not write code for a simple task, you can record a macro in Google Sheets<\/a> instead, and Apps Script saves it as a script you can edit later.<\/p>\n [\/et_pb_text][et_pb_text module_id=”faq” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n How to add Script Editor to Google Sheets?<\/b><\/p>\n The Script Editor is built into Google Sheets. You don’t need to add it separately.<\/p>\n How to open the Script Editor in Google Sheets?<\/b><\/p>\n Go to Extensions > Apps Script. This will open the Script Editor in a new tab.<\/p>\n Where is the Script Editor in Google Sheets?<\/b><\/p>\n The Script Editor is not physically located within your Google Sheet. It opens in a separate tab or window when accessed through the Extensions menu. Go to Extensions > Apps Script.<\/p>\n Is Google Apps Script free?<\/b><\/p>\n Yes. Apps Script is free with any Google account, and you don’t need a paid plan to script Google Sheets. The limits are quotas: a script can run for up to 6 minutes at a time, and triggers on a free Google account get 90 minutes of total runtime a day. Google Workspace accounts get higher quotas.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" This article will teach you how to use Google Apps Script in Google Sheets. We will share script examples and how they affect spreadsheets. We will also explain some key concepts like Custom Functions and Data Types. Let\u2019s get right into it! Key Takeaways: In Google Sheets, Apps Script can be used to automate data […]<\/p>\n","protected":false},"author":2,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-50318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=50318"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/50318\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=50318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=50318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=50318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
What is Google Apps Script?<\/b><\/h2>\n
\n
How to use Google Apps Script in Google Sheets?<\/b><\/h2>\n
\n
\nconst sheet = SpreadsheetApp.getActiveSheet();
\nconst data = sheet.getDataRange().getValues(); \/\/ Get all data
\nconst headers = data.shift(); \/\/ Remove and store headers
\nfor (let i = 1; i < data.length; i++) {
\nconst row = data[i];
\nconst emailAddress = row[headers.indexOf(“Email”)]; \/\/ Get email from column
\nconst subject = “Automated Email”; \/\/ Customize subject
\nconst message = `Hello ${row[headers.indexOf(“Name”)]}, this is an automated email from Google Sheets.`; \/\/ Customize message
\nif (emailAddress) { \/\/ Check if email exists
\nMailApp.sendEmail({
\nto: emailAddress,
\nsubject: subject,
\nbody: message
\n});
\n}
\n}
\n}[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_4.webp” alt=”Google Apps Script in Google Sheets \u2014 sendEmails function pasted into Code.gs that emails each row” title_text=”SendEmails function pasted into Code.gs that emails each row” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n\n
Practical examples of Apps Scripts in action<\/b><\/h2>\n
1. Automate data entry<\/b><\/h3>\n
\nvar label = GmailApp.getUserLabelByName(“Receipts”); \/\/ Change “Receipts” if your label is different
\nvar threads = label.getThreads(0, 5); \/\/ Get the first 5 unread threads<\/p>\n
\nfor (var i = 0; i < threads.length; i++) {
\nvar messages = threads[i].getMessages();
\nfor (var j = 0; j < messages.length; j++) {
\nvar message = messages[j];<\/p>\n
\nvar body = message.getBody();
\nvar amountMatch = body.match(\/\\$\\d+\\.\\d{2}\/);\u00a0 \/\/ Look for $ amounts
\nvar dateMatch = body.match(\/\\d{2}\\\/\\d{2}\\\/\\d{4}\/); \/\/ Look for MM\/DD\/YYYY dates<\/p>\n
\nif (amountMatch && dateMatch) {
\nvar amount = amountMatch[0];
\nvar date = dateMatch[0];
\nvar sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
\nsheet.appendRow([date, amount, message.getSubject()]); \/\/ Adjust columns as needed
\n}
\n}<\/p>\n
\nthreads[i].markRead();
\n}
\n}[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/08\/google_apps_scripts_google_sheets_15.webp” alt=”Google Apps Script in Google Sheets \u2014 extractExpensesFromEmails script reading Gmail receipts” title_text=”ExtractExpensesFromEmails script reading Gmail receipts” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nWhat does this script mean?<\/b><\/h4>\n
2. Generate Reports<\/b><\/h3>\n
\n
What does this script mean?<\/b><\/h4>\n
3. Clean and format data<\/b><\/h3>\n
\n
What does this script mean?<\/b><\/h4>\n
Essential Apps Script concepts to know and use in Google Sheets<\/b><\/h2>\n
1. Custom functions<\/b><\/h3>\n
\n
\n
Difference between a custom function and a general code you write in the Google Apps Script<\/b><\/h4>\n
2. Triggers<\/b><\/h3>\n
3. Properties and Methods<\/b><\/h3>\n
\n
\n
\n
\n
\n
\n
\n
4. Data types<\/b><\/h3>\n
\n
\n
Tips and best practices for Apps Script<\/b><\/h2>\n
1. Learn Javascript<\/b><\/h3>\n
2. Write efficient and maintainable code<\/b><\/h3>\n
\n
\n
3. Debug smartly<\/b><\/h3>\n
\n
Use Google Apps Scripts to enhance your Google Sheets<\/b><\/h2>\n
Where to go from here<\/h2>\n
\n
FAQ<\/b><\/h2>\n