Skip to main content

Create cleansed records in Google Sheet from Sharepoint List items



Pitney Bowes Data Validation
Google Sheets

SharePoint, Pitney Bowes Data Validation, and Google Sheets

Use this flow to standardize and validate addresses from Sharepoint List in bulk and push cleansed addresses into Google Sheet. Select a List that has header columns as Title (as FirmName), AddressLine1, AddressLine2, City, StateProvince, PostalCode, and Country. To store non-validated addresses, select another List with headers as Status, StatusDescription, and StatusCode (along with the ones mentioned above).