)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Importing Customers from Square into Excel lets you analyze purchase behavior and demographics in one sheet.
This guide covers importing your Customers object with Coefficient and enabling auto-refresh.
TLDR
-
Step 1:
Install Coefficient, connect Square.
-
Step 2:
Select “Import from Objects” → “Customers.”
-
Step 3:
Click “Import,” verify fields.
-
Step 4:
Enable auto-refresh if desired.
Step-by-Step Guide
What Square Data is Imported?
- Disputes
- Bank Accounts
- Gift Cards
- Merchants
- Locations
- Payments
- Invoices
- Payouts
- Customers
- Refunds
Related Square Use Cases
How to Import Payouts Data from Square into Google Sheets
Learn how to easily import live Square Payouts data into Google Sheets using Coefficient for streamlined payout analysis and reporting.
How to Import Customers Data from Square into Google Sheets
Learn how to easily import live Square Customers data into Google Sheets using Coefficient for streamlined customer analysis and reporting.
How to Import Disputes Data from Square into Google Sheets
Learn how to easily import live Square Disputes data into Google Sheets using Coefficient for streamlined analysis and reporting.
Frequently Asked Questions
-
How to get Customers from Square?
1. Open Coefficient sidebar → “Import from Objects.”2. Select “Customers” → “Import.”Coefficient pulls all customer profiles into Excel.
-
How do I get a list of Customers in Square?
Use “Import from Objects,” pick “Customers.”View every registered buyer.
-
How to export Customers to Excel?
Click “Export to Excel,” map fields, then run.Your sheet updates with live customer data.
-
How do I update Customers from Excel to Square?
Use “Export to Square,” configure mappings, then “Update.”Excel edits sync back to Square.
-
How to send email alerts about Customers data?
Create an email automation in Coefficient.Select Customers fields and schedule.Get notified on new or updated customer records.
Trusted By Over 50,000 Companies
