Google Email, show unread email count

[cocarrig]

Google Email, show unread email count

Feature Explanation: A new DAKboard block named 'Email', with direct authorization to the Google Gmail API to show an unread email count. Refresh interval set at 15 minute.

Use rest API to grab the unread emails from an oauth configured account and display number value. https://developers.google.com/gmail/api/reference/rest/v1/users.messages/list https://developers.google.com/gmail/api/reference/rest

Create new block type "Email" from add block Menu with description 'Display your unread email count', icon requires further discussion (square with '1' in it possibly):

• Block to show 'Link Account' button to generate authorization workflow for necessary scopes.

• Once Authorized, list accounts with radio button(fa-regular fa-circle-dot) option to the left to select only one account:

  

• Add 'Rules' Tab, with same options from fetch, to allow the customer to color change on different values

• Add 'formatting' tab with same options as normal text block.

[Dan-Peck]

After some preliminary research, what we may be able to use is:

• First https://developers.google.com/gmail/api/reference/rest/v1/users.labels/list
• Then https://developers.google.com/gmail/api/reference/rest/v1/users.labels/get for "INBOX" or possibly "UNREAD"

[Dan-Peck]

Status Update:

• Development and Pre-Production testing completed.
• Google Verification process is now in progress / Pending.
• UI Designs revised from original description for consistency with other blocks, primarily modeled after "Fetch" block, and will look more like the following:

[Dan-Peck]

Google Verification review has been completed and request has been granted (Internal Ref: 49368).

[Dan-Peck]

SQL Patch Required

• 065

[Dan-Peck]

Merged in @ 8b1628c and added to the queue for upcoming release to the live site.