Payments OAuth
Sync Square Data
to Flat Files
& Spreadsheets
Automatically sync your Square data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
Historical & Dynamic Data
One-way Sync
For Non-technical Users
About the integration: Square, Inc. is a financial services, merchant services aggregator, and mobile payment company based in San Francisco, California. Flatly integrates with Square's official APIs.
Available Datasets
Flatly can sync the following datasets from Square.
- BankAccounts
- CashDrawerShifts-Alltime
- CashDrawerShifts-Last X days Date-ranged
- CatalogList-Items
- CatalogList-ItemsVariations
- Customers-All
- Customer Groups
- Customers by Group
- Device Codes
- Disputes
- InventoryCounts by Location
- InventoryCounts+Items by Location Combo
- Locations
- Orders-All by Location
- Orders-Last X days by Location Date-ranged
- Payments-Alltime
- Payments-Last X days Date-ranged
- Refunds-Alltime
- Refunds-Last X days Date-ranged
- Shifts
- TeamMembers
- TeamMember Wages
- Workweek Configs
Send Square data to
Flatly can sync Square data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.