On this Page
Table of Contents | ||||
---|---|---|---|---|
|
Overview
You can use this Snap to browse the given Google Drive folder and list the spreadsheet names matching the provided name filter. It also displays the worksheets within each spreadsheet.
Note | ||||
---|---|---|---|---|
| ||||
Enhances the Google Spreadsheet Snap Pack by migrating from v3 to v4 API as Google announces sunsetting the v3 API on June 8, 2021. For more information, see Migrating Google Spreadsheet Sheets Pipelines from V3 to V4. |
Read
Description:
This Snap browses the given Google Drive folder and lists the spreadsheet names matching the provided name filter. It also displays worksheets within each spreadsheet.
- Expected upstream Snaps: [None]
- Expected downstream Snaps: File Writer or any Transform Snap.
- Expected input: The name filter to select the desired spreadsheets.
- Expected output: List of spreadsheets available in the provided folder matching the provided name filter. Provides Sheet ID, Sheet name, and Worksheets within.
[None]
Prerequisites
None.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
Multiexcerpt macro | ||
---|---|---|
|
|
|
|
- You will find the Snap fetching all worksheets in the output, regardless of them being either hidden or protected.
Known Issue
:Multiexcerpt macro | ||
---|---|---|
| ||
A long-standing bug in the Google Sheets endpoint does not allow the use of a colon ':' in the worksheet names; hence, these inputs are not supported. |
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. This Snap uses Google Basic Auth Account (Username and Password) or Google OAuth Account (Client ID, Client Secret, and so on) or Google Dynamic OAuth Account (Access Token). See Configuring Google Sheets Accounts for more information.
Input | This Snap has at most one document input view. |
---|---|
Output | This Snap has at most one document output view. |
Error | This Snap has at most one document error view and produces zero or more documents in the view. |
Settings
Label
Required. TheSnap Input and Output
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Output | Document |
|
| The name filter to select the desired spreadsheets. |
Input | Document |
|
| List of spreadsheets available in the provided folder matching the provided name filter. Provides Sheet ID, Sheet name, and Worksheets within. |
Snap Settings
Field Name | Field Dependency | Description | |
---|---|---|---|
Label* | N/A | Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your |
Pipeline. Default value: Spreadsheets Browser | |
Name filter |
---|
N/A | Specify the GLOB pattern to look for spreadsheets having |
name pattern. Default value |
: None | |
Number of |
---|
Retries | N/A | Specify the maximum number of retry attempts that the Snap must make to read the worksheet. Default value: 3 | |
---|---|---|---|
Retry |
Interval (seconds) | N/A | Specify the time interval in seconds for each retry attempt. Default value: 1 |
---|
Example: 2 | |
Snap Execution |
---|
N/A |
|
Examples
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|