Google Sheets + Upodi
Update Upodi customers with new or updated rows in Google Sheets
Keep your customer data up-to-date with this simple workflow. Whenever there's a new or updated row in your Google Sheets, it swiftly updates customer information in Upodi. No more manual transfers or outdated customer records. Increase efficiency while ensuring your customer data in Upodi is always current.
Keep your customer data up-to-date with this simple workflow. Whenever there's a new or updated row in your Google Sheets, it swiftly updates customer information in Upodi. No more manual transfers or outdated customer records. Increase efficiency while ensuring your customer data in Upodi is always current.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update CustomerUpdates a customer
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Contact
Triggers when a new contact is created in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Invoice
Triggers when a new invoice is created by Upodi or manually.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Contact
Triggers when a contact is updated in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Invoice
Triggers when an invoice is updated in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSend activation email to the customer if configured
SubscriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The ID of the invoice you want to bookRequired
Send activation email to the customer if configured
If the email should not just be sent to the Customer.PrimaryEmail include a substitute email address here instead
Pay the invoice using the customers default payment method
Push the invoice to any external applications that are connected in your Upodi. Fx. to an ERP-system or e-invoicing applications.
Will allow Upodi to perform the booking asynchronously for performance. This means you do not receive as much information directly on the booking call
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer ID
Full NameRequired
Contact TypeRequired
GLN Number
Reference Key
Primary Email
Home Phone
Business Phone
Mobile Phone
Address Line 1
Note
City
Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
CurrencyRequired
Subscription
Child
Invoice Date
Due Date
Payment Date
Ref Key
Original Invoice
Invoice Reference
Credit Note Reason
Title
Description
Line Number
QuantityRequired
Tax Exempt
Unit PriceRequired
SKU
Unit
Discount
Period Start
Period End
Is Empty Line
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Product Plan IDRequired
Start Date
End date
Auto Renew
Switch To Plan ID
Subscription Number
Reference Key
Reference
Initial Term Interval
Initial Term Period
Renewal Term Interval
Renewal Term Period
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
Action
Price Strategy
Switch To Product Plan IDRequired
Pay the invoice using the customers default payment methodRequired
Push the invoice to any external applications that are connected in your Upodi. Fx. to an ERP-system or e-invoicing applications.
Will allow Upodi to perform the booking asynchronously for performance. This means you do not receive as much information directly on the booking call
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
Full Name
Parent customer ID
Bill To Parent
Account Number
Company Name
Company VAT Number
Reference Key
Primary Email
Currency Code
Auto Billing
Home Phone
Business Phone
Mobile Phone
Address Line 1
Address Line 2
Note
City
Postal Code
Country
County
State
Collective Billing
Our Reference Contact
Your Reference Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubscriptionCharge IDRequired
Action
Price Strategy
Reference key
Description
Next charge date of the charge
Period start date
QuantityRequired
Price
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product PlanRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAccount Number
Customer ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSubscription ID
ActionThis is an event a Zap performs.SearchFind existing data in your app
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Customer
Triggers when a new customer is created in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Subscription
Triggers when a new subscription is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Customer
Triggers when a customer is updated in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUpdated Subscription
Triggers when a subscription is updated in Upodi.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubscriptionRequired
Product Plan ChargeRequired
Price
Quantity
Description
Charge Start Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
Cancellation reason
Cancel option
Cancel on date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full nameRequired
Account Number (ID)
Currency CodeRequired
Company Name
Company VAT Number
Primary Email
Auto Billing
Home Phone
Business Phone
Mobile Phone
Address Line 1
Address Line 2
Note Field
City
Postal Code
Country
County
State
Parent Customer
Bill To Parent Customer
Collective Billing
Our Reference Contact
Your Reference Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.GatewayRequired
SourceRequired
Customer IDRequired
Make defaultRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The invoice you want to creditRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
Resume ByRequired
Resume By Specific Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Full Name
Customer ID
Contact Type
GLN Number
Reference Key
Primary Email
Home Phone
Business Phone
Mobile Phone
Address Line 1
Note
City
Postal Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
Auto Renew
End date
Reference Key
Reference
Start Date
Switch To Plan ID
Subscription Number
Initial Term Interval
Initial Term Period
Renewal Term Interval
Renewal Term Period
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
Stock Keeping Unit (SKU)
Anchor Code
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer IDRequired
Contact Type
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice ID
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About Upodi
Related categories
Related Zap Templates
- Change Upodi charges from newly updated amounts in Corpay One and Google Sheets rows
- Update Upodi customers with new Google Sheets rows
- Activate new Upodi subscriptions from new rows in Google Sheets
- Create new Upodi customers from new rows in Google Sheets
- Create a change to charges in Upodi for new or updated rows in Google Sheets