Google Apps Script allows you to write scripts and programs in JavaScript to automate, connect and extend the products in Google’s G Suite, including Sheets, Docs, Slides, Gmail, Drive, and several others. Learning it requires an investment in time, as does writing the scripts, but the productivity increases and additional opportunities that ...Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent).In this tutorial we'll cover how to work with script editor, mai...Mở Google Sheets có macro bạn muốn sao chép và sau đó click vào Tools > Macros > Manage Macros. Tiếp theo, click vào biểu tượng của More bên cạnh macro bạn muốn sao chép và sau đó click vào Edit Script. Tất cả các macro được lưu vào cùng một file, vì vậy nếu chỉ muốn sử dụng một ...That's it. You created a button and configured it to run a Google Apps Script function whenever a user clicks on it. Run a macro in Google Sheets from a button. You can also use this approach to run macros that you've recorded in Google Sheets. Let's say you've recorded a macro to bold text in the selected cell. This macro is called boldText.Click Extensions > Apps Script. In the Apps Script project, click Project settings . Under the script ID, click Copy. Set the script ID aside for use in a later step. Open or create a new spreadsheet where you want to add the macro. You must have permission to edit the spreadsheet.Mar 5, 2024 · For a quick introduction to using Apps Script with Google Sheets, see the 5-minute quickstart guide for Macros, Menus, and Custom Functions. Get started Apps Script includes special APIs to let you programmatically create, read, and edit Google Sheets. 1. Google Sheets Macros is managed by a function of the container-bound script of the Spreadsheet. So when you want to run the function from outside, unfortunately, it cannot be achieved by Sheets API. You can achieve it by the scripts.run method of Apps Script API and Web Apps. – Tanaike.Try a simple trigger if you don't want to use onOpen function. Step 1 - Go to Tools >> Script Editor Step 2 - Click on Triggers Step 3 - Choose which function to run Step 4 - Select event type as "On Open" Step 5 - Save the trigger. Thanks Rocheux, this is absolutely what I need! I was concentrating on the onOpen function but there was more …One way to run your scripts and macros in Google Sheets is with a button. Here's how to create buttons from drawings or images.That's it. You created a button and configured it to run a Google Apps Script function whenever a user clicks on it. Run a macro in Google Sheets from a button. You can also use this approach to run macros that you've recorded in Google Sheets. Let's say you've recorded a macro to bold text in the selected cell. This macro is called boldText.Jan 31, 2023 · Step 1. First, select the spreadsheet where you want to record your macro. Before you create the macro itself, we suggest doing a practice run of each step you want to add to the macro. In the current example, we want to create a macro that adds a currency formatting to column D and inserts a pie chart that breaks down the distribution of each ... Convert Excel macros to Google Sheets. Do more with add-ons. Automate tasks with macros. Convert Excel macros to Google Sheets. Do more with add-ons. Back to top. …Macros created for MS Excel documents (and even converted to Google Sheets format) will not work in Google Sheets documents. Do not inflate the macro, do not record many actions at once. For example, there are many formatting requirements on a single worksheet.Step 2. In the window that appears, type in the name of your macro exactly as you typed it when you saved the macro, then hit OK. If you are assigning a script to the button, type the script name exactly as it appears in the script editor: Now when you click on the button, the macro you assigned to will run.Open the spreadsheet in Google Sheets. Click on Tools from the menu bar. Go to Macros > Manage macros. Select the macro you would like to edit. Click the three-dot menu button. Choose Edit script to make changes to the macro actions. Click on the Remove option to delete macro in Google Sheets.May 24, 2018 · Then the next time you get a similar contact sheet, run the macro and it will do the cleanup work for you. With Google Sheets Macros you can: Use any Google Sheets formatting tools. Use any feature in a Google Sheets toolbar, menu, or right-click menu. Use any Google Sheets function. Select any cell, row, or column Sep 10, 2022 · Just open Docs or Sheets and go to Extensions, then click on Apps Script. A new tab with the Apps Script editor interface will open. There, you can create new scripts or run existing ones (use the ... To create a macro, go to sheets.google.com on a computer. Need more help? Try these next steps: Post to the help community Get answers from community members . Tools. 1 of 5. Use add-ons, Apps Script & AppSheet; 2 of 5. Keyboard shortcuts for Google Sheets; 3 of 5. Import, edit & sync Salesforce data with Google Sheets ...May 16, 2022 · Here’s how to run a macro in Google Sheets: First, select the cell where you want to run the saved macro. In the example below, we selected cell C7. Next, click the Extensions menu and select Macros. Under Macros, you’ll see a list of recently saved macros. Here, choose the macros you need to implement on the selected cell. A macro is one of the Google Sheets quick hacks to enhance the Google Sheets user experience. It increases your efficiency and capability to manage more data while reducing the overall turnaround time. The following are a few vital benefits of using macros in your spreadsheet: 1. Automation.How to run a macro on multiple sheets in your workbook? - Google Docs Editors Community. Help Center. Community. Google Docs Editors.Learn how to use a sheets macro to select cell A1 in Google Docs. Find answers from experts and other users, and get tips on using the ADDRESS and CELL functions.Method 1: Activate a sheet in Google Sheets using its name. The activateSheetByName() method below accesses the sheet using its name and then uses the activate() method of the Sheet object to activate it. function activateSheetByName(sheetName) {. var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName); sheet.activate();Mở Google Sheets có macro bạn muốn sao chép và sau đó click vào Tools > Macros > Manage Macros. Tiếp theo, click vào biểu tượng của More bên cạnh macro bạn muốn sao chép và sau đó click vào Edit Script. Tất cả các macro được lưu vào cùng một file, vì vậy nếu chỉ muốn sử dụng một ... Macro e Google Apps Script: Excel 2013 e 2010. Puoi automatizzare le attività ripetitive con le macro di Fogli o utilizzare Google Apps Script se hai bisogno di creare funzioni, menu o finestre personalizzate. Best practice relative alle macro. Limita il numero di azioni eseguite in una macro per ottenere prestazioni ottimali. This help content & information General Help Center experience. Search. Clear searchI am trying to print some information based on some parameters. I have the following script that sets the desired range, but I do not see a way to print it using script. function printInvoice() {. var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var range = sheet.getRange("A1:H46"); range.activate();Steps to Record Google Sheets Macro: 1. Go to the menu Tools > Macros > Record Macro. 2. Click on “Use relative reference”. 3. The Macro started recording my task! In Cell A1 I am going to type the word Info Inspired, then …If not, is there a quick and easy way for me to access the macro in each google sheet? Here is the Macro code as requested - changed some info. var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('AW:AW').activate(); spreadsheet.getActiveSheet().showColumns(47, 1);Strictly talking the only way to run a Google Sheets macro is through the Google Sheets UI, but macros code could be run the same way that any other Google Apps Script code. In order to keep this answer short and helpful, forget about running the functions saved on each spreadsheet and use a "master" Google Apps Script project.It's very likely that you already found the Macro recording feature of Google Sheets because the code on the question. While this feature could be useful, in order to be able to improve the recorded macro you should spend some time to learn the basics of JavaScript, Apps Script and the Spreadsheet Service.Both Google Sheets and Microsoft Excel are the top spreadsheet programs in the market. They look similar to beginners. However, there are key differences. Microsoft Excel is the best tool for Windows users, and it is a perfect fit for complex data analysis. It comparatively holds more data with added rows and columns.Open docs.google.com from any browser on PC. Click on hamburger menu icon at the top left corner and select “Sheets.”. Select a suitable template from the Google Sheets window (mostly, “Blank” is …I went ahead and coded up a quick App Script macro for Google Sheets that lets you select a 3-column wide swath of the spreadsheet and geocode a text address into coordinates. Update 10 January 2016: The opposite is now true too, you can take latitude, longitude pairs and reverse-geocode them to the nearest known address.Sending QR code from Google Sheets to email address. 1. Google QR-Code API encoded URL wrong in .NET and C#. 1. HOW TO INSERT QRCODE INTO …To create a macro, go to sheets.google.com on a computer. Need more help? Try these next steps: Post to the help community Get answers from community members . Tools. 1 of 5. Use add-ons, Apps Script & AppSheet; 2 of 5. Keyboard shortcuts for Google Sheets; 3 of 5. Import, edit & sync Salesforce data with Google Sheets ...Select the function ClearAllVisibleSheets in GoogleSpredsheets from Tools-> ScriptsEditor -> SelectFunction (ClearAllVisibleSheets) and run/or debug and you will see this do the job. P.S: If this satisfies your need, remember to upvote and kindly accept this as an answer :). answered Jan 8, 2020 at 16:31. Pramod Yadav.What are Google Sheets Macros? Macros are small programs that you can create within Google Sheets. Since you don’t need to use code, it’s become a highly valuable feature to automate repetitive …On your computer, open a spreadsheet at sheets.google.com. At the top, click Tools > Macros > Record macro. At the bottom, choose which type of cell reference you want your macro to use: Use absolute references: The macro will do tasks on the exact cell you record. For example, if you bold cell A1, the macro will only ever bold cell A1 ...In the most primitive way, this would look something like this: function setFilter() {. var ss = SpreadsheetApp.getActiveSpreadsheet(); var filterSettings = {}; // The range of data on which you want to apply the filter. // optional arguments: startRowIndex, startColumnIndex, endRowIndex, endColumnIndex.Download Google Sheets Macros Examples PDF. Download Google Sheets Macros Examples DOC. ᅠ. Must have script and sheets macros are intended to clean up on its own apps script into values, to get your macro. An apps script and it will save the video at least, you do you! Site by highlighting the google apps script into my favorite macros.Jun 17, 2019 · From the Google Sheets homepage, click the folder icon in the top right, click the "Upload" tab, then drag an Excel file over from your computer. Once the Excel file uploads, Sheets automatically converts and opens it, ready for you to start to edit, share, and collaborate. To open an Excel file that you want to edit that's already uploaded ... From here, find the Google Drive API and click the “Enable” button. Repeat for the Google Sheets API. Step 6: Next, select “Create Credentials” from the top menu on the project home page. Step 7: From the credentials options, select “Service account.”. Step 8: Name the service account and click “Create and Continue.”.Dennis Kane. 11 1. A key difference between Google Sheets and Excel is that Excel runs on your machine. Because Google Sheets runs that script invocation on a server somewhere, it caches and internally optimizes function calls/steps that utilize Google APIs and interfaces. "Pure" JavaScript calls will be individually stepped in the debugger.Adding a macro is easy. Open Google Spreadsheets and then choose: Tools → Macros → Record macro. A small window “Recording new macro …” will open. All recorded activities in Google Sheet will be saved and then played back when the macros are run. The “Use absolute references” option saves actions to specific, selected cells.On your computer, open a spreadsheet at sheets.google.com. At the top, click Extensions MacrosRecord macro. At the bottom, choose which type of cell reference you want your …212. 18K views 2 years ago SWITZERLAND. This video is dedicated to how you can use Google Sheets macros! Learn how to record macros in a Google Sheets document, …1. Access Google Sheets. 2. Sheets and Excel best practices. 3. Manage data in Sheets. 4. Analyse data in Sheets. 5. Use macros and add-ons. 6. Collaborate in Sheets. 7. …Nếu công việc của bạn hay phải sử dụng Google Sheet để làm việc, có những lúc, bạn sẽ ước làm thế nào để chúng ta có thể tự động hóa Google Sheet tránh làm những công việc lặp đi lặp lại nhàm chán?Học Excel Online xin bắt đầu bằng việc chia sẻ 10 đoạn macro (Code) dành cho Google Sheets để giúp bạn có ...Learn how to use a sheets macro to select cell A1 in Google Docs. Find answers from experts and other users, and get tips on using the ADDRESS and CELL functions.Here’s how to run a macro in Google Sheets: First, select the cell where you want to run the saved macro. In the example below, we selected cell C7. Next, click the Extensions menu and select Macros. Under Macros, you’ll see a list of recently saved macros. Here, choose the macros you need to implement on the selected cell.From here, find the Google Drive API and click the “Enable” button. Repeat for the Google Sheets API. Step 6: Next, select “Create Credentials” from the top menu on the project home page. Step 7: From the credentials options, select “Service account.”. Step 8: Name the service account and click “Create and Continue.”.Enabling macros in Google Sheets can streamline your tasks and automate processes. Follow the steps below to enable macros in Google Sheets: A. Accessing the "Script Editor". 1. Open Google Sheets. 2. Click on "Extensions" in the top menu. 3. Select "Apps Script" to open the Script Editor.A prompt is used to get input from the user in a Google Sheets application. A prompt is a popup dialog that has a text field for the user to enter some text. The code to display a prompt is written using Apps Script and is simple to write. For example, the code to display the prompt in the above image is just two lines long.1. Google Sheets Macros is managed by a function of the container-bound script of the Spreadsheet. So when you want to run the function from outside, unfortunately, it cannot be achieved by Sheets API. You can achieve it by the scripts.run method of Apps Script API and Web Apps. – Tanaike.From here, find the Google Drive API and click the “Enable” button. Repeat for the Google Sheets API. Step 6: Next, select “Create Credentials” from the top menu on the project home page. Step 7: From the credentials options, select “Service account.”. Step 8: Name the service account and click “Create and Continue.”. Macro e Google Apps Script: Excel 2013 e 2010. Puoi automatizzare le attività ripetitive con le macro di Fogli o utilizzare Google Apps Script se hai bisogno di creare funzioni, menu o finestre personalizzate. Best practice relative alle macro. Limita il numero di azioni eseguite in una macro per ottenere prestazioni ottimali. Do you want to use the record macro function in Google Sheets, but cannot find it under the Tools menu? Find out why this feature may be missing and how to enable it in this support thread. Learn from other users' questions …4 - Now run your macro using the keyboard shortcut, or go back to the main menu, "Tools", "Macros". Your macro will appear at the bottom of the panel; click the macro name. 5 - The system will advise Authorisation is required. Click Continue and follow the prompts to give authorisation. That's it. You can create a button to link to the macro.Nếu công việc của bạn hay phải sử dụng Google Sheet để làm việc, có những lúc, bạn sẽ ước làm thế nào để chúng ta có thể tự động hóa Google Sheet tránh làm những công việc lặp đi lặp lại nhàm chán?Học Excel Online xin bắt đầu bằng việc chia sẻ 10 đoạn macro (Code) dành cho Google Sheets để giúp bạn có ...File -> Spreadsheet Settings -> (Tab) Calculation -> Recalculation (3 Options) On change. On change and every minute. On change and every hour. This affects how often NOW, TODAY, RAND, and RANDBETWEEN are updated. but.. .. it updates only if the functions' arguments (their ranges, cells) are affected by that. from my example.Learn how to record a script in Google Sheets using macro recorder. This tutorial covers recording macros in absolute or relative mode, modifying macro scrip...Mar 5, 2024 · Creating a custom function. To write a custom function: Create or open a spreadsheet in Google Sheets. Select the menu item Extensions > Apps Script. Delete any code in the script editor. For the DOUBLE function above, simply copy and paste the code into the script editor. At the top, click Save save. Now you can use the custom function. Sub test() Dim cl As Object, count As Double For Each cl In Sheets("Sheet1").Range("10:10") If cl.MergeCells Then If cl.Offset(3, 0).HasFormula = False And cl.MergeArea.Cells(1, 1).Value = "Upfront Costs" Then count = count + cl.Offset(3, 0).Value End If Else MsgBox count Exit Sub End If Next cl End Sub ... Loop the recored …Use AppSheet to build custom applications on top of Sheets, without writing code. Or add custom functions, menu items, and macros with Apps Script. En un ordenador, abre una hoja de cálculo en sheets.google.com. En la parte superior, haz clic en Extensiones Macros Grabar macro. En la parte inferior, elige el tipo de referencia de celda que quieres que use la macro: Usar referencias absolutas: la macro se ejecutará en la celda exacta en la que grabes las tareas. Por ejemplo, si pones la ... How to run a macro on multiple sheets in your workbook? - Google Docs Editors Community. Help Center. Community. Google Docs Editors.Crearemos dashboards profesionales. Aprenderemos a trabajar con tablas dinámicas y a crear gráficos dinámicos. Crearemos formularios conectados a nuestra base de Google Sheets. Trabajaremos con macros sencillas y aprenderemos a crear funciones personalizadas. Nos conectaremos con Data Studio, para generar reportes más …Google Sheets Macros. Google Sheets lets you record macros that duplicate a specific series of UI interactions that you define. Once you've recorded a …To create a macro, go to sheets.google.com on a computer. Need more help? Try these next steps: Post to the Help Community Get answers from community members . Tools. 1 of 5. Use add-ons and Apps Script; 2 of 5. Keyboard shortcuts for Google Sheets; 3 of 5. Import, edit and sync Salesforce data with Google Sheets ...212. 18K views 2 years ago SWITZERLAND. This video is dedicated to how you can use Google Sheets macros! Learn how to record macros in a Google Sheets document, …There are 3 types of loops you can use when writing JavaScript inside the Apps Script editor in Google Sheets. Those are do, for and while loops. They each work slightly differently. For loops are our favorite construct when updating all the cells in a range. They offer outstanding performance and make for easily readable code.Step 1. First, select the spreadsheet where you want to record your macro. Before you create the macro itself, we suggest doing a practice run of each step you want to add to the macro. In the current example, we want to create a macro that adds a currency formatting to column D and inserts a pie chart that breaks down the distribution of each ...File -> Spreadsheet Settings -> (Tab) Calculation -> Recalculation (3 Options) On change. On change and every minute. On change and every hour. This affects how often NOW, TODAY, RAND, and RANDBETWEEN are updated. but.. .. it updates only if the functions' arguments (their ranges, cells) are affected by that. from my example.Open the spreadsheet in Google Sheets. Click on Tools from the menu bar. Go to Macros > Manage macros. Select the macro you would like to edit. Click the three-dot menu button. Choose Edit script to make changes to the macro actions. Click on the Remove option to delete macro in Google Sheets.This help content & information General Help Center experience. Search. Clear searchSteps to Record Google Sheets Macro: 1. Go to the menu Tools > Macros > Record Macro. 2. Click on “Use relative reference”. 3. The Macro started recording my task! In Cell A1 I am going to type the word Info Inspired, then … Macro e Google Apps Script: Excel 2013 e 2010. Puoi automatizzare le attività ripetitive con le macro di Fogli o utilizzare Google Apps Script se hai bisogno di creare funzioni, menu o finestre personalizzate. Best practice relative alle macro. Limita il numero di azioni eseguite in una macro per ottenere prestazioni ottimali. 2. Your issue can be solved by using an onOpen(e) trigger and by hosting your python script on Google Cloud. 1. Use the onOpen(e) trigger. The onOpen(e) trigger is used to create the menu MY MENU in your Spreadsheet each time the Spreadsheet opens. Moreover, the submenu item TRIGGER THE PYTHON SCRIPT will have the …Strictly talking the only way to run a Google Sheets macro is through the Google Sheets UI, but macros code could be run the same way that any other Google Apps Script code. In order to keep this answer short and helpful, forget about running the functions saved on each spreadsheet and use a "master" Google Apps Script project.Google Sheets Macros. Google Sheets lets you record macros that duplicate a specific series of UI interactions that you define. Once you've recorded a …Enabling macros in Google Sheets can streamline your tasks and automate processes. Follow the steps below to enable macros in Google Sheets: A. Accessing the "Script Editor". 1. Open Google Sheets. 2. Click on "Extensions" in the top menu. 3. Select "Apps Script" to open the Script Editor.1. Welcome to Web Apps Stack Exchange! Take the tour here. It would help immensely if you could share a copy of your spreadsheet containing dummy data and what you want the output to look like. In your face, a filter function could do that trick, though we'll have to see how your data is structured first. – David Tan.
3. As the screenshot shows the .XLSM label your Excel spreadsheet is being edited using Google Sheets without converting it to the Google Sheets format. In this case some features aren't available …. Video a texto
Apr 24, 2020 · Learn how to create and use Google Sheets macros, small programs that automate repeatable tasks without coding. Discover the benefits, limitations and best practices of macros, and how to integrate them with Apps Script coding. See examples of macros for formatting, applying formulas, creating charts and more. Learn how to record and run macros in Google Sheets to speed up your work and create custom keyboard shortcuts for any feature or function. Macros …Come and explore the amazing world of macros in Google Sheets! Lesson taken from the Apps Script Blastoff! course. This free, introductory online course teac...It's very likely that you already found the Macro recording feature of Google Sheets because the code on the question. While this feature could be useful, in order to be able to improve the recorded macro you should spend some time to learn the basics of JavaScript, Apps Script and the Spreadsheet Service.1. Google Sheets Automation with Macros What are Macros? Macros are automated scripts in spreadsheets designed to streamline repetitive tasks. By recording a sequence of actions, macros serve as a “recipe” that users can later activate with a single click or a keyboard shortcut, such as Ctrl+Alt+Shift+Number (on Mac: … In Sheets, open a spreadsheet. At the top, click Tools Macros Record macro. At the bottom, select the type of cell reference to use: Use absolute references —When you run the macro, it will only do tasks on the exact cells you select. For example, if you start in cell B1 (recording starts when you place your cursor) and then click cell D1 and ... Master the use of formulas, functions, and data analysis tools to derive meaningful insights from your data. Create visually compelling charts, graphs, and pivot tables to represent your data effectively. Streamline your data management, analysis, and collaboration with Google Sheets. Enroll today in "Google Sheets - The Complete Google Sheets ... Google Tabellen: Makros in Google Tabellen neu erstellen: Excel 2010 und 2013. Sie können Makros aus Microsoft® Excel®-Tabellen in Google Tabellen konvertieren. Dazu müssen Sie sie mit Google Apps Script neu erstellen. Apps Script unterstützt Makros in Google Tabellen, genau wie Microsoft® Visual Basic for Applications® dies für Excel tut. Create the Apps Script project. Click the following button to make a copy of the Gmail/Sheets Mail Merge sample spreadsheet. The Apps Script project for this solution is attached to the spreadsheet. Make a copy. In your copied spreadsheet, update the Recipients column with email addresses you want to use in the mail merge.This help content & information General Help Center experience. Search. Clear searchbreak; } } } In this modified script, when the script is run, a row is added to the sheet. By this, the number of rows are increased every run. When you want to keep the number of rows when the script is run, please use the line of // spreadsheet.deleteRow(spreadsheet.getMaxRows());. By this, when new row is … In Sheets, open a spreadsheet. At the top, click Tools Macros Record macro. At the bottom, select the type of cell reference to use: Use absolute references —When you run the macro, it will only do tasks on the exact cells you select. For example, if you start in cell B1 (recording starts when you place your cursor) and then click cell D1 and ... Schedule your macro. You can set your macro to run based on actions, calendar updates, time intervals or a chosen time and date. On your computer, open a spreadsheet at sheets.google.com. Click Tools Script editor. At the top, click Edit Current project's triggers. At the bottom right, click Add trigger and select your options. 1. Google Sheets Macros is managed by a function of the container-bound script of the Spreadsheet. So when you want to run the function from outside, unfortunately, it cannot be achieved by Sheets API. You can achieve it by the scripts.run method of Apps Script API and Web Apps. – Tanaike.To create a new macro, open a spreadsheet. The sheet doesn't have to contain data, but the macro is specific to the spreadsheet, so data will have to be entered or copied to it before the macro ...Download Google Sheets Macros Examples PDF. Download Google Sheets Macros Examples DOC. ᅠ. Must have script and sheets macros are intended to clean up on its own apps script into values, to get your macro. An apps script and it will save the video at least, you do you! Site by highlighting the google apps script into my favorite macros. Macro e Google Apps Script: Excel 2013 e 2010. Puoi automatizzare le attività ripetitive con le macro di Fogli o utilizzare Google Apps Script se hai bisogno di creare funzioni, menu o finestre personalizzate. Best practice relative alle macro. Limita il numero di azioni eseguite in una macro per ottenere prestazioni ottimali. If a person wants to use code that modifies spreadsheets on their behalf, they must grant permission to it. Apps Script does not do provisional access elevation, instead it requests permission for the most dangerous scopes defined anywhere in the project, even if they are not called by the functions that will be used (and even if they are …Create the Apps Script project. Click the following button to make a copy of the Gmail/Sheets Mail Merge sample spreadsheet. The Apps Script project for this solution is attached to the spreadsheet. Make a copy. In your copied spreadsheet, update the Recipients column with email addresses you want to use in the mail merge.Download Google Sheets Macros Examples PDF. Download Google Sheets Macros Examples DOC. ᅠ. Must have script and sheets macros are intended to clean up on its own apps script into values, to get your macro. An apps script and it will save the video at least, you do you! Site by highlighting the google apps script into my favorite macros..