Google Sheets Activities

Version: 1.0.0  ·  ID: zoan-packages-googlesheets  ·  Author: Zoan Software

The Google Sheets package reads and writes Google Sheets directly to the cloud (via its API). It’s the equivalent of Excel for Google Docs - ideal when data lives in a shared Google Drive sheet that is updated by multiple people or systems.

Concept 1: Google OAuth connection

Unlike Excel (which opens a local file), Google Sheets accesses a sheet in the cloud, so you need authorization. That authorization is configured once on Zoan Cloud as a Google OAuth connection, and then references it by name.

What you need	Where to get it
OAuth connection	It is configured in Zoan Cloud (you authorize access to your Google account). It references it by name in the credential parameter.
Sheet ID (spreadsheetId)	It’s in the URL of the sheet: docs.google.com/spreadsheets/d/{ID}/edit — copy the {ID} part.

Alternative: service account

Besides the OAuth connection, Google Sheets — Open supports authenticating with a service account key (parameter authType = service-account): no user consent required, ideal for unattended runs. The key is stored as a credential and the sheet must be shared with the service account’s email.

Concept 2: the session

All operations work on a session that you open with Google Sheets — Open (passing the connection and ID) and share with the other activities:

• With body: activities inside inherit the session; When finished it closes itself.
• Without body: You save the session in a variable and close it with Google Sheets — Close.

Google Sheets — Open   credential = "google-clinica"   spreadsheetId = = idHoja
 └─ body:
      Google Sheets — Read sheet   sheet = "Citas"   has-headers = true   → output: citas
      ... procesar ...

A1 notation and headings

• Cells and ranges use A1 notation: A1, B3, A1:E10, A:E (full columns).
• Sheets: by name ("Citas"); if you omit it, use the first/active one.
• has-headers: In reads, if you set it to true, the first row is treated as headers and the result is a DataTable; if false (default), returns a list of raw rows.

Scriptures allow formulas

When you type, the values are interpreted as USER_ENTERED: If you type =SUM(A1:A10), Google Sheets saves it as formula, just as if you typed it.

Activities

Session

Activity	Type	Output	What it does
Google Sheets — Open	googlesheets-open	ZoanGoogleSheetsSession	Open an authenticated session with a sheet
Google Sheets — Close	googlesheets-close	—	Sign out

Read

Activity	Type	Output	What it does
Read sheet	googlesheets-read-sheet	DataTable / List	Read a whole page
Read range	googlesheets-read-range	DataTable / List	Read a range
Read cell	googlesheets-read-cell	object	Read a cell
Used range	googlesheets-get-used-range	Dictionary	Dimensions of the data area
Get sheet names	googlesheets-get-sheet-names	List	Leaf names
Find cell	googlesheets-find-cell	Dictionary	Find a cell by value
Find row	googlesheets-find-row	object	Find a row by column value

Write

Activity	Type	Output	What it does
Write sheet	googlesheets-write-sheet	—	Write data from A1
Write range	googlesheets-write-range	—	Write in a range
Write cell	googlesheets-write-cell	—	Write a cell
Append rows	googlesheets-append	—	Add rows to the end
Clear range	googlesheets-clear-range	—	Clear the contents of a range

Next steps

• Google Sheets — Open — open a sheet.
• Read sheet — read data to a DataTable.
• Excel — the equivalent for local .xlsx files.