Publish A Google Sheets Macro To Your Domain Step-by-Step

In this post I’m going to give a screenshot walk-through to publish a macro in your Google Apps (G Suite) domain.

These screenshots are current as of 11/7/2016.

PREREQUISITE #1: Accept the Chrome Web Store TOS

First things first. If you have NEVER published a macro in your G Suite domain space before, you must do this step.

Navigate to and accept the TOS.

Failure to do this step will result in this very non-descriptive error message when you attempt to publish your add-on: “Chrome Web Store system error, please try again later.”

It is only necessary to complete this step one time in your domain.

Google Chrome Web Store Developer Agreement

Prerequisite #2: Retrieve your “Project key”

Navigate to File -> Project Properties and copy your Project Key


PREREQUISITE #3: Enable Google Apps Marketplace SDK

Navigate to to enable the Google Apps Marketplace SDK.

It is only necessary to complete this step one time in your domain.


Click “Enable” at top


PREREQUISITE #4: Set web store icon image file. Sizes 128×128 and 32×32.

Even though there is no visual indication that the field is required, if you try to submit the form without these fields populated, you will get notified that they are required. Whether you are creating a macro for internal use or the wide world, the presentation in the chrome web store is the same. Because of this, it is required to add an icon image for your add-on.

Open the Configuration tab of the Google Apps Marketplace SDK.


PREREQUISITE #5: Add project key

Since this macro is for a Sheet, I have the “Sheets Add-On Extension” option set. Paste your Project Key here.

Once all the required fields are satisfied, the “Save Changes” button turns dark blue indicating that it is ready to save.


STEP 1: Register your project

Finally, if the above steps have been completed, you are ready to publish your macro.

From your script at, Publish menu -> Register  in Chrome Store. In the subsequent window, click “Register Web App”


STEP 2: Perform first upload of your script to web store.

Menu: Publish -> Deploy as Web add-on

Assuming the previous steps were completed, clicking “Create web store draft” will redirect your browser to the Edit Item page of your add-on in the Chrome web store*

*You can easily get back to the edit menu by re-launching the “Deploy as Web add-on” menu. At the bottom of the window there will be an “Edit” link to the item in the chrome web store.


STEP 3: Configure web add-on options

There are several requirements that must be configured before the add-on can be made available in your domain:

  • Set an icon image (different from the web store icon we set previously)
  • A 1200×800 or 640×400 screenshot.
  • A 440×280 small tile image
  • Set Category
  • Set Language
  • Visibility options
    • Set value to “Unlisted” or “Private” so it will be internal use only.

Assuming you are ready for prime time, click “Publish changes” in the lower right corner.




After clicking “Publish”, you are done.

As the end-user:

Open a blank Sheet.

Add-ons menu -> Get Add-ons

Change the drop-down menu to “For [your domain name]”



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s