# Google Drive trigger - New CSV file (batch)
This trigger checks a specified folder for new CSV files every 5 minutes and processes the CSV lines in batches of 1000 by default. The maximum batch size is 1000.
The trigger does not pick up newly uploaded versions of the same file.
Google Drive New CSV file trigger
# Input fields
Field name | Description |
---|---|
When first started, this recipe should pick up events from | When you start the recipe for the first time, it picks up activity from the specified date and time. Defaults to fetching activity an hour ago if left blank. After the recipe has been run or tested, the value cannot be changed. Learn more about this input field. |
Parent folder | The parent folder where the file is placed. Select a folder from the picklist or enter the folder ID directly. You can find the folder ID at the end of the folder URL. If entering the folder ID for a shared drive (formerly Team Drive), this value must be in the form folder_id/shared_drive_id (for example, 1fm6iCMYrN7roZZ-ynpVFRTVq9mellrWp/0AB6ZFCw3XdamUk9PAA ).The uploaded file is saved in My Drive if this field is not specified. |
Sample CSV file | Required for Workato to understand the data columns in your files. If you do not have a sample CSV file to upload, enter column names manually, with each name on a new line. This is used to build output column fields. |
Column delimiter | The character used to separate column values within each CSV line. |
Contains header line? | Set to Yes if the first CSV line is a header line containing column names that must be excluded in the output. |
Batch size | Number of CSV rows per batch. Instead of reading rows one by one, Workato reads a batch of CSV rows at the same time to increase throughput. Refer to Batch processing for more information. Defaults to 1000 , which is the maximum batch size. |
Expected encoding | The expected file encoding type. Defaults to UTF-8 , and typically doesn't need to be changed. |
# Output fields
- Events
- Details about the new CSV file in Google Drive. Contains the following output fields:
- ID
- ID of the file.
- Name
- Name of the file.
- MIME type
- MIME type of the file, as stated in Google Drive's documentation.
- Description
- Description of the file.
- Starred
- Whether you have starred the file.
- Trashed
- Whether the file has been trashed, either explicitly or from a trashed parent folder. Only the owner can trash a file. Other users cannot see files in the owner's trash.
- Explicitly trashed
- Whether the file has been explicitly trashed, as opposed to recursively trashed from a parent folder (for example, when you trash an entire parent folder).
- Parents
- List of parent folders containing the file. Contains the following output fields, in addition to List size and List index:
- ID
- ID of the parent folder.
- Version
- A version number for the file. This reflects every change made to the file on the server, even those not visible to the user.
- Web content link
- A link for downloading the content of the file in a browser. This is only available for files with binary content in Google Drive.
- Web view link
- A link for opening the file in a relevant Google editor or viewer in a browser.
- Icon link
- A static, unauthenticated link to the file's icon.
- Thumbnail link
- A short-lived link to the file's thumbnail, if available. Typically lasts on the order of hours. Only populated when the requesting app can access the file's content.
- Viewed by me
- Whether the file has been viewed by this user.
- Viewed by me time
- The last time the file was viewed by this user (RFC 3339 date-time).
- Created time
- The time at which the file was created (RFC 3339 date-time).
- Modified time
- The last time the file was modified by anyone (RFC 3339 date-time).
- Modified by me time
- The last time the file was modified by this user (RFC 3339 date-time).
- Sharing user
- The user who shared the file with the requesting user, if applicable. Each user contains the following output fields:
- Display name
- A plain text displayable name for this user.
- Email address
- The email address of the user. This may not be present in certain contexts if the user has not made their email address visible to the requester.
- Permission ID
- The user's ID as visible in Permission resources.
- Photo link
- A link to the user's profile photo, if available.
- Me
- Whether this user is the requesting user.
- Owners
- The list of owners of the file. Only certain legacy files can have more than one owner. This field is not populated for shared drive files. Each owner contains the following fields, in addition to List size and List index:
- Display name
- A plain text displayable name for this user.
- Email address
- The email address of the user. This may not be present in certain contexts if the user has not made their email address visible to the requester.
- Permission ID
- The user's ID as visible in Permission resources.
- Photo link
- A link to the user's profile photo, if available.
- Me
- Whether this user is the requesting user.
- Last modifying user
- The last user to modify the file. Each user contains the following output fields:
- Display name
- A plain text displayable name for this user.
- Email address
- The email address of the user. This may not be present in certain contexts if the user has not made their email address visible to the requester.
- Permission ID
- The user's ID as visible in Permission resources.
- Photo link
- A link to the user's profile photo, if available.
- Me
- Whether this user is the requesting user.
- Shared
- Whether the file has been shared. This field is not populated for shared drive files.
- Owned by me
- Whether the user owns the file. This field is not populated for shared drive files.
- Viewers can copy content
- Whether users with View access can copy the file contents.
- Writers can share
- Whether users with Edit access can share the file. This field is not populated for shared drive files.
- Original filename
- The original filename of the file if available, or else the original value of the name field. This is only available for files with binary content in Google Drive.
- Full file extension
- The full file extension extracted from the name field. May contain multiple concatenated extensions (for example,
tar.gz
). This is only available for files with binary content in Google Drive. It is automatically updated when the name field changes, but it is not cleared if the new name does not contain a valid extension. - File extension
- The final component of the full file extension (for example,
gz
). This is only available for files with binary content in Google Drive. - MD5 checksum
- The MD5 checksum for the content of the file. This is only applicable to files with binary content in Google Drive.
- Size
- The size of the file's content in bytes. This is only applicable to files with binary content in Google Drive.
- Quota bytes used
- The number of storage quota bytes used by the file. This includes the head revision as well as previous revisions with Keep Forever enabled.
- Head revision ID
- The ID of the file's most current version. This is only available for files with binary content in Google Drive.
Last updated: 8/28/2024, 8:43:06 PM