Google Drive + Smartsheet

Google Drive + Smartsheet integrations

Create Google Drive folders for new Smartsheet rows

As you set you rows on your sheet, you already know there are going to be files associated with each. Let Zapier do the prep work by setting up this Smartsheet-Google Drive integration to work with you. Whenever a new row is added on a particular Smartsheet, Zapier will create a Google Drive folder to match it. You can always rely on having an accurately named place to store those assets from then on!

When this happens...
New RowTriggers when a new row is added.
TriggerPolling
automatically do this!
Create FolderTriggers when a new folder is added directly to a specific folder (but not its subfolders).
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Smartsheet and Google Drive

Discover other triggers and actions you can use with Smartsheet and Google Drive

Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write

- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write

- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search
- Drive
Trigger
Polling
Try It
- Drive
- Folder
Trigger
Polling
Try It
- File
  Required
- Convert to Document?
- File Name
- Drive
- Folder
Action
Write
- Drive
- Folder
- File
  Required
- Export Format
  Required
Action
Write
- Drive
- Parent Folder
- Folder Name
  Required
Action
Write
- Drive
- Folder
- File Name
  Required
- File Content
  Required
- Convert to Document?
Action
Write
- Drive
- Folder
- File to Replace
  Required
- File
  Required
- Convert to Document?
- File Name
- File Extension
- Idempotency_key
Action
Write
- Drive
- File_id
  Required
- Sharing Preference
  Required
- Organization Domain
Action
Write
- Drive
- Copy
- Folder
- File
- Name
- Description
- Starred
- Folder Color (RGB)
- Custom Properties
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- 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 ID
  Required
Action
Search
- Folder Name
  Required
- Search_type
- Drive
- Parent Folder
Action
Search
- Folder Name
  Required
- Search_type
- Drive
- Parent Folder
Action
Search or write

- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- 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 ID
  Required
- Query
  Required
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
- File
  Required
- Confirm deletion
  Required
Action
Write
- Drive
- Folder
- File
  Required
- Convert to Document?
- File Name
- File Extension
- Idempotency_key
Action
Write
- File
  Required
- Drive
- Folder
  Required
Action
Write
- Drive
- Folder
- File
  Required
- Email Address
- Permission ID
Action
Write
- Shared Drive Name
  Required
- Theme ID
- Color RGB
- Background Image File ID
Action
Write
- File
  Required
- 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 ID
  Required
Action
Search
- Filename
  Required
- Search_type
- Drive
- Folder
- File_types
Action
Search
- Filename
  Required
- Search_type
- Drive
- Folder
- File_types
- File
  Required
- 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 moreLearn moreHelpHelp

Related categories

File Management & Storage

Google

Similar apps

Dropbox

File Management & Storage

Box

File Management & Storage

OneDrive

File Management & Storage, Microsoft

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.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Related Zap Templates

Update rows in Smartsheet and create corresponding folders in Google Drive