Google Sheets + Zoho Billing
Create Google Sheets rows at the top for new Zoho Billing subscriptions
Effortlessly manage your new Zoho Billing subscriptions with this efficient workflow. As soon as you acquire a new subscription, it instantly records the details in a designated Google Sheets spreadsheet. It's a great solution to maintaining organized records without the need for manual data entry, saving you valuable time to focus on other crucial aspects of your business.
Effortlessly manage your new Zoho Billing subscriptions with this efficient workflow. As soon as you acquire a new subscription, it instantly records the details in a designated Google Sheets spreadsheet. It's a great solution to maintaining organized records without the need for manual data entry, saving you valuable time to focus on other crucial aspects of your business.
- When this happens...
New SubscriptionTriggers when a new subscription is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet Row at TopCreates a new spreadsheet row at the top of a spreadsheet (after the header row).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Organization
Credit Note Number
Customer NameRequired
Reason
Credit Note Date
NameRequired
RateRequired
QuantityRequired
Discount
Description
Discount Type
Discount
Exchange Rate
Notes
Credit Note Terms
Shipping Charge
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Quote Number
Customer NameRequired
Quote Date
Expiry Date
NameRequired
RateRequired
QuantityRequired
Discount
Description
Discount Type
Discount
Exchange Rate
Quote Notes
Quote Terms
Shipping Charge
Send Quote Only to Primary Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Item NameRequired
RateRequired
Item Description
SKU
Unit
Is Taxable
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization
Retainer Invoice Number
Customer NameRequired
Retainer Invoice Date
DescriptionRequired
RateRequired
Notes
Terms
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Display Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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
OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationsRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationRequired
Customer IDRequired
Invoice IDRequired
Amount
Payment ModeRequired
Description
Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
VAT Treatment
Display NameRequired
First Name
Last Name
EmailRequired
Company Name
Website
Payment Terms
Mobile
Work Phone
Currency Code
Billing Address Street
Billing Address City
Billing Address State
Billing Address Country
Billing Address ZIP
Billing Address Fax
Shipping Address Street
Shipping Address City
Shipping Address State
Shipping Address Country
Shipping Address ZIP
Shipping Address Fax
Notes
Custom Fields
Enable Portal
Bank Account Payment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Customer NameRequired
Customer Email
Invoice Number
Invoice Date
Due Date
Order Number
Payment Terms
Line Item NameRequired
Line Item RateRequired
Line Item QuantityRequired
Line Item Description
Line Item Discount
Tax Rate
Exchange Rate
Discount
Discount Before Tax
Discount Type
Notes
Terms
Allow Partial Payments
Shipping Charge
Adjustments
Adjustment Description
Salesperson Name
Tax Inclusive
Place Of Supply
Paypal Payment Method
Send Invoice Only to Primary Contact
Payment Gateways
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Plan CodeRequired
Plan Quantity
Addons
Coupon Code
Starts At
Customer
Email
Display Name
First Name
Last Name
Company Name
Website
Mobile
Work Phone
Currency Code
Customer Payment Terms
Enable Portal
Billing Address Street
Billing Address City
Billing Address State
Billing Address ZIP
Billing Address Country
Billing Address Fax
Shipping Address Street
Shipping Address City
Shipping Address State
Shipping Address ZIP
Shipping Address Country
Shipping Address Fax
Place Of Supply
Contact Persons
Customer Custom Fields
Exchange Rate
Customer Notes
Reference
Sales Person Name
Subscription Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Customer IDRequired
Display Name
First Name
Last Name
Email
Company Name
Website
Payment Terms
Mobile
Work Phone
Currency Code
Billing Address Street
Billing Address City
Billing Address State
Billing Address Country
Billing Address Zip
Billing Address Fax
Shipping Address Street
Shipping Address City
Shipping Address State
Shipping Address Country
Shipping Address Zip
Shipping Address Fax
Notes
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Invoice#Required
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 found
About Google Sheets
Related categories
About Zoho Billing
Related categories
Related Zap Templates
- Update Zoho Billing customers from a Google Sheet
- Add new Zoho Billing invoices to Google Sheets as rows
- Pause Zoho Billing subscriptions and create corresponding rows in Google Sheets
- Track Zoho Billing payment failures by creating a row in Google Sheets
- Log new Zoho Billing payment successes to Google Sheets by creating rows