While running application using TIBCO Flogo Connector for Google Sheets and Google Docs the below error is observed and the application startup fails.

Error for Google Sheets: googleapi 403 "The caller does not have permission, forbidden
Error for Google Docs: GoogledocsGet failed to get metadata for reason: googleapi: Error 404: File not found: <ResourceID>, notFound

Both the above errors are caused due to insufficient privilege for the service account which is being used in the Google connection referenced in the application. For example, if a Google Doc/Sheet is owned by let say user "xyz@abc.com" and the service account being used in the Google connection is let say 'xyz.iam.gserviceaccount.com' then the access for the Google Doc/Sheet in question needs to be given to the user 'xyz.iam.gserviceaccount.com'. Failing to do so will make the application to throw the above-mentioned error.

NOTE: The details of the service account can be obtained by logging on to the Google IAM console.

Provide access for the required files to the service account being used in the Google connection referenced by the application.