Google BigQuery + PayPal + VATFix Plus

Log new PayPal payments with EU VAT numbers validated by VATFix into BigQuery

When a payment is captured in PayPal, VATFix validates the customer’s EU VAT number and automatically logs the results into Google BigQuery. This helps finance and compliance teams keep accurate records and generate VAT-compliant reports with ease.

When this happens...
Payment Capture WebhooksTriggers when a payment capture event occurs.
TriggerInstant
automatically do this...
Validate EU VAT NumberChecks a VAT number against VIES and returns validity, entity name, and address.
ActionWrite
then do this!
Create RowsCreates new rows of data in a table (accepts line items). Note: Does not create a job.
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 PayPal, VATFix Plus, and more

- Docs Link
- Events
Trigger
Instant
Try It
- Docs Link
- Events
Trigger
Instant
Try It
- Docs Link
Trigger
Instant
Try It
- Docs Link
- Events
Trigger
Instant
Try It
- Docs Link
Trigger
Instant
Try It

- Amount
  Required
- Currency Code
- Payment Intent
- Description
- Reference ID
- Custom ID
- Invoice ID
- Payer Email
- Payer First Name
- Payer Last Name
- Item Name
- Item Quantity
- Item SKU
- Item Category
- Shipping Type
- Shipping Full Name
- Shipping Email
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping State/Province
- Shipping City
- Shipping Postal Code
- Shipping Country Code
- Return URL
- Cancel URL
- Brand Name
- Shipping Preference
- User Action
- Soft Descriptor
Action
Write
- Authorization ID
  Required
Action
Search

- Invoice ID
  Required
Action
Search
- Plan ID
  Required
Action
Search
- Refund ID
  Required
Action
Search
- Country Code
  Required
- VAT Number
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

- Docs Link
- Events
Trigger
Instant
Try It
- Triggering Events
Trigger
Instant
Try It
- Docs Link
- Events
Trigger
Instant
Try It
- Docs Link
- Events
Trigger
Instant
Try It
- Invoice Number
- Reference
- Currency Code
- Invoice Date
- Due Date
- Payment Terms
- Note
- Terms and Conditions
- Memo
- Your Business Name
- Your First Name
- Your Last Name
- Your Email
- Your Phone Country Code
- Your Phone Number
- Your Phone Type
- Your Website
- Your Tax ID
- Your Logo URL
- Your Additional Notes
- Your Address Line 1
- Your Address Line 2
- Your Address Line 3
- Your City
- Your State/Province
- Your Postal Code
- Your Country Code
- Recipient Business Name
- Recipient First Name
- Recipient Last Name
- Recipient Email
- Recipient Phone Country Code
- Recipient Phone Number
- Recipient Phone Type
- Recipient Additional Info
- Recipient Language
- Recipient Address Line 1
- Recipient Address Line 2
- Recipient Address Line 3
- Recipient City
- Recipient State/Province
- Recipient Postal Code
- Recipient Country Code
- Shipping Business Name
- Shipping First Name
- Shipping Last Name
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address Line 3
- Shipping City
- Shipping State/Province
- Shipping Postal Code
- Shipping Country Code
- Item Name
  Required
- Item Description
- Item Quantity
  Required
- Item Unit Amount
  Required
- Unit of Measure
- Item Date
- Item Tax Name
- Item Tax Percentage
- Item Tax Note
- Item Discount Type
- Item Discount Value
- Invoice Discount Type
- Invoice Discount Value
- Shipping Amount
- Shipping Tax Name
- Shipping Tax Percentage
- Custom Charge Label
- Custom Charge Amount
- Allow Partial Payment
- Minimum Amount Due
- Allow Tip
- Tax Calculated After Discount
- Tax Inclusive Pricing
- Template ID
- Additional Recipients (CC)
Action
Write
- Invoice
  Required
- Send to Recipient
- Send Copy to Invoicer
- Email Subject
- Note to Payer
- Additional Recipients (CC)
Action
Write
- Capture ID
  Required
Action
Search
- Order ID
  Required
Action
Search
- Product ID
  Required
Action
Search
- Subscription ID
  Required
Action
Search
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About PayPal

PayPal is a fast, safe way to send money, make an online payment, receive money or set up a merchant account. With over 150 million active registered accounts, PayPal helps people and businesses receive and make payments in more than 100 currencies in 203 markets.

Learn moreLearn moreHelpHelp

Related categories

Payment Processing

Premium

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

Capture payment webhooks in PayPal and create rows in Google BigQuery

Related Zap Templates

Capture payment webhooks in PayPal and create rows in Google BigQuery