Add Google Sheets加入 Google 試算表

Use SafeFlow日常使用

Add Google Sheets加入 Google 試算表

Spreadsheets in Google Drive stay in sync: SafeFlow checks them for changes every few minutes, and answers follow Google Drive sharing.

存放在 Google Drive 的試算表會自動同步:SafeFlow 每隔數分鐘檢查一次更新,而答案會跟隨 Google Drive 的共用權限。

Admin: set up the sync account (once)管理員:設定同步帳戶(一次)

SafeFlow reads spreadsheets through one read-only Google account, the sync account. Staff share spreadsheets with it as Viewer. The admin chooses it once: send /configure (or /sync-account) and pick one of two options.

SafeFlow 透過一個唯讀 Google 帳戶讀取試算表,稱為「同步帳戶」。員工以「檢視者」權限把試算表共用給它。管理員只需設定一次:發送 /configure(或 /sync-account),然後二選一。

OptionWhen to choose it
A dedicated account in your organizatione.g. data-bot@your-company.com. Internal sharing; works when Workspace blocks external sharing. Sign in with that account, not your own, then send the /confirm command the browser shows.
The SafeFlow service accountNothing to create. It is outside your organization, so Google Workspace must allow sharing with external users.
選項適用情況
公司內的專用帳戶例如 data-bot@your-company.com,屬內部共用,適合不允許對外共用的 Workspace。登入時要用該帳戶(不是你自己的),再發送瀏覽器顯示的 /confirm 指令。
SafeFlow 服務帳戶毋須建立任何帳戶。由於它在公司以外,Google Workspace 必須允許與外部使用者共用。

When it is ready, SafeFlow gives you a message to forward to staff:

設定完成後,SafeFlow 會提供一段訊息,讓你轉發給員工:

Everyone: add your spreadsheets所有人:加入你的試算表

  1. 1

    Share with the sync account共用給同步帳戶

    In Google Drive, share each spreadsheet with the sync account as Viewer, or add it to a Shared Drive as a Viewer member.

    喺 Google Drive 以「檢視者」權限把試算表共用給同步帳戶,或把它加為共用雲端硬碟的檢視者成員。

  2. 2

    Send /configure and sign in發送 /configure 並登入

    Open the link SafeFlow sends and sign in with your own Google account. The link works once and expires in a few minutes; send /status for a new one. Back in WhatsApp, send the /confirm command shown in the browser.

    打開 SafeFlow 傳來的連結,用你自己的 Google 帳戶登入。連結只可用一次,數分鐘後失效;發送 /status 可取得新連結。返回 WhatsApp 後,發送瀏覽器顯示的 /confirm 指令。

  3. 3

    Pick spreadsheets選擇試算表

    Browse all spreadsheets you can open, a Shared Drive, or /search <name>. Reply with row numbers such as 1,3; /page picks a whole page, /all every result. Send /done.

    可瀏覽所有你可開啟的試算表、某個共用雲端硬碟,或用 /search <名稱> 搜尋。回覆列號,例如 1,3;/page 選取整頁,/all 選取全部結果,然後發送 /done。

  4. 4

    Check access and create檢查權限並建立

    SafeFlow checks it can read each one. Fix any listed sharing issue and send /retry, then /create to start the first sync. /status shows progress.

    SafeFlow 會檢查能否讀取每份試算表。如列出共用問題,修正後發送 /retry,再發送 /create 開始首次同步;/status 可查看進度。

Who sees what誰看到甚麼

Answers use only the spreadsheets your own Google account can open right now. If a colleague asks about a sheet they cannot open in Google Drive, SafeFlow says so instead of answering; ask the owner to share it with them.

答案只會使用你本人 Google 帳戶目前可開啟的試算表。同事問及他在 Google Drive 開不到的試算表時,SafeFlow 會說明原因而不會回答;請檔案擁有人把試算表共用給他。