■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
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete 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