Obtaining Google Service Account Keys

How to get service account keys

Go to your project in google console dashboard

1. Enable Drive API and Sheets API

For that in navigation menu select APIs & Services then Library.
APIs & Services > Library
  1. 1.
    Search for Google Drive API, select it and click on ENABLE .
2. Now search for Google Sheets API enable it as well.
Note: For other APIs (e.g. Calendar, Maps etc.) please enable those APIs in the Google Cloud Platform

2. Create service account

In the navigation menu select IAM & admin and click on Service Accounts. See in image below:
APIs & Services > Service Accounts
  1. 1.
    Click on top button CREATE SERVICE ACCOUNT;
  2. 2.
    Add a name and an id and then click CREATE;
  3. 3.
    Give this account 2 roles one of Ownerto have full access and one of Service Account Admin;
  4. 4.
    Save and CONTINUE.

3. Creating Keys

On next step scroll to the bottom and click on CREATE KEY and select JSON type of key and then click CREATE, a file with key will be downloaded, it will be in format .JSON.
Add new JSON key
Open the (.json) file in any text editor and copy client_email - (e.g: [email protected]) without quotes.
Copy the client_email from the JSON key

4. Adding the keys in Bubble Google Sheets plugin

Paste it in email settings in the Iss (account email) field in plugin settings in Bubble editor:
Iss (account email)

This next step is very important so be careful!

Now copy private_key (the edited one) to plugin settings in Bubble editor:
Private key
Before that however the key should be edited first.
You will need to remove only all the "\n" and "=" characters from it and replace them with <-Enter.
Google's instructions for the private_key formatting
After you did that, paste this key in plugin settings, it should look like this:
private_key example from the plugin demo page
You're all set to work with a Service Account.
Last modified 3mo ago