FormKiQ Module Google Sheets

Google Sheets Module for FormKiQ

Configuring Google Permissions

The plugin require permissions to Google Sheets.

Generate Google Private Key Authorization

• Visit Google Cloud Platform

• Click IAM & Admin and then Service Accounts

• Click Create Service Account

• Under Service account details, enter a Service account name and click DONE.

• Click the Create key to generate a private key

• Click Create and save private key to file

• Visit Google Drive and create a new Google Sheets

• Click Share and enter the gserviceaccount.com email address from the Service account details

Store Private Key in Parameter Store

To keep the privatekey secret. The plugin uses the AWS Parameter Store to the private key.

Save your private key to a file named privateKey.json and use the AWS CLI command below to store the privatekey in the parameter store.

NOTE: replace with the value used in your FormKiQ installation.

aws ssm put-parameter --overwrite --type SecureString --name '/formkiq/<AppEnvironment>/auth/google/spreadsheets' --value "$(cat privateKey.json)"