Can someone walk me through how I would go about configuring a Gmail data connection to pull in data via a service account?
There are two well-documented guides on the Community Registry, with pictures and instructions.
For Google Workspace accounts (admin access required) - https://github.com/palantir/aip-community-registry/tree/develop/GSuite_Send_Email_Compute_Module
For personal Google accounts - https://github.com/palantir/aip-community-registry/tree/develop/Personal%20Gmail%20and%20Calendar%20Connector
Base functionality is sending emails, but by modifying the code in the compute module and playing around with the API, you can do loads.