Overview

This node interacts with the Google Sheets resource to perform operations such as listing Google Sheets or retrieving details of a specific Google Sheet. For the 'List' operation, it fetches a paginated list of Google Sheets, allowing users to specify pagination options like page number and limit on the number of items returned. This is useful for workflows that need to manage or display multiple Google Sheets dynamically, such as automating reporting or data aggregation tasks.

Use Case Examples

1. A user wants to retrieve a list of their Google Sheets to display in a dashboard.
2. An automation workflow fetches Google Sheets in batches to process or analyze data from multiple sheets.

Properties

Output

JSON

• `` - Array of Google Sheets or a single Google Sheet object depending on the operation.

Dependencies

• Requires an API key credential for authentication to access the Google Sheets API via the Marketing Master IO API.

Troubleshooting

• Common issues include invalid or missing API credentials, resulting in authentication errors.
• Incorrect pagination parameters may lead to empty or incomplete results.
• Errors from the API are returned and can be handled by enabling 'Continue On Fail' to avoid workflow interruption.