■Overview
This is a flow to register customer information in Square when a row is added in Google Sheets.
■Recommended for
1. Those who manage customer information with Google Sheets
・Those who want to automatically reflect customer information entered in Google Sheets to Square
・Those who want to avoid duplicate entry of customer information and improve work efficiency
・Those who want to keep customer information in Google Sheets and Square synchronized and always up-to-date
2. Store operators using Square
・Those who want to utilize customer information managed in Google Sheets in Square's customer ledger
・Those who want to efficiently register a large amount of customer information in Square for new customer acquisition campaigns, etc.
・Those who want to centrally manage customer information and utilize it for marketing strategies and customer analysis
3. Marketing personnel
・Those who want to aggregate customer information into Square for analysis and customer segmentation, regardless of online or offline
■Benefits of using this template
Google Sheets is convenient for managing customer information, but manually transferring that information to other systems is time-consuming and labor-intensive, and prone to human error. Manual management is inefficient when customer information is frequently added or updated, or when you want to share information across multiple systems.
By utilizing this flow, customer information entered in Google Sheets is reflected in real-time in Square, eliminating the need for manual data entry and significantly improving operational efficiency.
■Notes
・Please link both Google Sheets and Square with Yoom.


When a row is added
When a row is updated
When a payment is created
When a booking is created
When a booking is updated or canceled
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns
When a payment is created
When a booking is created
When a booking is updated or canceled
Retrieve Specific Customer Information
Search Customer Information
Retrieve Specific Transaction Information
Retrieve Specific Order Information
Retrieve Specific Product Information
Register Customer Information
Retrieve Specific Invoice Information
Retrieve List of Locations
Get Specific Product Variation Information
List payments