Create cleansed records in Google Sheet from Sharepoint List items

Recurrence

Recurrence

SharePoint
PREMIUM
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).