# 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 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