Google Drive + Google Sheets
Update Google Drive file sharing preferences when new or updated rows appear in Google Sheets
This workflow springs into action as soon as there are new or revised entries in your Google Sheets. Without any manual intervention, it sets up sharing preferences for a specific file in your Google Drive. A perfect solution for those looking to streamline their document sharing process, this workflow ensures that your Google Drive files are always up-to-date with the latest changes made in your Google Sheets.
This workflow springs into action as soon as there are new or revised entries in your Google Sheets. Without any manual intervention, it sets up sharing preferences for a specific file in your Google Drive. A perfect solution for those looking to streamline their document sharing process, this workflow ensures that your Google Drive files are always up-to-date with the latest changes made in your Google Sheets.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Add File Sharing PreferenceAdds a sharing scope to the sharing preference of a file. Does not remove existing sharing settings. Provides a sharing URL.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
Folder
Include Deleted Files?
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
Folder
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
FolderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to ReplaceRequired
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Delete File
This action will delete a file in Google Drive. You will need to provide the file ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FilenameRequired
Search Type
Drive
Folder
File Types
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder NameRequired
Search Type
Drive
Parent Folder
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFileRequired
Convert to Document?
File Name
Drive
Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Parent Folder
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File NameRequired
File ContentRequired
Convert to Document?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File IdRequired
Sharing PreferenceRequired
Organization Domain
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Folder
File to Replace
File/Folder Name
Rename Folder?
Extension Copy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
File or Folder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Filename
Search Type
Drive
Folder
File Types
Maximum Number of Results
ActionThis is an event a Zap performs.SearchFind existing data in your appFilenameRequired
Search Type
Drive
Folder
File Types
FileRequired
Convert to Document?
File Name
File Extension
Idempotency Key
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
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.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Add new Google Drive files in a folder as rows in Google Sheets
- Add new Google Drive files to rows in Google Sheets
- Create Google Drive folders from new rows in Google Sheets
- Extract data with Extracta.ai from new files in Google Drive and add to Google Sheets rows
- Create Google Sheet rows for new files in Google Drive
- Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
- Add new Google Sheets rows as text files to Google Drive
- Generate Google Drive folders for new Google Sheets rows
- Upload files in Google Drive for new spreadsheet rows in Google Sheets
- Update spreadsheet rows in Google Sheets when new files are added in Google Drive
- Update Google Sheets rows when new Google Drive files are added
- Create folders in Google Drive for new Google Sheets worksheets
- Add new row in Google Sheets with detailed CandidateZip parsed resume files added to Google Drive
- Create new rows in a Google Sheet with detailed CandidateZip parsed resume files added to a folder in Google Drive
- Create Google Sheet rows for new folders in Google Drive
- Create Google Drive folders for new Google Sheet rows
- Create Google Sheet rows for new updated Google Drive files
- Upload Google Drive files for new or updated spreadsheet rows in Google Sheets
- Create Google Drive folders from new Google Sheets folders
- Copy files in Google Drive for new or updated spreadsheet rows in Google Sheets
- Create folders in Google Drive for new spreadsheets in Google Sheets
- Create files from text in Google Drive for new Google Sheets worksheets
- Create tasks in Asana for new incidents in TOPdesk
- Create copies of new Google Sheets spreadsheets in Google Drive files
- Create spreadsheets in Google Sheets for each new folder in Google Drive
- Create new Google Sheets spreadsheets from new Google Drive files in folder
- Create multiple spreadsheet rows in Google Sheets from new folders in Google Drive
- Create worksheets in Google Sheets for new files in Google Drive folders
- Manage new or updated rows in Google Sheets by creating extensions in Google Drive
- Update Google Sheets rows when new Google Drive files are added to a folder
- Handle updated Google Drive files with app extensions in Google Sheets
- Create worksheets in Google Sheets for each new file in Google Drive
- Create new Google Drive folders from new Google Sheets rows
- Create worksheets in Google Sheets for new files in Google Drive folders
- Upload files to Google Drive when new or updated rows are created in Google Sheets
- Create files from text in Google Drive from new rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Copy worksheets in Google Sheets when files get updated in Google Drive
- Create spreadsheets in Google Sheets from new files in Google Drive
- Create new Google Drive folders from new Google Sheets rows in team drive
- Create files from text in Google Drive for new or updated rows in Google Sheets
- Create multiple rows in Google Sheets for new files in Google Drive folder
- Create new Google Drive folders from new or updated Google Sheets rows on team drive
- Create spreadsheets in Google Sheets for new folders in Google Drive
- Create new Google Drive folders from new Google Sheets rows
- Create and upload files in Google Drive for new Zoho CRM leads
- Upload files to Google Drive when new or updated rows appear in Google Sheets
- Create new Google Drive folders from new Google Sheets rows in team drive
- Create new Google Drive folders from new rows in Google Sheets team drive
- Create new Google Sheets rows for new Google Drive folders
- Upload new Google Sheets rows as files in Google Drive
- Create files from text in Google Drive for new spreadsheets in Google Sheets
- Create new rows in Google Sheets when new files appear in Google Drive
- Update Google Sheets rows quickly with new files from Google Drive
- Create worksheets in Google Sheets for every new file in Google Drive
- Create new Google Sheets spreadsheets and upload files to Google Drive
- Create new Google Drive folders from new Google Sheets rows
- Create folders in Google Drive for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Copy files in Google Drive when rows are updated or new in Google Sheets
- Create multiple rows in Google Sheets from new files in a Google Drive folder
- Upload new Google Sheets rows as files in Google Drive
- Create spreadsheet rows in Google Sheets for new files in Google Drive
- Create multiple spreadsheet rows in Google Sheets for new files in Google Drive
- Create new Google Drive folders from new Google Sheets team drive rows
- Create new Google Sheets rows from updated Google Drive files
- Update Google Sheets rows with new Google Drive files in folders
- Upload new Google Sheets rows as files in Google Drive
- Create spreadsheet rows in Google Sheets for new folders in Google Drive
- Upload files to Google Drive from new or updated rows in Google Sheets team drive
- Update Google Drive files and create corresponding rows in Google Sheets
- Update Google Sheets rows whenever new files appear in Google Drive folders
- Upload files to Google Drive when new or updated rows appear in Google Sheets
- Create new Google Drive files from text whenever new rows are added in Google Sheets
- Move new Google Sheets rows to Google Drive as files
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Create updated records in Google Sheets for new files in Google Drive folders
- Copy files in Google Drive when new or updated rows are found in Google Sheets team drive
- Update file sharing preferences in Google Drive when new or updated rows are added to a team drive in Google Sheets
- Upload files to Google Drive for each new or updated row in Google Sheets
- Create spreadsheet columns in Google Sheets for new files in Google Drive folders
- Update rows in Google Sheets when new files populate in Google Drive folders
- Copy new Google Drive files to Google Sheets worksheets
- Create worksheets in Google Sheets from updated files in Google Drive
- Copy new Google Drive files into Google Sheets worksheets
- Copy new Google Sheets rows to Google Drive files
- Add file sharing preferences in Google Drive for new rows in Google Sheets
- Clear Google Sheets rows when new files are added in Google Drive
- Create copies of worksheets in Google Sheets for every new file in Google Drive
- Create spreadsheet rows in Google Sheets for new folders in Google Drive
- Create new Google Sheets rows for new Google Drive files
- Add file sharing preferences in Google Drive for new or updated rows in Google Sheets
- Create a copy in Google Drive when new spreadsheets are added to Google Sheets
- Move files in Google Drive when new or updated rows in Google Sheets (team drive) are detected
- Update rows in Google Sheets when files in Google Drive are updated
- Update rows in Google Sheets when new files are added to Google Drive
- Create spreadsheets in Google Sheets from updated files in Google Drive
- Create new Google Sheets columns from new Google Drive files
- Create new Google Sheets rows for every new file in Google Drive
Related Zap Templates
- Add new Google Drive files in a folder as rows in Google Sheets
- Extract data with Extracta.ai from new files in Google Drive and add to Google Sheets rows
- Add new Google Sheets rows as text files to Google Drive
- Update spreadsheet rows in Google Sheets when new files are added in Google Drive
- Add new row in Google Sheets with detailed CandidateZip parsed resume files added to Google Drive
- Create Google Drive folders for new Google Sheet rows
- Create Google Drive folders from new Google Sheets folders
- Create files from text in Google Drive for new Google Sheets worksheets
- Create spreadsheets in Google Sheets for each new folder in Google Drive
- Create worksheets in Google Sheets for new files in Google Drive folders
- Handle updated Google Drive files with app extensions in Google Sheets
- Create worksheets in Google Sheets for new files in Google Drive folders
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Create new Google Drive folders from new Google Sheets rows in team drive
- Create new Google Drive folders from new or updated Google Sheets rows on team drive
- Create and upload files in Google Drive for new Zoho CRM leads
- Create new Google Drive folders from new rows in Google Sheets team drive
- Create files from text in Google Drive for new spreadsheets in Google Sheets
- Create worksheets in Google Sheets for every new file in Google Drive
- Create folders in Google Drive for new or updated rows in Google Sheets
- Create multiple rows in Google Sheets from new files in a Google Drive folder
- Create multiple spreadsheet rows in Google Sheets for new files in Google Drive
- Update Google Sheets rows with new Google Drive files in folders
- Upload files to Google Drive from new or updated rows in Google Sheets team drive
- Upload files to Google Drive when new or updated rows appear in Google Sheets
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Update file sharing preferences in Google Drive when new or updated rows are added to a team drive in Google Sheets
- Update rows in Google Sheets when new files populate in Google Drive folders
- Copy new Google Drive files into Google Sheets worksheets
- Clear Google Sheets rows when new files are added in Google Drive
- Create new Google Sheets rows for new Google Drive files
- Move files in Google Drive when new or updated rows in Google Sheets (team drive) are detected
- Create spreadsheets in Google Sheets from updated files in Google Drive
- Add new Google Drive files to rows in Google Sheets
- Create Google Sheet rows for new files in Google Drive
- Generate Google Drive folders for new Google Sheets rows
- Update Google Sheets rows when new Google Drive files are added
- Create new rows in a Google Sheet with detailed CandidateZip parsed resume files added to a folder in Google Drive
- Create Google Sheet rows for new updated Google Drive files
- Copy files in Google Drive for new or updated spreadsheet rows in Google Sheets
- Create tasks in Asana for new incidents in TOPdesk
- Create new Google Sheets spreadsheets from new Google Drive files in folder
- Manage new or updated rows in Google Sheets by creating extensions in Google Drive
- Create worksheets in Google Sheets for each new file in Google Drive
- Upload files to Google Drive when new or updated rows are created in Google Sheets
- Copy worksheets in Google Sheets when files get updated in Google Drive
- Create files from text in Google Drive for new or updated rows in Google Sheets
- Create spreadsheets in Google Sheets for new folders in Google Drive
- Upload files to Google Drive when new or updated rows appear in Google Sheets
- Create new Google Sheets rows for new Google Drive folders
- Create new rows in Google Sheets when new files appear in Google Drive
- Create new Google Sheets spreadsheets and upload files to Google Drive
- Create spreadsheet rows in Google Sheets for new files in Google Drive folders
- Upload new Google Sheets rows as files in Google Drive
- Create new Google Drive folders from new Google Sheets team drive rows
- Upload new Google Sheets rows as files in Google Drive
- Update Google Drive files and create corresponding rows in Google Sheets
- Create new Google Drive files from text whenever new rows are added in Google Sheets
- Create updated records in Google Sheets for new files in Google Drive folders
- Upload files to Google Drive for each new or updated row in Google Sheets
- Copy new Google Drive files to Google Sheets worksheets
- Copy new Google Sheets rows to Google Drive files
- Create copies of worksheets in Google Sheets for every new file in Google Drive
- Add file sharing preferences in Google Drive for new or updated rows in Google Sheets
- Update rows in Google Sheets when files in Google Drive are updated
- Create new Google Sheets columns from new Google Drive files
- Create Google Drive folders from new rows in Google Sheets
- Extract data from new PDFs in Google Drive with PDF.co and add to multiple rows in Google Sheets
- Upload files in Google Drive for new spreadsheet rows in Google Sheets
- Create folders in Google Drive for new Google Sheets worksheets
- Create Google Sheet rows for new folders in Google Drive
- Upload Google Drive files for new or updated spreadsheet rows in Google Sheets
- Create folders in Google Drive for new spreadsheets in Google Sheets
- Create copies of new Google Sheets spreadsheets in Google Drive files
- Create multiple spreadsheet rows in Google Sheets from new folders in Google Drive
- Update Google Sheets rows when new Google Drive files are added to a folder
- Create new Google Drive folders from new Google Sheets rows
- Create files from text in Google Drive from new rows in Google Sheets
- Create spreadsheets in Google Sheets from new files in Google Drive
- Create multiple rows in Google Sheets for new files in Google Drive folder
- Create new Google Drive folders from new Google Sheets rows
- Create new Google Drive folders from new Google Sheets rows in team drive
- Upload new Google Sheets rows as files in Google Drive
- Update Google Sheets rows quickly with new files from Google Drive
- Create new Google Drive folders from new Google Sheets rows
- Copy files in Google Drive when rows are updated or new in Google Sheets
- Create spreadsheet rows in Google Sheets for new files in Google Drive
- Create new Google Sheets rows from updated Google Drive files
- Create spreadsheet rows in Google Sheets for new folders in Google Drive
- Update Google Sheets rows whenever new files appear in Google Drive folders
- Move new Google Sheets rows to Google Drive as files
- Copy files in Google Drive when new or updated rows are found in Google Sheets team drive
- Create spreadsheet columns in Google Sheets for new files in Google Drive folders
- Create worksheets in Google Sheets from updated files in Google Drive
- Add file sharing preferences in Google Drive for new rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new folders in Google Drive
- Create a copy in Google Drive when new spreadsheets are added to Google Sheets
- Update rows in Google Sheets when new files are added to Google Drive
- Create new Google Sheets rows for every new file in Google Drive