Easy

For non-technical users

Fast

Setup in under 5 minutes

Secure

Secure data architecture

Square

Square Integration

One way sync
Commerce
API Key Authentication

Data Objects

Catalog

Customers

Locations

Refunds

Transactions

Flatten Data from Square

Destination: Google Drive +Google Sheets
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to CSV, Excel XLSX or Google Sheets files in Google Drive / Google Sheets on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place. Frozen rows, filters and sorts are preserved upon Sheet refresh. Using importrange and vlookup two Sheets can be linked and merged by ID fields.

Connect Square data to Google Data Studio via Google Sheets.


Destination: Microsoft OneDrive +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect Square data to Power BI via OneDrive.


Destination: Microsoft OneDrive for Business +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive for Business on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect Square data to Power BI via OneDrive for Business.


Destination: Dropbox
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to CSV or Excel XLSX files in Dropbox folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Box
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to CSV or Excel XLSX files in Box folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Microsoft Azure
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to blobs in Microsoft Azure on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Amazon S3
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export Square comprehensive data objects to buckets in Amazon S3 on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.