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 .
2. 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
Ownerto 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.