Google Sheets + Microsoft SharePoint
Create Google Sheets rows from updated Microsoft SharePoint list items
Keep track of any changes made in your Microsoft SharePoint list items with this workflow that ensures updated list items are immediately reflected in your Google Sheets. This streamlines your data organization, saving you from the mundane task of manually updating your Google Sheets every time an item is updated in SharePoint.
Keep track of any changes made in your Microsoft SharePoint list items with this workflow that ensures updated list items are immediately reflected in your Google Sheets. This streamlines your data organization, saving you from the mundane task of manually updating your Google Sheets every time an item is updated in SharePoint.
- When this happens...
Updated List ItemTriggers when an existing list item is updated.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Info
File or folderRequired
Destination siteRequired
Destination folder pathRequired
Overwrite if exists
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
SharePoint URLRequired
Allow editing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Parent folderRequired
Folder nameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Template
List's nameRequired
Description
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.Site
FolderRequired
File's nameRequired
Should we overwrite the file?
New FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
FolderRequired
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSite
FolderRequired
Include detailed metadata
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
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.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
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 found
Info
File or folderRequired
Destination folder pathRequired
Overwrite if exists
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
ListRequired
IdRequired
E Tag
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
ListRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
FileRequired
FolderRequired
Overwrite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
ListRequired
Item IDRequired
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.Site
ListRequired
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 appNo 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.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 found
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
- 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