Microsoft Excel + Square + VATFix Plus

Add new Square customers with VAT numbers validated by VATFix into Excel rows

When a new customer is created in Square, VATFix automatically validates their EU VAT number and logs the result into a Microsoft Excel spreadsheet row. Keep your sales and tax compliance records up to date with no added clicks or keystrokes.

When this happens...
New CustomerTriggers when a new customer is created.
TriggerPolling
automatically do this...
Validate EU VAT NumberChecks a VAT number against VIES and returns validity, entity name, and address.
ActionWrite
then do this!
Add RowAdds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with these apps

Discover other triggers and actions you can use with Square, VATFix Plus, and more

New Appointment
Triggers when a new appointment is created.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
- Location
  Required
- Order Status
Trigger
Polling
Try It
- Customer ID
  Required
- Group
  Required
Action
Write
- Inventory Change Type
  Required
- Location
  Required
- Catalog Object
  Required
- Quantity
  Required
- Ignore unchanged counts
Action
Write

- Location
  Required
- Order ID
  Required
- Customer ID
  Required
- Accepted_payment_methods
  Required
- Payment due date
  Required
- Tipping enabled
- Invoice title
- Invoice number
- Description
- Delivery method
  Required
- Scheduled at
- Date of sale
Action
Write
- Payment
  Required
- Refund amount
- Reason
- Team member
Action
Write

- Help_text
- Location
  Required
Action
Write
- Customer ID
  Required
- First Name
- Last Name
- Email_address
- Phone_number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference ID
- Birthday
Action
Write
Find Order by ID
This action retrieves the details of a specific order from Square using the order ID.
Action
Write
- Customer_id
Action
Search
- Location
  Required
- Field_help
- Customer
- Fulfillment_state
- Status
Action
Search
- Location
  Required
- Field_help
- Customer
- Fulfillment_state
- Status
- Customer ID
- External Identifier
- Source
- Ticket Name
- Quantity
- Amount
- Currency
- Catalog Item Variation ID
- Note
- Unique Identifier
- Amount Discounted
- Amount Discounted Currency
- Name
- Percentage
- Type
- Unique Identifier
- Name
- Percentage
- Type
- Unique Identifier
Action
Search or write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write

- Item Type
Trigger
Polling
Try It
- Location
  Required
Trigger
Polling
Try It
- Location
Trigger
Polling
Try It
- Location
  Required
- Team Member ID
  Required
- Customer ID
  Required
- Date and Time of Appointment
  Required
- Appointment Service ID
  Required
- Note
Action
Write
- First Name
- Last Name
- Email_address
- Phone_number
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
- Reference_id
Action
Write
- Location
  Required
- Customer ID
- External Identifier
- Buyer Email Address
- Payment Type
  Required
- Payment Note
- Quantity
  Required
- Amount
  Required
- Currency
  Required
- Line Item Name
- Catalog Item Variation ID
- Pickup
- Display Name
- Carrier
- Expected Ship Date/Time
- Shipping Note
- Fulfillment Email Address
- Phone number of the fulfillment recipient
- Address Line 1
- Address Line 2
- State
- County
- Country
- City
- Postal Code
- Discount Type
- Name
- Percentage
- Amount Discounted
- Discount Currency
- Name
- Percentage
- Type
Action
Write
- Customer ID
  Required
- Group
  Required
Action
Write
- Customer
  Required
- Attribute
  Required
- Value
  Required
- Idempotency Key
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Field_help
- Email_address
- Phone Number
- Reference ID
Action
Search
- Field_help
- Text Filter
- Location
Action
Search
- Field_help
- Email_address
- Phone Number
- Reference ID
- First Name
- Last Name
- Country
- Street Address
- Apt./Suite
- City
- State
- ZIP
- Other
- Company
- Nickname
Action
Search or write
- Country Code
  Required
- VAT Number
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Square

Square creates tools that help sellers of all sizes start, run and grow their businesses. Square’s point-of-sale service offers tools for every part of running a business, from accepting credit cards and tracking inventory to real-time analytics and invoicing.

Learn moreLearn moreHelpHelp

Related categories

eCommerce

Payment Processing

Similar apps

PayPal

Payment Processing

Shopify

eCommerce

Epos Now

Payment Processing

About VATFix Plus

VATFix Plus is a real‑time EU VAT validation service via the official VIES, with resilient fallback & caching. Secure, Stripe‑gated API for SaaS tax compliance.

HelpHelp

Related categories

Accounting

Related Zap Templates

Create rows in Microsoft Excel for every new order in Square