Easy

Easy point and click

Fast

Setup in under 5 minutes

Secure

Secure data architecture

Square

Square Integration

One way sync
Payments
OAuth Authentication

Datasets

BankAccounts

CashDrawerShifts-Alltime

CashDrawerShifts-Last30days

CashDrawerShifts-Last365days

CashDrawerShifts-Last60days

CashDrawerShifts-Last7days

CashDrawerShifts-Last90days

CatalogList-Items

CatalogList-ItemsVariations

Customer Groups

Customers by Group

Customers-All

Device Codes

Disputes

Employees

Employees-All Wages

InventoryCounts by Location

Locations

Orders-All by Location

Orders-Last30days by Location

Orders-Last365days by Location

Orders-Last90days by Location

Payments-Alltime

Payments-Last30days

Payments-Last365days

Payments-Last60days

Payments-Last7days

Payments-Last90days

Refunds-Alltime

Refunds-Last30days

Refunds-Last365days

Refunds-Last60days

Refunds-Last7days

Refunds-Last90days

Auto export Square data to flat files

Every 10 Minutes, Hourly, Daily, Weekly


Full DatasetsData IntegrationFlat files

Square, Inc. is a financial services, merchant services aggregator, and mobile payment company based in San Francisco, California.

Google Drive

Destination: Google Drive

Export and sync comprehensive Square datasets to Google Sheets, CSV or Excel XLSX files in Google Drive folders on a recurring, automatic basis. Historical data is included. Use Filter Views to sort or filter flattened data. Connect to Google Data Studio via Google Sheets or Google Drive.


└ Google Sheets

Destination: └ Google Sheets

Export and sync comprehensive Square datasets to Google Sheets, CSV or Excel XLSX files in Google Drive folders on a recurring, automatic basis. Historical data is included. Use Filter Views to sort or filter flattened data. Connect to Google Data Studio via Google Sheets or Google Drive.


OneDrive

Destination: OneDrive

Export and sync comprehensive Square datasets to Excel Online XLSX or CSV files in OneDrive folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.


└ Excel Online

Destination: └ Excel Online

Export and sync comprehensive Square datasets to Excel Online XLSX or CSV files in OneDrive folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.


OneDrive for Business

Destination: OneDrive for Business

Export and sync comprehensive Square datasets to Excel Online XLSX or CSV files in OneDrive for Business folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.


└ Excel Online

Destination: └ Excel Online

Export and sync comprehensive Square datasets to Excel Online XLSX or CSV files in OneDrive for Business folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.


Box

Destination: Box

Export and sync comprehensive Square datasets to XLSX or CSV files in Box on a recurring, automatic basis. Historical data is included.


Dropbox

Destination: Dropbox

Export and sync comprehensive Square datasets to XLSX or CSV files in Dropbox on a recurring, automatic basis. Historical data is included.


Amazon S3

Destination: Amazon S3

Export and sync comprehensive Square datasets to XLSX or CSV files in Amazon S3 storage buckets on a recurring, automatic basis. Historical data is included.


Azure Storage

Destination: Azure Storage

Export and sync comprehensive Square datasets to CSV or Excel XLSX files in Microsoft Azure on a recurring, automatic basis. Past and present data records are included.


Google Cloud Storage

Destination: Google Cloud Storage

Export and sync comprehensive Square datasets to CSV or Excel XLSX files in Google Cloud Storage buckets on a recurring, automatic basis. Past and present data records are included. Connect to Google BigQuery and Google Data Studio.


FTP

Destination: FTP

Export and sync comprehensive Square datasets to CSV or Excel XLSX files on FTP servers.


SFTP

Destination: SFTP

Export and sync comprehensive Square datasets to CSV or Excel XLSX files on SFTP servers.


HubSpot Files

Destination: HubSpot Files

Export and sync comprehensive Square datasets to CSV or Excel XLSX files in HubSpot Files.