■Overview
This is a flow that registers payments completed with Square into Microsoft Excel.
■Recommended for
1. Stores using Square
・Those who use Square as a payment system
・Store owners utilizing Square by offering multiple payment options
2. Those managing payment data
・Those who centrally manage payment data in Microsoft Excel
・Those who analyze payment data for marketing strategies
■Benefits of using this template
Square offers multiple payment options and is a system that can cater to a wide range of customers.
However, if you manage Square's payment data with other tools, there is a risk of data entry errors or omissions due to manual work.
This template is suitable for those who want to streamline manual registration tasks.
By using this template, payment data can be automatically registered in Microsoft Excel once a Square payment is completed, reducing the burden of manual work.
Even if there is a large amount of data to register, the data registration is seamless, allowing you to focus on other important tasks.
■Notes
・Please integrate Square and Microsoft Excel with Yoom.
・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.
・Triggers can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest activation interval varies depending on the plan.


When a payment is created
When a booking is created
When a booking is updated or canceled
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
Retrieve Specific Customer Information
Search Customer Information
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
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