Open Activity
The Open activity enables users to access a specified Google Sheet file. This activity is essential for initiating interactions with Google Sheets, allowing subsequent operations to be performed on the document.
| Field | Description | Requirement |
|---|---|---|
| Google sheet name | The reference name of the Google Sheet which has already been opened or created is chosen in the dropdown. | Required |
| Google sheet url address | URL address of the page to be accessed. | Required |
| Credential file | Pre-authorized user credentials. | Required |
Action Types & Examples
Google Sheet Name
- Format: String
- Example Result: "newGoogleSheet"
Implementation Examples
Field Setup - Google Sheet Name: newGoogleSheet - Google Sheet URL Address: https://docs.google.com/spreadsheets/d/1A2B3C4D5E6F7G8H9I0J1K2L3M4N5O6P7Q8R9S0T/edit#gid=0 - Credential File: serviceAccountKey.json
Technical Notes
Ensure that the provided Google Sheet URL is accessible and that the credential file has the necessary permissions to access the sheet. Incorrect credentials or an invalid URL will prevent the activity from executing successfully. It is recommended to test credentials and URL accessibility independently before activity execution.