{"id":17026,"date":"2025-01-04T10:00:12","date_gmt":"2025-01-04T01:00:12","guid":{"rendered":"https:\/\/84office.jp\/?p=17026"},"modified":"2025-01-05T12:54:28","modified_gmt":"2025-01-05T03:54:28","slug":"script-execution-simple","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/script-execution-simple\/","title":{"rendered":"Simplify Google Apps Script Execution: How to Use Shape Buttons and Macro Imports"},"content":{"rendered":"
<\/div>\n

Google Apps Script (GAS) can help streamline your daily tasks, but have you ever found it inconvenient to run scripts directly from the GAS editor every time?<\/p>\n\n\n\n

Wouldn’t it be great if you could execute GAS directly from your spreadsheet more easily and save even more time?<\/p>\n\n\n\n

In this article, we\u2019ll introduce two simple methods for running GAS directly within Google Sheets: using shape buttons<\/strong> and using macro imports.<\/strong><\/p>\n\n\n

\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t
\"\"<\/figure><\/div>\t\t\t\t\t
\n\t\t\t\t\t\tStreamline Your Workflow with Google Apps Script: Easily Transfer Gmail Content to Google Sheets<\/a>\n\t\t\t\t\t\tDo you find it time-consuming and tedious to manually transfer information received in Gmail to a Google Sheet? When you need to extract only the necessary i…<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n

Example Output<\/h2>\n\n\n\n

Running Google Apps Script Using Shape Buttons<\/strong><\/strong><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Shape buttons allow for intuitive and user-friendly operation.<\/strong><\/p>\n\n\n\n

By clicking a shape button placed in your Google Spreadsheet, the assigned GAS script is executed immediately.<\/p>\n\n\n\n

For example, you can assign a script that retrieves specific Gmail data to a button, and simply pressing the button will trigger the process.<\/p>\n\n\n\n

This approach is visually intuitive, ensuring users can operate it without confusion about what the button does.<\/p>\n\n\n\n

Running Google Apps Script Using Macro Imports<\/strong><\/h3>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n

Easily executed from the menu.
Organize and manage multiple scripts.<\/strong><\/p>\n\n\n\n

From the “Extensions” > “Macros”<\/strong> menu, you can easily select and run pre-created Apps Scripts.<\/p>\n\n\n\n

By adding frequently used scripts to the menu, you can significantly reduce the effort required for execution.<\/p>\n\n\n\n

How to Execute Apps Script Using Shape Buttons<\/h2>\n\n\n\n
\n
STEP<\/span><\/div>
Create a Shape<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Go to “Insert” > “Drawing”<\/strong> and select “Shape.”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

From “Shapes,”<\/strong> select any shape (e.g., a rectangle) and draw it.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Right-click on the shape you created and select “Edit text”<\/strong> to add text to it.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Add clear and descriptive text to the shape.<\/p>\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Assign the Script<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Click on the created shape, then select “Assign script”<\/strong> from the right-click menu or the “…”<\/strong> menu.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Enter the name of the script you want to execute (e.g., saveEmailsToSheet<\/code><\/strong>).<\/p>\n\n\n\n

Now, simply clicking the shape will run the assigned script.<\/p>\n\n\n\n

\n
Script Name Location<\/span><\/i><\/i><\/span><\/summary>
\n
\"\"<\/figure>\n<\/div>\n\n\n

If your script starts with function saveEmailsToSheet() {<\/code>, copy the saveEmailsToSheet<\/code><\/strong> portion and paste it when assigning the script to the shape.<\/p>\n<\/div><\/details>\n<\/div>\n\n\n\n\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Test and Verify<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

Click the button on the spreadsheet to ensure the script executes as expected.<\/p>\n\n\n\n

\n

If you’re running the script for the first time, you need to authorize it.<\/p>\n\n\n\n

Therefore, press “Review Permissions.<\/strong>“<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n
\n
Detailed Authorization Steps<\/span><\/i><\/i><\/span><\/summary>
\n

Press “Advanced.”<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n\n\n

Press “Go to Untitled project (Unsafe).”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

After that, press “Allow.”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n\n<\/div><\/details>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n

How to Execute Apps Script Using Macro Imports<\/strong><\/h2>\n\n\n\n
\n
STEP<\/span><\/div>
Import a Macro<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

In your spreadsheet, go to “Extensions” > “Macros” > “Import macro.”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Select the function you want to use from the list and click “Add function.”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The selected function will be added to the menu as a macro.<\/p>\n<\/div><\/div>\n\n\n\n

STEP<\/span><\/div>
Rename a Macro<\/div>
\n
\"\"<\/figure>\n<\/div>\n\n\n

To rename a macro you\u2019ve added, go to “Extensions” > “Macros” > “Manage macros.”<\/strong><\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

Here, click on the name of the macro you want to edit and change it to a more descriptive name.<\/p>\n\n\n\n

You can also assign a shortcut key to the macro on the same screen.<\/p>\n\n\n\n

By setting a shortcut key, you can execute the macro even faster.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n

Comparison: Shape Buttons vs. Macro Imports<\/h2>\n\n\n\n
Benefits of Shape Buttons<\/strong><\/span><\/span><\/div>
\n