Go to your project in google console dashboard https://console.developers.google.com
For that in navigation menu select APIs & Services then Library.
Search for Google Drive API, select it and click on ENABLE .
Now search for Google Sheets API enable it as well.
In the navigation menu select IAM & admin and click on Service Accounts
See in image below:
Click on top button CREATE SERVICE ACCOUNT
Add a name and an id and then click CREATE
Give this account 2 roles one of Owner to have full access and one of Service Account Admin.
Save and CONTINUE
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.
Open the (.json) file in any text editor and copy client_email - (e.g: [email protected]) without quotes.
Paste it in email settings in the Iss (account email) field in plugin settings in Bubble editor:
Now copy private_key (the edited one) to plugin settings in Bubble editor:
Before that however the key should be edited first.
After you did that, paste this key in plugin settings, it should look like this:
You're all set to work with a Service Account.