Google Sheets + Stripe + VATFix Plus

Add new Stripe customers with validated EU VAT details from VATFix to Google Sheets rows

Keep track of your customers and their EU VAT validation status in one place. This integration automatically adds each new Stripe customer to Google Sheets after validating their VAT number with VATFix Plus. You’ll get a spreadsheet row with the customer details, validation result, source, and check date, making compliance tracking and reporting much easier.

When this happens...
New Customer
Triggers when a new customer is added.
TriggerInstant
automatically do this...
Validate EU VAT Number
Checks a VAT number against VIES and returns validity, entity name, and address.
ActionWrite
then do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

Canceled Subscription
Triggers when a subscription is canceled (by a subscriber or due to end of billing period).
Trigger
Instant
Try It
Failed Payment
Triggers when a payment attempt fails.
Trigger
Instant
Try It
- Ignore payments intentsRequired
Trigger
Instant
Try It
New Dispute
Triggers when a customer disputes a charge.
Trigger
Instant
Try It
- Event Types
Trigger
Polling
Try It

- Status
- Collection Method
- Customer ID
- Subscription ID
Trigger
Polling
Try It
- Products
Trigger
Polling
Try It

Updated Subscription
Triggers when a customer subscription has changed.
Trigger
Instant
Try It
- Subscription IDRequired
Action
Write
- ModeRequired
- Price ID
- Quantity
- Success URLRequired
- Cancel URL
- Customer ID
- Customer Email
- Payment Method Types
- Currency
- Billing Address Collection
- Shipping Countries
- Allow Promotion Codes
- Automatic Tax Enabled
- Coupon ID
- Promotion Code ID
- Client Reference ID
- Expires At
Action
Write
- Customer ID
- Description
- Quantity
- Unit Price
- Amount
- Include Tax In Price?
- Item Taxes
- Is Discountable?
- Item Coupons
- Supply Date - Start
- Supply Date - End
- Invoice Item Currency
- Price ID
- Invoice Item Subscription ID
- Tax Code
- Shipping Rate
- Invoice Coupons
- Default Tax Rates
- Payment Collection
- Due Date
- Days Until Due
- Turn On Automatic Collection?
- Default Payment Method
- Memo
- Footer
- Custom Fields
- Tax IDs
- PDF Page Size
- Shipping Details Instructions
- Shipping Details - Name
- Shipping Details - Phone
- Shipping Details - Address Line 1
- Shipping Details - Address Line 2
- Shipping Details - City
- Shipping Details - State
- Shipping Details - Postal Code
- Shipping Details - Country
- Subscription ID
- Automatic Tax Enabled?
- Invoice Currency
- Effective At
- Payment Method Types
- Rendering - Amount Tax Display
- Statement Descriptor
- Pending Invoice Items Behavior
- Invoice Metadata
- Help Text For Finalizing Sending Charging
- Finalize Invoice?
- Send Invoice for Manual Payment?
- Pay Invoice?
- Pay Invoice - Forgive
- Pay Invoice - Off-Session
- Pay Invoice - Paid Out of Band
Action
Write
- PriceRequired
- QuantityRequired
- Minimum adjustable quantity
- Maximum adjustable quantity
- Collect Tax Automatically?
- Allow Promotion Codes?
- Maximum number of times the link can be used
- Collect Customers' Addresses?
- Require customers to provide a phone number?
- Collect Tax ID?
- Create Invoice on Payment?
- Require customers to accept terms of service agreement?
- Confirmation Page
- Metadata
- Payment Method Types
Action
Write
- NameRequired
- Description
- Image
- Tax Code
- Metadata
Action
Write
- Payment LinkRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Account IDRequired
Action
Search
- Find by
- QueryRequired
Action
Search
- Payment Intent IDRequired
Action
Search
- Country CodeRequired
- VAT NumberRequired
Action
Write
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

Checkout Session Completed
Triggers when a checkout session is completed.
Trigger
Instant
Try It
Invoice Payment Failed
Triggers when an invoice payment fails.
Trigger
Instant
Try It
New Customer
Triggers when a new customer is added.
Trigger
Instant
Try It
New Subscription
Triggers when a customer is signed up for a new plan.
Trigger
Instant
Try It
New Invoice Item
Triggers when a new invoice item is created.
Trigger
Polling
Try It
New Payment
Triggers when a new payment is completed.
Trigger
Instant
Try It
New Refund
Triggers when a charge is refunded, including partial refunds.
Trigger
Polling
Try It
Updated Dispute
Triggers when a dispute is updated (usually with evidence).
Trigger
Instant
Try It
- Warning
- Payment IDRequired
- Payment Method ID
- Receipt Email
- Error on Requires Action?
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
Action
Write
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
- Warning
- AmountRequired
- CurrencyRequired
- Customer ID
- Payment Method ID
- Confirm Payment Immediately?
- Error on Requires Action?
- Off Session?
- Payment Description
- Receipt Email
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
- Statement Descriptor
- Statement Descriptor Suffix
- Metadata
- Capture Method
Action
Write
- ProductRequired
- Price (in minor units, e.g. cents)Required
- CurrencyRequired
- Recurring or One time?
- Tax Behavior
Action
Write
- Customer IDRequired
- ItemsRequired
- Collection MethodRequired
- Coupon ID
- Cancel at period end?
- Metadata
Action
Write
- Customer IDRequired
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
Find Account Balance
Finds the account balance for your stripe account
Action
Search
- Stripe Charge IDRequired
Action
Search
- Invoice IDRequired
Action
Search
- Customer IDRequired
- Price ID
- Status
Action
Search
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write
- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Stripe

Stripe is a developer-friendly way to accept payments online and in mobile apps. Stripe's suite of APIs powers commerce for thousands of companies of all sizes, processing billions of dollars for businesses each year.

Learn more

Related categories

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.

Related categories

Accounting

Google Sheets + Stripe + VATFix Plus

Add new Stripe customers with validated EU VAT details from VATFix to Google Sheets rows

Canceled Subscription

Failed Payment

New Charge

New Dispute

New Event

New Invoice

New Payment Link

Updated Subscription

Cancel Subscription

Create Checkout Session

Create Invoice

Create Payment Link

Create Product

Deactivate Payment Link

API Request (Beta)

Find Account by ID

Find Customer

Find Payment

Validate EU VAT Number

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

Checkout Session Completed

Invoice Payment Failed

New Customer

New Subscription

New Invoice Item

New Payment

New Refund

Updated Dispute

Confirm Payment

Create Customer

Create Payment

Create Price

Create Subscription

Update Customer

Find Account Balance

Find Charge

Find Invoice

Find Subscription

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator