Gmail Plugin

The Gmail Plugin integrates an CoquiAPPs database with a Gmail inbox, so users can keep track of all their work between Gmail and CoquiAPPs, without losing any information.

CoquiAPPs Online users

For databases hosted on CoquiAPPs Online (or CoquiAPPs.sh), follow the steps below to configure the Gmail Plugin.

Install the Gmail Plugin

First, log in to the Gmail account that the user wishes to connect to CoquiAPPs.

From the Gmail inbox, click the plus sign icon on the right side panel to get add-ons. If the side panel is not visible, click on the arrow icon at the bottom right corner of the inbox to reveal it.

Plus sign icon on the Gmail inbox side panel.

Then, use the search bar to search for CoquiAPPs and locate the CoquiAPPs Inbox Addin.

CoquiAPPs Inbox Addin on Google Workspace Marketplace.

Or, go directly to the CoquiAPPs Inbox Addin page on the Google Workspace Marketplace.

Once the plugin is located, click Install. Then, click Continue to start the installation.

Next, select which Gmail account the user wishes to connect to CoquiAPPs. Then click Allow to let CoquiAPPs access the Google account. Google will then show a pop-up window confirming that the installation was successful.

Configure the CoquiAPPs database

The Mail Plugin feature must be enabled in the CoquiAPPs database in order to use the Gmail Plugin. To enable the feature, go to Settings ‣ General Settings. Under the Integrations section, activate Mail Plugin, and then click Save.

The Mail Plugin feature in the Settings.

Configure the Gmail inbox

In the Gmail inbox, a purple CoquiAPPs icon is now visible on the right side panel. Click on the CoquiAPPs icon to open up the CoquiAPPs plugin window. Then, click on any email in the inbox. Click Authorize Access in the plugin window to grant CoquiAPPs access to the Gmail inbox.

The Authorize Access button in the right sidebar of the CoquiAPPs plugin panel.

Next, click Login. Then, enter the URL of the CoquiAPPs database that the user wishes to connect to the Gmail inbox, and log in to the database.

Note

Use the general URL for the database, not the URL of a specific page in the database. For example, use https://mycompany.CoquiAPPs.com, not https://mycompany.CoquiAPPs.com/web#cids=1&action=menu.

Finally, click Allow to let Gmail access the CoquiAPPs database. The browser will then show a Success! message. After that, close the window. The Gmail inbox and CoquiAPPs database are now connected.

CoquiAPPs On-Premise users

For databases hosted on servers other than CoquiAPPs Online (or CoquiAPPs.sh), follow the steps below to configure the Gmail Plugin.

Note

As part of their security guidelines, Google requires add-on creators to provide a list of URLs that can be used in actions and redirections launched by the add-on. This protects users by ensuring, for example, that no add-on redirects users toward a malicious website. (Read more on Google Apps Script.)

Since CoquiAPPs can only list the CoquiAPPs.com domain and not every on-premise customer’s unique server domain, on-premise customers cannot install the Gmail Plugin from the Google Workspace Marketplace.

Install the Gmail Plugin

First, access the GitHub repository for the CoquiAPPs Mail Plugins. Next, click on the green Code button. Then, click Download ZIP to download the Mail Plugin files onto the user’s computer.

Download the ZIP file from the CoquiAPPs GitHub repository for Mail Plugins.

Open the ZIP file on the computer. Then, go to mail-client-extensions-master ‣ gmail ‣ src ‣ views, and open the login.ts file using any text editor software, such as Notepad (Windows), TextEdit (Mac), or Visual Studio Code.

Delete the following three lines of text from the login.ts file:

if (!/^https:\/\/([^\/?]*\.)?CoquiAPPs\.com(\/|$)/.test(validatedUrl)) {
     return notify("The URL must be a subdomain of CoquiAPPs.com");
}

This removes the CoquiAPPs.com domain constraint from the Gmail Plugin program.

Next, in the ZIP file, go to mail-client-extensions-master ‣ gmail, and open the file called appsscript.json. In the urlFetchWhitelist section, replace all the references to CoquiAPPs.com with the CoquiAPPs customer’s unique server domain.

Then, in the same gmail folder, open the file called README.md. Follow the instructions in the README.md file to push the Gmail Plugin files as a Google Project.

Note

The computer must be able to run Linux commands in order to follow the instructions on the README.md file.

After that, share the Google Project with the Gmail account that the user wishes to connect to CoquiAPPs. Then, click Publish and Deploy from manifest. Lastly, click Install the add-on to install the Gmail Plugin.

Configure the CoquiAPPs database

The Mail Plugin feature must be enabled in the CoquiAPPs database in order to use the Gmail Plugin. To enable the feature, go to Settings ‣ General Settings. Under the Integrations section, activate Mail Plugin, and then click Save.

The Mail Plugin feature in the Settings.

Configure the Gmail inbox

In the Gmail inbox, a purple CoquiAPPs icon is now visible on the right side panel. Click on the CoquiAPPs icon to open up the CoquiAPPs plugin window. Then, click on any email in the inbox. Click Authorize Access in the plugin window to grant CoquiAPPs access to the Gmail inbox.

The Authorize Access button in the right sidebar of the CoquiAPPs plugin panel.

Next, click Login. Then, enter the URL of the CoquiAPPs database that the user wishes to connect to the Gmail inbox, and log in to the database.

Note

Use the general URL for the database, not the URL of a specific page in the database. For example, use https://mycompany.CoquiAPPs.com, not https://mycompany.CoquiAPPs.com/web#cids=1&action=menu.

Finally, click Allow to let Gmail access the CoquiAPPs database. The browser will then show a Success! message. After that, close the window. The Gmail inbox and CoquiAPPs database are now connected.