# Google Drive - New CSV file trigger (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
Input field | 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
Input field | Description |
---|---|
Events | Details about the new CSV file in Google Drive. Contains the following output fields:
|
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.
|
Sharing user | The user who shared the file with the requesting user, if applicable. Each user contains the following output fields:
|
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:
|
Last modifying user | The last user to modify the file. Each user contains the following output fields:
|
Shared | Indicates whether the file has been shared. This field is not populated for shared drive files. |
Owned by me | Indicates whether the user owns the file. This field isn't populated for shared drive files. |
Viewers can copy content | Indicates whether users with View access can copy the file contents. |
Writers can share | Indicates 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 (opens new window) 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: 3/10/2025, 6:11:59 PM