OAuth IMAP

This plugin imports received email from a specified email account using OAuth authentication. You can manage email responses centrally in a kintone app. Attachments are imported too, so you can also find files by date received or sender.

See the features

By using this product, you are deemed to have agreed to the Terms of Service.

How to install ＋

SETTING

Setup

Specify the conditions

First, specify the users who can run the plugin and the execute button.

Settings

Authorized users: To allow execution based on the logged-in user, or the departments and groups the user belongs to, specify who is allowed.
Execute Button Label: Enter the label of the button that imports email.
Execution Confirmation Dialog Message: Enter the message shown before the import runs.
List View where buttons can be placed: Specify the views in which the execute button is shown.

Specify the settings

Next, specify the OAuth credentials and the fields in which the imported email is saved.

This plugin receives email using a refresh token obtained from a client ID and client secret. You need to prepare these for each service in advance.

Google Microsoft

How to get a client ID and client secret ＋

OAuth settings

Client ID: Enter the client ID you obtained in advance.
Client Secret: Enter the client secret you obtained in advance.
Username (Email Address): Enter the email address of the account from which email is imported. Email received by this account is imported.
Service Name: Select the service you use (GMail or Exchange Online).

Email Storage Settings

UID: Specify the field in which the email ID is saved.
Sender: Specify the field in which the sender is saved.
CC: Specify the field in which CC is saved. CC may contain multiple email addresses, so specify a text field.
Received DateTime: Specify the field in which the date and time received is saved.
Subject: Specify the field in which the subject is saved.
Body: Specify the field in which the body is saved.
Attachment Field: Specify the field in which the attachments are saved.

Get the refresh token

After entering the client ID and client secret, click "Get the refresh token" and get the refresh token on the authentication screen that appears. When it is obtained, the Refresh Token field shows that authentication succeeded.

On the authentication screen, log in with the account of the email address entered in "Username (Email Address)". If you log in with a different account, the refresh token of that account is obtained.

Google Microsoft

Notes on getting the refresh token ＋ Using multiple email accounts ＋

Notes on getting the refresh token ＋ Authenticating with an account other than the administrator account ＋ Using multiple email accounts ＋

How to use the tabs ＋

HOW TO USE

How to use

Show the execute button

When you open the view specified on the settings screen, the button that imports email appears.

Specify the period and sender to import

Click the button to show the screen for entering the period and sender to import. The default period is 0:00 to 23:59 today.

If you leave the sender blank, all email in the specified period is imported.

Import email

Click "OK" to import the email and save it in the fields specified on the settings screen.

The plugin does not check whether email has already been imported. If you import the same period again, the same email is registered again. Selecting "Prohibit duplicate values" for the email ID field prevents duplicates, but if already imported email is included, an error occurs and the import stops. Email is registered 100 at a time, so the records registered before the error remain.

About the plugin execution order ＋