Google Drive + Smartsheet

Copy files in Google Drive for each updated row in Smartsheet

When an update occurs in your Smartsheet rows, this workflow ensures your files in Google Drive get copied promptly. This automation seamlessly connects Smartsheet and Google Drive, saving you the hassle of manual copying. It's an ideal solution for those who want to maintain consistency and efficiency in their document updates.

When this happens...
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
TriggerInstant
automatically do this!
Copy File
Create a copy of the specified file.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
- Select a ReportRequired
Trigger
Polling
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write

- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write

- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet IDRequired
- Row IDRequired
Action
Search
- Drive
Trigger
Polling
Try It
- Drive
- Folder
Trigger
Polling
Try It
- FileRequired
- Convert to Document?
- File Name
- Drive
- Folder
Action
Write
- Drive
- Folder
- FileRequired
- Export FormatRequired
Action
Write
- Drive
- Parent Folder
- Folder NameRequired
Action
Write
- Drive
- Folder
- File NameRequired
- File ContentRequired
- Convert to Document?
Action
Write
- Drive
- Folder
- File to ReplaceRequired
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Write
- Drive
- File IdRequired
- Sharing PreferenceRequired
- Organization Domain
Action
Write
- Drive
- Copy
- Folder
- File
- Name
- Description
- Starred
- Folder Color (RGB)
- Custom Properties
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Retrieve Files from Google Drive
This action sends a GET request to the Google Drive API to retrieve a list of files based on specific query parameters.
Action
Write
- Drive
- Folder
- File IDRequired
Action
Search
- Folder NameRequired
- Search Type
- Drive
- Parent Folder
Action
Search
- Folder NameRequired
- Search Type
- Drive
- Parent Folder
Action
Search or write

- Choose a SheetRequired
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- SheetRequired
- ColumnRequired
- Parent Row
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet IDRequired
- QueryRequired
Action
Search
- Drive
- Folder
- Include Subfolders?
- Subfolder Depth Limit
- Include Deleted Files?
Trigger
Polling
Try It
- Drive
- Folder
- Include Deleted
Trigger
Polling
Try It
- Drive
- Folder
- FileRequired
- Confirm deletionRequired
Action
Write
- Drive
- Folder
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Write
- FileRequired
- Drive
- FolderRequired
Action
Write
- Drive
- Folder
- FileRequired
- Email Address
- Permission ID
Action
Write
- Shared Drive NameRequired
- Theme ID
- Color RGB
- Background Image File ID
Action
Write
- FileRequired
- Drive
- Folder
Action
Write
- Drive
- Folder
- File to Replace
- File/Folder Name
- Rename Folder?
- Extension Copy
Action
Write
Delete File
This action will delete a file in Google Drive. You will need to provide the file ID.
Action
Write
- Drive
- File or Folder IDRequired
Action
Search
- FilenameRequired
- Search Type
- Drive
- Folder
- File Types
Action
Search
- FilenameRequired
- Search Type
- Drive
- Folder
- File Types
- FileRequired
- Convert to Document?
- File Name
- File Extension
- Idempotency Key
Action
Search or write

About Google Drive

Google Drive is Google's file sync app that lets you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.

Learn more

Related categories

Similar apps

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Related categories

Spreadsheets

Similar apps

Related Zap Templates

Add new Google Drive files as attachments to Smartsheet rows

Google Drive + Smartsheet

Copy files in Google Drive for each updated row in Smartsheet

Get Reports

New Comment

New or Updated Report Row

Create Workspace

Add Discussion to Row

Copy Folder

Copy Workspace

Move Row

Create Sheet From Template

Send Row

Share Sheet

API Request (Beta)

Find Attachment

New File

New Folder

Copy File

Export File

Create Folder

Create File From Text

Replace File

Add File Sharing Preference

Update File or Folder Metadata

API Request (Beta)

Retrieve Files from Google Drive

Get File Permissions

Find a Folder

Find or Create Folder

New Attachment

New Row

Updated Row

Add Attachment to Row

Add Row to Sheet

Copy Row

Export Column

Create Sheet From Existing Sheet

Update Row

Send Sheet

Share Workspace

Find sheet Row (Legacy)

Find Sheet Row

New File in Folder

Updated File

Delete File

Upload File

Move File

Remove File Permission

Create Shared Drive

Create Shortcut

Update File/Folder Name

Delete File

Retrieve File or Folder by ID

Find a File

Find or Create File

About Google Drive

Related categories

Similar apps

Dropbox

Box

OneDrive

About Smartsheet

Related categories

Similar apps

MySQL

Zoho Creator

Knack

Related Zap Templates

Related Zap Templates