Configuring Filemaker 2023 to send SMTP Using OAUTH and Google

Filemaker 2023 is here, and now supports OAuth 2.0 as the authentication mechanism for the Send Mail script step. Here's how to get things setup to leverage this.


• Filemaker 2023

• A Google Admin Console login for your Google Workspace Account

• Rudimentary understanding of JSON.

Step 1 - Create Google Project

Log into your Google Cloud Console and click the Project Selector at the top of the screen, and then choose 'New Project'

You can either use the suggested values, or give your Project a more meaningful name:

Step 2 - Create Service Account within your Project:

Click Create, and then skip through steps 2 and 3 (you don't need to set anything), and click DONE.

Step 3 - Generate Key

Select the 3 dots to right hand side of your new service account, and the choose 'Manage Keys':

Choose Add Key > Create New Key

Choose JSON as the key type:

Your browser will download the JSON to your default download location, and from that JSON, you'll need the 'client_id' and 'private_key' strings:

Note that the private_key element will likely have \n line breaks if you simply view in a text editor, so it's important to use something like JSONGetElement to extract the key in a suitable format (e.g with line breaks intact)

That's it for setting up the Project, and Service Account, now we just need to grant the service account permission to use Gmail:

Step 4 - Implement Domain-Wide Delegation

In the Google Admin Console (note this is different to he Google Cloud Console), select Security > Access and data control > API Controls > Domain-wide Delegation:

Click Add New, andhten enter in the Client ID from the JSON payload above, and then add this to the scopes:,

That's pretty much it for setting up the Google side of things - you may find you need to wait a few minutes for the Domain Wide Delegation to kick in though.

Step 5 - Configure Send Email script step in Filemaker

Now all you need to do is populate the new options in the Send Mail (oAuth) config screen:

oAuth 2.0 Provider isGoogle

'Name, E-Mail Address' and Reply-To Address are the bits for the email your sending, the oAuth 2.0 Information should be populated as below:

And that's it!

If you have any queries, or would rather have Glenavon Technology handle your Email integrations, please drop us a line