আইনি নীতি ও নির্দেশিকা

Google Sheets & Drive — Amar Sonod

App functionality for Google OAuth verification · Last updated: 1 August 2026

Amar Sonod is a digital certificate platform for Bangladesh Union Parishad and Municipality offices. Google Sheets and Google Drive are an optional office feature — not required for citizens to apply for certificates.

This page explains the product functionality reviewers and users can verify without logging in. Live connect controls are available after office login at /settings/google.

How the feature works

1. Sign in to Amar Sonod as office staff
Authorized Union Parishad / Municipality staff open Amar Sonod and go to Settings → Google Sheets ও Drive.
2. Connect Google (OAuth consent)
Staff choose Connect Google account. Google shows the Amar Sonod consent screen with only the scopes listed below. After Allow, Amar Sonod returns to Settings and shows the connected email.
3. Create or select Sheet and Drive folder
Amar Sonod can create a spreadsheet and Drive folder owned by that Google account, or staff can paste their own spreadsheet/folder IDs.
4. Apply → Sheet row
When a certificate application is submitted, Amar Sonod appends a register row (track ID, certificate type, citizen info, status) to the office Sheet.
5. Approve → Sheet update + PDF in Drive
When an application is approved, Amar Sonod updates the Sheet (including fee data from cash register when available) and uploads Bangla/English certificate PDF copies into the Drive folder.

Minimum Google scopes we request

Amar Sonod requests only these scopes — the minimum needed for the features above. We do not request Gmail, full Drive, or Contacts access.

https://www.googleapis.com/auth/spreadsheets
Create/update the office certificate register spreadsheet and append or update application rows.
https://www.googleapis.com/auth/drive.file
Create or use only files/folders that Amar Sonod creates (or the user selects). Upload approved certificate PDFs. No full Drive access.
https://www.googleapis.com/auth/userinfo.email
Show which Google account is connected in Settings.
openid
Standard OpenID Connect identity for the OAuth sign-in flow.

Sheets

Office certificate register rows for apply and approve events.

Drive (file)

Approved certificate PDFs in Amar Sonod–created or user-chosen folders only.

Disconnect anytime

From Amar Sonod Settings or Google Account → Third-party access.

Appropriate data access & Limited Use

Google user data obtained through these scopes is used only to provide the Sheets register and Drive PDF features described here. We do not use Google user data for ads, sell it, or transfer it to unrelated third parties. See our Privacy Policy for full disclosure.

বাংলা: অফিস স্টাফ চাইলে Google সংযুক্ত করে সনদ রেজিস্টার Sheet-এ এবং অনুমোদিত PDF Drive-এ রাখতে পারেন। নাগরিক আবেদনের জন্য এটি বাধ্যতামূলক নয়।

How the feature works

1. Sign in to Amar Sonod as office staff

Authorized Union Parishad / Municipality staff open Amar Sonod and go to Settings → Google Sheets ও Drive.

2. Connect Google (OAuth consent)

Staff choose Connect Google account. Google shows the Amar Sonod consent screen with only the scopes listed below. After Allow, Amar Sonod returns to Settings and shows the connected email.

3. Create or select Sheet and Drive folder

Amar Sonod can create a spreadsheet and Drive folder owned by that Google account, or staff can paste their own spreadsheet/folder IDs.

4. Apply → Sheet row

When a certificate application is submitted, Amar Sonod appends a register row (track ID, certificate type, citizen info, status) to the office Sheet.

5. Approve → Sheet update + PDF in Drive

When an application is approved, Amar Sonod updates the Sheet (including fee data from cash register when available) and uploads Bangla/English certificate PDF copies into the Drive folder.

Minimum Google scopes we request

Amar Sonod requests only these scopes — the minimum needed for the features above. We do not request Gmail, full Drive, or Contacts access.

https://www.googleapis.com/auth/spreadsheets

Create/update the office certificate register spreadsheet and append or update application rows.

https://www.googleapis.com/auth/drive.file

Create or use only files/folders that Amar Sonod creates (or the user selects). Upload approved certificate PDFs. No full Drive access.

https://www.googleapis.com/auth/userinfo.email

Show which Google account is connected in Settings.

openid

Standard OpenID Connect identity for the OAuth sign-in flow.