Skip to main content

Microsoft Power Automate template

Recurrence
Google Sheets
Pitney Bowes Data Validation
FreshBooks

Create Freshbooks clients with cleansed Google sheet addresses

By Pitney Bowes

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

Work less, do more

Connect your favorite apps to automate repetitive tasks.

Explore Microsoft Power Automate

See how it works

Check out a quick video about Microsoft Power Automate.

Watch it now

Build your skills

Learn how to make flows, easy up to advanced.

Get started