LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

Exchange On-Premises GAL Contacts syncs one-way to Square Customers

Sync Exchange On-Premises GAL and Square Contacts

Learn how to sync your Exchange On-Premises GAL and Square contacts using the SyncPenguin platform


Free 14-day trial with full support, no credit card required

Many businesses that run Exchange On-Premises also sell through Square, whether in a company store, staff cafeteria, on-site shop or retail location where employees buy at a discount. The Global Address List already holds every employee's name, company and email, but none of it reaches Square. Staff profiles have to be created by hand at the register, details go out of date as people change roles, and former employees stay in the customer directory long after they leave.

How SyncPenguin helps

SyncPenguin connects your Exchange On-Premises address list to Square Customers and keeps them automatically aligned in one direction. New employees appear in Square as customer profiles. Name, company and email changes are carried over on the next sync. Departures can be removed or kept, depending on your sync rules. With no-code filters and rules, you choose which address list, departments or companies are synced, and you can tag employee profiles with their department or job title in Square notes or the Reference ID. Staff are then easy to recognize at checkout, and your Square directory stays clean without manual data entry.

Best suited for: IT administrators managing Exchange On-Premises. HR teams running employee discount or perks programs. Operators of company stores, staff cafeterias and on-site shops. Retail businesses that sell to their own staff through Square.

Real-world use cases

  • Add every employee from the Exchange Global Address List to Square Customers so staff can be quickly found at checkout for employee discounts.
  • Sync only selected departments or office locations from an Exchange address list into Square for an on-site cafeteria or company store, and write the department into the customer notes with a custom rule.
  • Set the Square Reference ID to 'EMPLOYEE' plus the person's department for all synced GAL entries, so cashiers and reports can easily tell staff purchases apart from regular customers.
  • Keep a group of companies' employees in Square by syncing the GAL filtered by the Company field, so each subsidiary's staff profile shows the correct company name.
  • Sync employees from the GAL into Square, then sync Square customers to QuickBooks Customers so staff purchases on account can be invoiced or settled in your bookkeeping.
  • Import staff from Exchange into Square, then push Square customers who carry the employee tag to a Mailchimp audience for internal company store promotions.
  • Run an employee merchandise store both online and in person by syncing the GAL to Square Customers and Shopify Customers at the same time.
  • In a hybrid Exchange environment, sync both the on-premises GAL and the Microsoft 365 GAL Contacts to Square so cloud and on-premises employees are included.

Key features

Employee Import

Turn your Global Address List, or any custom Exchange address list, into Square customer profiles automatically.

Always Current

New hires, name changes and company updates in Exchange are picked up automatically and applied to Square.

Smart Filters

Sync only the people you need, such as one department, one company or only entries with an email address.

Staff Tagging

Use no-code rules to put department, job title or an 'Employee' tag into Square notes or the Reference ID.

No Duplicates

Employees who are already Square customers are matched by email during the initial merge, so profiles are linked instead of duplicated.

Affordable & Scalable

With SyncPenguin you only pay for changes to your data, regardless of how many contacts you have now or will have in the future.

Things to note

  • This is a one-way sync from Exchange to Square. The GAL connector is read-only by design, which protects your company directory. Edit employee details in Exchange, and SyncPenguin will carry the changes over to Square.
  • The GAL provides names, display name, job title, department, company and primary email. Phone numbers and postal addresses are not read from Exchange, so those Square fields are not filled from the directory.
  • Square customer group membership cannot be set by the sync. To mark employees, use the Reference ID or Notes fields with a no-code rule.
  • Custom fields in Exchange and Square custom attributes are not supported. Standard fields such as names, company, email, notes and Reference ID are fully supported.
  • You need the ID of the address list you want to sync. Your Exchange administrator can find it in seconds using the Exchange Management Shell.
  • Exchange Server 2013 or newer is required, and its Exchange Web Services (EWS) endpoint must be reachable from the internet. Very large address lists may take a little longer to process on each sync.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose Exchange On-Premises GAL Contacts for the first app.
  • Then choose Square Customers for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Exchange On-Premises GAL and Square

Now that your sync is created, the next important step is to grant SyncPenguin access to your contact data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Exchange On-Premises GAL?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Exchange On-Premises GAL Contacts account connection section will look like this:

Account for Exchange On-Premises GAL Contacts (Example)
Exchange On-Premises GAL Contacts

How to connect Square?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Square Customers account connection section will look like this:

Account for Square Customers (Example)
Square Customers

Please make sure both apps are properly connected before starting the contact sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Please note that this connection uses webhooks, so syncing will be near real-time in most cases. The syncing interval is used as a fallback in case a webhook was not fired.

Additionally, in Field mappings & rules you can customize how contact data is mapped between the apps, or add filters and custom rules to the sync. This is done using our simple no-code visual interface, which lets you make simple adjustments as well as implement complex custom scenarios.

Supported Exchange On-Premises GAL fields: First name Last name Display name Job title Department Company Email address
Supported Square fields: First name Last name Company Notes Reference ID Birthdate Email Phone Address Customer groups (read-only)

Virtually any syncing behavior based on supported fields is possible using the customizations interface.

Learn more about our customization interface.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Only sync new data, meaning anything added or updated from now on.
  2. Merge Exchange On-Premises GAL Contacts into Square Customers: take all Exchange On-Premises GAL Contacts and add/merge them into Square Customers.
Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing contacts?

Once you've made your choice, click Start syncing. If you choose an initial merge, it'll be queued immediately. Once it's done, we'll check for contact changes at the sync interval you've set and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

Can I automatically add my employees from Exchange to Square Customers?

Is the sync between Exchange GAL and Square one-way or two-way?

How can I identify employees in Square for staff discounts?

Will employees who are already Square customers be duplicated?

Can I sync only certain departments or companies?

What happens when an employee leaves the company?

What do I need to connect Exchange On-Premises?