The most common cause for the error shown in the screenshot is, more often than not, attempting to authenticate using an older version of Templater. Google made a change to the authentication method that their API uses to grant apps access to Google Sheets last year. Due to this change, previous versions of Templater will no longer be able to sign in to Google Sheets.
The first thing I’d try is updating to the latest version of Templater. You can download the installer for Templater Standard (for AE 2022 and above) from this link:
https://assets.dataclay.com/Templater3.zipand Templater Legacy (For AE 2021 and below) here:
https://assets.dataclay.com/Templater3-Legacy.zipHopefully, that’s all we should need to get things up and running, but if you run into further issues, just let us know, and we’ll see where we need to go from there.
Thanks!