Skip to main content

Create Dynamics 365 accounts with validated data from Google Sheets



Google Sheets
Pitney Bowes Data Validation
Dynamics 365

Google Sheets, Pitney Bowes Data Validation, and Dynamics 365

Use this flow to standardize and validate addresses from Google Sheet and push cleansed addresses into Dynamics 365. Select a sheet that has first row with columns headers as FirmName, AddressLine1, AddressLine2, City, StateProvince, PostalCode, and Country. To store records that failed address validation, select another sheet with headers as Status, StatusDescription, and StatusCode (along with the ones mentioned above).