Google Sheets — Close
Google Sheets — Close
Section titled “Google Sheets — Close”Type: googlesheets-close · Package: Google Sheets Activities v1.0.5 · Output: —
Closes a Google Sheets session opened with Google Sheets — Open and releases its resources. Needed when you open the session without body.
How it works
Section titled “How it works”Releases the session given in session (or the inherited one, inside a body). Afterwards that session can no longer be used: any activity that receives it fails. It does not change the spreadsheet: every write was already saved in Google when it ran.
Required parameters
Section titled “Required parameters”None.
Optional parameters
Section titled “Optional parameters”| Parameter | Type | Default | Description |
|---|---|---|---|
session | ZoanGoogleSheetsSession | — | Session returned by Google Sheets — Open. Inside a body the inherited one is used. |
Output
Section titled “Output”This activity does not return a value.
Common errors
Section titled “Common errors”| Message | Cause and fix |
|---|---|
'session' is required and must be a Google Sheets session. | No session was given (or it is not a Google Sheets session) and the activity is not inside an Open body. |
Example
Section titled “Example”Google Sheets — Open credential = credential("google-operations") spreadsheetId = id → output: bookGoogle Sheets — Read sheet session = book sheet = "Data" → output: dataGoogle Sheets — Close session = bookRelated activities
Section titled “Related activities”- Google Sheets — Open — open the session.