Overview

This node interacts with Google Sheets via the Marketing Master IO API. Specifically, the 'Get' operation retrieves details of a specific Google Sheet by its ID. This is useful for workflows that need to fetch metadata or information about a particular Google Sheet for further processing or integration.

Use Case Examples

1. Retrieve details of a Google Sheet by providing its Sheet ID to automate reporting workflows.
2. Fetch Google Sheet metadata to validate or log sheet information before performing data operations.

Properties

Output

JSON

• id - The unique identifier of the Google Sheet.
• name - The name of the Google Sheet.
• createdTime - The creation timestamp of the Google Sheet.
• modifiedTime - The last modified timestamp of the Google Sheet.
• otherProperties - Additional metadata properties returned by the API about the Google Sheet.

Dependencies

• Requires an API key credential for the Marketing Master IO API to authenticate requests.

Troubleshooting

• Common issues include providing an invalid or empty Google Sheet ID, which will result in an error from the API indicating the sheet could not be found.
• API authentication errors may occur if the API key credential is missing or invalid, resulting in authorization failures.
• Network or connectivity issues can cause request failures; ensure the node has internet access and the API endpoint is reachable.