In this guide, we will walk you through how to integrate Google Apps Script with Yoom.

☝️ Note:

Before starting, make sure you have administrative privileges on the Google Cloud Platform!

Log in to Google Cloud Platform and create a new project.

Set the project name and choose any option for the organization and location.

Once the project is created, select APIs & Services > Library from the left side menu.

In the API library, search for "Apps Script API" and select it.

On the Apps Script API page, click the ENABLE button to enable the Apps Script API.

Next, open OAuth consent screen from the side menu.

Open Audience from the side menu and select “Internal” under User Type, and click Create if the button appears.

(This will limit the use to your organization only.)

Open Branding from the side menu and configure each item as follows:

Click the Save button at the bottom of the page.

Open Data Access from the side menu and click “Add or remove scopes” to configure the scope information.

Check the following scopes based on the services you will use with Google Apps Script:

After setting the scopes, scroll down to click Update.

The selected scopes will be displayed. Once added, click Save.

Next, go to the Credentials page from the side menu.

From the top, click “+ Create credentials” and select “OAuth client ID”.

On the next page, configure the following settings and click Create:

After creation, you will be shown the Client ID and Client Secret.

Be sure to copy these, as you’ll need them later when integrating with Yoom.

⚠️ Important:

Important: The Client ID and Client Secret are sensitive information (like passwords).

This completes the settings on the Google Cloud Platform. 🎉

Now, let’s move on to integrating Yoom with Google Apps Script.

Log in to Yoom and open the My Apps registration screen for Google Apps Script.

On the next screen, click Sign in with Google.

Enter the Client ID, Client Secret (from the Google Cloud Platform authentication settings), and the scopes you selected on the OAuth consent screen. Then, click Register.

In the Scopes field, enter the scopes in the following format. Be sure to leave a space between each scope:

After you enter the information and click Add, you will be directed to a new screen. Select the Google account you integrated and keep clicking Allow until the process is complete.

🎉 Congratulations! Your Google Apps Script integration is now complete!