3️Google Sheets

Create a service account key

1. Activate the Google Sheets API of your Google Cloud project.

2. From the left panel, select APIs & Services > Credentials.

3. To establish a new service account, select CREATE CREDENTIALS > Service account.

4. Get a service account key:

   1. Click the Email of the service account.

   2. Click KEYS > ADD KEY > Create new key.

   3. Select JSON as the key type.

   4. Click CREATE to download it.

Ensure to securely store the downloaded service account key in JSON format on your device. It's crucial to keep it in a safe location.

Share your Google sheet

Return to Google Sheets, then proceed with the following steps to share your sheet using the service account key.

1. Open the JSON file of the key.

2. Retrieve the value of client_email, which serves as an identity utilized for access management of your sheet.

3. Click on the "Share" button located at the top right corner, then paste the copied client_email value to add a member with access.

4. Select Editor as the role and click Send.

Once you receive the notification "Access updated", it indicates that you have successfully authorized this service account to edit your sheet.

Connect Google Sheets to QuickDEV

Follow the steps below:

1. Click Data Sources on QuickDEV homepage.

2. Click on "New data source" located in the upper right corner. Please note that this permission is restricted to workspace admins and developers.

3. Select Database > Google Sheets as the type.

4. Set its name and paste the whole content in the JSON flie of the key to Service Account.

5. Click Save, and you can check it in your data source library later.

The available methods are Read Data, Append Row, Update Row, and Clear Row.