Setting the administrator credentials
A Google Sheets target requires two sets of administrative credentials. One must use a system password. For the first administrator, add the following:
ID Full path to the .P12 encryption file (the C: drive is recommended)
Password The private key’s password given with the .P12 file.
For the second administrator, add the following:
ID The service account ID referred to in Configure Google Sheets API credentials (including the "@<domain>")
Password Any value (unused) System password Must be checked
The target should now be able to connect and interact with the Google Sheets API.