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