Google Sheets + Microsoft SharePoint
Create sharepoint lists from new or updated rows in Google Sheets
Ensure your data is always updated and organized with this handy automation. Whenever there are new or updated entries in your Google Sheets, this workflow creates a corresponding list in Microsoft SharePoint. Save time, reduce manual data entry and maintain consistency across your platforms with this efficient process.
Ensure your data is always updated and organized with this handy automation. Whenever there are new or updated entries in your Google Sheets, this workflow creates a corresponding list in Microsoft SharePoint. Save time, reduce manual data entry and maintain consistency across your platforms with this efficient process.
- 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!
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
Include Grid Data
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 foundSite
Document Library
Folder
Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
ListRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
Document LibraryRequired
Browse to Folder
File or FolderRequired
RecipientsRequired
Permission LevelRequired
Message
Require Sign In
Send Email Invitation
Expiration Date
Retain Inherited Permissions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
Document LibraryRequired
Folder
File nameRequired
Text contentRequired
If file name exists
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
Site
ListRequired
List Item IDRequired
ETag
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
SiteRequired
Document LibraryRequired
Folder
FileRequired
Export formatRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
PageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
Document LibraryRequired
Browse to Folder
File to ReplaceRequired
FileRequired
New Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Document Library
Folder
FileRequired
File name
If file name exists
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
Site
Document Library
Search For
Match By
Search QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCopy
Site
Document Library
File or Folder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSiteRequired
Document LibraryRequired
File or FolderRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSiteRequired
Page IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInfo
Source SiteRequired
Source Document LibraryRequired
File or Folder IDRequired
Destination SiteRequired
Destination Document LibraryRequired
Destination Folder
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
List NameRequired
Description
List Template
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
TitleRequired
URL Name
Description
Page Layout
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
Document LibraryRequired
Browse to Folder
File or Folder to ShareRequired
Permission
Who Can Access
Expiration Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
SiteRequired
Document LibraryRequired
Folder
File or Folder IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
SiteRequired
PageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy
SiteRequired
Document LibraryRequired
ItemRequired
Folder
New name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
Document LibraryRequired
Browse to Folder
File or FolderRequired
Email Address
Permission ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SiteRequired
ListRequired
List Item IDRequired
ETag
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.SiteRequired
ListRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInfo
Monitor URLRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCopy
SiteRequired
Document LibraryRequired
FolderRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSiteRequired
ListRequired
List Item IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSite
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About Microsoft SharePoint
Related categories
Related Zap Templates
- Create sharepoint list items from new Google Sheets rows
- Create sharepoint items from new or updated rows in Google Sheets
- Create sharepoint list items from new Google Sheets team drive rows
- Create Google Sheets rows from new Microsoft SharePoint files in subfolders
- Create Google Sheets rows from updated Microsoft SharePoint list items
- Update Google Sheets rows when Microsoft SharePoint list items are updated
- Create Google Sheets rows from new Microsoft SharePoint files in folders
- Add new Microsoft SharePoint list items to Google Sheets as spreadsheet rows
- Update sharepoint list items with new or updated rows from Google Sheets
- Update Google Sheets rows when list items are updated in Microsoft SharePoint
- Create Microsoft SharePoint items from new or updated Google Sheets rows in team drive
- Create new Microsoft SharePoint folders from new or updated rows in Google Sheets