Create Freshbooks clients with cleansed Google sheet addresses

Recurrence

Recurrence

Google Sheets
PREMIUM
Pitney Bowes Data Validation
PREMIUM
FreshBooks

Google Sheets, Pitney Bowes Data Validation, and FreshBooks

Use this flow to standardize and validate addresses from Google Sheet and push cleansed addresses into Freshbooks while creating new clients. Select a google sheet as input that has first row with columns headers as FirmName, AddressLine1, AddressLine2, City, StateProvince, PostalCode, and Country. To store non-validated addresses, select another sheet with headers as Status, StatusDescription, and StatusCode (along with the ones mentioned above).